public static IQueryable <StockItem> GetStockItems(this WideWorldImportersDbContext dbContext, int pageSize = 10, int pageNumber = 1, int?lastEditedBy = null, int?colorID = null, int?outerPackageID = null, int?supplierID = null, int?unitPackageID = null)
        {
            // Get query from DbSet
            var query = dbContext.StockItems.AsQueryable();

            // Filter by: 'LastEditedBy'
            if (lastEditedBy.HasValue)
            {
                query = query.Where(item => item.LastEditedBy == lastEditedBy);
            }

            // Filter by: 'ColorID'
            if (colorID.HasValue)
            {
                query = query.Where(item => item.ColorID == colorID);
            }

            // Filter by: 'OuterPackageID'
            if (outerPackageID.HasValue)
            {
                query = query.Where(item => item.OuterPackageID == outerPackageID);
            }

            // Filter by: 'SupplierID'
            if (supplierID.HasValue)
            {
                query = query.Where(item => item.SupplierID == supplierID);
            }

            // Filter by: 'UnitPackageID'
            if (unitPackageID.HasValue)
            {
                query = query.Where(item => item.UnitPackageID == unitPackageID);
            }

            return(query);
        }
 public static async Task <StockItem> GetStockItemsByStockItemNameAsync(this WideWorldImportersDbContext dbContext, StockItem entity)
 => await dbContext.StockItems.FirstOrDefaultAsync(item => item.StockItemName == entity.StockItemName);