public IEnumerable <string> GetAllDevices() { //TODO: roll in ORM like EF or Dapper for Db access var result = _repository.GetAllDevices().ToList(); result.Insert(0, "ALLDEVICES"); //per user requirements return(result); }
/// <summary> /// Parses the specified sw. /// </summary> /// <param name="sw">The sw.</param> /// <param name="sd">The sd.</param> /// <param name="from">From.</param> /// <param name="to">To.</param> /// <param name="sdate">The sdate.</param> /// <returns></returns> public ReportFilter Parse(string sw, string sd, string from, string to, string sdate) { if (sw == "ALLWEBSITES") sw = null; if (sd == "ALLDEVICES") sd = null; //make sure selected website matches one from db before sending it to db if (sw != null && _reportsRepository.GetAllWebsites().All(w => w != sw)) sw = null; //make sure selected device matches one from db before sending it to db if (sd != null && _reportsRepository.GetAllDevices().All(d => d != sd)) sd = null; //parse params DateTime? dtFrom = null, dtTo = null; if (!string.IsNullOrEmpty(sdate)) { //Per user requirements switch (sdate) { case "Today": dtFrom = DateTime.Today; dtTo = DateTime.Today.AddDays(1); break; case "Yesterday": dtFrom = DateTime.Today.AddDays(-1); dtTo = DateTime.Today; break; case "ThisWeek": dtFrom = DateTime.Today.AddDays(-1 * (int) (DateTime.Today.DayOfWeek)); dtTo = dtFrom.Value.AddDays(7); break; case "LastWeek": dtFrom = DateTime.Today.AddDays(-1 * (int) (DateTime.Today.DayOfWeek)).AddDays(-7); dtTo = dtFrom.Value.AddDays(7); break; case "ThisMonth": dtFrom = DateTime.Today.AddDays(-1 * DateTime.Today.Day); dtTo = dtFrom.Value.AddMonths(1); break; case "LastMonth": dtFrom = DateTime.Today.AddDays(-1 * DateTime.Today.Day).AddMonths(-1); dtTo = dtFrom.Value.AddMonths(1); break; case "ThisYear": dtFrom = new DateTime(DateTime.Now.Year, 1, 1); dtTo = new DateTime(DateTime.Now.Year, 12, 31); break; case "LastYear": dtFrom = new DateTime(DateTime.Now.AddYears(-1).Year, 1, 1); dtTo = new DateTime(DateTime.Now.AddYears(-1).Year, 12, 31); break; } } else { if (!string.IsNullOrEmpty(from) && !string.IsNullOrEmpty(to)) { if (DateTime.TryParse(from, out var dfrom)) { dtFrom = dfrom; } if (DateTime.TryParse(to, out var dto)) { dtTo = dto; } } } return new ReportFilter { SelectedDevice = sd, SelectedWebsite = sw, SelectedToDate = dtTo, SelectedFromDate = dtFrom }; }