public int getWeather(DownloadWeather myWeather) { clouds = myWeather.weather[0].description; temp = myWeather.main.temp; feels_like = myWeather.main.feels_like; temp_min = myWeather.main.temp_min; temp_max = myWeather.main.temp_max; pressure = myWeather.main.pressure; humidity = myWeather.main.humidity; windSpeed = myWeather.wind.speed; windDeg = myWeather.wind.deg; id = DateTime.Now.ToString("yyyyMMddHHmmssffff"); name = myWeather.name; return(0); }
public static void Main(string[] args) { var context = new WeatherByCity(); string choosenCity; DownloadWeather myWeather = new DownloadWeather(); DownloadWeather actualWeather; WeatherForDB actualWeatherForDB = new WeatherForDB(); Console.WriteLine("1. Sprawdz pogode \n2. Pokaz historie dla miasta"); int caseSwitch = Convert.ToInt32(Console.ReadLine()); switch (caseSwitch) { case 1: Console.WriteLine("Podaj miasto: "); choosenCity = Console.ReadLine(); actualWeather = JsonConvert.DeserializeObject <DownloadWeather>(myWeather.getWeather(choosenCity)); actualWeatherForDB.getWeather(actualWeather); Console.WriteLine("Miasto: " + actualWeather.name); Console.WriteLine("Kraj: " + actualWeather.sys.country); Console.WriteLine("Temperatura: " + actualWeather.main.temp + "°C"); Console.WriteLine("Zachmurzenie: " + actualWeather.weather[0].description); context.WeatherForDB.Add(actualWeatherForDB); context.SaveChanges(); break; case 2: Console.WriteLine("Podaj miasto"); choosenCity = Console.ReadLine(); Console.WriteLine("SELECT * FROM WeatherForDB WHERE name = '" + choosenCity + "'"); var pogody = context.WeatherForDB.FromSqlRaw("SELECT * FROM WeatherForDB WHERE name = '" + choosenCity + "'");//.ToList<DownloadWeather>(); foreach (var pogoda in pogody) { Console.WriteLine(pogoda.id.Substring(0, 4) + "-" + pogoda.id.Substring(4, 2) + "-" + pogoda.id.Substring(6, 2) + " Temperatura: " + pogoda.temp + "°C");//+" "+pogoda.id.Substring(0,4)+" "); } break; default: Console.WriteLine("Nie ma takiej opcji"); break; } }