public JsonResult Fetchlabels(int iDisplayStart = 0, int iDisplayLength = 0, int sEcho = 1, string sSearch = null, int iSortCol_0 = 0, string sSortDir_0 = "asc")
{
int adminId = Convert.ToInt16(Session["AdminId"]);
TableDate <tbllabel> tableDate = new TableDate <tbllabel>();
List <string[]> list = new List <string[]>();
int recordsTotal = 0;
Global _global = new Database.Global();
using (CRMClassDataContext dataClasses1DataContext = new CRMClassDataContext(_global.con))
{
List <tbllabel> list2 = (from a in dataClasses1DataContext.tbllabels.Where(a => a.AdminId == adminId && a.Isactive == true)
select a).ToList <tbllabel>();
recordsTotal = list2.Count <tbllabel>();
if (!string.IsNullOrEmpty(sSearch))
{
list2 = list2.Where(a => a.LableName.Contains(sSearch) || a.Description.Contains(sSearch)).ToList <tbllabel>();
}
string sortby = "mDataProp_" + iSortCol_0;
sortby = Request.QueryString[sortby].ToString();
list2 = SortList <tbllabel>(list2, sSortDir_0, sortby).Skip(iDisplayStart).Take(iDisplayLength).ToList();
tableDate.sEcho = sEcho;
tableDate.aaData = list2;
tableDate.iTotalRecords = list2.Count <tbllabel>();
tableDate.iTotalDisplayRecords = recordsTotal;
}
return(base.Json(tableDate, JsonRequestBehavior.AllowGet));
}
public JsonResult Fetchusers(int iDisplayStart = 0, int iDisplayLength = 0, int sEcho = 1, string sSearch = null, int iSortCol_0 = 0, string sSortDir_0 = "asc")
{
int adminId = 1;
TableDate <tbllogin> tableDate = new TableDate <tbllogin>();
List <string[]> list = new List <string[]>();
int recordsTotal = 0;
Global _global = new Database.Global();
using (CRMClassDataContext dataClasses1DataContext = new CRMClassDataContext(_global.con))
{
List <tbllogin> list2 = (from a in dataClasses1DataContext.tbllogins.Where(a => a.IsActive == "Y")
select a).ToList <tbllogin>();
recordsTotal = list2.Count <tbllogin>();
if (!string.IsNullOrEmpty(sSearch))
{
list2 = list2.Where(a => a.FirstName.Contains(sSearch) || a.Email.Contains(sSearch) || a.PhoneNumber.Contains(sSearch)).ToList <tbllogin>();
}
string sortby = "mDataProp_" + iSortCol_0;
sortby = Request.QueryString[sortby].ToString();
list2 = SortList <tbllogin>(list2, sSortDir_0, sortby).Skip(iDisplayStart).Take(iDisplayLength).ToList();
tableDate.sEcho = sEcho;
tableDate.aaData = list2;
tableDate.iTotalRecords = list2.Count <tbllogin>();
tableDate.iTotalDisplayRecords = recordsTotal;
}
return(base.Json(tableDate, JsonRequestBehavior.AllowGet));
}
