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>