A fully featured Clinic Management System based on three tier architecture made using ASP.NET, C# with a well documented information. This application is developed by one of our contributor Haris Muneer.
Technologies Used in Clinic Management System:
For Frontend: HTML, CSS, BootStrap, JavaScript
For Backend: C#, ASP.NET
For Database: SQL
Pre-requisites:
Features of Clinic Management System:
1. Patient:
- 1. Patient Home – Patient can view his profile
- 2. Current Appointment – Patient can view if he has some pending or approved appointment with a doctor
- 3. Bills History – Patient can view the bill history of appointments that have been completed
- 4. Treatment History – Patient also has the permission to view the treatment history of appointments which have been marked as completed
- 5. Take Appointment – The patient also has the permission to view all the departments and then can select one department. Then, all the doctors of that concerned department are shown. Then the patient selects one doctor and the doctor’s profile is then shown along with a ‘make an appointment’ button. When the button is clicked, the free slots of that particular doctor are shown. The patient then proceeds to choose and selecte a free slot and then sends a request for that free slot to the doctor. The doctor will then approve/reject it.
- 6. Notifications – In this tab, a notification is shown whenever the doctor accepts/rejects the requested appointment.
- 7. Feedback – After a appointment is completed, patient can give feedback about that appointment by rating it from 1 – 5
- 8. A patient can request for only one appointment at a time and will not be allowed to take more than one appointments until the last appointment has been completed.
2. Doctor:
- 1. Doctor Profile: Doctor can see his own profile
- 2. Pending Appointments: Doctor can view all the pending appointments that have been made against his doctor ID.
- 3. Todays Appointmemts: Doctor can see all the appointments for current day and can select/reject any appointment of that day
- 4. History Update: Doctor can update the prescription,disease and progress of patient.
- 5. Generate Bill: He will then generate the bill
- 6. Patient History: Doctor will be able to see the treatment history of all his treated patients.
3. Administrator:
- 1. Admin Home: Admin can view Clinic stats which includes weekly appointments, income of the Clinic. No of registered patients and doctors along with the list of departments
- 2. View Doctors: Admin can view the list of doctors currently registered along with their departments and other information. Complete profile will be shown when clicked.
- 3. View Patients: Admin also has the permission to view the list of patients currently registered in the program along with their phone numbers and ids. Complete profile will be shown when clicked.
- 4. View Other Staff: Admin can view other staff members along with their designations.
- 5. Search Box: Admin can if needed, search for a specific employee within the company by the name.
- 6. Add/Remove: Admin can also Add/remove doctors, patients and other staff members registered in the system from the clinic.
How to Run
1- Install the following:
2- Open SQL Server Management Studio and in the “Connect to Database Engine” window type the following:
Servername: .\SQLEXRPESS
Authentication: Windows Authentication 3- Now open Schema.sql file in Database Files folder and execute it all. This will create the database and the tables. Afterwards execute the following sql files: Admin.sql, Doctor.sql, Patient.sql, Signup.sql.
4- Now execute the Insertions.sql file in Database Files folder. This will populate the database with some test entries. Moreover, some login emails and passwords of doctors, patients and admin are placed in the Insertions.sql file. You can use them to test the functionalities of the system.
5- Everything is setup now! You can run the Visual Studio Project by opening Clinic Management System.sln and then select the SignUp.aspx page and click run button named IIS Express.
If you need to download Microsoft Visual Studio(recommended) on your PC, follow this video:
FIND MORE on this site.
DOWNLOAD Clinic Management System using C# With Source Code FOR FREE
