private void BtnDelete_Click(object sender, EventArgs e) { try { int delete = dataGridView1.CurrentCell.RowIndex; dataGridView1.Rows.RemoveAt(delete); double a, b, c = 0; a = double.Parse(Txtcurrentstock.Text); b = double.Parse(Txtquant.Text); c = a - b; con.Open(); SqlCommand cmd = new SqlCommand(); cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "UPDATE CProductMaster SET TUnit='" + c + "' where [ProCode]='" + Txtproductid.Text + "'"; cmd.ExecuteNonQuery(); MessageBox.Show("Product " + Txtproductname.Text + " Deleted From List.", "Congratulation", MessageBoxButtons.OK, MessageBoxIcon.Information); con.Close(); } catch (Exception ex) { } finally { Txtproductname.Text = ""; Txtcategory.Text = ""; Txtunitname.Text = ""; Txtproductid.Text = ""; Txtquantity.Text = ""; Txtprice.Text = ""; Txtmrp.Text = ""; Txtpurchage.Text = ""; Txtsale.Text = ""; Txtcurrentstock.Clear(); } }
private void Btnadd_Click(object sender, EventArgs e) { try { //add text item in datagridview int row1 = 0; dataGridView1.Rows.Add(); row1 = dataGridView1.Rows.Count - 1; dataGridView1["Purchase_ID", row1].Value = TxtpurchageID.Text; dataGridView1["Product_Name", row1].Value = Txtproductname.Text; dataGridView1["Category_Name", row1].Value = Txtcategory.Text; dataGridView1["Unit_Name", row1].Value = Txtunitname.Text; dataGridView1["Purchase_Rate", row1].Value = Txtpurchage.Text; dataGridView1["MRP_Rate", row1].Value = Txtmrp.Text; dataGridView1["Sale_Rate", row1].Value = Txtsale.Text; dataGridView1["Quantity", row1].Value = Txtquantity.Text; dataGridView1["Price", row1].Value = Txtprice.Text; dataGridView1["CurrentStock", row1].Value = Txtcurrentstock.Text; dataGridView1["ProductID", row1].Value = Txtproductid.Text; Txttottal.Text = "0.00"; for (int i = 0; i < dataGridView1.Rows.Count; i++) { Txttottal.Text = Convert.ToString(double.Parse(Txttottal.Text) + double.Parse(dataGridView1.Rows[i].Cells[9].Value.ToString())); } double x; double.TryParse(Txttottal.Text, out x); Txttottal.Text = x.ToString("0.00"); long a, b, c = 0; a = long.Parse(Txtcurstock.Text); //Quantity of Total items b = long.Parse(Txtquantity.Text); //Quantity of Purchase items c = a + b; con.Open(); SqlCommand cmd = new SqlCommand(); cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "UPDATE CProductMaster SET [TUnit]='" + c + "' where [ID]='" + Txtproductid.Text + "'"; cmd.ExecuteNonQuery(); MessageBox.Show("Product " + Txtproductname.Text + " Added To Cart!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Problem Found"); } finally { Txtproductname.Text = ""; Txtcategory.Text = ""; Txtunitname.Text = ""; Txtcurrentstock.Text = ""; Txtproductid.Text = ""; Txtquantity.Text = ""; Txtprice.Text = ""; Txtmrp.Text = ""; Txtpurchage.Text = ""; Txtsale.Text = ""; Txtcurrentstock.Clear(); Txtquant.Text = ""; Txtcurstock.Text = ""; } }