/// <summary> /// Get a Warehouse by a Product id /// </summary> /// <param name="productId"></param> /// <param name="shopId"></param> /// <returns> /// Warehouse if found, else null /// </returns> public Warehouse GetWarehouseByProductId(int productId, int shopId) { Warehouse warehouse = null; using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationDbContext"].ConnectionString)) { conn.Open(); var command = new SqlCommand("SELECT * FROM Warehouse, Product WHERE warehouseProductId=@ProductId And warehouseProductId = productId AND warehouseShopId = @ShopId", conn); command.Parameters.AddWithValue("ProductId", productId); command.Parameters.AddWithValue("ShopId", shopId); var reader = command.ExecuteReader(); while (reader.Read()) { // Build the object var product = ObjectBuilder.CreateProduct(reader); warehouse = ObjectBuilder.CreateWarehouse(reader, product); } } return(warehouse); }
/// <summary> /// Get a Warehouse /// </summary> /// <param name="id"></param> /// <returns> /// Warehouse if found, else null /// </returns> public Warehouse GetWarehouse(int id) { Warehouse warehouse = null; using ( var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationDbContext"].ConnectionString)) { conn.Open(); var cmd = new SqlCommand("SELECT * FROM Warehouse, Product WHERE warehouseId = @id and Product.productId = warehouseProductId ", conn); cmd.Parameters.AddWithValue("id", id); var reader = cmd.ExecuteReader(); while (reader.Read()) { // Build the product var product = ObjectBuilder.CreateProduct(reader); // Build the Warehouse with a product warehouse = ObjectBuilder.CreateWarehouse(reader, product); } } return(warehouse); }
/// <summary> /// Get all Warehouse by a shop id /// </summary> /// <param name="shopId"></param> /// <returns> /// List of Warehouse /// </returns> public List <Warehouse> GetAllWarehousesByShopId(int shopId) { var warehouses = new List <Warehouse>(); using ( var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationDbContext"].ConnectionString)) { conn.Open(); var cmd = new SqlCommand("SELECT * FROM Warehouse, Product WHERE Product.productId = warehouseProductId and warehouseShopId = @ShopId", conn); cmd.Parameters.AddWithValue("ShopId", shopId); var reader = cmd.ExecuteReader(); while (reader.Read()) { // Build the product object var product = ObjectBuilder.CreateProduct(reader); // Build the warehouse with a product var warehouse = ObjectBuilder.CreateWarehouse(reader, product); // Add the warehouse to the list warehouses.Add(warehouse); } } return(warehouses); }