public void Update(DayWeather item)
{
string sql = string.Format("Update DayWeather Set " +
"Day = '@Day', DayTemperature = '@DayTemperature', NightTemperature = '@NightTemperature', " +
"IdImagePath = '@IdImagePath'");
using (var cmd = new SqlCommand(sql, _connection))
{
cmd.Parameters.AddWithValue("@Id", item.Id);
cmd.Parameters.AddWithValue("@Day", item.Day);
cmd.Parameters.AddWithValue("@DayTemperature", item.DayTemperature);
cmd.Parameters.AddWithValue("@NightTemperature", item.NightTemperature);
_connection.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new Exception("Update operation wasn`t successful." + ex.Message, ex);
}
finally
{
_connection.Close();
}
}
}
/// <summary>
/// Fill day weather view with the weather data
/// </summary>
/// /// <param name="place">Place for which is forecast</param>
async Task FillDayWeather(string place)
{
XmlSerializer serializer = new XmlSerializer(typeof(WeatherData));
string xml;
try
{
xml = await GetWeather(DayWeatherUrl, place, 9);
}
catch (HttpRequestException)
{
throw;
}
if (xml != null)
{
try
{
TextReader reader = new StringReader(xml);
WeatherData forecast = (WeatherData)serializer.Deserialize(reader);
DayWeather.Update(forecast);
reader.Dispose();
}
catch (InvalidOperationException)
{
throw;
}
}
}
public void Create(DayWeather item)
{
string sql = string.Format("Insert Into DayWeather" +
"(Id, Day, DayTemperature, NightTemperature, IdImagePath)" +
"Values(@Id, @Day, @DayTemperature, @NightTemperature, @IdImagePath)");
using (var cmd = new SqlCommand(sql, _connection))
{
cmd.Parameters.AddWithValue("@Id", item.Id);
cmd.Parameters.AddWithValue("@Day", item.Day);
cmd.Parameters.AddWithValue("@DayTemperature", item.DayTemperature);
cmd.Parameters.AddWithValue("@NightTemperature", item.NightTemperature);
cmd.Parameters.AddWithValue("@IdImagePath", item.IdImagePath);
_connection.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new Exception("Insert operation wasn`t successful." + ex.Message, ex);
}
finally
{
_connection.Close();
}
}
}
public Weather(CityInfomaition cityInfo, TodayWeather today, DayWeather tomorrow, DayWeather third, DayWeather fourth)
{
_cityInfo = cityInfo;
_today = today;
_fourth = fourth;
_third = third;
_tomorrow = tomorrow;
}
public Weather(CityInfomaition cityInfo, TodayWeather today, DayWeather tomorrow, DayWeather third, DayWeather fourth)
{
_cityInfo = cityInfo;
_today = today;
_fourth = fourth;
_third = third;
_tomorrow = tomorrow;
}
public void AddDayWeather(CustomWeather.DayWeather dayWeather)
{
var list = _imagePathRepository.GetList().ToList();
int id = list.First(x => x.Weather == dayWeather.Weather.ToString()).Id;
var item = new DayWeather()
{
Id = _dayWeatherRepository.GetList().ToList().Count + 1,
Day = dayWeather.Day,
DayTemperature = dayWeather.DayTemperature,
NightTemperature = dayWeather.NightTemperature,
IdImagePath = id
};
_dayWeatherRepository.Create(item);
_dayWeatherRepository.Save();
}
public MainWindow()
{
InitializeComponent();
Forecaster = new Forecaster();
CurrentWeather = new CurrentWeather();
DayWeather = new DayWeather();
WeekWeather = new WeekWeather();
this.CurrentPage.DataContext = CurrentWeather;
this.WeekForecastPage.DataContext = DayWeather;
CreateDayForecast();
this.WeekForecastPage.DataContext = WeekWeather;
CreateWeekForecast();
FillWeatherPages("London");
PlaceBox.Items.Add(new TextBlock()
{
Text = "London"
});
}
/// <summary>Sets the day weather for the currently selected day.</summary>
/// <param name="dayWeather">The day weather.</param>
private void SetDayWeather(DayWeather dayWeather)
{
IsToday = dayWeather.Day.ToString() == "Today" ? true : false;
foreach (var item in SevenDayForecast)
{
if (item.Day == dayWeather.Day)
{
item.DayColor = Color.GreenYellow;
item.IsSelected = true;
}
else
{
item.DayColor = Color.DarkGray;
item.IsSelected = false;
}
}
SelectedDayWeather = dayWeather;
}
public void Delete(DayWeather item)
{
string sql = string.Format($"Delete from DayWeather where Id ='{item.Id}'");
using (var cmd = new SqlCommand(sql, _connection))
{
_connection.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new Exception("Delete operation wasn`t successful." + ex.Message, ex);
}
finally
{
_connection.Close();
}
}
}
/// <summary>
/// If exists- generates collection for user from day weather objects
/// </summary>
public void PopulateDayWeatherList()
{
if (daysObservableCollection != null)
{
daysObservableCollection.Clear();
FirstDay = null;
}
if (!CreatedWeatherGetter.ErrorOccured)
{
try
{
daysObservableCollection = new ObservableCollection <DayWeather>(CreatedWeatherGetter.PopulateDayWeatherList());
FirstDay = daysObservableCollection.FirstOrDefault();
daysObservableCollection.RemoveAt(0);
}
catch (Exception e)
{
MessageBox.Show("VIEWMODEL: " + e.Message);
}
}
}
public DayWeather Get(int id)
{
DayWeather record = null;
string sql = string.Format("Select * FROM DayWeather where Id = @Id");
using (var cmd = new SqlCommand(sql, _connection))
{
_connection.Open();
try
{
cmd.Parameters.AddWithValue("@Id", id);
var reader = cmd.ExecuteReader();
try
{
while (reader.Read())
{
record = GetRecord(reader);
}
}
finally
{
reader.Close();
}
}
catch (SqlException ex)
{
throw new Exception("Find operation wasn`t successful." + ex.Message, ex);
}
finally
{
_connection.Close();
}
}
return(record);
}
public IList <DayWeather> GetWeatherByParkCode(string parkCode)
{
List <DayWeather> result = new List <DayWeather>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
string sql = "select * from weather WHERE parkCode = @code " +
"ORDER BY fiveDayForecastValue ASC";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@code", parkCode); //add user input safely
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DayWeather weather = new DayWeather();
weather.ParkCode = Convert.ToString(reader["parkCode"]);
weather.FiveDayForecastValue = Convert.ToInt32(reader["fiveDayForecastValue"]);
weather.Low = Convert.ToInt32(reader["low"]);
weather.High = Convert.ToInt32(reader["high"]);
weather.Forecast = Convert.ToString(reader["forecast"]);
result.Add(weather);
}
}
}
catch (SqlException ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// Weather
/// </summary>
/// <param name="cityInfo"></param>
/// <param name="today"></param>
/// <param name="dayWeathers"></param>
public Weather(CityInfomaition cityInfo, TodayWeather today, DayWeather[] dayWeathers)
{
_cityInfo = cityInfo;
_today = today;
_dayWeathers = dayWeathers;
}
