public IActionResult Get(int pageIndex, int pageSize)
{
var data = _context.Orders.Include(o => o.Customer).OrderByDescending(c => c.Placed);
var page = new PaginatedResponse <Order>(data, pageIndex, pageSize);
var totalCount = data.Count();
var totalPages = Math.Ceiling((double)totalCount / pageSize);
var response = new
{
Page = page,
TotalPages = totalPages
};
return(Ok(response));
}
public IActionResult Get(int pageIndex, int pageSize)
{
var data = _ctx.Customers.OrderBy(c => c.Id);
var page = new PaginatedResponse <Customer>(data, pageIndex, pageSize);
var totalCount = data.Count();
var totalPages = Math.Ceiling((double)totalCount / pageSize);
var response = new
{
Page = page,
TotalPages = totalPages
};
return(Ok(response));
}
public IActionResult Get(int pageIndex, int pageSize)
{
var data = _ctx.Trips.Include(o => o.Account)
.OrderByDescending(c => c.RTA);
var page = new PaginatedResponse <Trip>(data, pageIndex, pageSize);
var totalCount = data.Count();
var totalPages = Math.Ceiling((double)totalCount / pageSize);
var response = new
{
Page = page,
TotalPages = totalPages
};
return(Ok(response));
}
public IActionResult Get(int pageIndex, int pageSize)
{
var data = _ctx.Orders.Include(o => o.Customer)
.OrderByDescending(c => c.Placed);
var page = new PaginatedResponse <Order>(data, pageIndex, pageSize);
var totalCount = data.Count();
//will create a new page if there are still some results left that dont fit
var totalPages = Math.Ceiling((double)totalCount / pageSize);
var response = new
{
Page = page,
TotalPages = totalPages
};
return(Ok(response));
}
public async Task <IActionResult> GetAllOrders(int pageIndex, int pageSize)
{
//Get orders include customers and sort by orders placed.
var data = _context.Orders
.Include(order => order.Customer)
.OrderByDescending(order => order.Placed);
//Paginate the data.
var page = new PaginatedResponse <Order>(data, pageIndex, pageSize);
var totalCount = await data.CountAsync();
var totalPages = Math.Ceiling((double)totalCount / pageSize);
var response = new
{
Page = page,
TotalPages = totalPages
};
return(Ok(response));
}