private void bttn_AllPrintKhatawani_Click(object sender, EventArgs e)
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
DataTable dtKhatawani = _objGirviAdd.getAllKhatawaniDetails();
for (int i = 0; i < dtKhatawani.Rows.Count; i++)
{
txt_KhatawaniNo.Text = dtKhatawani.Rows[i]["khatawani_No"].ToString();
FillGrids();
DataTable dtGirviDetails = _objCommon.DataGridView2DataTable(dgv_GirviDetail, "dtCustomerBill");
DataTable dtPaydetails = _objCommon.DataGridView2DataTable(dgv_PaymentDetail, "table");
DataTable dtMerge = _objCommon.mergeTwoDataGrid(dtGirviDetails, dtPaydetails);
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendDataMulti _obj = new SendDataMulti(_objfrm_ReportViewer.ReceiveDataInterestRecordMultiPrint);
if (rbt_OtherTrue.Checked == true)
{
_obj(dtMerge, txt_KhatawaniNo.Text, totalloanamountsum.ToString(), totalpaidsum.ToString(), oPrintersetting.PrinterName, true);
}
else
{
_obj(dtMerge, txt_KhatawaniNo.Text, totalloanamountsum.ToString(), totalpaidsum.ToString(), oPrintersetting.PrinterName, false);
}
MasterClear();
}
}
}
public void khatawaniBook()
{
DataTable dtFiancialYear = _objFinancialYear.getSelectedFinancialYear();
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
for (int j = 0; j < dgv_KhatawaniDetail.Rows.Count; j++)
{
if (Convert.ToBoolean(dgv_KhatawaniDetail.Rows[j].Cells["chk"].Value) == true)
{
double totalloanamountsum = 0;
DataTable girvi_data = _objGirviAdd.getGirviDetailsByKhatawaniInterest(dgv_KhatawaniDetail.Rows[j].Cells["KhatawaniNo"].Value.ToString());
DataTable dtGirviDetailsKhatwani = new DataTable();
dtGirviDetailsKhatwani.Columns.Add("RecieptNoNave");
dtGirviDetailsKhatwani.Columns.Add("AmountPaidNave");
dtGirviDetailsKhatwani.Columns.Add("DateOfDepositNave");
dtGirviDetailsKhatwani.Columns.Add("PageNoNave");
dtGirviDetailsKhatwani.Columns.Add("DiscriptionNave");
for (int i = 0; i < girvi_data.Rows.Count; i++)
{
int girvi_no = Convert.ToInt32(girvi_data.Rows[i]["GirviRecordNo"]);
string pagenumber = _objGirviCommon.getPageNumber(girvi_data.Rows[i]["Date_of_deposit"].ToString());
string Dateofrelease = _objKhatawaniGiviRecord.getDateofrelease(girvi_no);
string str = _objKhatawaniGiviRecord.getgirviitem(girvi_no.ToString()) + " व्याज: दि." + girvi_data.Rows[i]["Date_of_deposit"] + "ते दि." + Dateofrelease;
string interest = _objKhatawaniGiviRecord.getreleaseinterest(girvi_no);
dtGirviDetailsKhatwani.Rows.Add(girvi_data.Rows[i]["receipt_no"].ToString(), girvi_data.Rows[i]["Amount"].ToString() + "\n " + interest, girvi_data.Rows[i]["Date_of_deposit"].ToString(), pagenumber, str.Trim());
totalloanamountsum = totalloanamountsum + (Convert.ToDouble(girvi_data.Rows[i]["Amount"].ToString()));//lalit remove interest
}
double totalpaidsum = 0;
DataTable dtGirviReleaseKhatwani = new DataTable();
DataTable dtGirvirelease = _objKhatawaniGiviRecord.getgirvivaluesByFinancialYear(dgv_KhatawaniDetail.Rows[j].Cells["KhatawaniNo"].Value.ToString(), dtFiancialYear.Rows[0]["startyear"].ToString(), dtFiancialYear.Rows[0]["endyear"].ToString());
dtGirviReleaseKhatwani.Columns.Add("RecieptNoJama");
dtGirviReleaseKhatwani.Columns.Add("AmountPaidJama");
dtGirviReleaseKhatwani.Columns.Add("DateJama");
dtGirviReleaseKhatwani.Columns.Add("PageNoJama");
dtGirviReleaseKhatwani.Columns.Add("DiscriptionJama");
if (dtGirvirelease.Rows.Count > 0)
{
for (int i = 0; i < dtGirvirelease.Rows.Count; i++)
{
string str;
if (rbt_Marathi.Checked == true)
{
str = dtGirvirelease.Rows[i]["AmountDeposit"].ToString() + " दि. " + dtGirvirelease.Rows[i]["dateOfRelease"].ToString() + " चे मुद्दल, " + dtGirvirelease.Rows[i]["Interest_Amount"].ToString() + " व्याज बद्दल";
}
else
{
str = dtGirvirelease.Rows[i]["AmountDeposit"].ToString() + " दि." + dtGirvirelease.Rows[i]["dateOfRelease"].ToString() + " चे मुद्दल, " + dtGirvirelease.Rows[i]["Interest_Amount"].ToString() + " व्याज बद्दल";
}
string pagenumber = _objGirviCommon.getPageNumber(dtGirvirelease.Rows[i]["dateOfRelease"].ToString());
dtGirviReleaseKhatwani.Rows.Add(dtGirvirelease.Rows[i]["pavtino"].ToString(), dtGirvirelease.Rows[i]["AmountDeposit"].ToString(), dtGirvirelease.Rows[i]["dateOfRelease"].ToString(), pagenumber, str);
totalpaidsum = totalpaidsum + (Convert.ToDouble(dtGirvirelease.Rows[i]["AmountDeposit"].ToString()));
}
}
totalpaidsum.ToString();
DataTable dtMerge = _objCommon.mergeTwoDataGrid(dtGirviDetailsKhatwani, dtGirviReleaseKhatwani);
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendDataMulti _obj = new SendDataMulti(_objfrm_ReportViewer.ReceiveDataInterestRecordMultiPrint);
if (rbt_PrintTrue.Checked == true)
{
_obj(dtMerge, dgv_KhatawaniDetail.Rows[j].Cells["KhatawaniNo"].Value.ToString(), totalloanamountsum.ToString(), totalpaidsum.ToString(), oPrintersetting.PrinterName, true);
}
else
{
_obj(dtMerge, dgv_KhatawaniDetail.Rows[j].Cells["KhatawaniNo"].Value.ToString(), totalloanamountsum.ToString(), totalpaidsum.ToString(), oPrintersetting.PrinterName, false);
}
}
}
}
}
