private string PaymentInsert(int BillID, string Mode, string Amount, string Bankid, string CDate, string CNo, string PhoneNo, string paymenttype, string username, string emailid, string status)
{
Common cm = new Common();
payment_Prop paymentprop = new payment_Prop();
paymentprop.BillID = BillID;
paymentprop.SubdivisionCode = paymenttype;
paymentprop.Mode = Mode;
paymentprop.Amount = Convert.ToDouble(Amount);
paymentprop.Bankid = Convert.ToInt16(Bankid.Replace("select", "0"));
paymentprop.ChequeDate = CDate == "" ? "01/01/1900" : cm.MMDDYYYY(CDate);
paymentprop.ChequeNo = CNo;
paymentprop.PhoneNo = PhoneNo;
paymentprop.UserName = username;
paymentprop.Emailid = emailid;
paymentprop.status = Convert.ToInt32(status);
payment_bal paymentbal = new payment_bal();
string strmsg = paymentbal.PaymentInsert(paymentprop);
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
return(paymentbal.ErrMessage);
}
else
{
return(strmsg);
}
}
private string SendSMS(int id)
{
payment_Prop paymentprop = new payment_Prop();
paymentprop.PaymentID = id;
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.PaymentSelect(paymentprop);
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
return("Unable to send message");
}
else
{
if (dt.Rows.Count > 0)
{
string Amount = dt.Rows[0]["Amount"].ToString();
string PhoneNo = dt.Rows[0]["PhoneNo"].ToString();
return(SMSThread(PhoneNo, "We wish to confirm the receipt of your payment of Rs." + Amount));
}
else
{
return("Unable to send message");
}
}
}
private string BillingSelect(string SDOCode, string AccountNo)
{
StringBuilder sb = new StringBuilder();
payment_Prop paymentprop = new payment_Prop();
paymentprop.SubdivisionCode = SDOCode;
paymentprop.AccountNo = AccountNo;
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.BillingSelect(paymentprop);
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
return(paymentbal.ErrMessage);
}
else
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
sb.Append(dt.Rows[0][i].ToString() + "#");
}
return(sb.ToString() + SDOCode);
}
else
{
return("No Data Found");
}
}
}
private string PaymentSummary(string username)
{
payment_bal paymentbal = new payment_bal();
payment_Prop paymentprop = new payment_Prop();
paymentprop.UserName = username;
DataTable dt = paymentbal.PaymentSummary(paymentprop);
StringBuilder sb = new StringBuilder();
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
sb.Append("0#0#0#0#0#0#0#");
}
else
{
if (dt.Rows.Count <= 0)
{
sb.Append("0#0#0#0#0#0#0#");
}
else
{
sb.Append(dt.Rows[0]["LastReceiptNo"].ToString() + "#" + dt.Rows[0]["LastReceiptAmount"].ToString() + "#" + dt.Rows[0]["TotalCash"].ToString() + "#" + dt.Rows[0]["TotalCheque"].ToString() + "#" + dt.Rows[0]["TotalReceipt"].ToString() + "#" + dt.Rows[0]["NoofCheques"].ToString() + "#" + dt.Rows[0]["TotalAmount"].ToString() + "#");
}
}
return(sb.ToString());
}
private string ConsumerSelect(string subdivisioncode, string name, string saccountno)
{
payment_Prop paymentprop = new payment_Prop();
paymentprop.SubdivisionCode = subdivisioncode;
paymentprop.Name = name;
paymentprop.AccountNo = saccountno;
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.ConsumerSelect(paymentprop);
StringBuilder sb = new StringBuilder();
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
sb.Append("<tr><td>" + paymentbal.ErrMessage + "</td><td></td><td></td></tr>");
}
else
{
if (dt.Rows.Count <= 0)
{
sb.Append("<tr><td >No Record Found</td><td></td><td></td></tr>");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td onclick=Populate('" + dt.Rows[i]["SubDivisionID"].ToString() + "#" + dt.Rows[i]["AccountNO"].ToString() + "')>" + dt.Rows[i]["AccountNO"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["Name"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["Address"].ToString() + "</td>");
sb.Append("</tr>");
}
}
}
return(sb.ToString());
}
private string GenerateReceipt(int Paymentid)
{
try
{
CrystalReport1 cr = new CrystalReport1();
//this.printDialog1.Document = this.printDocument1;
//string PrinterName = this.printDocument1.PrinterSettings.PrinterName;
// System.Drawing.Printing.PrinterSettings settings = new PrinterSettings();
string Printer = GetDefaultPrinterName();
//int i=0;
//foreach (string Printer_loopVariable in System.Drawing.Printing.PrinterSettings.InstalledPrinters)
//{
// if (i == 1)
// {
// Printer = Printer_loopVariable;
// }
// i = i + 1;
//}
//return Printer;
// if (Printer == "Error1")
// {
// return "Error1d";
// }
// else
// {
//cr.PrintOptions.PrinterName = @"\\192.168.102.81\Send To OneNote 2007";
cr.PrintOptions.PrinterName = "Thermal";
//}
// System.Drawing.Printing.PrinterSettings oPS = new System.Drawing.Printing.PrinterSettings();
//cr.PrintOptions.PrinterName = oPS.PrinterName;
payment_Prop paymentprop = new payment_Prop();
paymentprop.PaymentID = Paymentid;
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.PaymentSelect(paymentprop);
cr.SetDataSource(dt);
TextObject txt = (TextObject)cr.Section3.ReportObjects["txtAmtInWords"];
string AmtinWords = retWord(Convert.ToInt32(Math.Round(Convert.ToDouble(dt.Rows[0]["amount"].ToString()), 0).ToString()));
txt.Text = AmtinWords;
cr.PrintToPrinter(1, true, 1, 1);
string s = cr.PrintOptions.PrinterName.ToString();
return(s);
}
catch (Exception ex)
{
return(ex.Message);
}
}
private string checkclosedtrasction(string user)
{
payment_Prop paymentprop = new payment_Prop();
paymentprop.UserName = user;
payment_bal paymentbal = new payment_bal();
string strmsg = paymentbal.checkclosedtrasction(paymentprop);
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
return(paymentbal.ErrMessage);
}
else
{
return(strmsg);
}
}
private string PaymentDelete(int paymentid)
{
payment_Prop paymentprop = new payment_Prop();
paymentprop.PaymentID = paymentid;
payment_bal paymentbal = new payment_bal();
string strmsg = paymentbal.PaymentDelete(paymentprop);
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
return(paymentbal.ErrMessage);
}
else
{
return(strmsg);
}
}
private string CancelBill(int sdocode, string fusername)
{
payment_Prop lpayment_Prop = new payment_Prop();
lpayment_Prop.PaymentID = sdocode;
lpayment_Prop.UserName = fusername;
payment_bal lpayment_bal = new payment_bal();
string strMsg = lpayment_bal.BillCancel(lpayment_Prop);
if (lpayment_bal.ErrMessage != "" && lpayment_bal.ErrMessage != null)
{
return(lpayment_bal.ErrMessage);
}
else
{
return(strMsg);
}
}
private string PaymentIDs(string BillIds)
{
payment_Prop paymentprop = new payment_Prop();
paymentprop.BillIDs = BillIds.Substring(1);
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.PaymentSelectByBillID(paymentprop);
string strData = "";
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
strData = strData + "," + dt.Rows[i][0].ToString();
}
}
return(strData);
}
private string ChangeBillDuedate(int billid, string username, string duedate)
{
payment_Prop paymentprop = new payment_Prop();
paymentprop.BillID = billid;
paymentprop.UserName = username;
paymentprop.ChequeDate = duedate;
payment_bal paymentbal = new payment_bal();
string strmsg = paymentbal.PaymentChangeDuedate(paymentprop);
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
return(paymentbal.ErrMessage);
}
else
{
return(strmsg);
}
}
protected void btnsearch_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
payment_Prop paymentprop = new payment_Prop();
paymentprop.SubdivisionCode = subdivision.SelectedValue;
paymentprop.AccountNo = binderno.Value + accountno.Value;
paymentprop.Receiptno = receiptno.Value;
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.PaymentSelectCancel(paymentprop);
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
sb.Append("<tr><td >" + paymentbal.ErrMessage + "</td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
}
else
{
if (dt.Rows.Count <= 0)
{
sb.Append("<tr><td >No Record Found</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>" + dt.Rows[i]["Name"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["Subdivisioncode"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["Consumeraccountno"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["receiptno"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["CounterName"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["PaymentDate"].ToString() + "</td>");
sb.Append("<td>" + Math.Round(Convert.ToDouble(dt.Rows[i]["Amount"].ToString()), 2).ToString(".00") + "</td>");
sb.Append("<td ><img src='images/icon_delete.png' alt='delete' onclick=DeleteSDO('");
sb.Append(dt.Rows[i]["paymentid"].ToString().Trim() + '$' + dt.Rows[i]["Phoneno"].ToString().Trim() + '$' + dt.Rows[i]["EmailId"].ToString().Trim() + '$' + dt.Rows[i]["PayAmount"].ToString().Trim());
sb.Append("') /></td>");
sb.Append("</tr>");
}
}
tbody.InnerHtml = sb.ToString();
}
}
private void SpViewReport(string Paymentid)
{
CrystalReport1 cr = new CrystalReport1();
cr.Load(Server.MapPath("CrystalReport1.rpt"));
payment_Prop paymentprop = new payment_Prop();
paymentprop.PaymentID = Convert.ToInt32(Paymentid);
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.PaymentSelect(paymentprop);
cr.SetDataSource(dt);
TextObject txt = (TextObject)cr.Section3.ReportObjects["txtAmtInWords"];
string AmtinWords = retWord(Convert.ToInt32(Math.Round(Convert.ToDouble(dt.Rows[0]["amount"].ToString()), 0).ToString()));
txt.Text = AmtinWords;
//cr.PrintToPrinter(1,true,1,1);
CrystalReportViewer1.ReportSource = cr;
}
private string PaymentChequeSelect_new(int bankid, string chequeno, string chedate)
{
Common cm = new Common();
payment_Prop paymentprop = new payment_Prop();
paymentprop.Bankid = bankid;
paymentprop.ChequeNo = chequeno;
paymentprop.ChequeDate = cm.MMDDYYYY(chedate);
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.PaymentChequeSelect_new(paymentprop);
StringBuilder sb = new StringBuilder();
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
sb.Append("<tr><td>" + paymentbal.ErrMessage + "</td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
}
else
{
if (dt.Rows.Count <= 0)
{
sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>" + Convert.ToInt16(i + 1).ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["SubdivisionID"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["AccountNo"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["paymentdate"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["paymenttype"].ToString() + "</td>");
sb.Append("<td>" + Convert.ToDecimal(dt.Rows[i]["Amount"].ToString()).ToString("0.00") + "</td>");
//sb.Append("<td><img src='images/icon_delete.png' alt='reset' onclick='DeleteRecord(" + dt.Rows[i]["paymentid"].ToString() + ")'><img src='images/receipt.png' alt='receipt' onclick='GenerateReceipt(" + dt.Rows[i]["paymentid"].ToString() + ")'><img src='images/sms.png' alt='sms' onclick='SendSMS(" + dt.Rows[i]["paymentid"].ToString() + ")'></td>");
sb.Append("<td><img src='images/icon_delete.png' alt='reset' onclick='DeleteRecord(" + dt.Rows[i]["paymentid"].ToString() + "," + dt.Rows[i]["amount"].ToString() + ")'></td>");
sb.Append("</tr>");
}
}
}
return(sb.ToString());
}
private string BillingSelect(string SDOCode, string AccountNo, string receiptno)
{
StringBuilder sb = new StringBuilder();
payment_Prop paymentprop = new payment_Prop();
paymentprop.SubdivisionCode = SDOCode;
paymentprop.AccountNo = AccountNo;
paymentprop.Receiptno = receiptno;
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.PaymentSelectCancel(paymentprop);
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
return(paymentbal.ErrMessage);
}
else
{
if (dt.Rows.Count <= 0)
{
sb.Append("<tr><td >No Record Found</td><td></td><td></td><td></td><td></td><td></td></tr>");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>" + dt.Rows[i]["Name"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["billdate"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["duedate"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["BillAmount"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["PayAmount"].ToString() + "</td>");
sb.Append("<td ><img src='images/icon_delete.png' alt='delete' onclick=DeleteSDO('");
sb.Append(dt.Rows[i]["paymentid"].ToString().Trim() + '$' + dt.Rows[i]["Phoneno"].ToString().Trim() + '$' + dt.Rows[i]["EmailId"].ToString().Trim() + '$' + dt.Rows[i]["PayAmount"].ToString().Trim());
sb.Append("') /></td>");
sb.Append("</tr>");
}
}
return(sb.ToString());
}
}
private string PaymentUserSummary(string username, string fromdate, string todate)
{
Common cm = new Common();
payment_Prop paymentprop = new payment_Prop();
paymentprop.UserName = username;
paymentprop.Fromdate = cm.MMDDYYYY(fromdate);
paymentprop.Todate = cm.MMDDYYYY(todate);
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.PaymentUserSummary(paymentprop);
StringBuilder sb = new StringBuilder();
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
sb.Append("<tr><td>" + paymentbal.ErrMessage + "</td><td></td><td></td><td></td><td></td><td></td></tr>");
}
else
{
if (dt.Rows.Count <= 0)
{
sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td><td></td></tr>");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>" + dt.Rows[i]["Subdivisioncode"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["ConsumerAccountNo"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["paymentdate"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["mode"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["Amount"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["username"].ToString() + "</td>");
sb.Append("</tr>");
}
}
}
return(sb.ToString());
}
private string PaymentUpdateMultiple(int bankid, string chequeno, string chedate)
{
Common cm = new Common();
payment_Prop paymentprop = new payment_Prop();
paymentprop.Bankid = bankid;
paymentprop.ChequeNo = chequeno;
paymentprop.ChequeDate = cm.MMDDYYYY(chedate);
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.PaymentUpdateMultiple(paymentprop);
StringBuilder sb = new StringBuilder();
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
sb.Append(paymentbal.ErrMessage);
}
else
{
sb.Append(dt.Rows[0][0].ToString());
}
return(sb.ToString());
}
private string BillingSelect(string AccountNo)
{
StringBuilder sb = new StringBuilder();
payment_Prop paymentprop = new payment_Prop();
paymentprop.AccountNo = AccountNo;
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.PaymentSelectChangeDuedate(paymentprop);
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
return(paymentbal.ErrMessage);
}
else
{
if (dt.Rows.Count <= 0)
{
sb.Append("<tr><td >No Record Found</td><td></td><td></td><td></td><td></td><td></td></tr>");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>" + dt.Rows[i]["BillID"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["Name"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["billdate"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["duedate"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["Amount"].ToString() + "</td>");
sb.Append("<td ><input type='checkbox' id='chkBoxChild' /></td> ");
sb.Append("</tr>");
}
}
return(sb.ToString());
}
}
private string PaymentCloseTransaction(string fromdate)
{
Common cm = new Common();
payment_Prop paymentprop = new payment_Prop();
paymentprop.Fromdate = cm.MMDDYYYY(fromdate);
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.PaymentClosedTransaction(paymentprop);
StringBuilder sb = new StringBuilder();
if (paymentbal.ErrMessage != "" && paymentbal.ErrMessage != null)
{
sb.Append("<tr><td>" + paymentbal.ErrMessage + "</td><td></td><td></td><td></td><td></td></tr>");
}
else
{
if (dt.Rows.Count <= 0)
{
sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td></tr>");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>" + dt.Rows[i]["CounterName"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["username"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["TotalTrans"].ToString() + "</td>");
sb.Append("<td>" + dt.Rows[i]["TotalAmount"].ToString() + "</td>");
sb.Append("<td onclick=ShowTrans('" + dt.Rows[i]["username"].ToString() + "')><img src='images/closetransaction.png' alt='close'/></td>");
sb.Append("</tr>");
}
}
}
return(sb.ToString());
}
