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