private void btnAdd_Click(object sender, EventArgs e)
{
if (lstProdSup.SelectedIndex < 0) // no selection
{
MessageBox.Show("Please select product supplier to add");
}
else
{
Packages currentPackage = PackagesDB.GetPackageById((int)id);
string i = lstProdSup.SelectedItem.ToString();
string[] s = i.Split('|');
int prodSupId = Int32.Parse(s[0].Trim());
Products_Suppliers selectedProductSupplier = Products_SuppliersDB.GetProductSupplierById(prodSupId);
try
{
if (!Packages_Products_SuppliersDB.AddPackageProductSupplier(currentPackage.PackageId, selectedProductSupplier.ProductSupplierId))
{
MessageBox.Show("Product added", "Success!");
this.DialogResult = DialogResult.OK;
DisplayPackage();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
// ADD a supplier to current product click
private void btnAdd_Click(object sender, EventArgs e)
{
int index = cboSupplier.SelectedIndex;
int supId = suppliersList[index].SupplierId;
Products_Suppliers productsSuppliers = new Products_Suppliers();
if (supId < 1)
{
MessageBox.Show("Please select supplier to add");
}
else
{
try
{
int ProductSupplierId = Products_SuppliersDB.AddSupplierById((int)prodId, supId);
MessageBox.Show("Supplier added", "Success!");
this.DialogResult = DialogResult.OK;
Products_Suppliers ps = Products_SuppliersDB.GetProductSupplierById(ProductSupplierId);
currentProductSupplierIds.Add(ps);
DisplayProductSupplier();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
private void RadioButton3_CheckedChanged_1(object sender, EventArgs e)
{
//panelProductSuppliers.Show();20190604
//20190604--
panel25.BringToFront();
//panel25.Visible = true;
//--20190604
comboBox3.DataSource = ProductsDB.GetProducts();
comboBox3.DisplayMember = "ProdName";
comboBox3.ValueMember = "ProductId";
int fid;
bool parseOK = Int32.TryParse(comboBox3.SelectedValue.ToString(), out fid);
comboBox4.DataSource = Products_SuppliersDB.GetSuppliersByProductID(fid);
comboBox4.DisplayMember = "SupName";
comboBox4.ValueMember = "SupplierId";
comboBox7.DataSource = ProductsDB.GetProducts();
comboBox7.DisplayMember = "ProdName";
comboBox7.ValueMember = "ProductId";
comboBox6.DataSource = Products_SuppliersDB.GetSuppliersByProductID(fid);
comboBox6.DisplayMember = "SupName";
comboBox6.ValueMember = "SupplierId";
}
// DELETE a supplier to current product click
private void btnRemove_Click(object sender, EventArgs e)
{
string i = lstSuppliers.SelectedItem.ToString();
string[] s = i.Split('|');
int prodSupId = Int32.Parse(s[0].Trim());
Products_Suppliers productsSuppliers = new Products_Suppliers();
if (prodSupId < 1) // no selection
{
MessageBox.Show("Please select supplier to add");
}
else // user selected a product to add
{
try
{
this.DialogResult = DialogResult.OK;
Products_Suppliers ps = Products_SuppliersDB.GetProductSupplierById(prodSupId);
Products_SuppliersDB.DeleteProductSupplier(ps);
MessageBox.Show("Supplier deleted", "Success!");
loadData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
private void Button1_Click(object sender, EventArgs e)
{
int prodID = Convert.ToInt32(comboBox3.SelectedValue);
int supID = Convert.ToInt32(comboBox4.SelectedValue);
Products_SuppliersDB.AddPS(prodID, supID);
}
private void GetSupplier()
{
if (Int32.TryParse(productIdTextBox.Text, out int ProductId))
{
dgvSuppliers.DataSource = Products_SuppliersDB.GetSupplierByProducts(ProductId);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
int index = cboProducts.SelectedIndex;
int prodId = productsList[index].ProductId;
Products_Suppliers productsSuppliers = new Products_Suppliers();
if (prodId < 1) // no selection
{
MessageBox.Show("Please select supplier to add");
}
else // user selected a product to add
{
try
{
int ProductSupplierId = Products_SuppliersDB.AddSupplierById(prodId, (int)supId);
MessageBox.Show("Product deleted", "Success!");
this.DialogResult = DialogResult.OK;
Products_Suppliers ps = Products_SuppliersDB.GetProductSupplierById(ProductSupplierId); // selected product
//add selected product
currentProductSupplierIds.Add(ps); // add to current product supplier list
loadData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
//DisplayCurrentPackageProductSupplierData();
}
}
private void Button2_Click(object sender, EventArgs e)
{
int pid = Convert.ToInt32(comboBox7.SelectedValue);
int sid = Convert.ToInt32(comboBox6.SelectedValue);
int psid = Products_SuppliersDB.GetPSID_By_P_SID(pid, sid);
Products_SuppliersDB.UpdatePS(psid, pid, sid);
}
private void ComboBox7_SelectedIndexChanged(object sender, EventArgs e)
{
int fid;
bool parseOK = Int32.TryParse(comboBox7.SelectedValue.ToString(), out fid);
comboBox6.DataSource = Products_SuppliersDB.GetSuppliersByProductID(fid);
comboBox6.DisplayMember = "SupName";
comboBox6.ValueMember = "SupplierId";
}
private void DisplayProductSupplierData()
{
productSupplierIds = Products_SuppliersDB.GetProductSupplierIds();
lstProdSup.Items.Clear();//start with empty list box
lstProdSup.Items.Add("Id " + ": " + "Product Name" + ", " + "Supplier Name");
foreach (int id in productSupplierIds)
{
//Products_Suppliers ps = Products_SuppliersDB.GetProductSupplierById(id);
// lstProdSup.Items.Add(ps);
}
}
// display ProductSuppliers by DB method, passing through the productID inherited from main form
private List <Products_Suppliers> DisplayProductSupplier()
{
lstSuppliers.Items.Clear();
List <Products_Suppliers> productSuppliers = Products_SuppliersDB.ProductSuppliers((int)prodId);
foreach (Products_Suppliers psup in productSuppliers)
{
lstSuppliers.Items.Add(psup);
}
return(productSuppliers);
}
private void DisplayProductSupplier()
{
productSuppliers = Products_SuppliersDB.GetProductSupplier();
if (productSuppliers != null) // if we have product suppliers to display
{
lstView.Items.Clear(); //start with empty list box
foreach (Products_Suppliers prodsup in productSuppliers)
{
lstView.Items.Add(prodsup);
}
}
}
private void LoadSupplierBox(int id)
{
sList = Products_SuppliersDB.GetSuppliersByProductID(id);
listBox2.DataSource = null;
if (sList.Capacity != 0)
{
listBox2.DataSource = sList;
listBox2.DisplayMember = "SupName";
listBox2.SetSelected(0, true);
}
}
// btn to delete a record
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvSuppliers.SelectedRows.Count > 0)
{
// sets the object to delete
int index = dgvSuppliers.SelectedRows[0].Index;
suplierContact = suppliersContacts[index];
// asks user if they are sure
DialogResult result = MessageBox.Show("Delete the supplier " + suplierContact.SupConCompany + "?", "Confirm Delete",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
// creates the other table objects
Supplier supplier = new Supplier();
List <Products_Suppliers> products_suppliers = new List <Products_Suppliers>();
try // tries to delete the table records
{
// gets the data for the tasble records that need to be deleted
supplier = SupplierDB.GetSupplier(suplierContact.SupplierId);
products_suppliers = Products_SuppliersDB.GetAllProdSupOnID(suplierContact.SupplierId);
// deletes each productsuppliers table record
foreach (Products_Suppliers ps in products_suppliers)
{
Products_SuppliersDB.DeleteProdSup(ps);
}
// deltes the suppliercontacts record
SupplierContactsDB.DeleteSup(suplierContact);
// deltes the supplier record
SupplierDB.DeleteSup(supplier);
// redisplays the dgv
suppliersContacts = SupplierContactsDB.listSuppliers();
refreshDGV();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
else
{
MessageBox.Show("Please select a Product");
}
}
private void BtnAdd_Click(object sender, EventArgs e)
/*Adds a new Product to the Supplier by creating new Supplier and Product objects
* and getting the IDs from the appropriate control to pass as args.
* Added by Shanice Talan*/
{
TravelExpertsClass.Products prod = new TravelExpertsClass.Products(); //there's 2 Products.cs
Supplier sup = new Supplier();
prod.ProductsID = Convert.ToInt32(productIdTextBox.Text);
sup.SupplierID = Convert.ToInt32(supNameComboBox.SelectedValue);
Products_SuppliersDB.AddProductSupplier(sup, prod);
}
// load data if a SupplierID is passed from Main form
private void loadData()
{
lstProducts.Items.Clear();
List <Suppliers> supplierDetails = new List <Suppliers>();
List <Products_Suppliers> supplierProducts = new List <Products_Suppliers>();
supplierDetails = SuppliersDB.SupplierDetail((int)supId);
txtSupplierID.Text = supplierDetails[0].SupplierId.ToString();
txtSupName.Text = supplierDetails[0].SupName.ToString();
supplierProducts = Products_SuppliersDB.SupplierProducts((int)supId);
foreach (Products_Suppliers sprod in supplierProducts)
{
lstProducts.Items.Add(sprod);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
int index = lstPackProdSupp.SelectedIndex;
string i = lstPackProdSupp.SelectedItem.ToString();
string[] s = i.Split('|');
int pid = Int32.Parse(s[0].Trim());
//Packages_Products_Suppliers currentPackage = Packages_Products_SuppliersDB.GetPackageIds
if (pid < 1) // no selection
{
MessageBox.Show("Please select product supplier to delete");
}
else // user selected a product to delete
{
if (type == "View")
{
Products_Suppliers pps = Products_SuppliersDB.GetProductSupplierById(pid); // selected product
DialogResult answer =
MessageBox.Show("Are you sure to delete " + pps.ProdName + "?",
"Please Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (answer == DialogResult.Yes)
{
//delete selected package product supplier
try
{
if (!Packages_Products_SuppliersDB.DeletePackageProductSupplier((int)id, pps.ProductSupplierId))
{
MessageBox.Show("Another user has updated or deleted " +
"that product.", "Database Error");
}
else
{
currentProductSupplierIds.RemoveAt(index - 1);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
// remove from the current product supplier list
DisplayCurrentPackageProductSupplierData();
}
}
}
}
private void DisplayCurrentPackageProductSupplierData()
{
if (productSupplierIds != null) // if we have product suppliers to display
{
lstProductSupplierId.Items.Clear(); //start with empty list box
lstProductSupplierId.Items.Add("Id " + ": " + "Product Name" + ", " + "Supplier Name");
foreach (int id in productSupplierIds)
{
Products_Suppliers ps = Products_SuppliersDB.GetProductSupplierById(id);
lstProductSupplierId.Items.Add(ps);
}
}
else // null this product does not exist - need to refresh combo box
{
packageIds = Packages_Products_SuppliersDB.GetPackageIds();
}
}
// display ProductSupplier attached to package by DB method, passing through the packageID inherited from main form
private void DisplayCurrentPackageProductSupplierData()
{
if (currentProductSupplierIds != null) // if we have product suppliers to display
{
lstPackProdSupp.Items.Clear(); //start with empty list box
lstPackProdSupp.Items.Add("Id " + ": " + "Product Name" + ", " + "Supplier Name");
foreach (int id in currentProductSupplierIds)
{
Products_Suppliers ps = Products_SuppliersDB.GetProductSupplierById((int)id);
lstPackProdSupp.Items.Add(ps);
}
}
else
{
lstPackProdSupp.Items.Clear();
}
}
// if product combo box selected item changes updates the suppliers combobox
private void cmbProductBName_SelectedIndexChanged(object sender, EventArgs e)
{
List <Products_Suppliers> cbSuppliers = new List <Products_Suppliers>();
try
{
if (cmbProductBName.SelectedIndex != -1)
{
cbSuppliers = Products_SuppliersDB.GetAllProdSupOnProdID((int)cmbProductBName.SelectedValue);
cmbSuppliers.DataSource = cbSuppliers;
cmbSuppliers.DisplayMember = "SupName";
cmbSuppliers.ValueMember = "ProductSupplierId";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
// button to delete fa product from the list of products
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvProducts.SelectedRows.Count > 0)
{
// for adding
if (add)
{
productSuppliers.RemoveAt(this.dgvProducts.SelectedRows[0].Index);
RedisplayList();
}
//for modifing
else
{
DialogResult result = MessageBox.Show("Are you sure you want to delete this Product offered by Supplier?",
"Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
int index = this.dgvProducts.SelectedRows[0].Index;
try
{
if (!Products_SuppliersDB.DeleteProdSup(productSuppliers[index]))
{
MessageBox.Show("That product has been updated or deleted already.", "Database Error");
}
else
{
productSuppliers = Products_SuppliersDB.GetAllProdSupOnID(supplierContact.SupplierId);
this.RedisplayList();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
}
else
{
MessageBox.Show("Please select a Product");
}
}
private void PopulateViewer(string NodeName, string ParentNodeName)
{
uxListView.Columns.Clear();
uxListView.Items.Clear();
switch (ParentNodeName)
{
case "rootPackages":
uxListView.Columns.Add("Product Name", 150);
uxListView.Columns.Add("Supplier Name", 150);
List <Products_Suppliers> package_products = Products_SuppliersDB.GetProductsByPackageName(NodeName);
foreach (Products_Suppliers item in package_products)
{
uxListView.Items.Add(new ListViewItem(new string[] { item.productName, item.SupName }));
}
break;
case "rootProducts":
uxListView.Columns.Add("Product Name", 75);
uxListView.Columns.Add("Supplier Name", 150);
List <Products_Suppliers> product_suppliers = Products_SuppliersDB.GetSuppliersByProductName(NodeName);
foreach (Products_Suppliers item in product_suppliers)
{
uxListView.Items.Add(new ListViewItem(new string[] { item.productName, item.SupName }));
}
break;
case "rootSuppliers":
uxListView.Columns.Add("Supplier Name", 250);
uxListView.Columns.Add("Product Name", 150);
List <Products_Suppliers> supplier_products = Products_SuppliersDB.GetProductsBySupplierName(NodeName);
foreach (Products_Suppliers item in supplier_products)
{
uxListView.Items.Add(new ListViewItem(new string[] { item.SupName, item.productName }));
}
break;
default:
;
break;
}
}
private void btnAccept_Click(object sender, EventArgs e)
{
if (addProductSupplier)
{
productSupplier = new Products_Suppliers();
this.PutProductSupplierData(productSupplier);
try
{
productSupplier.ProductSupplierId = Products_SuppliersDB.AddProductSupplier(productSupplier);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
else
{
Products_Suppliers newProductSupplier = new Products_Suppliers();
newProductSupplier.ProductSupplierId = productSupplier.ProductSupplierId;
this.PutProductSupplierData(newProductSupplier);
try
{
if (!Products_SuppliersDB.UpdateProductSupplier(productSupplier, newProductSupplier))
{
MessageBox.Show("Another user has updated or " +
"deleted that product supplier.", "Database Error");
this.DialogResult = DialogResult.Retry;
}
else
{
productSupplier = newProductSupplier;
this.DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
private void DeleteSupplier(Supplier sp)
{
SupplierContacts suplierContact = SupplierContactsDB.GetSupplierbySupID(sp.SupplierId);
// asks user if they are sure
DialogResult result = MessageBox.Show("Delete the supplier " + suplierContact.SupConCompany + "?", "Confirm Delete",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
// creates the other table objects
Supplier supplier = new Supplier();
List <Products_Suppliers> products_suppliers = new List <Products_Suppliers>();
try // tries to delete the table records
{
// gets the data for the tasble records that need to be deleted
supplier = SupplierDB.GetSupplier(suplierContact.SupplierId);
products_suppliers = Products_SuppliersDB.GetAllProdSupOnID(suplierContact.SupplierId);
// deletes each productsuppliers table record
foreach (Products_Suppliers ps in products_suppliers)
{
Products_SuppliersDB.DeleteProdSup(ps);
}
// deletes the suppliercontacts record
SupplierContactsDB.DeleteSup(suplierContact);
// deletes the supplier record
SupplierDB.DeleteSup(supplier);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
RefreshSuppliers();
}
}
// button to add a product to the supplier
private void btnProduct_Click(object sender, EventArgs e)
{
if (cmbProductBName.IsPresent())
{
// for adding a supplier
if (add)
{
Products_Suppliers product = new Products_Suppliers();
product.productid = (int)cmbProductBName.SelectedValue;
product.productName = cmbProductBName.Text;
productSuppliers.Add(product);
RedisplayList();
cmbProductBName.SelectedIndex = -1;
}
//for modifing a supplier
else
{
Products_Suppliers product = new Products_Suppliers();
product.productid = (int)cmbProductBName.SelectedValue;
product.productName = cmbProductBName.Text;
product.supplierid = supplier.SupplierId;
try
{
Products_SuppliersDB.AddProdSupp(product);
productSuppliers = Products_SuppliersDB.GetAllProdSupOnID(supplierContact.SupplierId);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
RedisplayList();
cmbProductBName.SelectedIndex = -1;
}
}
}
// sets up the form on load
private void frmAddModifySupplier_Load(object sender, EventArgs e)
{
this.LoadProductComboBox();
// does the fiollowing if its a add
if (this.add)
{
// find the next availble supplierid and suppliercontactid
supplierContact.SupplierContactId = SupplierContactsDB.GetNextAvailableID();
txtSCID.Text = supplierContact.SupplierContactId.ToString();
supplierContact.SupplierId = SupplierDB.GetNextAvailableID();
supplier.SupplierId = SupplierDB.GetNextAvailableID();
this.Text = "Add a Supplier";
lblTitle.Text = "Add Supplier Information";
cmbProductBName.SelectedIndex = -1;
}
//else does this for modify
else
{
this.Text = "Modify a Supplier";
lblTitle.Text = "Modify Supplier Information";
try
{
supplier = SupplierDB.GetSupplier(supplierContact.SupplierId);
productSuppliers = Products_SuppliersDB.GetAllProdSupOnID(supplierContact.SupplierId);
this.DisplaySupplier();
this.RedisplayList();
cmbProductBName.SelectedIndex = -1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
private void cboTableNames_SelectedIndexChanged(object sender, EventArgs e)
{
string tableName = cboTableNames.SelectedValue.ToString();
if (tableName == "Products")
{
pnlName.Visible = true;
pnlName2.Visible = false;
lblId.Text = "Product Id";
productIds = ProductsDB.GetProductsIds();
if (productIds.Count > 0) // if there are prodcuts
{
cboId.DataSource = productIds;
cboId.SelectedIndex = 0; // triggers SelectedIndexChanged
}
else // no members
{
MessageBox.Show("There are no products. " +
"Add some products in the database, and restart the application ", "Empty Load");
Application.Exit();
}
DisplayProductData();
}
else if (tableName == "Suppliers")
{
lblId.Text = "Supplier Id";
supplierIds = SuppliersDB.GetSuppliersIds();
pnlName.Visible = true;
pnlName2.Visible = false;
if (supplierIds.Count > 0) // if there are suppliers
{
cboId.DataSource = supplierIds;
cboId.SelectedIndex = 0; // triggers SelectedIndexChanged
}
else // no members
{
MessageBox.Show("There are no suppliers. " +
"Add some supplier in the database, and restart the application ", "Empty Load");
Application.Exit();
}
DisplaySupplierData();
}
else if (tableName == "Products_Suppliers")
{
lblId.Text = "ProductSupplier Id";
lblName.Text = "Product Name";
lblName2.Text = "Supplier Name";
pnlName.Visible = true;
pnlName2.Visible = true;
productSupplierIds = Products_SuppliersDB.GetProductSupplierIds();
if (productSupplierIds.Count > 0) // if there are suppliers
{
cboId.DataSource = productSupplierIds;
cboId.SelectedIndex = 0; // triggers SelectedIndexChanged
}
else // no members
{
MessageBox.Show("There are no product_suppliers. " +
"Add some product_supplier in the database, and restart the application ", "Empty Load");
Application.Exit();
}
DisplayProductSupplierData();
}
else if (tableName == "Packages_Products_Suppliers")
{
lblId.Text = "Package Id";
packageIds = Packages_Products_SuppliersDB.GetPackageIds();
pnlName.Visible = false;
pnlName2.Visible = false;
if (packageIds.Count > 0) // if there are packages
{
cboId.DataSource = packageIds;
cboId.SelectedIndex = 0; // triggers SelectedIndexChanged
}
else // no members
{
MessageBox.Show("There are no packages with products_suppliers. " +
"Add some packages with product_supplier in the database, and restart the application ", "Empty Load");
Application.Exit();
}
}
else if (tableName == "Packages")
{
lblId.Text = "Package Id";
pnlName.Visible = true;
pnlName2.Visible = false;
packageIds = PackagesDB.GetPackageIds();
DisplayPackages();
if (packageIds.Count > 0) // if there are suppliers
{
cboId.DataSource = packageIds;
cboId.SelectedIndex = 0; // triggers SelectedIndexChanged
}
else // no members
{
MessageBox.Show("There are no packages. " +
"Add some packages in the database, and restart the application ", "Empty Load");
Application.Exit();
}
}
}
private void DisplayCurrentProductSupplierData()
{
currentProductSupplier = Products_SuppliersDB.GetProductSupplierById(currentProductSupplier.ProductSupplierId);
txtName.Text = currentProductSupplier.ProdName;
txtName2.Text = currentProductSupplier.SupName;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
string tableName = cboTableNames.SelectedValue.ToString();
if (tableName == "Products")
{
frmAddUpdateProducts updateProductForm = new frmAddUpdateProducts();
updateProductForm.addProduct = false;
updateProductForm.product = currentProd;
DialogResult result = updateProductForm.ShowDialog();
if (result == DialogResult.OK)
{
currentProd = updateProductForm.product;
this.DisplayProductData();
}
else if (result == DialogResult.Retry)
{
currentProd = ProductsDB.GetProductById(currentProd.ProductId);
if (currentProd != null)
{
this.DisplayProductData();
}
}
}
else if (tableName == "Suppliers")
{
frmAddUpdateSuppliers updateSupplierForm = new frmAddUpdateSuppliers();
updateSupplierForm.addSupplier = false;
updateSupplierForm.supplier = currentSupplier;
DialogResult result = updateSupplierForm.ShowDialog();
if (result == DialogResult.OK)
{
currentSupplier = updateSupplierForm.supplier;
this.DisplaySupplierData();
}
else if (result == DialogResult.Retry)
{
currentSupplier = SuppliersDB.GetSupplierById(currentSupplier.SupplierId);
if (currentSupplier != null)
{
this.DisplaySupplierData();
}
}
}
else if (tableName == "Products_Suppliers")
{
frmAddUpdateProductSupplier updateProductSupplierForm = new frmAddUpdateProductSupplier();
updateProductSupplierForm.addProductSupplier = false;
updateProductSupplierForm.productSupplier = currentProductSupplier;
DialogResult result = updateProductSupplierForm.ShowDialog();
if (result == DialogResult.OK)
{
this.DisplayCurrentProductSupplierData();
this.DisplayProductSupplierData();
}
else if (result == DialogResult.Retry)
{
currentProductSupplier = Products_SuppliersDB.GetProductSupplierById(currentProductSupplier.ProductSupplierId);
if (currentProductSupplier != null)
{
this.DisplayCurrentProductSupplierData();
}
this.DisplayProductSupplierData();
}
}
else if (tableName == "Packages")
{
frmAddUpdatePackages updatePackageForm = new frmAddUpdatePackages();
updatePackageForm.addPackage = false;
updatePackageForm.package = currentPackage;
updatePackageForm.currentProductSupplierIds = Packages_Products_SuppliersDB.GetProductSupplierIds(currentPackage.PackageId);
DialogResult result = updatePackageForm.ShowDialog();
if (result == DialogResult.OK)
{
this.DisplayPackages();
DisplayCurrentPackageProductSupplierData();
}
else if (result == DialogResult.Retry)
{
currentPackage = PackagesDB.GetPackageById(currentPackage.PackageId);
if (currentPackage != null)
{
DisplayCurrentPackageProductSupplierData();
}
this.DisplayPackages();
}
}
}
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());
}
}
}
}
