private void btnSave_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Are you sure to save this Product?", "Save Product", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { string bid = ""; string cid = ""; //Getting the id of brand cn.Close(); cn.Open(); cm = new SqlCommand("select id from tblBrand where brand like '" + cboBrands.Text + "'", cn); dr = cm.ExecuteReader(); dr.Read(); if (dr.HasRows) { bid = dr[0].ToString(); } dr.Close(); cn.Close(); //getting the id of category cn.Open(); cm = new SqlCommand("select id from tblCategory where Category like '" + cboCategory.Text + "'", cn); dr = cm.ExecuteReader(); dr.Read(); if (dr.HasRows) { cid = dr[0].ToString(); } dr.Close(); cn.Close(); //Saving Product cn.Open(); cm = new SqlCommand("INSERT INTo tblProduct(pcode,barcode, pdesc, bid, cid, price, reorder)VALUES(@pcode,@barcode, @pdesc, @bid, @cid, @price, @reorder)", cn); cm.Parameters.AddWithValue("@pcode", txtPCode.Text); cm.Parameters.AddWithValue("@barcode", txtBarcode.Text); cm.Parameters.AddWithValue("@pdesc", txtDescription.Text); cm.Parameters.AddWithValue("@bid", bid); cm.Parameters.AddWithValue("@cid", cid); cm.Parameters.AddWithValue("@price", Double.Parse(txtPrice.Text)); cm.Parameters.AddWithValue("@reorder", int.Parse(txtReorder.Text)); cm.ExecuteNonQuery(); cn.Close(); MessageBox.Show("Product has been successfully saved.", "Product Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); clear(); plist.LoadProducts(); } } catch (Exception ex) { cn.Close(); MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { try { cn.Open(); cm = new SqlCommand("Select * from tblProduct", cn); dr = cm.ExecuteReader(); dr.Read(); if (dr.HasRows) { cn.Close(); cn.Open(); cm = new SqlCommand("update tblProduct set disc_per = @disc_per", cn); cm.Parameters.AddWithValue("@disc_per", double.Parse(txtDiscount.Text)); cm.ExecuteNonQuery(); cn.Close(); MessageBox.Show("Discount updated Successfully", "Discount", MessageBoxButtons.OK, MessageBoxIcon.Information); f.LoadProducts(); this.Dispose(); } else { MessageBox.Show("You have no Product in Record"); } } catch (Exception ex) { cn.Close(); MessageBox.Show(ex.Message); } }
private void btnProduct_Click(object sender, EventArgs e) { frmProductList frmProduct = new frmProductList(); frmProduct.TopLevel = false; MainPanel.Controls.Add(frmProduct); frmProduct.BringToFront(); frmProduct.LoadProducts(); //frmProduct.loadRecords(); frmProduct.Show(); }
private void btnProduct_Click(object sender, EventArgs e) { ReferenceBtn.Enabled = true; ReferenceFrm.Dispose(); btnProduct.Enabled = false; frmProductList frmProduct = new frmProductList(); ReferenceFrm = frmProduct; ReferenceBtn = btnProduct; frmProduct.TopLevel = false; MainPanel.Controls.Add(frmProduct); frmProduct.BringToFront(); frmProduct.LoadProducts(); //frmProduct.loadRecords(); frmProduct.Show(); }