private void DisplayCurrentSupplierData() { if (currentSupplier != null) { txtName.Text = currentSupplier.SupName; } else // null this product does not exist - need to refresh combo box { supplierIds = SuppliersDB.GetSuppliersIds(); } }
private void frmAddUpdateProductSupplier_Load(object sender, EventArgs e) { productIds = ProductsDB.GetProductsIds(); cboProdId.DataSource = productIds; supplierIds = SuppliersDB.GetSuppliersIds(); cboSupplierId.DataSource = supplierIds; if (addProductSupplier) { this.Text = "Add Product Supplier"; cboProdId.SelectedIndex = 0; cboSupplierId.SelectedIndex = 0; } else { this.Text = "Update Product Supplier"; this.DisplayCustomer(); } }
private void DisplaySupplierData() { supplierIds = SuppliersDB.GetSuppliersIds(); cboId.DataSource = supplierIds; if (supplierIds != null) { txtName.Text = currentSupplier.SupName; cboId.SelectedItem = currentSupplier.SupplierId; lstView.Items.Clear();//start with empty list box lstView.Items.Add("Id " + ": " + "Supplier Name"); foreach (int id in supplierIds) { Suppliers s = SuppliersDB.GetSupplierById(id); lstView.Items.Add(s); } } else // null this product does not exist - need to refresh combo box { supplierIds = SuppliersDB.GetSuppliersIds(); } }
private void cboTableNames_SelectedIndexChanged(object sender, EventArgs e) { string tableName = cboTableNames.SelectedValue.ToString(); if (tableName == "Products") { pnlName.Visible = true; pnlName2.Visible = false; lblId.Text = "Product Id"; productIds = ProductsDB.GetProductsIds(); if (productIds.Count > 0) // if there are prodcuts { cboId.DataSource = productIds; cboId.SelectedIndex = 0; // triggers SelectedIndexChanged } else // no members { MessageBox.Show("There are no products. " + "Add some products in the database, and restart the application ", "Empty Load"); Application.Exit(); } DisplayProductData(); } else if (tableName == "Suppliers") { lblId.Text = "Supplier Id"; supplierIds = SuppliersDB.GetSuppliersIds(); pnlName.Visible = true; pnlName2.Visible = false; if (supplierIds.Count > 0) // if there are suppliers { cboId.DataSource = supplierIds; cboId.SelectedIndex = 0; // triggers SelectedIndexChanged } else // no members { MessageBox.Show("There are no suppliers. " + "Add some supplier in the database, and restart the application ", "Empty Load"); Application.Exit(); } DisplaySupplierData(); } else if (tableName == "Products_Suppliers") { lblId.Text = "ProductSupplier Id"; lblName.Text = "Product Name"; lblName2.Text = "Supplier Name"; pnlName.Visible = true; pnlName2.Visible = true; productSupplierIds = Products_SuppliersDB.GetProductSupplierIds(); if (productSupplierIds.Count > 0) // if there are suppliers { cboId.DataSource = productSupplierIds; cboId.SelectedIndex = 0; // triggers SelectedIndexChanged } else // no members { MessageBox.Show("There are no product_suppliers. " + "Add some product_supplier in the database, and restart the application ", "Empty Load"); Application.Exit(); } DisplayProductSupplierData(); } else if (tableName == "Packages_Products_Suppliers") { lblId.Text = "Package Id"; packageIds = Packages_Products_SuppliersDB.GetPackageIds(); pnlName.Visible = false; pnlName2.Visible = false; if (packageIds.Count > 0) // if there are packages { cboId.DataSource = packageIds; cboId.SelectedIndex = 0; // triggers SelectedIndexChanged } else // no members { MessageBox.Show("There are no packages with products_suppliers. " + "Add some packages with product_supplier in the database, and restart the application ", "Empty Load"); Application.Exit(); } } else if (tableName == "Packages") { lblId.Text = "Package Id"; pnlName.Visible = true; pnlName2.Visible = false; packageIds = PackagesDB.GetPackageIds(); DisplayPackages(); if (packageIds.Count > 0) // if there are suppliers { cboId.DataSource = packageIds; cboId.SelectedIndex = 0; // triggers SelectedIndexChanged } else // no members { MessageBox.Show("There are no packages. " + "Add some packages in the database, and restart the application ", "Empty Load"); Application.Exit(); } } }