public async Task <ActionResult> MonthlyTransactionSummary([Bind(Include = "TerminalId,StartDate,EndDate,Partner,PartnerId,Group,GroupId,Surcharge")] MonthlyTransactionSummaryViewModel vmodel)
{
ModelState.Remove("PartnerId");
ModelState.Remove("GroupId");
ModelState.Remove("TerminalId");
if (ModelState.IsValid)
{
List <TransMonthlyTableVM> listaux = new List <TransMonthlyTableVM>();
List <JsonMonthlyTransactionSummary> list = new List <JsonMonthlyTransactionSummary>();
ApiATM api = new ApiATM();
DateTime?start = DateTime.ParseExact(vmodel.StartDate, "MM/dd/yyyy", CultureInfo.InvariantCulture);
DateTime?end = DateTime.ParseExact(vmodel.EndDate, "MM/dd/yyyy", CultureInfo.InvariantCulture);
string[] listtn = ListTerminalByGroup(vmodel.GroupId);
list = await api.MonthlyTransactionSummary(start, end, vmodel.TerminalId, listtn, vmodel.Surcharge);
IEnumerable <dynamic> listTn = repo_terminal.TransMonthlyList(list, vmodel.PartnerId, Convert.ToInt32(Session["partnerId"]));
if (listTn.Count() > 0)
{
foreach (var item in list)
{
string locationname = "";
foreach (dynamic x in listTn)
{
if (x.TerminalId == item.TerminalId)
{
locationname = x.LocationName;
break;
}
}
if (locationname != "")
{
TransMonthlyTableVM obj = new TransMonthlyTableVM(item.TerminalId, locationname, item.Date, item.ApprovedWithdrawals, item.Declined, item.SurchargableWithdrawals, item.OtherApproved, item.Reversed, item.SurchargeAmount, item.TotalTransaction, item.Surcharge);
listaux.Add(obj);
}
}
}
#region Variables Partial
TempData["List"] = listaux.Count() > 0 ? listaux : null;
TempData["filename"] = "MonthlyTransactionSummary";
TempData["Chart"] = null;
TempData["terminal"] = vmodel.TerminalId;
TempData["partner"] = vmodel.Partner;
TempData["from"] = start?.ToString("MMMM , yyyy");
TempData["to"] = end?.ToString("MMMM , yyyy");
TempData["model"] = vmodel;
TempData["sub"] = false;
#endregion
return(View("MonthlyTransactionSummary/MonthlyTransactionSummary"));
}
return(RedirectToAction("Index"));
}
public async Task <ActionResult> TerminalStatus([Bind(Include = "Status,Partner,PartnerId,Group,GroupId,City,Cityid,State,StateId,ZipCode")] TerminalStatusViewModel vmodel)
{
ModelState.Remove("PartnerId");
ModelState.Remove("GroupId");
ModelState.Remove("CityId");
ModelState.Remove("StateId");
if (ModelState.IsValid)
{
List <TerminalStatusTableVM> listaux = new List <TerminalStatusTableVM>();
List <JsonTerminalStatusChart> listchart = new List <JsonTerminalStatusChart>();
List <JsonTerminalStatusReport> list = new List <JsonTerminalStatusReport>();
ApiATM api = new ApiATM();
string[] listtn = ListTerminalByGroup(vmodel.GroupId);
list = await api.TerminalStatus(listtn);
IEnumerable <dynamic> listTn = repo_terminal.TerminalStatus(list, vmodel.Status, vmodel.PartnerId, Convert.ToInt32(Session["partnerId"]), vmodel.CityId, vmodel.StateId, vmodel.ZipCode);
if (listTn.Count() > 0)
{
foreach (var item in listTn)
{
int? cashBalance = list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.CashBalance).FirstOrDefault();
int? dayuntilcashload = list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.Dayuntilcashload).FirstOrDefault();
DateTime? lastComunication = list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.LastComunication).FirstOrDefault();
List <DateTime?> lastran = new List <DateTime?>
{
list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.LastTransaction11).FirstOrDefault(),
list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.LastTransaction12).FirstOrDefault(),
list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.LastTransaction15).FirstOrDefault()
};
DateTime?lastTransaction = lastran.Max();
int? hourInactive = list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.HourInactive).FirstOrDefault();
TerminalStatusTableVM obj = new TerminalStatusTableVM(item.TerminalId, item.LocationName, cashBalance, dayuntilcashload, item.Name, item.Phone, "Falta esta columna", lastComunication, lastTransaction, hourInactive);
JsonTerminalStatusChart objchart = new JsonTerminalStatusChart(item.TerminalId, cashBalance, lastComunication?.ToString("yyyy-MM-dd H:m:s"));
listchart.Add(objchart);
listaux.Add(obj);
}
}
#region Variables Partial
TempData["List"] = listaux.Count() > 0 ? Utils.ToDataTable <TerminalStatusTableVM>(listaux) : null;
TempData["filename"] = "TerminalStatus";
TempData["Chart"] = listchart.Count() > 0 ? JsonConvert.SerializeObject(listchart) : null;
TempData["sub"] = false;
#endregion
return(View("TerminalStatus/TerminalStatus"));
}
return(RedirectToAction("Index"));
}
public async Task <ActionResult> CashManagement([Bind(Include = "TerminalId,Status,Partner,PartnerId,Group,GroupId")] CashManagementViewModel vmodel)
{
ModelState.Remove("PartnerId");
ModelState.Remove("GroupId");
ModelState.Remove("TerminalId");
if (ModelState.IsValid)
{
List <CashManagementTableVM> listaux = new List <CashManagementTableVM>();
List <JsonLoadCashChart> listchart = new List <JsonLoadCashChart>();
List <JsonCashManagement> list = new List <JsonCashManagement>();
ApiATM api = new ApiATM();
string[] listtn = ListTerminalByGroup(vmodel.GroupId);
list = await api.CashManagement(vmodel.TerminalId, listtn);
IEnumerable <dynamic> listTn = repo_terminal.LoadCashMngList(list, vmodel.Status, vmodel.PartnerId, Convert.ToInt32(Session["partnerId"]));
if (listTn.Count() > 0)
{
foreach (var item in listTn)
{
int? cashBalance = list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.CashBalance).FirstOrDefault();
int? amountPrevius = list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.AmountPrevius).FirstOrDefault();
int? amountLoad = list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.AmountLoad).FirstOrDefault();
int? amountCurrent = list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.AmountCurrent).FirstOrDefault();
int? dayuntilcashload = list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.Dayuntilcashload).FirstOrDefault();
DateTime?lastLoad = list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.LastLoad).FirstOrDefault();
CashManagementTableVM obj = new CashManagementTableVM(item.TerminalId, item.LocationName, cashBalance.ToString(), dayuntilcashload.ToString(), lastLoad.ToString(), amountPrevius.ToString(), amountLoad.ToString(), amountCurrent.ToString());
JsonLoadCashChart objchart = new JsonLoadCashChart(lastLoad?.ToString("yyyy-MM-dd"), amountPrevius, amountLoad);
listchart.Add(objchart);
listaux.Add(obj);
}
}
#region Variables Partial
TempData["List"] = listaux.Count() > 0 ? Utils.ToDataTable <CashManagementTableVM>(listaux) : null;
TempData["filename"] = "CashManagement";
TempData["Chart"] = listchart.Count() > 0 ? JsonConvert.SerializeObject(listchart) : null;
TempData["terminal"] = vmodel.TerminalId;
TempData["partner"] = vmodel.Partner;
TempData["Sub"] = false;
#endregion
Session["businessName"] = "";
return(View("CashManagement/CashManagement"));
}
return(RedirectToAction("Index"));
}
public async Task <ActionResult> CashBalanceatClose([Bind(Include = "Partner,PartnerId,Group,GroupId,StartDate")] CashBalanceatCloseViewModel vmodel)
{
ModelState.Remove("PartnerId");
ModelState.Remove("GroupId");
if (ModelState.IsValid)
{
List <CashBalanceAtCloseTableVM> listaux = new List <CashBalanceAtCloseTableVM>();
List <JsonCashBalanceClose> list = new List <JsonCashBalanceClose>();
ApiATM api = new ApiATM();
string[] listtn = ListTerminalByGroup(vmodel.GroupId);
DateTime?start = DateTime.ParseExact(vmodel.StartDate, "MM/dd/yyyy", CultureInfo.InvariantCulture);
list = await api.CashBalanceClose(start, listtn);
IEnumerable <dynamic> listTn = repo_terminal.CashBalanceClose(list, vmodel.PartnerId, Convert.ToInt32(Session["partnerId"]));
if (listTn.Count() > 0)
{
foreach (var item in listTn)
{
int? cashBalance = list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.CashBalance).FirstOrDefault();
string time = list.Where(m => m.TerminalId == item.TerminalId).Select(m => m.Time).FirstOrDefault();
CashBalanceAtCloseTableVM obj = new CashBalanceAtCloseTableVM(item.TerminalId, item.LocationName, time, cashBalance.ToString());
listaux.Add(obj);
}
}
#region Variables Partial
TempData["List"] = listaux.Count() > 0 ? Utils.ToDataTable <CashBalanceAtCloseTableVM>(listaux) : null;
TempData["filename"] = "CashManagement";
TempData["Chart"] = null;
TempData["partner"] = vmodel.Partner;
TempData["sub"] = false;
#endregion
return(View("CashBalanceatClose/CashBalanceatClose"));
}
return(RedirectToAction("Index"));
}
public async Task <ActionResult> CashLoad([Bind(Include = "TerminalId,StartDate,EndDate,Status,Partner,PartnerId,Group,GroupId")] CashLoadViewModel vmodel)
{
ModelState.Remove("PartnerId");
ModelState.Remove("GroupId");
ModelState.Remove("TerminalId");
if (ModelState.IsValid)
{
List <CashLoadTableVM> listaux = new List <CashLoadTableVM>();
List <JsonLoadCashChart> listchart = new List <JsonLoadCashChart>();
List <JsonLoadCash> list = new List <JsonLoadCash>();
ApiATM api = new ApiATM();
DateTime?start = DateTime.ParseExact(vmodel.StartDate, "MM/dd/yyyy", CultureInfo.InvariantCulture);
DateTime?end = DateTime.ParseExact(vmodel.EndDate, "MM/dd/yyyy", CultureInfo.InvariantCulture);
string[] listtn = ListTerminalByGroup(vmodel.GroupId);
list = await api.CashLoad(start, end, vmodel.TerminalId, listtn);
IEnumerable <dynamic> listTn = repo_terminal.LoadCashList(list, vmodel.Status, vmodel.PartnerId, Convert.ToInt32(Session["partnerId"]));
if (listTn.Count() > 0)
{
foreach (var item in list)
{
string locationname = "";
foreach (dynamic x in listTn)
{
if (x.TerminalId == item.TerminalId)
{
locationname = x.LocationName;
break;
}
}
if (locationname != "")
{
CashLoadTableVM obj = new CashLoadTableVM(item.TerminalId, locationname, item.Date, item.AmountPrevius.ToString(), item.AmountLoad.ToString(), item.AmountCurrent.ToString());
JsonLoadCashChart objchart = new JsonLoadCashChart(item.Date.ToString("yyyy-MM-dd"), item.AmountPrevius, item.AmountLoad);
listchart.Add(objchart);
listaux.Add(obj);
}
}
}
#region Variables Partial
TempData["List"] = listaux.Count() > 0 ? Utils.ToDataTable <CashLoadTableVM>(listaux) : null;
TempData["filename"] = "CashLoad";
TempData["Chart"] = listchart.Count() > 0 ? JsonConvert.SerializeObject(listchart) : null;
TempData["terminal"] = vmodel.TerminalId;
TempData["partner"] = vmodel.Partner;
TempData["from"] = vmodel.StartDate;
TempData["to"] = vmodel.EndDate;
TempData["Sub"] = false;
#endregion
return(View("CashLoad/CashLoad"));
}
return(RedirectToAction("Index"));
}
