internal static WeatherCity getWeatherByDayAndCity(string city, DateTime day)
{
string Command = "SELECT * FROM Weather WHERE City = '" + city + "' AND Date = '" + day.ToString("yyy-MM-dd") + "'";
var result = WeatherTableCreator.ReadData(Command);
return(result.Count > 0 ? result[0] : null);
}
internal static List <WeatherCity> getWeatherForAllCitiesAndAllDays()
{
string Command = "SELECT * FROM Weather";
var result = WeatherTableCreator.ReadData(Command);
return(result.Count > 0 ? result : null);
}
internal static List <WeatherCity> getWeatherByDayForAllCities(DateTime day)
{
string Command = "SELECT * FROM Weather WHERE Date = '" + day.ToString("yyy-MM-dd") + "'";
var result = WeatherTableCreator.ReadData(Command);
return(result.Count > 0 ? result : null);
}
internal static void addWeatherForACity(WeatherCity weathercityModel)
{
string Command = "INSERT OR REPLACE INTO Weather(City, Date, MinTemp, MaxTemp)" +
" VALUES('" + weathercityModel.City + "', date('" + weathercityModel.Date.ToString("yyy-MM-dd") + "')," + weathercityModel.MinTemp + "," +
weathercityModel.MaxTemp + ");";
WeatherTableCreator.ReadData(Command);
return;
}
