// Deleting Packages from Package
private void pkgdelete_Click(object sender, EventArgs e)
{
Packages pkgDel = new Packages();
Packages_Products_Suppliers pkgPrdDel = new Packages_Products_Suppliers();
List <Packages> pack = PackagesDB.GetPackages();
if (
Validation.IsListSelected(lstPkg, "Available Packages", lblError)
)
{
// delete confirmaiton message box with ok or cancel
if (MessageBox.Show("Delete Package?", "Delete Confirmation", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
lblError.Text = "";
foreach (var item in pack)
{
if (item.PackageId == Convert.ToInt32(txtpkgID.Text)) // txt box is one number ahead of newly added items
{
pkgDel.PackageId = item.PackageId;
pkgDel.PkgName = item.PkgName;
pkgDel.PkgStartDate = item.PkgStartDate;
pkgDel.PkgEndDate = item.PkgEndDate;
pkgDel.PkgDesc = item.PkgDesc;
pkgDel.PkgBasePrice = item.PkgBasePrice;
pkgDel.PkgAgencyCommission = item.PkgAgencyCommission;
}
}
var productSupplierid = from item in Products_SuppliersDB.GetProductsSuppliers()
where item.PackageId == Convert.ToInt32(txtpkgID.Text)
select new { item.ProductSupplierId };
Packages_Products_Suppliers pkgDelPro = new Packages_Products_Suppliers();
var id = productSupplierid.ToList();
foreach (var item in id)
{
pkgDelPro.ProductSupplierId = item.ProductSupplierId;
}
pkgDelPro.PackageId = Convert.ToInt32(txtpkgID.Text);
Packages_Products_SuppliersDB.DeletePackagePro(pkgDelPro);
PackagesDB.DeletePackage(pkgDel);
lstPkg.Items.Clear();
List <Packages> packupdatedel = PackagesDB.GetPackages();
foreach (var pkg in packupdatedel)
{
lstPkg.Items.Add(pkg.PkgName);
}
ResetPackage();
}
}
}
private void btnDeleteProdSupplier_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Delete Product?", "Delete Confirmation", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
var productSupplierID = gridProductSuppliers.CurrentRow.Cells[1].Value;
Products_Suppliers itemDelete = new Products_Suppliers();
Packages_Products_Suppliers pkgPrdDelete = new Packages_Products_Suppliers();
pkgPrdDelete.ProductSupplierId = Convert.ToInt32(productSupplierID);
itemDelete.ProductSupplierId = Convert.ToInt32(productSupplierID);
Packages_Products_SuppliersDB.DeletePackageProSupplierByID(pkgPrdDelete);
Products_SuppliersDB.DeleteProductsSuppliers(itemDelete);
gridProductSuppliers.DataSource = Products_SuppliersDB.GetProductsSuppliers();
ResetProductList();
ResetSupplierList();
ResetPrdSupplierPage();
ResetProductSupllierList();
}
}
catch
{
MessageBox.Show("Cannot Delete at this moment as this supplied id is linked with booking details table.Plaese select another one to delete");
}
}
private void PackProductUpdate()
{
var prodpacklistupdate = Packages_Products_SuppliersDB.GetPackProductsSuppliers();
var listProdPack = from prod in prodpacklistupdate
where prod.PackageId == Convert.ToInt32(txtpkgID.Text)
select new { prod.ProdName, prod.SupName };
listProdPack.ToList();
gridprdpkg.DataSource = listProdPack.ToList();
gridprdpkg.Columns[0].HeaderText = "Product Name";
gridprdpkg.Columns[1].HeaderText = "Supplier Name";
gridprdpkg.Columns[0].Width = 100;
gridprdpkg.Columns[1].Width = 200;
}
private void pkgProductAdd_Click(object sender, EventArgs e)
{
//shows an error message in a lable if informaiton is input incorrectly
if (
Validation.IsListSelected(lstPkg, "Available Packages", lblProdError) &&
Validation.IsListSelected(listSuppPkg, "Suppliers", lblProdError)
)
{
//clears error message if the error has been fixed
lblProdError.Text = "";
PackProductUpdate();
try
{
var productSupplierid = from item in productSupplierList
where item.ProdName == comboPrdPack.SelectedItem.ToString() && item.SupName == listSuppPkg.SelectedItem.ToString()
select new { item.ProductSupplierId };
Packages_Products_Suppliers pkgAddPro = new Packages_Products_Suppliers();
var id = productSupplierid.ToList();
foreach (var item in id)
{
pkgAddPro.ProductSupplierId = item.ProductSupplierId;
}
pkgAddPro.PackageId = Convert.ToInt32(txtpkgID.Text);
Packages_Products_SuppliersDB.AddPackageProduct(pkgAddPro);
PackProductUpdate();
}
catch
{
//error message
lblProdError.Text = "Product Already in the Packages OR Product/Suppleir not Selected for Add";
}
}
}
// Deleting Product From Packages
private void pkgProductDelete_Click(object sender, EventArgs e)
{
if (
Validation.IsListSelected(lstPkg, "Available Packages", lblProdError)
)
{
// if okay is selected in delete confirmation than continue
if (MessageBox.Show("Delete Package?", "Delete Confirmation", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
lblProdError.Text = "";
var pkgProductName = gridprdpkg.CurrentRow.Cells[0].Value.ToString();
var pkgSupplierName = gridprdpkg.CurrentRow.Cells[1].Value.ToString();
var pkgProductSupplierId = from item in productSupplierList
where item.ProdName == pkgProductName && item.SupName == pkgSupplierName
select new { item.ProductSupplierId };
Packages_Products_Suppliers pkgDeletePro = new Packages_Products_Suppliers();
var id = pkgProductSupplierId.ToList();
foreach (var item in id)
{
pkgDeletePro.ProductSupplierId = item.ProductSupplierId;
}
pkgDeletePro.PackageId = Convert.ToInt32(txtpkgID.Text);
Packages_Products_SuppliersDB.DeletePackageProSupplier(pkgDeletePro);
PackProductUpdate();
}
}
}
