How tuncerozcan90/flight-ticket-automation works
This is a Windows Forms flight-ticket sales application backed by PostgreSQL. Users can browse and select flights, proceed through passenger and payment details to create a ticket, then view or cancel bookings; account registration, sign-in, profile management, and password recovery are additional workflows. Program starts the Main form, which navigates to the application screens. NpgDB centralizes database operations, while the SQL script defines the database-side procedures and functions. Several screen capabilities are documented in the README but their full implementation was not sampled.
Main entry points: Main.cs Main Menu · NpgDB.cs Database Operations · ManageBooking.cs Manage Booking · Flight.cs Flight Search
Components 13
Application Navigation
- Application Entry
Visual Studio/Program.cs - Main Menu
Visual Studio/Main.cs
Accounts and Profile
- Sign In
Visual Studio/SignIn.cs - Sign Up
Visual Studio/SignUp.cs - Password Recovery
Visual Studio/Forgot.cs - Profile
Visual Studio/Profile.cs
Flights and Booking
- Flight Search
Visual Studio/Flight.cs - Booking Details
Visual Studio/Booking.cs - Passenger and Payment
Visual Studio/Booking2.cs - Manage Booking
Visual Studio/ManageBooking.cs
Database Access
- Database Operations
Visual Studio/NpgDB.cs - PostgreSQL
PostgreSQL/flight-ticket-automation.sql
Other components
- Customer
Connections 19
- Application Entry → Main Menu: starts
Visual Studio/Program.cs - Customer → Main Menu: uses
- Main Menu → Sign In: opens
Visual Studio/Main.cs - Main Menu → Sign Up: opens
Visual Studio/Main.cs - Main Menu → Profile: opens
Visual Studio/Main.cs - Main Menu → Flight Search: opens
Visual Studio/Main.cs - Main Menu → Booking Details: opens
Visual Studio/Main.cs - Main Menu → Manage Booking: opens
Visual Studio/Main.cs - Sign In → Database Operations: checks credentials
Visual Studio/SignIn.cs - Sign Up → Database Operations: saves account
Visual Studio/SignUp.cs - Password Recovery → Database Operations: retrieves password
Visual Studio/Forgot.cs - Profile → Database Operations: reads profile
Visual Studio/Profile.cs - Booking Details → Passenger and Payment: opens details
Visual Studio/Booking.cs - Passenger and Payment → Database Operations: saves ticket and passenger
Visual Studio/Booking2.cs - Manage Booking → Database Operations: cancels ticket
Visual Studio/ManageBooking.cs - Manage Booking → PostgreSQL: reads ticket view
Visual Studio/ManageBooking.cs - Database Operations → PostgreSQL: executes database operations
Visual Studio/NpgDB.cs - Flight Search → Booking Details: continues booking
Visual Studio/Flight.cs - Customer → Flight Search: searches flights
README.md