public JsonResult LoadGrid(string sidx, string sord, int rows, int page = 1)
{
if (Request["Tab"] == "History")
{
string getCardNo = (Request["CardNo"].Trim() != "") ? Request["CardNo"].Trim() : null;
string getAcctNo = (Request["AccountNo"].Trim() != "") ? Request["AccountNo"].Trim() : null;
DateTime getTransDate1 = DateTime.ParseExact(Request["TransDate1"], "dd/MM/yyyy", null);
DateTime getTransDate2;
if (Request["TransDate2"] != "")
{
getTransDate2 = DateTime.ParseExact(Request["TransDate2"], "dd/MM/yyyy", null).AddDays(1);
}
else
{
getTransDate2 = getTransDate1.AddDays(1);
}
var data = db.GetHistoryDebitTransactions(getAcctNo, getCardNo, Formatter.FormatDateHist(getTransDate1), Formatter.FormatDateHist(getTransDate2)).ToList()
.Select(x => new
{
MerchantID = x.MerchantId,
TerminalID = x.TerminalId,
Batch = x.Batch,
Date = x.Date,
DateOnly = x.DateOnly,
Time = x.Time,
TrTp = x.TrTp,
CardNo = x.CardNo,
AccountNo = x.AccountNo,
Amount = x.Amount,
Cash = x.Cash,
ResponseCode = x.ResponseCode,
ApprCd = x.ApprCd,
TraceNo = x.TraceNo,
RefNo = x.RefNo,
Cashier = x.Cashier,
RequestID = x.RequestId,
Merchant = x.Merchant,
Date2 = x.Date.ToString()
});
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = data.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
data = data.Skip((page - 1) * pageSize).Take(pageSize);
var recordCount = data.Count();
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = data.ToArray();
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
else
{
var culture = CultureInfo.GetCultureInfo("de-DE");
string atmNo = Request["ATMNo"];
string lnet = Request["LNET"];
string fiid = Request["FIID"];
string terminalId = Request["TerminalID"];
string trxDate = Formatter.ToStringExact(DateTime.ParseExact(Request["TransDate"], "dd/MM/yyyy", null), "MM/dd/yyyy");
string startDate = trxDate + " 00:00:00";
string endDate = trxDate + " 23:59:59";
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
param.Parameter.Add("atmNo", atmNo);
param.Parameter.Add("startDate", startDate);
param.Parameter.Add("endDate", endDate);
param.Parameter.Add("lnet", lnet);
param.Parameter.Add("fiid", fiid);
if (!string.IsNullOrEmpty(terminalId))
{
param.Parameter.Add("terminalId", terminalId);
}
var trx = CurrentTransaction.Debit(param);
var data = trx.Select(x => new
{
Number = x.Number,
TransactionCode = x.TransactionCode,
TransactionDate = x.TransactionDate,
TransactionTime = x.TransactionTime,
Amount = string.Format(culture, "{0:n}", Int32.Parse(x.Amount)),
ResponseCode = x.ResponseCode,
ApprovalCode = x.ApprovalCode,
AtmCardNo = x.AtmCardNo,
TerminalId = x.TerminalId,
CashAmount = string.Format(culture, "{0:n}", Int32.Parse(x.CashAmount)),
AccountNumber = x.AccountNumber,
Retailer = x.Retailer,
TraceNo = x.TraceNo,
Batch = x.Batch,
SequenceNo = x.SequenceNo,
CardType = x.CardType
}
);
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = trx.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
data = data.Skip((page - 1) * pageSize).Take(pageSize);
var recordCount = data.Count();
JSONTable jTable = new JSONTable();
jTable.total = totalPages;
jTable.page = page;
jTable.records = totalRecords;
jTable.rows = data.ToArray();
return(Json(jTable, JsonRequestBehavior.AllowGet));
}
}
