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) { var query = dbContext.StockItems.AsQueryable(); if (lastEditedBy.HasValue) { query = query.Where(item => item.LastEditedBy == lastEditedBy); } if (colorID.HasValue) { query = query.Where(item => item.ColorID == colorID); } if (outerPackageID.HasValue) { query = query.Where(item => item.OuterPackageID == outerPackageID); } if (supplierID.HasValue) { query = query.Where(item => item.SupplierID == supplierID); } if (unitPackageID.HasValue) { query = query.Where(item => item.UnitPackageID == unitPackageID); } return(query); }
public static IQueryable <StockItem> GetStockItems(this WideWorldImportersDbContext dbContext, int pageSize = 10, int pageNumber = 1, int?lastEditedBy = null, int?colorID = null, int?embalagemID = null, int?fornecedorID = null, int?precoUnidade = null) { //Get quey do DbSet var query = dbContext.StockItems.AsQueryable(); //Filtro do: 'LastEditedBy' if (lastEditedBy.HasValue) { query = query.Where(item => item.LastEditedBy == lastEditedBy); } //Filtro do: 'ColorID' if (colorID.HasValue) { query = query.Where(item => item.ColorID == colorID); } //Filtro do: 'OuterPackageID if (embalagemID.HasValue) { query = query.Where(item => item.EmbalagemID == embalagemID); } //Filtro do: 'SupplierID if (fornecedorID.HasValue) { query = query.Where(item => item.FornecedorID == fornecedorID); } //Filtro do: 'UnitPackageID' if (precoUnidade.HasValue) { query = query.Where(item => item.PrecoUnidade == precoUnidade); } return(query); }
public static async Task <StockItem> GetStockItemsByStockItemNameAsync(this WideWorldImportersDbContext dbContext, StockItem entity) => await dbContext.StockItems.FirstOrDefaultAsync(item => item.StockItemName == entity.StockItemName);
public WarehouseRepository(WideWorldImportersDbContext dbContext) : base(dbContext) { }
public Repository(WideWorldImportersDbContext dbContext) { DbContext = dbContext; }
public static IQueryable <TEntity> Paging <TEntity>(this WideWorldImportersDbContext dbContext, int pageSize = 0, int pageNumber = 0) where TEntity : class { var query = dbContext.Set <TEntity>().AsQueryable(); return(pageSize > 0 && pageNumber > 0 ? query.Skip((pageNumber - 1) * pageSize).Take(pageSize) : query); }
public UnitOfWork(WideWorldImportersDbContext dbContext) { this.Dbcontext = dbContext; }
public static IQueryable <Product> GetProducts(this WideWorldImportersDbContext dbContext) { return(dbContext.Products.AsQueryable()); }
public static async Task <Product> GetProductByProductNameAsync(this WideWorldImportersDbContext dbContext, Product entity) => await dbContext.Products.FirstOrDefaultAsync(item => item.Name == entity.Name);