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;
}
}