private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Are you sure! you want to update this Product?", "Save Product", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string cid = "";
sqlcon.Open();
cm = new SqlCommand("Select id from tblCategory where category like '" + cboCategory.Text + "'", sqlcon);
dr = cm.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
cid = dr[0].ToString();
}
dr.Close();
sqlcon.Close();
sqlcon.Open();
cm = new SqlCommand("INSERT INTO tblProduct (code, detail, cid, price,quantity) VALUES(@pcode, @detail, @cid, @price,@quantity) ", sqlcon);
cm.Parameters.AddWithValue("@pcode ", txtCode.Text);
cm.Parameters.AddWithValue("@detail ", txtDetail.Text);
cm.Parameters.AddWithValue("@cid ", cid);
cm.Parameters.AddWithValue("@price", txtPrice.Text);
cm.Parameters.AddWithValue("@code ", txtCode.Text);
cm.Parameters.AddWithValue("@quantity ", txtQuantity.Text);
cm.ExecuteNonQuery();
sqlcon.Close();
MessageBox.Show("Product has been successfully Saved!");
Clear();
flist.LoadRecord();
this.Dispose();
}
}
catch (Exception ex)
{
sqlcon.Close();
MessageBox.Show(ex.Message);
}
}
private void btnProduct_Click(object sender, EventArgs e)
{
fromProductLsit frm = new fromProductLsit();
frm.TopLevel = false;
panel3.Controls.Add(frm);
frm.BringToFront();
frm.LoadRecord();
frm.Show();
}