private void DisplayComboBoxes() { List <ProductsSuppliers> prodid = new List <ProductsSuppliers>(); List <ProductsSuppliers> supid = new List <ProductsSuppliers>(); try { prodid = ProductSupplierIdDB.GetUniqueProSupId("p"); supid = ProductSupplierIdDB.GetUniqueProSupId("s"); cboProdId.DataSource = prodid; cboProdId.DisplayMember = "ProdName"; cboProdId.ValueMember = "ProductId"; cboSupId.DataSource = supid; cboSupId.DisplayMember = "SupName"; cboSupId.ValueMember = "SupplierId"; if (!addProductsSuppler) { cboProdId.SelectedValue = productsupplier.ProductId; cboSupId.SelectedValue = productsupplier.SupplierId; } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } }
// STEP 3 private void cboProductsSupplierrId_SelectedIndexChanged(object sender, EventArgs e) { int pid = 0; try { pid = Convert.ToInt32(cboProductsSupplierrId.SelectedValue); } catch { } SelectedPS = ProductSupplierIdDB.GetSelected(pid); this.DisplayPS(SelectedPS); }
//Alex private void cboSupplierName_SelectedIndexChanged(object sender, EventArgs e) { if (cboSupplierName.SelectedIndex != 0) { int selectedprodid = Convert.ToInt32(cboProductName.SelectedIndex); selectedprodid = selectedprodid + 1; int sup = (int)cboSupplierName.SelectedValue; //int selectedsupplier = sup.SupplierId; cboPSPPS.DataSource = ProductSupplierIdDB.GetProductSupplierId2Inputs(selectedprodid, sup); cboPSPPS.ValueMember = "ProductSupplierId"; cboPSPPS.DisplayMember = "ProductSupplierId"; } }
//******************************************************************* //* * //* ALEX * //* * //******************************************************************* // STEP 1 public void GetProductsSuppliers() { List <ProductsSuppliers> productssupplierid = new List <ProductsSuppliers>(); try { productssupplierid = ProductSupplierIdDB.GetProductsSupplierId(); cboProductsSupplierrId.DataSource = productssupplierid; cboProductsSupplierrId.DisplayMember = "ProductSupplierId"; cboProductsSupplierrId.ValueMember = "ProductSupplierId"; } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } }
private void btnAccept_Click(object sender, EventArgs e) { if (Validator.IsPresent(cboProdId) && Validator.IsPresent(cboSupId)) { if (addProductsSuppler) { productsupplier = new ProductsSuppliers(); this.PutProductSupplierData(productsupplier); try { productsupplier.ProductSupplierId = ProductSupplierIdDB.AddProductSupplier(productsupplier); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } else { ProductsSuppliers newProductSupplier = new ProductsSuppliers(); newProductSupplier.ProductSupplierId = productsupplier.ProductSupplierId; this.PutProductSupplierData(newProductSupplier); try { if (!ProductSupplierIdDB.UpdateProductSupplier(productsupplier, newProductSupplier)) { MessageBox.Show("Another user has updated or " + "deleted that Product Supplier.", "Database Error"); this.DialogResult = DialogResult.Retry; } else { productsupplier = newProductSupplier; this.DialogResult = DialogResult.OK; } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } } }
private void btnDeletePS_Click(object sender, EventArgs e) { int ps; ps = ((int)cboProductsSupplierrId.SelectedValue); bool logic = ProductSupplierIdDB.Delete(ps); this.GetProductsSuppliers(); if (logic == true) { MessageBox.Show("You have Deleted Products Suplliers combination!"); } else { MessageBox.Show("Delete product from pachages first!"); } }
//Alex private void cboProductName_SelectedIndexChanged(object sender, EventArgs e) { int selectedprodid = Convert.ToInt32(cboProductName.SelectedIndex); selectedprodid = selectedprodid + 1; cboSupplierName.DataSource = ProductSupplierIdDB.GetSupplierName(selectedprodid); cboSupplierName.DisplayMember = "SupName"; cboSupplierName.ValueMember = "SupplierId"; int?selectedsupplier = (int?)cboSupplierName.SelectedValue; if (selectedsupplier != null) { cboPSPPS.DataSource = ProductSupplierIdDB.GetProductSupplierId2Inputs(selectedprodid, selectedsupplier); } else { MessageBox.Show("This selection does not have existing suplliers, add a supplier first"); } //cboPSPPS.DataSource=ProductSupplierIdDB.Get }
// STEP 2 public void GetPackages() { try { packages = PackagesDB.GetPackages(); cboPackageId.DataSource = packages; cboPackageId.DisplayMember = "PackageId"; cboPackageId.ValueMember = "PackageId"; packages2 = PackagesDB.GetPackages(); cboPkgPPS.DataSource = packages2; cboPkgPPS.DisplayMember = "PackageId"; cboPkgPPS.ValueMember = "PackageId"; List <ProductsSuppliers> productssupplierid = new List <ProductsSuppliers>(); productssupplierid = ProductSupplierIdDB.GetProductsSupplierId(); cboPSPPS.DataSource = productssupplierid; cboPSPPS.DisplayMember = "ProductSupplierId"; cboPSPPS.ValueMember = "ProductSupplierId"; } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } }