public void Create(CreatePlayerModel player) { int playerId; using (var conn = (SqlConnection)_db.CreateConnection()) using (var cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 300; cmd.Parameters.AddWithValue("@lastName", player.LastName); cmd.Parameters.AddWithValue("@firstName", player.FirstName); cmd.CommandText = string.Format($@" INSERT INTO player ( last_name , first_name) VALUES ( @lastName , @firstName)" ); cmd.CommandText += $@"SELECT SCOPE_IDENTITY()"; playerId = Convert.ToInt32(cmd.ExecuteScalar()); } using (var conn = (SqlConnection)_db.CreateConnection()) using (var cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 300; cmd.Parameters.AddWithValue("@player_id", playerId); cmd.Parameters.AddWithValue("@team_code", player.TeamCode); cmd.Parameters.AddWithValue("@roster_transaction_type_id", 1); 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.CommandType = CommandType.Text; cmd.CommandTimeout = 300; cmd.ExecuteScalar(); } }
public IActionResult Create([FromBody] CreatePlayerModel player) { _createPlayerService.Create(player); return(Ok()); }