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