// Nepaginat
public IEnumerable <HotelGetModel> GetHotels()
{
IQueryable <Hotel> result = context.Hotels
.Include(h => h.Reviews);
return(result.Select(h => HotelGetModel.GetHotelModel(h, context)));
}
public IQueryable <HotelGetModel> FilterByCity(string city) //, PagingParameters pagingParameters)
{
IQueryable <Hotel> hotels = context.Hotels
.OrderBy(h => h.Id)
.Include(h => h.Reviews)
.Where(h => (h.City.ToLower() == city))
.OrderByDescending(h => h.Rating);
return(hotels.Select(h => HotelGetModel.GetHotelModel(h, context))); //, pagingParameters.PageNumber, pagingParameters.PageSize);
}
public PaginatedList <HotelGetModel> GetHotelsPaginated(PagingParameters pagingParameters)
{
var result = context.Hotels
.OrderBy(h => h.Id)
.Select(h => HotelGetModel.GetHotelModel(h, context));
var resultList = result
.Skip(pagingParameters.PageNumber * pagingParameters.PageSize)
.Take(pagingParameters.PageSize)
.ToList();
var totalItems = resultList.Count();
var paginatedList = new PaginatedList <HotelGetModel>(totalItems, pagingParameters.PageNumber, pagingParameters.PageSize);
paginatedList.Items.AddRange(resultList);
return(paginatedList);
}
