private void BtnModify_Click(object sender, EventArgs e)
{
FrmAddModifyDelete modifyCustomerForm = new FrmAddModifyDelete
{
addproductsupplier = false,
productsupplier = productsupplier
};
DialogResult result = modifyCustomerForm.ShowDialog();
if (result == DialogResult.OK)
{
productsupplier = modifyCustomerForm.productsupplier;
this.DisplayProductSupplier();
//refresh the grid view
dataGridView1.DataSource = Product_supplierDB.GetSuppliers();
}
else if (result == DialogResult.Retry)
{
this.GetProductSupplierId(productsupplier.ProductSupplierId);
if (productsupplier != null)
{
this.DisplayProductSupplier();
}
else
{
this.ClearControls();
}
}
}
private void BtnModify_Click(object sender, EventArgs e)
{
var cells = dataGridView1.CurrentRow.Cells;
string rowId = cells[1].Value.ToString();
string rowId1 = cells[2].Value.ToString();
var selectedProductSupplierId = Product_supplierDB.GetSuppliers(rowId, rowId1);
FrmAddModifyDelete modifyCustomerForm = new FrmAddModifyDelete
{
addproductsupplier = false,
modifyproductsupplier = selectedProductSupplierId
};
DialogResult result = modifyCustomerForm.ShowDialog();
if (result == DialogResult.OK)
{
productsupplier = modifyCustomerForm.productsupplier;
//this.DisplayProductSupplier();
//refresh the grid view
dataGridView1.DataSource = Product_supplierDB.GetSuppliers();
}
//else if (result == DialogResult.Retry)
//{
// this.GetProductSupplierId(productsupplier.ProductSupplierId);
// if (productsupplier != null)
// this.DisplayProductSupplier();
// else
// this.ClearControls();
//}
}
private void GetProductSupplierId(int productSupplierID)
{
try
{
productsupplier = Product_supplierDB.GetProductSupplierId(productSupplierID);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
FrmAddModifyDelete addproductsupplierform = new FrmAddModifyDelete
{
addproductsupplier = true
};
DialogResult result = addproductsupplierform.ShowDialog();
if (result == DialogResult.OK)
{
productsupplier = addproductsupplierform.productsupplier;
dataGridView1.DataSource = Product_supplierDB.GetSuppliers();
}
}
private void BtnAccept_Click(object sender, EventArgs e)
{
if (IsValidData())
{
if (addproductsupplier) // processing Add
{
productsupplier = new suppliers();
this.PutProductSupplierData(productsupplier);
try
{
productsupplier.ProductSupplierId = Product_supplierDB.AddProductSupplier(productsupplier);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
else // processing Modify
{
suppliers newProductSupplier = new suppliers
{
ProductId = Convert.ToInt32(txtProductID.Text),
SupplierId = Convert.ToInt32(txtSupplierID.Text)
};
PutProductSupplierData(newProductSupplier);
try
{
if (!Product_supplierDB.UpdateProductSupplier(modifyproductsupplier, newProductSupplier))
{
MessageBox.Show("Another user has updated or " +
"deleted that product supplier ID.", "Database Error");
this.DialogResult = DialogResult.Retry;
}
else
{
productsupplier = newProductSupplier;
this.DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
}
private void BtnDelete_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Delete ProductID " + productsupplier.ProductSupplierId + "?",
"Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
try
{
if (!Product_supplierDB.DeleteProductSupplier(productsupplier))
{
MessageBox.Show("Another user has updated or deleted " +
"that Product Supplier ID.", "Database Error");
this.GetProductSupplierId(productsupplier.ProductSupplierId);
if (productsupplier != null)
{
this.DisplayProductSupplier();
}
else
{
this.ClearControls();
}
}
else
{
this.ClearControls();
//refresh gridview
dataGridView1.DataSource = Product_supplierDB.GetSuppliers();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
private void Form1_Load_1(object sender, EventArgs e)
{
dataGridView1.DataSource = Product_supplierDB.GetSuppliers();
dataGridView1.Rows[0].Selected = true;
}
