private void btnAddProductSupplier_Click(object sender, EventArgs e) { addModifySup addProductSupplierForm = new addModifySup(); addProductSupplierForm.addProducts_suppliers_packages = true; DialogResult result = addProductSupplierForm.ShowDialog(); if (result == DialogResult.OK) { dataGridView1.DataSource = Products_suppliers_packagesDB.GetProducts_suppliers_packages(); } }
private void btnAccept_Click(object sender, EventArgs e) { if (IsValidData()) { if (addProducts_suppliers_packages) // processing Add { psp = new Products_suppliers_packages(); PutProducts_suppliers_packagesData(psp); try { Products_suppliers_packagesDB.AddProducts_suppliers_packages(psp); MessageBox.Show("New Item with Package Id of " + psp.packageId + " and productSupplier Id of " + psp.productSupplierId + " was added"); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } else // processing Modify { Products_suppliers_packages newProducts_suppliers_packages = new Products_suppliers_packages(); newProducts_suppliers_packages.packageId = Convert.ToInt32(pkgIDtextBox3.Text); newProducts_suppliers_packages.productSupplierId = Convert.ToInt32(prdSuppIDtextBox4.Text); PutProducts_suppliers_packagesData(newProducts_suppliers_packages); try { if (!Products_suppliers_packagesDB.UpdateProducts_suppliers_packages(modifyproducts_suppliers_packages, newProducts_suppliers_packages)) { MessageBox.Show("Another user has updated or " + "deleted that customer.", "Database Error"); this.DialogResult = DialogResult.Retry; } else { psp = newProducts_suppliers_packages; this.DialogResult = DialogResult.OK; } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } } }
private void btnModify_Click(object sender, EventArgs e) { var cells = dataGridView1.CurrentRow.Cells; string rowId = cells[0].Value.ToString(); string rowId1 = cells[1].Value.ToString(); //int rowId = Convert.ToInt32(cells[0].Value); var selectedSupplierID = Products_suppliers_packagesDB.GetProducts_suppliers_package(rowId, rowId1); addModifySup modifyproductsPackagesFrm = new addModifySup(); modifyproductsPackagesFrm.addProducts_suppliers_packages = false; modifyproductsPackagesFrm.modifyproducts_suppliers_packages = selectedSupplierID; DialogResult result = modifyproductsPackagesFrm.ShowDialog(); if (result == DialogResult.OK) { dataGridView1.DataSource = Products_suppliers_packagesDB.GetProducts_suppliers_packages(); } }
private void button2_Click(object sender, EventArgs e) { // get the key of the current product in the data grid view //int rowNum = dataGridView1.CurrentCell.RowIndex; // index of the current row //string PackageIDNos = dataGridView1[columnName: "packageIDDataGridViewTextBoxColumn", rowNum].Value.ToString(); // Column for PackageID //string Package_SupplierIDNos = dataGridView1[columnName: "productSupplierIdDataGridViewTextBoxColumn", rowNum].Value.ToString(); // Column for Package_SupplierID var cells = dataGridView1.CurrentRow.Cells; string rowId = cells[0].Value.ToString(); string rowId1 = cells[1].Value.ToString(); //int rowId = Convert.ToInt32(cells[0].Value); var selectedSupplierID = Products_suppliers_packagesDB.GetProducts_suppliers_package(rowId, rowId1); addModifySup modifyproductsPackagesFrm = new addModifySup(); modifyproductsPackagesFrm.addProducts_suppliers_packages = false; modifyproductsPackagesFrm.modifyproducts_suppliers_packages = selectedSupplierID; DialogResult result = modifyproductsPackagesFrm.ShowDialog(); if (result == DialogResult.OK) { dataGridView1.DataSource = Products_suppliers_packagesDB.GetProducts_suppliers_packages(); } }
private void frmProductSup_Load(object sender, EventArgs e) { dataGridView1.DataSource = Products_suppliers_packagesDB.GetProducts_suppliers_packages(); dataGridView1.Rows[0].Selected = true; }