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