private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult result1 = MessageBox.Show("Are You Want To Delete This?", "Confirm!", MessageBoxButtons.YesNo);
if (result1 == DialogResult.Yes)
{
try
{
int p_Id = Convert.ToInt32(txtProductId.Text);
context = new DBDataContext();
Database.Product deleteProduct = context.Products.FirstOrDefault(p => p.P_Id == p_Id);
context.Products.DeleteOnSubmit(deleteProduct);
context.SubmitChanges();
MessageBox.Show("Successfully Deleted.");
ClearProductInput();
ShowAllProductsData();
}
catch (Exception)
{
MessageBox.Show("Failed to Delete.");
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
DialogResult result1 = MessageBox.Show("Are You Want To Update This?", "Confirm!", MessageBoxButtons.YesNo);
if (result1 == DialogResult.Yes)
{
context = new DBDataContext();
String sts = "Unabailable";
if (chkAvailable.Checked)
{
sts = "Available";
}
try
{
int p_Id = Convert.ToInt32(txtProductId.Text);
Database.Product updateProduct = context.Products.FirstOrDefault(p => p.P_Id == p_Id);
if (updateProduct != null)
{
updateProduct.P_Id = Convert.ToInt32(txtProductId.Text);
updateProduct.P_Name = txtProductName.Text;
updateProduct.P_Price = Convert.ToInt32(txtProductPrice.Text);
updateProduct.P_Status = sts;
}
context.SubmitChanges();
MessageBox.Show("Successfully Updated.");
ClearProductInput();
ShowAllProductsData();
}
catch (Exception)
{
MessageBox.Show("Failed to Update.");
}
}
}
