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()); }