Get Users where are not in role admin and simpleuser

Question

I am using .Net Core 2.1 and I want to exclude the users that have the role "Admin" and "SimpleUser" I had followed this example Link

How i can add the where part? So far i have tried this with no luck:

 ViewData["ApplicationUserId"] = new SelectList( _context.Users.Include(u=>u.UserRoles).ThenInclude(u=>u.Role).Where(o=>o.UserRoles!="Admin"), "Id", "Company", products.ApplicationUserId);

ApplicationUserRole Class:

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

If you see the image on my question the error starts in the first part on my where — marios, Nov 22 '18 at 09:12
Since the `UserRoles` is of type `ICollection` you probably need something like `.Where(o => !o.UserRoles.Any(r => r.Role == "Admin"))` — Fabjan, Nov 22 '18 at 09:16

score 0 · Accepted Answer · answered Nov 22 '18 at 09:19

0

The message in the attached image suggests that u.UserRoles is not a string, try something like u.UserRoles.All(r=>r.RoleId!="Admin" && r.RoleId!="SimpleUser") in your Where

answered Nov 22 '18 at 09:19

Muaz Othman

427
4
13

Your solution is working but with this . r.Role.Name != "Admin" – marios Nov 22 '18 at 09:54

score 0 · Answer 2 · answered Nov 22 '18 at 09:32

You will need to check that none of the roles are of "Admin" or "SimpleUser"

ViewData["ApplicationUserId"] = new SelectList( _context.Users.Include(u=>u.UserRoles).ThenInclude(u=>u.Role).Where(o => !o.UserRoles.Any(r => (r.Role == "Admin") || (r.Role == "SimpleUser"))), "Id", "Company", products.ApplicationUserId);

Get Users where are not in role admin and simpleuser

2 Answers2