Creating New Tours

public async Task<int> CreateTourAsync(
    TourRegistrationRequest request,
    CancellationToken cancellationToken = default)
{
    using var connection = CreateConnection();
    await connection.OpenAsync(cancellationToken);

    using var command = new SqlCommand("sp_Tour_Insert", connection)
    {
        CommandType = CommandType.StoredProcedure
    };

    // Convert OwnerUserId from string to int
    int ownerId = 0;
    if (!string.IsNullOrWhiteSpace(request.OwnerUserId))
    {
        int.TryParse(request.OwnerUserId, out ownerId);
    }

    command.Parameters.AddWithValue("@OwnerUserId", ownerId);
    command.Parameters.AddWithValue("@Title", request.Title ?? string.Empty);
    command.Parameters.AddWithValue("@LocationLabel", request.LocationLabel ?? string.Empty);
    command.Parameters.AddWithValue("@ImageList", (object?)request.ImageList ?? DBNull.Value);
    command.Parameters.AddWithValue("@DescriptionHtml", (object?)request.DescriptionHtml ?? DBNull.Value);
    command.Parameters.AddWithValue("@ShortDescription", (object?)request.ShortDescription ?? DBNull.Value);
    command.Parameters.AddWithValue("@MuestraInstantanea", request.MuestraInstantanea);

    var idParameter = new SqlParameter("@NewTourId", SqlDbType.Int)
    {
        Direction = ParameterDirection.Output
    };
    command.Parameters.Add(idParameter);

    await command.ExecuteNonQueryAsync(cancellationToken);

    return (int)(idParameter.Value ?? 0);
}

public record TourRegistrationRequest(
    string OwnerUserId,
    string Title,
    string LocationLabel,
    string ShortDescription,
    string DescriptionHtml,
    string ImageList,
    bool IsActive,
    bool MuestraInstantanea,
    bool IsQuote,
    bool IsNoPayment,
    decimal? QuoteDepositPercent,
    int? QuoteDueDays,
    DateTime? CreatedAt,
    DateTime? UpdatedAt);