Travel Reservation System

italiansaucyΛογισμικό & κατασκευή λογ/κού

13 Δεκ 2013 (πριν από 3 χρόνια και 10 μήνες)

80 εμφανίσεις

U
niversity of
S
cience and
T
echnology of
C
hina


Travel Reservation System


----
an Attempt
on
Microsoft .NET Platform


Yuan Zhong@1011


PB10011004


zgkdzy@mail.ustc.edu.cn

U
niversity of
S
cience and
T
echnology of
C
hina

Outline


Fundamental Targets


Summary of Design


Database Design


Process Oriented VS. Object Oriented Database System


LINQ to SQL VS. ADO.NET Entity
Framework


View of Travel System Relation
Table


User Interface


User Guide and Presentation


User Guide


Presentation



U
niversity of
S
cience and
T
echnology of
C
hina

Outline


Fundamental
Targets


Summary of Design


Database Design


Process Oriented
VS.
Object Oriented Database System


LINQ to SQL VS. ADO.NET Entity
Framework


View of Travel System Relation Table


User
Interface


User Guide and Presentation


User Guide


Presentation



U
niversity of
S
cience and
T
echnology of
C
hina

Fundamental
Targets


User Friendly


High
Portability


Good scalability


Database Interactivity

U
niversity of
S
cience and
T
echnology of
C
hina

Outline


Fundamental Targets


Summary of
Design


Database Design


Process Oriented or Object Oriented Database System


LINQ to SQL VS. ADO.NET Entity
Framework


View of Travel System Relation Table


User
Interface


User Guide and Presentation


User Guide


Presentation



U
niversity of
S
cience and
T
echnology of
C
hina

Summary of Design


Based on Microsoft .NET
4.0 Platform


IDE: Microsoft Visual Studio 2012


Database System: Microsoft SQL Server 2012


User Interface:
WPF(Windows Presentation
Foundation)


Programming
Language: C Sharp


Database
Type
: OODBS and ORM Design


Linking to Database: LINQ to SQL



U
niversity of
S
cience and
T
echnology of
C
hina

Outline


Fundamental Targets


Summary of Design


Database Design


Process Oriented or Object Oriented Database System


LINQ to SQL VS. ADO.NET Entity
Framework


View of Travel System Relation Table


User
Interface


User Guide and Presentation


User Guide


Presentation



U
niversity of
S
cience and
T
echnology of
C
hina

PODBS
VS.
OODBS


Potential
Merits

of OODBS:


Good i
nheritance, encapsulation and polymorphism


Less
code for object oriented applications


Provide Object/Relation Mapping(ORM) mechanism


Easier to handle



Potential Drawbacks of OODBS:


Lower
efficiency with simple data and relationships


Late
binding may slow access speed


Less stable standards for OODBS

U
niversity of
S
cience and
T
echnology of
C
hina

LINQ to SQL VS. ADO.NET Entity Framework

4
/32


Some Significant Differences

U
niversity of
S
cience and
T
echnology of
C
hina

View of Travel System Relation Table

U
niversity of
S
cience and
T
echnology of
C
hina

Outline


Fundamental
Targets


Summary of Design


Database Design


Process Oriented or Object Oriented Database System


LINQ to SQL VS. ADO.NET Entity
Framework


View of Travel System Relation
Table


User Interface


User Guide and Presentation


User
Guide


Presentation


2
/32

U
niversity of
S
cience and
T
echnology of
C
hina

User Interface


Microsoft Windows WPF GUI application:


An
easy way
to
bound data source
with UI
elements


High development efficiency than MFC
and
WinForm


Windows 8 Metro Style




Excellent Color Coordination



U
niversity of
S
cience and
T
echnology of
C
hina

Outline


Fundamental
Targets


Summary of Design


Database Design


Process Oriented or Object Oriented Database System


LINQ to SQL VS. ADO.NET Entity Framework


User Interface


User Guide and Presentation


User
Guide


Presentation


U
niversity of
S
cience and
T
echnology of
C
hina

User Guide



Travel Plan Designer”
for users while “Database
Management Studio
” for administrator


In the Travel Plan Designer Window
:


“Hotels” “Cars” “Flights

for showing relation tables


Deletion should select a tuple and type
“Delete”
button


“Reservation” button for making reservations


In
the Database Management Studio Window
:


Login first


“Hotels” “Cars” “Flights” “
Custs
” for showing relation tables


Implement insertion or update directly on tables


Deletion should select a tuple and type “Delete” button.


U
niversity of
S
cience and
T
echnology of
C
hina

User Guide


In the
Travel Plan Designer Reservations Window


“Hotels” “Cars” “Flights” for showing
available relation
tables


Combobox

for selecting location, travel source and travel
destination


After operations in
Combobox
, typing “Query” button for
query



Confirm
” button for acknowledging
reservations


“Check” button for the Integrity of Customers’
Travel Route


Equals to whether the graph is connected Euler Circuit


Equals to that the degrees of each vertex are even

U
niversity of
S
cience and
T
echnology of
C
hina

Presentation


MainWindow

U
niversity of
S
cience and
T
echnology of
C
hina

Presentation


Database Management Studio Login:

U
niversity of
S
cience and
T
echnology of
C
hina

Presentation


Database Management Working Interface:

U
niversity of
S
cience and
T
echnology of
C
hina

Presentation


Travel Plan Designer Login and Register

U
niversity of
S
cience and
T
echnology of
C
hina

Presentation


Travel Plan Designer
Working Interface

U
niversity of
S
cience and
T
echnology of
C
hina

Presentation


Travel Plan Designer Reservation Interface

U
niversity of
S
cience and
T
echnology of
C
hina

Yuan

Zhong@1011


PB10011004