/// <summary>
/// Returns a list of DBTrackInfo objects that match the artist
/// </summary>
/// <param name="mbid"></param>
/// <returns></returns>
public static List <DBTrackInfo> GetEntriesByArtist(DBArtistInfo mv)
{
if (mv == null)
{
return(null);
}
lock (lockList)
{
List <DBTrackInfo> results = new List <DBTrackInfo>();
List <DBTrackInfo> db1 = DBTrackInfo.GetAll();
foreach (DBTrackInfo db2 in db1)
{
if (db2.ArtistInfo.Count > 0)
{
if (mv == db2.ArtistInfo[0])
{
results.Add(db2);
}
}
}
return(results);
}
}
// One time upgrade tasks for movie information
public static void PerformMusicVideoInformationUpgradeCheck()
{
Version ver = Assembly.GetExecutingAssembly().GetName().Version;
logger.Info("Performing MusicVideo Information Upgrade Check...");
float count = 0;
List <DBTrackInfo> mvs = DBTrackInfo.GetAll();
float total = mvs.Count;
foreach (DBTrackInfo mv in mvs)
{
if (MaintenanceProgress != null)
{
MaintenanceProgress("", (int)(count * 100 / total));
}
count++;
// Skip uncommited files
if (mv.ID == null)
{
continue;
}
#region Upgrades required for 0.7.1
if (mvCentralCore.GetDbVersionNumber() < new Version("0.7.1"))
{
if (mv.LocalMedia.Count > 0 && mv.LocalMedia[0].ImportPath != null)
{
if (mv.LocalMedia[0].ImportPath.IsOpticalDrive && mv.LocalMedia[0].IsAvailable)
{
mv.DateAdded = mv.LocalMedia[0].File.CreationTime;
}
else
{
mv.DateAdded = mv.DateAdded.AddSeconds((double)mv.ID);
}
}
}
#endregion
// commit MusicVideo
mv.Commit();
}
if (MaintenanceProgress != null)
{
MaintenanceProgress("", 100);
}
}
/// <summary>
/// Returns a list of DBTrackInfo that are marked as DVDs
/// </summary>
/// <param name="mbid"></param>
/// <returns></returns>
public static List <DBTrackInfo> GetDVDEntries()
{
lock (lockList)
{
List <DBTrackInfo> results = new List <DBTrackInfo>();
List <DBTrackInfo> db1 = DBTrackInfo.GetAll();
foreach (DBTrackInfo db2 in db1)
{
if (db2.LocalMedia[0].IsDVD)
{
results.Add(db2);
}
}
return(results);
}
}
// Loops through all mvCentral in the system to verify them
public static void VerifyMusicVideoInformation()
{
logger.Info("Updating MusicVideo Information...");
float count = 0;
List <DBTrackInfo> mvs = DBTrackInfo.GetAll();
List <DBUser> users = DBUser.GetAll();
float total = mvs.Count;
int removed = 0;
int settings = 0;
foreach (DBTrackInfo mv in mvs)
{
if (MaintenanceProgress != null)
{
MaintenanceProgress("", (int)(count * 100 / total));
}
count++;
// Skip uncommited files
if (mv.ID == null)
{
continue;
}
#region Remove MusicVideo without attached local media
// Remove mvCentral with no files
if (mv.LocalMedia.Count == 0)
{
logger.Info("'{0}' was removed from the system because it had no local media.", mv.Track);
mv.Delete();
removed++;
continue;
}
#endregion
#region Add missing user settings
if (mv.UserSettings.Count == 0)
{
logger.Info("'{0}' was missing UserMovingSettings, adding now.", mv.Track);
foreach (DBUser currUser in users)
{
DBUserMusicVideoSettings userSettings = new DBUserMusicVideoSettings();
userSettings.User = currUser;
userSettings.Commit();
mv.UserSettings.Add(userSettings);
userSettings.CommitNeeded = false;
}
// lock (mv)
{
mv.Commit();
}
settings++;
}
#endregion
}
logger.Info("Removed {0} MusicVideo entries.", removed.ToString());
logger.Info("Updated {0} MusicVideo entries with default user setting.", settings.ToString());
if (MaintenanceProgress != null)
{
MaintenanceProgress("", 100);
}
}