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)); }