ASP.NET MVC 5 Get users from specific Role

Question

How is it possible to show a List from all users in a specific role.

I attach a IdentityRole model to my View with the 'Admin' role assigned to it. So far I only can get the UserId.

@model Microsoft.AspNet.Identity.EntityFramework.IdentityRole

@Html.DisplayNameFor(model => model.Name) // Shows 'Admin'

@foreach (var item in Model.Users)
{
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.UserId)
        </td>
    </tr>
}

A possible solution would be to create a List of the users in the controller and attach this to the View. The problem would be that I also need data from the Role itself.

http://stackoverflow.com/questions/27347802/how-to-list-users-with-role-names-in-asp-net-mvc-5 — Robert Harvey, Apr 27 '15 at 08:59
The method in the example has the attribute from a user (mine a role id). So I assume the example is about showing all the roles from a user. I need to show all users from a specific role and also data (name, description,..) from the role itself. — Sam, Apr 27 '15 at 09:11

Mohsen Esmailpour · Answer 1 · 2015-04-27T10:06:26.877

8

If you are using ASP.NET Identity 2:

public ActionResult UserList(string roleName)
{
    var context = new ApplicationDbContext();
    var users = from u in context.Users
        where u.Roles.Any(r => r.Role.Name == roleName)
        select u;

    ViewBag.RoleName = roleName;
    return View(users);
}

and in View:

@model Microsoft.AspNet.Identity.EntityFramework.IdentityUser // or ApplicationUser

@Html.DisplayNameFor(model => ViewBag.RoleName) // Shows 'Admin'

@foreach (var item in Model.Users)
{
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.Id)
        </td>
       <td>
            @Html.DisplayFor(modelItem => item.UserName)
        </td>
    </tr>
}

edited Apr 27 '15 at 10:06

answered Apr 27 '15 at 10:00

Mohsen Esmailpour

11,224
3
45
66

Nice solution, but is there a reason you are not using the RoleManager/UserManager? – Sam Jan 11 '16 at 14:02
Is it just me or does this not work? User Roles count is always zero, even when I Include it using entity framework. – Ian Apr 18 '16 at 13:42

score 2 · Answer 2 · answered Apr 27 '15 at 09:56

I found a working solution using ViewModels:

ViewModel:

public class RoleUserVM
{
    public IdentityRole Role { get; set; }
    public ICollection<ApplicationUser> Users { get; set; }
}

Controller:

public async Task<ActionResult> Details(string id)
{
    if (id == null)
    {
        return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
    }

    var role = await RoleManager.FindByIdAsync(id);

    var users = new List<ApplicationUser>();
    foreach (var user in UserManager.Users.ToList())
    {
        if (await UserManager.IsInRoleAsync(user.Id, role.Name))
        {
            users.Add(user);
        }
    }

    RoleUserVM vm = new RoleUserVM();
    vm.Users = users;
    vm.Role = role;

    return View(vm);
}

View:

@model AspnetIdentitySample.Models.RoleUserVM

@Html.DisplayFor(model => model.Role.Name)

<table class="table table-striped">
    @foreach (var item in Model.Users)
    {
        <tr>
            <td>
                @Html.DisplayFor(modelItem => item.UserName)
            </td>
        </tr>
    }
</table>

ASP.NET MVC 5 Get users from specific Role

2 Answers2

Linked