private void addItemButton_Click(object sender, EventArgs e) { aProductInfo = new Product(productIdTextBox.Text, Convert.ToInt16(quantityTextBox.Text)); MessageBox.Show(aShop.AddProduct(aProductInfo)); ShowItemInListView(); }
private void sellItemButton_Click(object sender, EventArgs e) { aProduct = new Product(sellProductIdTextBox.Text, Convert.ToInt16(sellQuantityTextBox.Text)); string msg = shop.SellProduct(aProduct); ShowProductsOnListView(); MessageBox.Show(msg); }
private void UpdateQuantity(Product aNewProduct) { foreach (Product aProduct in productList) { if (aProduct.ProductId == aNewProduct.ProductId) { aProduct.Quantity += aNewProduct.Quantity; } } }
public string SaveProduct(Product aProduct) { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); string query = "INSERT INTO t_Product(Quantity, ProductID) VALUES (" + aProduct.Quantity + ",'" + aProduct.ProductId + "')"; sqlCommand = new SqlCommand(query, conn); sqlCommand.ExecuteNonQuery(); conn.Close(); return "Product has been saved"; }
public string SellProduct(Product aSellProduct) { foreach (Product aProduct in productList) { if (aProduct.ProductId == aSellProduct.ProductId) { aProduct.Quantity -= aSellProduct.Quantity; return "Product Sold!"; } } return "The product does not exists!"; }
private string UpdateProductQuantity(Product aProduct) { string connectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\FTFL-ITS-2014000122\SuperShopWithAddAndSellApp\SuperShopWithAddAndSellApp\SuperShop.mdf"; SqlConnection conn = new SqlConnection(connectionString); conn.Open(); string query = "UPDATE Product_table SET Quantity = Quantity + " + aProduct.Quantity + " WHERE ProductID = '" + aProduct.ProductId + "'"; SqlCommand insert = new SqlCommand(query, conn); insert.ExecuteNonQuery(); conn.Close(); return "Product has been saved."; }
private void addItemButton_Click(object sender, EventArgs e) { string id = productIdTextBox.Text; int quantity = Convert.ToInt16(quantityTextBox.Text); aProduct = new Product(id, quantity); string mes = shop.AddProduct(aProduct); MessageBox.Show(mes); string msg = aDatabase.AddProductInDatabase(id, quantity); MessageBox.Show(msg); ShowProductsOnListView(); }
public string AddProduct(Product aNewProduct) { if(HasThisID(aNewProduct.ProductId)) { UpdateQuantity(aNewProduct); return "product updated"; } else { productList.Add(aNewProduct); return "product added"; } }
public string SellProduct(Product aSellProduct) { if (HasThisIdInSell(aSellProduct.ProductId)) { return SellQuantity(aSellProduct); // return "product updated"; } else { // productList.Add(aNewProduct); return "product is not found"; } }
private string AddProduct(Product aProduct) { string connectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\FTFL-ITS-2014000122\SuperShopWithAddAndSellApp\SuperShopWithAddAndSellApp\SuperShop.mdf"; SqlConnection conn = new SqlConnection(connectionString); conn.Open(); string query = "INSERT INTO Product_table(Quantity, ProductID) VALUES (" + aProduct.Quantity + ",'" + aProduct.ProductId + "')"; SqlCommand insert = new SqlCommand(query, conn); insert.ExecuteNonQuery(); conn.Close(); return "Product has been saved."; }
public string SellProduct(Product aNewProduct) { foreach (Product aProduct in productList) { if (aProduct.ProductId == aNewProduct.ProductId) { aProduct.Quantity -= aNewProduct.Quantity; return "product Updated"; } } //productList.Add(aNewProduct); return "succefully selled"; }
public string AddProduct(Product aNewProduct) { foreach (Product aProduct in productList) { if (aProduct.ProductId == aNewProduct.ProductId) { aProduct.Quantity += aNewProduct.Quantity; return "product Updated"; } } productList.Add(aNewProduct); return "succefully added"; }
private void addProductButton_Click(object sender, EventArgs e) { int qty = Convert.ToInt16(quantityTextBox.Text); Product aProduct = new Product(productIdTextBox.Text, qty); if (HasThisId(aProduct.ProductId)) { MessageBox.Show(UpdateProductQuantity(aProduct)); } else { MessageBox.Show(AddProduct(aProduct)); } ShowItemInListView(); }
private void addItemButton_Click(object sender, EventArgs e) { string id = productIdTextBox.Text; int qty = Convert.ToInt16(quantityTextBox.Text); Product aProduct = new Product(productIdTextBox.Text, qty); if (aDatabase.HasThisId(id)) { MessageBox.Show(aDatabase.UpdateProductInDatabase(id,qty)); } else { MessageBox.Show(aDatabase.AddProductInDatabase(id,qty)); } addItemdataGridView.DataSource = null; addItemdataGridView.DataSource = aDatabase.fillDataTable("Product"); // table name // ShowProductsOnListView(); }
private void sellItemButton_Click(object sender, EventArgs e) { aDatabase = new Database(); string id = sellProductIdTextBox.Text; int quantity = Convert.ToInt16(sellQuantityTextBox.Text); aProduct = new Product(id, quantity); if (aDatabase.HasThisId(id)) { MessageBox.Show(aDatabase.SellProductInDatabase(id, quantity)); } else { MessageBox.Show("Product not fornd"); } sellItemdataGridView.DataSource = null; sellItemdataGridView.DataSource = aDatabase.fillDataTable("Product"); // table name }
public List<Product> GetAllProduct() { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); string query = "SELECT ProductId, Quantity FROM t_Product"; SqlCommand insert = new SqlCommand(query, conn); SqlDataReader productReader = insert.ExecuteReader(); List<Product> productList = new List<Product>(); while (productReader.Read()) { Product aProduct = new Product(); aProduct.ProductId = productReader["productId"].ToString(); aProduct.Quantity = Convert.ToInt16(productReader["Quantity"]); productList.Add(aProduct); } conn.Close(); return productList; }
public string SellProduct(Product aNewProduct) { foreach (Product aProduct in productList) { if (aProduct.ProductId == aNewProduct.ProductId) { bool isSuccess = aProduct.DeductQuantity(aNewProduct.Quantity); if (!isSuccess) { return "Insuficient quantity"; } return "Sell success"; } } return "success"; //public List<Product> GetProductList() //{ // return productList; //} }
private void sellItemButton_Click(object sender, EventArgs e) { aProductInfo = new Product(sellProductIdTextBox.Text, Convert.ToInt16(sellQuantityTextBox.Text)); MessageBox.Show(aShop.SellProduct(aProductInfo)); SellItemInListView(); }
private string AddProduct(Product aProduct) { aDatabaseGateway.SaveProduct(aProduct); return "Product has been saved."; }
private void sellProductButton_Click(object sender, EventArgs e) { aproductInfo = new Product(productIdTextBox.Text, Convert.ToInt16(quantityTextBox.Text)); MessageBox.Show(ashop.SellProduct(aproductInfo)); ShowSellItemListView(); }
private string SellQuantity(Product aSellProduct) { foreach (Product aProduct in productList) { if (aProduct.ProductId == aSellProduct.ProductId) { if (aProduct.Quantity >= aSellProduct.Quantity && aProduct.Quantity != 0) { aProduct.Quantity -= aSellProduct.Quantity; return "product has been selled"; } else { return "sorry, sell quqntity is not sufficient"; } } } return null; }
private string UpdateProductQuantity(Product aProduct) { return aDatabaseGateway.IncreaseProductQuantity(aProduct); }
public string IncreaseProductQuantity(Product aProduct) { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); string query = "UPDATE t_Product SET Quantity = Quantity + " + aProduct.Quantity + " WHERE ProductID = '" + aProduct.ProductId + "'"; SqlCommand insert = new SqlCommand(query, conn); insert.ExecuteNonQuery(); conn.Close(); return "Product quantity has been increased"; }