public async Task <IActionResult> GetOffices([FromQuery] OfficeParametersDto officeParametersDto) { var officesFromRepo = await _officeRepository.GetOfficesAsync(officeParametersDto); var paginationMetadata = new { totalCount = officesFromRepo.MetaData.TotalCount, pageSize = officesFromRepo.MetaData.PageSize, currentPageSize = officesFromRepo.MetaData.CurrentPageSize, currentStartIndex = officesFromRepo.MetaData.CurrentStartIndex, currentEndIndex = officesFromRepo.MetaData.CurrentEndIndex, pageNumber = officesFromRepo.MetaData.PageNumber, totalPages = officesFromRepo.MetaData.TotalPages, hasPrevious = officesFromRepo.MetaData.HasPrevious, hasNext = officesFromRepo.MetaData.HasNext }; Response.Headers.Add("X-Pagination", JsonSerializer.Serialize(paginationMetadata)); var officesDto = _mapper.Map <IEnumerable <OfficeDto> >(officesFromRepo); var response = new Response <IEnumerable <OfficeDto> >(officesDto); return(Ok(response)); }
public async Task <PagingResponse <OfficeDto> > GetOfficesAsync(OfficeParametersDto officeParameters) { var queryStringParam = new Dictionary <string, string> { ["pageNumber"] = officeParameters.PageNumber.ToString(), ["pageSize"] = officeParameters.PageSize.ToString(), ["sortOrder"] = officeParameters.SortOrder.ToString(), ["filters"] = officeParameters.Filters.ToString() }; using (var httpClient = new HttpClient()) { using (var response = await httpClient.GetAsync(QueryHelpers.AddQueryString(uriOffice.ToString(), queryStringParam))) { if (response.IsSuccessStatusCode) { var content = await response.Content.ReadAsStringAsync(); var pagingResponse = new PagingResponse <OfficeDto> { Items = JsonConvert.DeserializeObject <PageListOffice>(content).Offices, Metadata = JsonConvert.DeserializeObject <MetaData>(response.Headers.GetValues("x-pagination").First()) }; pagingResponse.Filters = officeParameters.Filters; pagingResponse.SortOrder = officeParameters.SortOrder; return(pagingResponse); } return(null); } } }
public async Task <IActionResult> Index(int page = 1, int pageSize = 10, String filters = "", String sortOrder = "") { ViewBag.pageSize = pageSize; ViewBag.filter = filters; ViewData["IdSortParm"] = sortOrder == "Id" ? "-Id" : "Id"; ViewData["NameSortParm"] = sortOrder == "Name" ? "-Name" : "Name"; OfficeParametersDto officeParameters = new OfficeParametersDto() { PageNumber = page, PageSize = pageSize, SortOrder = sortOrder, Filters = filters }; var pagingResponse = await _officeRepo.GetOfficesAsync(officeParameters); return(View(pagingResponse)); }
public async Task <PagedList <Office> > GetOfficesAsync(OfficeParametersDto officeParametersDto) { if (officeParametersDto == null) { throw new ArgumentNullException(nameof(officeParametersDto)); } // TODO: AsNoTracking() should increase performance, but will break the sort tests. need to investigate var collection = _context.Offices as IQueryable <Office>; var sieveModel = new SieveModel { Sorts = officeParametersDto.SortOrder ?? "Id", Filters = officeParametersDto.Filters }; collection = _sieveProcessor.Apply(sieveModel, collection); return(await PagedList <Office> .CreateAsync(collection, officeParametersDto.PageNumber, officeParametersDto.PageSize)); }