public List <TransactModels> GetListTransact(STTransactVP param) { List <TransactModels> ret = new List <TransactModels>(); TransactModels item; List <STTransact> data = new List <STTransact>(); string msg; CTransact clTransact = new CTransact(LocalData.UserId(), LocalData.CSDbTransacts1(), LocalData.CSDbTransacts2(), LocalData.LogPath()); try { int retvalue = clTransact.GetData(param, out data, out msg); foreach (STTransact row in data) { item = new TransactModels(); item.Amount = row.amount; item.Country = row.country; item.Currency = row.currency; item.LocalTime = row.ltime.ToString("yyyy-MM-dd HH:mm:ss"); item.Pan = row.pan; item.Pos = row.pos; item.Product = row.product; item.Quantity = row.quantity; ret.Add(item); } } catch (Exception ex) { msg = ex.Message; } return(ret); }
public STTransactVP GetParam(TransactModelsViewParam prm) { STTransactVP ret = new STTransactVP(); string msg; try { ret.strdata = null; ret.dtbegin = prm.BeginDate; ret.strdata += string.Format("<DateBegin={0}>", ret.dtbegin.ToString("yyyy-MM-dd HH:mm:ss")); ret.dtend = prm.EndDate; ret.strdata += string.Format("<DateEnd={0}>", ret.dtend.ToString("yyyy-MM-dd HH:mm:ss")); if (prm.MaskPan != null) { ret.maskedpan = prm.MaskPan; ret.strdata += string.Format("<MaskPAN={0}>", ret.maskedpan); } if (prm.MaskPos != null) { ret.maskedpos = prm.MaskPos; ret.strdata += string.Format("<MaskPOS={0}>", ret.maskedpos); } } catch (Exception ex) { msg = ex.Message; } return(ret); }
public List <TransactModels> GetListTransact(int pageSize, int pageNum, STTransactVP param) { List <TransactModels> ret = new List <TransactModels>(); List <TransactModels> data = new List <TransactModels>(); string msg = null; try { data = GetListTransact(param); if (data.Count <= pageSize) { return(data); } else { for (int i = 0; i < data.Count; i++) { if (i >= pageNum * pageSize && i < pageNum * pageSize + pageSize) { ret.Add(data[i]); } } } } catch (Exception ex) { msg = ex.Message; } return(ret); }
public ActionResult List(int pageNum = 0) { if (Request.IsAuthenticated) { CUser clUser = new CUser(LocalData.UserId(), LocalData.CSDbUsers(), LocalData.LogPath()); STUser stUser; string msg; clUser.GetRecordByUserId(LocalData.UserId(), out stUser, out msg); if (!stUser.oldpass) { STTransactVP param; if (Session["TRANSACTPARAM"] != null) { param = (STTransactVP)Session["TRANSACTPARAM"]; } else { param = new STTransactVP(); } if (!SharedModel.IsConnect(LocalData.CSDbTransacts1(), out msg) && !SharedModel.IsConnect(LocalData.CSDbTransacts2(), out msg)) { ViewData["ERROR"] = "No connection to DB"; ViewData["MSG"] = msg; //return RedirectToAction("Index", "Error"); return(View("Index")); } else { string[] arr = new[] { "'", "\"", "--" }; if (CheckerField.CheckField(arr, param.maskedpan, param.maskedpos)) { ViewData["MSG"] = "One or more fields contain invalid characters."; return(View("Errors")); } else { List <TransactModels> lst = TransactModelsRepository.Instance.GetListTransact(param); ViewData["PageNum"] = pageNum; ViewData["ItemsCount"] = lst.Count; ViewData["PageSize"] = pageSize; ViewData["STRPARAM"] = param.strdata; return(View(TransactModelsRepository.Instance.GetListTransact(pageSize, pageNum, param))); } } } else { return(RedirectToAction("ChangePassword", "Account")); } } else { return(RedirectToAction("Index", "Home")); } }
public TransactModelsViewParam SetParam(STTransactVP param) { TransactModelsViewParam ret = new TransactModelsViewParam(); string msg; try { ret.MaskPan = param.maskedpan; ret.MaskPos = param.maskedpos; ret.BeginDate = param.dtbegin; ret.EndDate = param.dtend; } catch (Exception ex) { msg = ex.Message; } return(ret); }
public ActionResult Filter(TransactModelsViewParam prm, FormCollection collection) { if (Request.IsAuthenticated) { try { STTransactVP param = TransactModelsRepository.Instance.GetParam(prm); Session["TRANSACTPARAM"] = param; return(RedirectToAction("List")); } catch { return(View()); } } else { return(RedirectToAction("Index", "Home")); } }
public ActionResult Filter() { if (Request.IsAuthenticated) { CUser clUser = new CUser(LocalData.UserId(), LocalData.CSDbUsers(), LocalData.LogPath()); STUser stUser; string msg; clUser.GetRecordByUserId(LocalData.UserId(), out stUser, out msg); if (!stUser.oldpass) { //STCardVP param = LocaParam.cardparam; STTransactVP param; if (Session["TRANSACTPARAM"] != null) { param = (STTransactVP)Session["TRANSACTPARAM"]; } else { param = new STTransactVP(); // param.dtbegin = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0, 0); // DateTime end = DateTime.Now; // end = end.AddMonths(1); // end = new DateTime(end.Year, end.Month, 1, 0, 0, 0, 0); // end = end.AddDays(-1); // param.dtend = new DateTime(end.Year, end.Month, end.Day, 23, 59, 59, 0); param.dtbegin = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0, 0); param.dtend = DateTime.Now; } TransactModelsViewParam prm = TransactModelsRepository.Instance.SetParam(param); return(View("Filter", prm)); } else { return(RedirectToAction("ChangePassword", "Account")); } } else { return(RedirectToAction("Index", "Home")); } }