private DataTable PaymentData(string SubDivision, string CounterName, string fromdate, string todate, string userid)
{
report_Prop reportProp = new report_Prop();
reportProp.SubDivision = SubDivision;
reportProp.CounterName = CounterName;
reportProp.fromdate = fromdate;
reportProp.todate = todate;
reportProp.UserId = userid;
report_bal reportbal = new report_bal();
DataTable dt = reportbal.PaymentData(reportProp);
return(dt);
}
private DataTable exporttoexcel(string SubDivision, string CounterName, string fromdate, string todate, string userid)
{
report_Prop reportProp = new report_Prop();
reportProp.SubDivision = SubDivision;
reportProp.CounterName = CounterName;
reportProp.fromdate = fromdate;
reportProp.todate = todate;
reportProp.UserId = userid;
report_bal reportbal = new report_bal();
DataTable dt = reportbal.ReportDailyPCSheet(reportProp);
return(dt);
}
private string filluser(int CounterId)
{
counter_Prop counterProp = new counter_Prop();
counterProp.Counterid = CounterId;
report_bal reportbal = new report_bal();
DataTable dt = reportbal.fillUser(counterProp);
StringBuilder sb = new StringBuilder();
if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
{
return("0#" + reportbal.ErrMessage + "$");
}
else
{
if (dt.Rows.Count > 0)
{
StringBuilder sbtxt = new StringBuilder();
for (int i = 0; i < dt.Rows.Count; i++)
{
sbtxt.Append(dt.Rows[i]["UserID"].ToString() + "#" + dt.Rows[i]["UserName"].ToString() + "$");
}
return(sbtxt.ToString());
}
else
{
return("0#No Data Found$");
}
}
return(sb.ToString());
}
private string PaymentData(string SubDivision, string CounterName, string fromdate, string todate, string userid)
{
report_Prop reportProp = new report_Prop();
reportProp.SubDivision = SubDivision;
reportProp.CounterName = CounterName;
reportProp.fromdate = fromdate;
reportProp.todate = todate;
reportProp.UserId = userid;
report_bal reportbal = new report_bal();
DataTable dt = reportbal.PaymentData(reportProp);
StringBuilder sb = new StringBuilder();
if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
{
return("0#" + reportbal.ErrMessage + "$");
}
else
{
sb.Append("<tr>");
sb.Append("<th colspan=15>" + "Daily Payment Data" + "</th>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<th>" + "SDO" + "</th>");
sb.Append("<th>" + "ACCNo" + "</th>");
sb.Append("<th>" + "Counter No" + "</th>");
sb.Append("<th>" + "ReceiptNo" + "</th>");
sb.Append("<th>" + "AMOUNT" + "</th>");
sb.Append("<th>" + "RDATE" + "</th>");
sb.Append("<th>" + "CHEQUENO" + "</th>");
sb.Append("<th>" + "CHQ DATE" + "</th>");
sb.Append("<th>" + "BANK" + "</th>");
sb.Append("<th>" + "Mode Of Payment" + "</th>");
sb.Append("<th>" + "Status" + "</th>");
sb.Append("<th>" + "CounterName" + "</th>");
sb.Append("<th>" + "Entered Time" + "</th>");
sb.Append("<th>" + "Consumer Name" + "</th>");
sb.Append("</tr>");
if (dt.Rows.Count > 0)
{
sb.Append("$");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>" + dt.Rows[i]["SDO"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["ACCNo"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["Counter No"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["ReceiptNo"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["AMOUNT"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["RDATE"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["CHEQUENO"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["CHQ DATE"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["BANK"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["Mode Of Payment"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["Status"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["CounterName"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["Entered Time"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["Consumer Name"].ToString() + "</td>");
sb.Append("</tr>");
}
}
else
{
sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
}
//sb.Append("<tr><td colspan='9'>No Record Found</td></tr>");
}
return(sb.ToString());
}
private string DailyPCSheet(string SubDivision, string CounterName, string fromdate, string todate, string userid)
{
report_Prop reportProp = new report_Prop();
reportProp.SubDivision = SubDivision;
reportProp.CounterName = CounterName;
reportProp.fromdate = fromdate;
reportProp.todate = todate;
reportProp.UserId = userid;
report_bal reportbal = new report_bal();
DataTable dt = reportbal.ReportDailyPCSheet(reportProp);
StringBuilder sb = new StringBuilder();
if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
{
return("0#" + reportbal.ErrMessage + "$");
}
else
{
sb.Append("<tr>");
sb.Append("<th colspan=9>" + "Daily Payment ControlSheet" + "</th>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<th>" + "Sr No" + "</th>");
sb.Append("<th>" + "ACCNo" + "</th>");
sb.Append("<th>" + "PAYDATE" + "</th>");
sb.Append("<th>" + "COUNTERNO" + "</th>");
sb.Append("<th>" + "ReceiptNo" + "</th>");
sb.Append("<th>" + "AMOUNT" + "</th>");
sb.Append("<th>" + "CASH/CHEQUE" + "</th>");
sb.Append("<th>" + "CHEQUENO" + "</th>");
sb.Append("<th>" + "USER" + "</th>");
sb.Append("</tr>");
if (dt.Rows.Count > 0)
{
sb.Append("$");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>" + dt.Rows[i]["SrNo"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["ACCNo"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["PAYDATE"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["COUNTERNO"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["ReceiptNo"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["AMOUNT"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["CASH/CHEQUE"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["CHEQUENO"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["USER"].ToString() + "</td>");
sb.Append("</tr>");
}
}
else
{
sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
}
//sb.Append("<tr><td colspan='9'>No Record Found</td></tr>");
}
return(sb.ToString());
}
private string DailyCSUserWise(string CounterName, string user, string fromdate, string todate, string userid)
{
report_Prop reportProp = new report_Prop();
reportProp.CounterName = CounterName;
reportProp.UserName = user;
reportProp.fromdate = fromdate;
reportProp.todate = todate;
reportProp.UserId = userid;
report_bal reportbal = new report_bal();
DataTable dt = reportbal.DailyCSUserWise(reportProp);
StringBuilder sb = new StringBuilder();
if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
{
return("0#" + reportbal.ErrMessage + "$");
}
else
{
sb.Append("<tr>");
sb.Append("<th colspan=7>" + "Daily Collection Summary User Wise" + "</th>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<th>" + "User Name" + "</th>");
sb.Append("<th>" + "TOTAL CASHSTUBS" + "</th>");
sb.Append("<th>" + "TOTALCASHS Amount" + "</th>");
sb.Append("<th>" + "TOTAL CHQ STUBS" + "</th>");
sb.Append("<th>" + "TOTAL CHQ Amount" + "</th>");
sb.Append("<th>" + "Total Stub" + "</th>");
sb.Append("<th>" + "TotalAmount" + "</th>");
sb.Append("</tr>");
if (dt.Rows.Count > 0)
{
sb.Append("$");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>" + dt.Rows[i]["username"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["TOTAL CASHSTUBS"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["TOTALCASHSAMount"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["TOTAL CHQ STUBS"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["TOTALCHQAmount"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["TotalStub"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["TotalAmount"].ToString() + "</td>");
sb.Append("</tr>");
}
}
else
{
sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
}
//sb.Append("<tr><td colspan='13'>No Record Found</td></tr>");
}
return(sb.ToString());
}
private string repReceiptno(string SubDivision, string CounterName, string fromdate, string todate, string userid, string Receiptno)
{
report_Prop reportProp = new report_Prop();
reportProp.SubDivision = SubDivision;
reportProp.CounterName = CounterName;
reportProp.fromdate = fromdate;
reportProp.todate = todate;
reportProp.UserId = userid;
reportProp.Receiptno = Receiptno;
report_bal reportbal = new report_bal();
DataTable dt = reportbal.Receiptno(reportProp);
StringBuilder sb = new StringBuilder();
if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
{
return("0#" + reportbal.ErrMessage + "$");
}
else
{
sb.Append("<tr>");
sb.Append("<th colspan=10>" + "Cashier location allocation report" + "</th>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<th>" + "Sr No" + "</th>");
sb.Append("<th>" + "ACCNo" + "</th>");
sb.Append("<th>" + "PAYDATE" + "</th>");
sb.Append("<th>" + "COUNTERNO" + "</th>");
sb.Append("<th>" + "ReceiptNo" + "</th>");
sb.Append("<th>" + "AMOUNT" + "</th>");
sb.Append("<th>" + "CASH/CHEQUE" + "</th>");
sb.Append("<th>" + "CHEQUENO" + "</th>");
sb.Append("<th>" + "USER" + "</th>");
sb.Append("<th>" + "Print" + "</th>");
sb.Append("</tr>");
if (dt.Rows.Count > 0)
{
sb.Append("$");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>" + dt.Rows[i]["SrNo"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["ACCNo"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["PAYDATE"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["COUNTERNO"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["ReceiptNo"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["AMOUNT"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["CASH/CHEQUE"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["CHEQUENO"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["USER"].ToString() + "</td>");
sb.Append("<td ><img src='images/print.jpeg' alt='delete' onclick=PrintReceipt('");
sb.Append(dt.Rows[i]["paymentid"].ToString().Trim() + "') /></td>");
sb.Append("</tr>");
}
}
else
{
sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
}
//sb.Append("<tr><td colspan='9'>No Record Found</td></tr>");
}
return(sb.ToString());
}
private string DailyChequeWise(string SubDivision, string CounterName, string Bank, string User, string fromdate, string todate, string userid)
{
report_Prop reportProp = new report_Prop();
reportProp.SubDivision = SubDivision;
reportProp.CounterName = CounterName;
reportProp.Bank = Bank;
reportProp.UserName = User;
reportProp.fromdate = fromdate;
reportProp.todate = todate;
reportProp.UserId = userid;
report_bal reportbal = new report_bal();
DataTable dt = reportbal.DailyChequeWise(reportProp);
StringBuilder sb = new StringBuilder();
if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
{
return("0#" + reportbal.ErrMessage + "$");
}
else
{
sb.Append("<tr>");
sb.Append("<th colspan=9>" + "Daily Cheque Report Cheque Wise" + "</th>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<th>" + "Sr No" + "</th>");
sb.Append("<th>" + "SDO" + "</th>");
sb.Append("<th>" + "SDO Name" + "</th>");
sb.Append("<th>" + "ACCNo" + "</th>");
sb.Append("<th>" + "CHEQUENO" + "</th>");
sb.Append("<th>" + "CHQ DATE" + "</th>");
sb.Append("<th>" + "BANK" + "</th>");
sb.Append("<th>" + "UNDER A/C" + "</th>");
sb.Append("<th>" + "AMOUNT" + "</th>");
sb.Append("</tr>");
if (dt.Rows.Count > 0)
{
sb.Append("$");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>" + dt.Rows[i]["SrNo"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["SDO"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["SDO Name"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["ACCNo"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["CHEQUENO"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["CHQ DATE"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["BANK NAME"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["UNDER A/C"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["AMOUNT"].ToString() + "</td>");
sb.Append("</tr>");
}
}
else
{
sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
}
//sb.Append("<tr><td colspan='13'>No Record Found</td></tr>");
}
return(sb.ToString());
}
private string DatewiseSPS(string CounterName, string fromdate, string todate, string userid)
{
report_Prop reportProp = new report_Prop();
reportProp.CounterName = CounterName;
reportProp.fromdate = fromdate;
reportProp.todate = todate;
reportProp.UserId = userid;
report_bal reportbal = new report_bal();
DataTable dt = reportbal.DatewiseSPS(reportProp);
StringBuilder sb = new StringBuilder();
if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
{
return("0#" + reportbal.ErrMessage + "$");
}
else
{
sb.Append("<tr>");
sb.Append("<th colspan='11'>" + "Date wise Subdivision wise Payment Summary" + "</th>");
sb.Append("</tr>");
sb.Append("<tr>");
for (int i = 0; i < dt.Columns.Count; i++)
{
sb.Append("<th>" + dt.Columns[i].ColumnName.ToString() + "</th>");
}
sb.Append("</tr>");
if (dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() != "")
{
sb.Append("$");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
for (int j = 0; j < dt.Columns.Count; j++)
{
sb.Append("<td>" + dt.Rows[i][j].ToString() + "</td>");
}
sb.Append("</tr>");
}
}
else
{
sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td></tr>");
}
}
else
{
sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td></tr>");
}
//sb.Append("<tr><td colspan='13'>No Record Found</td></tr>");
}
return(sb.ToString());
}
