public JsonResult GetCompanyManager(string sidx, string sort, int page, int rows) { sort = (sort == null) ? "" : sort; int pageIndex = Convert.ToInt32(page) - 1; int pageSize = rows; AdminUsers obj = new AdminUsers(); var CompaniesList = obj.GetCompanyManager(); int totalRecords = CompaniesList.Count(); var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); if (sort.ToUpper() == "DESC") { CompaniesList = CompaniesList.OrderByDescending(t => t.ServiceFirstCompanyManagerID).ToList(); CompaniesList = CompaniesList.Skip(pageIndex * pageSize).Take(pageSize).ToList(); } else { CompaniesList = CompaniesList.OrderBy(t => t.ServiceFirstCompanyManagerID).ToList(); CompaniesList = CompaniesList.Skip(pageIndex * pageSize).Take(pageSize).ToList(); } var jsonData = new { total = totalPages, page, records = totalRecords, rows = CompaniesList }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }