Hospital Management System (HMS)

A Desktop Application using C#, Windows Forms and Oracle Database.

Description

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).

Prerequisites

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

Project Related

Resource	Link
Project Issues on GitHub	Link
Project Pull Requests on GitHub	Link
Project Questions on Stack Overflow	Link

Getting into the project

ERD

Schema

🔸 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.

Other Screenshots

Reports

Bills

Pharmacy

Medical Staff Data

Change Password

Show Patients