private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Are you sure you want to Save this Product?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string bid = "", cid = "";
conn.Open();
cmd = new SqlCommand("Select id from tblBrand where Brand like '" + TXT_brand.Text + "'", conn);
dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
bid = dr[0].ToString();
}
dr.Close();
conn.Close();
conn.Open();
cmd = new SqlCommand("Select id from Category where Category like '" + txt_cat.Text + "'", conn);
dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
cid = dr[0].ToString();
}
dr.Close();
conn.Close();
conn.Open();
cmd = new SqlCommand("insert into ProductTble(pcode,barcode,pdesc,bid,cid,Price)Values(@pcode,@barcode,@pdesc,@bid,@cid,@Price)", conn);
cmd.Parameters.AddWithValue("@pcode", txt_pcode.Text);
cmd.Parameters.AddWithValue("@barcode", txt_barcode.Text);
cmd.Parameters.AddWithValue("@pdesc", Txtdescription.Text);
cmd.Parameters.AddWithValue("@bid", bid);
cmd.Parameters.AddWithValue("@cid", cid);
cmd.Parameters.AddWithValue("@Price", txt_price.Text);
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Record inserted successfully");
clear();
frmlist.LoadProduct();
}
}
catch (Exception ex)
{
conn.Close();
MessageBox.Show(ex.Message);
}
}
private void button3_Click(object sender, EventArgs e)
{
ProductList list = new ProductList();
list.TopLevel = false;
panel3.Controls.Add(list);
list.LoadProduct();
list.BringToFront();
list.Show();
;
}
