Asp.Net, Mvc, C#, Vb.Net, DataBase, JavaScript, Jquery

Thursday, 8 February 2018

public List<SelectListItem> AvailableTemplateName { get; set; }

@Html.DropDownList("TemplateId", new SelectList(Model.AvailableTemplateName, "Value", "Text"))

var selectListTemp = new List<SelectListItem>();

foreach (var c in Template)
selectListTemp.Add(new SelectListItem()
{
Value = c.TemplateName.ToString(),
Text = c.TemplateName,

});
model.AvailableTemplateName = selectListTemp;

public override List<SelectListItem> BindVehicleTransmision()
{
List<SelectListItem> list = new List<SelectListItem>();
SqlCommand command = new SqlCommand("TransmisionConCombo", con);
command.CommandType = CommandType.StoredProcedure;
con.Open();
List<SelectListItem> state = new List<SelectListItem>();
SqlDataAdapter da = new SqlDataAdapter(command);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
//dr1[0].ToString(), Text = dr1[0].ToString()
list.Add(new SelectListItem { Text = dr[0].ToString(), Value = dr[1].ToString() });
}
con.Close();
return list;
}

public List<SelectListItem> TransmisionList { get; set; }

@Html.DropDownListFor(m => m.Transmission, new SelectList(Model.TransmisionList, "Text", "Value", @Model.Transmission), "Select", new { @class = "form-control", @id = "ddlTransmission", @required = "required" })

Model with Controller

public class CmsModel
{
public List<CmsModel> CmsList { get; set; }
public int Id { get; set; }
public string Name { get; set; }
public string Key { get; set; }
[AllowHtml]
public string Value { get; set; }
public bool IsActive { get; set; }
[AllowHtml]
public string Content { get; set; }
public string CmsImage { get; set; }
public byte[] Image { get; set; }
}

public abstract List<CmsModel> getallcms();

public override List<CmsModel> getallcms()
{
List<CmsModel> model = new List<CmsModel>();
DataTable dt = new DataTable();
try
{
SqlCommand command = new SqlCommand("sp_getallcms", con);
command.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
CmsModel cmsList = new CmsModel();
cmsList.Id = Convert.ToInt32(dr["Id"]);
cmsList.Name = dr["Name"].ToString();
cmsList.Key = dr["Key"].ToString();
cmsList.Value = dr["Value"].ToString();
cmsList.IsActive = Convert.ToBoolean(dr["IsActive"]);
model.Add(cmsList);
}
con.Close();
}
catch (Exception ex)
{
con.Close();
}

return model;
}
=============================================================
public class NewsLettersModel
{
public NewsLettersModel()
{
ManageNewsLetterList = new List<NewsLettersModel>();
ManagePostFeedList = new List<NewsLettersModel>();
GetAssignedRole = new List<RoleAssignmentModel>();
}
public bool HasErrors { get; set; }

public int ID { get; set; }

public string Email { get; set; }
public bool Active { get; set; }
public bool IsWeekly { get; set; }

public bool IsPriceAvailable { get; set; }

public int CategoryID { get; set; }

public int CityID { get; set; }
public int CountryID { get; set; }
public string CityName { get; set; }
public string CategoryName { get; set; }
public string Title { get; set; }

public string Image { get; set; }
public string CreatedDate { get; set; }
public decimal Price { get; set; }
public int AdsType { get; set; }
public int DCount { get; set; }
public List<SelectListItem> AvailableTemplateName { get; set; }

public List<NewsLettersModel> ManageNewsLetterList { get; set; }
public List<NewsLettersModel> ManagePostFeedList { get; set; }
public List<RoleAssignmentModel> GetAssignedRole { get; set; }

var Template = objSettings.SelectAllMailTemplate();
var model = new NewsLettersModel();

var selectListTemp = new List<SelectListItem>();

foreach (var c in Template)
selectListTemp.Add(new SelectListItem()
{
Value = c.TemplateName.ToString(),
Text = c.TemplateName,

});
model.AvailableTemplateName = selectListTemp;
var role = objRole.GetRoleAssignMentByUserIDAndModuleUrl(Convert.ToInt32(Session["RoleId"]), "/Admin/NewsLetters").ToList();
if (role.Count() > 0)
{
foreach (var itm in role)
{
model.GetAssignedRole.Add(new RoleAssignmentModel()
{
Add = itm.Add,
Edit = itm.Edit,
Delete = itm.Delete,
View = itm.View,
IsActive = Convert.ToBoolean(itm.IsActive)
});
}
}

Procedure

ALTER proc [dbo].[sp_Insert_Employee]
(
@Name nvarchar(255),
@Email nvarchar(255),
@Mobile nvarchar(255),
@Address nvarchar(255),
@Salary decimal(18,2),
@IsActive bit
)
as
begin
Declare @Id int
set @Id = 0
insert into Employee (Name, Email, Mobile, Address, Salary,IsActive) values (@Name,@Email,@Mobile,@Address,@Salary,@IsActive)
Set @Id=SCOPE_IDENTITY()
end

ALTER proc [dbo].[sp_Update_Employee]
(
@Id int,
@Name nvarchar(255),
@Email nvarchar(255),
@Mobile nvarchar(255),
@Address nvarchar(255),
@Salary decimal(18,2),
@IsActive bit
)
as
begin
update Employee set Name=@Name, Email=@Email,Mobile=@Mobile,Address=@Address,Salary=@Salary,IsActive=@IsActive WHERE Id=@Id
end

+++++++++++++++++++++++++++++++++++++++++

$(document).ready(
function () {
fTmcStatus()
setInterval(function () {
TmcStatus();
}, 10000);
});

function fTmcStatus() {
$("#divProcess").show();
$.ajax({
url: '/TmcStatus/fTmcStatus',
dataType: "HTML",
type: "GET",
contentType: 'application/json; charset=utf-8',
success: function (data) {
if (data.length > 0) {
$("#dvtmcstatus").html("");
$("#dvtmcstatus").html(data);
}
},
error: function (xhr) {
//alert('error');
}
});
};

=======================================================================

public int? InsertUpdateAdminUser(int ID, string FirstName, string MiddleName, string LastName, string Email, string Password, string ContactNo, string Gender, int? RoleId, bool? IsRegistered, bool? IsActive)
{

int? res = 0;

try
{
var result = Objdb.usp_AdminUser_GetByID(ID).SingleOrDefault();
if (result == null)
{

res = Objdb.usp_AdminUser_Insert(FirstName, LastName, MiddleName, Email, Password, ContactNo, Gender, RoleId, IsRegistered, IsActive).FirstOrDefault();

}
else
{
res = Objdb.usp_AdminUser_Update(ID, FirstName, LastName, MiddleName, Email, Password, ContactNo, Gender, RoleId, IsRegistered, IsActive);

}

}
catch (Exception ex)
{

}
return res;

}

public int DeleteAdminUserByID(int Id)
{

try
{
int retval=Objdb.usp_AdminUser_DeleteById(Id);
return retval;
}
catch (Exception ex)
{
throw ex;
}

}

public int AdminUser_StatusChange(int ID, bool IsActive)
{

try
{
int retval = Objdb.usp_AdminUser_StatusChange(ID, IsActive);
return retval;
}
catch (Exception ex)
{
throw ex;
}

}
public List<usp_AdminUser_GetAll_Result> getAllAdminUserActive()
{
var AdminUsers = Objdb.usp_AdminUser_GetAll().Where(x => x.IsActive == true).ToList();
return AdminUsers;
}

================================================================

var role = objRole.GetRoleAssignMentByUserIDAndModuleUrl(Convert.ToInt32(Session["RoleId"]), "/Admin/AdminUser").ToList();
if (role.Count() > 0)
{
foreach (var itm in role)
{
model.GetAssignedRole.Add(new RoleAssignmentModel()
{
Add = itm.Add,
Edit = itm.Edit,
Delete = itm.Delete,
View = itm.View,
IsActive = Convert.ToBoolean(itm.IsActive)
});
}
}

=====================================================================

function fillStateCity() {
var zipcode = $('#zipcode').val();
$.ajax({
url: '/AdminUser/GetSateCityList/',
type: 'GET',
data: {
zipcode: zipcode,
},
success: function (data) {
if (data.StateList.length > 0) {
var html_content = "";
$("#ddlState").html("");
for (i = 0; i < data.StateList.length; i++) {
html_content += '<option value="' + data.StateList[i].Value + '">' + data.StateList[i].Text + '</option>';
break;
}
$('#ddlState').html(html_content);

var html_content = "";
$("#ddlCity").html("");
html_content += '<option value="">Select</option>';
for (i = 0; i < data.CityList.length; i++) {
html_content += '<option value="' + data.CityList[i].Text + '">' + data.CityList[i].Text + '</option>';
}
$('#ddlCity').html(html_content);
}
else {

$("#ddlState").html("");
var html_content = '<option value="">Select</option>';
html_content += '</select>';
$('#ddlState').html(html_content);

$("#ddlCity").html("");
var html_content = '<option value="">Select</option>';
html_content += '</select>';
$('#ddlCity').html(html_content);
}
},
});
}

Monday, 22 May 2017

How to clock to show in a div by java script?

Sunday, 29 January 2017

How to enum class create and call enum data in controller?

Firstly we create a class enum.cs -:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ProjectName.Entity
{
public class ProjectEnum
{
public enum Status : int
{
Created = 1,
CheckedOut = 2,
CheckedIn = 3,
Published = 4,
Deleted = 5
}

public enum SourceType : int
{
SBI = 1,
Axis = 2,
ICICI = 3,
}
}
}

int type = Convert.ToInt32(ProjectName.SourceType.SBI );

How to age calculate from date in asp.net?

private static TimeZoneInfo INDIAN_ZONE = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
public static string GetCalcaulateAge(DateTime date)
{
string _age = "";
int age = 0;
int month = 0;
int days = 0;
int dobYear = Convert.ToInt32(date.Year);
int dobMonth = Convert.ToInt32(date.Month);
int dobDay = Convert.ToInt32(date.Day);
age = Convert.ToInt32(TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE).Year) - dobYear;
month = Convert.ToInt32(TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE).Month) - dobMonth;
days = Convert.ToInt32(TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE).Day) - dobDay;

if (days < 0)
{
days = Math.Abs(days);
}

if (month < 0)
{
month = Math.Abs(month);
}
if (age == 0)
{
if (month == 0)
{
_age = Convert.ToString(days) + " days";
}
else
{
if (days == 0)
{
_age = Convert.ToString(month) + " months";
}
else
{
_age = Convert.ToString(month) + " months " + days + " days";
}
}
}
else
{
if (age <= 12)
{
if (days == 0)
{
_age = Convert.ToString(age) + " yrs " + Convert.ToString(month) + " months";
}
else if (month == 0)
{
_age = Convert.ToString(age) + " yrs " + days + " days";
}
else
{
_age = Convert.ToString(age) + " yrs " + Convert.ToString(month) + " months " + days + " days";
}
}
else
{
_age = Convert.ToString(age) + " yrs";
}
}
return _age;
}

Saturday, 28 January 2017

How to autocomplete text box by ajax with filtering in mvc?



<link rel="stylesheet"href="//code.jquery.com/ui/1.12.1/themes/base/jqueryui.css">
<link rel="stylesheet" href="/resources/demos/style.css">
<script src="https://code.jquery.com/jquery-1.12.4.js"></script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>

Sunday, 25 September 2016

How to create multilingual application in C# ?

Firstly defined In global.asax.cs

protected void Application_BeginRequest()
{
CultureInfo info = new CultureInfo(System.Threading.Thread.CurrentThread.CurrentCulture.ToString());
info.DateTimeFormat.ShortDatePattern = "dd.MM.yyyy";
System.Threading.Thread.CurrentThread.CurrentCulture = info;
}

protected void Application_BeginRequest(object sender, EventArgs e)
{
HttpCookie cookie = HttpContext.Current.Request.Cookies["lang"];
if (cookie != null && cookie.Value != null)
{
System.Threading.Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo(cookie.Value);
}
else
{
System.Threading.Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo("en");
}
}

In App_Global_ResourceFile folder

To create a resource file in this folder -:
default.
employee.resx (It's automatic in English language we represent string and value)

Emp Employee

employee.bn.resx (bn means bengali language we represent string and value)

Emp Employee_bn

We represent View Pages

In LayOut Pages defined-

<script type="text/javascript">
function SetLanguage(obj) {
debugger;
$.ajax({
cache: false,
type: "GET",
url: '/Home/SetCulture/?lang=' + obj,
success: function (result) {
debugger;
window.location.reload();

},
error: function (result) {
alert("Error");
}
});
}

</script>

public ActionResult SetCulture(string lang)
{
LanguageModel model = new LanguageModel();
if (!String.IsNullOrEmpty(lang))
{
string culture = lang;
CultureInfo ci = CultureInfo.GetCultureInfo(culture);
Thread.CurrentThread.CurrentUICulture = ci;
model.Culture = lang;
Response.Cookies["lang"].Value = culture;
Response.Cookies["lang"].Expires = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE).AddDays(30);
}
else
{
string culture = "en";
CultureInfo ci = CultureInfo.GetCultureInfo(culture);
Thread.CurrentThread.CurrentUICulture = ci;
model.Culture = culture;
Response.Cookies["lang"].Value = culture;
}
return Json(model, JsonRequestBehavior.AllowGet);

}

<label>App_GlobalResources.employee.Emp</label>

Sunday, 10 July 2016

How to implementing jquery datepicker in bootstrap modal?

<button class="btn btn-primary btn-lg" data-toggle="modal" data-target="#myModal">Launch demo modal</button>

<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title" id="myModalLabel">Modal title</h4>

</div>
<div class="modal-body">
<div class="col-md-12">
<div class="row">
<label for="idTourDateDetails">Tour Start Date:</label>
<div class="form-group">
<div class="input-group">
<input type="text" name="idTourDateDetails" id="idTourDateDetails" readonly="readonly" class="form-control clsDatePicker"> <span class="input-group-addon"><i id="calIconTourDateDetails" class="glyphicon glyphicon-th"></i></span>

</div>
</div>Alt Field:
<input type="text" name="idTourDateDetailsHidden" id="idTourDateDetailsHidden">
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>

</div>

</div>


$('#idTourDateDetails').datepicker({
dateFormat: 'dd-mm-yy',
minDate: '+5d',
changeMonth: true,
changeYear: true,
altField: "#idTourDateDetailsHidden",
altFormat: "yy-mm-dd"
});

// Since confModal is essentially a nested modal it's enforceFocus method
// must be no-op'd or the following error results
// "Uncaught RangeError: Maximum call stack size exceeded"
// But then when the nested modal is hidden we reset modal.enforceFocus
var enforceModalFocusFn = $.fn.modal.Constructor.prototype.enforceFocus;

$.fn.modal.Constructor.prototype.enforceFocus = function() {};

$confModal.on('hidden', function() {
$.fn.modal.Constructor.prototype.enforceFo

Wednesday, 22 June 2016

How to multiple select list value in mvc without ctrl key?

Multiple select list value in asp.net

Multiple select list value in java script

<link href="@Url.Content("~/Content/MultiCheckbx/css/bootstrap-3.1.1.min.css")" rel="stylesheet" />
<link href="@Url.Content("~/Content/MultiCheckbx/css/bootstrap-multiselect.css")" rel="stylesheet" />
<script src="@Url.Content("~/Content/MultiCheckbx/js/bootstrap-multiselect.js")"></script>

<script type="text/javascript">
$(document).ready(function () {

$('#ddlLanguage').multiselect({
includeSelectAllOption: true,
numberDisplayed: 1,
});

function Validation() {
//var language = ListboxChek();
debugger;
var languageids = '';
$('#dvlanguage input[type="checkbox"]:checked').each(function (i, el) {
languageids += el.value + ',';
document.getElementById("hdnLanguage").value = languageids;
var abc = document.getElementById("hdnLanguage").value;
});
var abcd = document.getElementById("hdnLanguage").value;
</script>

When Insert into a table
@Html.HiddenFor(m => m.hdnLanguage)
<div id="dvlanguage">
<select id="ddlLanguage" class="form-control" multiple="multiple">
@if (Model._listLanguage.Count() > 0)
{
foreach (var item in Model._listLanguage)
{
<option value="@item.LanguageId"> @item.Name </option>
}
}
</select>
</div>

<button type="submit" class="btn" onclick="javascript:return Validation();">Submit</button>

When Edit after that update
@Html.HiddenFor(m => m.hdnLanguage)
<div id="dvlanguage">
<select id="ddlLanguage" class="form-control" multiple="multiple">
@if (Model._listLanguage.Count() > 0)
{
foreach (var item in Model._listLanguage)
{
<option value="@item.LanguageId"
@if (Model.hdnLanguage != null && (Model.hdnLanguage.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries).Any(p => (item.LanguageId.ToString().Trim().ToLower() == p.ToString().Trim().ToLower()))))
{ <text> selected="selected" </text> }>
@item.Name
</option>
}
}
</select>

</div>
<button type="submit" class="btn" onclick="javascript:return Validation();">Submit</button>

How to multiple select list value in mvc without ctrl key?

Tuesday, 21 June 2016

How to a file and text value in javascript and sent data in mvc?

<form enctype="multipart/form-data">
<div class="col-sm-5">
<div class="form-group">
<label>Weekend Date:<span id="errorWeekendDate">*</span></label>
@Html.TextBoxFor(model => model.WeekendDate, new { @Placeholder = "Weekend Date", @required = "required", @style = "height: 35px;border: 1px solid #ccc;border-radius: 4px;" })
<div class="clearfix"></div>
</div>
</div>
<div class="col-sm-7">
<a class="file-input-wrapper btn btn-default" style="margin-bottom: 15px;">
<input type="file" name="file" id="fileInput" data-filename-placement="inside">
</a>
<input type="submit" value="Upload file" style="position: relative;top: -5px;" />
</div>
<br />
</form>
<div class="clearfix"></div>
<div id="dvmismatch" style="display :none;">
@Html.Partial("_MismatchVendorList", Model)
</div>

<script type="text/javascript">
$(function () {
// When your form is submitted
$("form").submit(function (e) {
debugger;
var errorWeekendDate = document.getElementById('errorWeekendDate');
var WeekendDate = document.getElementById('WeekendDate');

if (WeekendDate.value == '') {
errorWeekendDate.style.color = "red";
return false;
}
else {
errorWeekendDate.style.color = "";
}
e.preventDefault();
// Serialize your form
var formData = new FormData($(this)[0]);
loader();

// Make your POST
$.ajax({
type: 'POST',
url: '@Url.Action("FileCsv", "InvoiceProcessing")',
data: formData,
cache: false,
contentType: false,
processData: false,
success: function (result) {
debugger;
$("#popup_ok").click();
document.getElementById('dvmismatch').style.display = 'block';
$("#dvmismatch").html(result);
},
error: function (result) { alert(''); }

});
});
})

function loader() {
debugger;
jAlert('<img src="@Url.Content("~/Content/images/ajax-loader-large.gif")" height="60" width="60" />', 'Please wait');
$("#popup_ok").hide();
}
</script>

[HttpPost]
public ActionResult FileCsv(HttpPostedFileBase file, string WeekendDate)
{
try
{
int result = 0;
string List = string.Empty;
DataSet ds = new DataSet();
if (Request.Files["file"].ContentLength > 0)
{
string fileExtension =
System.IO.Path.GetExtension(Request.Files["file"].FileName);

string ImportCSVFile = Request.Files["file"].FileName;
string FileName = Request.Files["file"].FileName;
string[] strFileName = FileName.Split('.');
FileName = strFileName[0];

string fileLocation = Server.MapPath("~/Content/CSVFile/") + Request.Files["file"].FileName;
if (System.IO.File.Exists(fileLocation))
{
System.IO.File.Delete(fileLocation);
}
Request.Files["file"].SaveAs(fileLocation);

DataTable dt = new DataTable();

string fileName1 = Request.Files["file"].FileName;
string path = Path.Combine(Server.MapPath("~/Content/CSVFile/"), fileLocation);

return PartialView("_MismatchVendorList", model);
}
catch (Exception ex)
{
throw ex;
}
}

Sunday, 19 June 2016

How to bind a partial view in a div?

<div id="dvMappingList" style="display:none;"> </div>

public ActionResult ServicetoServiceMapping()
{
AModel model = new AModel();
try
{

return PartialView("_ServiceMapping", model);
}
catch (Exception ex)
{
throw ex;
}

}

function bindServicetoService(serviceId, IsServiceId) {
debugger;
$('#dvMappingList').html('');
loader();
$.ajax({
cache: false,
type: "GET",
url: '@Url.Action("ServicetoServiceMapping", "Component")',
data: { serviceId: serviceId, IsServiceId: IsServiceId },
success: function (result) {
debugger;
$("#dvMappingList").html(result);
$('.tabclass li').removeClass("active");
$('#litab3').addClass("active");
$('.tab-content div').removeClass("in active");
$('#tab3').addClass("in active");
//document.getElementById("litab3").style.display = "block";
document.getElementById("dvMappingList").style.display = "block";
$("#popup_ok").click();
},
}
)
};

And after that top to message display and reload the page-:

In Partial view page-

<div id="prefix_108058000000" class="Metronic-alerts alert alert-success fade in" style="display: none;">
<a type="button" class="close" data-dismiss="alert" aria-hidden="true"></a>
<span id="spnmessage1"></span>
</div>
<div id="prefix_Error" class="Metronic-alerts alert alert-danger fade in" style="display: none;">
<a type="button" class="close" data-dismiss="alert" aria-hidden="true"></a>
<span id="spnmessage2"></span>
</div>

In Main Page

<div class="page-content" id="dvSubComponat">

In a div tab and partial pages...........

<ul class="nav nav-tabs tabclass">
<li class="active" id="litab1"><a data-toggle="tab" href="#tab1">A Mapping</a></li>
<li id="litab2" style="display:none;"><a data-toggle="tab" href="#tab2">Add Edit Employee</a></li>
<li id="litab3" style="display:none;"><a data-toggle="tab" href="#tab3">DepartmentMapping Mapping</a></li>
<li id="litab4" style="display:none;"><a data-toggle="tab" href="#tab4">Add Edit Deaprtment Mapping</a></li>
</ul>

<div class="form-body">
<div id="tab1" class="tab-pane fade in active">
<div id="dvEmployee">
@Html.HiddenFor(a => a.EmpID)
<div class="form-group" style="margin-left:-217px;">
<label class="control-label col-md-3">
Search EmployeeID :
</label>
<div class="col-md-4">
@Html.TextBoxFor(m => m.SerTextID, new { @class = "form-control", @onkeypress = "return PopulateEmployeeID();" })
</div>
</div>
<div id="dvserAllList">
@Html.Partial("_EmployeeAllListPartial", Model)
</div>
</div>

<div id="dvmaplist" style="display:none;">
@Html.Partial("_ComponentMappingPartial", Model)
</div>

<div id="dvunmaplist" style="display:none;">
@Html.Partial("_ComponentUnMappingPartial", Model)
</div>

</div>
</div>

<div id="tab2" class="tab-pane fade">
@Html.Action("AddEditEmployee", "Component", new { ID = 0 })
</div>
</div>

function SuccessSubComponent(data) {
$("#popup_ok").click();
if (data != null) {
debugger;
if (data.indexOf("exist") != -1) {
$('#prefix_Error').show();
$('#prefix_Error').removeClass("fade");
$("#spnmessage2").html(data);
$("#spnmessage2").focus();
$('html,body').animate({
scrollTop: $("#dvSubComponat").offset().top
},
'slow');
setTimeout("loadSubComponentReload()", 1000);
}
else {
debugger;
$('#prefix_108058000000').show();
$('#prefix_108058000000').removeClass("fade");
$("#spnmessage1").html(data);
$("#spnmessage1").focus();
$('html,body').animate({
scrollTop: $("#dvSubComponat").offset().top
},
'slow');
setTimeout("loadComponentMapReload()", 1000);
}
}
}

function loadComponentMapReload() {
window.location.href = "@Url.Action("ComponentMapping", "Component")";
}

Wednesday, 15 June 2016

How to display some character in mvc?

@(model.ShortDescription.Length > 130 ? model.ShortDescription.Substring(0, 131)+"..." : model.ShortDescription)

Wednesday, 1 June 2016

How to multiple parameter pass in window.location in mvc?

window.location.href = "/Controller/Action?id=" + historyId + "&check=" + itemfilter;

How to split the string in asp.net?

if (!string.IsNullOrWhiteSpace(tempitemnoList))
{
string[] tempNumber = tempitemnoList.Split(new string[] { "/" }, StringSplitOptions.None);
if (tempNumber.Count() > 0)
{
for (int i = 0; i < tempNumber.Count(); i++)
{
if (tempNumber[i] != "")
{
string[] temp = tempNumber[i].Split(new string[] { "," }, StringSplitOptions.None);
if (temp.Count() > 0)
{
if (temp[0] != "")
{
string VendorItemNo = temp[0];
VendorItem item = new VendorItem();
var data = objdb.GetInvoiceImportPriceById(Convert.ToInt32(temp[0])).FirstOrDefault();
if (data != null)
{
}
}
}
}
}
}
}
return Json(new { success = true }, JsonRequestBehavior.AllowGet);

Monday, 23 May 2016

How to more than one list value to add another list value in MVC?

*************Employee Model*******************
public classEmployeeModel
{
public EmployeeModel()
{
  EmployeeList = new List<EmployeeModel>();
StudentList = new List<EmployeeModel>();

ServiceList = new List<SelectListItem>();
ParentList = new List<SelectListItem>();
GenderList= new List<SelectListItem>
{
new SelectListItem() {Text = "--Select--", Value ="0" },
new SelectListItem() {Text = "Male", Value ="1" },
new SelectListItem() {Text = "Female", Value ="2"},
};
}
public int ID { get; set; }
public string Name{ get; set; }
public string Address{ get; set; }
public int Age{ get; set; }
public string Mobile{ get; set; }

public List<EmployeeModel> EmployeeList { get; set; }
public List<EmployeeModel> StudentList { get; set; }
public IEnumerable<Employee> SerList { get; set; }

public decimal? ServiceUsage { get; set; }
public decimal? ServiceCost_Per_Annum { get; set; }
public decimal? ServiceCost_for_Service { get; set; }

public List<SelectListItem> GenderList{ get; set; }

}

************************End Employee Model**************************
var empList = _apiService.GetAllEmployee().ToList();
model.EmployeeList = stcList.Select(x =>
{
return new EmployeeModel()
{
ID = x.ID == null ? 0 : x.ID.Value,
Name = string.IsNullOrEmpty(x.Name) ? "" : x.Name,
Address= string.IsNullOrEmpty(x.Address) ? "" : x.Address,
  Mobile= string.IsNullOrEmpty(x.Mobile) ? "" : x.Mobile,
Age= x.Age == null ? Convert.ToInt32(0) : x.Age,
};
}).ToList();

var stuList = _apiService.GetAllStudent().ToList();
model.StudentList = stuList .Select(x =>
{
return new ComponentModel()
{
ID = x.ID == null ? 0 : x.ID.Value,
Name = string.IsNullOrEmpty(x.Name) ? "" : x.Name,
Address= string.IsNullOrEmpty(x.Address) ? "" : x.Address,
  Mobile= string.IsNullOrEmpty(x.Mobile) ? "" : x.Mobile,
Age= x.Age == null ? Convert.ToInt32(0) : x.Age,
};
}).ToList();

var AddExData = new List<EmployeeModel>();

AddExData.AddRange(model.EmployeeList);
AddExData.AddRange(model.StudentList);

Sunday, 1 May 2016

How to windows authentication in mvc?

Firstly, in web.config to configure-:

<system.web>
<authentication mode="Windows"></authentication>
<authorization>
<deny users="?" />
</authorization>
</system.web>

After that Project property (F4 Click)

Windows Authentication Diable and Autonymous Authentication Enabled.

After that it works.
string domainUser = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
string IsAuthentication = System.Web.HttpContext.Current.Request.IsAuthenticated.ToString();
string[] paramsLogin = domainUser.Split('\\');
string UserName = paramsLogin[1].ToString();

How to log out windows authentication in mvc?

public ActionResult LogOut()
{
    HttpCookie cookie = Request.Cookies["TSWA-Last-User"];

    if(User.Identity.IsAuthenticated == false || cookie == null || StringComparer.OrdinalIgnoreCase.Equals(User.Identity.Name, cookie.Value))
    {
        string name = string.Empty;

        if(Request.IsAuthenticated)
        {
            name = User.Identity.Name;
        }

        cookie = new HttpCookie("TSWA-Last-User", name);
        Response.Cookies.Set(cookie);

        Response.AppendHeader("Connection", "close");
        Response.StatusCode = 401; // Unauthorized;
        Response.Clear();
        //should probably do a redirect here to the unauthorized/failed login page
        //if you know how to do this, please tap it on the comments below
        Response.Write("Unauthorized. Reload the page to try again...");
        Response.End();

        return RedirectToAction("Index");
    }

    cookie = new HttpCookie("TSWA-Last-User", string.Empty)
    {
        Expires = DateTime.Now.AddYears(-5)
    };

    Response.Cookies.Set(cookie);

    return RedirectToAction("Index");

}

Wednesday, 27 April 2016

How to randomly data fetch from a table in sql?

select * from tableName order by NEWID()