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