public JsonResult OnGet() { List<Owner> cafeOwners = new List<Owner>(); string CafeJsonString = GetData("https://data.cityofchicago.org/resource/mqmh-p6ud.json"); Cafe[] allCafes = Cafe.FromJson(CafeJsonString); string OwnerJsonString = GetData("https://data.cityofchicago.org/resource/ezma-pppn.json"); Owner[] allOwners = Owner.FromJson(OwnerJsonString); IDictionary<string, Cafe> cafes = new Dictionary<string, Cafe>(); foreach (Cafe cafe in allCafes) { cafes.Add(cafe.PermitNumber, cafe); } foreach (Owner owner in allOwners) { foreach (var cafe in cafes) { //Compare Account Number from two JSON and select only ones which have common account number if (cafe.Value.AccountNumber == owner.AccountNumber) { cafeOwners.Add(owner); } } } return new JsonResult(cafeOwners); }
public void OnGet() { List <Owner> cafeOwners = new List <Owner>(); string CafeJsonString = GetData("https://data.cityofchicago.org/resource/mqmh-p6ud.json"); Cafe[] allCafes = Cafe.FromJson(CafeJsonString); ViewData["allCafes"] = allCafes; string OwnerJsonString = GetData("https://data.cityofchicago.org/resource/ezma-pppn.json"); Owner[] allOwners = Owner.FromJson(OwnerJsonString); ViewData["allOwners"] = allOwners; IDictionary <string, Cafe> cafes = new Dictionary <string, Cafe>(); foreach (Cafe cafe in allCafes) { cafes.Add(cafe.PermitNumber, cafe); } foreach (Owner owner in allOwners) { foreach (var cafe in cafes) { if (cafe.Value.AccountNumber == owner.AccountNumber) { cafeOwners.Add(owner); } } } ViewData["cafeOwners"] = cafeOwners; }
public void OnGet() { List <Owner> cafeOwners = new List <Owner>(); string CafeJsonString = GetData("https://data.cityofchicago.org/resource/mqmh-p6ud.json"); Cafe[] allCafes = Cafe.FromJson(CafeJsonString); ViewData["allCafes"] = allCafes; string OwnerJsonString = GetData("https://data.cityofchicago.org/resource/ezma-pppn.json"); Owner[] allOwners = Owner.FromJson(OwnerJsonString); ViewData["allOwners"] = allOwners; IDictionary <string, Cafe> cafes = new Dictionary <string, Cafe>(); foreach (Cafe cafe in allCafes) { cafes.Add(cafe.PermitNumber, cafe); } foreach (Owner owner in allOwners) { foreach (var cafe in cafes) { //Compare Account Number from two JSON and select only ones which have common account number if (cafe.Value.AccountNumber == owner.AccountNumber) { cafeOwners.Add(owner); } if (owner.IsNameNull(owner.OwnerFirstName + owner.OwnerMiddleInitial + owner.OwnerLastName)) { ViewData["ownerNames"] = "No Information Available"; } } } ViewData["cafeOwners"] = cafeOwners; }