470 Project 4 CREATING AN AIRLINE RESERVATION PORTAL

FIGURE 20-7 The ChangePassword.aspx form

Forms for Network Administrators

The SkyShark Airlines application provides two forms for business managers, ManageUsers.aspx and ManageDatabases.aspx. The ManageUsers.aspx form is used to add and remove user accounts, and the ManageDatabases.aspx form is used to update databases. I will discuss the design of these two forms in this section.

ManageUsers.aspx

The ManageUsers.aspx form is divided into two sections. One section is used to add user accounts and the other is used to remove user accounts.The controls you need to add to the ManageUsers.aspx form are given in Table 20-5.

472 Project 4 CREATING AN AIRLINE RESERVATION PORTAL

After you add the controls specified in Table 20-5, the design of the ManageUsers.aspx form is complete and is shown in Figure 20-8.

FIGURE 20-8 The ManageUsers.aspx form

ManageDatabases.aspx

The ManageDatabases.aspx form includes two Button controls used for moving information pertaining to flight departure from the dtReservations table to the

dtDepartedFlights table and from the dtDepartedFlights table to the dtPassen-

gerDetails table. Apart from the first four controls consistent in all forms and mentioned in Table 20-5, I have added two Button controls to the form. These controls are described in Table 20-6.

for the frequent fliers program. BackColor=Silver BorderColor=Blue Font:Name=Bookman Old Style

Forms for Business Managers

SkyShark Airlines provides four forms for business managers: AddFl.aspx, RequestID.aspx, Reports.aspx, and FreqFl.aspx.The design of these forms is discussed in this section.

AddFl.aspx

The AddFl.aspx form is used to add details of any new flights introduced by SkyShark Airlines. The design of the AddFl.aspx form is straightforward. Apart from including the first four controls mentioned in Table 20-5, I have added text boxes and validation controls for the flight number, departure time and place, arrival time and destination, aircraft type, number of seats in the executive and business classes, and the fares of the executive and business class fields. I have also added two buttons for submitting and canceling the form. The design of the AddFl.aspx form is shown in Figure 20-9.

FIGURE 20-10 The RequestID.aspx form

Reports.aspx

The Reports.aspx form is used to generate reports. The form uses a DataGrid control to display reports corresponding to the type of report selected by the business manager. You can assign a DataView control to the DataGrid control so that data can be formatted and displayed in the form. A DataView control, in turn, retrieves data from a DataSet control. You will learn about using the DataGrid control in Chapter 21, “Implementing the Business Logic.”

The controls you need to add to the Reports.aspx page are listed in Table 20-8.

The completed Reports.aspx form is shown in Figure 20-11.