You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
122 lines
5.7 KiB
122 lines
5.7 KiB
using Swift.DAL.BL.Remit.Administration.Customer;
|
|
using Swift.web.Library;
|
|
using System;
|
|
using System.Data;
|
|
using System.Text;
|
|
|
|
namespace Swift.web.Remit.CustomerSOA
|
|
{
|
|
public partial class CustomerSoaReceipt : System.Web.UI.Page
|
|
{
|
|
private readonly SwiftLibrary sl = new SwiftLibrary();
|
|
private readonly CustomersDao obj = new CustomersDao();
|
|
public const string GridName = "CustomerSoa";
|
|
private const string ViewFunctionId = "20192000";
|
|
private string[] transactionIds;
|
|
private string toDate;
|
|
private string fromDate;
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
Authenticate();
|
|
if (!IsPostBack)
|
|
{
|
|
GetStatic.PrintMessage(Page);
|
|
}
|
|
FetchData();
|
|
}
|
|
|
|
private void Authenticate()
|
|
{
|
|
sl.CheckAuthentication(ViewFunctionId);
|
|
}
|
|
|
|
public void FetchData()
|
|
{
|
|
string tranId = GetStatic.ReadSession("tranIds", "");
|
|
string customerId = GetStatic.ReadQueryString("customerId", "");
|
|
string isFor = GetStatic.ReadQueryString("rptFor", "");
|
|
//if (string.IsNullOrEmpty(tranId))
|
|
//{
|
|
// DbResult dbRes = new DbResult
|
|
// {
|
|
// ErrorCode = "1",
|
|
// Msg = "No transaction selected"
|
|
// };
|
|
// GetStatic.SetMessage(dbRes);
|
|
// Response.Redirect("");
|
|
//}
|
|
DataTable tranData = obj.GetCustomerSoaData(GetStatic.GetUser(), tranId, (isFor == "disabled" ? customerId : ""), isFor);
|
|
PrepareHtml(tranData);
|
|
}
|
|
|
|
public void PrepareHtml(DataTable tranData)
|
|
{
|
|
var sb = new StringBuilder("");
|
|
if (tranData.Rows.Count <= 0 || tranData.Rows == null)
|
|
{
|
|
sb.AppendLine("<tr>");
|
|
sb.AppendLine("<td colspan='6' align='center'>");
|
|
sb.AppendLine("No Data To Display ");
|
|
sb.AppendLine("</td>");
|
|
sb.AppendLine("</tr>");
|
|
// tblMain.InnerHtml = sb.ToString();
|
|
return;
|
|
}
|
|
|
|
sb.AppendLine((GenerateReceipt(tranData)));
|
|
//foreach (DataRow dr in tranData.Rows)
|
|
//{
|
|
// sb.AppendLine((GenerateReceipt(dr)));
|
|
//}
|
|
|
|
rpt_grid.InnerHtml = sb.ToString();
|
|
}
|
|
|
|
|
|
public string GenerateReceipt(DataTable dt)
|
|
{
|
|
DataRow firstRow = dt.Rows[0];
|
|
//Int64 TotalAmount;
|
|
var sb = new StringBuilder("");
|
|
|
|
txtperiod.InnerText = GetStatic.ReadQueryString("fromDate", "-") + " TO " + GetStatic.ReadQueryString("toDate", "-");
|
|
txtPrintDate.InnerText = firstRow["PrintTime"].ToString();
|
|
txtName.InnerText = firstRow["senderName"].ToString();
|
|
txtCustomerId.InnerText = firstRow["sCustomerId"].ToString();
|
|
txtAddress.InnerText = firstRow["sAddress"].ToString();
|
|
txtDob.InnerText = firstRow["sdob"].ToString();
|
|
int sNo = 1;
|
|
double totalAmt = 0;
|
|
double collectedAmount = 0;
|
|
string sc = "";
|
|
foreach (DataRow dr in dt.Rows)
|
|
{
|
|
totalAmt += Convert.ToDouble(dr["tAmt"].ToString());
|
|
collectedAmount += Convert.ToDouble(dr["cAmt"].ToString());
|
|
sc = GetStatic.ShowTwoDecimal(dr["serviceCharge"].ToString());
|
|
DateTime date = DateTime.Parse(dr["approvedDate"].ToString());
|
|
string approvedDate = date.ToString("yyyy-MM-dd");
|
|
sb.AppendLine("<tr class=\"table-info\">");
|
|
sb.AppendLine("<td style=\"white-space:nowrap; text-align: center;\">" + sNo + "</td>");
|
|
sb.AppendLine("<td style=\"white-space:nowrap; text-align: center;\">" + approvedDate + "</td>");
|
|
sb.AppendLine("<td style=\"white-space:nowrap; text-align: center;\">" + dr["receiverName"].ToString() + "</td>");
|
|
sb.AppendLine("<td style=\"white-space:nowrap; text-align: center;\">" + dr["controlNo"].ToString() + "</td>");
|
|
sb.AppendLine("<td style=\"white-space:nowrap; text-align: center;\">" + dr["paymentMethod"].ToString() + "</td>");
|
|
sb.AppendLine("<td class=\"tright\" style=\"white-space:nowrap; text-align: center;\">" + GetStatic.ShowTwoDecimal(dr["serviceCharge"].ToString()) + " " + dr["collCurr"].ToString() + "</td>");
|
|
sb.AppendLine("<td class=\"tright\" style=\"white-space:nowrap; text-align: center;\">" + GetStatic.ShowDecimal(dr["tAmt"].ToString()) + " " + dr["collCurr"].ToString() + "</td>");
|
|
sb.AppendLine("<td class=\"tright\" style=\"white-space:nowrap; text-align: center;\">" + GetStatic.ShowDecimal(dr["cAmt"].ToString()) + " " + dr["collCurr"].ToString() + " </td>");
|
|
sb.AppendLine("</tr>");
|
|
sNo++;
|
|
}
|
|
|
|
sb.AppendLine("<tr>");
|
|
sb.AppendLine("<td> </td>");
|
|
sb.AppendLine("<td colspan=\"4\" style=\"text-align: center;\" class=\"tright\">TOTAL</td>");
|
|
sb.AppendLine(" <td style=\"text-align: center;\" class=\"tright\">" + sc + " " + firstRow["collCurr"].ToString() + "</td>");
|
|
sb.AppendLine(" <td style=\"text-align: center;\" class=\"tright\">" + GetStatic.ShowDecimal(totalAmt.ToString()) + " " + firstRow["collCurr"].ToString() + "</td>");
|
|
sb.AppendLine(" <td style=\"text-align: center;\" class=\"tright\">" + GetStatic.ShowDecimal(collectedAmount.ToString()) + " " + firstRow["collCurr"].ToString() + "</td>");
|
|
return sb.ToString();
|
|
}
|
|
}
|
|
}
|