public void Injured(UpdatePlayerModel player)
{
using (var conn = (SqlConnection)_db.CreateConnection())
using (var cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandTimeout = 300;
cmd.Parameters.AddWithValue("@player_id", player.PlayerId);
cmd.Parameters.AddWithValue("@team_code", player.TeamCode);
cmd.Parameters.AddWithValue("@roster_transaction_type_id", 2);
cmd.Parameters.AddWithValue("@effective_date", player.EffectiveDate);
cmd.CommandText = string.Format($@"
INSERT INTO roster_transaction (
player_id,
team_code,
roster_transaction_type_id,
effective_date)
VALUES ( @player_id, @team_code, @roster_transaction_type_id, @effective_date)" );
cmd.ExecuteScalar();
}
}
public IActionResult Injured([FromBody] UpdatePlayerModel player)
{
player.TeamCode = _playerService.GetCurrentTeamCode(player.PlayerId);
_updatePlayerService.Injured(player);
return(Ok());
}
public IActionResult Trade([FromBody] UpdatePlayerModel player)
{
_updatePlayerService.Trade(player);
return(Ok());
}