/// <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()); } }