//******************************************************************* //* * //* MIKE * //* * //******************************************************************* // STEP 1 private void tabselection() { if (tabControl.SelectedIndex == 0) { if (cboPackageId.SelectedValue == null) { GetPackages(); int ID1 = Convert.ToInt32(cboPackageId.SelectedValue); load_table(); } } if (tabControl.SelectedIndex == 2) { this.GetProductsSuppliers(); } if (tabControl.SelectedIndex == 4) { cboProductName.DataSource = ProductDB.GetProducts(); cboProductName.DisplayMember = "ProdName"; cboProductName.ValueMember = "ProductId"; dataGridPackProdSup.DataSource = Packages_Products_SuppliersDB.GetPackages_Products_Supplierss(); } if (tabControl.SelectedIndex == 5) { GetPackages(); } }
// STEP 7 // ****************************************** // * PRODUCT ID COMBO BOX * // ****************************************** private void comboProdId_SelectedIndexChanged_1(object sender, EventArgs e) { List <Product> prods = new List <Product>(); Product prod = (Product)comboProdId.SelectedItem; prods.Add(prod); dataGridProduct.DataSource = prods; List <Product> products = ProductDB.GetProducts(); txtProductName.Text = products[Convert.ToInt32(comboProdId.SelectedIndex)].ProdName; prodold.ProdName = txtProductName.Text.ToString(); }
// STEP 6 // ****************************************** // * DELETE BUTTON * // ****************************************** private void txtProdDelete_Click_1(object sender, EventArgs e) { Product prod = new Product(); prod.ProdName = txtProductName.Text.ToString(); ProductDB.DeleteProduct(prod); //MessageBox.Show(prod.ProdName.ToString() + " has been successfully deleted from the database."); products = ProductDB.GetProducts(); comboProdId.DataSource = products; comboProdId.DisplayMember = "ProductId"; comboProdId.ValueMember = "ProductId"; }
// STEP 3 public void GetProducts() { try { products = ProductDB.GetProducts(); comboProdId.DataSource = products; comboProdId.DisplayMember = "ProductId"; comboProdId.ValueMember = "ProductId"; } //catch any database exceptions catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } }
// *********** // * STEP 0C * // *********** private void Form1_Load(object sender, EventArgs e) { //// Mike tabselection(); // Justin List <Product> products = ProductDB.GetProducts(); comboProdId.DataSource = products; comboProdId.DisplayMember = "ProductId"; // Ayi List <Supplier> suppliers = SupplierDB.GetSuppliers(); comboSupId.DataSource = suppliers; comboSupId.DisplayMember = "SupplierId"; }
// STEP 5 // ****************************************** // * UPDATE BUTTON * // ****************************************** private void btnUpdateProd_Click_1(object sender, EventArgs e) { if (Validator.IsPresent(txtProductName)) { Product prodnew = new Product(); //dataGridProduct prodnew.ProdName = txtProductName.Text.ToString(); ProductDB.UpdateProduct(prodold, prodnew); MessageBox.Show(prodold.ProdName.ToString() + " has been successfully updated in the database."); products = ProductDB.GetProducts(); comboProdId.DataSource = products; comboProdId.DisplayMember = "ProductId"; comboProdId.ValueMember = "ProductId"; } }
// STEP 4 // ****************************************** // * ADD BUTTON * // ****************************************** private void btnAddProd_Click_1(object sender, EventArgs e) { if (Validator.IsPresent(txtProductName)) { Product prod = new Product(); prod.ProdName = txtProductName.Text.ToString(); ProductDB.AddProduct(prod); MessageBox.Show(prod.ProdName.ToString() + " has been successfully added to the database."); products = ProductDB.GetProducts(); comboProdId.DataSource = products; comboProdId.DisplayMember = "ProductId"; comboProdId.ValueMember = "ProductId"; // comboProdId.SelectedValue = prod.ProdName; MessageBox.Show("Product was added!"); } }
// STEP 8 // ****************************************** // * GET PRODUCT BUTTON * // ****************************************** private void btnGetProd_Click(object sender, EventArgs e) { List <Product> products = ProductDB.GetProducts(); txtProductName.Text = products[Convert.ToInt32(comboProdId.SelectedIndex)].ProdName; }