HoMasters CS 499 Fall 2006 Nov 21

1
Ho-MastersCS 499Fall 2006 Nov 21

• Tasha Baker
• John Flanary
• Stephenie Swope

2
Introduction

• We are the Ho-Masters implementing Tolly-Hos
  employee website.
• Site will allow employees and managers to login
  and view or change information based on their
  access control.

3
Scope

• Environment is still the same. Visual Studio
  2005 using ASP.NET and C.
• The database is MYSQL with ODBC Connection.
• The objectives have been shortened to eliminate
  Import Data, Payroll Data, and Employee Test
  Development.

4
Objectives
Objectives left
EmployeeData
Access Control
Images Forms
Reports
Reminders Notifications
5
Agenda
1. User Interface v
2. Access Control v
3. Database v
4. Getting website online ?
5. Connecting everything together
6
Progress Diagram
Phase 1
Phase 2
Phase 3
Website Completed Purchase of
Domain Hosting Service To
do Fix hosting error of Does not allow
partially Trusted users
Database Completed Create
Statements To do Reports Queries
User Interface Completed Login Access
Control Calendar Events
Form Uploading News To do MyPage
Form Storage
7
High-Level Diagram
Home
DontLogin
Login
Employees
Managers
Administrators
RestaurantData (View)
EmployeeData (View)
All Data(Edit)
View PageStructure
ViewReports
Database Access
8
Intermediate Level Diagram
Data Tables Albums Announcements Events
Employees Forms Locations Roles Users
9
Employee Module

• View Calendar of Events
• View Events in a Calendar Format
• View Events in a List Format
• Click on an Event to View detailed information
• View Locations
• View Locations List
• Click on a Location to View detailed information
• Events may occur at a location they can be
  accessed from there
• View News Images
• View News List
• Click on a News Article to view detailed
  information
• Photos are in Albums click on an album to view
  the images in it
• Click on an image to view it larger and get the
  option to download it
• View / Download Docs
• Not yet implemented will probably be accessed
  through the Photo Albums
• View Personal Data
• Not yet implemented will be accessed through
  the My Page page

10
Managers Module

• View / Edit Events
• View like Employees
• Additional Ability to Create, Delete, or Edit an
  existing event
• View / Edit Locations
• View like Employees
• Additional Ability to Create, Delete, or Edit an
  existing Location
• View / Edit News Images
• View like Employees
• Additional Ability to Create, Delete, or Edit an
  existing News article or Image
• View / Edit Docs
• Not yet implemented will probably be accessed
  through the Photo Albums
• Managers will have the additional ability to
  Create, Delete, or Edit an existing Album and Add
  or Delete Images
• View / Edit Employees
• Not yet implemented will be accessed through
  the Members page
• Managers will have the ability to view and edit
  all employees
• Generate Reports
• Not yet implemented This function will be
  added to the Members page

11
Administrators Module

• View / Edit Events
• Same functionality as Managers
• View / Edit Locations
• Same functionality as Managers
• View / Edit News Images
• Same functionality as Managers
• View / Edit Docs
• Same functionality as Managers
• View / Edit Employees
• Same functionality as Managers
• Generate Reports
• Same functionality as Managers
• ---- The Administrators Module was originally
  created for the optional objective that allowed
  Administrators to access financial data that
  Managers could not. This possible objective has
  been removed, but we are leaving in this
  structure for possible future implementation by
  the customer.----

12
User Interface

• We will do a demo in real time of the following
  functionality
• Security Access Controls
• Only Authorized users can see data
• Employees can view data
• Managers / Administrators can edit
• Create a News Article, associate an image with
  that article and insert that image into an album
• Then log out and view that image as an Employee

13
Partial Data Dictionary
Form Database Table
14
Acceptance Testing
Testers
Employees
Managers
Stephenie
Owner
15
Conclusion
Testing has already begun. Now you can see the
permissions of administrators, managers and
employees from the user interface.