private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
var dialog = new MasterFile.Products();
string code = dataGridView1.Rows[e.RowIndex].Cells[colCode.Name].Value.ToString();
var dRow = DataSupport.RunDataSet("Select * from base_product join base_price on base_price.product_code = base_product.product_code where base_price.product_code ='" + code + "'").Tables[0];
if (dRow.Rows.Count > 0)
{
foreach (DataRow row in dRow.Rows)
{
dialog.txtproductCode.Text = row["product_code"].ToString();
dialog.txtCustCode.Text = row["customer_code"].ToString();
dialog.txtDescription.Text = row["description"].ToString();
dialog.dataGridView1.DataSource = DataSupport.RunDataSet("Select [uom],quantity,priceType,price from base_price where product_code ='" + code + "'").Tables[0];
}
}
else
{
var dt = DataSupport.RunDataSet("Select * from base_product where product_code ='" + code + "'").Tables[0];
foreach (DataRow row in dt.Rows)
{
dialog.txtproductCode.Text = row["product_code"].ToString();
dialog.txtCustCode.Text = row["customer_code"].ToString();
dialog.txtDescription.Text = row["description"].ToString();
}
}
Products.mode = "update";
dialog.txtproductCode.ReadOnly = true;
dialog.txtCustCode.ReadOnly = true;
dialog.ShowDialog();
display();
}
private void btnAdd_Click(object sender, EventArgs e)
{
var dialog = new MasterFile.Products();
Products.mode = "";
dialog.ShowDialog();
display();
}
