private void btnDeleteProduct_Click(object sender, EventArgs e) { //supName is equal to the selected items at index 0 to text string supName = (lvPkgDetails.Items[lvPkgDetails.SelectedItems[0].Index].Text); //suppID is equal to the result of the getProductId method taking supName as an argument int suppID = ProductsDB.getProductId(supName); //prodName is equal to the selected items at index 0, sub-item index 1 to text string prodName = lvPkgDetails.SelectedItems[0].SubItems[1].Text; //prodID is equal to the result of the getSupplierId method taking prodName as an argument int prodID = SuppliersDB.getSupplierId(prodName); //productSupplierID is equal to the result of the get_PpsID method taking suppID and prodID as arguments int psID = Products_SuppliersDB.Get_PpsID(suppID, prodID); // pkgID is equal to the result of the GetPackageIDBy_PsID method taking PsID as an argument int pkgID = PackagesDB.GetPackageIDBy_PsID(psID); bool exists = false; bool attempt = false; if (!exists) // if it does not exist, do this { try { // attempt = add product to package method, taking product supplier id and package id as arguments attempt = ProductsDB.deleteProductFromPkg(pkgID, psID); //MessageBox.Show("Succesfully deleted"); } catch (SqlException ex) { MessageBox.Show("Error modifying package\n" + ex); } if (attempt) { MessageBox.Show("Succesfully deleted"); lvPkgDetails.Items.Clear(); int i = 0; //int pkgID = lvPackages.Items.IndexOf(lvPackages.SelectedItems[i]); -- this is an old logic used List <Package_Product_Suppliers> pps_o = PackagesDB.GetProductSuppliersByPackage(pkgID); foreach (Package_Product_Suppliers pps in pps_o) { lvPkgDetails.Items.Add(pps.ProdName); lvPkgDetails.Items[i].SubItems.Add(pps.SupName); i += 1; } } } else { MessageBox.Show("Unable to delete"); } btnAddPackage.Visible = true; btnDeleteProduct.Visible = false; lvPkgDetails.Items.Clear(); }
private void btnConfirm_Click(object sender, EventArgs e) { if (cBSupplier.SelectedText != "") { string prodNameSelected = cBProduct.GetItemText(cBProduct.SelectedItem); //Get the product name for the selected product int prodIdSelected = ProductsDB.getProductId(prodNameSelected); //find the productId of the selected item // get thee supplier name from the combo box selection string supNameSelected = cBSupplier.GetItemText(cBSupplier.SelectedItem); // get the supplierID from the suppliername using the method in SuppliersDB int supplierIdSelected = SuppliersDB.getSupplierId(supNameSelected); // product supplier ID is equal to a method that retrieves it in a SQL Query int ppsID = Products_SuppliersDB.Get_PpsID(prodIdSelected, supplierIdSelected); // pkgID is equal to the selected ITEM at the index clicked to maintain consistency int pkgID = Convert.ToInt32(lvPackages.Items[lvPackages.SelectedItems[0].Index].Text); bool exists = false; bool attempt = false; if (!exists) // if it does not exist, do this { try { // attempt = add product to package method, taking product supplier id and package id as arguments attempt = PackagesDB.AddProdToPackage(ppsID, pkgID); } catch (SqlException ex) { MessageBox.Show("Error modifying package\n" + ex); } if (attempt) { MessageBox.Show("Succesfully modified"); int i = 0; lvPkgDetails.Items.Clear(); List <Package_Product_Suppliers> pps_o = PackagesDB.GetProductSuppliersByPackage(pkgID); foreach (Package_Product_Suppliers pps in pps_o) { lvPkgDetails.Items.Add(pps.ProdName); lvPkgDetails.Items[i].SubItems.Add(pps.SupName); i += 1; } } } else { MessageBox.Show("Package is already in the database"); } } else { MessageBox.Show("Please choose a valid supplier"); } }
private void lvPackages_SelectedIndexChanged(object sender, EventArgs e) { btnAddPackage.Visible = true; btnModify.Visible = true; btnDeleteProduct.Visible = false; // remove visibility for delete product button to avoid errors btnDeletePackage.Visible = true; // make delete package button visible btnAddProd.Visible = true; cBProduct.Visible = false; cBSupplier.Visible = false; lblProducts.Visible = false; lblSupplier.Visible = false; btnConfirm.Visible = false; pbPic.Visible = true; lblPkgName.Visible = true; cBProduct.Text = ""; if (lvPackages.SelectedItems.Count > 0) { lblPkgName.Text = lvPackages.SelectedItems[0].SubItems[1].Text; } lvPkgDetails.Items.Clear(); try { if (lvPackages.SelectedItems.Count > 0) { int i = 0; //int pkgID = lvPackages.Items.IndexOf(lvPackages.SelectedItems[i]); -- this is an old logic used int pkgID = Convert.ToInt32(lvPackages.Items[lvPackages.SelectedItems[0].Index].Text); selectedPackage = PackagesDB.GetPackageDetails(pkgID); List <Package_Product_Suppliers> pps_o = PackagesDB.GetProductSuppliersByPackage(pkgID); foreach (Package_Product_Suppliers pps in pps_o) { lvPkgDetails.Items.Add(pps.ProdName); lvPkgDetails.Items[i].SubItems.Add(pps.SupName); i += 1; } } } catch (SqlException ex) { throw ex; } }