public IActionResult LoadData()
{
List <DataTableUserView> data = new List <DataTableUserView>();
try
{
var draw = HttpContext.Request.Form["draw"].FirstOrDefault();
// Skip number of Rows count
var start = Request.Form["start"].FirstOrDefault();
// Paging Length 10,20
var length = Request.Form["length"].FirstOrDefault();
// Sort Column Name
var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"].FirstOrDefault();
sortColumn = string.IsNullOrWhiteSpace(sortColumn) ? "RegistrationNumber" : sortColumn;
// Sort Column Direction (asc, desc)
var sortColumnDirection = Request.Form["order[0][dir]"].FirstOrDefault();
// Search Value from (Search box)
var searchValue = Request.Form["search[value]"].FirstOrDefault();
//Paging Size (10, 20, 50,100)
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
UserPaginationModel paginationModel = new UserPaginationModel
{
SortColumn = sortColumn, //"RegistrationNumber"
SortColumnDirection = sortColumnDirection, // "asc"
SearchValue = searchValue, //""
PageSize = pageSize, //10
Skip = skip //0
};
// getting all Customer data
data = _userService.GetUsers(paginationModel, out int recordsTotal);
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
}
catch (Exception)
{
UserPaginationModel paginationModel = new UserPaginationModel
{
SortColumn = "RegistrationNumber",
SortColumnDirection = "asc",
SearchValue = "",
PageSize = 10,
Skip = 0
};
data = _userService.GetUsers(paginationModel, out int recordsTotal);
return(Json(new { draw = "1", recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
}
}
public JsonResult _GridTest(UserPaginationModel userModel)
{
if (userModel.ID == 0)
{
userModel.ID = 1;
}
var dto1 = userDbContext.getTenUser(userModel.ID);
userModel = pageMapper.Map <UserPaginationDTO, UserPaginationModel>(dto1);
return(Json(userModel, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> UserPaginationList(int page = 1)
{
int pageSize = 3; // количество элементов на странице
IQueryable <User> source = db.Users.Include(x => x.Company);
var count = await source.CountAsync();
var items = await source.Skip((page - 1) *pageSize).Take(pageSize).ToListAsync();
PageViewModel pageViewModel = new PageViewModel(count, page, pageSize);
UserPaginationModel viewModel = new UserPaginationModel
{
PageViewModel = pageViewModel,
Users = items
};
return(View(viewModel));
}
public List <Users> GetUsersRepository(UserPaginationModel paginationModel, out int recordsTotal)
{
var userData = (from tempUsers in _gymManagementContext.Users
select tempUsers);
userData = userData.OrderBy(paginationModel.SortColumn + " " + paginationModel.SortColumnDirection);
//Search
if (!string.IsNullOrEmpty(paginationModel.SearchValue))
{
userData = userData.Where(m => m.Name.StartsWith(paginationModel.SearchValue));
}
//Total Records
recordsTotal = userData.Count();
//Paging
var data = userData.Skip(paginationModel.Skip).Take(paginationModel.PageSize).ToList();
return(data);
}
public List <DataTableUserView> GetUsers(UserPaginationModel paginationModel, out int recordsTotal)
{
var allUsers = _userRepository.GetUsersRepository(paginationModel, out recordsTotal);
return(ViewModelParser.GetDTUserViews(allUsers));
}