PRG$455$ Final Project

Marks: $15\%$

Project Overview

Design a Visual C# application to manage a simple airline reservation system. It requires creating a SQLite database with at least three related tables:

Flight Records: Includes flight ID$,$ cities of departure$/$destination$,$ dates$/$times of departure$/$arrival$,$ price, and seats available$/$sold $($first$-$class and coach$).$

Customer Information: Contains customer ID$,$ name, telephone, and address.

Flight Purchases: Details flights purchased with selected flight and customer data.

Additional tables and fields can be added as necessary. The application should feature multiple Windows forms to search for flights, process purchases, and display receipts with order details and total cost including taxes. Database updates are required when orders are processed.

Functionality & Requirements

Use of exception handling to prevent run$-$time errors.

Multiple forms for searching flights, making purchases, and displaying receipts.

The first form will enable the user to search for a flight's information. If a flight selection has been made,

the second form will enable the user to purchase this flight, or return to the previous form and search for another flight.

If the purchase has been made the next form will display a receipt, which contains the customer and the purchased flight data, as well as the total cost including all taxes.

Please note that when a customer's order is processed the database file has to be updated, i$.$e$.$ new records added into the third table, and the number of seats available as well as the number of seats sold updated in the first table.

Database updates with each transaction.

Submission Requirements

Complete your solution to above questions and name your solution folder as following mySenecaID$\_$courseCodeAndSection$\_$LP format,

where:

'mySenecaID' is your lowercase my$.$seneca user$/$login id

'courseCodeAndSection' is your UPPERCASE course code and section $($eg$.$ PRG$550$A$,$ PRG$550$B$,$ etc$)$ For example, a my$.$seneca user id of tswift$2$ submitting project for PRG$455$NCCL would be: tswift$2\_$PRG$455$C$\_$LP

and zip your solution folder submit on blackboard

People who demonstrate a fully functioning program before the deadline will get a $2\%$ bonus.

Zipped project file submission on BlackBoard.

Note: No extensions will be granted. Projects submitted after the deadline will not receive any marks.

Prepared by: Sushen ZhangForm $1$

Figure $1.$ Form$1$ before input

Form$1$ launches when program starts shown as figure $1.$ User will need to select

all three search criteria to search flights.