// method to insert and update records to the database private void btnSave_Click(object sender, EventArgs e) { int num; if (btnSave.Text == "Add") { try { if (txtProductId.Text == "") { MessageBox.Show("Please Enter Product Id", "Product Id"); txtProductId.Focus(); } else if (!Int32.TryParse(txtProductId.Text, out num) && num <= 0) { MessageBox.Show("Please Enter a valid Number", "Entry_Error"); txtProductId.Focus(); } else if (txtProductName.Text == "") { MessageBox.Show("Please Enter Product Name", "Product Name"); txtProductName.Focus(); } else { prod = new Product(); prod.ProductId = Convert.ToInt32(txtProductId.Text); prod.Name = txtProductName.Text; ProductDB.AddEntity(prod); LoadComboxProducts(); LoadListView(); pnlProduct.Visible = false; lsvProduct.Visible = true; lblSelectProd.Visible = true; cboProducts.Visible = true; btnDeleteProduct.Enabled = true; btnProduct.Enabled = true; txtProductId.Enabled = true; MessageBox.Show("New Product Added Successfully"); } } catch (SqlException ex) { string errorMsg = "A record exist with the same Product Id"; MessageBox.Show(errorMsg, ex.Message); } } // update record else if (btnSave.Text == "Update") { Product newProduct = new Product(); newProduct.ProductId = prod.ProductId; acceptRecord(newProduct); try { if (!ProductDB.UpdateProduct(prod, newProduct)) { MessageBox.Show("Another Product Exist with similar records", "Database Error"); this.DialogResult = DialogResult.Retry; } else { prod = newProduct; LoadComboxProducts(); LoadListView(); pnlProduct.Visible = false; lsvProduct.Visible = true; lblSelectProd.Visible = true; cboProducts.Visible = true; btnDeleteProduct.Enabled = true; btnProduct.Enabled = true; txtProductId.Enabled = true; MessageBox.Show("Product record Updated successfully", "Update Record"); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } }