private void paymentTermsToolStripMenuItem_Click(object sender, EventArgs e) { this.Show(); payment_re pr = new payment_re(); pr.ShowDialog(); }
private void button2_Click(object sender, EventArgs e) { payment_re it = new payment_re(); it.ShowDialog(); }
// int id = 0; // string id1 = ""; private void button9_Click(object sender, EventArgs e) { string in_no = ""; // insert query into payment Receipt DataGridViewRow newDataRow = dataGridView1.Rows[selectedrow]; DataGridViewRow row = dataGridView1.Rows[selectedrow]; try { connection.Close(); connection.Open(); OleDbDataReader rdr = null; OleDbCommand cmd = new OleDbCommand("select * from payment_receipt where invoice_type = 'Tax-Invoice' AND in_no = '" + row.Cells[0].Value + "' ", connection); rdr = cmd.ExecuteReader(); if (rdr.Read()) { in_no = Convert.ToString(rdr["in_no"]); } } catch (Exception o) { MessageBox.Show("getid" + o); } finally { connection.Close(); } if (in_no == row.Cells[0].Value.ToString()) { MessageBox.Show("Already exist"); } else { try { string bla = ""; bla = "1"; get_id gi = new get_id(); gi.taxinvoice(); int receipt_no = get_id.pay_re; connection.Close(); connection.Open(); string command = "insert into payment_receipt(re_no,re_date,payment_type,invoice_type,ref_no,ref_date,in_no,in_date,c_name,total_amount,due_amount,receive_amount,total_receive) values(@re_no,@re_date,@payment_type,@invoice_type,@ref_no,@ref_date,@in_no,@in_date,@c_name,@in_amount,@due_amount,@receive_amount,@total_receive) "; OleDbCommand cmdd = new OleDbCommand(command, connection); cmdd.Parameters.AddWithValue("@re_no", receipt_no); cmdd.Parameters.AddWithValue("@re_date", DateTime.Now.ToString("MM-dd-yyyy")); cmdd.Parameters.AddWithValue("@payment_type", "Against Invoice"); cmdd.Parameters.AddWithValue("@invoice_type", "Tax-Invoice"); cmdd.Parameters.AddWithValue("@re_no", receipt_no); cmdd.Parameters.AddWithValue("@re_date", DateTime.Now.ToString("MM-dd-yyyy")); cmdd.Parameters.AddWithValue("@in_no", row.Cells[0].Value); cmdd.Parameters.AddWithValue("@in_date", row.Cells[1].Value); cmdd.Parameters.AddWithValue("@c_name", row.Cells[4].Value); cmdd.Parameters.AddWithValue("@in_amount", row.Cells[5].Value); cmdd.Parameters.AddWithValue("@due_amount", row.Cells[7].Value); string receive = Convert.ToString(Convert.ToDouble(row.Cells[5].Value.ToString()) - Convert.ToDouble(row.Cells[7].Value.ToString())); cmdd.Parameters.AddWithValue("@receive_amount", receive); cmdd.Parameters.AddWithValue("@total_receive", receive); cmdd.ExecuteNonQuery(); //update into id int df = get_id.pay_re + 1; OleDbCommand command1 = new OleDbCommand(@"UPDATE get_id SET pay_re = @City_Name WHERE ID = " + bla + "", connection); command1.Parameters.AddWithValue("@City_Name", df); command1.ExecuteNonQuery(); } catch (Exception p) { MessageBox.Show("" + p); } finally { connection.Close(); payment_re ts = new payment_re(); ts.ShowDialog(); } } }