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(); }