private void RefreshPackages()
{
frmMain.packageList = null;
frmMain.packageList = PackagesDB.GetAll();
PopulateTreeNode("rootPackages");
PopulateViewer("rootPackages");
}
private void mainForm_Load(object sender, EventArgs e)
{
packageList = PackagesDB.GetAll();
productList = ProductsDB.GetAll();
supplierList = SupplierDB.ListSupplier();
suppliersContactList = SupplierContactsDB.listSuppliers();
}
// loads the form
private void frmPackages_Load(object sender, EventArgs e)
{
try
{
packages = PackagesDB.GetAll();
refreshDGV();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
// 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");
}
}
// button to edit a package
private void btnEdit_Click(object sender, EventArgs e)
{
//creates the form and sets the options
int index = dgvPackages.SelectedRows[0].Index;
frmAddModifyPackages editfrm = new frmAddModifyPackages();
editfrm.add = false;
editfrm.package = packages[index];
DialogResult result = editfrm.ShowDialog();
if (result == DialogResult.OK)
{
try // if the edit for good redisplay the dgv
{
package = editfrm.package;
packages = PackagesDB.GetAll();
refreshDGV();
// selects the edited record
int n = -1;
foreach (Package sc in packages)
{
if (sc.PackageId == package.PackageId)
{
n = packages.IndexOf(sc);
break;
}
}
dgvPackages.Rows[n].Selected = true;
dgvPackages.FirstDisplayedScrollingRowIndex = n;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
// button to bring uo the add form
private void btnAdd_Click(object sender, EventArgs e)
{
// creates the new form and sets the options
frmAddModifyPackages newaddfrm = new frmAddModifyPackages();
newaddfrm.add = true;
DialogResult result = newaddfrm.ShowDialog();
// if the results are good redisplay the dgv
if (result == DialogResult.OK)
{
try // tries to get the data from the db and refresh the dgv
{
package = newaddfrm.package;
packages = PackagesDB.GetAll();
refreshDGV();
// select the newly made record
int n = -1;
foreach (Package pack in packages)
{
if (pack.PackageId == package.PackageId)
{
n = packages.IndexOf(pack);
break;
}
}
dgvPackages.Rows[n].Selected = true;
dgvPackages.FirstDisplayedScrollingRowIndex = n;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}