Overview
This is a more difficult assignment and uses a great deal of Visual basic. It is a more realistic way to create a large web site. Dividing functionality into seperate classes makes it easier to maintain and scale an application.
Here is a sequence diagram that shows how the classes communicate with each other
Instructions
The point of this assignment is to add a new employee. To do this we will create an employee class and a datalayer class that takes the employee class and writes the data to the database.
The first step is to create the entry form
We are not going to worry about multiple contacts or dependents. The goal is to keep this fairly simple.
Your Employee class should have fields and properties for each of the elements to be entered
The data layer class should accept an Employee object in its constructor and then use ADO to insert the data into the appropriate tables. Remember that you will need to find the PersonKey in order to do the inserts into PersonAddress. PersonContact and Employee tables.
Grading
Because this is a complex assignment I will make it worth 20 points.
- 5 points for the web form
- 5 points for the Employee Class
- 5 points for the DataLayer Class
- 5 points for the ADO and the successful insertion of an Employee