Download A Dynamic Web Server Based Appointment Calendar

Transcript
Besides the classes used to access the database, the business logic layer also includes some classes that
have the functions needed by the implementation of event handlers in the presentation layer. The classes
of CalendarSecurity and DateTimeInfo are such classes.
Presentation Layer
The presentation layer is the layer that is used to display the user interface. This layer consists of some
ASP.NET pages that have some ASP.NET Server Controls or user-defined Controls and also some event
handlers. The Visual Studio .NET environment let the developer work on the pages using the ‘Web Forms
Designer’ and write code using Code-behind module. This separation makes the UI design, code
implementation and maintenance much easier.
5. Implementation of the Web Calendar
5.1 The Database Design
To implement the web calendar, a database is needed to hold all the required information. For example,
we need information of the users, and information of the attendees and resources for a meeting, we also
need information of an event, etc. In this project, Microsoft SQL Server 2000 was used as the database
server that can be in the same IP address or different IP address as the web server machine. In this project,
the web server and the database server are in the same machine. When a connection request to the web
server is made, ASP.NET authenticates the user provided credentials with the user information stored in
the MS SQL server. If the connection is authenticated, the MS SQL server will trust this connection and a
default account ASP.NET is used by the user to access the database.
Nine tables are created for implementing the web calendar system. The primary key for each table is
underlined in the Name column. If the primary key is the combination of several variables, all the names
of there variables are underlined. Each table is described in details as below and following the nine tables
is a Diagram of Database Entity-Relationship.
Table 5.2
Column Name
ResourceID
Data Type
Int(4)
Resource
.NET Data Type
Int
ResourceName Varchar(50) String
Description
Auto increment field, uniquely identifies a resource
The resource name which will be used in a meeting
This table is used to store all the resources, like the conference room and projector, etc.
37