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