Horas Management System is a Hospital Management System using C#, Windows Forms and Oracle Database.

The HMS is organized into clinics. Each clinic has a name, working hours and floor number. We keep track of :

• Medical Staff (first and last name, age, gender, specialization, shifting time, year of employment, and contact number). The Medical Staff Includes [Doctors - Receptionists]
• Patient (National ID number, full name, conditional illness, responsible doctor, and the room he stayed at)
• The current available Medicine (code number, name, quantity, and price).

1. Install Visual Studio
2. Install Crystal Reports with the same version of VS
3. Any Oracle Database.

🔸 Database SQL Script
🔸 Database Procedures

’Login’ Page where the Doctors & Receptionists can login into their accounts.

’Register’ Page allows Doctors & Receptionists to register and make an account, all fields have validation checkers.

’Doctor Part’ consists of 4 pages:

1. Home, where the doctor can show all the reports that he has made
2. My Data, where he can edit any thing related to his profile like the name, shift time or ...
3. My Clinic
4. Add Report.

’Clinic’ Page, where the doctor can show the clinic name, working hours or display all the other clinics.

’Add Report’ Page, Each doctor writes a detailed Report for each patient describing the medicines which the patient took, the duration patient spent and his conditional illness.

’Receptionist Part’ consists of 5 pages:

1. Home, where the receptionist can show all the bills of the patients
2. My Data, where he can edit any thing related to his profile like the name, shift time or ...
3. Make an Appointment
4. Make a Bill
5. Show Rooms.

’Make an Appointment’ Page, where the receptionist can make an appointment between the doctor and the patient.

’Make a Bill’ Page, where the receptionist makes a bill contains the patient name, medicine and cost.

’Show Rooms’ Page, where the receptionist shows all the rooms. Each room has a unique number, floor number, number of all beds and taken beds.