示例#1
0
        public void UpdateOrphanEpisodes(WatchTowerEF WTData)
        {
            foreach (Episode EpsItem in WTData.Episodes)
                if (EpsItem.FileFullPath != "")
                    if (!File.Exists(EpsItem.FileFullPath))
                        EpsItem.FileFullPath = "";

            WTData.SaveChanges();
        }
示例#2
0
        //retuns a list episodes that exist on the drive
        public static List<Episode> UpdateEpisodesFromFolder(WatchTowerEF WTData)
        {
            List<Entities.Episode> EpsListToDisplay = new List<Entities.Episode>();
            string SeriesName = "";
            string sourceDir = Properties.Settings.Default.EpisodePath;
            string[] subdirEntries;
            if (Directory.Exists(sourceDir))
            {
                subdirEntries = Directory.GetDirectories(sourceDir);
                foreach (string seriesFolder in subdirEntries)
                {
                    //Get or create series
                    SeriesName = new DirectoryInfo(seriesFolder).Name;

                    Entities.Series SeriesItem = WTData.Series.Where<Entities.Series>
                        (s => s.Name == SeriesName).FirstOrDefault<Entities.Series>();
                    if (SeriesItem == null)
                    {
                        SeriesItem = WTData.Series.Add(new Entities.Series
                        {
                            Name = SeriesName
                        });
                        WTData.SaveChanges(); //save to get ID from DB
                    }

                    //iqnore files
                    var filteredFiles = Directory
                            .GetFiles(seriesFolder)
                            .Where(file => file.ToLower().Contains("thumbs.db") == false)
                            .ToList();

                    foreach (string EpisodeFile in filteredFiles)
                    {
                        FileInfo fi = new FileInfo(EpisodeFile);
                        //get file details
                        string sLastPart = fi.Name.Substring(fi.Name.IndexOf(".S") + 2);
                        int SeasonNo;
                        if (int.TryParse(sLastPart.Substring(0, 2), out SeasonNo))
                            SeasonNo = int.Parse(sLastPart.Substring(0, 2));
                        else
                        {
                            //MessageBox.Show(fi.Name);
                            continue;
                        }
                        int EpisodeNo = int.Parse(sLastPart.Substring(3, 2));
                        string EpisodeName = sLastPart.Split('.')[1];

                        //get or create episode
                        Entities.Episode EpsItem = WTData.Episodes.Where<Entities.Episode>
                            (e => e.SeriesId == SeriesItem.Id
                                && e.SeasonNo == SeasonNo
                                && e.EpisodeNo == EpisodeNo).FirstOrDefault<Entities.Episode>();
                        if (EpsItem == null)
                            EpsItem = WTData.Episodes.Add(new Episode
                            {
                                SeriesId = SeriesItem.Id,
                                Series = SeriesItem,
                                Name = EpisodeName,
                                SeasonNo = SeasonNo,
                                EpisodeNo = EpisodeNo,
                                FileFullPath = fi.FullName,
                                DateAddedToCollection = fi.LastWriteTimeUtc
                            });
                        EpsListToDisplay.Add(EpsItem);
                    }
                }
            }

            WTData.SaveChanges();
            return EpsListToDisplay;
        }
示例#3
0
        public List<Episode> GetListOfExstingEpisodes(WatchTowerEF WTData)
        {
            List<Episode> EpsList;
            EpsList = WTData.Episodes.Where(e => e.FileFullPath != "").ToList<Episode>();

            return EpsList;
        }
示例#4
0
        private void Form1_Load(object sender, EventArgs e)
        {
            WTEntities = new WatchTowerEF();
            System.Data.Entity.Database.SetInitializer<WatchTowerEF>(null);

            SetFontSize(Properties.Settings.Default.FontSize);

            timerUpdateFiles.Interval = 1;
        }