Web Services Project: Flight Booking App using .NET and C#

This project focuses on the implementation of a flight booking application using .NET and C# programming, encompassing database design and the Model-View-Controller (MVC) architectural pattern. The project begins with the creation of a database, including tables for airports, airlines, and flights, detailing flight information such as start and end locations, times, and prices. The assignment then moves on to interface implementation using the MVC model, with the design and implementation of models, controllers, and views. The provided code snippets illustrate the structure of the models, controllers, and the initial view for displaying flight options. The project includes references to various database systems and information systems management resources, indicating a comprehensive approach to the application's development and design. The application aims to provide users with a functional interface for searching and selecting flights based on their preferences.

1WEB SERVICES USING .NET AND C# PROGRAMMING
WEB SERVICES USING .NET AND C# PROGRAMMING
[Student name]
[University name]
[Professor Name]
[Date]

2WEB SERVICES USING .NET AND C# PROGRAMMING
Table of Contents
1 FLIGHT BOOKING APP IMPLEMENTATION...........................................................................................2
1.1 Database implementation...........................................................................................................2
1.2 Interfaces implementation using MVC model.............................................................................6
2 Reference...........................................................................................................................................13

3WEB SERVICES USING .NET AND C# PROGRAMMING
1 FLIGHT BOOKING APP IMPLEMENTATION
1.1 Database implementation
i. Creating database.

4WEB SERVICES USING .NET AND C# PROGRAMMING
ii. Creating tables.

5WEB SERVICES USING .NET AND C# PROGRAMMING
a. Airport table.
CREATE TABLE [dbo].Airport(
AirportID int IDENTITY(1,1) PRIMARY KEY,

6WEB SERVICES USING .NET AND C# PROGRAMMING
AirportName varchar(25) NOT NULL,
City varchar(25) NOT NULL
)
b. Airline_Flight table.
CREATE TABLE [dbo].Airline_Flight(
AirlineID int IDENTITY(1,1) PRIMARY KEY,
FlightNo int NOT NULL
) (Specialist, 2017).
c. Airline table.
CREATE TABLE [dbo].Airline(
Airline_AirlineID int IDENTITY(1,1) PRIMARY KEY,
AirlineName varchar(25) NOT NULL
)
d. Flight table.
CREATE TABLE Flight
(
FlightNo int IDENTITY(1,1) PRIMARY KEY,
AirportID INT FOREIGN KEY REFERENCES Airport(AirportID),
AirlineID INT FOREIGN KEY REFERENCES Airline_Flight(AirlineID),
StartLocation varchar(25) NOT NULL,
Destination varchar(25) NOT NULL,

7WEB SERVICES USING .NET AND C# PROGRAMMING
StartTime varchar(8) NOT NULL,
EndTime varchar(8) NOT NULL,
Airline_AirlineID INT FOREIGN KEY REFERENCES Airline(Airline_AirlineID),
Price numeric(6,2),
passagers varchar(25) NOT NULL,
coach varchar(25) NOT NULL
) (Paige, 2016).
1.2 Interfaces implementation using MVC model
i. Model designing and implementation.

8WEB SERVICES USING .NET AND C# PROGRAMMING
(Stephen, 2016).

9WEB SERVICES USING .NET AND C# PROGRAMMING

10WEB SERVICES USING .NET AND C# PROGRAMMING
(Thomas, 2015).

11WEB SERVICES USING .NET AND C# PROGRAMMING
(Shamkant, 2016).
Source codes
namespace FLIGHT_BOOKING.Models
{
using System;
using System.Collections.Generic;
public partial class Flight
{
public int FlightNo { get; set; }
public Nullable<int> AirportID { get; set; }
public Nullable<int> AirlineID { get; set; }
public string StartLocation { get; set; }
public string Destination { get; set; }
public string StartTime { get; set; }
public string EndTime { get; set; }
public Nullable<int> Airline_AirlineID { get; set; }
public Nullable<decimal> Price { get; set; }

12WEB SERVICES USING .NET AND C# PROGRAMMING
public string passagers { get; set; }
public string coach { get; set; } (Ramez, 2016).
}
}
ii. Controller designing and implementation.
(Elmasri, 2015).
iii. View designing and implementation (first page).
The below is the first page that displays the various flights available and the customers can select one of
the appropriate flights from the list.