// 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");
}
}
// retrieve a single package product and supplier data
public static Packages_Products_Suppliers GetPackProdSup(int PackageID)
{
//creating the object to store the orders information
Packages_Products_Suppliers pkgProdSup = null;
//opening a connection to SQL and inputting a query to access the specific orderIDs information
using (SqlConnection connection = TravelExpertsDB.GetConnection())
{
string query = "SELECT * " +
"FROM Packages " +
"WHERE PackageID = @PackageID";
using (SqlCommand cmd = new SqlCommand(query, connection))
{
cmd.Parameters.AddWithValue("@PackageID", PackageID);
connection.Open();
using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow))
{
//store values into the order object
if (reader.Read())
{
pkgProdSup = new Packages_Products_Suppliers();
pkgProdSup.PackageId = (int)reader["PackageId"];
pkgProdSup.ProductSupplierId = (int)reader["ProductSupplierId"];
}
}
}
}
return(pkgProdSup);
}// Get Packages and suppliers method completed
}// Get Packages and suppliers method completed
public static void AddPackageProduct(Packages_Products_Suppliers pkgPrdSup)
{
using (SqlConnection connection = TravelExpertsDB.GetConnection())
{
string insertStatement =
"INSERT INTO Packages_Products_Suppliers(PackageId, ProductSupplierId) " +
"VALUES(@PackageId, @ProductSupplierId)";
using (SqlCommand cmd = new SqlCommand(insertStatement, connection))
{
cmd.Parameters.AddWithValue("@PackageId", pkgPrdSup.PackageId);
cmd.Parameters.AddWithValue("@ProductSupplierId", pkgPrdSup.ProductSupplierId);
connection.Open();
cmd.ExecuteScalar(); // fixes problem of retrieving ID
}
}
}
public static bool DeletePackagePro(Packages_Products_Suppliers pkg)
{
int count = 0; // how many rows deleted
using (SqlConnection connection = TravelExpertsDB.GetConnection())
{
string deleteStatement =
"DELETE FROM Packages_Products_Suppliers " +
"WHERE PackageId = @PackageId ";
using (SqlCommand cmd = new SqlCommand(deleteStatement, connection))
{
cmd.Parameters.AddWithValue("@PackageId", pkg.PackageId);
connection.Open();
count = cmd.ExecuteNonQuery(); // DELETE statement return # affected rows
}
}
return(count > 0);
}
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();
}
}
}
