public void AddAndDeletePlayerTest()
{
var player = new Player();
player.FirstName = "TestFirstName";
player.LastName = "TestLastName";
player.JerseyNumber = 99;
player.TeamID = 1;
player.LastYearBA = 0;
player.YearsPlayed = 3;
player.PrimaryPositionID = 1;
player.SecondaryPositionID = 2;
//Add new player to Team 1
var repo = new Create();
repo.AddPlayer(player);
//Get team roster and verify new player was added
var readRepo = new Read();
var players = readRepo.GetTeamRoster(1);
var playerCount = players.Count;
var newPlayer = players.FirstOrDefault(p => p.JerseyNumber == player.JerseyNumber);
//Assert player added is on the roster
Assert.AreEqual(newPlayer.JerseyNumber, player.JerseyNumber);
//Delete Player from database
var deleteRepo = new Delete();
deleteRepo.DeletePlayer(newPlayer.PlayerID.Value);
//Get count of players on roster after delete
var playerCountAfterDelete = readRepo.GetTeamRoster(1).Count;
//Assert player count reduced after player deleted
Assert.AreEqual(playerCount - 1, playerCountAfterDelete);
}
public Player AddPlayer(Player player)
{
int playerId;
using (var connection = new SqlConnection(Settings.ConnectionString))
{
var command = new SqlCommand();
command.CommandText = "SP_AddPlayer";
command.CommandType = CommandType.StoredProcedure;
var outputParam = new SqlParameter("@PlayerID", SqlDbType.Int) { Direction = ParameterDirection.Output };
command.Connection = connection;
command.Parameters.AddWithValue("@PlayerName", player.PlayerName);
command.Parameters.AddWithValue("@JerseyNumber", player.JerseyNumber);
command.Parameters.AddWithValue("@PositionID", player.PositionID);
command.Parameters.AddWithValue("@PreviousYrsBattingAvg", player.PreviousYrsBattingAvg);
command.Parameters.AddWithValue("@NumYrsPlayed", player.NumYrsPlayed);
command.Parameters.AddWithValue("@TeamID", player.TeamID);
command.Parameters.Add(outputParam);
connection.Open();
command.ExecuteNonQuery();
playerId = (int)outputParam.Value;
player.PlayerID = playerId;
return player;
}
}
public Response()
{
League = new League();
Leagues = new List<League>();
Team = new Team();
Teams = new List<Team>();
Position = new Position();
Positions = new List<Position>();
Player = new Player();
Players = new List<Player>();
}
public void CreatePlayerTest()
{
Player player = new Player();
player.PlayerName = "Raiden";
player.JerseyNumber = 55;
player.Position.PositionID = 7;
player.BattingAverage = 0.29m;
player.YearsPlayed = 20;
player.Team.TeamID = 2;
Assert.AreEqual(true, _ops.CreatePlayer(player).Success);
}
public Response CreatePlayer(Player p)
{
var player = _repo.CreatePlayer(p);
_response = new Response();
if (player != null)
{
_response.Success = true;
_response.Player = player;
}
return _response;
}
public void CreatePlayer()
{
Player player = new Player();
player.PlayerName = "Raiden";
player.JerseyNumber = 55;
player.Position.PositionID = 7;
player.BattingAverage = 0.29m;
player.YearsPlayed = 20;
player.Team.TeamID = 2;
var result = _repo.CreatePlayer(player);
Assert.AreEqual("Raiden", result.PlayerName);
}
// Add player to database. Player object is assigned a PlayerID
public void AddPlayer(Player player)
{
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
var p = new DynamicParameters();
try
{
p.Add("FirstName", player.FirstName);
p.Add("LastName", player.LastName);
p.Add("JerseyNumber", player.JerseyNumber);
p.Add("TeamID", player.TeamID);
p.Add("LastYearBA", player.LastYearBA);
p.Add("YearsPlayed", player.YearsPlayed);
p.Add("PrimaryPositionID", player.PrimaryPositionID);
p.Add("SecondaryPositionID", player.SecondaryPositionID);
p.Add("PlayerID", DbType.Int32, direction: ParameterDirection.Output);
cn.Execute("AddPlayer", p, commandType: CommandType.StoredProcedure);
player.PlayerID = p.Get<int>("PlayerID");
}
//catch (Exception e)
//{
// var ep = new DynamicParameters();
// ep.Add("ExceptionType", e.GetType());
// ep.Add("ExceptionMessage", e.Message);
// ep.Add("Input", String.Format("FirstName = {0}, LastName = {1}, JerseyNumber = {2}," +
// "TeamID = {3}, LastYearBA = {4}, YearsPlayed = {5}, " +
// "PrimaryPositionID = {6}, SecondaryPositionID = {7}",
// player.FirstName, player.LastName, player.JerseyNumber,
// player.TeamID, player.LastYearBA, player.YearsPlayed, player.PrimaryPositionID,
// player.SecondaryPositionID));
// cn.Execute("AddError", ep, commandType: CommandType.StoredProcedure);
//}
finally
{
cn.Close();
}
}
}
public void AddPlayerTest()
{
var repo = new PlayerMockRepo();
Player player = new Player()
{
PlayerID = 8,
PlayerName = "Lucius Washington",
JerseyNumber = 25,
PositionID = 3,
PreviousYrsBattingAvg = (decimal).900,
NumYrsPlayed = 12,
TeamID = 3
};
var result = repo.AddPlayer(player);
Assert.AreEqual(result.PlayerID, 6);
}
public int CreatePlayer(Player p)
{
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
var sqlQuery = "INSERT INTO Players (PlayerName,JerseyNumber,Position,BattingAverage,YearsPlayed,TeamID) " +
"VALUES (@PlayerName,@JerseyNumber,@Position,@BattingAverage,@YearsPlayed,@TeamID)" +
"SELECT SCOPE_IDENTITY() AS id";
int playerId = cn.Query<int>(sqlQuery,
new
{
p.PlayerName,
p.JerseyNumber,
p.Position,
p.BattingAverage,
p.YearsPlayed,
p.TeamId
}).FirstOrDefault();
return playerId;
}
}
public Player CreatePlayer(Player player)
{
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
var p = new DynamicParameters();
p.Add("@PlayerName", player.PlayerName);
p.Add("@JerseyNumber", player.JerseyNumber);
p.Add("@PositionID", player.Position.PositionID);
p.Add("@BattingAverage", player.BattingAverage);
p.Add("@YearsPlayed", player.YearsPlayed);
p.Add("@TeamID", player.Team.TeamID);
p.Add("PlayerID", DbType.Int32, direction: ParameterDirection.Output);
cn.Execute("InsertPlayer", p, commandType: CommandType.StoredProcedure);
var playerID = p.Get<int>("PlayerID");
return GetPlayerByID(playerID);
}
}
private Player PopulatePlayerFromDataReader(SqlDataReader dr)
{
var player = new Player();
player.PlayerID = (int)dr["PlayerID"];
player.PlayerName = dr["PlayerName"].ToString();
player.Team.TeamID = (int)dr["TeamID"];
player.Team.TeamName = dr["TeamName"].ToString();
player.Team.Manager = dr["Manager"].ToString();
player.Team.League.LeagueID = (int)dr["LeagueID"];
player.Team.League.LeagueName = dr["LeagueName"].ToString();
player.Position.PositionID = (int)dr["PositionID"];
player.Position.PositionName = dr["PositionName"].ToString();
player.JerseyNumber = (int)dr["JerseyNumber"];
player.BattingAverage = (decimal)dr["BattingAverage"];
player.YearsPlayed = (int)dr["YearsPlayed"];
return player;
}
//for testing creating a method to check if player table is updated and then setup methods for response on bll
public Player GetPlayerByID(int playerID)
{
var player = new Player();
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select p.PlayerID, p.PlayerName, p.TeamID, t.TeamName, t.Manager, " +
"l.LeagueID, l.LeagueName, p.PositionID, ps.PositionName, p.JerseyNumber, " +
"p.BattingAverage, p.YearsPlayed " +
"from Players p " +
"inner join Positions ps " +
"on p.PositionID = ps.PositionID " +
"inner join Teams t " +
"on p.TeamID = t.TeamID " +
"inner join Leagues l " +
"on t.LeagueID = l.LeagueID " +
"where p.PlayerID = @playerID";
cmd.Connection = cn;
cmd.Parameters.AddWithValue("@playerID", playerID);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
player = PopulatePlayerFromDataReader(dr);
}
}
}
return player;
}
public void TradePlayerToTeam(Player p, int teamToTradeTeamID)
{
AssociatePlayerToTeam(p.PlayerId,teamToTradeTeamID);
}
// Add player to database. Player object is assigned a PlayerID
public void AddPlayer(Player player)
{
var create = new Create();
create.AddPlayer(player);
}
public AddPlayerVM()
{
PlayerToAdd = new Player();
TeamNameSelectList = new List<SelectListItem>();
PositionSelectList = new List<SelectListItem>();
}
