protected void btnAdd_Click(object sender, EventArgs e) { PlayerBO player = new PlayerBO(); player.AddPlayer(txtName.Text, txtAddress.Text, txtPhone.Text, txtEmail.Text); Server.Transfer("~/Player.aspx"); }
public void TestCreateNew() { PlayerBO player = new PlayerBO(); //adding comments to my unit tests //more comments player.AddPlayer("Kei Nishikori", "Japan", "", ""); Assert.IsTrue(player.GetPlayerByName("Kei Nishikori").IsActive); }
public void AddPlayer(string PlayerName, double pot) { PlayerBO player = new PlayerBO(); player.PlayerName = PlayerName; player.PlayerMoney = pot; conn.AddPlayer(player); }
public void AddPlayer(PlayerBO player) { string query = "INSERT INTO Player(PlayerName, PlayerMoney) VALUES (@PlayerName, @PlayerMoney)"; SqlParameter[] sqlParameters = new SqlParameter[2]; sqlParameters[0] = new SqlParameter("@PlayerName", SqlDbType.VarChar); sqlParameters[0].Value = player.PlayerName; sqlParameters[1] = new SqlParameter("@PlayerMoney", SqlDbType.SmallMoney); sqlParameters[1].Value = player.PlayerMoney; conn.executeInsertQuery(query, sqlParameters); }
public List <PlayerBO> GetPlayers() { SqlDataReader dr; string query = "SELECT * FROM Player"; SqlParameter[] sqlParameters = new SqlParameter[0]; dr = conn.executeSelectQuery(query, sqlParameters); while (dr.Read()) { PlayerBO player = new PlayerBO(); player.PlayerName = dr["PlayerName"].ToString(); player.PlayerMoney = Convert.ToDouble(dr["PlayerMoney"]); player.PlayerID = Convert.ToInt32(dr["PlayerID"]); Players.Add(player); } return(Players); }
public List <int> GetFourPlayers(List <string> playersInGame) { SqlDataReader dr; SqlParameter[] sqlParameters = new SqlParameter[0]; List <int> players = new List <int>(); foreach (string name in playersInGame) { string query = "Select PlayerID From Player where PlayerName = " + "'" + name + "'"; dr = conn.executeSelectQuery(query, sqlParameters); PlayerBO player = new PlayerBO(); while (dr.Read()) { player.PlayerID = Convert.ToInt32(dr["PlayerID"]); players.Add(player.PlayerID); } } return(players); }