public ActionResult GetTable(string startDate = "", string endDate = "") { IEnumerable <ParsedPackage> packages; var deviceRepository = new NHDeviceRepository(); if (!String.IsNullOrEmpty(startDate)) { if (String.IsNullOrEmpty(endDate)) { endDate = DateTime.Today.ToString("yyyyMMdd"); } packages = _parsedPackagesRepository.FromDateRange(DateTime.Parse(startDate), DateTime.Parse(endDate)); } else { packages = _parsedPackagesRepository.GetAll(); } var tabla = new List <ReportTable>(); foreach (var floor in packages.GroupBy(x => x.Floor)) { foreach (var item in floor.GroupBy(x => x.LatLng)) { var device = deviceRepository.GetAll().FirstOrDefault(x => x.LatLng == item.Key); tabla.Add(new ReportTable { Descripcion = device.Description, Piso = floor.Key, Personas = item.Count() }); } } return(Json(tabla, JsonRequestBehavior.AllowGet)); }
public ActionResult GetTable(string startDate = "", string endDate = "") { IEnumerable<ParsedPackage> packages; var deviceRepository = new NHDeviceRepository(); if (!String.IsNullOrEmpty(startDate)) { if (String.IsNullOrEmpty(endDate)) endDate = DateTime.Today.ToString("yyyyMMdd"); packages = _parsedPackagesRepository.FromDateRange(DateTime.Parse(startDate), DateTime.Parse(endDate)); } else { packages = _parsedPackagesRepository.GetAll(); } var tabla = new List<ReportTable>(); foreach (var floor in packages.GroupBy(x=>x.Floor)) { foreach(var item in floor.GroupBy(x=>x.LatLng)) { var device = deviceRepository.GetAll().FirstOrDefault(x => x.LatLng == item.Key); tabla.Add(new ReportTable { Descripcion = device.Description, Piso = floor.Key, Personas = item.Count() }); } } return Json(tabla, JsonRequestBehavior.AllowGet); }