Load list of roles for each user in MVC5 razor

Question

I am trying to display a row of each user and their roles in the ASP.net MVC application.

Users and their roles are stored in ASP.net membership provider table. Using the code below I can display each user and the role they are assigned, but my problem is if the user is in multiple roles then the user gets repeated.

I tried making UserRole as List but I am now stuck as I do not know how to add the roles to a list in the code below. Could you please provide me some direction?

My viewmodel is :

public class UserViewModel
{
   public string UserName { get; set; }
   public List<String> UserRole { get; set; }
}


var roles = ApplicationRoles.RolesList;
       var users = new List<UserViewModel>();
       foreach (var role in roles)
        {
           foreach (var user in Roles.GetUsersInRole(role)) 
            {
               users.Add(new UserViewModel {UserName = user, UserRole = role });
            }
        }

return View(users);

How can I load the roles so I do not repeat username if the user has multiple roles attached to him/her?

I would like to display it in the following format:

=======================

User | Role

John | Admin, Approver

Sam | Approver

=======================

Did you get this to work how you wanted? I used the selected answer, but my roles are blank, and I know I have users with roles. — RoLYroLLs, Dec 02 '15 at 19:50

user1666620 · Answer 1 · 2015-07-06T12:08:07.433

1

Do it the other way round: don't get users with a certain role, get the list of users and loop through that, using the Roles.GetRolesForUser method to get their list of rows.

var userList = Membership.GetAllUsers();

foreach(MembershipUser user in userList)
{
    string[] rolesArray = Roles.GetRolesForUser(user.UserName); 
    users.Add(new UserViewModel {UserName = user.UserName, UserRole = string.Join(",", rolesArray) });
}

edited Jul 06 '15 at 12:08

answered Jul 06 '15 at 12:00

user1666620

4,800
18
27

Thank you @user1666620, I will try your logic, my pc is rebooting now. – snowflakes74 Jul 06 '15 at 12:06
I like this way better, however, the roles are always coming back empty. How can this be fixed? – RoLYroLLs Dec 02 '15 at 16:30
BTW: I had to enable `RoleManager` with `` in the `web.config` – RoLYroLLs Dec 02 '15 at 16:31

Pranay Rana · Accepted Answer · 2015-07-06T14:40:22.407

1

why dont you do like this

  foreach (var user in Roles.GetUsersInRole(role)) 
  {
      users.Add(new UserViewModel {UserName = user, NameAndRole = user + "|"+ String.Join(",", UserRole.ToArray() });
  }

or you can add property in your viewmodel class and use it

Public String NameAndRole
{
  get
   { return name + " | "+ String.Join(",", UserRole.ToArray()) }
}

MSDN : String.Join

edited Jul 06 '15 at 14:40

answered Jul 06 '15 at 12:00

Pranay Rana

175,020
35
237
263

Thank you @Pranay , but what happens if I have a user who have multiple roles? This will still repeat the user and I just want to display it only once. – snowflakes74 Jul 06 '15 at 12:04
@snowflakes74 - for that i just use string.join where there are multiple roles it will join and display – Pranay Rana Jul 06 '15 at 12:05
Fantastic!! I will try it now. – snowflakes74 Jul 06 '15 at 12:08

Load list of roles for each user in MVC5 razor

2 Answers2

Linked