/// <summary> /// Show suppliers of selected product /// </summary> /// @author Harry private void cmboBoxProducts_SelectedIndexChanged(object sender, EventArgs e) { // ensure there was a selection if (cmboBoxProducts.SelectedIndex > -1) { cmboBoxSupsOfProd.Text = ""; try { // get product id // NEED TO FIX SELECTED INDEX CAN BE GREATER THAN LENGTH OF SUPPLIERSOFPROD string prodName = (string)cmboBoxProducts.SelectedItem; int prodId = -1; foreach (Products p in products) { if (p.ProductName == prodName) { prodId = p.ProductID; } } // get suppliers of product suppliersOfProd = SuppliersDB.FindSuppliersOfProduct(prodId); cmboBoxSupsOfProd.Items.Clear(); // add to combo box foreach (Supplier sup in suppliersOfProd) { cmboBoxSupsOfProd.Items.Add(sup.SupName); } } catch (Exception ex) { MessageBox.Show("Error while loading suppliers\n" + ex.Message, ex.GetType().ToString()); } } }