Skip to content

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

Notifications You must be signed in to change notification settings

Abanoub-Asaad/HospitalMS

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 

Repository files navigation

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

ERD

Schema

Schema

🔸 Database SQL Script
🔸 Database Procedures

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

Screenshot (180)

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

Screenshot (182)

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

Screenshot (185)

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

Screenshot (188)

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

Screenshot (191)

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

Screenshot (196)

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

Screenshot (199)

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

Screenshot (203)

Other Screenshots

Reports

ReportForm DisplayReports

Bills

DisplayBillsForm

Pharmacy

PharmacyForm

Medical Staff Data

UserDataForm

Change Password

ChangePasswordForm

Show Patients

PatientsForm

About

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

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •  

Languages