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