Patient Database
This is the home page for the DrOffice application. To use this application
the DrOffice database must first have been created using the scripts that
came with the book. Assign a system DSN with the name DROfficeDB to the database.
Five commands can be executed from this home page. They are described below:
Manual Login
This command permits you to chose the login ID to be used when retrieving data
from the database. The user ID is used to retrieve the user's role from the database.
The role is used to determine the category of data that the user is permitted to
retrieve from the database.
Integrated Login
This command uses the context of the current user as the user ID. To make this work
create four users with the IDs Peter, Paul, Mary, and Pat to test this out. Assign
each user to a role in the Authorization Store DrOffice.xml using the Authorization
Manager MMC which you can access by running AzMan from the Run dialog or the command
line.
Application Tables
This command is used to look at the application tables that are used to define the
users who are part of the staff along with their role, the data category that each
role can access, the value for each data category, and the data category for each
column in the patient table.
Add Patient Record
This command permits you to add a new record into the Patients table. Play with the role
values and the category values for the database columns to see how it affects the output.
You can modify the data category for the database columns by using the SQL Query Analyzer
tool and right-clicking on a column and selecting Extended properties. Change the value
of the DataCategory property and see how it affects the output.
Submit Resume
This command permits you to submit a new resume to the database. Multiple data blocks
can be added to each resume entry. Each data block can be assigned a data category.
When viewing the resumes, the reviewer will only be able to see those fieds that
match his or her role.
Manual Login
Integrated Login
Application Tables
Add Patient Record
Submit Resume