private void FrmCreditorInvoice_Load(object sender, EventArgs e) { fillledgers(); CreditorFind.Focus(); //dataGridView1.Rows.Clear(); TxtInv.Text = ""; TxtJob.Text = ""; txtinvdate.Text = ""; TxtInvValue.Text = "0.00"; txtothers.Text = "0.00"; txtdiscount.Text = "0.00"; txtsgst.Text = "0.00"; txtcgst.Text = "0.00"; txtigst.Text = "0.00"; textnet.Text = "0.00"; TxtInv.Focus(); }
private void button2_Click(object sender, EventArgs e) { try { Int32 rowcnt = dataGridView1.Rows.Count; for (int a = 0; a < rowcnt; a = a + 1) { if (dataGridView1.Rows[a].Cells[0].Value != null) { string qry = "insert into TblCreditorInvMast (finyr,Brcode,GLID,SLID,Creditor_Name,InvNo,InvDt,Job,InvValue," + "other_charge,discount,sgst,cgst,igst,net_value,PaidSum,Payment_Status) values " + "(@finyr,@Brcode,@glid,@slid,@creditor,@invno,@invdt,@job,@invvalue,@othchg,@disc,@sgst,@cgst,@igst,@netval,0,'N')"; SqlCommand com = new SqlCommand(qry, clsConnection.Conn); com.Parameters.Clear(); com.Parameters.AddWithValue("@finyr", Global.finyr); com.Parameters.AddWithValue("@Brcode", Global.branch); com.Parameters.AddWithValue("@glid", label8.Text); com.Parameters.AddWithValue("@slid", label9.Text); com.Parameters.AddWithValue("@Creditor", CreditorFind.Text); com.Parameters.AddWithValue("@InvNo", dataGridView1.Rows[a].Cells[0].Value); com.Parameters.AddWithValue("@Job", dataGridView1.Rows[a].Cells[1].Value); com.Parameters.AddWithValue("@InvDt", dataGridView1.Rows[a].Cells[2].Value); com.Parameters.AddWithValue("@invvalue", Convert.ToDouble(dataGridView1.Rows[a].Cells[3].Value ?? 0)); com.Parameters.AddWithValue("@othchg", Convert.ToDouble(dataGridView1.Rows[a].Cells[4].Value ?? 0)); com.Parameters.AddWithValue("@disc", Convert.ToDouble(dataGridView1.Rows[a].Cells[5].Value ?? 0)); com.Parameters.AddWithValue("@sgst", Convert.ToDouble(dataGridView1.Rows[a].Cells[6].Value ?? 0)); com.Parameters.AddWithValue("@cgst", Convert.ToDouble(dataGridView1.Rows[a].Cells[7].Value ?? 0)); com.Parameters.AddWithValue("@igst", Convert.ToDouble(dataGridView1.Rows[a].Cells[8].Value ?? 0)); com.Parameters.AddWithValue("@netval", Convert.ToDouble(dataGridView1.Rows[a].Cells[9].Value ?? 0)); com.ExecuteNonQuery(); } } //Insert Audit Tran string qry2 = "insert into TblAuditTrn (HostName,ipaddress,menu,OperationType,username,Remarks) values " + "(@HostName,@ipaddress,@menu,@OperationType,@username,@Remarks)"; SqlCommand com2 = new SqlCommand(qry2, clsConnection.Conn); com2.Parameters.Clear(); com2.Parameters.AddWithValue("@HostName", Global.FetchHost()); com2.Parameters.AddWithValue("@ipaddress", Global.FetchIP()); com2.Parameters.AddWithValue("@menu", "Creditor Invoice Master"); com2.Parameters.AddWithValue("@OperationType", "Insert"); com2.Parameters.AddWithValue("@username", Global.username); com2.Parameters.AddWithValue("@Remarks", "New Creditor Invoice Entry of Creditor: " + CreditorFind.Text.ToString()); com2.ExecuteNonQuery(); MessageBox.Show("Record saved successfully"); TxtInv.Text = ""; TxtJob.Text = ""; txtinvdate.Text = ""; TxtInvValue.Text = "0.00"; txtothers.Text = "0.00"; txtdiscount.Text = "0.00"; txtsgst.Text = "0.00"; txtcgst.Text = "0.00"; txtigst.Text = "0.00"; textnet.Text = "0.00"; TxtInv.Focus(); dataGridView1.Rows.Clear(); dataGridView1.RowCount = 1; CreditorFind.Focus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }