private void btn_save_Click(object sender, EventArgs e)
{
try
{
con = new OleDbConnection(lblpath.Text);
con.Open();
string cb = "insert into PlotSell(CUSTOMERID,CUSTOMERNAME,PLOTNO,SURVEYNO,PLOTSIZE,RATE,TOTALAMOUNT,BOOKINGAMOUNT,AGREEMENTAMOUNT,TOTALPAIDAMOUNT,BALANCEAMOUNT,EXTRADETAIL,PLOTSELLDATE) VALUES (" + lblcustid.Text + ",'" + cmbCustomer.Text + "','" + txtplotno.Text + "','" + txtsurveyno.Text + "'," + txtplotsize.Text + "," + txtrate.Text + "," + txttotalamount.Text + "," + txtbookingamout.Text + "," + txtagreementamount.Text + "," + txttotalpaidamount.Text + "," + txtbalanceamount.Text + ",'" + txtextradetail.Text + "','" + dtpDate.Text + "')";
cmd = new OleDbCommand(cb);
cmd.Connection = con;
cmd.ExecuteReader();
con.Close();
MessageBox.Show("Successfully saved", "PLOT SELL DETAIL", MessageBoxButtons.OK, MessageBoxIcon.Information);
con = new OleDbConnection(lblpath.Text);
con.Open();
string cb1 = "insert into Ledger(PLOTSELLID,VOUCHERDATE,VOUCHERTYPE,VOUCHERNO,DEBIT,BAL) VALUES (" + lblplotsell.Text + ",'" + dtpDate.Text + "','" + "TOTAL PLOT SELL AMOUNT" + "'," + lblplotsell.Text + "," + txttotalamount.Text + "," + txttotalamount.Text + ")";
cmd = new OleDbCommand(cb1);
cmd.Connection = con;
cmd.ExecuteReader();
con.Close();
string a = Convert.ToString(Convert.ToInt64(txttotalamount.Text) - Convert.ToInt64(txtbookingamout.Text));
con = new OleDbConnection(lblpath.Text);
con.Open();
string cb2 = "insert into Ledger(PLOTSELLID,VOUCHERDATE,VOUCHERTYPE,VOUCHERNO,CREDIT,BAL) VALUES (" + lblplotsell.Text + ",'" + dtpDate.Text + "','" + "Booking AMOUNT" + "'," + lblplotsell.Text + "," + txtbookingamout.Text + "," + a.ToString() + ")";
cmd = new OleDbCommand(cb2);
cmd.Connection = con;
cmd.ExecuteReader();
con.Close();
a = Convert.ToString(Convert.ToInt64(a) - Convert.ToInt64(txtagreementamount.Text));
con = new OleDbConnection(lblpath.Text);
con.Open();
string cb3 = "insert into Ledger(PLOTSELLID,VOUCHERDATE,VOUCHERTYPE,VOUCHERNO,CREDIT,BAL) VALUES (" + lblplotsell.Text + ",'" + dtpDate.Text + "','" + "AGREEMENT AMOUNT" + "'," + lblplotsell.Text + "," + txtagreementamount.Text + "," + a.ToString() + ")";
cmd = new OleDbCommand(cb3);
cmd.Connection = con;
cmd.ExecuteReader();
con.Close();
DialogResult result1 = MessageBox.Show("Do you want to print this plot sell detail?", "Account Management",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result1 == DialogResult.Yes)
{
try
{
rptInvoice rpt = new rptInvoice();
//The report you created.
cmd = new OleDbCommand();
OleDbDataAdapter myDA = new OleDbDataAdapter();
DataSet myDS = new DataSet();
//The DataSet you created.
con = new OleDbConnection(lblpath.Text);
cmd.Connection = con;
// cmd.CommandText = "SELECT PlotSell.CUSTOMERID,PlotSell.CUSTOMERNAME,PlotSell.PLOTNO,PlotSell.SURVEYNO,PlotSell.PLOTSIZE,PlotSell.RATE,PlotSell.TOTALAMOUNT,PlotSell.BOOKINGAMOUNT,PlotSell.AGREEMENTAMOUNT,PlotSell.TOTALPAIDAMOUNT,PlotSell.BALANCEAMOUNT,PlotSell.EXTRADETAIL,PlotSell.PLOTSELLDATE,PlotSell.PLOTSELLID,Installment.INSTALLMENTNO,Installment.INSTALLMENTDATE,Installment.INSTALLMENT FROM PlotSell INNER JOIN Installment ON PlotSell.PLOTSELLID = Installment.PLOTSELLID WHERE PlotSell.PLOTSELLID =" + lblplotsell.Text + "";
cmd.CommandText = "SELECT PlotSell.CUSTOMERID,PlotSell.CUSTOMERNAME,PlotSell.PLOTNO,PlotSell.SURVEYNO,PlotSell.PLOTSIZE,PlotSell.RATE,PlotSell.TOTALAMOUNT,PlotSell.BOOKINGAMOUNT,PlotSell.AGREEMENTAMOUNT,PlotSell.TOTALPAIDAMOUNT,PlotSell.BALANCEAMOUNT,PlotSell.EXTRADETAIL,PlotSell.PLOTSELLDATE,PlotSell.PLOTSELLID FROM PlotSell WHERE PlotSell.PLOTSELLID =" + lblplotsell.Text + "";
cmd.CommandType = CommandType.Text;
myDA.SelectCommand = cmd;
myDA.Fill(myDS, "PlotSell");
cmd.CommandText = "SELECT Company.COMPANYNAME,Company.ADDRESS,Company.PHONENO,Company.EMAIL,Company.WEB,Company.TINNO,Company.CSTNO,Company.EXTRA1,Company.EXTRA2 FROM Company ";
cmd.CommandType = CommandType.Text;
myDA.SelectCommand = cmd;
myDA.Fill(myDS, "Company");
cmd.CommandText = "SELECT Installment.INSTALLMENTNO,Installment.INSTALLMENTDATE,Installment.INSTALLMENT FROM Installment WHERE Installment.PLOTSELLID =" + lblplotsell.Text + " ";
cmd.CommandType = CommandType.Text;
myDA.SelectCommand = cmd;
myDA.Fill(myDS, "Installment");
con.Close();
rpt.SetDataSource(myDS);
frmReport frm = new frmReport();
frm.crystalReportViewer1.ReportSource = rpt;
frm.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
btn_save.Enabled = false;
Reset();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}