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"); } }
// removes a product supplier from the list private void btnDelete_Click(object sender, EventArgs e) { if (dgvProducts.SelectedRows.Count > 0) { if (add) { pack_prod_sup.RemoveAt(this.dgvProducts.SelectedRows[0].Index); RedisplayList(); } else { DialogResult result = MessageBox.Show("Are you sure you want to delete this Product in the Package?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { int index = this.dgvProducts.SelectedRows[0].Index; try { if (!Packages_Products_SuppliersDB.DeletePackProdSup(pack_prod_sup[index])) { MessageBox.Show("That product has been updated or deleted already.", "Database Error"); } else { pack_prod_sup = Packages_Products_SuppliersDB.GetList(package.PackageId); this.RedisplayList(); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } } } else { MessageBox.Show("Please select a Product"); } }