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