/// <summary>
/// Get all games from the game table
/// </summary>
public async Task <List <GameDatabaseEntry> > GetAllGames()
{
List <GameDatabaseEntry> gameList = new List <GameDatabaseEntry>();
if (_connection.State == System.Data.ConnectionState.Open)
{
if (await ExecuteQuery("SELECT * FROM Games") is SQLiteDataReader reader)
{
while (reader.Read())
{
GameDatabaseEntry entry = new GameDatabaseEntry
{
GameName = reader.GetString((int)ColIndex.GameName),
AddedDate = reader.GetString((int)ColIndex.AddedDate),
PC = reader.GetString((int)ColIndex.PC),
PS3 = reader.GetString((int)ColIndex.PS3),
PS4 = reader.GetString((int)ColIndex.PS4),
PSVita = reader.GetString((int)ColIndex.PSVita),
OwnedStatus = reader.GetString((int)ColIndex.OwnedStatus),
PlayedStatus = reader.GetString((int)ColIndex.PlayedStatus)
};
gameList.Add(entry);
}
}
}
return(gameList);
}
/// <summary>
/// Edit an existing game item in the database
/// </summary>
public bool EditGame(string nameToEdit, GameDatabaseEntry entry)
{
if (_connection.State == System.Data.ConnectionState.Open)
{
if (DeleteGame(nameToEdit))
{
return(AddGame(entry));
}
}
return(false);
}
public GameListEntry(GameDatabaseEntry databaseEntry)
{
try
{
Name = databaseEntry.GameName;
IsOnPS4 = databaseEntry.PS4 == "true";
IsOnPS3 = databaseEntry.PS3 == "true";
IsOnPSVita = databaseEntry.PSVita == "true";
IsOnPC = databaseEntry.PC == "true";
Owned = databaseEntry.OwnedStatus == "true";
string statusNoSpace = databaseEntry.PlayedStatus.Replace(" ", "");
PlayStatus = (Status)Enum.Parse(typeof(Status), statusNoSpace, true);
DateAdded = DateTime.Parse(databaseEntry.AddedDate);
}
catch (ArgumentException exception)
{
MessageBox.Show(exception.Message);
}
}
/// <summary>
/// Add a game item to the database
/// </summary>
public bool AddGame(GameDatabaseEntry entry)
{
if (_connection.State == System.Data.ConnectionState.Open)
{
SQLiteCommand command = _connection.CreateCommand();
command.CommandText = "INSERT OR REPLACE INTO Games" +
"(GameName, AddedDate, PC, PS3, PS4, PSVita, OwnedStatus, PlayedStatus) " +
"VALUES " +
"(@GameName, @AddedDate, @PC, @PS3, @PS4, @PSVita, @OwnedStatus, @PlayedStatus)";
command.Parameters.Add(new SQLiteParameter("@GameName", entry.GameName));
command.Parameters.Add(new SQLiteParameter("@AddedDate", entry.AddedDate));
command.Parameters.Add(new SQLiteParameter("@PC", entry.PC));
command.Parameters.Add(new SQLiteParameter("@PS3", entry.PS3));
command.Parameters.Add(new SQLiteParameter("@PS4", entry.PS4));
command.Parameters.Add(new SQLiteParameter("@PSVita", entry.PSVita));
command.Parameters.Add(new SQLiteParameter("@OwnedStatus", entry.OwnedStatus));
command.Parameters.Add(new SQLiteParameter("@PlayedStatus", entry.PlayedStatus));
return(command.ExecuteNonQuery() > 0);
}
return(false);
}
