public ActionResult LoadRoleName(DtParams dt)
{
bool isEmpty = string.IsNullOrWhiteSpace(dt.search.value);
var query = (from a in CoreContext.AT_Roles where (isEmpty || a.Name.Contains(dt.search.value)) select a);
return(DataTable(dt, query));
}
public ActionResult LoadCompany(DtParams dt)
{
bool isEmpty = string.IsNullOrWhiteSpace(dt.search.value);
var query = (from a in CoreContext.CompanyMaster
where (isEmpty || a.CompanyName.Contains(dt.search.value) || a.CompanyCode.Contains(dt.search.value) ||
a.OfficialMail.Contains(dt.search.value))
select a);
return(DataTable(dt, query));
}
public ActionResult LoadData(DtParams dt)
{
bool isEmpty = string.IsNullOrWhiteSpace(dt.search.value);
var query = (from a in CoreContext.TblRegister
where (isEmpty || a.Name.Contains(dt.search.value) || a.Email.Contains(dt.search.value) ||
a.Mobile.Contains(dt.search.value))
select a);
return(DataTable(dt, query));
}
protected ActionResult DataTable(DtParams dt, IEnumerable <dynamic> query)
{
var count = (from a in query select a).Count();
Response response = new Response()
{
draw = dt.draw,
recordsTotal = count
};
query = dt.Order(query);
query = dt.Filter(query);
var filterCount = query.Count();
var data = dt.Take(query).ToList();
response.data = data;
response.recordsFiltered = filterCount;
return(Json(response, JsonRequestBehavior.AllowGet));
}
