private void DeletePackage(Package pkg) { DialogResult result = MessageBox.Show("Delete the Package " + pkg.PkgName + "?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { // creates the other table objects List <Packages_Products_Suppliers> newpack_prod_sup = new List <Packages_Products_Suppliers>(); try // tries to delete the table records { // gets the data for the tasble records that need to be deleted newpack_prod_sup = Packages_Products_SuppliersDB.GetList(pkg.PackageId); // deletes each productsuppliers table record foreach (Packages_Products_Suppliers ps in newpack_prod_sup) { Packages_Products_SuppliersDB.DeletePackProdSup(ps); } // deletes the suppliercontacts record PackagesDB.DeletePackage(pkg); } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } RefreshPackages(); } }
// button to delete a package from the DB private void btnDelete_Click(object sender, EventArgs e) { if (dgvPackages.SelectedRows.Count > 0) { // sets the object to delete int index = dgvPackages.SelectedRows[0].Index; package = packages[index]; // asks user if they are sure DialogResult result = MessageBox.Show("Delete the Package " + package.PkgName + "?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { // creates the other table objects List <Packages_Products_Suppliers> newpack_prod_sup = new List <Packages_Products_Suppliers>(); try // tries to delete the table records { // gets the data for the tasble records that need to be deleted newpack_prod_sup = Packages_Products_SuppliersDB.GetList(package.PackageId); // deletes each productsuppliers table record foreach (Packages_Products_Suppliers ps in newpack_prod_sup) { Packages_Products_SuppliersDB.DeletePackProdSup(ps); } // deltes the suppliercontacts record PackagesDB.DeletePackage(package); // deltes the supplier record // redisplays the dgv packages = PackagesDB.GetAll(); refreshDGV(); } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } } else { MessageBox.Show("Please select a Product"); } }
private void btnDelete_Click(object sender, EventArgs e) { string tableName = cboTableNames.SelectedValue.ToString(); if (tableName == "Products") { DialogResult result = MessageBox.Show("Delete " + currentProd.ProdName + "?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { try { if (!ProductsDB.DeleteProduct(currentProd)) { MessageBox.Show("Another user has updated or deleted " + "that product.", "Database Error"); currentProd = ProductsDB.GetProductById(currentProd.ProductId); if (currentProd != null) { this.DisplayProductData(); } } else { this.DisplayProductData(); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } } else if (tableName == "Suppliers") { DialogResult result = MessageBox.Show("Delete " + currentSupplier.SupName + "?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { try { if (!SuppliersDB.DeleteSupplier(currentSupplier)) { MessageBox.Show("Another user has updated or deleted " + "that supplier.", "Database Error"); currentSupplier = SuppliersDB.GetSupplierById(currentSupplier.SupplierId); if (currentSupplier != null) { this.DisplaySupplierData(); } } else { this.DisplaySupplierData(); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } } else if (tableName == "Products_Suppliers") { DialogResult result = MessageBox.Show("Delete Product Supplier " + currentProductSupplier.ProductSupplierId + "?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { try { if (!Products_SuppliersDB.DeleteProductSupplier(currentProductSupplier)) { MessageBox.Show("Another user has updated or deleted " + "that product_supplier.", "Database Error"); currentProductSupplier = Products_SuppliersDB.GetProductSupplierById(currentProductSupplier.ProductSupplierId); if (currentProductSupplier != null) { this.DisplayCurrentProductSupplierData(); } this.DisplayProductSupplierData(); } else { this.DisplayCurrentProductSupplierData(); } this.DisplayProductSupplierData(); } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } } else if (tableName == "Packages") { DialogResult result = MessageBox.Show("Delete Packages " + currentPackage.PkgName + "?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { try { if (!PackagesDB.DeletePackage(currentPackage)) { MessageBox.Show("Another user has updated or deleted " + "that package.", "Database Error"); currentPackage = PackagesDB.GetPackageById(currentPackage.PackageId); if (currentPackage != null) { //this.DisplayCurrentProductSupplierData(); this.DisplayProductSupplierData(); } } else { //this.DisplayCurrentProductSupplierData(); this.DisplayPackages(); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } } }
// delete item button based on which radio button and item is selected private void btnDelete_Click(object sender, EventArgs e) { if (radPackages.Checked == false && radProducts.Checked == false && radSuppliers.Checked == false) { MessageBox.Show("Please select a database to delete from.", "Select a Database"); } else if (radPackages.Checked) { string i = lstView.SelectedItem.ToString(); string[] s = i.Split('|'); int packageId = Int32.Parse(s[0].Trim()); string nameSelected = s[1].Trim(); currentPackage = PackagesDB.GetPackageById(packageId); DialogResult result = MessageBox.Show("Delete Packages " + nameSelected + "?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { try { if (!PackagesDB.DeletePackage(currentPackage)) { MessageBox.Show("Another user has updated or deleted " + "that package.", "Database Error"); currentPackage = PackagesDB.GetPackageById(packageId); } else { this.DisplayPackages(); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } } else if (radProducts.Checked) { string i = lstView.SelectedItem.ToString(); string[] s = i.Split('|'); int productId = Int32.Parse(s[0].Trim()); string nameSelected = s[1].Trim(); currentProduct = ProductsDB.GetProductById(productId); DialogResult result = MessageBox.Show("Delete Product " + nameSelected + "?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { try { if (!ProductsDB.DeleteProduct(currentProduct)) { MessageBox.Show("Another user has updated or deleted " + "that package.", "Database Error"); currentProduct = ProductsDB.GetProductById(productId); } else { this.DisplayProducts(); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } } else if (radSuppliers.Checked) { string i = lstView.SelectedItem.ToString(); string[] s = i.Split('|'); int supplierId = Int32.Parse(s[0].Trim()); string nameSelected = s[1].Trim(); currentSupplier = SuppliersDB.GetSupplierById(supplierId); DialogResult result = MessageBox.Show("Delete Supplier " + nameSelected + "?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { try { if (!SuppliersDB.DeleteSupplier(currentSupplier)) { MessageBox.Show("Another user has updated or deleted " + "that package.", "Database Error"); currentSupplier = SuppliersDB.GetSupplierById(supplierId); } else { this.DisplaySuppliers(); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } } }