HyperCube/Pages/Verifying.razor

@page "/verifying"

@using System.ComponentModel.DataAnnotations;
@using System.Linq;
@using System.Reflection;

@attribute [Authorize]

<div class="tabs__content">
    <div class="tabs__controls">
        <a href="DocEdit" class="tabs__btn">Загрузка материалов</a>
        <a href="Verifying" class="tabs__btn tabs__btn_active">Верификация</a>
        <a class="tabs__btn">Библиотеки</a>
        <a class="tabs__btn">Заказы</a>
    </div>
    <div class="upload">
        <h2 class="upload__title">Аккаунт - Квалификация</h2>
    </div>
    <table class="table">
        <thead>
            <tr>
                <th>№</th>
                @*<th>Файл</th>*@
                <th>Название</th>
                <th>Дата издания</th>
                @*<th>Авторы</th>*@
                <th>Инициатор</th>
                <th>Верификатор</th>
                <th>Статус</th>
            </tr>
        </thead>
        <tbody>
            @foreach (var articleModel in articleModels)
            {
                <tr>
                    <td>@(counter++)</td>
                    @*<td>@articleModel.Value.Filename</td>*@
                    <td><a href="@($"/docedit/{articleModel.Key}")">@articleModel.Value.Name</a></td>
                    <td>@articleModel.Value.PublishDate.ToString("d")</td>
                    @*<td>@articleModel.Value.Authors</td>*@
                    <td><center> - </center></td>
                    <td><center> - </center></td>
                    <td>@GetDisplayName(articleModel.Value.Status)</td>
                </tr>
            }
        </tbody>
    </table>
</div>


@code {
    private Dictionary<int, Models.ArticleModel> 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<DisplayAttribute>()
                        .GetName();
    }
}