Pricing Strategies

public record TourRegistrationRequest(
    // ... other fields
    bool IsQuote,                    // Requires approval before booking
    bool IsNoPayment,                // No online payment required
    decimal? QuoteDepositPercent,    // Deposit % (e.g., 0.25 = 25%)
    int? QuoteDueDays,               // Days until full payment due
    // ...
);

var quoteTour = new TourRegistrationRequest(
    // ... basic fields
    IsQuote: true,
    IsNoPayment: false,
    QuoteDepositPercent: 0.30m,     // 30% deposit required
    QuoteDueDays: 14,                // Full payment 14 days before tour
    // ...
);

public class DepositCalculator
{
    public decimal CalculateDeposit(decimal totalAmount, decimal depositPercent)
    {
        return Math.Round(totalAmount * depositPercent, 2);
    }
    
    public decimal CalculateRemainder(decimal totalAmount, decimal depositPaid)
    {
        return totalAmount - depositPaid;
    }
    
    public DateTime CalculateDueDate(DateTime travelDate, int dueDays)
    {
        return travelDate.AddDays(-dueDays);
    }
}

// Example usage
var calculator = new DepositCalculator();
var tourPrice = 500.00m;
var depositPercent = 0.30m;
var travelDate = new DateTime(2026, 06, 15);

var depositAmount = calculator.CalculateDeposit(tourPrice, depositPercent);
// Result: $150.00

var remainder = calculator.CalculateRemainder(tourPrice, depositAmount);
// Result: $350.00

var dueDate = calculator.CalculateDueDate(travelDate, 14);
// Result: June 1, 2026

public sealed record TourReservationRequest(
    // ... booking fields
    byte PaymentStatus,         // 0=Unpaid, 1=Paid, 2=Partial, 3=Refunded, 4=Cancelled
    byte PaymentPlanType,       // 0=Full, 1=Deposit, 2=Split, 3=Custom
    decimal? DepositPercent,    // Deposit percentage paid
    decimal? AmountPaid,        // Amount paid so far
    decimal? AmountPending,     // Amount still owed
    DateTime? NextChargeDate,   // When next payment is due
    // ...
);

public async Task UpdateReservationPaymentStatusAsync(
    int reservationId,
    byte paymentStatus,
    string? paymentProvider,
    string? paymentReference,
    CancellationToken cancellationToken = default)
{
    if (reservationId <= 0)
    {
        throw new ArgumentException("Invalid ReservationId.", nameof(reservationId));
    }

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

    var reservationTable = await ResolveReservationTableAsync(connection, cancellationToken);
    if (string.IsNullOrWhiteSpace(reservationTable))
    {
        throw new InvalidOperationException("Reservation table not found.");
    }

    var sql = $@"
UPDATE {reservationTable}
SET PaymentStatus = @PaymentStatus,
    PaymentProvider = @PaymentProvider,
    PaymentReference = @PaymentReference,
    UpdatedAt = SYSUTCDATETIME()
WHERE TourReservationId = @ReservationId;";

    await using var cmd = new SqlCommand(sql, connection);
    cmd.Parameters.Add(new SqlParameter("@PaymentStatus", SqlDbType.TinyInt) { Value = paymentStatus });
    cmd.Parameters.AddWithValue("@PaymentProvider", (object?)paymentProvider ?? DBNull.Value);
    cmd.Parameters.AddWithValue("@PaymentReference", (object?)paymentReference ?? DBNull.Value);
    cmd.Parameters.Add(new SqlParameter("@ReservationId", SqlDbType.Int) { Value = reservationId });

    var rows = await cmd.ExecuteNonQueryAsync(cancellationToken);
    if (rows == 0)
    {
        throw new InvalidOperationException("Reservation not found for update.");
    }
}

var freeTour = new TourRegistrationRequest(
    // ... basic fields
    IsQuote: false,
    IsNoPayment: true,      // No online payment
    QuoteDepositPercent: null,
    QuoteDueDays: null,
    // ...
);

CurrencyCode = "USD"  // or "DOP", "EUR"

public interface ICurrencyConversionService
{
    Task<decimal> ConvertAsync(
        decimal amount, 
        string fromCurrency, 
        string toCurrency,
        CancellationToken cancellationToken = default);
}

@inject ICurrencyConversionService CurrencyService

var priceUSD = 100m;
var priceDOP = await CurrencyService.ConvertAsync(priceUSD, "USD", "DOP");
// Result: ~5,600 DOP (depending on exchange rate)

private static decimal? GetMainPrice(TourMarketplaceItemDto tour)
{
    // Try FromPrice first (if set)
    if (tour.FromPrice.HasValue) return tour.FromPrice.Value;
    
    // Fall back to MaxPrice
    if (tour.MaxPrice.HasValue) return tour.MaxPrice.Value;

    // Last resort: first ticket type price
    var ticketPrice = tour.TicketTypes.FirstOrDefault()?.Price;
    return ticketPrice;
}

private static string GetCurrency(TourMarketplaceItemDto tour)
{
    return tour.TicketTypes.FirstOrDefault()?.CurrencyCode ?? "DOP";
}

private static string FormatCurrency(decimal amount, string currencyCode)
{
    var symbol = currencyCode switch
    {
        "USD" => "$",
        "EUR" => "EUR",
        _ => "RD$"
    };

    return $"{symbol}{amount:N0}";
}