private void UpdateProduct() { string productID = txtProductID.Text; PRODUCT product = db.PRODUCTS.Where(p => p.Product_ID == productID).SingleOrDefault(); Console.WriteLine(product); if (product != null) { if (IsValidPriceProduct()) { string categoryName = cbCategory.SelectedValue.ToString(); string categoryID = MapCategoryName_To_CategoryID(categoryName); product.Product_CategoryID = categoryID; product.Product_Name = cbProductName.SelectedValue.ToString(); product.Product_Price = int.Parse(txtPrice.Text); product.Product_Status = cxActiveProduct.Checked; db.SaveChanges(); LoadData_Products(); MessageBox.Show("Update product successully"); } else { MessageBox.Show("Product Price MUST BE GREATER THAN ZERO"); } } else { MessageBox.Show("System prevent to edit Product ID"); } }
private void AddProduct() { string productID = txtProductID.Text; PRODUCT product = db.PRODUCTS.Where(p => p.Product_ID == productID).SingleOrDefault(); if (product == null) { string categoryName = cbCategory.SelectedValue.ToString(); string categoryID = MapCategoryName_To_CategoryID(categoryName); Console.WriteLine(categoryID); if (IsValidPriceProduct()) { PRODUCT p = new PRODUCT() { Product_ID = productID, Product_CategoryID = categoryID, Product_Name = cbProductName.SelectedValue.ToString(), Product_Price = int.Parse(txtPrice.Text), Product_Status = cxActiveProduct.Checked }; db.PRODUCTS.Add(p); db.SaveChanges(); LoadData_Products(); MessageBox.Show("Add product successully"); } else { MessageBox.Show("Product Price MUST BE GREATER THAN ZERO"); } } else { MessageBox.Show("Product ID Duplicate or Blank !"); } }
private void DeleteProduct() { string productID = txtProductID.Text; PRODUCT product = db.PRODUCTS.Where(p => p.Product_ID == productID).SingleOrDefault(); if (product != null) { db.PRODUCTS.Remove(product); db.SaveChanges(); LoadData_Products(); MessageBox.Show("Delete product successully"); } else { MessageBox.Show("Can not find this Product ID"); } }