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
}