public List <EventModels> GetListEvent(int pageSize, int pageNum, STEventVP param)
{
List <EventModels> ret = new List <EventModels>();
List <EventModels> data = new List <EventModels>();
string msg = null;
try
{
data = GetListEvent(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 List <EventModels> GetListEvent(STEventVP param)
{
List <EventModels> ret = new List <EventModels>();
EventModels item;
List <STEvent> data = new List <STEvent>();
string msg;
CEvent clEvent = new CEvent(LocalData.UserId(), LocalData.CSDbCards1(), LocalData.CSDbCards2(),
LocalData.LogPath());
try
{
int retvalue = clEvent.GetData(param, out data, out msg);
foreach (STEvent row in data)
{
item = new EventModels();
item.IfsfCode = row.ifsfcode;
item.Country = row.country;
item.Pan = row.maskedpan;
item.LocalTime = row.ltime.ToString("yyyy-MM-dd HH:mm:ss");
item.ProcCode = row.proccode;
item.Text = row.text;
item.UTDCode = row.utdcode;
item.Msg = row.msg;
ret.Add(item);
}
}
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)
{
STEventVP param;
if (Session["EVENTPARAM"] != null)
{
param = (STEventVP)Session["EVENTPARAM"];
}
else
{
param = new STEventVP();
}
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))
{
ViewData["MSG"] = "One or more fields contain invalid characters.";
return(View("Errors"));
}
else
{
List <EventModels> lst = EventModelsRepository.Instance.GetListEvent(param);
ViewData["PageNum"] = pageNum;
ViewData["ItemsCount"] = lst.Count;
ViewData["PageSize"] = pageSize;
ViewData["STRPARAM"] = param.strdata;
return(View(EventModelsRepository.Instance.GetListEvent(pageSize, pageNum, param)));
}
}
}
else
{
return(RedirectToAction("ChangePassword", "Account"));
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public EventModelsViewParam SetParam(STEventVP param)
{
EventModelsViewParam ret = new EventModelsViewParam();
string msg;
try
{
ret.MaskPan = param.maskedpan;
ret.BeginDate = param.dtbegin;
ret.EndDate = param.dtend;
}
catch (Exception ex) { msg = ex.Message; }
return(ret);
}
public ActionResult Filter(EventModelsViewParam prm, FormCollection collection)
{
if (Request.IsAuthenticated)
{
try
{
STEventVP param = EventModelsRepository.Instance.GetParam(prm);
Session["EVENTPARAM"] = 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;
STEventVP param;
if (Session["EVENTPARAM"] != null)
{
param = (STEventVP)Session["EVENTPARAM"];
}
else
{
param = new STEventVP();
// 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;
}
EventModelsViewParam prm = EventModelsRepository.Instance.SetParam(param);
return(View("Filter", prm));
}
else
{
return(RedirectToAction("ChangePassword", "Account"));
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public STEventVP GetParam(EventModelsViewParam prm)
{
STEventVP ret = new STEventVP();
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);
}
}
catch (Exception ex) { msg = ex.Message; }
return(ret);
}
