// Constructor public LibrarySidebar(int gameId) { db = new MyDbContext(); // populate public properties GameId = gameId; Game game = (from g in db.Game where g.gameId == gameId select g).SingleOrDefault(); if (game == null) { return; } GameName = game.gameName; GamePath = game.gamePath; IsFavorite = game.isFavorite; LastPlayed = game.gameLastPlayed; LastFinished = game.gameLastFinished; TotalPlayTime = game.gameTime; TimesPlayed = game.timesPlayed; SystemId = game.systemId; SystemCode = GSystem.GetSystemCode(SystemId); SystemName = GSystem.GetSystemName(SystemId); SystemDescription = GSystem.GetSystemDesc(SystemId); if (game.gdbId != null) { gdbid = game.gdbId.Value; } AlternateTitles = game.AlternateTitles; Genres = game.Genres; Coop = game.Coop; Developer = game.Developer; ESRB = game.ESRB; Overview = game.Overview; Players = game.Players; Publisher = game.Publisher; Year = game.Year; Copyright = game.Copyright; Country = game.Country; DevelopmentStatus = game.DevelopmentStatus; Language = game.Language; OtherFlags = game.OtherFlags; if (game.ManualEditSet == true) { ManEdit = true; } else { ManEdit = false; } }
// remove all disk-based games from db for a certain system public static void RemoveDisks(int sysId) { MessageBoxResult result = MessageBox.Show("This operation will wipe out ALL the " + GSystem.GetSystemName(sysId) + " games in your library database (but they will not be deleted from disk)\n\nAre you sure you wish to continue?", "WARNING", MessageBoxButton.OKCancel, MessageBoxImage.Warning); if (result == MessageBoxResult.OK) { // get all disks for specific system using (var context = new MyDbContext()) { List <Game> disks = (from a in context.Game where a.systemId == sysId select a).ToList(); Game.DeleteGames(disks); // GameListBuilder.UpdateFlag(); } } }