public PagedList <City> GetCities(CityQueryFilter filters) { filters.PageNumber = filters.PageNumber == 0 ? _paginationOptions.DefaultPageNumber : filters.PageNumber; filters.PageSize = filters.PageSize == 0 ? _paginationOptions.DefaultPageSize : filters.PageSize; var cities = _unitOfWork.CityRepository.GetAll(); if (filters.filter != null) { cities = cities.Where(x => x.name.ToLower().Contains(filters.filter.ToLower())); } if (filters.RegionId != null) { cities = cities.Where(x => x.id_region == filters.RegionId); } if (filters.Name != null) { cities = cities.Where(x => x.name.ToLower().Contains(filters.Name.ToLower())); } if (filters.orderedBy != null && filters.orderedBy.Count() > 0) { foreach (var sortM in filters.orderedBy) { cities = cities.OrderBy(sortM.PairAsSqlExpression); } } var pagedPosts = PagedList <City> .Create(cities, filters.PageNumber, filters.PageSize); return(pagedPosts); }
public IActionResult GetCities([FromBody] CityQueryFilter filters) { var cities = _cityService.GetCities(filters); var citiesDto = _mapper.Map <IEnumerable <CityDto> >(cities); var metadata = new Metadata { TotalCount = cities.TotalCount, PageSize = cities.PageSize, CurrentPage = cities.CurrentPage, TotalPages = cities.TotalPages, HasNextPage = cities.HasNextPage, HasPreviousPage = cities.HasPreviousPage, NextPageUrl = _uriService.GetPostPaginationUri(filters, Url.RouteUrl(nameof(GetCities))).ToString(), PreviousPageUrl = _uriService.GetPostPaginationUri(filters, Url.RouteUrl(nameof(GetCities))).ToString() }; var response = new ApiResponse <IEnumerable <CityDto> >(citiesDto) { Meta = metadata }; Response.Headers.Add("X-Pagination", JsonConvert.SerializeObject(metadata)); return(Ok(response)); }
public Uri GetPostPaginationUri(CityQueryFilter filter, string actionUrl) { string baseUrl = $"{_baseUri}{actionUrl}"; return(new Uri(baseUrl)); }