The relationships between tables in the schema that is shown in Figure 18-1 are explained in Table 18-8.

Table 18-8 Relationships in the SkyShark Airlines Database

You have examined each table of the SkyShark Airlines database and the database schema. Next, you will examine the interface of the application—the Web Forms that constitute the application.

Web Forms Design

As discussed in the previous sections, the Web application for SkyShark Airlines should provide different ASP.NET Web forms for different roles. In this section, I will show you the design of each Web form in the application.

Forms for Business Managers

The Web application has four forms for business managers: AddFl.aspx, RequestID.aspx, Reports.aspx, and FreqFl.aspx.The next sections discuss each of these forms.

The AddFl.aspx Form

The AddFl.aspx form is used to add new flights to the airline. The information specified by business managers in the AddFl.aspx form is stored in the dtFltDetails table. The AddFl.aspx form is shown in Figure 18-3. Notice that the prefix SS is added to all flight numbers by default, because these initials represent SkyShark Airlines.

FIGURE 18-3 Adding new flights to the airline

The RequestID.aspx Form

Business managers use the RequestID.aspx form to request new user IDs. The request is sent to a network administrator by e-mail. The interface of the RequestID.aspx form is shown in Figure 18-4.

418 Project 4 CREATING AN AIRLINE RESERVATION PORTAL

The Reports.aspx form is used for generating reports. You can view a description of the reports that a business manager can generate in the “Project Requirements” section of this chapter. The Reports.aspx form is shown in Figure 18-5.

FIGURE 18-5 Generating reports for analysis

Team-Fly®

420 Project 4 CREATING AN AIRLINE RESERVATION PORTAL

Forms for Line-of-Business Executives

Line-of-business executives use four Web forms for their daily operations: CreateRes.aspx, CancelRes.aspx, QueryStat.aspx, and ConfirmRes.aspx. A description of these forms is given in this section.

The CreateRes.aspx Form

The CreateRes.aspx form is used for making reservations to flights. This is the most elaborate of all forms in the Web application. The reservation process is divided into three steps:

1.In Step 1, the line-of-business executive accepts the flight number, class, and date of journey. The information is used to query the status of the flight.

2.In Step 2, the details of the flight and the flight status are displayed to the passenger. If the passenger wants to proceed with the reservation after viewing the details, the line-of-business executive moves to the third step of the reservation process.

3.In Step 3, passengers provide their name and e-mail ID. If the passenger qualifies for the frequent flier program, the appropriate discount is applied to the fare. Finally, the ticket for the passenger is generated.

The CreateRes.aspx form is shown in Figure 18-7.

FIGURE 18-7 Making reservations to flights

422 Project 4 CREATING AN AIRLINE RESERVATION PORTAL

FIGURE 18-9 Querying the status of flights and tickets

The ConfirmRes.aspx Form

The ConfirmRes.aspx form uses the ticket number to confirm the reservation of a passenger before the departure of a flight. When the line-of-business executive confirms the status of a passenger, the status is updated in the dtReservations table. The ConfirmRes.aspx form is shown in Figure 18-10.

FIGURE 18-10 Confirming reservations

Forms for Network Administrators

Network administrators can use the SQL Server Enterprise Manager for archiving and backing up databases. However, the SkyShark Airlines application provides two Web forms for simplifying some of the tasks of network administrators. These forms are explained in this section.

The ManageUsers.aspx Form

The ManageUsers.aspx form is used for adding and deleting user accounts. The details of users added or deleted are updated in the dtUsers database.

I have divided the ManageUsers.aspx form into two sections. The first section is used for adding new users and the second one is used for deleting user accounts. The ManageUsers.aspx form is shown in Figure 18-11.

FIGURE 18-11 Adding and deleting user accounts

TIP

The ManageUsers.aspx form is divided into two sections by using DHTML.You will learn how to implement this functionality in Chapter 20.

424 Project 4 CREATING AN AIRLINE RESERVATION PORTAL

The ManageDatabases.aspx Form

The ManageDatabases.aspx form is used for two tasks:

Updating flight information for flights that have departed. Information for flights that have departed needs to be moved from the vations table to the dtDepartedFlights table. Network administrators can move this information by the click of a single button on the ManageDatabases.aspx form.

Updating customer for the frequent fliers program. Information pertaining to the frequent fliers program needs to be retrieved from the

dtDepartedFlights table and updated in the dtPassengerDetails table.

This information can also be updated from the ManageDatabases.aspx form.

The ManageDatabases.aspx form is shown in Figure 18-12.

FIGURE 18-12 Managing databases

Common Forms of the Application

Apart from the Default.aspx form, there are some forms that are common across all roles in the organization. These forms are explained in the following list: