Managing Reservations

<div class="bk-filters">
    <div class="bk-search">
        <input class="bk-search__input" 
               placeholder="Buscar por título o ubicación..." 
               @bind="searchText" />
    </div>
    
    <div class="bk-chips">
        <button type="button"
                class="bk-chip @(onlyWithReservations ? "active" : "")"
                @onclick="ToggleOnlyWithReservations">
            Solo con reservas
        </button>
        
        <button type="button"
                class="bk-chip @(statusFilter != StatusFilter.All ? "active" : "")"
                @onclick="ToggleStatusFilter">
            @GetStatusFilterLabel()
        </button>
    </div>
</div>

public async Task<IReadOnlyList<TourMarketplaceItemDto>> GetOwnerToursAsync(
    int ownerUserId,
    int topRows,
    CancellationToken cancellationToken = default)
{
    var sql = $@"
    SELECT TOP (@TopRows)
        t.TourId,
        t.Title,
        t.LocationLabel,
        t.ImageList,
        t.Status,
        t.CreatedAt
    FROM {tourTable} t
    WHERE t.OwnerUserId = @OwnerUserId
    ORDER BY t.CreatedAt DESC";
    
    // Load tours with ticket types and ratings
}

public async Task<TourReservationStatsDto> GetTourReservationStatsAsync(
    int tourId,
    int recentDays = 30,
    CancellationToken cancellationToken = default)
{
    var sql = $@"
    SELECT 
        CAST(r.CreatedAt AS date) AS DayDate,
        COUNT(*) AS ReservationCount,
        COALESCE(SUM(r.AmountPaid), 0) AS TotalAmount,
        SUM(CASE WHEN r.PaymentStatus = 1 THEN 1 ELSE 0 END) AS PaidCount,
        SUM(CASE WHEN r.PaymentStatus <> 1 THEN 1 ELSE 0 END) AS PendingCount
    FROM {reservationTable} r
    WHERE r.TourId = @TourId
    GROUP BY CAST(r.CreatedAt AS date)
    ORDER BY DayDate ASC;";
}

public sealed record TourReservationStatsDto(
    int TourId,
    int TotalReservations,
    decimal TotalAmount,
    IReadOnlyList<TourReservationDayStat> Daily);

public sealed record TourReservationDayStat(
    DateTime Date,
    int Count,
    decimal Amount,
    int PaidCount,
    int PendingCount,
    decimal PaidAmount,
    decimal PendingAmount);

public async Task DeleteTourAsync(
    int tourId,
    CancellationToken cancellationToken = default)
{
    // Check for existing reservations
    var countSql = $"SELECT COUNT(1) FROM {reservationTable} WHERE TourId = @TourId;";
    var count = await ExecuteScalarAsync<int>(countSql, new { TourId = tourId });
    
    if (count > 0)
    {
        throw new InvalidOperationException(
            "Este servicio tiene reservas/ventas y no puede eliminarse."
        );
    }
    
    // Delete tour and related data
    await ExecuteAsync("sp_Tour_DeleteCascade", new { TourId = tourId });
}