public static SMSTopUpTransaction SMSTopUp(Params request)
{
SMSTopUpTransaction transaction = new SMSTopUpTransaction();
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
try
{
param.RequestTransType = "GetTopUpTransactionByMobileNo";
param.Parameter.Add("FK_CustID", request.Parameter.ContainsKey("mobileNo") ? request.Parameter["mobileNo"].Trim() : string.Empty);
param.Parameter.Add("StartDate", Formatter.ToStringExact(Convert.ToDateTime(request.Parameter["startDate"]), "MM/dd/yyyy"));
param.Parameter.Add("EndDate", Formatter.ToStringExact(Convert.ToDateTime(request.Parameter["endDate"]).AddDays(1), "MM/dd/yyyy"));
param.WSDL = "ESBDBDelimiter";
ESBData data = EAI.RetrieveESBData(param);
if (data.Result != null && data.Result.Count > 0)
{
foreach (StringDictionary entry in data.Result)
{
SMSTopUpTRX trx = new SMSTopUpTRX();
DateTime? TransactionDate = Formatter.ParseExact(entry["createddate"], "MM/dd/yyyy hh:mm:ss tt");
trx.TransactionDate = TransactionDate;
trx.RequestId = entry["billerid"];
trx.AtmCardNumber = entry["cardnumber"];
trx.AccountNumber = entry["acctidfrom"];
trx.ValueOfTransactions = Formatter.GetParsedNumeric(entry["amt"], false);
trx.ResponseCode = Utility.GetDisplayText("TransactionAttributeMapping", "SMS Top Up", "Response Code", entry["srvrstatuscode"]);
transaction.Transactions.Add(trx);
}
param.Parameter = new Dictionary <string, string>();
param.RequestTransType = "GetTopUpInfoByMobileNo";
param.Parameter.Add("CustId", request.Parameter.ContainsKey("mobileNo") ? request.Parameter["mobileNo"].Trim() : string.Empty);
param.WSDL = "ESBDBDelimiter";
ESBData information = EAI.RetrieveESBData(param);
if (information.Result != null && information.Result.Count > 0)
{
transaction.ATMCardNumber = information.Result[0]["cardnumber"];
transaction.ATMCardHolderName = information.Result[0]["custname"];
transaction.Status = Utility.GetStatusInfo(information.Result[0]["status"]);
}
}
}
catch (Exception e)
{
}
return(transaction);
}
public JsonResult LoadGrid(string sidx, string sord, int rows, int page = 1)
{
string getSearchby = Request["_searchby"];
string getVal = Request["_val"];
string getStartDate = Request["_startDate"];
string getEndDate = Request["_endDate"];
string getTrxType = Request["_trxType"];
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
param.RequestTransType = "GetTopUpTransactionByMobileNo";
param.Parameter.Add("mobileNo", getVal);
param.Parameter.Add("startDate", getStartDate);
param.Parameter.Add("endDate", getEndDate);
SMSTopUpTransaction model = ChannelTransaction.SMSTopUp(param);
var trx = model.Transactions.ToList().Select(x => new
{
AtmCardNumber = x.AtmCardNumber,
TransactionDate = x.TransactionDate,
RequestId = x.RequestId,
AccountNumber = x.AccountNumber,
ValueOfTransactions = x.ValueOfTransactions,
ResponseCode = x.ResponseCode,
});
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = trx.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
trx = trx.Skip((page - 1) * pageSize).Take(pageSize);
var recordCount = trx.Count();
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = trx.ToArray();
jTable.additional = model.ATMCardHolderName + "<@z>" + model.ATMCardNumber + "<@z>" + model.Status;
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
