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 = "saldo".Equals(getTrxType) ? "GetSMSTransactionInfoSaldo" :
"mutasi".Equals(getTrxType) ? "GetSMSTransactionInfoMutasi" :
"kupon".Equals(getTrxType) ? "GetSMSTransactionInfoCoupon" :
"payment".Equals(getTrxType) ? "GetSMSTransactionInfoPayment" :
"all".Equals(getTrxType) ? "GetSMSTransactionAll" : string.Empty;
param.Parameter.Add("mobileNo", getVal);
param.Parameter.Add("startDate", getStartDate);
param.Parameter.Add("endDate", getEndDate);
SMSBCATransaction model = ChannelTransaction.SMSBCA(param);
var trx = model.Transactions.ToList().Select(x => new
{
TransactionDate = x.TransactionDate,
AccountNumber = x.AccountNumber,
TransactionType = x.TransactionType,
ResponseCode = x.ResponseCode,
Amount = x.Amount,
ReferenceNumber = x.ReferenceNumber,
Biller = x.Biller,
Receiver = x.Receiver,
Total = x.Total,
Other = x.Other
});
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));
}
public static SMSBCATransaction SMSBCA(Params request)
{
SMSBCATransaction transaction = new SMSBCATransaction();
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
try
{
param.RequestTransType = request.RequestTransType;
param.Parameter.Add("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.Parameter.Add("Proses", "GetSMSTransactionInfoSaldo".Equals(param.RequestTransType) ? "SMSBAccGetBalanceRq" :
"GetSMSTransactionInfoMutasi".Equals(param.RequestTransType) ? "SMSBAcctStmtRq" :
"GetSMSTransactionInfoCoupon".Equals(param.RequestTransType) ? "SMSBInqCouponRq" :
"GetSMSTransactionInfoPayment".Equals(param.RequestTransType) ? "SMSBLPGRQ" :
string.Empty);
param.WSDL = "ESBDBDelimiter";
ESBData data = EAI.RetrieveESBData(param);
if (data.Result != null && data.Result.Count > 0)
{
foreach (StringDictionary entry in data.Result)
{
DateTime? transactionDate = Convert.ToDateTime(entry["createddate"]);
string status = entry["srvrstatuscode"];
SMSBCATRX trx = new SMSBCATRX();
trx.TransactionDate = transactionDate;
trx.AccountNumber = entry["acctidfrom"];
trx.TransactionType = Utility.GetDisplayText("TransactionAttributeMapping", "SMS BCA", "Transaction Type", entry["process"]);
trx.ResponseCode = Utility.GetDisplayText("TransactionAttributeMapping", "SMS BCA", "Response Code", status);
trx.Amount = Formatter.GetParsedDouble(entry["amt"], false);
/* Payment Menu
* 07 12 2016 - LPG
* Tanggal Transaksi createddate TransactionDate
* No Rekening acctidfrom AccountNumber
* No Referensi refcode ReferenceNumber
* Jenis Transaksi process -company_name TransactionType + string
* Nominal (IDR) amt Amount
* Status srvrstatuscode - rquid ResponseCode + string
* Pembayar billerid Biller
* Penerima authidresponse [0] Receiver
* Jumlah authidresponse [1] Total
* Informasi Lain authidresponse [2] Other
*/
if ("GetSMSTransactionInfoPayment".Equals(param.RequestTransType))
{
trx.ReferenceNumber = entry["refcode"];
trx.TransactionType += " - " + entry["company_name"];
trx.ResponseCode += " - " + entry["rquid"];
trx.Biller = entry["billerid"];
string[] authidresp = entry["authidresponse"].Split('|');
if (authidresp.Length == 3)
{
trx.Receiver = authidresp[0];
trx.Total = authidresp[1];
trx.Other = authidresp[2].Length == 8 ? Utility.FormatDateAuth(authidresp[2]) : authidresp[2];
}
}
transaction.Transactions.Add(trx);
}
param.Parameter = new Dictionary <string, string>();
param.RequestTransType = "GetSMSBankingInfoByMobileNo";
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.ATMCardHolderName = information.Result[0]["custname"];
transaction.ATMCardNumber = information.Result[0]["cardnumber"];
transaction.Status = Utility.GetStatusInfo(information.Result[0]["status"]);
}
}
}
catch (Exception e)
{
}
return(transaction);
}
