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