private void Btl_Insert_Click(object sender, EventArgs e) { if (Insert_GridView.SelectedRows.Count > 0) { product_suppliers itemToInsert = (product_suppliers)Insert_GridView.SelectedRows[0].DataBoundItem; foreach (package_product_supplier element in List_info) { if (element.Productname == itemToInsert.Productname && element.suppliername == itemToInsert.Suppliername) { MessageBox.Show("this information already exists,Please insert a new value"); } } if (Package_Product_SupplierDB.insert_info(InsertName, itemToInsert.Productname, itemToInsert.Suppliername)) { MessageBox.Show("Sucessfully Inserted"); } else { MessageBox.Show("Insert failure Please contact Administrator"); } /* * TravelExperts info = new TravelExperts(); * List_info = Package_Product_SupplierDB.getPackageinfo(InsertName); * info.DisplayBox_info(List_info); */ } else { MessageBox.Show("need to choose a row first"); } }
private void InsertForm_Load(object sender, EventArgs e) { product_list = Package_Product_SupplierDB.loadProduct(); supplier_list = Package_Product_SupplierDB.loadSuppliers(); Package_label.Text = InsertName.ToString(); display_packages(); }
private void PackageNameCombo_SelectedIndexChanged(object sender, EventArgs e) { name = PackageNameCombo.SelectedItem.ToString(); info = Package_Product_SupplierDB.getPackageinfo(name); DisplayBox_info(info); btlDelete.Visible = true; btlInsert.Visible = true; }
private void btlInsert_Click(object sender, EventArgs e) { SearchForm Insert_window = new SearchForm(name, info); Insert_window.ShowDialog(this); //this line will prevent the code after it executing if the name = PackageNameCombo.SelectedItem.ToString(); info = Package_Product_SupplierDB.getPackageinfo(name); DisplayBox_info(info); }
private void button2_Click(object sender, EventArgs e) { product_get = Product_box.SelectedItem.ToString(); supplier_get = Supplier_box.SelectedItem.ToString(); if (product_get == null || supplier_get == null) { MessageBox.Show("need to choose choose product type or suppliers"); } else { product_suppliers_list = Package_Product_SupplierDB.getProduct_Suppliers(product_get, supplier_get); DisplayBox_info(product_suppliers_list); } }
private void btlDelete_Click(object sender, EventArgs e) { if (product_supplier_packageBox.SelectedRows.Count > 0) { package_product_supplier itemToDelete = (package_product_supplier)product_supplier_packageBox.SelectedRows[0].DataBoundItem; Package_Product_SupplierDB.delete_info(itemToDelete.package_id, itemToDelete.Product_id, itemToDelete.supplier_id); name = PackageNameCombo.SelectedItem.ToString(); info = Package_Product_SupplierDB.getPackageinfo(name); DisplayBox_info(info); } else { MessageBox.Show("need to choose a row first"); } }
private void BtlUpdate_Click(object sender, EventArgs e) { if (Insert_GridView.SelectedRows.Count > 0) { product_suppliers itemToUpdate = (product_suppliers)Insert_GridView.SelectedRows[0].DataBoundItem; if (Package_Product_SupplierDB.Update_info(InsertName, selected.Productname, selected.suppliername, itemToUpdate.Productname, itemToUpdate.Suppliername)) { oldSupplier.Text = itemToUpdate.Suppliername.ToString(); oldProduct.Text = itemToUpdate.Productname.ToString(); MessageBox.Show("Row Updated"); } else { MessageBox.Show("Fail to Update please contact Administrator"); } //TravelExperts info = new TravelExperts(); //List_info = Package_Product_SupplierDB.getPackageinfo(InsertName); //info.DisplayBox_info(List_info); } else { MessageBox.Show("No rows selected."); } }
private void TravelExperts_Load(object sender, EventArgs e) { access = Package_Product_SupplierDB.loadPackage(); product_supplier_packageBox.ReadOnly = false; display_packages(); }