public void ChangeGame(Room room, Casual game)
{
string query = "INSERT INTO game (gameId, roomId, game_name) VALUES (@gameId, @roomId, @name)";
using (var cmd = new NpgsqlCommand(query, _connection, _transaction))
{
cmd.Parameters.AddWithValue("gameId", game.ID);
cmd.Parameters.AddWithValue("roomId", room.ID);
cmd.Parameters.AddWithValue("name", game.GameName());
cmd.ExecuteNonQuery();
}
}
