//delete button pressed for product supplier tab private void btnDeleteProductSupplier_Click(object sender, EventArgs e) { //showing yes or no message box to give user choice DialogResult result = MessageBox.Show("Are you sure?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); Product_Supplier productSupplier = productSuppliers[product_SupplierDataGridView.CurrentCell.RowIndex]; //SelectRowProducts_Suppliers(); //delete later if (result == DialogResult.Yes) { try { if (!Product_SupplierDB.DeleteProduct_Supplier(productSupplier)) //if database delete was not sucessful { MessageBox.Show("Another user has updated or deleted this product supplier information", "Datebase Error"); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } this.DisplayProductSupplier(); this.DisplayPackages(); this.DisplayPackageProdSup(); }
private void AddModifyProductsSupplier_Load(object sender, EventArgs e) { this.LoadComboBox(); //load combo boxs with values if (addProductSupplier) //if add was pressed { this.Text = "Add Product Supplier"; //combo box has no selection cbProductId.SelectedIndex = -1; cbSupplierID.SelectedIndex = -1; txtProdSupplierID.Text = Product_SupplierDB.GetNextProductSupplierID().ToString();//get next id value } else//modify button was pressed { this.Text = "Modify Product Supplier"; DisplayProductSuppliers(); } }
/// <summary> /// /// </summary> private void btnAccept_Click(object sender, EventArgs e) { if (ValidData()) //making sure data is valid { if (addPackageProdSup) // if user clciked the add button { productSupplier = new Product_Supplier(); this.ProductSupplierData(productSupplier); try { productSupplier.ProductSupplierID = Product_SupplierDB.AddProduct_Supplier(productSupplier); Packages_Products_SuppliersDB.Add(productSupplier, package); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } else //if user clicks modify button { Product_Supplier newProductSupplier = new Product_Supplier(); newProductSupplier.ProductSupplierID = packProdSup.ProductSupplerID; this.ProductSupplierData(newProductSupplier); try { if (!Product_SupplierDB.UpdateProduct_Supplier_Packages(packProdSup, newProductSupplier)) //if product update was unsuccessful { MessageBox.Show("Another user has updated or " + "deleted that customer.", "Database Error"); this.DialogResult = DialogResult.Retry; } else { this.DialogResult = DialogResult.OK; } } catch (Exception ex) { throw ex; } } } }
//user clicks accept button private void btnAccept_Click(object sender, EventArgs e) { if (ValidData()) { if (addProductSupplier) //add button was pressed { productSupplier = new Product_Supplier(); this.ProductSupplierData(productSupplier); //set the product supplier data to the product supplier object try { productSupplier.ProductSupplierID = Product_SupplierDB.AddProduct_Supplier(productSupplier); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } else //modify button was pressed { Product_Supplier newProductSupplier = new Product_Supplier(); newProductSupplier.ProductSupplierID = productSupplier.ProductSupplierID; this.ProductSupplierData(newProductSupplier); try { if (!Product_SupplierDB.UpdateProduct_Supplier(productSupplier, newProductSupplier)) { MessageBox.Show("Another user has updated or " + "deleted that customer.", "Database Error"); this.DialogResult = DialogResult.Retry; } else { this.DialogResult = DialogResult.OK; } } catch (Exception ex) { throw ex; } } } }
//display product supplier private void DisplayProductSupplier() { productSuppliers = Product_SupplierDB.GetProduct_Supplier(); //getting product supplier from the database product_SupplierDataGridView.DataSource = productSuppliers; }