/// <summary>
/// Deprecated Method for adding a new object to the episodes EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToepisodes(episodes episodes)
{
base.AddObject("episodes", episodes);
}
/// <summary>
/// Create a new episodes object.
/// </summary>
/// <param name="id">Initial value of the id property.</param>
public static episodes Createepisodes(global::System.Int64 id)
{
episodes episodes = new episodes();
episodes.id = id;
return episodes;
}
private void AddEpisodes(List<TvDbEpisodeInfo> episodeList, long? seriesId)
{
//Check if Episode is in table, if not, add it!
try
{
using (SABSyncEntities sabSyncEntities = new SABSyncEntities())
{
var shows = from s in sabSyncEntities.shows
where s.tvdb_id == seriesId
select new
{
s.id
};
foreach (var episode in episodeList) //Get all Episodes for show
{
if (sabSyncEntities.episodes.Any(e => e.tvdb_id == episode.EpisodeId)) //If episode was already added...update it
{
//Update all existing episodes
var episodeToUpdate = (from e in sabSyncEntities.episodes where e.tvdb_id == episode.EpisodeId select e).FirstOrDefault(); //Select the first episode ID matching the TvDB Episode ID
episodeToUpdate.season_number = episode.SeasonNumber;
episodeToUpdate.episode_number = episode.EpisodeNumber;
episodeToUpdate.episode_name = episode.EpisodeName;
episodeToUpdate.air_date = episode.FirstAired;
episodeToUpdate.overview = episode.Overview;
sabSyncEntities.episodes.ApplyCurrentValues(episodeToUpdate);
continue;
}
episodes newItem = new episodes
{
id = new long(),
show_id = shows.FirstOrDefault().id,
season_number = episode.SeasonNumber,
episode_number = episode.EpisodeNumber,
episode_name = episode.EpisodeName,
air_date = episode.FirstAired,
tvdb_id = episode.EpisodeId,
overview = episode.Overview
};
sabSyncEntities.AddToepisodes(newItem);
}
sabSyncEntities.SaveChanges(); //Insert into Database after processing each series
}
}
catch (Exception ex)
{
Logger.Log(ex.ToString());
}
}
