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)); }