//*******************************************************************
//* *
//* 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;
}
