private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("ARE YOU SURE YOU WANT TO ADD THIS PRODUCT?", "ADD PRODUCT", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string bid = ""; string cid = "";
con.Open();
cmd = new MySqlCommand("Select id from tblBrand where brand like '" + cboBrand.Text + "'", con);
dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
bid = dr[0].ToString();
}
dr.Close();
con.Close();
con.Open();
cmd = new MySqlCommand("Select id from tblCategory where category like '" + cboCategory.Text + "'", con);
dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
cid = dr[0].ToString();
}
dr.Close();
con.Close();
con.Open();
cmd = new MySqlCommand("INSERT INTO tblproduct(pcode,barcode,pdesc,bid,cid,price,reorder)VALUES(@pcode,@barcode,@pdesc,@bid,@cid,@price,@reorder)", con);
cmd.Parameters.AddWithValue("@pcode", txtPcode.Text);
cmd.Parameters.AddWithValue("@barcode", txtBarcode.Text);
cmd.Parameters.AddWithValue("@pdesc", txtPDesc.Text);
cmd.Parameters.AddWithValue("@bid", bid);
cmd.Parameters.AddWithValue("@cid", cid);
cmd.Parameters.AddWithValue("@price", Double.Parse(txtPrice.Text));
cmd.Parameters.AddWithValue("@reorder", int.Parse(txtReorder.Text));
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("PRODUCT ADDED SUCCESSFULLY");
Clear();
flist.LoadRecords();
ProductCodeLoad();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnProduct_Click(object sender, EventArgs e)
{
frmProductList frm = new frmProductList();
frm.TopLevel = false;
panelShow.Controls.Add(frm);
frm.BringToFront();
frm.LoadRecords();
frm.Show();
}
