private void btnUpdateSupplier_Click(object sender, EventArgs e) { if (Validation.IsPresent(txtSupplier, "Supplier Name", lblSuppError)) { updateSupplierName(lstSupplier.SelectedItem.ToString(), txtSupplier.Text); gridProductSuppliers.DataSource = Products_SuppliersDB.GetProductsSuppliers(); ResetPrdSupplierPage(); ResetProductSupllierList(); ResetSupplierList(); List <int> suppupdated = SuppliersDB.GetSupplierIDs(); List <string> supplier = new List <string>(); foreach (var sup in suppupdated) { supplier.Add(SuppliersDB.GetSupplier(sup).SupName); } comboSupplier.DataSource = supplier; List <int> prod = ProductsDB.GetProductID(); List <string> product = new List <string>(); foreach (var prd in prod) { product.Add(ProductsDB.GetProduct(prd).ProdName); } comboProduct.DataSource = null; comboProduct.DataSource = product; txtSupplier.Text = ""; lblSuppError.Text = ""; } }
// 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(); } } }
public void ResetProductSupllierList() { lstPkg.Items.Clear(); List <Packages> packupdated = PackagesDB.GetPackages(); foreach (var pkg in packupdated) { lstPkg.Items.Add(pkg.PkgName); } lstPkg.SelectedIndex = 0; productSupplierList = Products_SuppliersDB.GetProductsSuppliers(); var distinctPrd = productSupplierList.Select(o => o.ProdName).Distinct().ToList(); comboPrdPack.DataSource = distinctPrd; comboProduct.DataSource = product; comboSupplier.DataSource = supplier; listSuppPkg.Items.Clear(); foreach (var supname in productSupplierList) { if (supname.ProdName == comboPrdPack.SelectedItem.ToString()) { listSuppPkg.Items.Add(supname.SupName); } } }
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"); } }
// Editing Product_supplier table private void btnAddPrdSaveEdit_Click(object sender, EventArgs e) { updateProductname(gridProductSuppliers.CurrentRow.Cells[2].Value.ToString(), txtPrdSupPrdName.Text); updateSupplierName(gridProductSuppliers.CurrentRow.Cells[3].Value.ToString(), txtAddSupSupName.Text); gridProductSuppliers.DataSource = Products_SuppliersDB.GetProductsSuppliers(); ResetProductList(); ResetSupplierList(); ResetProductSupllierList(); ResetPrdSupplierPage(); }
// Adding Supplier to supplier table private void btnSaveAddSupp_Click(object sender, EventArgs e) { if (Validation.IsPresent(txtSupplier, "Supplier Name", lblSuppError)) { Suppliers suppAdd = new Suppliers(); List <int> supp = SuppliersDB.GetSupplierIDs(); var newsuppindex = supp[supp.Count - 1] + 1; suppAdd.SupplierID = newsuppindex; suppAdd.SupName = txtSupplier.Text; SuppliersDB.AddSupplier(suppAdd); gridProductSuppliers.DataSource = Products_SuppliersDB.GetProductsSuppliers(); List <int> suppupdated = SuppliersDB.GetSupplierIDs(); List <string> supplier = new List <string>(); foreach (var sup in suppupdated) { supplier.Add(SuppliersDB.GetSupplier(sup).SupName); } comboSupplier.DataSource = null; comboSupplier.DataSource = supplier; List <int> prod = ProductsDB.GetProductID(); List <string> product = new List <string>(); foreach (var prd in prod) { product.Add(ProductsDB.GetProduct(prd).ProdName); } comboProduct.DataSource = null; comboProduct.DataSource = product; ResetSupplierList(); ResetPrdSupplierPage(); ResetProductSupllierList(); txtSupplier.Text = ""; lblSuppError.Text = ""; } }
private void saveProdSup_Click(object sender, EventArgs e) { ResetPrdSupplierPage(); try { Products_Suppliers addPrdSupp = new Products_Suppliers(); List <int> prod = ProductsDB.GetProductID(); List <int> supp = SuppliersDB.GetSupplierIDs(); foreach (var item in prod) { if (comboProduct.SelectedItem.ToString() == ProductsDB.GetProduct(item).ProdName) { addPrdSupp.ProductId = item; } } foreach (var item in supp) { if (comboSupplier.SelectedItem.ToString() == SuppliersDB.GetSupplier(item).SupName) { addPrdSupp.SupplierId = item; } } Products_SuppliersDB.AddProdSupplier(addPrdSupp); gridProductSuppliers.DataSource = null; gridProductSuppliers.DataSource = Products_SuppliersDB.GetProductsSuppliers(); gridProductSuppliers.Columns[0].Visible = false; gridProductSuppliers.Columns[1].HeaderText = "Product Supplier ID"; gridProductSuppliers.Columns[2].HeaderText = "Product Name"; gridProductSuppliers.Columns[3].HeaderText = "Supplier Name"; gridProductSuppliers.Columns[1].Width = 150; gridProductSuppliers.Columns[2].Width = 300; gridProductSuppliers.Columns[3].Width = 300; ResetProductList(); ResetSupplierList(); ResetPrdSupplierPage(); ResetProductSupllierList(); } catch { lblPckProdError.Text = "Same Product Supplier Already Exist"; } }
// Adding Product to Product list ** Need Validation of Data private void btnAddSaveProd_Click(object sender, EventArgs e) { if (Validation.IsPresent(txtProductName, "Product Name", lblProdsError)) { Products prodAdd = new Products(); prodAdd.ProdName = txtProductName.Text; List <int> prod = ProductsDB.GetProductID(); List <string> product = new List <string>(); foreach (var prd in prod) { product.Add(ProductsDB.GetProduct(prd).ProdName); } comboProduct.DataSource = null; comboProduct.DataSource = product; List <int> suppupdated = SuppliersDB.GetSupplierIDs(); List <string> supplier = new List <string>(); foreach (var sup in suppupdated) { supplier.Add(SuppliersDB.GetSupplier(sup).SupName); } comboSupplier.DataSource = null; comboSupplier.DataSource = supplier; ProductsDB.AddProduct(prodAdd); gridProductSuppliers.DataSource = Products_SuppliersDB.GetProductsSuppliers(); ResetProductList(); ResetPrdSupplierPage(); ResetProductSupllierList(); txtProductName.Text = ""; lblProdsError.Text = ""; } }