// sets up the form on load
private void frmAddModifyPackages_Load(object sender, EventArgs e)
{
this.LoadProductComboBox();
// does the fiollowing if its a add
if (add)
{
this.Text = "Add a Package";
lblTitle.Text = "Add Package Information";
cmbProductBName.SelectedIndex = -1;
cmbSuppliers.DataSource = null;
}
//else does this for modify
else
{
this.Text = "Modify a Package";
lblTitle.Text = "Modify Package Information";
cmbProductBName.SelectedIndex = -1;
cmbSuppliers.DataSource = null;
try
{
pack_prod_sup = Packages_Products_SuppliersDB.GetList(package.PackageId);
this.DisplayPackages();
this.RedisplayList();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
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");
}
}
// button to add a product supplier to the package
private void btnProduct_Click(object sender, EventArgs e)
{
if (cmbProductBName.IsPresent())
{
if (add)
{
Packages_Products_Suppliers product = new Packages_Products_Suppliers();
product.ProductSupplierId = (int)cmbSuppliers.SelectedValue;
product.ProdName = cmbProductBName.Text;
product.SupName = cmbSuppliers.Text;
pack_prod_sup.Add(product);
RedisplayList();
cmbProductBName.SelectedIndex = -1;
cmbSuppliers.SelectedIndex = -1;
}
else
{
Packages_Products_Suppliers product = new Packages_Products_Suppliers();
product.ProductSupplierId = (int)cmbSuppliers.SelectedValue;
product.ProdName = cmbProductBName.Text;
product.SupName = cmbSuppliers.Text;
product.PackageId = package.PackageId;
try
{
Packages_Products_SuppliersDB.AddPackProdSupp(product);
pack_prod_sup = Packages_Products_SuppliersDB.GetList(package.PackageId);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
RedisplayList();
cmbProductBName.SelectedIndex = -1;
}
}
}
