public static void AddWatchedHistory(DBTrackInfo MusicVideo, DBUser user)
{
DBWatchedHistory history = new DBWatchedHistory();
history.DateWatched = DateTime.Now;
history.Movie = MusicVideo;
history.User = user;
history.Commit();
MusicVideo.Commit();
}
public static void AddWatchedHistory(DBTrackInfo MusicVideo, DBUser user)
{
DBWatchedHistory history = new DBWatchedHistory();
history.DateWatched = DateTime.Now;
history.Movie = MusicVideo;
history.User = user;
history.Commit();
MusicVideo.Commit();
}
// 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);
}
}
// Initializes the database connection to the Music video Plugin database
private static void initDB()
{
if (_databaseManager != null)
return;
string fullDBFileName = MediaPortal.Configuration.Config.GetFile(MediaPortal.Configuration.Config.Dir.Database, dbFileName);
_databaseManager = new DatabaseManager(fullDBFileName);
// check that we at least have a default user
List<DBUser> users = DBUser.GetAll();
if (users.Count == 0)
{
DBUser defaultUser = new DBUser();
defaultUser.Name = "Default User";
defaultUser.Commit();
}
// add all filter helpers
// _databaseManager.AddFilterHelper<DBMovieInfo>(new FilterHelperDBMovieInfo());
}
