Let’s add a “Roles” tab on the Users page to allow management of roles. When a role is selected, users corresponding to the role will be displayed below. In order to create this “implied” master-detail relationship, a “UsersInRole” view must be created that will use a custom command to extract the RoleID.
Creating “Users In Role” View
Right-click on Users / Views / grid1 view node, and press Copy.
![Copying 'grid1' view of Users controller. Copying 'grid1' view of Users controller.](/blog/2012/11/advanced-user-manager-for-custom_9266/image02.png)
Right-click on Users / Views node, and press Paste. A duplicate of the view will be created.
![A duplicate of 'grid1' called 'v100' has been created. A duplicate of 'grid1' called 'v100' has been created.](/blog/2012/11/advanced-user-manager-for-custom_9266/image06.png)
Double-click on Users / Views / v100 node. Next to the Command property, select the New Command icon.
![Creating a new command. Creating a new command.](/blog/2012/11/advanced-user-manager-for-custom_9266/image08.png)
Assign these values.
Property | Value |
Id | command2 |
Text | select
"Users"."UserID" "UserID"
,"Users"."UserName" "UserName"
,"Users"."Password" "Password"
,"Users"."Email" "Email"
,"Users"."Comment" "Comment"
,"Users"."PasswordQuestion" "PasswordQuestion"
,"Users"."PasswordAnswer" "PasswordAnswer"
,"Users"."IsApproved" "IsApproved"
,"Users"."LastActivityDate" "LastActivityDate"
,"Users"."LastLoginDate" "LastLoginDate"
,"Users"."LastPasswordChangedDate" "LastPasswordChangedDate"
,"Users"."CreationDate" "CreationDate"
,"Users"."IsLockedOut" "IsLockedOut"
,"Users"."LastLockedOutDate" "LastLockedOutDate"
,"Users"."FailedPasswordAttemptCount" "FailedPasswordAttemptCount"
,"Users"."FailedPasswordAttemptWindowStart"
"FailedPasswordAttemptWindowStart"
,"Users"."FailedPasswordAnswerAttemptCount"
"FailedPasswordAnswerAttemptCount"
,"Users"."FailedPasswordAnswerAttemptWindowStart"
"FailedPasswordAnswerAttemptWindowStart"
,UserRoles.RoleID RoleID
from "dbo"."Users" "Users"
left join UserRoles on Users.UserID = UserRoles.UserID
|
Type |
Text |
Event |
Select |
Press OK to create the command and insert it into the property. Also make the following changes:
Property |
Value |
Label |
Users In Role |
Show In View Selector |
false |
Press OK to save. In the Project Explorer, right-click on Users / Views / v100 and press Rename.
![Renaming the view 'v100' using the context menu option. Renaming the view 'v100' using the context menu option.](/blog/2012/11/advanced-user-manager-for-custom_9266/image10.png)
Change the name to “UsersInRole” and press Enter on your keyboard to save.
![View ID has been changed to 'UsersInRole'. View ID has been changed to 'UsersInRole'.](/blog/2012/11/advanced-user-manager-for-custom_9266/image12.png)
Adding “RoleID” Field
Right-click on Users / Fields node, and press New Field.
![New Field context menu option for Users controller. New Field context menu option for Users controller.](/blog/2012/11/advanced-user-manager-for-custom_9266/image14.png)
Assign the following properties:
Property |
Value |
Name |
RoleID |
Type |
Int32 |
The field is hidden from users. |
true |
Label |
Role ID |
Allow Query-by-Example |
true |
Press OK to save the field. Drop Users / Fields / RoleID field node onto Users / Views / UsersInRole to create a data field and append it to the view.
!['RoleID' data field created in view 'UsersInRole'. 'RoleID' data field created in view 'UsersInRole'.](/blog/2012/11/advanced-user-manager-for-custom_9266/image18.png)
Adding Roles Tab to Users Page
Switch to the Controllers tab in the Project Explorer. While holding Ctrl key, click on Roles and Users controller nodes in that order. Right-click and press Copy.
![Copying the Roles and Users controllers. Copying the Roles and Users controllers.](/blog/2012/11/advanced-user-manager-for-custom_9266/image20.png)
Switch back to the Pages tab. Right-click on Users / container1 node, and press Paste. The controllers will be instantiated as views in the container.
![The copied controllers have been instantiated as views in the container. The copied controllers have been instantiated as views in the container.](/blog/2012/11/advanced-user-manager-for-custom_9266/image24.png)
Double-click on Users / container1 / view1 (Users) data view node.
![Selecting 'view1' on the Users page. Selecting 'view1' on the Users page.](/blog/2012/11/advanced-user-manager-for-custom_9266/image26.png)
Change the following properties.
Property |
New Value |
Activator |
Tab |
Text |
Users |
Search By First Letter |
true |
Press OK to save. Double-click on Users / container1 / view2 (Roles) node.
![Selecting 'view2' on the Users page. Selecting 'view2' on the Users page.](/blog/2012/11/advanced-user-manager-for-custom_9266/image28.png)
Make the following changes.
Property |
New Value |
Activator |
Tab |
Text |
Roles |
Save the data view. Double-click on Users / container1 / view3 (Users) node.
![Selecting 'view3' on the Users page. Selecting 'view3' on the Users page.](/blog/2012/11/advanced-user-manager-for-custom_9266/image30.png)
Make these changes:
Property |
New Value |
View |
UsersInRole |
Activator |
Tab |
Text |
Roles |
Save the data view. Expand Users / container1 / view3 (Users, UsersInRole) / UsersInRole node. Drop RoleID data field node onto Users / container1 / view2 (Roles) to establish a master-detail relationship.
![A master-detail relationship has been created between 'view3' and 'view2'. A master-detail relationship has been created between 'view3' and 'view2'.](/blog/2012/11/advanced-user-manager-for-custom_9266/image34.png)