public void OnGet()
{
using (var webClient = new WebClient())
{
//Get Summary Neighborhood Cleanliness Data
string neighborhoodData = webClient.DownloadString("https://data.cincinnati-oh.gov/resource/h8mv-4fsc.json");
List <NeighborhoodData> neighborhoods = NeighborhoodData.FromJson(neighborhoodData);
//Get Vacant Properties in Cincinnati
string propertyData = webClient.DownloadString("https://data.cincinnati-oh.gov/resource/w3jp-dfxy.json");
IEnumerable <PropertyData> properties = PropertyData.FromJson(propertyData);
//Filter Vacant Properties by truly Vacant Properties
IEnumerable <PropertyData> vacantProperties = properties.Where(property => property.DataStatusDisplay.Contains("Vacant"));
//Sort Vacant Properties by Neighborhood and Unique ID for better display on View
vacantProperties = vacantProperties.OrderBy(x => x.Neighborhood).ThenBy(x => x.Uniqueid);
ViewData["VacantProperties"] = vacantProperties;
ViewData["Neighborhoods"] = neighborhoods;
}
}
public JsonResult OnGet()
{
ArrayList Output = new ArrayList();
using (WebClient webClient = new WebClient())
{
string neighborhoodData = webClient.DownloadString("https://data.cincinnati-oh.gov/resource/h8mv-4fsc.json");
JSchema nSchema = JSchema.Parse(System.IO.File.ReadAllText("NeighborhoodSchema.json"));
JArray nJsonObject = JArray.Parse(neighborhoodData);
IList <string> nValidationEvents = new List <string>();
if (nJsonObject.IsValid(nSchema, out nValidationEvents))
{
List <NeighborhoodData> neighborhoods = NeighborhoodData.FromJson(neighborhoodData);
//Get Vacant Properties in Cincinnati
string propertyData = webClient.DownloadString("https://data.cincinnati-oh.gov/resource/w3jp-dfxy.json");
JSchema pSchema = JSchema.Parse(System.IO.File.ReadAllText("PropertySchema.json"));
JArray pJsonObject = JArray.Parse(propertyData);
IList <string> pValidationEvents = new List <string>();
if (pJsonObject.IsValid(pSchema, out pValidationEvents))
{
IEnumerable <PropertyData> properties = PropertyData.FromJson(propertyData);
//Filter Vacant Properties by truly Vacant Properties
IEnumerable <PropertyData> vacantProperties = properties.Where(property => property.DataStatusDisplay.Contains("Vacant"));
//Sort Vacant Properties by Neighborhood and Unique ID for better display on View
vacantProperties = vacantProperties.OrderBy(x => x.Neighborhood).ThenBy(x => x.Uniqueid);
// iterate over the specimens, to find which ones like water.
foreach (NeighborhoodData NeighborhoodDatum in neighborhoods)
{
ArrayList NewData = new ArrayList();
ArrayList NewProp = new ArrayList();
IEnumerable <QuicktypeProperty.PropertyData> vacantPropertiesInNeighborhood = vacantProperties.Where(property => property.Neighborhood.Equals(NeighborhoodDatum.Neighborhood));
if (vacantPropertiesInNeighborhood.Any())
{
// find the matching plant record for this specimen.
foreach (PropertyData PropertyDatum in vacantProperties)
{
if (PropertyDatum.Neighborhood == NeighborhoodDatum.Neighborhood)
{
NewProp.Add(PropertyDatum);
}
}
NewData.Add(NeighborhoodDatum);
NewData.Add(NewProp);
Output.Add(NewData);
}
}
return(new JsonResult(Output));
}
else
{
foreach (string evt in pValidationEvents)
{
Console.WriteLine(evt);
}
return(new JsonResult(Output));
}
}
else
{
foreach (string evt in nValidationEvents)
{
Console.WriteLine(evt);
}
return(new JsonResult(Output));
}
}
}