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