public void ChangeGame(Room room, WolfNet game)
{
string query = "INSERT INTO game (gameId, roomId, game_name) VALUES(@id, @roomId, @name)";
using (var cmd = new NpgsqlCommand(query, _connection, _transaction))
{
cmd.Parameters.AddWithValue("id", game.ID);
cmd.Parameters.AddWithValue("roomId", room.ID);
cmd.Parameters.AddWithValue("name", game.GetGameName());
cmd.ExecuteNonQuery();
}
}
public newList()
{
this.Players = new List <Guid>();
this.PlayerRole = new List <int>();
ayu = User.createUser("Ayu");
bani = User.createUser("Bani");
cinta = User.createUser("Cinta");
dita = User.createUser("Dita");
ester = User.createUser("Ester");
fina = User.createUser("Fina");
grace = User.createUser("Grace");
hanako = User.createUser("Hanako");
ivanka = User.createUser("Ivanka");
jean = User.createUser("Jean");
Players.Add(ayu.ID);
Players.Add(bani.ID);
Players.Add(cinta.ID);
Players.Add(dita.ID);
Players.Add(ester.ID);
Players.Add(fina.ID);
Players.Add(grace.ID);
Players.Add(hanako.ID);
Players.Add(ivanka.ID);
Players.Add(jean.ID);
PlayerRole.Add(1);
PlayerRole.Add(3);
PlayerRole.Add(2);
PlayerRole.Add(2);
PlayerRole.Add(2);
PlayerRole.Add(1);
PlayerRole.Add(2);
PlayerRole.Add(2);
PlayerRole.Add(1);
PlayerRole.Add(2);
game = GameFactory.Create("werewolf", Players, PlayerRole, null, "");
CheckWin();
}
