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(); }