Assessment

Assumptions

• Worker can create cases but not review/approve.
• Worker/Reviewer/Approver can see all cases, but only take action on cases in their appropriate "queue".
  • State is derived from which "queue" the case is in. For example, a case is in the "New" state if it has not been approved.
• State diagram did not explicity demonstrate a "denied" state/queue.
• Percent of approved cases per user, along with the percent approved against the total number of cases.
  • Assumed that the "user" in this case would only be the the workers creating the cases. Since Reviewer/Approver cannot have cases "Approved" because they do not create cases.

Getting started

1. Open the Package Manager Console window, type in Update-Database

For convenience sample user and case data is added to the database on application start.

Tools used

Database is managed by EF Migrations

Dapper is used for stored procedure access.