So it's not possible to have an int in a database and map this to an enum to show user friendly text and be filterable with the default datagrid?
Here it seems to be working fine.
All of this code is in one page though.
I have a Blazor 8 with Auto Interactive and PWA.
There is a Server project and Client project.
I'm so confused.
If I change my field type back to int in the model, it works as expected.
[Table("Accounts", Schema = "dbo")]
public partial class Account
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int Id { get; set; }
[Required]
public string AccountName { get; set; }
[Required]
[EnumDataType(typeof(AccountType))]
public AccountType AccountType { get; set; }
// I changed this from int to AccountType
[Required]
public decimal AccountBalance { get; set; }
[Required]
public int AccountNumber { get; set; }
public ICollection<TransactionEntry> TransactionEntries { get; set; }
}
public enum AccountType
{
Asset = 1000,
Liability = 2000,
Equity = 3000,
Revenue = 4000,
Expense = 6000,
COGS = 5000
}
With the property type set to AccountType, the items won't load in the grid.
Accounts.razor
@page "/accounts"
@inject IJSRuntime JSRuntime
@inject NavigationManager NavigationManager
@inject DialogService DialogService
@inject ContextMenuService ContextMenuService
@inject TooltipService TooltipService
@inject NotificationService NotificationService
@inject BlazorPortalDbService BlazorPortalDbService
Accounts
<RadzenTextBox Placeholder="Search ..." style="display: block; width: 100%" @oninput="@Search" aria-label="Search by all string columns" />
<RadzenDataGrid @ref="grid0" ColumnWidth="200px" AllowFiltering="true" FilterMode="FilterMode.Advanced" AllowPaging="true" AllowSorting="true" ShowPagingSummary="true" PageSizeOptions=@(new int{5, 10, 20, 30})
Data="@accounts" LoadData="@Grid0LoadData" Count="@count" TItem="BlazorPortal.Server.Models.BlazorPortalDb.Account" RowDoubleClick="@EditRow">
<RadzenButton ButtonStyle="ButtonStyle.Danger" Icon="delete" Size="ButtonSize.Medium"
Shade="Shade.Lighter" Variant="Variant.Flat"
Click=@(args => GridDeleteButtonClick(args, account)) @onclick:stopPropagation="true" />
</Template>
</RadzenDataGridColumn>
</Columns>
</RadzenDataGrid>
</RadzenColumn>
@code {
protected IEnumerable<BlazorPortal.Server.Models.BlazorPortalDb.Account> accounts;
protected RadzenDataGrid<BlazorPortal.Server.Models.BlazorPortalDb.Account> grid0;
protected int count;
protected string search = "";
protected async Task Search(ChangeEventArgs args)
{
search = $"{args.Value}";
await grid0.GoToPage(0);
await grid0.Reload();
}
protected async Task Grid0LoadData(LoadDataArgs args)
{
try
{
var result = await BlazorPortalDbService.GetAccounts(filter: $@"(contains(AccountName,""{search}"")) and {(string.IsNullOrEmpty(args.Filter)? "true" : args.Filter)}", orderby: $"{args.OrderBy}", top: args.Top, skip: args.Skip, count:args.Top != null && args.Skip != null);
accounts = result.Value.AsODataEnumerable();
count = result.Count;
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
NotificationService.Notify(new NotificationMessage(){ Severity = NotificationSeverity.Error, Summary = $"Error", Detail = $"Unable to load Accounts" });
}
}
protected async Task AddButtonClick(MouseEventArgs args)
{
await DialogService.OpenAsync<AddAccount>("Add Account", null);
await grid0.Reload();
}
protected async Task EditRow(DataGridRowMouseEventArgs<BlazorPortal.Server.Models.BlazorPortalDb.Account> args)
{
await DialogService.OpenAsync<EditAccount>("Edit Account", new Dictionary<string, object> { {"Id", args.Data.Id} });
await grid0.Reload();
}
protected async Task GridDeleteButtonClick(MouseEventArgs args, BlazorPortal.Server.Models.BlazorPortalDb.Account account)
{
try
{
if (await DialogService.Confirm("Are you sure you want to delete this record?") == true)
{
var deleteResult = await BlazorPortalDbService.DeleteAccount(id:account.Id);
if (deleteResult != null)
{
await grid0.Reload();
}
}
}
catch (Exception ex)
{
NotificationService.Notify(new NotificationMessage
{
Severity = NotificationSeverity.Error,
Summary = $"Error",
Detail = $"Unable to delete Account"
});
}
}
protected async Task ExportClick(RadzenSplitButtonItem args)
{
if (args?.Value == "csv")
{
await BlazorPortalDbService.ExportAccountsToCSV(new Query
{
Filter = $@"{(string.IsNullOrEmpty(grid0.Query.Filter)? "true" : grid0.Query.Filter)}",
OrderBy = $"{grid0.Query.OrderBy}",
Expand = "",
Select = string.Join(",", grid0.ColumnsCollection.Where(c => c.GetVisible() && !string.IsNullOrEmpty(c.Property)).Select(c => c.Property.Contains(".") ? c.Property + " as " + c.Property.Replace(".", "") : c.Property))
}, "Accounts");
}
if (args == null || args.Value == "xlsx")
{
await BlazorPortalDbService.ExportAccountsToExcel(new Query
{
Filter = $@"{(string.IsNullOrEmpty(grid0.Query.Filter)? "true" : grid0.Query.Filter)}",
OrderBy = $"{grid0.Query.OrderBy}",
Expand = "",
Select = string.Join(",", grid0.ColumnsCollection.Where(c => c.GetVisible() && !string.IsNullOrEmpty(c.Property)).Select(c => c.Property.Contains(".") ? c.Property + " as " + c.Property.Replace(".", "") : c.Property))
}, "Accounts");
}
}
}
