public override void RollbackTransaction() => CurrentTransaction.Rollback();
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)); } }
public void Dispose() { CurrentTransaction?.Dispose(); _realConnection.Dispose(); }
public override void CommitTransaction() => CurrentTransaction.Commit();
public void CommitTransaction() => CurrentTransaction.Commit();
public void RollbackTransaction() => CurrentTransaction.Rollback();
public void Dispose() { CurrentTransaction?.Dispose(); CurrentTransaction = null; _semaphore?.Dispose(); }
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)); } }
// public void AddItem(Snack snack, int index) // { // Snacks.Insert(index, snack); // } // public void AddItem(Electronic electronic) // { // //add is the new push // Electronics.Add(electronic); // } // public void AddItem(Electronic electronic, int index) // { // Electronics.Insert(index, electronic); // } #endregion public string AddQuarter() { CurrentTransaction += .25m; return(CurrentTransaction.ToString()); }
public void RollbackTransaction() { CurrentTransaction?.Rollback(); }
public void CommitTransaction() { CurrentTransaction?.Commit(); }
public virtual void Commit() { CurrentTransaction?.Complete(); }
public void Commit() { CurrentTransaction.Commit(); CurrentTransaction = null; }