// populate drop down with names of sup objects from the Suppliers list private void PopulateProdSuppliers() { // return list of suppliers created in GetProdSuppliers() List <ProdSupplier> prodSupplierList = ProdSuppliersDB.GetProdSuppliers(); // adding product supplier names to the CBName (combo box) var prodSupplierLinq = from prodSup in prodSupplierList select new { prodSup.ProductSupplierId }; foreach (var item in prodSupplierLinq) { cBID.Items.Add(item.ProductSupplierId); } }
// when name combo box (ddl) is used to select an object from the list private void cBID_SelectedIndexChanged(object sender, EventArgs e) { // return list of packages created in GetProdSuppliers() //List<ProdSupplier> prodSupplierList = ProdSuppliersDB.GetProdSuppliers(); //// if a selection is made from the combo box //if (cBID.SelectedIndex != -1) //{ // // display information about the selected product supplier // var prodSup = from selectedprodSup in prodSupplierList where // selectedprodSup.ProductSupplierId == Convert.ToInt32(cBID.Text) // select new // { // selectedprodSup.ProductId, // selectedprodSup.ProdName, // selectedprodSup.SupplierId, // selectedprodSup.SupName // }; // //return list of packages created in GetSuppliers() if (btnProdSupClicked && cBID.SelectedIndex != -1) { int temp = Convert.ToInt32(cBID.Text); if (temp != Convert.ToInt32(null)) { ProdSupplier prodSupplier = ProdSuppliersDB.GetProdSuppliersOBJECT(temp); cbProdID.Text = prodSupplier.ProdName.ToString(); cbSupID.Text = prodSupplier.SupName.ToString(); //cbProdID.Text = prodSup.ProdName.ToString(); //cbSupID.Text = prodSup.SupName.ToString(); //Maryam //SingleProdSup = prodSup; SingleProdSup = prodSupplier; //} } } }
private void PutProdSupplierData(ProdSupplier newProductSupplier) { try { selectedProduct = Convert.ToInt32(cboProdID.SelectedItem); prodSupplier.ProductId = selectedProduct; selectedSupplier = Convert.ToInt32(cboSupID.SelectedItem); prodSupplier.SupplierId = selectedSupplier; ProdSuppliersDB.AddNewProdSupplier(prodSupplier); this.DialogResult = DialogResult.OK; MessageBox.Show("Product Supplier has been saved"); } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } }
//when user selects a product in the product list, populate suppliers list private void cboProdList_SelectedIndexChanged(object sender, EventArgs e) { if (cboProdList.SelectedIndex < 00000000) { selectedProduct = null; product.ProductId = selectedProduct; } else { newProdSup = new ProdSupplier(); newProdSup.ProductId = Convert.ToInt32(cboProdList.Text); // return list of suppliers based on product ID from GetProdSuppliersBasedOnProductId cboSupplierList.DataSource = ProdSuppliersDB.GetProdSuppliersBasedOnProductId(newProdSup); cboSupplierList.DisplayMember = "SupplierId"; cboSupplierList.ValueMember = "ProductSupplierId"; } }
//Saving the Data in database private void btnSave_Click(object sender, EventArgs e) { bool updated = false; //if Supplier button is clicked if (btnSupClicked) { //Validating Supplier Table if (Validator1.IsProvidedCombo(cBName, "Supplier Name")) { Supplier newSup = new Supplier(); newSup.SupName = cBName.Text; //for new supplier name updated = SuppliersDB.UpdateSupplier(newSup, SingleSup); if (updated) { MessageBox.Show("Supplier Updated"); } else { MessageBox.Show("Supplier not Updated. Please try again."); } } } //If Products button is clicked if (btnProdClicked) { //Validating Product Table if (Validator1.IsProvidedCombo(cBName, "Product Name")) { Product NewProd = new Product(); NewProd.ProdName = cBName.Text; //for new Product name updated = ProductsDB.UpdateProducts(NewProd, SingleProd); if (updated) { MessageBox.Show("Products Updated"); } else { MessageBox.Show("Products not Updated. Please try again"); } } } if (btnProdSupClicked)// this does not work yet { //Validating Product-Supplier table if (Validator1.IsProvidedCombo(cbProdID, "Product Id") && Validator1.IsProvidedCombo(cbSupID, "Supplier Id")) { ProdSupplier newProdSupplier = new ProdSupplier(); newProdSupplier.ProductId = Convert.ToInt32(cbProdID.SelectedValue); newProdSupplier.SupplierId = Convert.ToInt32(cbSupID.SelectedValue); updated = ProdSuppliersDB.UpdateProdSupplier(newProdSupplier, SingleProdSup); if (updated) { MessageBox.Show("Product_Supplier is Updated"); } else { MessageBox.Show("Product_Supplier is not Updated. Please try again"); } } } if (btnPackClicked) // Otherwise just load Packages { //Validating data for Packages if (Validator1.IsProvidedCombo(cBName, "Package Name") && Validator1.IsProvided(txtDesc, "Describtion") && Validator1.IsProvided(txtBasePrice, "Base Price") && Validator1.IsProvided(txtAgencyComm, "Agency Commission")) { Package NewPackage = new Package(); NewPackage.PkgName = cBName.Text; //Start Date cannnot be greater then End Date if (dTPStartDate.Value.Date >= dTPEndDate.Value.Date) { MessageBox.Show("Package start date cannot be later than end date"); } //Agency commission cannot be greater then base price else if (Convert.ToDecimal(txtBasePrice.Text.Replace("$", "")) < (Convert.ToDecimal(txtAgencyComm.Text.Replace("$", "")))) { MessageBox.Show("Agency Comission cannot be more than Package Base price!"); } else { NewPackage.PkgStartDate = dTPStartDate.Value.ToString("yyyy-MM-dd"); NewPackage.PkgEndDate = dTPEndDate.Value.ToString("yyyy-MM-dd"); NewPackage.PkgDesc = txtDesc.Text; NewPackage.PkgBasePrice = Convert.ToDecimal(txtBasePrice.Text.Replace("$", "")); NewPackage.PkgAgencyCommission = Convert.ToDecimal(txtAgencyComm.Text.Replace("$", "")); updated = PackageDB.UpdatePackage(NewPackage, SinglePkg); } if (updated) { MessageBox.Show("Package is Updated"); } else { MessageBox.Show("Package is not Updated, Please try again."); } } } }