/// <summary>
 /// Create a new shows object.
 /// </summary>
 /// <param name="id">Initial value of the id property.</param>
 public static shows Createshows(global::System.Int64 id)
 {
     shows shows = new shows();
     shows.id = id;
     return shows;
 }
 /// <summary>
 /// Deprecated Method for adding a new object to the shows EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToshows(shows shows)
 {
     base.AddObject("shows", shows);
 }
Exemple #3
0
        private void AddNewShowWithEpisodes(string showName)
        {
            //TODO: Find a way to migrate aliases to Database... or not, not a big deal IMO
            //Update the shows table, get TVDB ID and Name, possible get TVRage ID and Name

            Logger.Log("Checking if {0} is in Database: ", showName);

            try
            {
                using (SABSyncEntities sabSyncEntities = new SABSyncEntities())
                {
                    if (sabSyncEntities.shows.Any(s => s.show_name == showName)) //If show was already added...skip it (Use local disk name)
                        return;

                    //Get TVDB ID & Name
                    TvDbShowInfo info = new TvDbShowInfo();
                    info = TvDb.GetShowData(showName);

                    if (info == null)
                        return;

                    //string aliases = GetAliasForDb(showName, info.SeriesName);
                    int downloadQuality = GetQualityForDb();

                    //Add to shows Database
                    shows newItem = new shows
                                        {
                                            id = new int(),
                                            show_name = showName,
                                            tvdb_id = Convert.ToInt32(info.SeriesId),
                                            tvdb_name = info.SeriesName,
                                            ignore_season = 0,
                                            air_day = info.AirDay,
                                            air_time = info.AirTime,
                                            run_time = Convert.ToInt32(info.RunTime),
                                            status = info.Status,
                                            poster_url = info.PosterUrl,
                                            banner_url = info.BannerUrl,
                                            imdb_id = info.ImdbId,
                                            genre = info.Genre.Trim('|'),
                                            overview = info.Overview,
                                            quality = downloadQuality,
                                            aliases = GetAliasForDb(showName)
                    };
                    Logger.Log("Adding {0} to database.", showName);

                    sabSyncEntities.AddToshows(newItem);
                    sabSyncEntities.SaveChanges(); //Save show to Database after each show
                    var newShow = (from s in sabSyncEntities.shows where s.tvdb_id == info.SeriesId select s).FirstOrDefault(); //Get the PK for the show just added (so we can get the banner)
                    TvDb.GetBanner(info.BannerUrl, newShow.id); //Get the banner and save to disk
                    AddEpisodes(info.Episodes, Convert.ToInt32(info.SeriesId)); //Add all episodes for this show
                }
            }
            catch (Exception ex)
            {
                Logger.Log(ex.ToString());
            }
        }