// 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(); } } }