public JsonResult LoadGrid(string sidx, string sord, int rows, int page = 1) { if (Request["Tab"] == "History" && Request["SearchTerminalID"] != "Yes") { Dictionary <string, string> MappingCurrencyCode = getListMapping("CurrencyCode", "CurrencyCode"); string getCardNo = (Request["CardNo"].Trim() != "") ? Request["CardNo"].Trim() : null; string getFrAcctNo = (Request["FromAccount"].Trim() != "") ? Request["FromAccount"].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.GetHistoryATMTransactions(getCardNo, getFrAcctNo, null, Formatter.FormatDateHist(getTransDate1), Formatter.FormatDateHist(getTransDate2)).ToList() .Select(x => new { TransactionDate = x.TransactionDate, Terminal = x.Terminal, CardNo = x.CardNo, TransactionCode = x.TransactionCode, FromAccount = x.FromAccount, Amount = x.Amount, Company = x.Company, ToAccount = x.ToAccount, Rate = x.Rate, Currency = (MappingCurrencyCode.ContainsKey(x.Currency)) ? MappingCurrencyCode[x.Currency] : "", Forex = x.Forex, ResponseCode = x.ResponseCode, Response = x.Response, Sequence = x.Sequence, RequestID = x.RequestID, DateOnly = x.DateOnly, Time = x.Time, Location = x.Location, TransactionDescription = x.TransactionDescription, Date2 = x.TransactionDate.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 if (Request["Tab"] == "History" && Request["SearchTerminalID"] == "Yes") { Dictionary <string, string> MappingCurrencyCode = getListMapping("CurrencyCode", "CurrencyCode"); string getTerminalID = Request["TerminalID"].Trim(); string getSequenceNo = Request["SequenceNo"].Trim(); var data = db.GetHistoryATMTransactionsByTerminalID(getTerminalID, getSequenceNo).ToList() .Select(x => new { TransactionDate = x.TransactionDate, Terminal = x.Terminal, CardNo = x.CardNo, TransactionCode = x.TransactionCode, FromAccount = x.FromAccount, Amount = x.Amount, Company = x.Company, ToAccount = x.ToAccount, Rate = x.Rate, Currency = (MappingCurrencyCode.ContainsKey(x.Currency)) ? MappingCurrencyCode[x.Currency] : "", Forex = x.Forex, ResponseCode = x.ResponseCode, Response = x.Response, Sequence = x.Sequence, RequestID = x.RequestID, DateOnly = x.DateOnly, Time = x.Time, Location = x.Location, TransactionDescription = x.TransactionDescription, Date2 = x.TransactionDate.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 { Dictionary <string, string> MappingTransactionCode = getListMapping("TransactionType", "ATM Current"); Dictionary <string, string> MappingCurrencyCode = getListMapping("CurrencyCode", "CurrencyCode"); 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 culture = CultureInfo.GetCultureInfo("de-DE"); var trx = CurrentTransaction.ATM(param); var data = trx.Select(x => new { Number = x.Number, TransactionCode = x.TransactionCode, TransactionDate = x.TransactionDate, Amount1 = string.Format(culture, "{0:n}", Int32.Parse(x.Amount1)), ResponseCode = x.ResponseCode, ResponseDescription = x.ResponseDescription, TransactionDescription = (MappingTransactionCode.ContainsKey(x.TransactionCode)) ? MappingTransactionCode[x.TransactionCode] : "", Currency = (MappingCurrencyCode.ContainsKey(x.Currency)) ? MappingCurrencyCode[x.Currency] : "", Terminal = x.Terminal, Rate = string.Format(culture, "{0:n}", Int32.Parse(x.Rate)), ConversionAmount = x.ConversionAmount, Amount2 = x.Amount2, FromAccount = x.FromAccount, ToAccount = x.ToAccount, PayeeCode = x.PayeeCode, PayeeNumber = x.PayeeNumber, SequenceNumber = x.SequenceNumber } ); 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)); } }