public async Task <GetPagedList> GetPagedListAsync(GetPagedListRequest src)
{
var dt = _userDal.GetPagedList(src);
var data = await dt.Skip((src.page - 1) *src.rowCount).Take(src.rowCount).ToListAsync();
var count = await dt.CountAsync();
return(new GetPagedList {
items = data, itemCount = count
});
}
public async Task <IActionResult> GetPagedListAsync([FromQuery] GetPagedListRequest src)
{
var dt = await _userService.GetPagedListAsync(src);
if (dt == null)
{
return(Ok(new ReturnNotFound()));
}
return(Ok(new ReturnList <IList <UserAll> > {
Data = new DataList <IList <UserAll> > {
itemCount = dt.itemCount, items = dt.items, page = src.page, rowCount = src.rowCount, sort = src.sort
}
}));
}
public dynamic SortBy(GetPagedListRequest src, IQueryable <UserAll> dt)
{
switch (src.sort)
{
case "firstName" when src.sortDirection == SortDirection.desc.ToString():
dt = dt.OrderByDescending(x => x.firstName);
break;
case "firstName" when src.sortDirection == SortDirection.asc.ToString():
dt = dt.OrderBy(x => x.firstName);
break;
case "lastName" when src.sortDirection == SortDirection.desc.ToString():
dt = dt.OrderByDescending(x => x.lastName);
break;
case "lastName" when src.sortDirection == SortDirection.asc.ToString():
dt = dt.OrderBy(x => x.lastName);
break;
}
return(dt);
}
public IQueryable <UserAll> GetPagedList(GetPagedListRequest src)
{
var dt = FindBy(x => ((src.lastName == null) || x.LastName == src.lastName)).ProjectTo <UserAll>(_mapper.ConfigurationProvider);
return(SortBy(src, dt));
}
