private void ProductCategoryComboBox_SelectedIndexChanged(object sender, EventArgs e) { ProductsGridView.Rows.Clear(); if (ProductCategoryComboBox.SelectedIndex == 0) { FoodRepository _DataAccess = new FoodRepository(); foreach (Food ProductDetail in _DataAccess.RetreiveAllProducts()) { ProductsGridView.Rows.Add(ProductDetail.FId, ProductDetail.FName, ProductDetail.FPrice, ProductDetail.FCategory, ProductDetail.FDescription, ProductDetail.FPicture); } } else if (ProductCategoryComboBox.SelectedIndex > 0) { string CategoryName = ProductCategoryComboBox.SelectedItem.ToString(); FoodRepository _DataAccess = new FoodRepository(); int CategoryID = _DataAccess.ReturnCategoryID(CategoryName); foreach (Food ProductDetail in _DataAccess.RetreiveProductsFromCategory(CategoryID)) { ProductsGridView.Rows.Add(ProductDetail.FId, ProductDetail.FName, ProductDetail.FPrice, CategoryName, ProductDetail.FDescription, ProductDetail.FPicture); } } }
private void UpdateProductButton_Click(object sender, EventArgs e) { if (MessageBox.Show("Are You Sure You Want to Update this Product?", "Warning", MessageBoxButtons.YesNo) == DialogResult.Yes) { FoodRepository _DataAccess = new FoodRepository(); int ProductID = Convert.ToInt32(ProductIDBox.Text); string ProductName = ProductNameBox.Text; decimal ProductPrice = Convert.ToDecimal(ProductPriceBox.Text); string ProductCategory = ProductCategoryComboBox.Text; int ProductCategoryID = _DataAccess.ReturnCategoryID(ProductCategory); string ProductDescription = ProductDescriptionRBox.Text; /*initializing memory stream class for creating a stream of binary numbers*/ MemoryStream ms = new MemoryStream(); /*saving the image in raw format from picture box*/ ProductPictureBox.Image.Save(ms, ProductPictureBox.Image.RawFormat); /*Array of Binary numbers that have been converted*/ byte[] MyProductPicture = ms.GetBuffer(); /*closing the memory stream*/ ms.Close(); if (_DataAccess.UpdateProduct(ProductID, ProductName, ProductPrice, ProductCategoryID, ProductDescription, MyProductPicture)) { this.Close(); } else { MessageBox.Show("Product Not Updated", "Error", MessageBoxButtons.OK); } } }
private void AddProductButton_Click(object sender, EventArgs e) { FoodRepository _DataAccess = new FoodRepository(); /*THIS IS THE MAIN CODE FOR HASHING*/ /*initializing memory stream class for creating a stream of binary numbers*/ MemoryStream ms = new MemoryStream(); /*saving the image in raw format from picture box*/ ProductPictureBox.Image.Save(ms, ProductPictureBox.Image.RawFormat); /*Array of Binary numbers that have been converted*/ byte[] ProductPicture = ms.GetBuffer(); /*closing the memory stream*/ ms.Close(); /*HASHING END HERE*/ if (_DataAccess.AddNewProductToDatabase(ProductNameBox.Text, Convert.ToDecimal(ProductPriceBox.Text), _DataAccess.ReturnCategoryID(ProductCategoryComboBox.SelectedItem.ToString()), ProductDescriptionRBox.Text, ProductPicture)) { MessageBox.Show("Product Added"); } else { MessageBox.Show("Product Not Added"); } }