public async Task <ActionResult> GetSuppliers() { var useID = Session["useDetails"] as Users; var id = useID.useCompanyID; var draw = Request.Form.GetValues("draw").FirstOrDefault(); var start = Request.Form.GetValues("start").FirstOrDefault(); var length = Request.Form.GetValues("length").FirstOrDefault(); var sortCulmn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault(); var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault(); int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int totalRecords = 0; var Name = Request.Form.GetValues("columns[1][search][value]").FirstOrDefault(); List <SupplierModel> sup = new List <SupplierModel>(); sup = await supVM.Get(id); if (!string.IsNullOrEmpty(Name)) { sup = sup.Where(a => a.supName.ToLower().Contains(Name.ToLower())).ToList(); } if (!(string.IsNullOrEmpty(sortCulmn + "" + sortColumnDir))) { sup = sup.OrderBy(sortCulmn + " " + sortColumnDir).ToList(); } totalRecords = sup.Count(); var data = sup.Skip(skip).Take(pageSize).ToList(); return(Json(new { draw, recordsFiltered = totalRecords, recordsTotal = totalRecords, data }, JsonRequestBehavior.AllowGet)); }