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