private async void PopulateBtn_Click(object sender, RoutedEventArgs e)
{
string json = await WeatherConnection.LoadTimeZoneAsync(33, 113, 50);
JObject data = JObject.Parse(json);
var cities = from p in data["list"] select(string) p["name"];
var weathers = from p in data["list"] select(string) p["weather"][0]["description"];
var temperature = from p in data["list"] select(string) p["main"]["temp"];
int maxID = weatherDB.weather_table.Max(p => p.ID);
for (int i = 0; i < cities.Count(); ++i)
{
weather_table temp = new weather_table()
{
ID = ++maxID,
city = cities.ElementAt(i),
weather_descr = weathers.ElementAt(i),
temp = (int)float.Parse(temperature.ElementAt(i), CultureInfo.InvariantCulture.NumberFormat)
};
weatherDB.weather_table.Add(temp);
}
weatherDB.SaveChanges();
weather_tableViewSource.View.Refresh();
}
private void DBBtn_Click(object sender, RoutedEventArgs e)
{
try
{
int maxID = weatherDB.weather_table.Max(p => p.ID);
weather_table temp = new weather_table()
{
ID = maxID + 1,
city = cityTextBox.Text,
weather_descr = weather_descrTextBox.Text,
temp = Int32.Parse(tempTextBox.Text)
};
weatherDB.weather_table.Add(temp);
weatherDB.SaveChanges();
weather_tableViewSource.View.Refresh();
}
catch (Exception ex)
{
viewBox.Text = ex.Message;
}
}