public static IQueryable <TModel> Paging <TModel>(this IQueryable <TModel> query, PagedResponse <object> response, int pageStart = 0, int pageSize = 0) where TModel : class
{
response.ItemsCount = query.Count();
response.PageNumber = pageStart;
response.PageSize = pageSize;
return(pageSize > 0 && pageStart > 0 ? query.Skip((pageStart - 1) * pageSize).Take(pageSize) : query);
}
public async static Task <IEnumerable <object> > GetPurchaseList(this HSBorsDb db, PagedResponse <object> response, SearchPurchaseRequest request)
{
var query = await GetPurchases(db, request).Paging(response, request.page_start, request.page_size)
.Include(x => x.bank_copartner).Include(x => x.buyer)
.ToListAsync();
var entity_list = query
.Select(x => new
{
x.id,
x.amount,
x.bank_copartner_id,
x.bank_copartner_name,
x.bank_copartner_intrest,
x.bank_copartner_percent,
x.buyer_id,
x.buyer_name
});
return(entity_list);
}
