Problem with the PreloadService when loading data

[ud3665]

Hello,
I have a problem with the PreloadService. The spinner is not displayed when the data is loaded for the first time. The code is simple. Does anyone else have the problem or can help me?

Many thanks in advance.

protected override async Task OnInitializedAsync()
{
await LoadDataAsync();
}

private async Task LoadDataAsync()
{
try
{
PreloadService.Show(SpinnerColor.Light, "Loading data...");

    certificateHeaders = await CertificateHeadersService.GetListAsync();
}
catch (Exception ex)
{
    Logger.LogError(ex, "An error has occurred");
}
finally
{
    PreloadService.Hide();
}

}

[ud3665]

Hi gvreddy04,

can you help?

Many thanks in advance.

[gvreddy04]

@ud3665 Can you share your project details like (Version/WebAssembly/Server/Auto)?

[ud3665]

Hi gvreddy04,

the program is developed under .net 9.0. I use the server version.

[gvreddy04]

@ud3665 If possible pls share a GitHub repo, to reproduce the issue with minimal steps.

[ud3665]

Hi gvreddy04,

it is really very simple. I retrieve the data from the table via ODBC and Dapper. There are about 35000 data records. Loading the data is very fast, as the record structure is very flat.

Many thanks in advance.

Here is the service:

namespace CM.Web.GRS.Manager.Data
{
using CM.Web.GRS.Manager.Models;
using Dapper;
using NLog;

public class RawMaterialsService(ConnectionService connectionService)
{
    private static readonly Logger Logger = LogManager.GetCurrentClassLogger();
    private readonly ConnectionService connectionService = connectionService;
            
    public async Task<List<RawMaterial>> GetListAsync()
    {
        try
        {
            await using var connection = connectionService.GetConnection();
            var sql = $"SELECT * FROM ZCM_MM_GRS_RM ORDER BY RAWMATTXT";
            return (await connection.QueryAsync<RawMaterial>(sql)).AsList();
        }
        catch (Exception ex)
        {
            Logger.Error(ex, "An error has occurred.");
            throw;
        }
    } 
}

}

And this is the grid:

@using CM.Web.GRS.Manager.Data
@using CM.Web.GRS.Manager.Models

@Inject RawMaterialsService RawMaterialsService
@Inject ILogger Logger

@page "/rawmaterials"

Rohmaterialien

<Modal @ref="modal" UseStaticBackdrop="true" CloseOnEscape="false" IsVerticallyCentered="true" ModalType="ModalType.Light" ShowCloseButton="false" Size="ModalSize.Regular" HeaderCssClass="p-2" />

Rohmaterialien

Neu

    <Grid @ref="grid" TItem="RawMaterial"
          AllowPaging="true"
          PageSize="10"
          AllowSorting="true"
          Data="rawMaterials"
          Responsive="true"
          Class="table table-bordered"
          HeaderRowCssClass="bg-dark text-white"
          AllowFiltering="true"
          FiltersRowCssClass="bg-light text-dark"
          FiltersTranslationProvider="FiltersTranslationProvider"
          PaginationItemsTextFormat="{0} - {1} von {2} Einträgen"
          EmptyText="Keine Daten vorhanden"
          PageSizeSelectorVisible="true"
          PageSizeSelectorItems="@(new int[] { 10,20,30,40,50 })"
          ItemsPerPageText="Einträge pro Seite">

        <GridColumns>
            <GridColumn TItem="RawMaterial" Filterable="false" Sortable="false" Class="action-col">
                <Button TooltipTitle="Bearbeiten" Color="ButtonColor.Primary" Size="ButtonSize.Small" @onclick="() => EditRawMaterial(context.RAWMATID)"><Icon Name="IconName.Pencil"></Icon></Button>
            </GridColumn>

            <GridColumn TItem="RawMaterial" Filterable="false" Sortable="false" Class="action-col">
                <Button TooltipTitle="Löschen" Color="ButtonColor.Primary" Size="ButtonSize.Small" @onclick="() => DeleteRawMaterial(context.RAWMATID)"><Icon Name="IconName.Trash3"></Icon></Button>
            </GridColumn>

            <GridColumn TItem="RawMaterial" HeaderText="Bezeichnung" PropertyName="RAWMATTXT" SortKeySelector="item => item.RAWMATTXT">
                @context.RAWMATTXT
            </GridColumn>
        </GridColumns>
    </Grid>
</CardBody>

@code {
[Inject] protected PreloadService PreloadService { get; set; } = default!;

private Modal modal = default!;
private Grid<RawMaterial> grid = default!;
private List<RawMaterial>? rawMaterials;

protected override async Task OnInitializedAsync()
{
    await LoadDataAsync();
}

private async Task CreateRawMaterial()
{
    var parameters = new Dictionary<string, object>();
    parameters.Add("DataHasCreated", EventCallback.Factory.Create<bool>(this, AfterCallBack));

    await modal.ShowAsync<Create>(title: "Neues Rohmaterial", parameters: parameters);
}

private async Task EditRawMaterial(int rawmatid)
{
    var parameters = new Dictionary<string, object>();
    parameters.Add("RawMaterialId", rawmatid);
    parameters.Add("DataHasChanged", EventCallback.Factory.Create<bool>(this, AfterCallBack));

    await modal.ShowAsync<RawMaterials.Edit>(title: "Rohmaterial bearbeiten", parameters: parameters);
}

private async Task DeleteRawMaterial(int rawmatid)
{
    var parameters = new Dictionary<string, object>();
    parameters.Add("RawMaterialId", rawmatid);
    parameters.Add("DataHasDeleted", EventCallback.Factory.Create<bool>(this, AfterCallBack));

    await modal.ShowAsync<RawMaterials.Delete>(title: "Recycling Status löschen", parameters: parameters);
}

private async Task AfterCallBack(bool dataHasChanged)
{       
    await modal.HideAsync();

    if (dataHasChanged)
    {
        await LoadDataAsync();
    }
}

private async Task<IEnumerable<FilterOperatorInfo>> FiltersTranslationProvider()
{
    var filtersTranslation = new List<FilterOperatorInfo>();
    filtersTranslation.Add(new("=", "Gleich", FilterOperator.Equals));
    filtersTranslation.Add(new("!=", "Ungleich", FilterOperator.NotEquals));
    filtersTranslation.Add(new("<", "Kleiner", FilterOperator.LessThan));
    filtersTranslation.Add(new("<=", "Kleiner gleich", FilterOperator.LessThanOrEquals));
    filtersTranslation.Add(new(">", "Größer", FilterOperator.GreaterThan));
    filtersTranslation.Add(new(">=", "Größer gleich", FilterOperator.GreaterThanOrEquals));
    filtersTranslation.Add(new("*a*", "Enhält", FilterOperator.Contains));
    filtersTranslation.Add(new("!*a*", "Enhält nicht", FilterOperator.DoesNotContain));
    filtersTranslation.Add(new("a**", "Beginnt mit", FilterOperator.StartsWith));
    filtersTranslation.Add(new("**a", "Endet mit", FilterOperator.EndsWith));
    filtersTranslation.Add(new("x", "Zurücksetzen", FilterOperator.Clear));

    return await Task.FromResult(filtersTranslation);
}
    
private async Task LoadDataAsync()
{
    try
    {
        PreloadService.Show(SpinnerColor.Light, "Loading data...");

        rawMaterials = await RawMaterialsService.GetListAsync();
    }
    catch (Exception ex)
    {
        Logger.LogError(ex, "An error has occurred");
    }
    finally
    {
        PreloadService.Hide();
    }
}

}

[ud3665]

Hi gvreddy04,

can you help?

Many thanks in advance.