//Edit products
private void btnEditProduct_Click(object sender, EventArgs e)
{
frmAddEditProducts addProductForm = new frmAddEditProducts();
addProductForm.addProduct = false;
// get the key of the current product in the data grid view
int rowNum = Convert.ToInt32(productDataGridView.CurrentCell.RowIndex); // index of the current row
int ordernum = Convert.ToInt32(productDataGridView["dataGridViewTextBoxColumn12", rowNum].Value); // Column for productid
using (TravelExpertDBDataContext db = new TravelExpertDBDataContext())
{
addProductForm.currentProduct = (from p in db.Products
where p.ProductId == ordernum
select p).Single();
}
DialogResult result = addProductForm.ShowDialog(); // display second form modal
using (TravelExpertDBDataContext db = new TravelExpertDBDataContext())
{
if (result == DialogResult.OK) // successful update
{
productDataGridView.DataSource = db.Products; // refresh grid
MessageBox.Show("Product Name Edited Successfully");
}
}
}
// Add products
private void btnAddProduct_Click(object sender, EventArgs e)
{
frmAddEditProducts addProductForm = new frmAddEditProducts();
addProductForm.addProduct = true;
// Display second form modal
DialogResult result = addProductForm.ShowDialog();
using (TravelExpertDBDataContext db = new TravelExpertDBDataContext())
{
// Update is successful
if (result == DialogResult.OK)
{
// Refresh grid
productDataGridView.DataSource = db.Products;
products = db.Products.ToList();
MessageBox.Show("New Product Added Successfully");
}
}
}
