/// <summary> /// Get a Product /// </summary> /// <param name="id"></param> /// <returns> /// product if found, else null /// </returns> public Product GetProduct(int id) { Product product = null; using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationDbContext"].ConnectionString)) { conn.Open(); var command = new SqlCommand("SELECT * FROM Product WHERE productId=@ProductId", conn); command.Parameters.AddWithValue("ProductId", id); var reader = command.ExecuteReader(); while (reader.Read()) { // Build the object product = ObjectBuilder.CreateProduct(reader); } } return(product); }
/// <summary> /// Get all Products with Saving /// </summary> /// <returns> /// List of products /// </returns> public List <Product> GetAllProductsWithSavings() { var products = new List <Product>(); using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationDbContext"].ConnectionString)) { conn.Open(); var command = new SqlCommand("SELECT * FROM Product, Saving, Warehouse WHERE warehouseProductId = productId AND warehouseSavingId = savingId", conn); var reader = command.ExecuteReader(); while (reader.Read()) { // Build the Product object var product = ObjectBuilder.CreateProduct(reader); // Add to the list products.Add(product); } } return(products); }
/// <summary> /// Get all Sold products /// </summary> /// <returns> /// List of products /// </returns> public List <Product> GetAllSoldProducts() { var products = new List <Product>(); using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationDbContext"].ConnectionString)) { conn.Open(); var command = new SqlCommand("SELECT * FROM Cart, PartOrder, Product WHERE cartId = partOrderCartId AND partOrderProductId = productId", conn); var reader = command.ExecuteReader(); while (reader.Read()) { // Build the Product object var product = ObjectBuilder.CreateProduct(reader); // Add to the list products.Add(product); } } return(products); }
/// <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 Product similar to name /// </summary> /// <param name="input"></param> /// <returns> /// List of Product /// </returns> public List <Product> GetAllProductsByName(string input) { var products = new List <Product>(); using ( var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationDbContext"].ConnectionString)) { conn.Open(); var command = new SqlCommand("SELECT * FROM Product WHERE productName LIKE @name", conn); command.Parameters.AddWithValue("name", input); var reader = command.ExecuteReader(); while (reader.Read()) { // Build the Product object var product = ObjectBuilder.CreateProduct(reader); // Add the Product to the list products.Add(product); } } return(products); }
/// <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); }