I am in the process of creating an ECommerce website project (to wrap my mind around the Radzen Studio and more advanced Blazor work)
I attempted first to place a method inside of the Designer.cs file that would call on my Products Service and filter the results to only display things which had been marked as visible. However, it deletes anything inside Designer.cs files. So I instead decided to create a Stored Procedure which will return all products where the Visible boolean is true (which will allow the end user admins to mark products as non-visible for things like Seasonal products, and so that the database doesn't break if they delete something (which I will be changing next).
How do I pull the Stored Procedure forward into my Fieldset's datalist object?
Below is my page markup:
@page "/products"
@layout MainLayout
@inherits MermaidCraft.Pages.ProductsComponent
@using Radzen
@using Radzen.Blazor
@using MermaidCraft.Models.MermaidCrafts
<PageTitle>Products</PageTitle>
<RadzenContent Container="main">
<ChildContent>
<RadzenHeading Size="H1" Text="Products">
</RadzenHeading>
<div class="row">
<div class="col-md-12">
<RadzenButton Icon="add_circle_outline" style="margin-bottom: 10px" Text="Add" Click="@Button0Click">
</RadzenButton>
<RadzenTextBox Placeholder="Search ..." style="display: block; margin-bottom: 10px; width: 100%" Name="Textbox0" @oninput="@(async(args) => {search = $"{args.Value}";await grid0.GoToPage(0);await grid0.Reload();})">
</RadzenTextBox>
<RadzenDataGrid @ref="grid0" AllowFiltering="true" AllowPaging="true" AllowSorting="true" Count="@getProductsCount" Data="@getProductsResult" FilterMode="Radzen.FilterMode.Advanced" TItem="MermaidCraft.Models.MermaidCrafts.Product" LoadData="@Grid0LoadData" RowDoubleClick="@Grid0RowDoubleClick">
<Columns>
<RadzenDataGridColumn TItem="MermaidCraft.Models.MermaidCrafts.Product" Property="Id" Title="Id">
</RadzenDataGridColumn>
<RadzenDataGridColumn TItem="MermaidCraft.Models.MermaidCrafts.Product" Property="Title" Title="Title">
</RadzenDataGridColumn>
<RadzenDataGridColumn TItem="MermaidCraft.Models.MermaidCrafts.Product" Property="Description" Title="Description">
</RadzenDataGridColumn>
<RadzenDataGridColumn TItem="MermaidCraft.Models.MermaidCrafts.Product" Property="ImageUrl" Title="Image Url">
</RadzenDataGridColumn>
<RadzenDataGridColumn TItem="MermaidCraft.Models.MermaidCrafts.Product" FilterProperty="Category.Name" GroupProperty="Category.Name" Property="CategoryId" SortProperty="Category.Name" Title="Category">
<Template Context="data">
@(data.Category?.Name)
</Template>
</RadzenDataGridColumn>
<RadzenDataGridColumn TItem="MermaidCraft.Models.MermaidCrafts.Product" Property="Featured" Title="Featured">
</RadzenDataGridColumn>
<RadzenDataGridColumn TItem="MermaidCraft.Models.MermaidCrafts.Product" Property="Visible" Title="Visible">
</RadzenDataGridColumn>
<RadzenDataGridColumn TItem="MermaidCraft.Models.MermaidCrafts.Product" Property="Deleted" Title="Deleted">
</RadzenDataGridColumn>
<RadzenDataGridColumn TItem="MermaidCraft.Models.MermaidCrafts.Product" Filterable="false" Sortable="false" TextAlign="TextAlign.Center" Width="70px">
<Template Context="mermaidCraftModelsMermaidCraftsProduct">
<RadzenButton ButtonStyle="ButtonStyle.Danger" Icon="close" Size="ButtonSize.Small" Click="@((args) =>GridDeleteButtonClick(args, mermaidCraftModelsMermaidCraftsProduct))" @onclick:stopPropagation="true">
</RadzenButton>
</Template>
</RadzenDataGridColumn>
</Columns>
</RadzenDataGrid>
<RadzenFieldset Text="Fieldset">
<ChildContent>
<RadzenDataList @ref="datalist0" Data="@VisibleProductsResult" TItem="MermaidCraft.Models.MermaidCrafts.Product">
</RadzenDataList>
</ChildContent>
</RadzenFieldset>
</div>
</div>
</ChildContent>
</RadzenContent>