- 📙 overview
- 💻 Get Started
- 🔨 Built Using
- 📷 Demo Screenshots
- 📽 GIF Demo
- 🧱 File Structure
- ✨ Contributors
- A windows application for a train station DBMS. A train station DBMS that imitates a real transportation system. It is made to overcome manual errors of booking and make it into a computerized system. The train station manager can easily manage the station through the system, manage employees and schedule trips.
- It has all the schedules of the trains available. From which passengers, who wish to travel, can go to the booking employee to book a ticket or book it through the application.
- Passengers can also view, cancel or upgrade their ticket, address complaints...etc.
- The database system helps to maintain all the records of different train trips, available seats and passengers in an easy way.
- Clone the repository
git clone https://github.com/EslamAsHhraf/Train-Station - you will need to download SQL Server Management Studio (SSMS)
- Excute CreateDatabaseQuery to create Data Base
- Excute InsertValues to fill Data Base
- Do stepsAccessing DB from C# App to link Data Base with application
- Excute all files in Stored Procedures
- Read Report to undertand well how to use application
- Windows form application
- my sql
Train-Station
├── Stored Procedures
│ ├── Change_Department.sql
│ ├── Change_Rate.sql
│ ├── Change_Salary.sql
│ ├── Dno_Department.sql
│ ├── Employee_data.sql
│ ├── ID_Station.sql
│ ├── Insert_Trip.sql
│ ├── SSN_Employee.sql
│ ├── SSN_Passenger.sql
│ ├── get_tele_E.sql
│ └── get_tele_psql.sql
├── images
│ ├── cover.jpg
│ └── cover.png
├── TrainStation
│ ├── Admin_forms
│ │ ├── Add_admin.Designer.cs
│ │ ├── Add_admin.cs
│ │ ├── Add_admin.resx
│ │ ├── Block_.Designer.cs
│ │ ├── Block_.cs
│ │ ├── Block_.resx
│ │ ├── Remove_admin.Designer.cs
│ │ ├── Remove_admin.cs
│ │ └── Remove_admin.resx
│ ├── Employee_forms
│ │ ├── CancelTicket.Designer.cs
│ │ ├── CancelTicket.cs
│ │ ├── CancelTicket.resx
│ │ ├── TicketBooking.Designer.cs
│ │ ├── TicketBooking.cs
│ │ ├── TicketBooking.resx
│ │ ├── TrainStatus.Designer.cs
│ │ ├── TrainStatus.cs
│ │ ├── TrainStatus.resx
│ │ ├── UpdateMyData.Designer.cs
│ │ ├── UpdateMyData.cs
│ │ ├── UpdateMyData.resx
│ │ ├── UpgradeTicket.Designer.cs
│ │ ├── UpgradeTicket.cs
│ │ ├── UpgradeTicket.resx
│ │ ├── ViewPassengerData.Designer.cs
│ │ ├── ViewPassengerData.cs
│ │ ├── ViewPassengerData.resx
│ │ ├── ViewSeats.Designer.cs
│ │ ├── ViewSeats.cs
│ │ ├── ViewSeats.resx
│ │ ├── ViewTicketDetails.Designer.cs
│ │ ├── ViewTicketDetails.cs
│ │ ├── ViewTicketDetails.resx
│ │ ├── ViewTrips.Designer.cs
│ │ ├── ViewTrips.cs
│ │ ├── ViewTrips.resx
│ │ ├── updatePassengerData.Designer.cs
│ │ ├── updatePassengerData.cs
│ │ └── updatePassengerData.resx
│ ├── Manager_forms
│ │ ├── Change_Deb.Designer.cs
│ │ ├── Change_Deb.cs
│ │ ├── Change_Deb.resx
│ │ ├── Change_Salary.Designer.cs
│ │ ├── Change_Salary.cs
│ │ ├── Change_Salary.resx
│ │ ├── Change_rate.Designer.cs
│ │ ├── Change_rate.cs
│ │ ├── Change_rate.resx
│ │ ├── Employees_data.Designer.cs
│ │ ├── Employees_data.cs
│ │ ├── Employees_data.resx
│ │ ├── Fire_employee.Designer.cs
│ │ ├── Fire_employee.cs
│ │ ├── Fire_employee.resx
│ │ ├── Hire_Employee.Designer.cs
│ │ ├── Hire_Employee.cs
│ │ ├── Hire_Employee.resx
│ │ ├── Passengers_data.Designer.cs
│ │ ├── Passengers_data.cs
│ │ ├── Passengers_data.resx
│ │ ├── Schedule_trips.Designer.cs
│ │ ├── Schedule_trips.cs
│ │ └── Schedule_trips.resx
│ ├── Passenger forms
│ │ ├── Add_PhoneNumber.Designer.cs
│ │ ├── Add_PhoneNumber.cs
│ │ ├── Add_PhoneNumber.resx
│ │ ├── Book_Ticket.Designer.cs
│ │ ├── Book_Ticket.cs
│ │ ├── Book_Ticket.resx
│ │ ├── Cancel_Ticket.Designer.cs
│ │ ├── Cancel_Ticket.cs
│ │ ├── Cancel_Ticket.resx
│ │ ├── Change_Email.Designer.cs
│ │ ├── Change_Email.cs
│ │ ├── Change_Email.resx
│ │ ├── Change_Password.Designer.cs
│ │ ├── Change_Password.cs
│ │ ├── Change_Password.resx
│ │ ├── Change_PhoneNumber.Designer.cs
│ │ ├── Change_PhoneNumber.cs
│ │ ├── Change_PhoneNumber.resx
│ │ ├── Edit_Profile.Designer.cs
│ │ ├── Edit_Profile.cs
│ │ ├── Edit_Profile.resx
│ │ ├── Make_Complaint.Designer.cs
│ │ ├── Make_Complaint.cs
│ │ ├── Make_Complaint.resx
│ │ ├── Ticket_Details.Designer.cs
│ │ ├── Ticket_Details.cs
│ │ ├── Ticket_Details.resx
│ │ ├── Upgrade_Ticket.Designer.cs
│ │ ├── Upgrade_Ticket.cs
│ │ └── Upgrade_Ticket.resx
│ ├── Properties
│ │ ├── AssemblyInfo.cs
│ │ ├── Resources.Designer.cs
│ │ ├── Resources.resx
│ │ ├── Settings.Designer.cs
│ │ └── Settings.settings
│ ├── Resources
│ │ ├── 1419767.jpg
│ │ ├── Back-Ground.jpg
│ │ ├── 6108b580.jpg
│ │ ├── michal-parzuchowski-dmH3NWhYTHQ-unsplash.jpg
│ │ ├── michal-parzuchowski-dmH3NWhYTHQ-unsplash1.jpg
│ │ └─railway-station-platform-with-modern-high-speed-trains-clock_273525-355.jpg
│ ├── Admin.Designer.cs
│ ├── Admin.cs
│ ├── Admin.resx
│ ├── App.config
│ ├── Controller.cs
│ ├── Create_acc.Designer.cs
│ ├── Create_acc.cs
│ ├── Create_acc.resx
│ ├── DBManager.cs
│ ├── Employee.Designer.cs
│ ├── Employee.cs
│ ├── Employee.resx
│ ├── Handle.cs
│ ├── Manager.Designer.cs
│ ├── Manager.cs
│ ├── Manager.resx
│ ├── Passenger.Designer.cs
│ ├── Passenger.cs
│ ├── Passenger.resx /9/1419767
│ ├── Program.cs
│ ├── StoredProcedures.cs
│ ├── TrainStation.csproj
│ ├── TrainStation.csproj.user
│ ├── TrainStation.sln
│ ├── UserLog.Designer.cs
│ ├── UserLog.cs
│ └── UserLog.resx
├── Accessing DB from C# App.pdf
├── CreateDatabaseQuery.sql
├── InsertValues.sql
├── Lincense
├── README.md
├── Report .pdf
└── Schema.png
 Sarah Elzayat |
 Yasmine Ghanem |
 Yasmin Elgendi |
 Eslam Ashraf |