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();
}
}
}
private void bttn_PrintReport_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
try
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
int j = 0;
for (int v = 0; v <= (Convert.ToDateTime(dtp_EndDate.Text) - Convert.ToDateTime(dtp_StartDate.Text)).TotalDays; v++)
{
DataTable dt = _objRokad.getAllGirvi((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j)).ToString("dd/MM/yyyy"));
for (int k = 0; k < dt.Rows.Count; k++)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveBabhulgaonOfficeCopyMulti);
_obj(dt.Rows[k]["GirviRecordNo"].ToString(), dt.Rows[k]["khatawani_No"].ToString(), "", oPrintersetting.PrinterName);
// _objfrm_ReportViewer.Show();
}
j++;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void bttn_monthwiseReport_Click(object sender, EventArgs e)
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
foreach (DataRow dtr in _objCommon.DataGridView2DataTableSelected(dgv_SixMonthReport, "table").Rows)
{
try
{
frm_ReportViewer _objfrm_ReportViewer = new frm_ReportViewer();
SendDataNotice _obj = new SendDataNotice(_objfrm_ReportViewer.ReceiveDataNotice);
_obj(dtr["GirviRecordNo"].ToString(), dtr["KhatawaniNo"].ToString().Trim(), "Other", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (rbt_threemonths.Checked == true)
{
ThreeMonths();
}
else if (rbt_sixmonth.Checked == true)
{
fillgrid();
}
else if (rbt_ninemonths.Checked == true)
{
NineMonths();
}
else
{
twelthMonths();
}
}
else
{
}
}
private void bttn_Print_Click(object sender, EventArgs e)
{ //DataTable dtGirviDetails = _objCommon.DataGridView2DataTable(dgv_GirviAdded, "dtCustomerBill");
//DataTable dtPaydetails = _objCommon.DataGridView2DataTable(dgv_GirviRelease, "table");
//DataTable dtMerge = _objCommon.mergeTwoDataGrid(dtGirviDetails, dtPaydetails);
//CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
//SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveRokadSingleRecord);
//_obj(dtMerge);
//_objfrm_ReportViewer.Show();
string pageno = "";
DataSet ds = new DataSet();
try
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
int j = 0;
for (int v = 0; v <= (Convert.ToDateTime(dtp_EndDate.Text) - Convert.ToDateTime(dtp_StartDate.Text)).TotalDays; v++)
{
dgv_GirviAdded.Rows.Clear();
dgv_GirviRelease.Rows.Clear();
totalGirviAmount = 0;
totalinterestamt = 0;
totalReleaseAmount = 0;
DataTable dt = _objRokad.getAllGirvi((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j)).ToString("dd/MM/yyyy"));
if (dt.Rows.Count > 0)
{
pageno = _objGirviCommon.getPageNumber(dt.Rows[0]["Date_of_deposit"].ToString());
}
if (dt.Rows.Count > 0)
{
int i;
for (i = 0; i < dt.Rows.Count; i++)
{
int girvi_no = Convert.ToInt32(dt.Rows[i][1]);
string str = _objRokad.getGirviItem(girvi_no.ToString());
DataTable name = _objRokad.getnamefromID(dt.Rows[i][0].ToString());
string descriptionnew = name.Rows[0][0].ToString().Trim() + "\n" + name.Rows[0][3].ToString() + "," + str + "\n व्याज दर.सा.द.शे " + Convert.ToDecimal(dt.Rows[0]["interset_rate"]) * 12 + "प्र \n " + " दि." + dt.Rows[i][3].ToString();
//sagar pulgao column
string girviitemforsagarpulgao = _objRokad.getGirviItemForSagarPulgao(girvi_no.ToString());
string descriptionforSagarPulgao = name.Rows[0][0].ToString().Trim() + "\n" + name.Rows[0][3].ToString() + "," + girviitemforsagarpulgao;
//
dgv_GirviAdded.Rows.Add();
dgv_GirviAdded.Rows[i].Cells["DateNave"].Value = dt.Rows[i]["Date_of_deposit"].ToString();
dgv_GirviAdded.Rows[i].Cells["GirviNoNave"].Value = dt.Rows[i]["receipt_no"].ToString();
dgv_GirviAdded.Rows[i].Cells["DiscriptionNave"].Value = descriptionnew;
dgv_GirviAdded.Rows[i].Cells["AmountNave"].Value = dt.Rows[i]["Amount"].ToString();
dgv_GirviAdded.Rows[i].Cells["KhatawaniPanNave"].Value = dt.Rows[i]["khatawani_No"].ToString();
//sagar pulgao column
dgv_GirviAdded.Rows[i].Cells["ShortDescNaave"].Value = descriptionforSagarPulgao;
//
//totalGirviAmount = totalGirviAmount + Convert.ToDouble(dgv_GirviAdded.Rows[i].Cells["amountNave"].Value.ToString());
}
//totalGirviAmount = _objCommon.sumGridViewColumn(dgv_GirviAdded, "AmountNave");
// label4.Text = totalGirviAmount.ToString();
//dgv_GirviAdded.Rows.Add("Total= " + totalGirviAmount.ToString(), "", "", "");
//dgv_GirviAdded.Rows[i].DefaultCellStyle.BackColor = Color.Red;
//dgv_GirviAdded.Rows[i].DefaultCellStyle.ForeColor = Color.White;
}
else
{
}
DataTable dt1 = _objRokad.getAllGirviRelease((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j)).ToString("dd/MM/yyyy"));
if (dt1.Rows.Count > 0)
{
pageno = _objGirviCommon.getPageNumber(dt1.Rows[0]["dateOfRelease"].ToString());
}
if (dt1.Rows.Count > 0)
{
int i;
for (i = 0; i < dt1.Rows.Count; i++)
{
int girvi_no = Convert.ToInt32(dt1.Rows[i][1]);
string str = _objRokad.getgirviitem(girvi_no.ToString());
DataTable name = _objRokad.getnamefromID(dt1.Rows[i][0].ToString());
DataTable girviadddate = _objRokad.getDatefromGn(dt1.Rows[i]["Girvino"].ToString());
string descriptionnew = name.Rows[0]["FullName"].ToString() + ",\n" + name.Rows[0]["Address"].ToString() + "," + dt1.Rows[i][2].ToString() + " दि." + girviadddate.Rows[0][0].ToString() + " चे मुद्दल " + dt1.Rows[i][3].ToString() + " व्याज\n" + "दि" + girviadddate.Rows[0][0].ToString() + " ते " + dt1.Rows[i]["dateOfRelease"].ToString();
double sumtotal = Convert.ToDouble(dt1.Rows[i]["AmountDeposit"].ToString()) + Convert.ToDouble(dt1.Rows[i]["Interest_Amount"].ToString());
dgv_GirviRelease.Rows.Add();
dgv_GirviRelease.Rows[i].Cells["DateJama"].Value = dt1.Rows[i]["dateOfRelease"].ToString();
//dgv_GirviRelease.Rows[i].Cells["NameJama"].Value = "";
dgv_GirviRelease.Rows[i].Cells["GirviNoReleaseJama"].Value = girviadddate.Rows[0]["receipt_no"].ToString();//dt1.Rows[i]["pavtino"].ToString();//dt1.Rows[i]["Girvino"].ToString()
dgv_GirviRelease.Rows[i].Cells["DiscriptionJama"].Value = descriptionnew;
dgv_GirviRelease.Rows[i].Cells["TotalAmountJama"].Value = sumtotal.ToString();
dgv_GirviRelease.Rows[i].Cells["AmountJama"].Value = dt1.Rows[i]["AmountDeposit"].ToString();
dgv_GirviRelease.Rows[i].Cells["InterestJama"].Value = dt1.Rows[i]["Interest_Amount"].ToString();
dgv_GirviRelease.Rows[i].Cells["KhatawaniPanJama"].Value = dt1.Rows[i]["Khatawani_no"].ToString();
string descriptionSagarpulgao = name.Rows[0]["FullName"].ToString() + ",\n" + name.Rows[0]["Address"].ToString() + "," + dt1.Rows[i]["pavtino"].ToString();
dgv_GirviRelease.Rows[i].Cells["ShortDesc"].Value = descriptionSagarpulgao;
dgv_GirviRelease.Rows[i].Cells["GirviNoRelease"].Value = dt1.Rows[i]["pavtino"].ToString();
//try
//{
// totalReleaseAmount = totalReleaseAmount + Convert.ToDouble(dgv_GirviRelease.Rows[i].Cells["AmountJama"].Value.ToString());
//}
//catch { }
//try
//{
// totalinterestamt = totalinterestamt + Convert.ToDouble(dgv_GirviRelease.Rows[i].Cells["InterestJama"].Value.ToString());
//}
//catch { }
}
//double totalAmountJama = _objCommon.sumGridViewColumn(dgv_GirviRelease, "TotalAmountJama");
//totalReleaseAmount = _objCommon.sumGridViewColumn(dgv_GirviRelease, "AmountJama");
//totalinterestamt = _objCommon.sumGridViewColumn(dgv_GirviRelease, "InterestJama");
//dgv_GirviRelease.Rows.Add("Total= ", totalAmountJama.ToString(), totalReleaseAmount.ToString(), totalinterestamt.ToString());
//dgv_GirviRelease.Rows[i].DefaultCellStyle.BackColor = Color.Red;
//dgv_GirviRelease.Rows[i].DefaultCellStyle.ForeColor = Color.White;
// label5.Text = totalReleaseAmount.ToString();
}
totalGirviAmount.ToString();
totalReleaseAmount.ToString();
totalinterestamt.ToString();
//ds.Tables.Add(dtmerge);
j++;
DataTable dtGirviDetails = _objCommon.DataGridView2DataTable(dgv_GirviAdded, "dtCustomerBill");
DataTable dtPaydetails = _objCommon.DataGridView2DataTable(dgv_GirviRelease, "table");
DataTable dtMerge = _objCommon.mergeTwoDataGrid(dtGirviDetails, dtPaydetails);
if (dt.Rows.Count > 0)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveRokadMultiRecord);
if (rbt_OtherTrue.Checked == true)
{
_obj(dtMerge, oPrintersetting.PrinterName, true, _objGirviCommon.getPageNumber((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j - 1)).ToString("dd/MM/yyyy")), _objGirviCommon.getOpeningBalanceWithlastDate((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j - 1)).ToString("dd/MM/yyyy")), _objGirviCommon.getOpeningBalanceWithlastDate((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j)).ToString("dd/MM/yyyy")));
}
else
{
_obj(dtMerge, oPrintersetting.PrinterName, false, _objGirviCommon.getPageNumber((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j - 1)).ToString("dd/MM/yyyy")), _objGirviCommon.getOpeningBalanceWithlastDate((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j - 1)).ToString("dd/MM/yyyy")), _objGirviCommon.getOpeningBalanceWithlastDate((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j)).ToString("dd/MM/yyyy")));
}
// _objfrm_ReportViewer.Show();
//DataTable dtmerge=_objCommon.mergeTwoDataGrid(_objCommon.DataGridView2DataTable(dgv_GirviAdded,"table1"),_objCommon.DataGridView2DataTable(dgv_GirviRelease,"table2"));
//RokadoneNew(dtmerge, totalGirviAmount.ToString(), totalReleaseAmount.ToString(), totalinterestamt.ToString(), pageno);
}
if (dt1.Rows.Count > 0)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveRokadMultiRecord);
if (rbt_OtherTrue.Checked == true)
{
_obj(dtMerge, oPrintersetting.PrinterName, true, _objGirviCommon.getPageNumber((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j - 1)).ToString("dd/MM/yyyy")), _objGirviCommon.getOpeningBalanceWithlastDate((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j - 1)).ToString("dd/MM/yyyy")), _objGirviCommon.getOpeningBalanceWithlastDate((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j)).ToString("dd/MM/yyyy")));
}
else
{
_obj(dtMerge, oPrintersetting.PrinterName, false, _objGirviCommon.getPageNumber((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j - 1)).ToString("dd/MM/yyyy")), _objGirviCommon.getOpeningBalanceWithlastDate((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j - 1)).ToString("dd/MM/yyyy")), _objGirviCommon.getOpeningBalanceWithlastDate((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j)).ToString("dd/MM/yyyy")));
}
// _objfrm_ReportViewer.Show();
//DataTable dtmerge=_objCommon.mergeTwoDataGrid(_objCommon.DataGridView2DataTable(dgv_GirviAdded,"table1"),_objCommon.DataGridView2DataTable(dgv_GirviRelease,"table2"));
//RokadoneNew(dtmerge, totalGirviAmount.ToString(), totalReleaseAmount.ToString(), totalinterestamt.ToString(), pageno);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
public void CustomerBill(string BillNo, string Type)
{
string company = "SELECT * from CompanyMaster";
DataTable dt_CompanyInfo = _objsqlhelper.GetDataTable(company);
string BillingDetails = "Select * from CustomerBill Where BillNo='" + BillNo + "' and (PermanentDelete = 0 or PermanentDelete is Null) ";
DataTable dt_BillingDetails = _objsqlhelper.GetDataTable(BillingDetails);
string BillType, PayType;
if (dt_BillingDetails.Rows[0]["State"].ToString() == dt_CompanyInfo.Rows[0]["State"].ToString())
{
BillType = "GST_Interstate";
}
else
{
BillType = "GST_OtherState";
}
string crname = "Select SaleBill from CrystalReport Where Type='" + BillType + "'";
string str_crname = _objsqlhelper.ExecuteScalar(crname);
ReportDocument _objReport = new ReportDocument();
_objReport.Load(Environment.CurrentDirectory + "\\" + str_crname);
_objReport.Database.Tables["CompanyInfo"].SetDataSource(dt_CompanyInfo);
_objReport.Database.Tables["CustomerBill"].SetDataSource(dt_BillingDetails);
DataTable dt_CustomerInfo = _sales.GetCustomerByBill(BillNo);
_objReport.Database.Tables["CustomerDetails"].SetDataSource(dt_CustomerInfo);
DataTable dt_ItemsDetails = _sales.GetBillItem(BillNo, "Sale");
_objReport.Database.Tables["BillItem"].SetDataSource(dt_ItemsDetails);
string qty = Convert.ToString(_common.sumDataTableColumn(dt_ItemsDetails, "Qty"));
DataTable dt_Payment = _a.getpaymentByBill(BillNo, "Sale", "0");
_objReport.Database.Tables["Payment"].SetDataSource(dt_Payment);
try
{
string Balance = Convert.ToString(_sales.GetBalance(dt_CustomerInfo.Rows[0]["CustId"].ToString(), "Sale"));
_objReport.SetParameterValue("Balance", Balance);
}
catch (Exception ex)
{
_error.AddException(ex, "ReportViewer");
MessageBox.Show(ex.ToString());
}
try
{
PayType = "Cash";
if (dt_Payment.Rows.Count > 0)
{
if (dt_BillingDetails.Rows[0]["BillAmount"] == dt_Payment.Rows[0]["Amt"])
{
PayType = "Cash";
}
else
{
PayType = "Credit";
}
}
_objReport.SetParameterValue("Type", PayType);
}
catch (Exception ex)
{
_error.AddException(ex, "ReportViewer");
}
try
{
double inword = Convert.ToDouble(dt_BillingDetails.Rows[0]["BillAmount"].ToString());
inword = Math.Round(inword);
int number = Convert.ToInt32(inword);
string inwordsString = _objCommon.NumberToWords(number);
_objReport.SetParameterValue("inwords", inwordsString);
}
catch (Exception ex)
{
_error.AddException(ex, "ReportViewer");
}
try
{
_objReport.SetParameterValue("Qty", qty);
}
catch (Exception ex)
{
_error.AddException(ex, "ReportViewer");
}
if (Type == "Print")
{
if (_objPrinterSetting.ShowDialog() == DialogResult.OK)
{
try
{
int Copies = _objPrinterSetting.copies;
_objReport.PrintOptions.PrinterName = _objPrinterSetting.PrinterName;
_objReport.PrintToPrinter(Copies, true, 0, 0);
printresult = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
if (printresult == true)
{
printresult = false;
}
}
else
{
crReportViewer.ReportSource = _objReport;
crReportViewer.Show();
return;
}
}
else
{
crReportViewer.ReportSource = _objReport;
crReportViewer.Show();
return;
}
}
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);
}
}
}
}
}
private void bttn_login_Click(object sender, EventArgs e)
{
if (rbt_OtherTrue.Checked == true)
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataNotice);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
//_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["AmountDeposit"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
else
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataNotice);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
//_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["AmountDeposit"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
}
if (rbt_English.Checked == true)
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataNotice);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
//_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["AmountDeposit"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
else
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataNotice);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
//_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["AmountDeposit"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
}
else
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataNotice);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "", oPrintersetting.PrinterName);
//_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["AmountDeposit"].Value.ToString(), txt_KhatawaniNo.Text, "", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
else
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataNotice);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "", oPrintersetting.PrinterName);
//_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["AmountDeposit"].Value.ToString(), txt_KhatawaniNo.Text, "", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
}
}
