Aim:

The aim of this .NET Application is to develop an ASP.NET 3.5 Web Application using Microsoft Visual Studio 2008, SQL Server 2008 and Crystal Report.

Problem Description:

Aim of this assignment is to develop a web application that can be used to keep track of the patients registering in a hospital.
Also, this system should support features such as- accessing the previous visit histories of any patient, search for patients by name and other attributes, etc.

Explanation of some frequently used terms for this system-

1. Patient - a patient is the person who visits the hospital for treatment/consultation
2. Doctor - a doctor will be assigned to each patient.
3. Bed - if patient type is "In Patient", a bed will be assigned to the user.
4. Visit - a patient can visit the hospital any number of times.

Some of the most general requirements of the system are:

• Registration of patients
• Users are either normal users or admin; they need to login before using the system
• Users of this system can search for patients by name, admission date and discharge
date
• Users can view the previous visit histories of any patient
• System can maintain the list of doctors in the hospital
• System can maintain the list of beds/rooms available in the hospital
• Patients can be categorised into "In Patients" and "Out Patients"


Our Web system has the following basic pages

1. Login page for the booking staff
Home Page for the hospital- this page should contain some details about the hospital with a banner at the top.
2. Site Map- This page is the gateway to the website and should depict the
website structure and it should contain click-able links to all the pages.
3. Privacy Policy- Has all the copyright and privacy policy information. Any
website that deals with credit card transactions has to have one of these.

Following basic pages/screens are used with use of ADO.NET for data operations):

Patient List
(both “in” and “out”)
• Data control displays the list of registered patients.
• Staff’s are able to enter the full of a patient to filter the list of patients.
• It is also possible to filter patient list by DateofRegistration.

Patient Registration
• This screen allows add/edit patient registration. We had used a Grid View for this purpose

Patient Visits
• This screen displays the list of patient visits.
• The details of patient visits can also be filtered by patient name, date of visit and date of discharge.

Doctors List
• This screen displays the list of all available doctors.

For the above pages we had used the proper Validations, Themes and User Controls.


This part of the web system will be accessed by the admin (username: admin, password: admin).

Following admin pages are added to the system:
DoctorPatientInfo

This page has the following features-
• Assign a doctor to a patient,
• Treatment history of each doctor (i.e. which patient he/she has treated in past and/or is treating)

Edit Doctor
• Add/Edit doctors

For all these pages we had used ADO.NET

The themes for admin pages are different from Staff Pages.


We had used LINQ to code the following additional admin pages:

Bed List
• This screen uses a grid view to display the list of all available beds in the hospital.
• Add/Edit bed information

DischargeInPatient
• A page that calculates amount payable by the “in-patient” upon discharge.
• Presenting of an Invoice and change of status (patient-discharged) in the database.


Apart from that we had implemented:

1. Some AJAX controls to any of the above pages.
2. Changed the admin login functionality:
We are storing the admin password in an encrypted format in the database. Now the admin login code is reading an encrypted password.
3. Used the Crystal Report to the project that displays the following statistics:
• Top 5 doctors (in terms of how many patients have they treated?)
• A graphical element to the report to visually display the above information


We had also attached all the databases and Stored Procedures that we had used in our Application and some of the related files associated with the Application.


Last edited Oct 7, 2010 at 9:50 AM by pgargaupp, version 1

Comments

hpbaotho Dec 26, 2013 at 4:38 AM 
an I get the source code??

developersubhas Jan 10, 2013 at 6:26 AM 
thanks a lot great work....god bless you.

orangmuda Feb 24, 2012 at 2:37 AM 
can I get the source code??