public async Task <ActionResult <List <BetPlayDTO> > > List(int rouletteId, [FromQuery] PaginateDTO paginateDTO)
{
var queryable = context.Bets.AsQueryable().Where(x => x.RouletteId == rouletteId);
await HttpContext.InsertPaginationParams(queryable, paginateDTO.RowsByPage);
var entities = await queryable.Paginate(paginateDTO).ToListAsync();
return(mapper.Map <List <BetPlayDTO> >(entities));
}
public async Task <ActionResult <List <StoreType> > > Get([FromHeader] PaginateDTO paginateDTO)
{
var queryable = context.StoreTypes.AsQueryable();
await HttpContext.InsertPaginationParameters(queryable, paginateDTO.RecordsPerPage);
var storeTypes = await queryable.OrderBy(x => x.Name).Paginate(paginateDTO).ToListAsync();
return(storeTypes);
}
public async Task <ActionResult <List <RouletteDTO> > > List([FromQuery] PaginateDTO paginateDTO)
{
var queryable = context.Roulettes.AsQueryable();
await HttpContext.InsertPaginationParams(queryable, paginateDTO.RowsByPage);
var entities = await queryable.Paginate(paginateDTO).ToListAsync();
return(mapper.Map <List <RouletteDTO> >(entities));
}
public async Task <ActionResult <IEnumerable <StoreDTO> > > Get([FromHeader] PaginateDTO paginateDTO)
{
var queryable = _context.Stores.AsQueryable();
await HttpContext.InsertPaginationParameters(queryable, paginateDTO.RecordsPerPage);
var store = await queryable.OrderBy(x => x.Name).Paginate(paginateDTO).ToListAsync();
var storeDTO = mapper.Map <List <StoreDTO> >(store);
return(storeDTO);
}
public async Task <ActionResult <List <PlaceDTO> > > Get([FromQuery] PaginateDTO paginateDTO)
{
var queryable = context.Places.AsQueryable();
await HttpContext.InsertPaginationParameters(queryable, paginateDTO.RecordsPerPage);
var place = await queryable.Paginate(paginateDTO).Include(x => x.Province).Include(x => x.Photos).ToListAsync();
var placeDTO = mapper.Map <List <PlaceDTO> >(place);
return(placeDTO);
}
public async Task <IEnumerable <ProvinceDTO> > Get([FromHeader] PaginateDTO paginateDTO)
{
// var queryable = _context.Stores.AsQueryable();
// await HttpContext.InsertPaginationParameters(queryable, paginateDTO.RecordsPerPage);
// var store = await queryable.OrderBy(x => x.Name).Paginate(paginateDTO).ToListAsync();
// var storeDTO = mapper.Map<List<StoreDTO>>(store);
// return storeDTO;
var queryable = context.Provinces.AsQueryable();
await HttpContext.InsertPaginationParameters(queryable, paginateDTO.RecordsPerPage);
var province = await queryable.OrderBy(x => x.Name).Paginate(paginateDTO).Include(x => x.Stores).ToListAsync();
var provinceDTO = mapper.Map <List <ProvinceDTO> >(province);
return(provinceDTO);
}
public static IQueryable <T> Paginate <T>(this IQueryable <T> queryable, PaginateDTO paginateDTO)
{
return(queryable
.Skip((paginateDTO.Page - 1) * paginateDTO.RowsByPage)
.Take(paginateDTO.RowsByPage));
}
