SOFTPP

WOLAITA SODO UNIVERSITY
COLLEGE OF INFORMATICS
DEPARTMENT OF COMPUTER SCIENCE
Airline Management System
Group Members ID. No.
EBRAHIM SEID UGR/54384/13

DAWUD ABRAR
GENET SOLOMON
BIRUK
Acknowledgement
The satisfaction that accompanies that the successful completion of any task
would be incomplete without the mention of people whose ceaseless
cooperation made it possible, whose constant guidance and encouragement
crown all efforts with success. We are grateful to our project guide “Mrs
Medihanit” for the guidance, inspiration and constructive suggestions that
helpful us in the preparation of this project.
We are also thankful to my colleagues with whom we have fruitful discussion

which have helped us a lot in giving a final shape to the program.
CHAPTER ONE
1 INTRODUCTION
Technology is spreading its wing in almost every walks of human life
activities. Now a day, it is better if every activity is done using new
technology in order to fulfill the need of human being,
Organization and Enterprise etc. As today’s world there are many
organizations and each organizations needs to be preferable, computable
and work on fastest way in order to satisfy users interest etc. i.e. they
should have facilitate their activities in computerized way.
Hospital Management Systems are computer software products that

coordinate and integrate all the inherent activities involved in the
management and running of a healthcare facility. They must meet specified
security, technology and functionality standards for managing electronic
medical records and practice management information. Hospital
management system is created to computerize manual operations in
hospital. The primary purpose is to digitize patient records so as to make
data retrieval easy and efficient. Being in the digital form, patient data can
be conveniently shared and accessed by multiple simultaneous users at
different locations, resulting in medical operations and collaboration among
them.
Economically, hospitals benefit from constant cost savings as a result of

increased productivity and overall efficiency. Essentially, everyone in the
hospital benefits from the system:-doctor, nurse, receptionist, and
administrator which make their lives easy and remove unnecessary human
errors from their daily activities.
1.1 Background of the organization
Sodo or wolaita sodo is a town and separate woreda in south-central
Ethiopia. The administrative center of the wolaita zone of the southern
nations, nationalities, and peoples
Region, it has a latitude and longitude of 6°54′N 37°45′E with an elevation
between 1,600 and 2,100 meter (5,200 and 6,900 feet) above sea level. It
was part of the former Sodo woreda which included Sodo Zuria which
completely surrounds it.
College of health science and medicine of wsu is located in wolaita sodo

town; 329 km south of Addis Ababa and 151 km far from hawassa, which
is capital of Southern Nation Nationalities and Peoples Regional State. The
college is positioned on area of 16.7 hectares.
The former ‘Ottona Hospital’ the current ‘Wolaita Sodo University
Teaching Referral Hospital’ was established in 1920 E.C as small clinic by
SIM (Sudan Interior Mission). The hospital served for about 50 years as
primary hospital and then become general hospital for 30 years. In 2004
E.C, WSU takeover the hospital as a teaching and referral hospital with
academic, research and community service responsibilities. It delivers
different medical services for outpatients, emergency and inpatients for
approximately 450-500 patients per day for 24 hours. The total service
coverage of the hospital is about 3 million people of catchment areas. In
Academic wing, the hospital provides quality education, research and
community services.
1.2 Motivation
We had the opportunity to go to Ottona Teaching Referral Hospital for
many times. It is a large, manpower-intensive institution. It is also a huge
institution with many patients. But while it is a large medical institution,
the following procedure is not pleasant. The existing system is going on
inefficient and poor data record system. So we intend to make systematized
working environment. Patients get services in simple and clear way as soon
as with in efficient manner, to speed up medical cases, and to made better
managerial system. Finally we have motivated to propose this system to
automate management system.
1.3 Statement of the problem
On the existing system exhibit some problems like: lack of immediate
retrievals, lack of immediate information storage, and inaccurate report
generation. Additionally also have highly work load on employees, and
during retrieving patient history consume extra time. Data are captured
redundantly as well as data are not secured, that means personal
information are exposed by unauthorized agent. On the other side doctors
and patient forget the booked appointment. Economically the manual
system is expensive.
1.4 Objective
1.4.1 General objective

Develop web-based system for Ottona teaching referral hospital
management system.
1.4.2 Specific objective
 To analyze the existing system.

 To record employees of the organization.
 To provide online registration for the user.
 To enable online appointment reservation.
 To allow inter communication.
 To implement the proposed system.
 Test the new system.
 Deploy the new system.
 To maintain and update the new system when needed.
1.5 Methods
1.5.1 System Analysis and Design

In order to develop our project, our group used object-oriented system
analysis and design (OOSAD) development methodology for the design.
Since this system development methodology has so many important
features. Some of them are: -
 Real world modeling
 Increase reusability
 Increase extensibility
 Improve quality
 Improve reliability
1.5.2 Data collection methodology

In a newly proposed system, we have used different methods to develop the
system, to gather information or data of the existing system.
Interview - is one of traditional ways collecting or gathering data directly
from those who have information about that system. So, our team uses this
system to get the basic information such as the existing system working
condition and background information about existing management systems
of this hospital. This method is used to get truthful information by direct
eye contact questioning and answering the office workers.
Questionnaires: - By preparing question on hospital and distribute it to

workers works in the organization.
Document Analysis: - To get more information about the existing system
we analyzed the documents.
1.6 Scope and Limitation
1.6.1 Scope of the project

The scope of our project is focused on developing interactive web
based hospital management system for Ottona Teaching Referral
Hospital.
It mainly focuses on patients from registering patient up to treating in

different departments. It includes different activities of users which are
performed in their own department. Such like Admin, doctors, Patients,
pharmacist, laboratory technician, and receptionist. Such as:-
 Registration of patient’s information.

 Register patient’s diagnosis information.
Also employee management and pharmacy subsystems are included in this system.
1.6.2 Limitation of the project
 Does not support multi languages.
 The system cannot give the service of bed reservation for a patients
and also billing activities.
1.7 Significant of the Project

The study will significant to the hospital since it may improve their
management through connecting their entire existing computer in the
system. It also significant to the administrative staff since that may register,
update, delete and search information within the system. The study also has
significance to the hospital patients since they may have medical
information without experiencing delays and incorrect information.
Generally, the significance of the new system includes:
 Used to record patients on the database  Used to save time.
 Used to manage patient’s information easily.
 Used to make the recording and retrieving very fast.
 Used to reduce organization expense.
 Reduce human effort.
1.7.1 For users

 They can get recorded information easily and save the time.
 They receive services without harassment.
1.7.2 For employees

 Minimize work load.
 Easily can make inter communication.
1.7.3 For organizations

Use of the software is important for automation of the organization’s tasks
as well as reporting the progress or lags in the organization’s activities.
This improves company’s efficiency and effectiveness of the company’s
activities. The software reduces the workload and automation of activities.
It also assists in elimination of human errors, as a result, improves
effectiveness and consistency.
 It will manage the data easily.

 It will store the information securely.
 It will minimize the response time.

 It will increase the efficiency of the organization.
 It will increase the satisfaction of employees.
 It will reduce labor force.
 It will be easily accessible.
 It will enhance data security.
 It will decline overtime payment.
 Economically get benefit because man power will decrease and the
money which is paid for workers will be saved.
1.8 Feasibility Study

A feasibility study assesses the operational, technical and economic merits
of the proposed project. The feasibility study is intended to be a
preliminary review of the facts to see if it is worthy of proceeding to the
analysis phase. From the systems analyst perspective, the feasibility
analysis is the primary tool for recommending whether to proceed to the
next phase or to discontinue the project.
The feasibility study is a management-oriented activity. The objective of a

feasibility study is to find out if an information system project can be done
and to suggest possible alternative solutions.
A feasibility study should provide management with enough information to

decide:
 Whether the project can be done.

 Whether the final product will benefit its intended users and
organization.
 What are the alternatives among which a solution will be chosen?
 Is there a preferred alternative.
Feasibility study is an analysis that takes all of a project's relevant factors

into account including economic, technical, legal, and operational
considerations to ascertain the likelihood of completing the project
successfully. The need of this study is to identify and demonstrate the best
alternative. We have set four types of feasibility measures to test the
proposed system over the current one.
1.8.1 Economic Feasibility

The cost expending for project is smaller compared to the existing system.
So our project is economically feasible. And also, the system not requires
additional resource including computers because it uses the existing
computer and additional man power is not require. The proposed system
has an advantage over the existing system, through reducing number of
employees involving in the existing system. When we do cost analysis, the
cost used in the manual system is greater than the cost in required in the
proposed system.
Current System mainly manual process requires more staff members and
the operation is totally based on paper work. Paper based system requires
additional cost for transportation and copy. Indirectly it means need
additional manpower. As a result that affect economic balance of the
organization.
1.8.2 Technical Feasibility

Our system is technically feasible because the proposed system can be
developed using existing technology. It is planned to implement the
proposed system using Windows operating systems, web-based
applications. It is evident that the necessary hardware and software are
available for the development and implementation of the proposed system.
And after deployment the users of this project can use the system by using
the existing computers in the hospital and for developer, they use
computers that are used for implementation. And also more of the users are
literate on computers due to these most of them should not require training
and those users who are not literate are needed to undergo training and
prepare user documentation.
So, it should be possible for the users to use the system more efficiently
and effectively. The system has user friend interface that allows the users
of the system to perform the action they want without confusion.
1.8.3 Operational Feasibility

Our system is operationally feasible, because the proposed system can
perform different tasks that are difficult to perform manually and the
accessibility of the system is high because the design is interactive to the
users. In addition to this the performance of the system is high because
analysis and design are going OOSAD approach.
1.8.4 Legal feasibility

Legal feasibility is the study to know if the proposed project conform the
legal and ethical requirements is the study to know if the proposed project
conform the legal and ethical requirements. Ours system completely fulfill
legal and ethical requirements. Private information like medical histories
and personal details are held on protected manner.
1.9 System requirement
1.9.1 Hardware requirement

 Desktop: almost all tasks of our project will perform on
computer.
 Flash disk: required for store & transfer data from one PC to
another PC.
 Network cable: since our system includes web based, it is very
necessary requirement. It is also help us to extract relevant
information about our project from internet.
 Stationeries (pen, paper): for writing all necessary
documentations associated with the project.
 Note book: to take notes during data collection and for other
document.
1.9.2 Software requirement

 Microsoft word 2016: - for documentation purpose
 XAMPP: we prefer xampp because it runs on any platform and
integrally contain apache and MySQL database. It is open
source and free.
 Edrawmax: - for designing of UML diagrams.
 Sublime Text 3- for encoding scripting languages.
 Adobe Photoshop CS6: is a powerful graphic editing program

that allows creating and manipulating images.
1.9.3 Programing language

 Java script: To program the behavior of web pages
 HTML: To define the content of web pages.
 CSS: it is the language for describing the presentation of
Web pages, including colors, layout, and fonts
 PHP: It's an open source, server-side, scripting language
used for the development of web applications.
1.9.4 Cost Estimation

To conduct this project a moderate budget is required and we will summarize
the estimated cost in the following categories.
Table 2 cost estimation

Material Birr Cent quantity Total birr
Paper 120 00 1 120.00
Pen 10 00 3 30.00
Flash 8GB 280 00 1 280.00
Laptop 15,500 00 1 15,500.00

Transportation 100 00 6 600.00
print 2 00 65 130.00
Total 16,660.00
1. Project Name and Description
AIRLINES RESERVATION SYSTEM
The Airline Reservations System (ARS) was one of the earliest changes to
improve efficiency. ARS eventually evolved into the Computer Reservations
System (CRS). A Computer Reservation System is used for the reservations of a
particular airline and interfaces with a Global Distribution System (GDS) which
supports travel agencies and other distribution channels in making reservations
for most major airlines in a single system.
Airline Reservations Systems contain airline schedules, fare tariffs, passenger

reservations and ticket records. An airline's direct distribution works within
their own reservation system, as well as pushing out information to the GDS. A
second type of direct distribution channel are consumers who use the internet or
mobile applications to make their own reservations.
INVENTORY MANAGEMENT
An airline’s inventory contains all flights with their available seats. The
inventory of an airline is generally divided into service classes (e.g. First,
Business or Economy class) and up to 26 booking classes, for which different
prices and booking, conditions apply. Inventory data is imported and
maintained through a Schedule Distribution System over standardized
interfaces. One of the core functions of the inventory management is the
inventory control. Inventory control steers how many seats are available in the
different booking classes, by opening and closing individual booking classes for
sale. In combination with the fares and booking conditions stored in the Fare
Quote System the price for each sold seat is determined.
DISPLAY AND RESERVATION
Users access an airline’s inventory through an availability display. It contains
all offered flights for a particular city-pair with their available seats in the
different booking classes. This display contains flights, which are operated by
the airline itself, as well as code share flights, which are operated in co-
operation with another airline. If the city pair is not one on which the airline
offers service it may display a connection using its' own flights or display the
flights of other airlines.
The availability of seats of other airlines is updated through standard industry
interfaces. Depending on the type of co-operation it supports access to the last
seat (Last Seat Availability) in real-time. Reservations for individual passengers
or groups are stored in a so-called Passenger Name Record (PNR). Among
other data, the PNR contains personal information such as name, contact
information or special services requests (SSRs).
E.g. for a vegetarian meal, as well as the flights (segments) and issued tickets.
Some reservation systems also allow storing customer data in profiles to avoid
data re-entry each time a new reservation is made for a known passenger.
Fare Quote and Ticketing
The Fares data store contains fare tariffs, rule sets, routing maps, class of service tables, and
some tax information that construct the price - "the fare". Rules like booking conditions (e.g.
minimum stay, advance purchase, etc.) are tailored differently between different city pairs or
zones, and assigned a class of service corresponding to its appropriate inventory bucket.
Inventory control can also be manipulated manually through the availability feeds,
dynamically controlling how many seats are offered for a particular price by opening and
closing particular classes.
2. Profile of the problem
The web based “airline reservation system” project is an attempt to stimulate the basic concepts of
airline reservation system. The system enables the customer to do the things such as search for airline
flights for two travel cities on a specified date, choose a flight based on the details, reservation of
flight and cancellation of reservation.
The system allows the airline passenger to search for flights that are available between the two travel
cities, namely the “Departure city” and “Arrival city” for a particular departure and arrival dates. The
system displays all the flight’s details such as flight no, name, price and duration of journey etc.
After search, the system display list of available flights and allows customer to choose a particular
flight. Then the system checks for the availability of seats on the flight. If the seats are available then
the system allows the passenger to book a seat. Otherwise, it asks the user to choose another flight.
To book a flight the system asks the customer to enter his details such as name, address, city, state,
and credit card number and contact number. Then it checks the validity of card and book the flight
and update the airline database and user database.
Disadvantages in existing system :->
 Time consuming
 Possibly of losingdata
 Lack of security
 Difficulties in maintaining records
 Human error will be frequent
 searching the records manually leads time consuming
3. Existing System
Introduction
In the existing system all the data are stored manually to an excel sheet and filed accordingly in a
filing cabinet.
SPECIFIC OBJECTIVES:-
a. Maintaining safe records

b. Should be easier to find for a record in the database
c. The loss of data in any corruption of any files in the system will be avoided due to any
natural case
d. Minimizing errors of the information recorded in the system while entering to the
system
e. The new system should be user friendly
f. Data entry should be fast
g. There should be a method of keeping the information from unauthorized users.
Methods of data collection and input Structure of Airline:
Name:
Address:
Humber:
DOB:
Nick:
Passport No:
Nationality:
Destination:
Airline:
Day of Dep:
Time:
When the customer ask to book a flight at first the booking form is been filled with his/her full :->
Name, Address, National ID, Email, Address, Contact Number, Destination, Booking date and the
Retuned date as shown above the form. After that the document is been signed by the office staff.
2 Exiting software METHODOLOGIES
HARDWARE:
PROCESSOR : PENTUIUM IV 2.6 GHz
RAM : 512MB DD RAM
MONITOR : 15” COLOR
HARD DISK :250 GB
CDDRIVE : LG52X
KEYBOARD : STANDARD 102 KEYS
MOUSE :OPTICAL MOUSE
SOFTWARE:
FORNT END :JAVA,HTML,SERVLETS
BACKEND : ORACLE 10i
OPERATING SYSTEM : WINDOWS XP
DFD for Present system

What is new in the system to be developed?
APPLICABILITY
 This project solve the problem of the traditional reservation system.

 With certain changes, it can be applicable on any online reservation field.
 One of the most benefits in today’s life is that reservation can be made from any place of the
world.
 The user need not to be present the physically to draw a reservation slip. It will
automatically do by the system
ADVANTAGES
1. It easy to learn and adjust to the system
2. This system does not require the staff to be highly educated
3. The requirements to tackle this job may be limited to
4. Willing to work long hours

5. Data is not easily lost
6. It easy to manage the system due to the high number of staff working
4. Problem Analysis
Product definition
One .Plane type: This defines the physical type of the plane. It dictates the capacity of first,
Executive, business and economy seats that a flight can have.
2. Airport: An airport consists of a name, the city it is in, and its airport id.
3. Flight: A flight is identified by its flighty. A flight denotes a unique “plane”, i.e. one that is
scheduled to run at a certain time, from one place to another. A flight runs over a set of routes.
4. Route: A route is simply a tuple of airports: (Start Airport, End Airport), and every route has a
unique route id. A flight runs over a route only if it runs from the start airport to the end airport,
possibly halting in between at other airports. A route is elementary for a flight if the flight runs
nonstop from the start airport to the end airport.
5. Ticket: A ticket is uniquely identified by a ticketed. The ticket may be a passenger ticket or a cargo
ticket, and can be booked under a passenger profile or a user profile. A ticket is booked on a flight
for a route that the flight is associated with. A passenger ticket contains details about the passenger,
and a cargo ticket about a cargo. The
6. Scheme: A scheme consists of discount percentages on various classes awarded on certain flights,
and for certain people or round trips. Scheme ids have a type code defining what they they are valid
for, and a period code showing whether they are valid as of now or no. A scheme is defined for a
flight and for a particular route.
7.Official: An official is a person who can book tickets for others, and can find retrieve the complete
list of passengers boarding a flight. An official works at an airport.
8. Profile: A profile denotes that a person has been verified to be genuine and can book tickets/
execute certain queries.
Feasibility Analysis
1. FlightRouteScheme: This ternary relation says that a flight runs over a route using a particular
scheme. The scheme can be null, but not the flight id and route id. The attributes in this include:
a. Fare for the flight between the two stops given by the route specified.
b. Any scheme valid on this flight, for this route
c. Number of booked seats on this flight, route.
d. A flag value indicating whether this is an elementary or complex route for this flight.
2. FlightRouteTicket: This ternary relation says that a ticket is booked on a certain flight over one
route that the flight allows. It has only the primary keys of each entity.
3. Profile Ticket relation: This consists of two relations: user profile related to ticket and the official
profile related to ticket. This is done to keep the user and official profiles separate and independent
from each other.
Project Plan
The plan of this project is to make a software, which is :->>
 Interpreted and high performance

 Distributed
 Dynamic
 Secure
Services Reservation in Airlines Abstract:-

This Abstract report on a study about examining airlines' reservation services.
An apparatus, method, and program for determining a price of an option to purchase an airline
ticket, and for facilitating the sale & exercise of those options.
Pricing of the options may be based on departure location criteria, destination location criteria, and
travel criteria. The attributes selected for examination included….
(1) Requirements of reservation services.
(2) Provision of extra benefits.
(3) Factors affecting reservation time.
(4) Provision of additional services/facilities.
Empirical results indicated that some airlines did not provide all components in the chosen attributes
and that airlines in these regions differed significantly in certain dimensions of the chosen attributes.
5. Software requirement Analysis
Introduction
Requirements analysis is critical to the success of a development project. Requirements must be

documented, actionable, measurable, testable, related to identified business needs or opportunities,
and defined to a level of detail sufficient for system design. Requirements can be architectural,
structural, behavioural, functional, and non-functional.
General Description
Visual Basic .NET (VB.NET) is an object-oriented computer programming language that can be
viewed as an evolution of the classic Visual Basic (VB) which is implemented on the .NET
Framework. Microsoft currently supplies two major implementations of Visual Basic: Microsoft
Visual Studio, which is commercial software and Microsoft Visual Studio Express, which is free of
charge.
Specific Requirements
 System
 Windows XP Service Pack 2 or above (for 2010 release, Service Pack 3)
 Windows Server 2003 Service Pack 1 or above
 Windows Server 2003 R2 or above
 Windows Vista
 Windows Server 2008
 Windows 7
 Linux with Mono (only works with .NET 2.0 applications)
 Hardware
 Minimum: 1.6 GHz CPU, 384 MB RAM, 1024×768 display, 5400 RPM hard disk
 Recommended: 2.2 GHz or higher CPU, 1024 MB or more RAM, 1280×1024 display, 7200
RPM or higher hard disk
6. Design
System Design
Systems design is the process of defining the architecture, components, modules, interfaces, and
data for a system to satisfy specified requirements. One could see it as the application of systems
theory to product development.
There is some overlap with the disciplines of systems analysis, systems architecture and systems
engineering. If the broader topic of product development "blends the perspective of marketing,
design, and manufacturing into a single approach to product development, then design is the act of
taking the marketing information and creating the design of the product to be manufactured.
Systems design is therefore the process of defining and developing systems to satisfy specified
requirements of the user
Detailed design
Screen shots:
LOGIN Screen:-
Main menu:-
Customer add
Update
NEW ADD FLIGHT
UPDATE FLIGHT
FARE
TICKET RESERVATION
TICKET CANCEL
7. Testing
Functional Testing
Functional testing is a type of black box testing that bases its test cases on the specifications
of the software component under test. Functions are tested by feeding them input and
examining the output, and internal program structure is rarely considered (Not like in white-
box testing).
Functional testing differs from system testing in that functional testing a program by
checking it against ... design document or specification", while system testing "validate a
program by checking it against the published user or system requirements.
Functional testing typically involves five steps:->
1. The identification of functions that the software is expected to perform

2. The creation of input data based on the function's specifications
3. The determination of output based on the function's specifications
4. The execution of the test case
5. The comparison of actual and expected outputs
System testing of software or hardware is testing conducted on a complete, integrated system to
evaluate the system's compliance with its specified requirements. System testing falls within the
scope of black box testing, and as such, should require no knowledge of the inner design of the code
or logic.
Structural Testing
It determines the durability and integrity of complete structures or sub-assemblies, usually in multi-
axis testing systems that replicate end use conditions. The product range extends from single-axis
component testing through to complex testing systems for the simulation of almost all service loads
affecting a vehicle or component. IST offers a wide range of modular standard testing systems for
use in the automotive industry to test car components such as suspensions and steering systems.
Alternatively, systems can be engineered to meet specific customer requirements.
Levels of testing
1) Unit testing
2) Integration testing
3) System testing
4) User acceptance testing
1) Unit testing: individual software components of application are tested in isolation from other part
of the program.
Big ban testing: individual software components of an application are combined at once into
system .every module is first unit tested. Then the entire system is tested for communication
interfaces between them.
Bottom-up testing: In bottom-up integration, testing begins from bottom of the module hierarchy
and work up to the top to simulate higher-level modules .every module is first unit tested then
modules are added in ascending hierarchical order. Lower level modules are tested first then the
next set of higher level modules are tested with previously tested lower level modules.
Top-down testing: begins testing from top of the module hierarchy and
Work down to the bottom to simulate lower interfacing modules. Every module is first unit tested
then the modules are added in descending hierarchical order. Higher-level modules are tested first
then the next set of lower level modules are tested with previously tested higher-level modules.
Testing of the Project
Proofreading
Proofreading (also proofreading) traditionally means reading a proof copy of a text in order to detect
and correct any errors. Modern proofreading often requires reading copy at earlier stages as well.
Double Entry
In the double entry, system transactions are entered twice in the accounts. For example, the same
car purchased will result an increase in the "vehicle" account and a decrease in "cash" account.
Therefore, the difference between the two is that in single entry system, transaction is entered only
once and in double entry system it is entered twice
This is to find if any errors are present in the system. To check for the errors an artificial made
database are fed to system and been checked and the errors will be verified accordingly. Two main
ways of data verifications are-
Single Method: this is also known as proof reading method-
Typing the data twice and comparing the two database at the same time. This method is also known
as double entry method.
8. Implementation
Implementation of the project
Update
9. Project Legacy
Current status of project
 Data has been added

 New customer login
 Deletion in the data
 Updating
 Generate id automatically
Remaining area of concern
10.User Manual: The complete guide (help file) for the project
developed
Book which prefer: VB.NET 2008
1.9.5 Pro VB 2008 and the .NET 3.5 Platform
Author: Andrew Tirolese

Publisher: Après
11.Source code
CODING IN LOGIN SCREEN:-

Public Class Form1
Private Sub Button1_Click (By Val sender As System. Object, By Val e as

System.EventArgs) Handles Button1.Click
If TextBox1.Text = "admin" And TextBox2.Text = "password" Then
MsgBox ("Username and Password Accepted")
mainmenu.Show ()
Else
MsgBox ("You have entered wrong Username or Password")
End If
End Sub

System.EventArgs)
TextBox1.Clear ()
TextBox2.Clear ()
End Sub

MsgBox("Thanks for using Airline Reservation System ")
Me.Close ()
End Sub
End Class
CODING IN MAIN MENU

Public Class main menu
Private Sub ExitToolStripMenuItem_Click (By Val sender As System.

Object, By Val e as System.EventArgs) Handles ExitToolStripMenuItem.Click
Me.Close()
End Sub
Private Sub FareDetailToolStripMenuItem_Click (By Val sender As System.

Object, By Val e as System.EventArgs) Handles
FareDetailToolStripMenuItem.Click
faredetails.Show()
End Sub
Private Sub TicketReservationToolStripMenuItem_Click (By Val sender As

System. Object, By Val e as System.EventArgs) Handles
TicketReservationToolStripMenuItem.Click
Ticketreservation.Show ()
End Sub
Private Sub AddNewToolStripMenuItem_Click (By Val sender As System.

Object, By Val e as System.EventArgs) Handles AddNewToolStripMenuItem.Click
customerdetails.Show ()
End Sub
Private Sub DeleteToolStripMenuItem_Click (By Val sender As System.

Object, By Val e as System.EventArgs) Handles DeleteToolStripMenuItem.Click
Delcustomer.Show()
End Sub
Private Sub UpdateToolStripMenuItem_Click (By Val sender As System.

Object, By Val e as System.EventArgs) Handles UpdateToolStripMenuItem.Click
updatecustomer.Show()
End Sub
Private Sub AddNewToolStripMenuItem1_Click(By Val sender As System.

Object, By Val e As System.EventArgs) Handles
AddNewToolStripMenuItem1.Click
flightdetails.Show()
End Sub
Private Sub DeleteToolStripMenuItem1_Click (By Val sender As System.

DeleteToolStripMenuItem1.Click
Delflight.Show()
End Sub
Private Sub UpdateToolStripMenuItem1_Click (By Val sender As System.

UpdateToolStripMenuItem1.Click
Updateplane.Show ()
End Sub
Private Sub TicketCancellationToolStripMenuItem_Click (By Val sender As

TicketCancellationToolStripMenuItem.Click
TicketCancellation.Show ()
End Sub
Private Sub ReservationEnquiryToolStripMenuItem_Click (By Val sender As

ReservationEnquiryToolStripMenuItem.Click
TicketEnquiry.Show ()
End Sub
Private Sub Button1_Click(By Val sender As System. Object, By Val e as

System.EventArgs)
Me.Close ()
End Sub
Private Sub CustomersToolStripMenuItem_Click (By Val sender As System.

Object, By Val e as System.EventArgs)
customerdetails.Show ()
End Sub
Private Sub FlightsToolStripMenuItem_Click(By Val sender As System.

Object, By Val e As System.EventArgs)
flightdetails.Show()
End Sub
End Class
CODING IN ADD NEW CUSTOMER:-

Imports System.Data
Imports System
Imports System.Collections
Imports System.Console
Imports System.Linq
Imports System.Web
Imports System.Data.SqlClient
Public Class customerdetails
Private Sub Button5_Click(By Val sender As System. Object, By Val e As

If TextBox1.Text = "" Or TextBox2.Text = "" Or TextBox7.Text = ""

Or TextBox4.Text = "" Then
MsgBox("fill the information properly")
ElseIf IsNumeric(TextBox1.Text) Then
MsgBox("name should not be numeric")
ElseIf IsInputChar(TextBox4.Text) Then
MsgBox("contct should not be char")
MsgBox(" Father's name should not be numeric")
ElseIf IsInputChar(TextBox6.Text) Then
MsgBox("Insert D_O_B")
MsgBox("address should not be numeric")
Me.Hide()
End If
Dim con As New SqlConnection("server=SAHIL-PC;database=D:\Airline
Reservation System - Copy\Airline Reservation System\data\
dbARS.mdf;Integrated Security=True")
con.Open()
Dim PassportNo As String
PassportNo = Format(DateTime.Now, "yyyyMMddhhmmss")
Label4.Text = PassportNo
Dim cmd As New SqlCommand("insert into customer_dtls

values(@passportno,@custname,@fathername,@d_o_b,@address,@contactno)", con)
cmd.CommandType = CommandType.Text
cmd.Parameters.Add("@passportNo", SqlDbType.VarChar, 50).Value =

PassportNo
cmd.Parameters.Add("@custname", SqlDbType.VarChar, 50).Value =

TextBox1.Text
cmd.Parameters.Add("@fathername", SqlDbType.VarChar, 50).Value =

TextBox2.Text
cmd.Parameters.Add("@d_o_b", SqlDbType.DateTime).Value =
TextBox6.Text
cmd.Parameters.Add("@address", SqlDbType.VarChar, 50).Value =

TextBox7.Text
cmd.Parameters.Add("@contactno", SqlDbType.VarChar, 50).Value =

TextBox4.Text
cmd.ExecuteNonQuery()
cmd.Dispose()
con.Close()
MsgBox("welcome you are now the customer of airline")
End Sub
Private Sub Button1_Click_1(By Val sender As System. Object, By Val e

As System.EventArgs) Handles Button1.Click
mainmenu.Show()
Me.Hide()
End Sub

TextBox1.Clear()
TextBox2.Clear()
TextBox4.Clear()
TextBox6.Clear()
TextBox7.Clear()
End Sub
Private Sub TextBox6_TextChanged(By Val sender As System. Object, By

Val e As System.EventArgs) Handles TextBox6.TextChanged
If TextBox6.Text = "" Then
MsgBox("Insert D_O_B")
End If
End Sub

MsgBox("Insert Address")
End If
End Sub

MsgBox("Insert Contact_No")
End If
End Sub
MsgBox("Insert Father's Name")
End If
End Sub

MsgBox("Insert Your Name")
End If
End Sub
End Class
CODING IN UPDATE CUSTOMER:-

Imports System.Data
Imports System
Imports System.Linq
Imports System.Web
Public Class updatecustomer

System.EventArgs)
Me.Close()
End Sub


con.Open()
Dim adp As SqlDataReader
Dim cmd As New SqlCommand("select * from customer_dtls where

passportNo=" + "'" + ComboBox1.Text + "'", con)
adp = cmd.ExecuteReader()
While adp.Read
TextBox2.Text = adp(1)
End While
adp.Close()
con.Close()
End Sub


con.Open()
Dim cmd As New SqlCommand("Update customer_dtls set CustName=" +

"'" + TextBox2.Text + "'" + "," + "Fathername=" + "'" + TextBox3.Text + "'"
+ "," + "D_O_B=" + "'" + TextBox4.Text + "'" + "," + "Address=" + "'" +
TextBox5.Text + "'" + "," + "ContactNo=" + "'" + TextBox6.Text + "'" +
"where PassportNo=" + "'" + ComboBox1.Text + "'", con)
cmd.Dispose()
con.Close()
MsgBox("updated")
End Sub
Private Sub updatecustomer_Load(By Val sender As System. Object, By Val

e As System.EventArgs) Handles MyBase.Load
con.Open()
Dim cmd As New SqlCommand("select * from customer_dtls", con)
While adp.Read
ComboBox1.Items.Add(adp(0))
End While
adp.Close()
End Sub

mainmenu.Show()
Me.Close()
End Sub
End Class
CODING IN FLIGHT DETAILS:-
Imports System.Data
Imports System
Imports System.Linq
Imports System.Web
Public Class flightdetails

con.Open()
Dim cmd As New SqlCommand("insert into Flight_dtls

values(@flightname,@flightcode,@classname,@totalseats,@flightsource,@flight
destination,@departure,@arrival,@fare)", con)
cmd.Parameters.Add("@flightname", SqlDbType.VarChar, 50).Value =

TextBox1.Text
cmd.Parameters.Add("@flightcode", SqlDbType.VarChar, 50).Value =

TextBox2.Text
cmd.Parameters.Add("@classname", SqlDbType.VarChar, 50).Value =

TextBox3.Text
cmd.Parameters.Add("@totalseats", SqlDbType.VarChar, 50).Value =

TextBox4.Text
cmd.Parameters.Add("@flightsource", SqlDbType.VarChar, 50).Value =

TextBox5.Text
cmd.Parameters.Add("@flightdestination", SqlDbType.VarChar,
50).Value = TextBox6.Text
cmd.Parameters.Add("@departure", SqlDbType.VarChar, 50).Value =

TextBox7.Text
cmd.Parameters.Add("@arrival", SqlDbType.VarChar, 50).Value =

TextBox8.Text
cmd.Parameters.Add("@fare", SqlDbType.VarChar, 50).Value =

TextBox9.Text
cmd.Dispose()
con.Close()
MsgBox("welcome in airline....new flight has been Added")
End Sub
TextBox1.Clear()
TextBox2.Clear()
TextBox3.Clear()
TextBox4.Clear()
TextBox5.Clear()
TextBox6.Clear()
End Sub

mainmenu.Show()
Me.Hide()
End Sub
End Class
CODING IN UPDATE Plane

Imports System.Data
Imports System
Imports System.Linq
Imports System.Web
Public Class Updateplane

System.EventArgs)
Me.Close()
End Sub


con.Open()
Dim cmd As New SqlCommand("Update flight_dtls set flightcode=" +
"'" + TextBox2.Text + "'" + "," + "classname=" + "'" + TextBox3.Text + "'"
+ "," + "totalseats=" + "'" + TextBox4.Text + "'" + "," + "flightsource=" +
"'" + TextBox5.Text + "'" + "," + "flightdestination=" + "'" +
TextBox6.Text + "'" + "where flightname=" + "'" + ComboBox1.Text + "'",
con)
cmd.Dispose()
con.Close()
MsgBox("updated")
End Sub
Private Sub Updateplane_Load(By Val sender As System. Object, By Val e

As System.EventArgs) Handles MyBase.Load

con.Open()
Dim cmd As New SqlCommand("select * from flight_dtls", con)
While adp.Read
End While
adp.Close()
con.Close()
End Sub

con.Open()
Dim cmd As New SqlCommand("select * from flight_dtls where

flightname=" + "'" + ComboBox1.Text + "'", con)
While adp.Read
End While
adp.Close()
con.Close()
End Sub

mainmenu.Show()
Me.Close()
End Sub
End Class
CODING IN TICKET RESERVATION

Imports System.Data
Imports System
Imports System.Linq
Imports System.Web
Public Class Ticketreservation

If ComboBox5.SelectedItem = 5 Then
TextBox17.Text = 5 * TextBox5.Text
ElseIf ComboBox5.SelectedItem = 4 Then
End If
End Sub

System.EventArgs)
Me.Close()
End Sub
Private Sub Ticketreservation_Load(By Val sender As System. Object, By

Val e As System.EventArgs) Handles MyBase.Load

con.Open()

While adp.Read
End While
adp.Close()
con.Close()
End Sub

'' Dim con As New SqlConnection("server=SAHIL-PC;database=D:\

Airline Reservation System - Copy\Airline Reservation System\data\
'con.Open()
'Dim cmd As New SqlCommand("insert into ticket_dtls

values(@ticketNumber,@customername,@Ticketreaservation)", con)
'cmd.CommandType = CommandType.Text
'
' Dim TicketNumber As String
' TicketNumber = Format(DateTime.Now, "yyyyMMddhhmmss")
' Label4.Text = TicketNumber
' cmd.ExecuteNonQuery()
' cmd.Dispose()
' con.Close()
MsgBox("Ticket reserved")
End Sub

mainmenu.Show()
Me.Close()
End Sub

con.Open()
Dim cmd As New SqlCommand("select * from flight_dtls where

flightname=" + "'" + ComboBox1.Text + "'", con)
While adp.Read
End While
adp.Close()
con.Close()
End Sub
End Class
CODING IN TICKET CANCELLATION

Imports System.Data
Imports System
Imports System.Linq
Imports System.Web
Public Class TicketCancellation

TextBox5.Text = TextBox4.Text * 20 / 100
TextBox6.Text = TextBox4.Text - TextBox5.Text
End Sub
System.EventArgs)
Me.Close()
End Sub


con.Open()
Dim cmd As New SqlCommand("select * from Cancel where

TicketNumber=" + "'" + ComboBox1.Text + "'", con)
While adp.Read
End While
adp.Close()
con.Close()
End Sub
Private Sub TicketCancellation_Load(By Val sender As System. Object, By

Val e As System.EventArgs) Handles MyBase.Load

con.Open()
Dim cmd As New SqlCommand("select * from Cancel", con)

While adp.Read
End While
adp.Close()
End Sub


con.Open()
Dim cmd As New SqlCommand("delete from cancel where TicketNumber="

& "'" & ComboBox1.Text & "'", con)
cmd.Dispose()
con.Close()
MsgBox("Ticket Cancelled")
End Sub
End Class
CODING IN TICKET ENQUIRY

Imports System.Data
Imports System
Imports System.Linq
Imports System.Web
Public Class TicketEnquiry

System.EventArgs)
Me.Close()
End Sub

mainmenu.Show()
Me.Close()
End Sub


con.Open()
Dim cmd As New SqlCommand("select * from cancel where

'Dim cmd As New SqlCommand("select * from flight_dtls where

While adp.Read
End While
adp.Close()
con.Close()
End Sub
Private Sub TicketEnquiry_Load(By Val sender As System. Object, By Val

e As System.EventArgs) Handles MyBase.Load
con.Open()
'Dim cmd As New SqlCommand("select * from cancel", con)
While adp.Read
End While
adp.Close()
con.Close()
End Sub
End Class
12.Bibliography
http://www.dreamincode.net/forums/topic/53926-online-examination-system-on-
vbnet/
http://www.seminarprojects.com/Thread-online-examination-project

SOFTPP

Uploaded by

Copyright:

Available Formats

SOFTPP

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

SOFTPP

Uploaded by

Copyright:

Available Formats

WOLAITA SODO UNIVERSITY

DEPARTMENT OF COMPUTER SCIENCE

Airline Management System

Group Members ID. No.

EBRAHIM SEID UGR/54384/13

We are also thankful to my colleagues with whom we have fruitful discussion

Hospital Management Systems are computer software products that

Economically, hospitals benefit from constant cost savings as a result of

College of health science and medicine of wsu is located in wolaita sodo

1.4.1 General objective

1.4.2 Specific objective

 To analyze the existing system.

1.5.1 System Analysis and Design

1.5.2 Data collection methodology

Questionnaires: - By preparing question on hospital and distribute it to

1.6 Scope and Limitation

1.6.1 Scope of the project

It mainly focuses on patients from registering patient up to treating in

 Registration of patient’s information.

1.7 Significant of the Project

1.7.1 For users

1.7.2 For employees

1.7.3 For organizations

 It will manage the data easily.

 It will minimize the response time.

 It will increase the satisfaction of employees.

 It will reduce labor force.

 It will be easily accessible.

 It will enhance data security.

 It will decline overtime payment.

1.8 Feasibility Study

The feasibility study is a management-oriented activity. The objective of a

A feasibility study should provide management with enough information to

 Whether the project can be done.

Feasibility study is an analysis that takes all of a project's relevant factors

1.8.1 Economic Feasibility

1.8.2 Technical Feasibility

1.8.3 Operational Feasibility

1.8.4 Legal feasibility

1.9 System requirement

1.9.1 Hardware requirement

1.9.2 Software requirement

 Edrawmax: - for designing of UML diagrams.

 Sublime Text 3- for encoding scripting languages.

 Adobe Photoshop CS6: is a powerful graphic editing program

1.9.3 Programing language

1.9.4 Cost Estimation

Table 2 cost estimation

Laptop 15,500 00 1 15,500.00

AIRLINES RESERVATION SYSTEM

Airline Reservations Systems contain airline schedules, fare tariffs, passenger

2. Profile of the problem

Disadvantages in existing system :->

a. Maintaining safe records

Methods of data collection and input Structure of Airline:

2 Exiting software METHODOLOGIES

DFD for Present system

 This project solve the problem of the traditional reservation system.

1. It easy to learn and adjust to the system

2. This system does not require the staff to be highly educated