public static IQueryable <Invoice> GetInvoices(this KhaalminateDbContext dbContext, int pageSize = 10, int pageNumber = 1, int?invid = null, int?colorID = null, int?outerPackageID = null, int?supplierID = null, int?unitPackageID = null)
{
// Get query from DbSet
var query = dbContext.Invoices.AsQueryable();
// Filter by: 'LastEditedBy'
if (invid.HasValue)
{
query = query.Where(item => item.Invid == invid);
}
return(query);
}
public static async Task <Invoice> GetInvoiceNumberAsync(this KhaalminateDbContext dbContext, Invoice entity) => await dbContext.Invoices.FirstOrDefaultAsync(item => item.Invno == entity.Invno);
