This question is locked. New answers and comments are not allowed.
Hello:
I have a problem I am trying to solve, been pulling my hair out for quite some time. My issue is that I am trying to create a distinct list of users, based on their security permissions, as they relate to information provided on a web form.
A user enters some information into a form (basically a list of departments).
I then need to return a list of users that have access to each of the departments.
My code looks like this so far:
This returns me a list users that have access to at least 1 of the departments in details, but I need to return a list of users that has permission to all departments in details.
Can this be done easily?
Thanks!
I have a problem I am trying to solve, been pulling my hair out for quite some time. My issue is that I am trying to create a distinct list of users, based on their security permissions, as they relate to information provided on a web form.
A user enters some information into a form (basically a list of departments).
I then need to return a list of users that have access to each of the departments.
My code looks like this so far:
dim details = (Form p in db.Details select p.deptID Distinct)
dim singers = (from p in db.Users join ds in db.deptSecurities on p.UserID queals ds.UserID where details.contains(ds.deptID), select p.UserID Distinct)
This returns me a list users that have access to at least 1 of the departments in details, but I need to return a list of users that has permission to all departments in details.
Can this be done easily?
Thanks!