public IActionResult Main(String name, StationsService svc, CoreService csv, string dt = "")
        {
            StationsListViewModel model = new StationsListViewModel();

            model.Selected = svc.GetStation(name);
            model.Stations = svc.GetStations();

            model.Date = (string.IsNullOrEmpty(dt) ? model.Selected.Push : DateTime.Parse(dt));

            model.Totals    = svc.GetLedgerTotals(model.Selected, model.Date);
            model.Readings  = svc.GetMetreReadings(model.Selected, model.Date);
            model.Summaries = svc.GetSummaries(model.Selected, model.Date);
            model.Ledgers   = svc.GetCustomersSummaries(model.Selected, model.Date);
            model.Customers = csv.GetCustomers(model.Selected.Name);

            return(View(model));
        }
        public JsonResult GetStationsSummary(String date1, String date2, String stats, StationsService svc)
        {
            DateTime xdate1 = DateTime.Now.AddDays(-1);
            DateTime xdate2 = DateTime.Now.AddDays(-1);

            //DateTime.ParseExact(date1, "d MMM, yyyy", System.Globalization.CultureInfo.InvariantCulture);
            if (!string.IsNullOrEmpty(date1))
            {
                xdate1 = DateTime.Parse(date1);
            }

            if (!string.IsNullOrEmpty(date2))
            {
                xdate2 = DateTime.Parse(date2);
            }

            if (string.Equals(stats, "Select Stations"))
            {
                stats = "";
            }
            else
            {
                string[] stations = stats.Split(',', StringSplitOptions.RemoveEmptyEntries);
                stats = "";

                for (int i = 0; i < stations.Length; i++)
                {
                    if (string.IsNullOrEmpty(stats))
                    {
                        stats = "'" + stations[i].Trim() + "'";
                    }
                    else
                    {
                        stats += ",'" + stations[i].Trim() + "'";
                    }
                }
            }

            List <LedgerTotals> totals = new List <LedgerTotals>(svc.GetLedgerTotals(stats, xdate1, xdate2));

            return(Json(totals));
        }