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"));
}
}
