Presentation Transcript

1. Travel Reservation System ----an Attempt on Microsoft .NET Platform Yuan Zhong@1011 PB10011004 zgkdzy@mail.ustc.edu.cn
2. 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
3. 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
4. Fundamental Targets User Friendly High Portability Good scalability Database Interactivity
5. 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
6. 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
7. 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
8. PODBS VS. OODBS Potential Meritsof OODBS: Good inheritance, 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
9. LINQ to SQL VS. ADO.NET Entity Framework Some Significant Differences 4/32
10. View of Travel System Relation Table
11. 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
12. 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
13. 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
14. 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.
15. 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
16. Presentation MainWindow
17. Presentation Database Management Studio Login:
18. Presentation Database Management Working Interface:
19. Presentation Travel Plan Designer Login and Register
20. Presentation Travel Plan Designer Working Interface
21. Presentation Travel Plan Designer Reservation Interface
22. Thank You! Yuan Zhong@1011 PB10011004