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()); }