Extras & Add-ons

public record TourExtraRequest(
    string Name,                // Extra name
    string Description,         // What's included
    int ChargeMode,            // 0=Free, 1=Flat, 2=Per Person
    decimal? BasePrice,        // Base price (for flat rate)
    string CurrencyCode,       // "USD", "DOP", "EUR"
    IEnumerable<TourExtraTicketPriceRequest> TicketPrices, // Per-person pricing
    int SortOrder);            // Display order

public record TourExtraTicketPriceRequest(
    Guid TicketTypeId,         // Frontend identifier
    string TicketName,         // "Adult", "Child"
    decimal? Price);           // Price for this ticket type

var photoPackage = new TourExtraRequest(
    Name: "Professional Photo Package",
    Description: "20 high-res photos of your tour, delivered digitally within 48 hours",
    ChargeMode: 1,              // Flat rate
    BasePrice: 25.00m,
    CurrencyCode: "USD",
    TicketPrices: Array.Empty<TourExtraTicketPriceRequest>(),
    SortOrder: 1
);

var lunchUpgrade = new TourExtraRequest(
    Name: "Premium Lunch",
    Description: "3-course meal at a local restaurant with wine pairing",
    ChargeMode: 2,              // Per person
    BasePrice: null,            // Not used for per-person
    CurrencyCode: "USD",
    TicketPrices: new[]
    {
        new TourExtraTicketPriceRequest(
            TicketTypeId: Guid.NewGuid(),  // Links to adult ticket
            TicketName: "Adult",
            Price: 35.00m
        ),
        new TourExtraTicketPriceRequest(
            TicketTypeId: Guid.NewGuid(),  // Links to child ticket
            TicketName: "Child",
            Price: 18.00m
        )
    },
    SortOrder: 2
);

public async Task UpsertExtrasAsync(
    int tourId,
    IEnumerable<TourExtraRequest> extras,
    CancellationToken cancellationToken = default)
{
    if (extras is null) return;

    using var connection = CreateConnection();
    await connection.OpenAsync(cancellationToken);

    foreach (var extra in extras)
    {
        using var command = new SqlCommand("sp_TourExtra_Insert", connection)
        {
            CommandType = CommandType.StoredProcedure
        };

        command.Parameters.AddWithValue("@TourId", tourId);
        command.Parameters.AddWithValue("@Name", extra.Name ?? string.Empty);
        command.Parameters.AddWithValue("@Description", (object?)extra.Description ?? DBNull.Value);
        command.Parameters.AddWithValue("@ChargeMode", extra.ChargeMode);
        command.Parameters.AddWithValue("@BasePrice", (object?)extra.BasePrice ?? DBNull.Value);
        command.Parameters.AddWithValue("@CurrencyCode", extra.CurrencyCode ?? "USD");
        command.Parameters.AddWithValue("@SortOrder", extra.SortOrder);

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

        await command.ExecuteNonQueryAsync(cancellationToken);

        // Get the generated TourExtraId
        var extraId = (int)(extraIdParameter.Value ?? 0);

        // If per-person pricing, store ticket-specific prices
        if (extra.ChargeMode == 2 && extra.TicketPrices is not null)
        {
            foreach (var price in extra.TicketPrices)
            {
                using var priceCommand = new SqlCommand("sp_TourExtraPerTicketType_Insert", connection)
                {
                    CommandType = CommandType.StoredProcedure
                };

                priceCommand.Parameters.AddWithValue("@TourExtraId", extraId);
                priceCommand.Parameters.AddWithValue("@TourTicketTypeId", 0); // Placeholder
                priceCommand.Parameters.AddWithValue("@Price", (object?)price.Price ?? DBNull.Value);

                await priceCommand.ExecuteNonQueryAsync(cancellationToken);
            }
        }
    }
}

public sealed record TourExtraDetailDto(
    int TourExtraId,
    string Name,
    string? Description,
    byte ChargeMode,                    // 0=Free, 1=Flat, 2=Per Person
    decimal? BasePrice,
    string CurrencyCode,
    bool IsActive,
    int SortOrder,
    IReadOnlyList<TourExtraPricePerTicketDetailDto> TicketPrices
);

public sealed record TourExtraPricePerTicketDetailDto(
    int TourExtraPerTicketTypeId,
    int TourExtraId,
    int TourTicketTypeId,
    decimal Price
);

<div class="extra-row">
    <div class="extra-left">
        <input type="checkbox" 
               @bind="selectedExtras[extra.TourExtraId]" 
               id="extra_@extra.TourExtraId" />
        <label for="extra_@extra.TourExtraId">
            <span class="extra-name">@extra.Name</span>
            @if (!string.IsNullOrWhiteSpace(extra.Description))
            {
                <button type="button" 
                        class="extra-tip-btn" 
                        data-tip="@extra.Description">
                    ?
                </button>
            }
        </label>
    </div>
    <div class="extra-price">
        @if (extra.ChargeMode == 1)
        {
            <!-- Flat rate -->
            <span>@FormatCurrency(extra.BasePrice ?? 0, extra.CurrencyCode)</span>
        }
        else if (extra.ChargeMode == 2)
        {
            <!-- Per person -->
            <span>From @FormatCurrency(GetMinExtraPrice(extra), extra.CurrencyCode)/person</span>
        }
    </div>
</div>

private decimal CalculateExtrasTotal()
{
    decimal total = 0;
    
    foreach (var extra in _tourExtras.Where(e => selectedExtras.GetValueOrDefault(e.TourExtraId)))
    {
        if (extra.ChargeMode == 1)
        {
            // Flat rate
            total += extra.BasePrice ?? 0;
        }
        else if (extra.ChargeMode == 2)
        {
            // Per person - sum across all ticket types
            foreach (var ticketType in _ticketTypes)
            {
                var quantity = GetTicketQuantity(ticketType.TourTicketTypeId);
                if (quantity > 0)
                {
                    var priceForType = extra.TicketPrices
                        .FirstOrDefault(p => p.TourTicketTypeId == ticketType.TourTicketTypeId)?.Price ?? 0;
                    total += priceForType * quantity;
                }
            }
        }
    }
    
    return total;
}