robert_rg
robert_rg

Reputation: 297

ASP.NET Core 2.1 displaying users and roles

Trying to display users along with their role in core 2.1, I followed the example stackoverflow . I have no errors but I'm not getting user roles to display. I think it could be my view, for some reason my code returns an email address instead of user role.

ApplicationDbContext

public class ApplicationDbContext : IdentityDbContext<ApplicationUser, 
ApplicationRole, string, IdentityUserClaim<string>,
ApplicationUserRole, IdentityUserLogin<string>,
IdentityRoleClaim<string>, IdentityUserToken<string>>

{
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
       : base(options)
    {
    }

    protected override void OnModelCreating(ModelBuilder builder)
    {
        base.OnModelCreating(builder);

        builder.Entity<ApplicationUserRole>(userRole =>
        {
            userRole.HasKey(ur => new { ur.UserId, ur.RoleId });

            userRole.HasOne(ur => ur.Role)
                .WithMany(r => r.UserRoles)
                .HasForeignKey(ur => ur.RoleId)
                .IsRequired();

            userRole.HasOne(ur => ur.User)
                .WithMany(r => r.UserRoles)
                .HasForeignKey(ur => ur.UserId)
                .IsRequired();
        });
    }

    public DbSet<ApplicationUser> ApplicationUser { get; set; }
}

Startup.cs

services.AddIdentity<ApplicationUser, ApplicationRole>()
      .AddEntityFrameworkStores<ApplicationDbContext>()
      .AddDefaultUI()
      .AddDefaultTokenProviders();

ApplicationUser

public class ApplicationUser : IdentityUser
{
    public ICollection<ApplicationUserRole> UserRoles { get; set; }

    public class ApplicationUserRole : IdentityUserRole<string>
    {
        public virtual ApplicationUser User { get; set; }
        public virtual ApplicationRole Role { get; set; }
    }
    public class ApplicationRole : IdentityRole
    {
        public ICollection<ApplicationUserRole> UserRoles { get; set; }
    }
}

Index method:

public async Task<IActionResult> Index(int? page )
{
   var users = from u in _userManager.Users.Include(u => u.UserRoles).ThenInclude(ur => ur.Role) select u;

   return View(users.ToPagedList(pageNumber, pageSize));
}

View

@Html.DisplayFor(m => item.UserRoles)

Upvotes: 0

Views: 139

Answers (1)

TanvirArjel
TanvirArjel

Reputation: 32069

You put everything inside ApplicatonUser class. First rearrange your model classes as follows:

public class ApplicationUser : IdentityUser
{
    public ICollection<ApplicationUserRole> UserRoles { get; set; }
}

public class ApplicationUserRole : IdentityUserRole<string>
{
    public virtual ApplicationUser User { get; set; }
    public virtual ApplicationRole Role { get; set; }
}

public class ApplicationRole : IdentityRole
{
    public ICollection<ApplicationUserRole> UserRoles { get; set; }
}

Now UserRoles is a collection, you cannot display this with @Html.DisplayFor(m => item.UserRoles), rather you have to iterate over this collection as follows:

@model List<ApplicationUser>
@{
    foreach (ApplicationUser applicationUser in Model)
    {
        <div>UserName : @applicationUser.UserName</div>
        <br/>
        <h4>User's Role</h4>
        <hr/>
        foreach (ApplicationUserRole applicationUserRole in applicationUser.UserRoles)
        {
            <div>RoleName: @applicationUserRole.Role.Name</div>
        }
    }
}

Upvotes: 1

Related Questions