partial void DeleteIconsTable(IconsTable instance);
partial void UpdateIconsTable(IconsTable instance);
void getWeather() { using (WebClient web = new WebClient()) { string url = string.Format("http://api.openweathermap.org/data/2.5/weather?q={0}&appid={1}&units=metric&cnt=3", cityName, APPID); var json = web.DownloadString(url); var result = JsonConvert.DeserializeObject <WeatherInfo.root>(json); WeatherInfo.root outPut = result; lbl_cityName.Text = string.Format("{0}", outPut.name); lbl_country.Text = string.Format("{0}", outPut.sys.country); lbl_Temp.Text = string.Format("{0} \u00B0" + "C", outPut.main.temp); lbl_Conditions1.Text = string.Format("{0}", outPut.weather[0].main); lbl_Description1.Text = string.Format("{0}", outPut.weather[0].description); lbl_WindSpeed1.Text = string.Format("{0} km/h", outPut.wind.speed); string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\serge\source\repos\BaigiamasisDarbas_Orai_Sergej\BaigiamasisDarbas_Orai_Sergej\City.mdf;Integrated Security=True"; SqlConnection sql = new SqlConnection(connectionString); string querry = "SELECT TOP 1 * FROM IconsTable"; SqlCommand command = new SqlCommand(querry, sql); sql.Open(); SqlDataReader takeIcon = command.ExecuteReader(); while (takeIcon.Read()) { IconsTable iconsTable = new IconsTable(); iconsTable.Icons = takeIcon["Icons"].ToString(); IconChangeVar = iconsTable.Icons; } sql.Close(); SunriseNow = outPut.sys.sunrise; SunsetNow = outPut.sys.sunset; TimeNow = outPut.dt; if (IconChangeVar == null) { string iconNr1 = outPut.weather[0].icon; string url1 = string.Format("http://openweathermap.org/img/wn/{0}@2x.png", iconNr1); WebRequest request1 = WebRequest.Create(url1); using (var response1 = request1.GetResponse()) { using (var str1 = response1.GetResponseStream()) { pictureBox1.Image = Bitmap.FromStream(str1); } } } else { ChangeIcon1(); } if (outPut.dt >= outPut.sys.sunrise && outPut.dt <= outPut.sys.sunset) { BackgroundImage = Properties.Resources.day; } else { BackgroundImage = Properties.Resources.night; } } }
partial void InsertIconsTable(IconsTable instance);
void getForcast() { int day = 10; string url = string.Format("http://api.openweathermap.org/data/2.5/forecast?q={0}&units=metric&cnt={1}&APPID={2}", cityName, day, APPID); using (WebClient web = new WebClient()) { var json = web.DownloadString(url); var Object = JsonConvert.DeserializeObject <WeatherForcast>(json); WeatherForcast forcast = Object; DayNight2 = forcast.list[0].sys.pod; DayNight3 = forcast.list[3].sys.pod; DayNight4 = forcast.list[6].sys.pod; DayNight5 = forcast.list[9].sys.pod; lbl_Days2.Text = string.Format("{0}", forcast.list[0].dt_txt); lbl_Conditions2.Text = string.Format("{0}", forcast.list[0].weather[0].main); //oro būsena lbl_Description2.Text = string.Format("{0}", forcast.list[0].weather[0].description); //oro aprašimas lbl_daysTemp2.Text = string.Format("{0} \u00B0" + "C", forcast.list[0].main.temp); //oro temperatūra lbl_WindSpeed2.Text = string.Format("{0} km/h", forcast.list[0].wind.speed); //vėjo greitis lbl_Days3.Text = string.Format("{0}", forcast.list[3].dt_txt); lbl_Conditions3.Text = string.Format("{0}", forcast.list[3].weather[0].main); //oro būsena lbl_Description3.Text = string.Format("{0}", forcast.list[3].weather[0].description); //oro aprašimas lbl_daysTemp3.Text = string.Format("{0} \u00B0" + "C", forcast.list[3].main.temp); //oro temperatūra lbl_WindSpeed3.Text = string.Format("{0} km/h", forcast.list[3].wind.speed); //vėjo greitis lbl_Days4.Text = string.Format("{0}", forcast.list[6].dt_txt); lbl_Conditions4.Text = string.Format("{0}", forcast.list[6].weather[0].main); lbl_Description4.Text = string.Format("{0}", forcast.list[6].weather[0].description); lbl_daysTemp4.Text = string.Format("{0} \u00B0" + "C", forcast.list[6].main.temp); lbl_WindSpeed4.Text = string.Format("{0} km/h", forcast.list[6].wind.speed); lbl_Days5.Text = string.Format("{0}", forcast.list[9].dt_txt); lbl_Conditions5.Text = string.Format("{0}", forcast.list[9].weather[0].main); lbl_Description5.Text = string.Format("{0}", forcast.list[9].weather[0].description); lbl_daysTemp5.Text = string.Format("{0} \u00B0" + "C", forcast.list[9].main.temp); lbl_WindSpeed5.Text = string.Format("{0} km/h", forcast.list[9].wind.speed); string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\serge\source\repos\BaigiamasisDarbas_Orai_Sergej\BaigiamasisDarbas_Orai_Sergej\City.mdf;Integrated Security=True"; SqlConnection sql = new SqlConnection(connectionString); string querry = "SELECT TOP 1 * FROM IconsTable"; SqlCommand command = new SqlCommand(querry, sql); sql.Open(); SqlDataReader takeIcon = command.ExecuteReader(); while (takeIcon.Read()) { IconsTable iconsTable = new IconsTable(); iconsTable.Icons = takeIcon["Icons"].ToString(); IconChangeVar = iconsTable.Icons; } sql.Close(); if (IconChangeVar == null) { string iconNr2 = forcast.list[0].weather[0].icon; string url2 = string.Format("http://openweathermap.org/img/wn/{0}@2x.png", iconNr2); WebRequest request2 = WebRequest.Create(url2); using (var response2 = request2.GetResponse()) { using (var str2 = response2.GetResponseStream()) { pictureBox2.Image = Bitmap.FromStream(str2); } } string iconNr3 = forcast.list[3].weather[0].icon; string url3 = string.Format("http://openweathermap.org/img/wn/{0}@2x.png", iconNr3); WebRequest request3 = WebRequest.Create(url3); using (var response3 = request3.GetResponse()) { using (var str3 = response3.GetResponseStream()) { pictureBox3.Image = Bitmap.FromStream(str3); } } string iconNr4 = forcast.list[6].weather[0].icon; string url4 = string.Format("http://openweathermap.org/img/wn/{0}@2x.png", iconNr4); WebRequest request4 = WebRequest.Create(url4); using (var response4 = request4.GetResponse()) { using (var str4 = response4.GetResponseStream()) { pictureBox4.Image = Bitmap.FromStream(str4); } } string iconNr5 = forcast.list[9].weather[0].icon; string url5 = string.Format("http://openweathermap.org/img/wn/{0}@2x.png", iconNr5); WebRequest request5 = WebRequest.Create(url5); using (var response5 = request5.GetResponse()) { using (var str5 = response5.GetResponseStream()) { pictureBox5.Image = Bitmap.FromStream(str5); } } } else { ChangeIcon2(); ChangeIcon3(); ChangeIcon4(); ChangeIcon5(); } } }