c# lab work

simple lab tasks need to be done.

Project Description

The Course Project is simply the cumulative result of completing labs 1 through

7

. In lab 1, you will create a basic PayrollSystem Web application that represents a payroll processing website for a company. Each subsequent lab will add more features to this application. By the time you complete lab 7, you will have a finished Web application with a good deal of functionality. You will be able to log into your application, enter personnel records to be stored in a database, retrieve and display previously entered records, perform transactions, monitor user activity, and send e-mail notifications of errors.

After you complete lab 7, but before submitting the project, you should thoroughly test all the Web pages and the functionality added to the PayrollSystem website over all the labs. Also, review the feedback you have received from your instructor on the previous labs, and correct any deficiencies noted. After all problems have been fixed and everything from labs 1–7 works correctly, simply zip up the entire PayrollSystem website after completing lab 7 and submit it as your Course Project.

The following sections summarize the features you will add to the website each week. All of these features should be present and working in the Course Project in order for you to receive full credit.

See Syllabus/Assignments & Exams for due dates.

Week 1: “Annual Salary Calculator” ASP.NET Web Application

In this lab, you will create a simple ASP.NET Web application using Microsoft Visual Studio 2008 that displays the text “Hello, World” on the home page. You will also add a page and build an Annual Salary Calculator on that page. This will be used as the foundation for all subsequent labs.

Week 2: User Input Web Pages

In this lab, you will create an ASP.NET Web application main form containing a list of hyperlinks and images. You will also add a form with five text boxes and a Submit button. You will use the form to send information to a second form (which you will also create), where data from the first form will be displayed so it can be verified by the user.

Week 3: User Activity Monitoring

In this lab, you will save user activity data in a database. A record of each user’s IP address and the current date and time will be created whenever a user visits the Personnel form. You will be able to view a list of all previous user activity records. You will add validation to the form added in Week 2 to validate the user input.

Week 4: Web Forms with Database Interaction

In this lab, you will start with the form created in Week 2 and add functionality to INSERT records into a database table and SELECT records for display to the user. You will also add a search feature to search for records to display.

Week 5: Transaction Processing

In this lab, you will add transaction processing to the database INSERT functionality from the previous week to make it operate more reliably. Changes to the database will be committed (made permanent) only if all operations in a transaction are completed successfully. If any operation in a transaction fails, the entire transaction will be rolled back (undone) so that the database is left in its original state. This prevents storing incomplete or inconsistent information in the database when an error occurs. You will add client side validation controls. You will also add an editable list of database records that will allow the user to view, update, and delete employee records.

Week 6: Login and Security Levels

In this lab, you will create a login form, use the login control, validate a user based on the login name and password, and allow access to the system if it’s authorized or prevent the user from accessing the system if unauthorized. You will add the ability to add new users, modify existing users, delete users, and view all users.

Week 7: Error Notification Via E-Mail

In this lab, you will incorporate error handling into the login process so that a notice of each invalid login attempt is automatically e-mailed to the technical support staff. You will add additional security features to make the Web application more secure. You will also add security logic to specific forms in the Web application.

Grading Rubric

14

10%

14

10%

14

10%

14

10%

14

7

5%

7

5%

14

10%

Category

Points

%

Description

Functionality: Home Page or Main Page

14

10 %

· Displays “Hello World” message. (Lab 1) · Annual Salary Calculator is functional. (Lab 1) · Main page has links and hyperlinked images that go to the appropriate page. (Lab 2)

Functionality: Login Form

· Allows entry of user name and password. (Lab 6) · Has Login button. (Lab 6)

Security

· Uses Login control that redirects to Main page when there is a successful login. (Lab 6) · Main page links are turned on and off based on user role. (Lab 6) · Displays message saying that incorrect login information was e-mailed to support staff for invalid login. (Lab 7) · Pages appropriately check user role to allow access and functionality. (Lab 7)

Functionality: Personnel Form

· Allows entry of first name, last name, pay rate, start date, and end date. (Lab 2) · Properly validates data server side. (Lab 3) · Properly validates data client side. (Lab 5) · Displays submit button for administrative user only. (Lab 6)

Functionality: Personnel Verified Form

· Displays data entered on Personnel form. (Lab 2) · Displays message saying that data were saved in database if valid data is entered. (Lab 4) · Displays message saying that data were not saved if invalid data is entered. (Lab 5)

Functionality: User Activity Form

7

5%

· Displays user IP address, form name accessed, and date accessed. (Lab 3)

Functionality: Manage Users

10

· Allows the user to view, edit, and delete user records. (Lab 6)

Functionality: Edit Personnel Data

· Allows the user to view, edit, and delete employee records. (Lab 5)

Employee Search

· Allows the user to search for and display records based on search criteria.

Functionality: View Personnel Form

· Displays first name, last name, pay rate, start date, and end date for personnel entered on Personnel form with valid data. (Lab 4)

Comments

21

15%

· Explanatory comments placed in code where indicated in lab instructions.

Total

140

100

· Quality work will meet or exceed all of the above requirements.