public async Task <ActionResult <IEnumerable <Inventory> > > GetInventory([FromQuery] SalesInvoicePagination pagination, [FromQuery] string item)
{
var queryable = _context.Inventories.AsQueryable();
if (!string.IsNullOrEmpty(item))
{
queryable = queryable.Where(x => x.Item_Code.Contains(item));
}
await HttpContext.InsertPaginationParameterResponse(queryable, pagination.QuantityPerPage);
return(await queryable.Paginate(pagination).ToListAsync());
}
public async Task <ActionResult <IEnumerable <SalesOrderHeaders> > > GetSalesOrder_Headers([FromQuery] SalesInvoicePagination pagination, [FromQuery] string order)
{
var queryable = _context.SalesOrder_Headers.AsQueryable();
if (!string.IsNullOrEmpty(order))
{
queryable = queryable.Where(x => x.Order_Number.Contains(order));
}
await HttpContext.InsertPaginationParameterResponse(queryable, pagination.QuantityPerPage);
return(await queryable.Paginate(pagination).ToListAsync());
}
public async Task <ActionResult <IEnumerable <ArticleMaster> > > GetArticle_Masters([FromQuery] SalesInvoicePagination pagination, [FromQuery] string article)
{
var queryable = _context.Article_Masters.AsQueryable();
if (!string.IsNullOrEmpty(article))
{
queryable = queryable.Where(x => x.Article_Code.Contains(article));
}
await HttpContext.InsertPaginationParameterResponse(queryable, pagination.QuantityPerPage);
return(await queryable.Paginate(pagination).ToListAsync());
}
public static IQueryable <T> Paginate <T>(this IQueryable <T> queryable, SalesInvoicePagination pagination)
{
return(queryable.Skip((pagination.Page - 1) * pagination.QuantityPerPage).Take(pagination.QuantityPerPage));
}
public async Task <ActionResult <IEnumerable <Pending_BP> > > GetBusiness_Partners([FromQuery] SalesInvoicePagination pagination, [FromQuery] string card)
{
var queryable = _context.Pending_BPs.AsQueryable();
if (!string.IsNullOrEmpty(card))
{
queryable = queryable.Where(x => x.Card_Code.Contains(card));
}
await HttpContext.InsertPaginationParameterResponse(queryable, pagination.QuantityPerPage);
return(await queryable.Paginate(pagination).ToListAsync());
}
public async Task <ActionResult <IEnumerable <SalesOrder> > > GetSales_Orders([FromQuery] SalesInvoicePagination pagination)
{
var queryable = _context.Sales_Orders.AsQueryable();
await HttpContext.InsertPaginationParameterResponse(queryable, pagination.QuantityPerPage);
return(await queryable.Paginate(pagination).ToListAsync());
}
