public void UpdateOrphanEpisodes(WatchTowerEF WTData)
{
foreach (Episode EpsItem in WTData.Episodes)
if (EpsItem.FileFullPath != "")
if (!File.Exists(EpsItem.FileFullPath))
EpsItem.FileFullPath = "";
WTData.SaveChanges();
}
//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;
}
public List<Episode> GetListOfExstingEpisodes(WatchTowerEF WTData)
{
List<Episode> EpsList;
EpsList = WTData.Episodes.Where(e => e.FileFullPath != "").ToList<Episode>();
return EpsList;
}
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;
}