// 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;
}
}
public GSystem(string _systemCode)
{
// Set GSystem based on systemCode
GSystem gsystem = (from g in GetSystems()
where g.systemCode == _systemCode
select g).FirstOrDefault();
systemId = gsystem.systemId;
systemCode = gsystem.systemCode;
systemName = gsystem.systemName;
systemDescription = gsystem.systemDescription;
supportedFileExtensions = gsystem.supportedFileExtensions;
supportedArchiveExtensions = gsystem.supportedArchiveExtensions;
}
public static HashSet <string> GetAllowedSubFileExtensions(int systemId)
{
var exts = (from g in GSystem.GetSubSystems()
where g.systemId == systemId
select g).SingleOrDefault();
string archive = exts.supportedArchiveExtensions;
string nonArchive = exts.supportedFileExtensions;
HashSet <string> supported = new HashSet <string>();
char c = ',';
string[] aSplit = archive.Split(c);
string[] nSplit = nonArchive.Split(c);
foreach (string s in aSplit)
{
supported.Add(s);
}
foreach (string s in nSplit)
{
supported.Add(s);
}
return(supported);
}
// 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();
}
}
}
