问题[asp.net-core-mvc]

您好，我想设置我的应用程序，以便在 PareSubgroup 表中创建新字段时，在我的选择字段中的视图中，创建时，它返回的不是 Schedule 表中的 id，而是主题表中的学科名称。

 public IActionResult Create()
    {
        ViewData["Pare_Id"] = new SelectList(_context.Schedules, "Id", "Id");
        ViewData["Subgroup_Id"] = new SelectList(_context.Subgroups, "Id", "Id");
        return View();
    }


    [HttpPost]
    [ValidateAntiForgeryToken]
    public async Task<IActionResult> Create([Bind("Pare_Id,Subgroup_Id")] PareSubgroup pareSubgroup)
    {
        if (ModelState.IsValid)
        {
            _context.Add(pareSubgroup);
            await _context.SaveChangesAsync();
            return RedirectToAction(nameof(Index));
        }
        ViewData["Pare_Id"] = new SelectList(_context.Schedules, "Id", "Id", pareSubgroup.Pare_Id);
        ViewData["Subgroup_Id"] = new SelectList(_context.Subgroups, "Id", "Id", pareSubgroup.Subgroup_Id);
        return View(pareSubgroup);
    }

@{ ViewData["Title"] = "Create"; }

<h1>Create</h1>

<h4>PareSubgroup</h4>
<hr />
<div class="row">
  <div class="col-md-4">
    <form asp-action="Create">
      <div asp-validation-summary="ModelOnly" class="text-danger"></div>
      <div class="form-group">
        <label asp-for="Pare_Id" class="control-label"></label>
        <select asp-for="Pare_Id" class="form-control" asp-items="ViewBag.Pare_Id"></select>
      </div>
      <div class="form-group">
        <label asp-for="Subgroup_Id" class="control-label"></label>
        <select asp-for="Subgroup_Id" class="form-control" asp-items="ViewBag.Subgroup_Id"></select>
      </div>
      <div class="form-group">
        <input type="submit" value="Create" class="btn btn-primary" />
      </div>
    </form>
  </div>
</div>

<div>
  <a asp-action="Index">Back to List</a>
</div>

@section Scripts { @{await Html.RenderPartialAsync("_ValidationScriptsPartial");} }

有一个数据上下文：

public class OurDbContext : DbContext, IOurDbContext, IDataProtectionKeyContext
{
    public DbSet<Employee> Employees { get; set; }
    
    public DbSet<Role> Roles { get; set; }
    
    public DbSet<DataProtectionKey> DataProtectionKeys { get; set; } = null!;
}

有一种方法可以实现向数据库发送数据：

[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> CreateNewClient(Employee client, string TypeOfClient)
{
    var secstring = _protector.Protect(client.Password);

    Employee temp = new Employee
    {
        Name = client.Name,
        Password = secstring,
        RoleId = 1
    };
    await _mediatr.Send(new NewEmployee.NewEmployeeCommand(temp));
    return Redirect("~/");
}

没有任何东西进入数据库。

如果我们从上下文类中删除实现IDataProtectionKeyContext

public DbSet<DataProtectionKey> DataProtectionKeys { get; set; } = null!;

并缩短线路

builder.Services.AddDataProtection().PersistKeysToDbContext<OurDbContext>();

前

builder.Services.AddDataProtection();

然后数据以加密密码进入数据库。但在这种情况下，5 分钟后，尝试读取此密码将由于密钥过期而导致异常。

微软的帮助没有说明这一点：

https://docs.microsoft.com/en-us/aspnet/core/security/data-protection/configuration/overview?view=aspnetcore-6.0#persistkeystodbcontext

ASP.Net 6.0 上有一个站点。在 Configure startyp.cs 中创建了一个初始化类

public static class SiteInit
{
    private static void AddTasks (IServiceProvider serviceProvider, [NotNull] IConfiguration configuration)
        {
            //Получаю DependencyIjector
            serviceProvider = serviceProvider.CreateScope().ServiceProvider;
            //Провожу инъекцию аккаунта
            AccountManager account = serviceProvider.GetRequiredService<AccountManager>();

            byte.TryParse(configuration["accountsettings:newbieexceededhours"], out byte hourstodelete);

        /* To-Do после теста отключить на Dayly */
        RecurringJob.AddOrUpdate(() => NewbieDeleterTask.Execute(account, hourstodelete), Cron.Hourly);
    }
    public static void InitSite (IServiceProvider service,[NotNull] IConfiguration configuration)
    {
        AddTasks(service, configuration);
    }
}

它的任务是初始化类中给出的任务：

/// <summary>
/// Задача удаления новичков после n часов
/// </summary>
public static class NewbieDeleterTask
{
    private static async Task ExecuteAsync ([NotNull] AccountManager account, byte hours = 36)
    {
        //Получение текущей даты
        DateTime dateTime = DateTime.UtcNow;

        //Получение списока пользователей с неподтверждённым email
        IEnumerable<MyUser> notConfirmedUsers = account.GetAllUsers().Where(usr => !usr.EmailConfirmed);

        //Список "просроченных" пользователей
        // ReSharper disable once CollectionNeverQueried.Local
        List<MyUser> overdueUsers = new();

        //Получаем список просрочек
        foreach (MyUser user in notConfirmedUsers)
        {
            if (await account.IsUserInRoleAsync(user, "newbie") && user.DateOfRegister.AddHours(hours).CompareTo(dateTime) <= 0)
                overdueUsers.Add(user);
        }

        //Удаляем пользователей
        foreach (MyUser user in overdueUsers)
            await account.DeleteUserAsync(user);
    }

    public static void Execute([NotNull] AccountManager account, byte hours = 36) =>
        ExecuteAsync(account, hours).GetAwaiter().GetResult();
}

AccountManager 本身是 usermanager 和 rolemanager 类的包装器。

一般来说，Hangfire 是这样发誓的：

warn: Hangfire.AutomaticRetryAttribute[0]
      Failed to process the job '10004': an exception occurred. Retry attempt 1 of 10 will be performed in 00:00:21.
      System.NullReferenceException: Object reference not set to an instance of an object.
         at rnrmm.Platform.AccountManager.GetAllUsers() in E:\WebSites\rnrmm_ru\rnrmm_ru\Platform\AccountManager.cs:line 69
         at rnrmm.Tasks.NewbieDeleterTask.ExecuteAsync(AccountManager account, Byte hours) in E:\WebSites\rnrmm_ru\rnrmm_ru\Tasks\NewbieDeleterTask.cs:line 25
         at rnrmm.Tasks.NewbieDeleterTask.Execute(AccountManager account, Byte hours) in E:\WebSites\rnrmm_ru\rnrmm_ru\Tasks\NewbieDeleterTask.cs:line 44
warn: Hangfire.AutomaticRetryAttribute[0]
      Failed to process the job '10004': an exception occurred. Retry attempt 2 of 10 will be performed in 00:00:24.
      System.NullReferenceException: Object reference not set to an instance of an object.
         at rnrmm.Platform.AccountManager.GetAllUsers() in E:\WebSites\rnrmm_ru\rnrmm_ru\Platform\AccountManager.cs:line 69
         at rnrmm.Tasks.NewbieDeleterTask.ExecuteAsync(AccountManager account, Byte hours) in E:\WebSites\rnrmm_ru\rnrmm_ru\Tasks\NewbieDeleterTask.cs:line 25
         at rnrmm.Tasks.NewbieDeleterTask.Execute(AccountManager account, Byte hours) in E:\WebSites\rnrmm_ru\rnrmm_ru\Tasks\NewbieDeleterTask.cs:line 44

GetAllUsers函数本身如下所示：

public List<MyUser> GetAllUsers ()
    {
        IQueryable<MyUser> usersQuery = usermanager.Users;
        return usersQuery.ToList();
    }

怎么了？为什么她没有获得用户（网站上有 3 个用户）！

在哪里被认为是正确的使用数据库？在控制器中还是在单独的文件中？

if (!Yii::$app->user->isGuest)您只需要( Yii2)之类的东西asp.net core。我需要知道用户是否登录。

试过System.Security.Claims.User.Identity.IsAuthenticated了，但它一直在false ，所以错误是：HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;