public void OnGet() { String crimeIncidentJSON = GetData("https://data.cincinnati-oh.gov/resource/k59e-2pvf.json"); var crimeIncidents = CrimeIncidents.FromJson(crimeIncidentJSON); ViewData["CrimeIncidents"] = crimeIncidents; String smart911EnrollmentJSON = GetData("https://data.cincinnati-oh.gov/resource/rtu7-isj6.json"); var smart911Enrollments = Smart911Enrollment.FromJson(smart911EnrollmentJSON); ViewData["Smart911Enrollments"] = smart911Enrollments; IDictionary <long, CrimeIncident.CrimeIncidents> incidentsMap = new Dictionary <long, CrimeIncidents>(); List <SmartEnrollment.Smart911Enrollment> enrollist = new List <Smart911Enrollment>(); foreach (CrimeIncident.CrimeIncidents crInc in crimeIncidents) { if (!incidentsMap.ContainsKey(crInc.Zip)) { incidentsMap.Add(crInc.Zip, crInc); } } foreach (SmartEnrollment.Smart911Enrollment enroll in smart911Enrollments) { if (incidentsMap.ContainsKey(enroll.ZipCode)) { enrollist.Add(enroll); } } ViewData["Enrollist"] = enrollist; }
public void OnPost() { using (var webClient = new WebClient()) { String crimeIncidentJSON = webClient.DownloadString("https://data.cincinnati-oh.gov/resource/k59e-2pvf.json"); crimes = CrimeIncidents.FromJson(crimeIncidentJSON); String smart911EnrollmentJSON = webClient.DownloadString("https://data.cincinnati-oh.gov/resource/rtu7-isj6.json"); enrollments = Smart911Enrollment.FromJson(smart911EnrollmentJSON); crimesFiltered = crimes.Where(x => x.Zip == zipSearch).ToArray(); enrollmentsFiltered = enrollments.Where(x => x.ZipCode == zipSearch).ToArray(); ViewData["CrimeIncidents"] = crimesFiltered; ViewData["Smart911Enrollments"] = enrollmentsFiltered; } searchFinished = true; }
public IList <SmartEnrollmentAPI> GetSmartEnrollmentAPI() { IList <SmartEnrollmentAPI> outputJson = new List <SmartEnrollmentAPI>(); using (var webClient = new WebClient()) { String crimeIncidentJSON = webClient.DownloadString("https://data.cincinnati-oh.gov/resource/k59e-2pvf.json"); var crimeIncidents = CrimeIncidents.FromJson(crimeIncidentJSON); String smart911EnrollmentJSON = webClient.DownloadString("https://data.cincinnati-oh.gov/resource/rtu7-isj6.json"); var smart911Enrollments = Smart911Enrollment.FromJson(smart911EnrollmentJSON); IDictionary <long, CrimeIncident.CrimeIncidents> incidentsMap = new Dictionary <long, CrimeIncidents>(); foreach (CrimeIncident.CrimeIncidents crInc in crimeIncidents) { if (!incidentsMap.ContainsKey(crInc.Zip)) { incidentsMap.Add(crInc.Zip, crInc); } } foreach (SmartEnrollment.Smart911Enrollment enroll in smart911Enrollments) { if (incidentsMap.ContainsKey(enroll.ZipCode)) { SmartEnrollmentAPI enrollment = new SmartEnrollmentAPI(); enrollment.Zipcode = enroll.ZipCode; enrollment.WebEnrollments = enroll.WebEnrollments; enrollment.AppEnrollments = enroll.AppEnrollments; enrollment.TotalEnrollments = enroll.TotalEnrollments; outputJson.Add(enrollment); } } } return(outputJson); }