private async Task test(String location, PORT p) { using (var client = new HttpClient()) { client.BaseAddress = new Uri(clientBase); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); // HTTP GET HttpResponseMessage response = await client.GetAsync(clientBase + "/api/geo/geocoding/query/" + location); if (response.IsSuccessStatusCode) { var jsonAsString = await response.Content.ReadAsStringAsync(); var g = JsonConvert.DeserializeObject <wrapper>(jsonAsString); Console.WriteLine("{0}\t${1}\t{2}", g.data.day, g.data.displayName, g.data.lat); listBox2.Items.Add(g.data.displayName); listBox1.Items.Add(location); Dwstg d = new Dwstg(); var w = d.PORTs.FirstOrDefault(o => o.PORT_NAME == location); w.TZONE_OFFSET = g.data.rawOffset / 60 / 60 / 1000; w.LATITUDE = g.data.lat; w.LONGITUDE = g.data.lng; w.LAST_MODIFIED_DT = DateTime.Now; await d.SaveChangesAsync(); } } }
private async Task complete() { Dwstg d = new Dwstg(); await d.PORTs.Where(o => o.LATITUDE == null).Take(500).ForEachAsync(async o => { await test(o.PORT_NAME, o); }); }