private void DeleteProduct()
{
DialogResult result =
MessageBox.Show($"Delete {selectedProduct.ProductCode.Trim()}?",
"Confirm Delete", MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)// user confirmed
{
try
{
context.Products.Remove(selectedProduct);
context.SaveChanges(true);
DisplayProducts();
}
catch (DbUpdateConcurrencyException ex)
{
HandleConcurrencyError(ex);
}
catch (DbUpdateException ex)
{
HandleDatabaseError(ex);
}
catch (Exception ex)
{
HandleGeneralError(ex);
}
}
}
//user clicks on Add product
private void btnAdd_Click(object sender, EventArgs e)
{
var addModifyProductForm = new frmAddorModify()
{
AddProduct = true // initializer
};
DialogResult result = addModifyProductForm.ShowDialog(); //display model
if (result == DialogResult.OK) // user clicked Accept on the second form
{
try
{
selectedProduct = addModifyProductForm.Product; // record product from the second
// form as the current product
context.Products.Add(selectedProduct);
context.SaveChanges();
DisplayProducts();
}
catch (DbUpdateException ex)
{
HandleDatabaseError(ex);
}
catch (Exception ex)
{
HandleGeneralError(ex);
}
}
}
private void btnOk_Click(object sender, EventArgs e)
{
// lauching Add product form
{
addproduct = new Product();
addproduct.ProductCode = ProductCodeTxt.Text;
addproduct.Name = NameTxt.Text;
addproduct.Version = Convert.ToDecimal(VersionTxt.Text);
addproduct.ReleaseDate = Convert.ToDateTime(ReleaseDateTxt.Text);
if (Buttonadd == true)
{
context.Products.Add(addproduct);
MessageBox.Show("New Product added");
}
else
{
context.Products.Update(addproduct);
MessageBox.Show("Product updated");
}
context.SaveChanges();
this.Close();
}
}
// Save current product to database
public void OKBtn_Click(object sender, EventArgs e)
{
product = new Product
{
ProductCode = productCodeTxt.Text,
Name = nameTxt.Text,
Version = Convert.ToDecimal(versionTxt.Text),
ReleaseDate = Convert.ToDateTime(releaseDateTxt.Text)
};
if (AddButtonSet == false)
{
context.Products.Update(product);
}
else
{
context.Products.Add(product);
}
DialogResult save =
MessageBox.Show(
$"Saving this Entry:\nCode: {productCodeTxt.Text}\nName: {nameTxt.Text}\nVersion: {versionTxt.Text}\n" +
$"Release Date: {releaseDateTxt.Text}",
"Confirm Entry",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button2);
if (save == DialogResult.OK)
{
context.SaveChanges();
this.Close();
}
}
public void Save()
{
try
{
DB.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("Saving Error", ex.InnerException);
}
}
/// <summary>
/// Removes selected record from Database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void removeBtn_Click(object sender, EventArgs e)
{
DialogResult button =
MessageBox.Show(
"Are you sure that you want to remove the selected record?",
"Remove Item",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button2);
if (button == DialogResult.OK)
{
context.Products.Remove(currentProduct);
context.SaveChanges();
Display();
}
}
private void btnRemove_Click(object sender, EventArgs e)
{
context.Products.Remove(currentProduct);
context.SaveChanges();
Display();
}
