Server-Side Row Model

private async Task<GridDataResponse<Product>> HandleSimulatedServerDataRequest(
    GridDataRequest<Product> request)
{
    // Simulate network delay
    await Task.Delay(300);
    
    // Start with full dataset (simulate database query)
    var query = allProducts.AsQueryable();
    
    // Apply server-side filtering
    foreach (var filter in request.FilterDescriptors)
    {
        query = ApplyFilter(query, filter);
    }
    
    // Get total count after filtering
    var totalCount = query.Count();
    
    // Apply server-side sorting
    if (request.SortDescriptors.Any())
    {
        var sort = request.SortDescriptors.First();
        query = ApplySorting(query, sort);
    }
    
    // Apply pagination
    var pagedData = query
        .Skip(request.StartIndex)
        .Take(request.Count)
        .ToList();
    
    return new GridDataResponse<Product>
    {
        Items = pagedData,
        TotalCount = totalCount
    };
}

private async Task<GridDataResponse<Movie>> HandleMovieDataRequest(
    GridDataRequest<Movie> request)
{
    isMovieLoading = true;
    StateHasChanged();
    
    try
    {
        // Build TMDb API URL with parameters
        var page = (request.StartIndex / request.Count) + 1;
        var sortBy = MapSortField(request.SortDescriptors.FirstOrDefault());
        
        var url = $"https://api.themoviedb.org/3/discover/movie?page={page}";
        if (!string.IsNullOrEmpty(sortBy)) url += $"&sort_by={sortBy}";
        if (appliedFilterYear.HasValue) url += $"&primary_release_year={appliedFilterYear}";
        if (appliedFilterRating.HasValue) url += $"&vote_average.gte={appliedFilterRating}";
        if (!string.IsNullOrEmpty(appliedFilterGenre)) url += $"&with_genres={appliedFilterGenre}";
        
        // Call TMDb API
        var response = await CallTmdbApiAsync<TmdbDiscoverResponse>(url);
        
        // Map to Grid response
        return new GridDataResponse<Movie>
        {
            Items = response.Results.Select(MapToMovie),
            TotalCount = response.TotalResults
        };
    }
    finally
    {
        isMovieLoading = false;
        StateHasChanged();
    }
}