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