public JsonResult GetUserDetails(string sidx, string sord, int page, int rows) //Gets the todo Lists. { #region MyRegion int pageIndex = Convert.ToInt32(page) - 1; int pageSize = rows; // FinanceToolEntities2 db = new FinanceToolEntities2(); var duResults = db.Usp_GetUserMasterDetails().Select( userdata => new { userdata.UserID, userdata.UserName, userdata.ISActive, userdata.RoleID, userdata.RoleName, userdata.Createdby, userdata.Createddate, userdata.Modifiedby, userdata.ModifiedDate, userdata.password }).ToList(); int totalRecords = duResults.Count(); var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); var customerResults2 = duResults.OrderByDescending(s => s.UserName); var customerResults3 = customerResults2.Skip(pageIndex * pageSize).Take(pageSize); var jsonData = new { total = totalPages, page, records = totalRecords, rows = customerResults3 }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); #endregion }