Filter joined string array

Michael Seery

6y1.1kLINQ

I have a linq query that returns all users with their identity roles.

I am able to filter the results by using where claused however, I am unable to figure out how to filter based on a role name.

Below is my linq query.

var userList = (from user in _context.Users orderby user.UserName

select new UserForDetailDto

{

Id = user.Id,

UserName = user.UserName,

Email = user.Email,

Roles = (from userRole in user.UserRoles

join role in _context.Roles

on userRole.RoleId

equals role.Id

select role.Name).ToArray()

}).AsQueryable();

The below is sample of what is returned.

[

{

"id": 6,

"userName": "Adam",

"email": "[email protected]",

"roles": [

"Supplier",

"Assistant Buyer"

]

{

"id": 1,

"userName": "Admin",

"email": "[email protected]",

"roles": [

"Administrator"

]

}

]

I am able to filter the userList using a where clause such as the one below.

userList = userList.Where(u => u.UserName.ToLower().Contains(userParams.UserName.ToLower()));

I would like to be able to add a where clause to the role.Name string array.

Where roles contains 'Supplier' for example.

Any help would be appreciated.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sagar Malde6y ago
Hi Michael,

you can use
var User = userList.Where(x=> x.Roles.Where(z=> z == "Supplier").Count() > 0).ToList();
0
Michael Seery6y ago
Using the && condition would only return the filtered role and not all roles associated with the user that has the filtered role.

Solution

What I did was use the GetUsersInRolesAsync to get a list of the users with the selected role, then filtered the original list of users with their roles by this list using the following where clause.
userList = userList.Where(u => filterNames.Contains(u.UserName.ToLower()));

if (!string.IsNullOrEmpty(userParams.Roles))
   {
      var filteredUserList = await _userManager.GetUsersInRoleAsync(userParams.Roles);
      List<string> filterNames = new List<string>();
      foreach (var filtUser in filteredUserList)
         {
            filterNames.Add(filtUser.UserName.ToLower());
         }

      userList = userList.Where(u => filterNames.Contains(u.UserName.ToLower()));
   }


var userList = (from user in _context.Users
               orderby user.UserName
               select new UserForDetailDto
               {
                  Id = user.Id,
                  UserName = user.UserName,
                  LockedOut = user.LockedOut,
                  SupplierId = user.SupplierId,
                  WarehouseId = user.WarehouseId,
                  Email = user.Email,
                  Status = user.Status,
                  Roles = (from userRole in user.UserRoles
                           join role in _context.Roles
                           on userRole.RoleId
                           equals role.Id
                           select role.Name).ToArray()
                  }).AsQueryable();
0
Jignesh Kumar6y ago
Hi,

You can try below code, you can use && condition in your where clause.
0
Michael Seery6y ago
Hi Ravi,

I am using asp.net core identity.
I have a linq query that returns a list of all users with their associated role names in a string array. Each user may have more than one role.
I am currently able to filter the returned list by by all fields accept for the associated roles.

If you look at the sample data below. I have a user with multiple roles and one that doesn't have any role associated with them.
[
   {
      "id": 6,
      "userName": "Adam",
      "email": "[email protected]",
      "roles": [
            "Supplier",
            "Assistant Buyer"
      ]
   },
{
      "id": 1,
      "userName": "Admin",
      "email": "[email protected]",
      "roles": [
            "Administrator"
      ]
   },
   {
      "id": 5,
      "userName": "Jane",
      "email": "[email protected]",
      "roles": []
   }
]

If I filter using the role as example 'Supplier' I would like to see the following returned.
[
   {
      "id": 6,
      "userName": "Adam",
      "email": "[email protected]",
      "roles": [
            "Supplier",
            "Assistant Buyer"
      ]
   }
]
2 points to note.
1. Both roles are listed for the user with a role of supplier.
2. The user with no roles associated with them is not returned.

Thanks again for your help.
0
Ravi Patel6y ago
Hi Michael Seery,

can you please tell me what is your requirement?
0
Michael Seery6y ago
Thanks so much for the quick reply.
It appears to be working however it also returns user that have not been assigned a role.
{
   "id": 5,
   "userName": "jane",
   "email": "[email protected]",
   "roles": [
   ]
}

Also it doesn't return all of the roles associated with a user if they have more than the selected role.
For example user Adam has 2 roles.
{
   "id": 6,
    "userName": "Adam",
      "email": "[email protected]",
      "roles": [
            "Supplier",
            "Assistant Buyer"
      ]
   }

When I filter for supplier I get back the roles minus the Assistant Buyer role. (Please take no notice of the role names, these are just samples)

{
   "id": 6,
   "userName": "Adam",
   "email": "[email protected]",
   "roles": [
         "Supplier"
   ]
}

0
Ravi Patel6y ago
Hi,

try this

var userList = (from user in _context.Users orderby user.UserName
select new UserForDetailDto
{
Id = user.Id,
UserName = user.UserName,
Email = user.Email,
Roles = (from userRole in user.UserRoles
join role in _context.Roles
on userRole.RoleId
equals role.Id
where role.Name== "Admin"
select role.Name).ToArray()
}).AsQueryable();

0