@page "/verifying" @using System.ComponentModel.DataAnnotations; @using System.Linq; @using System.Reflection; @attribute [Authorize]

Верификация

@foreach (var articleModel in articleModels) { }
Файл Название Дата издания Авторы Статус
@(counter++) @articleModel.Value.Filename @articleModel.Value.Name @articleModel.Value.PublishDate.ToString("d") @articleModel.Value.Authors @GetDisplayName(articleModel.Value.Status)
@code { private Dictionary articleModels; private int counter = 1; protected override async Task OnInitializedAsync() { MySQLConnector dbCon = MySQLConnector.Instance(); string stringSQL = $"SELECT a.id, filename, article_name, date_publish, authors, ah.action_type " + $"FROM articles a " + $"LEFT JOIN actions_history ah ON a.id = ah.article_id " + $"AND EXISTS (SELECT 1 FROM actions_history ah1 WHERE ah.article_id = ah1.article_id HAVING MAX(ah1.date_add) = ah.date_add) " + $"ORDER BY a.id"; articleModels = await dbCon.SQLSelectArticles(stringSQL); dbCon.Close(); //status = results; } private static string GetDisplayName(Enum enumValue) { return enumValue.GetType() .GetMember(enumValue.ToString()) .First() .GetCustomAttribute() .GetName(); } }