public void Update(string gameName, Game game)
{
var parms = new Dictionary<string, string>();
parms.Add("@TableName", "games");
parms.Add("@Game", "game");
parms.Add("@GameName", gameName);
_db.Update("games", game.ToDictionary(), "@Game = '@GameName'", parms);
}
private Game NewGame(string gameName)
{
var game = new Game(gameName);
game.FirstPlayed = DateTime.Now;
var data = game.ToDictionary();
data.Add("game", game.Name);
_db.Insert("games", data);
return game;
}
public Game GetGame(string gameName)
{
//Get the message to be edited
var parms = new Dictionary<string, string>();
parms.Add("@TableName", "games");
parms.Add("@Game", "game");
parms.Add("@Name", gameName);
var results = _db.Query("SELECT * FROM @TableName WHERE @Game = '@Name'", parms);
//If game isn't found, create a new game
if (results.Rows.Count == 0)
return NewGame(gameName);
else //Otherwise, create a game and fill it with data from the database.
{
var game = new Game(gameName, DataRowToDictionary(results.Rows[0]));
return game;
}
}
