HOSPITAL MANAGEMENT SYSTEM

TABLE OF CONTENT
Chapter 1: INTRODUCTION
1.1 Introduction
1.2 Objective
1.3 Purpose
1.4 Scope
Chapter 2: SURVEY OF TECHNOLOGIES
Chapter 3: REQUIREMENTS AND ANALYSIS
3.1 Problem Definition
3.2 Project planning and scheduling
3.3 Project Management Life Cycle
3.4 Project Plan
3.5 Schedule Representation
3.6 Hardware & Software Requirement .
3.7 Preliminary Investigation
Chapter 4: SYSTEM DESIGN
4.1 UML Diagram
4.2 Data Flow Diagram
4.3 E-R Diagram
Chapter 5: IMPLEMENTATION AND TESTING
5.1 System Implementation
5.2 Coding
5.3 System Testing
5.4 Test Case
Chapter 6: RESULTS AND DISCUSSION
6.1 Test Reports
Chapter 7: CONCLUSIONS
7.1 Conclusion
7.2 Future Scope
7.3 References
HOSPITAL MANAGEMENT SYSTEM

1.1 INTRODUCTION

The Hospital Management System (HMS) is designed for Any Hospital to replace their
existing manual, paper based system. The new system is to control the following
information; patient information, room availability, staff and operating room schedules,
and patient invoices. These services are to be provided in an efficient, cost effective
manner, with the goal of reducing the time and resources currently required for such tasks.
A significant part of the operation of any hospital involves the acquisition, management
and timely retrieval of great volumes of information. This information typically involves;
patient personal information and medical history, staff information, room and ward
scheduling, staff scheduling, operating theater scheduling and various facilities waiting
lists. All of this information must be managed in an efficient and cost wise fashion so
that an institution's resources may be effectively utilized HMS will automate the
management of the hospital making it more efficient and error free. It aims at standardizing
data, consolidating data ensuring data integrity and reducing inconsistencies.
 HOSPITAL MANAGEMENT SYSTEM

1.2OBJECTIVE:
Hospitals currently use a manual system for the management and maintenance of
critical information. The current system requires numerous paper forms, with data stores
spread throughout the hospital management infrastructure. Often information (on forms) is
incomplete, or does not follow management standards. Forms are often lost in transit between
departments requiring a comprehensive auditing process to ensure that no vital information is
lost. Multiple copies of the same information exist in the hospital and may lead to
inconsistencies in data in various data stores.
A significant part of the operation of any hospital involves the acquisition,
management and timely retrieval of great volumes of information. This information
typically involves; patient personal information and medical history, staff information,
room and ward scheduling, staff scheduling, operating theatre scheduling and various
facilities waiting lists. All of this information must be managed in an efficient and cost
wise fashion so that an institution's resources may be effectively utilized HMS will
automate the management of the hospital making it more efficient and error free. It aims
at standardizing data, consolidating data ensuring data integrity and reducing
inconsistencies.

Main objectives of a Hospital Management System are:

Design a system for better patient care.

Reduce hospital operating costs.

Provide MIS (Management Information System) report on demand to management for better
decision making.

Better co-ordination among the different departments.

Provide top management a single point of control.

Hospital management System handles activities of major departments in a hospital like:

1.Front Office/OPD Management

2. Patient management (scheduling, registration and long-term care)

3.Patient care management and departmental modules (radiology, pharmacy and pathology
labs)

4. Investigative Labs
HOSPITAL MANAGEMENT SYSTEM

5. Billing

6. Medical Stores

7.Financial Accounting (billing, insurance processing, materials management, accounts

payable/receivable, payroll and general ledger)

8. Payroll
HOSPITAL MANAGEMENT SYSTEM

1.3Purpose

The purpose is to describe all the requirements for the Hospital Management System. The
following are some of the stake holders: • administrative staff • doctors • nurses • surgeons •
developers.

The hospital management and its team members uses this document as the primary means to
communicate confirmed requirements to the development team. The development team
expects many face-to-face conversations that will undoubtedly be about requirements and
ideas for requirements. However only the

requirements that appear in this document or a future revision, will be used to define the
scope of the system.
HOSPITAL MANAGEMENT SYSTEM

1.4 Scope
The software product is the Hospital Management System. The system will be used to
allocate beds to patients on a priority basis, and to assign doctors to patients in designated
wards as need arises. Doctors will also use the system to keep track of the patients assigned to
them. Nurses who are in direct contact with the patients will use the system to keep track of
available beds, the patients in the different wards, and the types of medication required for
each patient. Doctors must make rounds to pick up patients’ treatment cards in order to know
whether they have cases to treat or not. The intentions of the system are to reduce over-time
pay and increase the number of patients that can be treated accurately. Requirements
statements in this document are both functional and non-functional. Definitions,
Acronyms, and Abbreviations PHN Personal Health Number on health card Report an
account of patients Database Collection of information in a structured form Front-desk staff
Administrative staff that work at reception desk Logon ID. A user identification number to
enter the system Password A word that enables one to gain admission into the system ID
Patient Identification number GUI Graphical User Interface

SRS Software Requirements Specification General Description Product Perspective This

Hospital Patient Management System is a self-contained system that manages activities of the
hospital as bed assignment, operations scheduling, personnel management and administrative
issues. Various stakeholders are involved in the hospital system. Product Functions The
system functions can be described as follows: Registration: When a patient is admitted, the
front-desk staff checks to see if the patient is already registered with the hospital. If he is,
his/her Personal Health Number (PHN) is entered into the computer. Otherwise a new
Personal Health Number is given to this patient. The patient’s information such as date of
birth, address and telephone number is also entered into computer system. Consultation: The
patient goes to consultation-desk to explain his/her condition so that the consulting nurse can
determine what kind of ward and bed should be assigned to him/her. There are two possible
circumstances: a) If there is a bed then the patient will be sent to the bed to wait for the doctor
to come. b) If there is no bed, the patient is put on a waiting list until a bed becomes
available. Patient check out. If a patient checks out, the administrative staff shall delete his
PHN from the system and the just evacuated bed is included in available-beds list.

Report Generation: The system generates reports on the following information: patients, bed
availability and staff schedules after every six hours. It prints out all the information on who
has used which bed, when and the doctor that is taking care of a given patient as well as
expected medical expenses.
HOSPITAL MANAGEMENT SYSTEM

Chapter 2: Survey of Technologies

Software used to compete a project –

Visual Studio 2016 contains a variety of tools for developing business applications.
SharePoint developers will find new designers for list and content types, new templates for
site columns and Silverlight web pages, as well as new options for deploying Share Point
sites. ALM features like performance profiling, unit testing, and IntelliTrace are now
available for SharePoint development. Client-side development has been improved as well,
with support for JavaScript debugging and IntelliSense. LIGHTSWITCH is a powerful tool
available for building business applications for the Desktop and the Cloud. Starting in
Visual Studio 2012, LIGHTSWITCH is available as part of the Visual Studio Professional,
Premium and Ultimate installations.
LIGHTSWITCH includes a variety of improvements such as a new theme, the ability to
access data from any OData source as well as create OData services, Active Directory
integration, and new business types.

The AWS Toolkit for Visual Studio is an extension for Microsoft Visual Studio running
on Microsoft Windows that makes it easier for developers to develop, debug, and deploy
.NET applications using Amazon Web Services. With the AWS Toolkit for Visual Studio,
you'll be able to get started faster and be more productive when building AWS
applications.

The AWS Toolkit for Visual Studio is available via the Visual Studio Marketplace and
supports Visual Studio 2017 and 2019. The AWS Toolkit for 2013 and 2015 is contained in
the AWS SDK and Tools for .NET install package.

Frame work and language used in Front end and Back end
Asp.net –ASP.net is an open source webframework,created by micrsoft for building modern
web

apps and services with .NET ASP.NET is cross platofrom and run on

windows,linux,macOS and Docker

The .NET platform

.NET is a developer platform made up of tools, programming languages, and libraries for
building many different types of applications.
HOSPITAL MANAGEMENT SYSTEM

The base platform provides components that apply to all different types of apps.
Additional frameworks, such as ASP.NET, extend .NET with components for building
specific types of apps.

ASP.NET extends .NET

ASP.NET extends the .NET platform with tools and libraries specifically for
building web apps.

These are some things that ASP.NET adds to the .NET platform:
 HOSPITAL MANAGEMENT SYSTEM

CHAPTER 3: -REQUIREMENT AND

ANALYSIS

3.1PROBLEM DEFINITION:
This project is all about hospital and its management. This project is to manage the
employees including doctors, patients, wards and Hospital services provided in a renounced
Hospital. This program also provides immediate accessories needed while the hospital
management. This also provides the landmark of hospital, where it is located. This complex
project has the scope of adding new employee’s doctors admitting outpatients, fixing
appointments etc. This project also displays the services provided to outpatient.
INTERFACES:

1. Welcome interface Login interface

2. MDI main interface Application interface Doctor interface
3. Employees interface Ward interface
4. Outpatient interface Services interface

WELCOME INTERFACE:
In welcome interface, it includes just a progressing, intimates that the administrator is
getting in the management program.

LOGIN INTERFACE:
In login interface, we provide authorization to the user getting in.

MDI MAIN INTERFACE:

The multiple document interface, provides base screen for all management program
actions present in the management program. It contains menu bar which list the
manipulation forms for management.

APPLICATION INTERFACE:
Application interface provides the basic accessories that is required for certain
essential operations.

DOCTOR INTERFACE:
This interface provides us the facilities such as viewing doctor's details including his/her
id, qualification and specialization, address etc. It also displays the list of doctors
present in various departments. We can search a doctor by his id and then view his details.
This interface also provides us the facility to add new doctors in.
EMPLOYEES INTERFACE:

This interface provides us the facilities such as viewing employee's details including his/her
id, qualification, address etc. It also displays the list of employees present in various
departments. We can search an employee by his id and then view his details. This interface
also provides us the facility to add new employees in.
WARD INTERFACE:
This interface provides us the details about wards and the habited patients in those wards.

OUTPATIENT INTERFACE:
This interface provides us the information about the outpatients, what for they are in,
appointments with doctor, bill details, time they are in etc.

SERVICES INTERFACE:
This interface provides us the information about the services present in that hospital, which
time they are scheduled to be open, and the incharge administrator.
HOSPITAL MANAGEMENT SYSTEM

3.2Project planning and scheduling

Project planning is part of project management, which relates to the use of schedules such
as Gantt charts to plan and subsequently report progress within the project environment.
Initially, the project scope is defined and the appropriate methods for completing the
project are determined. Following this step, the durations for the various tasks necessary to
complete the work are listed and grouped into a work breakdown structure. The logical
dependencies between tasks are defined using an activity network diagram that enables
identification of the critical path.

Methodology

We have used Iterative and Incremental Development model (IID) for our project
development. This

development approach is also referred to as Iterative Waterfall Development approach.

Iterative and Incremental Development is a software development process developed in
response to the more traditional waterfall model. This model is designed to take care of
such big project. The large and complicate project chiefly demand better development and
testing procedure. The waterfall model is well known for its repeated testing process.
Hence I choose the waterfall model for developing my software.

Fig. : Waterfall model

Some advantages of waterfall model:

o Simple and easy to understand and use. o Easy to manage due to the
rigidity of the model. o Phases are processed and completed one at a time
o Works well for smaller projects where requirements are very well
understood.
HOSPITAL MANAGEMENT SYSTEM

3.3Project Management life cycle

The Project Management Life Cycle has four phases. Each project life cycle phase is
described along with the tasks need to complete it

The four phases is

1. Initiation

2. Planning

3. Execution

4. Closure.

Fig. : Iterative and Incremental Life

Cycle
HOSPITAL MANAGEMENT SYSTEM

3.3Project Plan:
Once we examine that the project is feasible, I undertake project planning. The table below
describes how we planned my project.

Table Project Plan

1 Task Name Duration

2 Planning 10 days

3 Design 30days

4 Coding 25days

5 Delivery 8 days

3.4 Schedule Representation

Scheduling the project tasks is an important project planning activity. It involves deciding
which tasks would be taken up when. In order to schedule the project activities, a software
project manage needs to do the following this rules.
HOSPITAL MANAGEMENT SYSTEM

3.6 Components.Hardware & Software

Requirement

Name of Component Specification

Operating System Windows 7,8,8.1,10, Linux

Language PHP.NET

Database SQL Server

Browser Any of Mozilla, Opera, Chrome etc

Scripting language JavaScript

Hardware Requirement:

Name of Component Specification

Intel Core2duo 2.2ghz or

Processor more/AMD

RAM 512MB

Keyboard 122 keys

Require hard disk space 20 GB

HOSPITAL MANAGEMENT SYSTEM

Software Requirements:
-
Operating System : Windows10
Programming language
: .NET
Web-Technology:
PHP.NET.20
Front-End:
PHP.NET
Back-End:
Sql Server
HOSPITAL MANAGEMENT SYSTEM

3.7Preliminary Investigation
System development, a process consisting of two major steps of system analysis and
design, start when management or sometimes system development personnel feel that a
new system or an improvement in the existing system is required. The system development
life cycle is classically thought of as the set of activities that analysts, designers and users
carry out to develop and implement an information system. The system development life
cycle consists of the following activities:

Preliminary investigation

Determination of system requirements

Design of system

Development of software

System testing

Implementation, evaluation, and maintenance

A request to take assistance from information system can be made for many reasons, but
in each case someone in the organisation initiates the request is made, the first

system activity the preliminary investigation begins. This activity has three parts:

1) Request clarification

2) Feasibility study

3) Request approval

Request clarification: Many requests from employees and users in the

Organizations are

not clearly defined, therefore it becomes necessary that project request must be examined

and clarified properly before considering systems investigation.

 HOSPITAL MANAGEMENT SYSTEM

FEASIBILITYSTUDY:
Feasibility Study is a test of system proposal according to its work ability, impact of the
organization, ability to meet needs and effective use of the resources.

Feasibility study focuses on a few major questions:

1. What are the user’s demonstrable needs and how does a candidate system meet
them?
2. What resources are available for given candidate system?

3. What are the likely impacts of the candidate system on the organization?

4. Whether it is worth to solve the problem?

STEPS IN FEASIBILITY STUDY

• Prepare system flowcharts.

• Enumerate potential proposed system.

• Define and identify characteristics of proposed system.

• Determine and evaluate performance and cost effective of each proposed system,

• Weight system performance and cost data.

• Select the best-proposed system.

• Prepare and report final project to management.

• TECHNICAL FEASIBILITY

This is a study of resource availability that may affect the ability to achieve
an acceptable system. This evaluation determines whether the technology needed
for the proposed system is available or not.
HOSPITAL MANAGEMENT SYSTEM
• Can the work for the project be done with current equipment existing software
technology & available personal?

• Can the system be upgraded if developed?

• If new technology is needed then what can be developed?

This is concerned with specifying equipment and software that will

successfully satisfy the user requirement. The technical needs of the system may
include:
HOSPITAL MANAGEMENT SYSTEM

i. Front-end selection:

1. Scalability and extensibility.

2. Flexibility.

3. Robustness.

4. According to the organization requirement and the culture.

5. Must provide excellent reporting features with good printing support.

6. Platform independent.

7. Easy to debug and maintain.

ii. Back-end Selection:

1. Multiple user support.

2. Efficient data handling.

3. Provide inherent features for security.

4. Efficient data retrieval and maintenance.

5. Stored procedures.

6. Popularity.

7. Operating System compatible.

8. Easy to install.

9. Various drivers must be available.

10. Easy to implant with the Front-end.

The technical feasibility is frequently the most difficult area encountered at this stage. It is

essential that the process of analysis and definition be conducted in parallel with an

assessment to technical feasibility. It centers on the existing computer system (hardware,

software etc.) and to what extent it can support the proposed system.
HOSPITAL MANAGEMENT SYSTEM

ECONOMICAL FEASIBILITY

Economic Feasibility is generally the “Bottom Line” consideration for most

systems. Economic feasibility includes a broad range of concerns that includes cost

benefit analysis. In this we weight the cost and the benefits associated with the proposed

system and if it suits the basic purpose of the organization i.e. profit making, the project is

making to the analysis and design phase.

The financial and the economic questions during the preliminary investigation are

verified to estimate the following:

• The cost to conduct a full system investigation.

• The cost of hardware and software for the class of application being considered.

• The benefits in the form of reduced cost.

HOSPITAL MANAGEMENT SYSTEM

OPERATIONAL FEASIBILITY

It is mainly related to human organizations and political aspects. The points to be

considered are:
• What changes will be brought with the system?

• What organization structures are disturbed?

• What new skills will be required?

• Do the existing staff members have these skills?

• If not, can they be trained in due course of time?

The system is operationally feasible as it very easy for the End users to operate it.

It only needs basic information about Windows platform

SCHEDULE FEASIBILITY
Time evaluation is the most important consideration in the development of project.
The time schedule required for the developed of this project is very important since more

development time effect machine time, cost and cause delay in the development of other
systems.
A reliable Hospital Management System can be developed in the considerable
amount of time.
HOSPITAL MANAGEMENT SYSTEM

SYSTEM LIFE CYCLE:

System life cycle is an organizational process of developing and maintaining
systems. It helps in establishing a system project plan, because it gives overall list of
processes and sub-processes required for developing a system.

System development life cycle means combination of various activities. In other

words we can say that various activities put together are referred as system development

life cycle. In the System Analysis and Design terminology, the system development life
cycle means software development life cycle.

Following are the different phases of software development cycle:

• System study

• Feasibility study

• System analysis

• System design

• Coding

• Testing

• Implementation

• Maintenance
HOSPITAL MANAGEMENT SYSTEM

The different phase of software development life cycle is shown below

PRELIMINARY
INVESTIGATIONN

DEVOTED
REVIEW RUNNING DETERMINATIONOF
SYSTEM AND SYSTEM REQUIREMENTS
MAINTENANCE

DEVELOPMENT OF
PROTOTYPE SYSTEM

SYSTEM DESIGN OF SYSTEM

IMPLEMENTATIONN

SYSTEM TESTING
SOFTWAR E AND
CODING

SYSTEM
ANALYSIS
50% DESIGN OF
SYSTEM30%

CODING
20%

FIG : SHOWING GENERAL LIFE CYCLE PROCESS AND PERCENTAGE OF TIME

HOSPITAL MANAGEMENT SYSTEM

CHAPTER 4: - SYSTEM DESIGN

Design is the first step in the development phase for any techniques and principles for
the purpose of defining a device, a process or system in sufficient detail to permit its
physical realization.

Once the software requirements have been analysed and specified the
software design involves three technical activities - design, coding, implementation and
testing that are required to build and verify the software.

The design activities are of main importance in this phase, because in this
activity, decisions ultimately affecting the success of the software implementation and its
ease of maintenance are made. These decisions have the final bearing upon reliability and
maintainability of the system. Design is the only way to accurately translate the
customer’s requirements into finished software or a system.

Design is the place where quality is fostered in development. Software

design is a process through which requirements are translated into a representation of
software. Software design is conducted in two steps. Preliminary design is concerned
with the transformation of requirements into data.
HOSPITAL MANAGEMENT SYSTEM

4.1UMLDiagrams:

A coherent set of roles that users of use cases play when interacting with the use `cases.
HOSPITAL MANAGEMENT
SYSTEM
A description of sequence of actions, including variants, that a system
tha performs yields an observable result of value of an
t actor.

UML stands for Unified Modelling Language. UML is a language for

specifying, visualizing and documenting the system. This is the step while developing
any product after analysis. The goal from this is to produce a model of the entities
involved in the project which later need to be built. The representation of the entities
that are to be used in the product being developed need to be designed.
There are various kinds of methods in software
design: They are as follows:
 Use case Diagram

 Sequence Diagram

 Collaboration Diagram

 Activity Diagram

 State chat Diagram

HOSPITAL MANAGEMENT SYSTEM

COLLABORATION DIAGRAM:
A collaboration diagram is an introduction diagram that emphasizes the structural
organization of the objects that send and receive messages. Graphically a collaboration
diagram is a collection of vertices and arcs.

CLASS DIAGRAM:

Class is nothing but a structure that contains both variables and methods. The Class
Diagram shows a set of classes, interfaces, and collaborations and their relating ships.
There is most common diagram in modelling the object oriented systems and are used to
give the static view of a system. It shows the dependency between the classes that can be
used in our system.

The interactions between the modules or classes of our projects are shown below.
Each block contains Class Name, Variables and Methods.
HOSPITAL MANAGEMENT SYSTEM

Activity Diagram

start

Doctor Patient

Registration

Pharmacy

Reception

Discharge
Laboratory summary

End

4.3 DATAFLOW DIAGRAMS:

The DFD takes an input-process-output view of a system i.e. data objects flow
into the software, are transformed by processing elements, and resultant data objects
flow out of the software.
HOSPITAL MANAGEMENT SYSTEM

Data objects represented by labeled arrows and transformation are represented by

circles also called as bubbles. DFD is presented in a hierarchical fashion i.e. the first data flow
model represents the system as a whole. Subsequent DFD refine the context diagram (level 0
DFD), providing increasing details with each subsequent level.

The DFD enables the software engineer to develop models of the information
domain & functional domain at the same time. As the DFD is refined into greater levels of details,
the analyst perform an implicit functional decomposition of the system. At the same time, the
DFD refinement results in a corresponding refinement of the data as it moves through the process
that embody the applications.

A context-level DFD for the system the primary external entities produce
information for use by the system and consume information generated by the system. The labelled
arrow represents data objects or object hierarchy.
RULES FOR DFD:

• Fix the scope of the system by means of context diagrams.

• Organize the DFD so that the main sequence of the actions

• Reads left to right and top to bottom.

• Identify all inputs and outputs.

• Identify and label each process internal to the system with Rounded circles.

• A process is required for all the data transformation and Transfers. Therefore, never
connect a data store to a data Source or the destinations or another data store with just a
Data flow arrow.

• Do not indicate hardware and ignore control information.

• Make sure the names of the processes accurately convey everything the process is done.

• There must not be unnamed process.

• Indicate external sources and destinations of the data, with Squares.

• Number each occurrence of repeated external entities.

• Identify all data flows for each process step, except simple Record retrievals.

• Label data flow on each arrow.

 Data Flow Diagram

Hospital

Admin Management
User
System
LEVEL 1 DFD

LEVEL 1 DFD

Login add patient

ADMIN 1.0
Detail added Patient DB
PATIENT

Login add doctor

1.1 Detail added Doctor DB
DOCOTR

Login add nurse

1.2 Detail added Nurse DB
NURSE

Login add pharmacists

1.3
PHARMAC Detail added Pharmacists DB
ISTS

Login add appointment

1.4
Detail added
APPOINT Appointment DB
MENT
LEVEL 2 DFD

Login request Login request

LOGIN LOGIN REGISTER DB
Login status Login status

REGISTER

New patient New patient data

1.1 ADD
PATIENT Patient added PATIENT Data added
PATIENT DB

1.2
PATIENT
LIST
LEVEL 2 DFD

New doctor New doctor data

2.1 ADD
DOCTOR DOCTOR DOCTOR DB
Doctor added Data added

2.2
DOCTOR
LIST

New nurse New nurse data

3.1 ADD
NURSE nurse added NURSE Data added NURSE DB

3.2
NURSE
LIST
LEVEL 2 DFD

New pharmacists 4.1 ADD New pharmacists data

PHARMACI
PHARMACISTS STS PHARMACISTS DB
Pharmacists added Data added

4.2 NURSE
LIST

New appointment 5.1 ADD

New appointment data
APPOINTEMENT
S Appointment added
APPOINTM
Data added APPOINTMENTS DB
ENTS

5.2
APPOINTM
ENT LIST
HOSPITAL MANAGEMENT SYSTEM

Database Dictionary

4. E-R Diagrams:
The Entity-Relationship (ER) model was originally proposed by Peter in 1976
[Chen76] as a way to unify the network and relational database views. Simply stated the
ER model is a conceptual data model that views the real world as entities and
relationships. A basic component of the model is the Entity-Relationship diagram which
is used to visually represents data objects. Since Chen wrote his paper the model has
been extended and today it is commonly used for database design For the database
designer, the utility of the ER model is:

• it maps well to the relational model. The constructs used in the ER model can
easily be transformed into relational tables.
• it is simple and easy to understand with a minimum of training. Therefore, the
model can be used by the database designer to communicate the design to the end
user.
• In addition, the model can be used as a design plan by the database developer to
implement a data model in a specific database management software.

Connectivity and Cardinality

The basic types of connectivity for relations are: one-to-one, one-to-many,

and many-to-many. A one-to-one (1:1) relationship is when at most one instance of a
entity A is associated with one instance of entity B. For example, "employees in the
company are each assigned their own office. For each employee there exists a unique
office and for each office there exists a unique employee.

A one-to-many (1:N) relationships is when for one instance of entity A, there are zero,

one, or many instances of entity B, but for one instance of entity B, there is only one

instance of entity
HOSPITAL MANAGEMENT SYSTEM

A. An example of a 1:N relationships is a department has many employees each

employee is assigned to one department

A many-to-many (M:N) relationship, sometimes called non-specific, is when for one

instance of entity A, there are zero, one, or many instances of entity B and for one instance
of entity B there are zero, one, or many instances of entity A. The connectivity of a
relationship describes the mapping of associated

ER Notation

There is no standard for representing data objects in ER diagrams. Each

modelling methodology uses its own notation. The original notation used by Chen is
widely used in academic’s texts and journals but rarely seen in either CASE tools or
publications by non- academic. Today, there are a number of notations used, among the
more common are Bachman, crow's foot, and IDEFIX.

All notational styles represent entities as rectangular boxes and relationships as

lines connecting boxes. Each style uses a special set of symbols to represent the
cardinality of a connection. The notation used in this document is from Martin. The
symbols used for the basic ER constructs are:

 entities are represented by labelled rectangles. The label is the name of the entity.

Entity names should be singular nouns.

 relationships are represented by a solid line connecting two entities. The name of the
relationship is written above the line. Relationship names should be verbs
 attributes, when included, are listed inside the entity rectangle. Attributes which are
identifiers are underlined. Attribute names should be singular nouns.
 cardinality of many is represented by a line ending in a crow's foot. If the crow's foot
is omitted, the cardinality is one.
 existence is represented by placing a circle or a perpendicular bar on the line.
Mandatory existence is shown by the bar (looks like a 1) next to the entity for an
instance is required. Optional existence is shown by placing a circle next to the entity
that is optional.
HOSPITAL MANAGEMENT SYSTEM

CHAPTER 5: -IMPLEMENTATION AND

TESTING

5.1SYSTEM IMPLEMENTATION
SYSTEM IMPLEMENTATION, MAINTENANCE AND REVIEW

As we know, creating software is one thing and the implementation of the created software is

another. The process of implementing software is much difficult as compared to the task of
creating the project. First we have to implement the software on a small scale for removing
the bugs and other errors in the project and after removing them we can implement the
software on a large scale. Before we think in terms of implementing the Software on a large
basis, we must consider the Hardware requirements.

Whenever we develop software or project a certain hardware and software is being used by the
programmer for developing the project. The hardware and software to be used by the

programmer for developing the project should be such that it would result in the development
of a project, which would satisfy all the basic needs for which the project has been created by
the programmer. The Hardware should be such that cost constraints of the Client should also
be taken into account without affecting the performance.

HARDWARE EVALUATION FACTORS:

When we evaluate computer hardware, we should first investigate specific physical and
performance characteristics for each hardware component to be acquired. These specific
questions must be answered concerning many important factors. These hardware evaluation
factors questions are summarized in the below figure.
 HOSPITAL MANAGEMENT SYSTEM

Notice that there is much more to evaluating hardware than determining the fastest and cheapest
computing device. For e.g. the question of possible obsolescence must be addressed by making a
technology evaluation. The factor of ergonomics is also very important. Ergonomics is the
science and technology that tries to ensure that computer and other technologies are "user-
friendly", that is safe, comfortable and easy to use. Connectivity is another important evaluation
factor, since so many computer systems are now interconnected within wide area or local area
telecommunications networks.

HARDWARE EVALUATION FACTORS:

1) Performance

2) Cost

3) Reliability

4) Availability

5) Compatibility

6) Modularity

7) Technology

8) Ergonomics

9) Connectivity

10) Environmental requirements

11) Software

12) Support
 HOSPITAL MANAGEMENT SYSTEM

SOFTWARE EVALUATION FACTORS:

Software can be evaluated according to many factors similar to the hardware evaluation. Thus the
factors of performance, cost, reliability, compatibility, modularity, technology, ergonomics, and
support should be used to evaluate proposed software acquisitions. In addition, however, the
software evaluation factors are summarized in below figure. For e.g. some software
packages require too much memory capacity and are notoriously slow, hard to use, or poorly
documented. They are not a good selection for most end users, even if offered at attractive
prices.

1) Efficiency: is the software a well-written system of computer instructions that does not use
much memory capacity or CPU time?
2) Flexibility: can it handle its processing assignments easily without major modifications?

3) Security: does it provide control procedures for errors, malfunctions and improper use?4)
Language: do our computer programmers and users write it in a programming language that
is used?
4) Documentation: is the s/w well documented? Does it include helpful user instructions?
5) Hardware: does existing hardware have the features required to best use this software?7)
Other characteristics of hardware such as its performance, what about the cost, how much
is reliable and etc.

SECURITY MEASURES

Security Performed In HOSPITAL Management System

User Name & Password security implemented so that no unauthorized person can handle any

operation without username and Password.

Only authorized person can log-on the system.

HOSPITAL MANAGEMENT SYSTEM

Only authorized person can update the records.

Only authorized person can handle the reservation.

Only authorized person can print the report.

It has two kinds of users:

1. Administrator

2. User1

Administrator: He has complete authority (Read, Add, and Modify) of operating the
software.

User1: When this user logs onto the system, he can only view information and other reports.
He can generate different reports.
HOSPITAL MANAGEMENT SYSTEM

5.2CODING
1.Home Page1. Aspx
<%@ Page Title="" Language="C#"MasterPageFile="~/master1.Master" AutoEventWireup="true"
CodeBehind="Homepage1.aspx.cs" Inherits="hospital_management.Homepage1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">

<img src="scripts/homeheadpic.jpg" style="width: 100%; height: 200px" />

<style type="text/css">
.auto-style1
{ width: 100%;
height:219px;
}
</style>
<style type="text/css">
.auto-style1
{ width: 100%;
height: 238px;
}
</style>
<style type="text/css">
.auto-style1
{ height: 169px;
text-align:center;
}
.auto-style2
{ height:169px;
width: 647px;
}
.auto-style3
{ width:647px;
padding:10px 10px 10px 10px;
}
</style>
<style type="text/css">
.auto-style1 {
text-align: center;
}
</style>
<style type="text/css">
.auto-style1
{ width:696px;
}
.auto-style2
{ width:675px;
}
.auto-style3 { width:
675px; text-align:
center;
}
.auto-style4 {
text-align: center;
}
.auto-style5 { width:
675px; text-align:
center; height:
12px;
HOSPITAL MANAGEMENT SYSTEM

}
.auto-style6
{ width:696px;
height:12px;
}
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="Content" runat="server">
<div >
<br/>
<br/>
<table style="width: 100%;">
<tr>
<tdclass="auto-style2">
<asp:Image ID="Image1" runat="server" Height="416px" ImageUrl="~/scripts/homeagepic1.jpg"
Width="698px" />
</td>
<td class="auto-style1"><h1 style="color:blue; font-family:Arial;"><b>Kantilal Gandhi Memorial
Hospital</b></h1>
<br/>
<h4 style="color:blue;">ISO-9001-2020,NABLAccredited<br />
Multispeciality Post Graduate Teaching Hospital
</h4>&nbsp;</td>

</tr>
<tr style="background-color:blue;color:white;">
<td class="auto-style2"><br />
<h2 style="color:white;">The Hospital</h2>
Our Hospital is a 404 bedded multi-specialty
DBN accredited Post Graduating Teaching hospital in
<b>JAMSEHDPUR</b>.Our Hopsital hasbeen continously
striving to offer the highest standard of services to
patient with great empathy and humanity.<br />
</td>
<td class="auto-style3"><br />
We have a wonderful team of doctor in all department who give the best
possible clinical care to our patients.We have state of the art Pathology
and Radiological units having equipments like Analyzer,Color Doppler
CT Scan etc.to supprot our Clinicians.<br />

</td>
</tr>
<tr>
<tdcolspan="2">&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style3">
<br/>
<asp:Image ID="Image2" runat="server" Height="250px" ImageUrl="~/scripts/home pic 2.jpg"
Width="400px" />
<br/>
<asp:Label ID="Label1" runat="server" Font-Bold="True" ForeColor="#0000CC" Text="Special Care
Ward"></asp:Label>
<br />
</td>
<tdclass="auto-style1">
<asp:Image ID="Image3" runat="server" Height="250px" ImageUrl="~/scripts/home pic3.jpg"
Width="400px" />
<br/>
<asp:Label ID="Label2" runat="server" Font-Bold="True" ForeColor="#0000CC" Text="General Care
Ward"></asp:Label>
</td>
</tr>
HOSPITAL MANAGEMENT SYSTEM

<tr>
<tdclass="auto-style5">
</td>
<tdclass="auto-style6">
</td>
</tr>
<tr>
<td class="auto-style4" colspan="2">
<asp:Image ID="Image4" runat="server" Height="300px" ImageUrl="~/scripts/home pic 4.jpg"
Width="900px" />
<br/>
<asp:Label ID="Label3" runat="server" Font-Bold="True" ForeColor="#0000CC" Text="Hospital
Facality"></asp:Label>
</td>
</tr>
</table>
</div>
<divstyle="padding-left:700px;">
</div>
</asp:Content>
<asp:ContentID="Content3" ContentPlaceHolderID="footer" runat="server">
</asp:Content>

1.1 Master1.master

<%@ Master Language="C#" AutoEventWireup="true"CodeBehind="master1.master.cs"

Inherits="hospital_management.master1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<link href="StyleSheet1master.css" rel="stylesheet" />
<title></title>
<asp:ContentPlaceHolderID="head" runat="server">
</asp:ContentPlaceHolder>

</head>
<body>
<form id="form1" runat="server">
<div>
+
<div class="menu">
<ul>
<li><aclass="active"href="Homepage1.aspx">Home</a></li>
<li><a href="register1.aspx">Register</a></li>
<li><a href="login.aspx">LogIn</a></li>
<li><a href="services.aspx">Services</a></li>
<li><a href="About.aspx">About Us</a></li>

</ul>
</div>

<asp:ContentPlaceHolderID="Content"runat="server">
</asp:ContentPlaceHolder>

<asp:ContentPlaceHolderID="footer"runat="server">
HOSPITAL MANAGEMENT SYSTEM

</asp:ContentPlaceHolder>
<div class="footer">
<h4>@copyright </h4>
</div>
</div>
</form>
</body>

</html>

STYLESHEET1MASTER.CSS

body {
padding:0;
margin:10px;
background-color:lightcyan;
font-family:Arial;
}
ul {
list-style-type:none;
margin:0;
padding:0;
overflow:hidden;
background-color:#0026ff;
}
li
{ float:lef
t;
}
li a, .dropbtn
{
display:inline-block;
color:white;
text-align:center;
padding:14px 16px ;
text-decoration:none;
}
li a:hover {
background-color:#3a68bb;

ul li a:active{
background-color:#3a68bb;
}

.footer{
background-color:#0026ff;
color:white;
margin-top:200px;
width:100%;
height:5%;
text-align:center;

}
HOSPITAL MANAGEMENT SYSTEM

REGISTER1.ASPX
<%@ Page Title="" Language="C#"MasterPageFile="~/master1.Master" AutoEventWireup="true"
CodeBehind="register1.aspx.cs" Inherits="hospital_management.register1" %>
<asp:ContentID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:ContentID="Content2" ContentPlaceHolderID="Content" runat="server">

<style type="text/css">
.auto-style1
{ height: 53px;
color:#0000FF;
}
.auto-style2
{ width:194px;
}
.auto-style3 {
width:247px;
}
.auto-style4
{ width:247px;
height:23px;
}
.auto-style5
{ width:194px;
height:23px;
}
.auto-style6
{ height:23px;
}
.auto-style7
{ width: 247px;
height:65px;
}
.auto-style8
{ width:194px;
height:65px;
}
.auto-style9
{ height: 65px;
text-align:left;
}

.auto-style10
{ width: 194px;
color:#0033CC;
}
.auto-style11
{ color:
#0033CC;
}
.auto-style12
{ width: 194px;
color: #0033CC;
font-weight:bold;
}
.auto-style13
{ width: 247px;
color:#0033CC;
}
HOSPITAL MANAGEMENT SYSTEM

</style>

<table style="width: 100%;">

<tr>
<td class="auto-style1" colspan="3" style="font-weight: 700; font-size: xx-large; text-align: center;
background-color: #0000FF; color: #FFFFFF; font-family: Arial;">Register Here</td>
</tr>
<tr>
<tdclass="auto-style3">&nbsp;</td>
<tdclass="auto-style2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<td class="auto-style12"><span class="auto-style11">User Name:</span><br class="auto-style11" />
</td>
<td>
<asp:TextBox ID="TextBox1" runat="server" Width="193px" placeholder="Enter
username"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<td class="auto-style10">&nbsp;</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<td class="auto-style12"><span class="auto-style11">Email :</span><br class="auto-style11" />
</td>
<td>
<asp:TextBox ID="TextBox2" runat="server" Width="263px" placeholder="Email"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<td class="auto-style10">&nbsp;</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<td class="auto-style12"><span class="auto-style11">password :</span><br class="auto-style11" />
</td>
<td>
<asp:TextBox ID="TextBox3" runat="server" TextMode="Password"Width="193px"
Placeholder="********"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<td class="auto-style10">&nbsp;</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td class="auto-style13">&nbsp;</td>
<tdclass="auto-style10"><strong>Gender:</strong></td>
<td>
<asp:DropDownList ID="DropDownList1" runat="server" Height="24px" Width="129px">
<asp:ListItem>Male</asp:ListItem>
HOSPITAL MANAGEMENT SYSTEM

<asp:ListItem>Female</asp:ListItem>
<asp:ListItem>other</asp:ListItem>
<asp:ListItem></asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<tdclass="auto-style13">&nbsp;</td>
<tdclass="auto-style10">&nbsp;</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td class="auto-style13">&nbsp;</td>
<td class="auto-style10"><strong>AadharNumbe</strong>r :</td>
<td>
<asp:TextBox ID="TextBox4" runat="server" MaxLength="10" TextMode="Number"Width="193px"
Placeholder="12 digit UID code"></asp:TextBox>
</td>
</tr>
<tr>
<tdclass="auto-style13">&nbsp;</td>
<td class="auto-style10">&nbsp;</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td class="auto-style13">&nbsp;</td>
<td class="auto-style2"><b><span class="auto-style11">Contact :</span><br class="auto-style11" />
</b></td>
<td>
<asp:TextBox ID="TextBox5" runat="server" TextMode="Number"Width="193px"
Placeholder="Phone Number"></asp:TextBox>
</td>
</tr>
<tr>
<tdclass="auto-style13">&nbsp;</td>
<td class="auto-style10">&nbsp;</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td class="auto-style13">&nbsp;</td>
<td class="auto-style2"><b><span class="auto-style11">Address :</span><br class="auto-style11" />
</b></td>
<td>
<asp:TextBox ID="TextBox6" runat="server" TextMode="MultiLine" Width="214px"
Placeholder="Full Address"></asp:TextBox>
</td>
</tr>
<tr>
<tdclass="auto-style4"></td>
<td class="auto-style5"></td>
<tdclass="auto-style6"></td>
</tr>
<tr>
<tdclass="auto-style7"></td>
<tdclass="auto-style8">
<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="Log In " Width="73px"
Height="29px" />
</td>
<tdclass="auto-style9">
HOSPITAL MANAGEMENT SYSTEM

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click1" Text="Register" Width="124px"

Height="36px" />
</td>
</tr>
<tr>
<tdclass="auto-style3">&nbsp;</td>
<td class="auto-style2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style3">&nbsp;</td>
<tdclass="auto-style2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style3">&nbsp;</td>
<tdclass="auto-style2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
</asp:Content>
<asp:ContentID="Content3" ContentPlaceHolderID="footer" runat="server">
</asp:Content>

REGISTER1.ASPX.CS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
usingSystem.Text;
using System.Configuration;

namespace hospital_management
{
public partial class register1 : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-UNT2SKE;Initial
Catalog=HMS;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{

}
HOSPITAL MANAGEMENT SYSTEM

protected void Button1_Click1(object sender, EventArgs e)

{
conn.Open();
string query = "insert into register(username,email,password,gender,aadharnumber,contact,address) values('" +
TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + DropDownList1.Text + "','" + TextBox4.Text
+ "','" + TextBox5.Text + "','" + TextBox6.Text + "')";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();
conn.Close();
Response.Write("<script LANGUAGE='JavaScript' >alert('REGISTRATION DONE !!')</script>");
TextBox1.Text = " ";
TextBox2.Text = " ";
TextBox3.Text = " ";
TextBox4.Text = " ";
TextBox5.Text = " ";
TextBox6.Text = " ";
}

protected void Button2_Click(object sender, EventArgs e)

{
Response.Redirect("login.aspx");
}
}
}

LOGIN.ASPX

<%@ Page Title="" Language="C#"MasterPageFile="~/master1.Master" AutoEventWireup="true"

CodeBehind="login.aspx.cs"Inherits="hospital_management.login"%>
<asp:ContentID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:ContentID="Content2" ContentPlaceHolderID="Content" runat="server">

<style type="text/css">
.auto-style2 {
font-size: xx-large;
color: #000099;
text-align: center;
height: 62px;
}

.auto-style4 {
text-align: center;
height: 54px;
}

.auto-style21 {
border-style:double;
border-color:blue;
border-width: 5px;
width: 465px;
HOSPITAL MANAGEMENT SYSTEM

height: 47px;
text-align: center;

.auto-style22 {
width:373px;
}

.auto-style23
{ width:465px;
}

body {
}

.auto-style24
{ width:373px;
height: 35px;
}

.auto-style25
{ width:465px;
height: 35px;
}

.auto-style26
{ height:35px;
}

.auto-style27
{ color:#000099;
}
</style>

<div>
<table style="width:100%;">
<tr>
<tdclass="auto-style22">&nbsp;</td>
<tdclass="auto-style23">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style4" colspan="3">
<asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Size="XX-Large" Font-
Strikeout="False" Font-Underline="True" ForeColor="#000099" Text="Hospital Management System"
CssClass="auto-style27"></asp:Label>
</td>
</tr>
<tr>
<tdclass="auto-style24"></td>
<td class="auto-style25"></td>
<tdclass="auto-style26"></td>
</tr>
<tr>
<td class="auto-style2" colspan="3"><strong>&nbsp;&nbsp; Admin Login</strong></td>
</tr>
<tr>
<tdclass="auto-style22"></td>
<td class="auto-style21" rowspan="8" <br />
<spanclass="auto-style27">
<strong>
HOSPITAL MANAGEMENT SYSTEM

<br />
User Name :</strong>&nbsp;&nbsp;&nbsp;
</span>
<asp:TextBox ID="TextBox1" runat="server" placeholder="Enter username" Height="24px"
Width="150px" CssClass="auto-style27"></asp:TextBox>
<strong>&nbsp;<br />
<br class="auto-style27" />
<span class="auto-style27">&nbsp;&nbsp; Password :&nbsp;&nbsp; </span> </strong>
<asp:TextBoxID="TextBox2" runat="server"TextMode="Password"placeholder="********"
Height="24px"Width="144px"CssClass="auto-style27"></asp:TextBox>
<br class="auto-style27" />
<br />
<asp:LinkButtonID="LinkButton1"runat="server"OnClick="LinkButton1_Click">Forget
Password</asp:LinkButton>
<br/>
<br/>
<asp:LinkButtonID="LinkButton2"runat="server"
OnClick="LinkButton2_Click">Register</asp:LinkButton>
<br/>
<br/>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Log In" Width="103px"
BackColor="#FFFFCC" Font-Bold="True" Height="35px" />
<br />
</td>
<tdclass="auto-style17"></td>
</tr>
<tr>
<td class="auto-style22"><strong>&nbsp;&nbsp; &nbsp;</strong></td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style22"><strong>&nbsp;&nbsp;&nbsp; </strong></td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style22">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style22"></td>
<tdclass="auto-style8"></td>
</tr>
<tr>
<td class="auto-style22">&nbsp;</td>
<td>&nbsp;</td>
</tr>

<tr>
<tdclass="auto-style22"></td>
<tdclass="auto-style20"></td>
</tr>
<tr>
<td class="auto-style22">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style22">&nbsp;</td>
<td class="auto-style23">
&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style22">&nbsp;</td>
HOSPITAL MANAGEMENT SYSTEM

<td class="auto-style23">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style22">&nbsp;</td>
<tdclass="auto-style23">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style22">&nbsp;</td>
<tdclass="auto-style23">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style22">&nbsp;</td>
<tdclass="auto-style23">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style22">&nbsp;</td>
<tdclass="auto-style23">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style22">&nbsp;</td>
<tdclass="auto-style23">&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
</div>

</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="footer" runat="server">
</asp:Content>
HOSPITAL MANAGEMENT SYSTEM

LOGIN.ASPX.CS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;
using System.Data;
usingSystem.Text;
using System.Data.SqlClient;
using System.Configuration;

namespace hospital_management
{
public partial class login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

protected void Button1_Click(object sender, EventArgs e)

{
SqlConnection con = new
SqlConnection(ConfigurationManager.ConnectionStrings["HMSConnectionString"].ConnectionString);
String ss = "select * from register";
SqlCommand cmd = new SqlCommand(ss, con);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds, "register");
for (int i = 0; i < ds.Tables["register"].Rows.Count; i++)
{
if (ds.Tables["register"].Rows[i][0].Equals(TextBox1.Text))
{
if (ds.Tables["register"].Rows[i][3].Equals(TextBox2.Text))
{
TextBox1.Text = "";
HOSPITAL MANAGEMENT SYSTEM

TextBox2.Text = "";
Response.Redirect("homepage.aspx");
break;
}

}
else
{
Response.Write("<scriptLANGUAGE='JavaScript'>alert('WRONG INFORMATION')</script>");
}

protected void LinkButton1_Click(object sender, EventArgs e)

{
Response.Redirect("forget password.aspx");
}

protected void LinkButton2_Click(object sender, EventArgs e)

{
Response.Redirect("register1.aspx");
}
}
}
HOSPITAL MANAGEMENT SYSTEM

FORGET PASSWORD.ASPX

<%@ Page Language="C#" AutoEventWireup="true" Codefile="forget password.aspx.cs"

Inherits="hospital_management.forget_password" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1
{ width:224px;
}
.auto-style2
{ width:246px;
}
.auto-style5
{ height:96px;
text-align: center;
font-size:xx-large;
color: #0000FF;
}
body{
background-color:lightcyan;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<table style="width:100%;">
<tr>
<td class="auto-style5" colspan="3"><strong>Reset Password</strong></td>
</tr>
<tr>
<tdclass="auto-style1">&nbsp;</td>
<tdclass="auto-style2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style1"><strong></strong></td>
<td class="auto-style2"><strong>User Name :</strong></td>
<td>
HOSPITAL MANAGEMENT SYSTEM

<asp:TextBox ID="TextBox1" runat="server" Height="27px" Width="225px" Placeholder="Enter

username"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style1"><strong></strong></td>
<td class="auto-style2"><strong>New Password :</strong></td>
<td>
<asp:TextBox ID="TextBox2" runat="server" Height="27px" TextMode="Password" Width="225px"
Placeholder="********"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style1"><strong></strong></td>
<td class="auto-style2"><strong>Confirm Pasword :</strong></td>
<td>
<asp:TextBox ID="TextBox3" runat="server" Height="27px" TextMode="Password" Width="225px"
Placeholder="********"></asp:TextBox>
</td>
</tr>
<tr>
<tdclass="auto-style1">&nbsp;</td>
<td class="auto-style2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style1">&nbsp;</td>
<tdclass="auto-style2">&nbsp;</td>
<td>
<asp:Button ID="Button1" runat="server" Font-Bold="True" OnClick="Button1_Click" Text="submit"
Width="116px" />
</td>
</tr>
<tr>
<tdclass="auto-style1">&nbsp;</td>
<tdclass="auto-style2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style1">&nbsp;</td>
<tdclass="auto-style2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
</form>
</body>
</html>
HOSPITAL MANAGEMENT SYSTEM

FORGET PASSWORD.ASPX.CS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;
using System.Data;
usingSystem.Text;
using System.Data.SqlClient;
using System.Configuration;

namespace hospital_management
{
public partial class forget_password : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

protected void Button1_Click(object sender, EventArgs e)

{
if (TextBox2.Text == TextBox3.Text)
{
SqlConnection con = new
SqlConnection(ConfigurationManager.ConnectionStrings["HMSConnectionString"].ConnectionString);

String ss = "update register set password=@password where username=@username";

SqlCommand cmd = new SqlCommand(ss, con);
cmd.Parameters.AddWithValue("@username", TextBox1.Text);
cmd.Parameters.AddWithValue("@password", TextBox3.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

TextBox1.Text = "";
TextBox3.Text = "";
Response.Redirect("LOG.aspx");
}
else
{
Response.Write("<scriptLANGUAGE='JavaScript'>alert('WRONGINFORMATION')</script>");
TextBox2.Text = "";
TextBox3.Text = "";
}
}
HOSPITAL MANAGEMENT SYSTEM

}
}

HOMEPAGE.ASPX
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="homepage.aspx.cs"
Inherits="hospital_management.homepage" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style4
{ width:141px;
height:74px;
}
.auto-style6
{ width:141px;
height: 87px;
}
.auto-style10
{ width:141px;
height:79px;
}
.auto-style14
{ height: 91px;
color:#33CCFF;
}
.auto-style16 {
}
.auto-style18
{ height:141px;
width: 156px;
}
.auto-style22
{ width:100%;
}
.auto-style29
{ width:141px;
}
.auto-style31
{ width: 99px;
height:141px;
}
.auto-style33
{ width: 96px;
height:141px;
}
.auto-style34
{ height: 141px;
width: 141px;
}
.auto-style35
{ width: 102px;
height:141px;
HOSPITAL MANAGEMENT SYSTEM

}
.auto-style36
{ width: 98px;
height:141px;
}
.auto-style37 {
font-weight: normal;
}
.auto-style38
{ width:141px;
height:75px;
}
.auto-style39
{ width:141px;
height:67px;
}
body{
background-color:lightcyan;
}
.auto-style40
{ color:
#0033CC;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<tableclass="auto-style22">
<tr>
<td colspan="6" style="text-align: center; font-size: xx-large; font-weight: 700" class="auto-
style14">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<span class="auto-style37"><strong>&nbsp;<span class="auto-style40">Dashboard</span></strong></span></td>
</tr>
<tr>
<td class="auto-style34">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<asp:LinkButtonID="LinkButton1"runat="server"OnClick="LinkButton1_Click">Log
Out</asp:LinkButton>
</td>
<td class="auto-style31">
<asp:ImageButtonID="ImageButton1"runat="server"BorderColor="#66FFFF" BorderStyle="None"
BorderWidth="1px"Height="79px"ImageUrl="~/scripts/Patient-icon.png"Width="80px"
OnClick="ImageButton1_Click"/>
<br />
&nbsp;&nbsp;&nbsp;&nbsp; Paitents</td>
<td class="auto-style35">&nbsp;&nbsp;&nbsp;
<asp:ImageButtonID="ImageButton2"runat="server"BorderColor="#66FFFF" BorderStyle="None"
BorderWidth="1px"Height="79px" ImageUrl="~/scripts/doctoricon.png" Width="80px"
OnClick="ImageButton2_Click"/>
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Doctors</td>
<tdclass="auto-style36">&nbsp;<asp:ImageButtonID="ImageButton3"runat="server"
BorderColor="#66FFFF" BorderStyle="None"BorderWidth="1px"Height="79px"ImageUrl="~/scripts/nurse
icon.png" Width="80px" OnClick="ImageButton3_Click" />
<br />
&nbsp;Nurses</td>
<td class="auto-style33">&nbsp; &nbsp;<asp:ImageButton ID="ImageButton4" runat="server"
BorderColor="#66FFFF" BorderStyle="None"BorderWidth="1px"Height="79px"
ImageUrl="~/scripts/Pharmacist_Male_Light.png"Width="80px"OnClick="ImageButton4_Click" />
<br />
&nbsp; Pharmacists</td>
<tdclass="auto-style18">
<asp:ImageButtonID="ImageButton5"runat="server"BorderColor="#66FFFF" BorderStyle="None"
BorderWidth="1px" Height="79px" ImageUrl="~/scripts/appoint ment icon.png" Width="80px"
OnClick="ImageButton5_Click"/>
HOSPITAL MANAGEMENT SYSTEM

<br />
&nbsp;Appointments</td>
</tr>
<tr>
<tdclass="auto-style39">
<asp:Button ID="Button1" runat="server" BorderColor="#66FFFF" Height="43px" Text="Add Patient"
Width="244px" OnClick="Button1_Click" />
</td>
<tdclass="auto-style16"colspan="5"rowspan="6">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</td>
</tr>
<tr>
<tdclass="auto-style4">
<asp:Button ID="Button4" runat="server" BorderColor="#66FFFF" Height="43px" Text="Add Doctor"
Width="244px" OnClick="Button4_Click" />
</td>
</tr>
<tr>
<tdclass="auto-style6">
<asp:Button ID="Button2" runat="server" BorderColor="#66FFFF" Height="43px" Text="Add Nurse"
Width="244px" OnClick="Button2_Click" />
</td>
</tr>
<tr>
<tdclass="auto-style38">
<asp:Button ID="Button5" runat="server" BorderColor="#66FFFF" Height="43px" Text="Add
Pharmacists" Width="244px" OnClick="Button5_Click" />
</td>
</tr>
<tr>
<tdclass="auto-style10">
<asp:Button ID="Button3" runat="server" BorderColor="#66FFFF" Height="43px" Text="Add
Appointment" Width="244px" OnClick="Button3_Click" />
</td>
</tr>
<tr>
<tdclass="auto-style29"></td>
</tr>
</table>
</form>
</body>
</html>

HOMEPAGE.ASPX.CS
HOSPITAL MANAGEMENT SYSTEM

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;

namespace hospital_management
{
public partial class homepage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

protected void Button1_Click(object sender, EventArgs e)

{
Response.Redirect("add patient.aspx");
}

protected void Button4_Click(object sender, EventArgs e)

{
Response.Redirect("add doctor.aspx");
}

protected void Button2_Click(object sender, EventArgs e)

{
Response.Redirect("Add Nurse.aspx");
}

protected void Button5_Click(object sender, EventArgs e)

{
Response.Redirect("add pharmacists.aspx");
}

protected void Button3_Click(object sender, EventArgs e)

{
Response.Redirect("add appiontment.aspx");
}

protected void LinkButton1_Click(object sender, EventArgs e)

{
Response.Redirect("login.aspx");
}

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)

{
Response.Redirect("patients_list.aspx");
}

protected void ImageButton2_Click(object sender, ImageClickEventArgs e)

{
Response.Redirect("doctor_list.aspx");
}

protected void ImageButton3_Click(object sender, ImageClickEventArgs e)

{
Response.Redirect("nurse_list.aspx");
}

protected void ImageButton4_Click(object sender, ImageClickEventArgs e)

{
HOSPITAL MANAGEMENT SYSTEM

Response.Redirect("pharmacists _list.aspx");
}

protected void ImageButton5_Click(object sender, ImageClickEventArgs e)

{
Response.Redirect("appointment list.aspx");
}
}
}

ADD PATIENT.ASPX

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="add patient.aspx.cs"

Inherits="hospital_management.add_patient" %>

<!DOCTYPE html>
HOSPITAL MANAGEMENT SYSTEM

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1
{ height:23px;
}
.auto-style2 {
text-align: center;
font-size: xx-large;
height: 124px; color:
#0000FF;
}
.auto-style4
{ height: 23px;
width:199px;
}
.auto-style5
{ width:339px;
}
.auto-style6
{ height: 23px;
width:339px;
}
.auto-style7
{ height: 23px;
width:196px;
}
.auto-style12
{ width: 199px;
height: 27px;
}
.auto-style14
{ width: 196px;
height: 27px;
}
.auto-style15
{ width: 339px;
height: 27px;
}
.auto-style16
{ height:27px;
}
.auto-style25
{ height: 1px;
width:199px;
}
.auto-style26
{ height: 1px;
width:196px;
}
.auto-style27
{ height: 1px;
}
.auto-style28
{ width:199px;
}
.auto-style30
{ width:196px;
}
.auto-style31
{ width: 199px;
height:135px;
HOSPITAL MANAGEMENT SYSTEM

}
.auto-style32
{ width: 339px;
height: 135px;
text-align:right;
}
.auto-style33
{ width: 196px;
height: 135px;
text-align:right;
}
.auto-style34
{ height:135px;
}
.auto-style35
{ width:199px;
height:24px;
}
.auto-style36
{ width:339px;
height:24px;
}
.auto-style37
{ width:196px;
height:24px;
}
.auto-style38
{ height:24px;
}

.auto-style39
{ height: 23px;
width: 199px;
color:#333333;
}
body{
background-color:lightcyan;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<p>
<table style="width:100%;">
<tr>
<td class="auto-style2" colspan="4"><strong>Add Patients</strong></td>
</tr>
<tr>
<td class="auto-style39">&nbsp;</td>
<td class="auto-style6">
&nbsp;</td>
<td class="auto-style7">&nbsp;</td>
<td class="auto-style1">
&nbsp;</td>
</tr>
<tr>
<td class="auto-style12"><strong>Patient Name :</strong></td>
<tdclass="auto-style15">
<asp:TextBoxID="TextBox2" runat="server" Width="177px"></asp:TextBox>
</td>
<td class="auto-style14"><strong>Room number:</strong></td>
<tdclass="auto-style16">
<asp:TextBoxID="TextBox5" runat="server" Width="177px"></asp:TextBox>
HOSPITAL MANAGEMENT SYSTEM

</td>
</tr>
<tr>
<tdclass="auto-style28"><strong>Gender:</strong></td>
<tdclass="auto-style5">
<asp:DropDownList ID="DropDownList3" runat="server" Height="23px" Width="150px">
<asp:ListItem>Male</asp:ListItem>
<asp:ListItem>Female</asp:ListItem>
<asp:ListItem>Other</asp:ListItem>
<asp:ListItem></asp:ListItem>
</asp:DropDownList>
</td>
<tdclass="auto-style30"><strong>Disease:</strong></td>
<td>
<asp:DropDownList ID="DropDownList2" runat="server" Height="26px" Width="157px">
<asp:ListItem>kidney</asp:ListItem>
<asp:ListItem>liver</asp:ListItem>
<asp:ListItem>lungs</asp:ListItem>
<asp:ListItem>heart</asp:ListItem>
<asp:ListItem>skin</asp:ListItem>
<asp:ListItem>eye</asp:ListItem>
<asp:ListItem>blood</asp:ListItem>
<asp:ListItem>other</asp:ListItem>
<asp:ListItem></asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<tdclass="auto-style35"><strong>Contact:</strong></td>
<tdclass="auto-style36">
<asp:TextBox ID="TextBox3" runat="server" MaxLength="10" TextMode="Number"
Width="177px"></asp:TextBox>
</td>
<td class="auto-style37">&nbsp;</td>
<td class="auto-style38">
&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style4"><strong>Address:</strong></td>
<tdclass="auto-style5">
<asp:TextBoxID="TextBox4" runat="server"TextMode="MultiLine"
Width="177px"></asp:TextBox>
</td>
<tdclass="auto-style7">&nbsp;</td>
<tdclass="auto-style1">&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style25"></td>
<td class="auto-style5">
&nbsp;</td>
<tdclass="auto-style26"></td>
<tdclass="auto-style27"></td>
</tr>
<tr>
<tdclass="auto-style4">&nbsp;</td>
<tdclass="auto-style6">&nbsp;</td>
<tdclass="auto-style7">&nbsp;</td>
<tdclass="auto-style1">&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style31"></td>
<td class="auto-
style32">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
HOSPITAL MANAGEMENT SYSTEM

p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<asp:Button ID="Button1" runat="server" Font-Bold="True" Text="Add" Width="181px"
Height="40px" OnClick="Button1_Click" />
</td>
<tdclass="auto-style33">
<br />
<asp:Button ID="Button2" runat="server" Font-Bold="True" Height="36px"
OnClick="Button2_Click" Text="Cancel" Width="99px" />
</td>
<tdclass="auto-style34"></td>
</tr>
<tr>
<tdclass="auto-style4">&nbsp;</td>
<tdclass="auto-style6">&nbsp;</td>
<tdclass="auto-style7">&nbsp;</td>
<tdclass="auto-style1">&nbsp;</td>
</tr>
</table>
</p>
</form>
</body>
</html>

ADD PATIENT .ASPX.CS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
namespace hospital_management
{
public partial class add_patient : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-UNT2SKE;Initial
Catalog=HMS;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{
HOSPITAL MANAGEMENT SYSTEM

protected void Button1_Click(object sender, EventArgs e)

{
conn.Open();
string insert = "insert into addpatient(patientname,gender,contact,address,disease,roomno) values('" +
TextBox2.Text + "','" + DropDownList3.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" +
DropDownList2.Text + "','" + TextBox5.Text + "')";
SqlCommand cmd = new SqlCommand(insert, conn);
cmd.ExecuteNonQuery();
conn.Close();
Response.Write("<scriptLANGUAGE='JavaScript'>alert('patientadded')</script>");
TextBox2.Text = " ";
TextBox3.Text = " ";
TextBox4.Text = " ";
TextBox5.Text = " ";
}

protected void Button2_Click(object sender, EventArgs e)

{
Response.Redirect("homepage.aspx");
}
}
}

ADD DOCTOR.ASPX

<%@ Page Language="C#" AutoEventWireup="true" Codefile="add doctor.aspx.cs"

Inherits="hospital_management.add_doctor" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1 {
font-size:xx-large;
text-align: center;
height: 109px;
color: #0033CC;
}
.auto-style2
{ width:241px;
}
.auto-style3 {
HOSPITAL MANAGEMENT SYSTEM

width:247px;
}
.auto-style4
{ width:167px;
}
.auto-style5
{ width: 241px;
text-align:right;
}
.auto-style6
{ width: 167px;
text-align:right;
}
body{
background-color:lightcyan;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<table style="width:100%;">
<tr>
<td class="auto-style1" colspan="4"><strong>Add Doctor </strong></td>
</tr>
<tr>
<tdclass="auto-style2">&nbsp;</td>
<tdclass="auto-style3">&nbsp;</td>
<tdclass="auto-style4">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style5">Doctor Id : </td>
<tdclass="auto-style3">
<asp:TextBoxID="TextBox1"runat="server"OnTextChanged="TextBox1_TextChanged"
Width="145px" TextMode="Number"></asp:TextBox>
</td>
<td class="auto-style6">Specialist : </td>
<td>
<asp:DropDownList ID="DropDownList2" runat="server" Height="21px" Width="135px">
<asp:ListItem>kidney </asp:ListItem>
<asp:ListItem>Liver</asp:ListItem>
<asp:ListItem>Eyes</asp:ListItem>
<asp:ListItem>Blood</asp:ListItem>
<asp:ListItem>skin</asp:ListItem>
<asp:ListItem>Heart</asp:ListItem>
<asp:ListItem>Lungs</asp:ListItem>
<asp:ListItem>others</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td class="auto-style5">Doctor Name : </td>
<td class="auto-style3">
<asp:TextBoxID="TextBox2"runat="server"OnTextChanged="TextBox2_TextChanged"
Width="152px"></asp:TextBox>
</td>
<td class="auto-style6">Contact : </td>
<td>
<asp:TextBoxID="TextBox3"runat="server"OnTextChanged="TextBox3_TextChanged"
TextMode="Number"></asp:TextBox>
</td>
</tr>
<tr>
HOSPITAL MANAGEMENT SYSTEM

<td class="auto-style5">Gender : </td>

<tdclass="auto-style3">
<asp:DropDownList ID="DropDownList1" runat="server" Height="19px" Width="102px">
<asp:ListItem>Male</asp:ListItem>
<asp:ListItem>Female</asp:ListItem>
<asp:ListItem>Other</asp:ListItem>
</asp:DropDownList>
</td>
<td class="auto-style6">Address : </td>
<td>
<asp:TextBoxID="TextBox4"runat="server"OnTextChanged="TextBox4_TextChanged"
TextMode="MultiLine"></asp:TextBox>
</td>
</tr>
<tr>
<tdclass="auto-style2">&nbsp;</td>
<tdclass="auto-style3">&nbsp;</td>
<tdclass="auto-style4">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style2">&nbsp;</td>
<td class="auto-style3">&nbsp;</td>
<tdclass="auto-style4">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style2">&nbsp;</td>
<tdclass="auto-style3">&nbsp;</td>
<tdclass="auto-style4">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style2">&nbsp;</td>
<tdclass="auto-style3">
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="ADD" Width="111px"
Height="39px" />
</td>
<tdclass="auto-style4">
<asp:Button ID="Button2" runat="server" Text="Cancel" Width="121px" OnClick="Button2_Click"
Height="42px" />
</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style2">&nbsp;</td>
<tdclass="auto-style3">&nbsp;</td>
<tdclass="auto-style4">&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
</form>
</body>
</html>
HOSPITAL MANAGEMENT SYSTEM

ADD DOCTOR.ASPX.CS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

namespace hospital_management
{
public partial class add_doctor : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-UNT2SKE;Initial
Catalog=HMS;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{

protected void TextBox1_TextChanged(object sender, EventArgs e)

{

protected void TextBox2_TextChanged(object sender, EventArgs e)

{
HOSPITAL MANAGEMENT SYSTEM

protected void TextBox3_TextChanged(object sender, EventArgs e)

{

protected void TextBox4_TextChanged(object sender, EventArgs e)

{

protected void Button1_Click(object sender, EventArgs e)

{
conn.Open();
string insert = "insert into adddoctor(doctorname,gender,specialist,contact,address) values('" + TextBox2.Text
+ "','" + DropDownList1.Text + "','" + DropDownList2.Text+ "','"+ TextBox3.Text + "','" + TextBox4.Text + "')";
SqlCommand cmd = new SqlCommand(insert, conn);
cmd.ExecuteNonQuery();
conn.Close();
Response.Write("<scriptLANGUAGE='JavaScript'>alert('Doctoradded')</script>");
TextBox1.Text = " ";
TextBox2.Text = " ";
TextBox3.Text = " ";
TextBox4.Text = " ";
}

protected void Button2_Click(object sender, EventArgs e)

{
Response.Redirect("homepage.aspx");
}
}
}
HOSPITAL MANAGEMENT SYSTEM

ADD NURSE.ASPX

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="add nurse.aspx.cs"

Inherits="hospital_management.add_nurse" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1 {
font-size:xx-large;
color: #000099;
text-align: center;
height: 82px;
}
.auto-style2
{ width:147px;
}
.auto-style3
{ width:321px;
}
body{
background-color:lightcyan;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<tablestyle="width:100%;">
<tr>
<td class="auto-style1" colspan="3"><strong>Add Nurse</strong></td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
HOSPITAL MANAGEMENT SYSTEM

<td class="auto-style2">&nbsp;</td>
<td>
&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style3">&nbsp;</td>
<td class="auto-style2">Name : </td>
<td>
<asp:TextBoxID="TextBox2" runat="server"
OnTextChanged="TextBox2_TextChanged"></asp:TextBox>
</td>
</tr>
<tr>
<tdclass="auto-style3">&nbsp;</td>
<td class="auto-style2">Email : </td>
<td>
<asp:TextBoxID="TextBox3" runat="server"
OnTextChanged="TextBox3_TextChanged"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<td class="auto-style2">Contact : </td>
<td>
<asp:TextBoxID="TextBox4" runat="server"
OnTextChanged="TextBox4_TextChanged"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<td class="auto-style2">Address : </td>
<td>
<asp:TextBoxID="TextBox5" runat="server" TextMode="MultiLine"
OnTextChanged="TextBox5_TextChanged"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<tdclass="auto-style2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<tdclass="auto-style2">
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Add" Width="100px"
Height="37px" />
</td>
<td>
<asp:Button ID="Button2" runat="server"OnClick="Button2_Click" Text="cancel" Width="122px"
Height="34px" />
</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<tdclass="auto-style2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
</form>
</body>
</html>
HOSPITAL MANAGEMENT SYSTEM

ADD NURSE.ASPX.CS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

namespace hospital_management
{
public partial class add_nurse : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-UNT2SKE;Initial
Catalog=HMS;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{

protected void Button2_Click(object sender, EventArgs e)

{
Response.Redirect("homepage.aspx");
}

protected void Button1_Click(object sender, EventArgs e)

{
conn.Open();
string insert = "insert into addnurse(name,email,contact,address) values('" + TextBox2.Text + "','" +
TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "')";
SqlCommand cmd = new SqlCommand(insert, conn);
cmd.ExecuteNonQuery();
conn.Close();
Response.Write("<scriptLANGUAGE='JavaScript'>alert('Nurse added')</script>");
TextBox2.Text = " ";
TextBox3.Text = " ";
TextBox4.Text = " ";
TextBox5.Text = " ";
}
HOSPITAL MANAGEMENT SYSTEM

protected void TextBox2_TextChanged(object sender, EventArgs e)

{

protected void TextBox3_TextChanged(object sender, EventArgs e)

{

protected void TextBox4_TextChanged(object sender, EventArgs e)

{

protected void TextBox5_TextChanged(object sender, EventArgs e)

{

}
}
}
HOSPITAL MANAGEMENT SYSTEM

ADD PHARMACISTS.ASPX

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="add pharmacists.aspx.cs"

Inherits="hospital_management.add_pharmacists" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1 {
font-size:xx-large;
color: #000099;
text-align: center;
height: 83px;
}
body{
background-color:lightcyan;
}
.auto-style3
{ width:301px;
}
.auto-style4
{ width:194px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<table style="width:100%;">
<tr>
<td class="auto-style1" colspan="3"><strong>Add Pharmacists</strong></td>
</tr>
<tr>
<tdclass="auto-style3">&nbsp;</td>
<tdclass="auto-style4">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<td class="auto-style4">Pharmacists Id : </td>
<td>
<asp:TextBoxID="TextBox1" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<tdclass="auto-style3">&nbsp;</td>
<td class="auto-style4">Name : </td>
<td>
HOSPITAL MANAGEMENT SYSTEM

<asp:TextBoxID="TextBox2" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<tdclass="auto-style3">&nbsp;</td>
<td class="auto-style4">Email : </td>
<td>
<asp:TextBoxID="TextBox3" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<td class="auto-style4">Contact : </td>
<td>
<asp:TextBoxID="TextBox4"runat="server" TextMode="Number"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<td class="auto-style4">Address : </td>
<td>
<asp:TextBoxID="TextBox5"runat="server" TextMode="MultiLine"></asp:TextBox>
</td>
</tr>
<tr>
<tdclass="auto-style3">&nbsp;</td>
<tdclass="auto-style4">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style3">&nbsp;</td>
<tdclass="auto-style4">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style3">&nbsp;</td>
<tdclass="auto-style4">
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Add" Width="98px"
Height="35px" />
</td>
<td>
<asp:Button ID="Button2" runat="server" Text="cancel" Width="108px" OnClick="Button2_Click"
Height="37px" />
</td>
</tr>
<tr>
<tdclass="auto-style3">&nbsp;</td>
<tdclass="auto-style4">&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
</form>
</body>
</html>
HOSPITAL MANAGEMENT SYSTEM

ADD PHARMACISTS.ASPX.CS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

namespace hospital_management
{
public partial class add_pharmacists : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-UNT2SKE;Initial
Catalog=HMS;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{

protected void Button1_Click(object sender, EventArgs e)

{
conn.Open();
string insert = "insert into addpharmacists(pharmacistsid,name,email,contact,address) values('" +
TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "')";
SqlCommand cmd = new SqlCommand(insert, conn);
cmd.ExecuteNonQuery();
conn.Close();
Response.Write("<script LANGUAGE='JavaScript' >alert('Pharmacists added')</script>");
TextBox1.Text = " ";
TextBox2.Text = " ";
TextBox3.Text = " ";
TextBox4.Text = " ";
TextBox5.Text = " ";
}

protected void Button2_Click(object sender, EventArgs e)

{
Response.Redirect("homepage.aspx");
}
}
}
HOSPITAL MANAGEMENT SYSTEM

ADD APPOINTMENT.ASPX
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="add appiontment.aspx.cs"
Inherits="hospital_management.add_appiontment" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1 { color:
#000099;
text-align: center;
font-size: xx-large;
height: 73px;
}
body{
background-color:lightcyan;
}
.auto-style2
{ width:325px;
}
.auto-style3
{ width:172px;
}
.auto-style4
{ width: 325px;
height: 37px;
}
.auto-style5
{ width: 172px;
height: 37px;
}
.auto-style6
{ height:37px;
}
.auto-style7
{ width: 325px;
height: 81px;
}
.auto-style8
{ width: 172px;
height: 81px;
}
.auto-style9
{ height:81px;
}
.auto-style10
{ width: 325px;
height: 52px;
}
.auto-style11
{ width: 172px;
height: 52px;
}
.auto-style12
{ height:52px;
}
.auto-style13
{ width: 325px;
HOSPITAL MANAGEMENT SYSTEM

height:42px;
}
.auto-style14
{ width:172px;
height:42px;
}
.auto-style15
{ height:42px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<table style="width:100%;">
<tr>
<td class="auto-style1"colspan="3"><strong>Add Appointment</strong></td>
</tr>
<tr>
<tdclass="auto-style2">&nbsp;</td>
<tdclass="auto-style3">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style13"></td>
<td class="auto-style14">Patient Name :</td>
<tdclass="auto-style15">
<asp:TextBoxID="TextBox1" runat="server" Width="147px"></asp:TextBox>
</td>
</tr>
<tr>
<tdclass="auto-style4"></td>
<td class="auto-style5">Disease : </td>
<tdclass="auto-style6">
<asp:DropDownList ID="DropDownList1" runat="server" Height="37px" Width="153px">
<asp:ListItem>kidney</asp:ListItem>
<asp:ListItem>liver</asp:ListItem>
<asp:ListItem>heart</asp:ListItem>
<asp:ListItem>blood</asp:ListItem>
<asp:ListItem>skin</asp:ListItem>
<asp:ListItem>eyes</asp:ListItem>
<asp:ListItem>others</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<tdclass="auto-style7"></td>
<td class="auto-style8">Doctor Appointed : </td>
<tdclass="auto-style9">
<asp:DropDownListID="DropDownList2"runat="server"DataSourceID="SqlDataSource1"
DataTextField="doctorname"DataValueField="doctorname"Height="39px" Width="162px">
</asp:DropDownList>
<asp:SqlDataSourceID="SqlDataSource1"runat="server"
ConnectionString="<%$ ConnectionStrings:HMSConnectionString %>" SelectCommand="SELECT [doctorname]
FROM [adddoctor]"></asp:SqlDataSource>
</td>
</tr>
<tr>
<tdclass="auto-style10"></td>
<td class="auto-style11">Appointment Date : </td>
<tdclass="auto-style12">
<asp:TextBox ID="TextBox2" runat="server" Width="164px"
placeholder="DD/MM/YYYY"></asp:TextBox>
</td>
HOSPITAL MANAGEMENT SYSTEM

</tr>
<tr>
<td class="auto-style2">&nbsp;</td>
<td class="auto-style3">Appointment Time : </td>
<td>
<asp:DropDownList ID="DropDownList3" runat="server" Height="31px" Width="151px">
<asp:ListItem>8:00 AM</asp:ListItem>
<asp:ListItem>9:00 AM</asp:ListItem>
<asp:ListItem>10:00 AM</asp:ListItem>
<asp:ListItem>11:00 AM</asp:ListItem>
<asp:ListItem>12:00 PM</asp:ListItem>
<asp:ListItem>2:00 PM</asp:ListItem>
<asp:ListItem>3:00 PM</asp:ListItem>
<asp:ListItem></asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<tdclass="auto-style2">&nbsp;</td>
<tdclass="auto-style3">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style2">&nbsp;</td>
<tdclass="auto-style3">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style2">&nbsp;</td>
<tdclass="auto-style3">
<asp:Button ID="Button1" runat="server" Text="ADD" Width="113px" Height="34px"
OnClick="Button1_Click"/>
</td>
<td>
<asp:Button ID="Button2" runat="server" Text="CANCEL" Width="115px" Height="33px"
OnClick="Button2_Click"/>
</td>
</tr>
<tr>
<tdclass="auto-style2">&nbsp;</td>
<tdclass="auto-style3">&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
</form>
</body>
</html>

ADD APPOINTMENT.ASPX.CS

using System;
using System.Collections.Generic;
using System.Linq;
HOSPITAL MANAGEMENT SYSTEM

using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

namespace hospital_management
{
public partial class add_appiontment : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-UNT2SKE;Initial
Catalog=HMS;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{

protected void Button1_Click(object sender, EventArgs e)

{
conn.Open();
string insert = "insert into
addappointment(patientname,disease,doctorappointed,appointementdate,appointmenttime) values('" + TextBox1.Text
+ "','" + DropDownList1.Text + "','" + DropDownList2.Text + "','" + TextBox2.Text + "','" + DropDownList3.Text +
"')";
SqlCommand cmd = new SqlCommand(insert, conn);
cmd.ExecuteNonQuery();
conn.Close();
Response.Write("<scriptLANGUAGE='JavaScript'>alert('appointmentadded')</script>");
TextBox1.Text = " ";
TextBox2.Text = " ";

protected void Button2_Click(object sender, EventArgs e)

{
Response.Redirect("homepage.aspx");
}
}
}

PATIENT LIST.ASPX

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
HOSPITAL MANAGEMENT SYSTEM

namespace hospital_management
{
public partial class add_appiontment : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-UNT2SKE;Initial
Catalog=HMS;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{

protected void Button1_Click(object sender, EventArgs e)

{
conn.Open();
string insert = "insert into
addappointment(patientname,disease,doctorappointed,appointementdate,appointmenttime)values('"+TextBox1.Text
+ "','" + DropDownList1.Text + "','" + DropDownList2.Text + "','" + TextBox2.Text + "','" + DropDownList3.Text +
"')";
SqlCommand cmd = new SqlCommand(insert, conn);
cmd.ExecuteNonQuery();
conn.Close();
Response.Write("<scriptLANGUAGE='JavaScript'>alert('appointmentadded')</script>");
TextBox1.Text = " ";
TextBox2.Text = " ";

protected void Button2_Click(object sender, EventArgs e)

{
Response.Redirect("homepage.aspx");
}
}
}

PATIENT LIST.ASPX.CS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace hospital_management
{
public partial class patients_list : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
HOSPITAL MANAGEMENT SYSTEM

protected void Button2_Click(object sender, EventArgs e)

{
Response.Redirect("homepage.aspx");
}
}
}

DOCTOR LISTS.ASPX

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="doctor_list.aspx.cs"

Inherits="hospital_management.WebForm1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1 {
color: #0000FF;
font-size: xx-large;
HOSPITAL MANAGEMENT SYSTEM

text-align:center;
height: 87px;
}

.auto-style2
{ width:308px;
}

.auto-style3
{ width:502px;
}

.auto-style4 { width:
502px; text-align:
center; height:
30px;
}

.auto-style5
{ width:308px;
height:30px;
}

.auto-style6
{ height:30px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>

<table style="width: 100%;">

<tr>
<td class="auto-style1" colspan="3"><strong>DoctorList</strong></td>
</tr>
<tr>
<td class="auto-style2">&nbsp;</td>
<td class="auto-style3">Search by Specialist&nbsp;
<asp:DropDownList ID="DropDownList1" runat="server" Height="29px" Width="169px">
<asp:ListItem>kidney</asp:ListItem>
<asp:ListItem>liver</asp:ListItem>
<asp:ListItem>lungs</asp:ListItem>
<asp:ListItem>heart</asp:ListItem>
<asp:ListItem>skin</asp:ListItem>
<asp:ListItem>eye</asp:ListItem>
<asp:ListItem>blood</asp:ListItem>
<asp:ListItem>other</asp:ListItem>
</asp:DropDownList>
&nbsp;&nbsp;&nbsp;&nbsp;
<asp:Button ID="Button1" runat="server" Text="Search" Width="77px" />
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style2">&nbsp;</td>
<tdclass="auto-style3">
HOSPITAL MANAGEMENT SYSTEM

<asp:GridViewID="GridView1" runat="server"AutoGenerateColumns="False"
DataKeyNames="doctorid" DataSourceID="SqlDataSource1" BackColor="White" BorderColor="#3366CC"
BorderStyle="None"BorderWidth="1px"CellPadding="4">
<Columns>
<asp:CommandFieldShowDeleteButton="True"ShowEditButton="True" />
<asp:BoundFieldDataField="doctorid"HeaderText="doctorid"SortExpression="doctorid"
InsertVisible="False" ReadOnly="True" />
<asp:BoundField DataField="doctorname" HeaderText="doctorname"
SortExpression="doctorname"/>
<asp:BoundField DataField="gender" HeaderText="gender" SortExpression="gender" />
<asp:BoundField DataField="specialist" HeaderText="specialist" SortExpression="specialist" />
<asp:BoundField DataField="contact" HeaderText="contact" SortExpression="contact" />
<asp:BoundField DataField="address"HeaderText="address" SortExpression="address" />
</Columns>
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
<RowStyle BackColor="White" ForeColor="#003399" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<SortedAscendingCellStyle BackColor="#EDF6F6" />
<SortedAscendingHeaderStyle BackColor="#0D4AC4" />
<SortedDescendingCellStyle BackColor="#D6DFDF" />
<SortedDescendingHeaderStyle BackColor="#002876" />
</asp:GridView>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style2">&nbsp;</td>
<tdclass="auto-style3">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style5"></td>
<tdclass="auto-style4">
<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="Home page" />
</td>
<tdclass="auto-style6"></td>
</tr>
<tr>
<tdclass="auto-style2">&nbsp;</td>
<tdclass="auto-style3">&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>

</div>

<asp:SqlDataSourceID="SqlDataSource1"runat="server"
ConnectionString="<%$ ConnectionStrings:HMSConnectionString %>" DeleteCommand="DELETE FROM
[adddoctor] WHERE [doctorid]
= @doctorid" InsertCommand="INSERT INTO [adddoctor] ([doctorname], [gender], [specialist], [contact], [address])
VALUES (@doctorname, @gender, @specialist, @contact, @address)" SelectCommand="SELECT * FROM
[adddoctor]" UpdateCommand="UPDATE [adddoctor] SET [doctorname] = @doctorname, [gender] = @gender,
[specialist] = @specialist, [contact] = @contact, [address] = @address WHERE [doctorid] = @doctorid"
FilterExpression="[specialist] LIKE '{0}%'">
<FilterParameters>
<asp:ControlParameterName="specialist"ControlID="DropDownList1" PropertyName="SelectedValue"
/>
</FilterParameters>
<DeleteParameters>
<asp:Parameter Name="doctorid" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="doctorname" Type="String" />
HOSPITAL MANAGEMENT SYSTEM

<asp:Parameter Name="gender" Type="String" />

<asp:Parameter Name="specialist" Type="String" />
<asp:Parameter Name="contact" Type="String" />
<asp:Parameter Name="address" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="doctorname" Type="String" />
<asp:Parameter Name="gender" Type="String" />
<asp:Parameter Name="specialist" Type="String" />
<asp:Parameter Name="contact" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="doctorid" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>

</form>
</body>
</html>

DOCTOR LIST.ASPX.CS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;

namespace hospital_management
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

protected void Button2_Click(object sender, EventArgs e)

{
Response.Redirect("homepage.aspx");
}
}
}
HOSPITAL MANAGEMENT SYSTEM

NURSE LIST.ASPX
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="nurse_list.aspx.cs"
Inherits="hospital_management.nurse_list" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1
{ width:309px;
}

.auto-style2
{ width:309px;
height:76px;
}

.auto-style3
{ height:76px;
}

.auto-style4
{ width:309px;
height:64px;
}

.auto-style5
{ height:64px;
}

.auto-style6
{ width: 309px;
height:37px;
HOSPITAL MANAGEMENT SYSTEM

.auto-style7
{ height:37px;
}

.auto-style8
{ text-align:
left;
}

.auto-style9
{ width:309px;
height:23px;
}

.auto-style10
{ height:23px;
}
.auto-style11 {
text-align: center;
font-size:xx-large;
color: #000099;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<table style="width: 100%;">
<tr>
<td colspan="3" class="auto-style11"><strong>&nbsp;&nbsp; Search Nurse </strong></td>
</tr>
<tr>
<tdclass="auto-style6"></td>
<tdclass="auto-style7"></td>
<tdclass="auto-style7"></td>
</tr>
<tr>
<td class="auto-style4"></td>
<td class="auto-style5">search by Nurse name
<asp:TextBoxID="TextBox1"runat="server"Width="150px"></asp:TextBox>
&nbsp;&nbsp;&nbsp;
<asp:Button ID="Button1" runat="server" Text="Search" Width="81px" OnClick="Button1_Click" />
</td>
<tdclass="auto-style5"></td>
</tr>
<tr>
<tdclass="auto-style2"></td>
<tdclass="auto-style3">
<asp:SqlDataSourceID="SqlDataSource1"runat="server"
ConnectionString="<%$ ConnectionStrings:HMSConnectionString %>" SelectCommand="SELECT [name] FROM
[addnurse] WHERE ([name] = @name)">
<SelectParameters>
<asp:ControlParameterControlID="TextBox1"Name="name" PropertyName="Text"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</td>
<tdclass="auto-style3"></td>
</tr>
<tr>
<td class="auto-style1">&nbsp;</td>
<td>
HOSPITAL MANAGEMENT SYSTEM

<asp:GridViewID="GridView1" runat="server"AutoGenerateColumns="False"BackColor="White"
BorderColor="#3366CC"BorderStyle="None"BorderWidth="1px"CellPadding="4"
DataSourceID="SqlDataSource2" Width="333px" EmptyDataText="no data yet" DataKeyNames="nurseid">
<Columns>
<asp:CommandFieldShowDeleteButton="True"ShowEditButton="True" />
<asp:BoundFieldDataField="nurseid"HeaderText="nurseid"SortExpression="nurseid"
InsertVisible="False" ReadOnly="True" />
<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
<asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />
<asp:BoundField DataField="contact" HeaderText="contact" SortExpression="contact" />
<asp:BoundField DataField="address" HeaderText="address" SortExpression="address" />
</Columns>
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
<RowStyle BackColor="White" ForeColor="#003399" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<SortedAscendingCellStyle BackColor="#EDF6F6" />
<SortedAscendingHeaderStyle BackColor="#0D4AC4" />
<SortedDescendingCellStyle BackColor="#D6DFDF" />
<SortedDescendingHeaderStyle BackColor="#002876" />
</asp:GridView>
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style1">&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style1">
<asp:SqlDataSourceID="SqlDataSource2"runat="server"
ConnectionString="<%$ ConnectionStrings:HMSConnectionString %>" DeleteCommand="DELETE FROM
[addnurse] WHERE [nurseid] =
@nurseid" InsertCommand="INSERT INTO [addnurse] ([name], [email], [contact], [address]) VALUES (@name,
@email, @contact, @address)" SelectCommand="SELECT * FROM [addnurse]" UpdateCommand="UPDATE
[addnurse] SET [name] = @name, [email] = @email, [contact] = @contact, [address] = @address WHERE [nurseid]
= @nurseid">
<DeleteParameters>
<asp:Parameter Name="nurseid" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="email" Type="String" />
<asp:Parameter Name="contact" Type="String" />
<asp:Parameter Name="address" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="email" Type="String" />
<asp:Parameter Name="contact" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="nurseid" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
</td>
<tdclass="auto-style8">
<asp:Button ID="Button2" runat="server" Height="32px" OnClick="Button2_Click" Text="Home Page"
Width="123px" />
</td>
<td>&nbsp;</td>
</tr>
<tr>
HOSPITAL MANAGEMENT SYSTEM

<tdclass="auto-style9"></td>
<td class="auto-style10">&nbsp;&nbsp;
</td>
<tdclass="auto-style10"></td>
</tr>
<tr>
<td class="auto-style1">&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style1">&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style1">&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
</form>
</body>
</html>
HOSPITAL MANAGEMENT SYSTEM

NURSE LIST.ASPX.CS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;

namespace hospital_management
{
public partial class nurse_list : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

protected void Button2_Click(object sender, EventArgs e)

{
Response.Redirect("homepage.aspx");
}

protected void Button1_Click(object sender, EventArgs e)

{

}
}
}
HOSPITAL MANAGEMENT SYSTEM

PHARMACISTS LIST.ASPX
<%@ Page Language="C#" AutoEventWireup="true" Codefile="pharmacists _list.aspx.cs"
Inherits="hospital_management.pharmacists list" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1
{ width:271px;
}
.auto-style2
{ width:469px;
}
.auto-style3
{ width:271px;
height:76px;
}
.auto-style4
{ width:469px;
height: 76px;
}
.auto-style5
{ height:76px;
}
.auto-style6
{ width:
469px; text-
align:left;
}
.auto-style7
{ width: 271px;
height:100px;
}
.auto-style8
{ width: 469px;
height: 100px;
font-size:xx-large;
color: #003399;
text-align: center;
}
.auto-style9
{ height:100px;
}
.auto-style10
{ width: 271px;
text-align:right;
}
</style>
</head>
<body>
<form id="form1" runat="server">

<tablestyle="width:100%;">
HOSPITAL MANAGEMENT SYSTEM

<tr>
<tdclass="auto-style7"></td>
<tdclass="auto-style8"><strong>SearchPharmacists</strong></td>
<tdclass="auto-style9"></td>
</tr>
<tr>
<td class="auto-style1">&nbsp;</td>
<td class="auto-style2">Search by Pharmacists Name&nbsp;
<asp:TextBoxID="TextBox1"runat="server"OnTextChanged="TextBox1_TextChanged"style="height:
22px"></asp:TextBox>
&nbsp;
<asp:Button ID="Button1" runat="server" Text="Search" Width="84px" OnClick="Button1_Click" />
</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style3"></td>
<tdclass="auto-style4">
<asp:SqlDataSourceID="SqlDataSource1"runat="server"
ConnectionString="<%$ ConnectionStrings:HMSConnectionString %>" SelectCommand="SELECT * FROM
[addpharmacists] WHERE ([name] = @name)">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="name" PropertyName="Text"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</td>
<tdclass="auto-style5"></td>
</tr>
<tr>
<td class="auto-style1">&nbsp;</td>
<tdclass="auto-style2">
<asp:GridViewID="GridView1" runat="server"AutoGenerateColumns="False"BackColor="White"
BorderColor="#3366CC"BorderStyle="None"BorderWidth="1px"CellPadding="4"
DataSourceID="SqlDataSource2" Width="442px" DataKeyNames="pharmacistsid">
<Columns>
<asp:CommandFieldShowDeleteButton="True"ShowEditButton="True" />
<asp:BoundField DataField="pharmacistsid" HeaderText="pharmacistsid"
SortExpression="pharmacistsid"InsertVisible="False" ReadOnly="True" />
<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
<asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />
<asp:BoundField DataField="contact" HeaderText="contact" SortExpression="contact" />
<asp:BoundField DataField="address" HeaderText="address" SortExpression="address" />
</Columns>
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
<RowStyle BackColor="White" ForeColor="#003399" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<SortedAscendingCellStyle BackColor="#EDF6F6" />
<SortedAscendingHeaderStyle BackColor="#0D4AC4" />
<SortedDescendingCellStyle BackColor="#D6DFDF" />
<SortedDescendingHeaderStyle BackColor="#002876" />
</asp:GridView>
</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style1">&nbsp;</td>
<tdclass="auto-style2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
HOSPITAL MANAGEMENT SYSTEM

<td class="auto-style10">&nbsp;</td>
<tdclass="auto-style6">
<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="Home Page" />
</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style1">
<asp:SqlDataSourceID="SqlDataSource2"runat="server"
ConnectionString="<%$ ConnectionStrings:HMSConnectionString %>" SelectCommand="SELECT * FROM
[addpharmacists]" DeleteCommand="DELETE FROM [addpharmacists] WHERE [pharmacistsid] =
@pharmacistsid" InsertCommand="INSERT INTO [addpharmacists] ([name], [email], [contact], [address])
VALUES (@name,
@email, @contact, @address)" UpdateCommand="UPDATE [addpharmacists] SET [name] = @name, [email] =
@email, [contact] = @contact, [address] = @address WHERE [pharmacistsid] = @pharmacistsid">
<DeleteParameters>
<asp:Parameter Name="pharmacistsid" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="email" Type="String" />
<asp:Parameter Name="contact" Type="String" />
<asp:Parameter Name="address" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="email" Type="String" />
<asp:Parameter Name="contact" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="pharmacistsid" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
</td>
<td class="auto-style2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>

</form>
</body>
</html>

PHARMACISTS LIST.ASPX.CS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;

namespace hospital_management
HOSPITAL MANAGEMENT SYSTEM

{
public partial class pharmacists list : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

protected void Button2_Click(object sender, EventArgs e)

{
Response.Redirect("homepage.aspx");
}

protected void TextBox1_TextChanged(object sender, EventArgs e)

{

protected void Button1_Click(object sender, EventArgs e)

{

}
}
}

APPOINTMENT LIST.ASPX

<%@ Page Language="C#" AutoEventWireup="true" Codefile="appointment list.aspx.cs"

Inherits="hospital_management.appointment_list" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style2 {
HOSPITAL MANAGEMENT SYSTEM

text-align:center;
height: 77px;
}
.auto-style3 {
font-size:xx-large;
color: #0000FF;
}
.auto-style4
{ width:452px;
}
.auto-style5
{ width:226px;
}
body{
background-color:azure;
}
.auto-style6 { width:
452px; text-align:
center;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>

<table style="width:100%;">
<tr>
<td class="auto-style2" colspan="3"><strong>
<asp:Label ID="Label1" runat="server" CssClass="auto-style3" Text="Appointments ..."></asp:Label>
</strong></td>
</tr>
<tr>
<tdclass="auto-style5">&nbsp;</td>
<tdclass="auto-style4">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style5">&nbsp;</td>
<tdclass="auto-style4">
<asp:GridViewID="GridView1" runat="server"BackColor="White" BorderColor="#3366CC"
BorderStyle="None"BorderWidth="1px"CellPadding="4"DataSourceID="SqlDataSource1"
OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
<Columns>
<asp:CommandFieldShowEditButton="True" />
<asp:CommandField/>
<asp:CommandFieldShowDeleteButton="True" />
</Columns>
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
<RowStyle BackColor="White" ForeColor="#003399" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<SortedAscendingCellStyle BackColor="#EDF6F6" />
<SortedAscendingHeaderStyle BackColor="#0D4AC4" />
<SortedDescendingCellStyle BackColor="#D6DFDF" />
<SortedDescendingHeaderStyle BackColor="#002876" />
</asp:GridView>
<asp:SqlDataSourceID="SqlDataSource1"runat="server"
ConnectionString="<%$ ConnectionStrings:HMSConnectionString %>"
SelectCommand="SELECT * FROM [addappointment]"></asp:SqlDataSource>
</td>
<td>&nbsp;</td>
HOSPITAL MANAGEMENT SYSTEM

</tr>
<tr>
<tdclass="auto-style5">&nbsp;</td>
<tdclass="auto-style6">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style5">&nbsp;</td>
<tdclass="auto-style4">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="auto-style5">&nbsp;</td>
<tdclass="auto-style6">
<asp:Button ID="Button1" runat="server" Height="37px" OnClick="Button1_Click" Text="Homepage"
Width="108px" />
</td>
<td>&nbsp;</td>
</tr>
<tr>
<tdclass="auto-style5">&nbsp;</td>
<tdclass="auto-style4">&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>

</div>
</form>
</body>
</html>

APPOINTMENT LIST.ASPX.CS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
usingSystem.Web.UI.WebControls;

namespace hospital_management
{
public partial class appointment_list : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
HOSPITAL MANAGEMENT SYSTEM

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)

{

protected void Button1_Click(object sender, EventArgs e)

{
Response.Redirect("homepage.aspx");
}
}
}

SERVICES.ASPX

<%@ Page Title="" Language="C#"MasterPageFile="~/master1.Master" AutoEventWireup="true"

CodeBehind="services.aspx.cs"Inherits="hospital_management.contact" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">

<style type="text/css">
.auto-style2
{ width:498px;
}
.auto-style3{
text-align:center;
color:blue;
}
.auto-style5
{ height:
97px;
text-align: center;

}
.auto-style7 {
width:231px;
HOSPITAL MANAGEMENT SYSTEM

}
</style>

</asp:Content>
<asp:ContentID="Content2" ContentPlaceHolderID="Content" runat="server">
<table style="width: 100%;">
<tr>
<td colspan="4"><h1 class="auto-style3"> Services</h1></td>
</tr>
<tr>
<td class="auto-style5" colspan="2">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<asp:Image ID="Image1" runat="server" Height="300px" ImageUrl="~/scripts/servicespic1.jpg"
Width="500px" />
</td>
<td class="auto-style5" colspan="2">
<asp:Image ID="Image2" runat="server" Height="300px" ImageUrl="~/scripts/servicespic2.jpg"
Width="500px" />
</td>
</tr>
<tr>
<td class="auto-style2">&nbsp;</td>
<td class="auto-style7" colspan="2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td colspan="4" style="color:blue;"><h2>Scope Of Services </h2><hr />
<br />
1.Eye Department.<br />
2.General Surgery.<br />
3.Emergency & Ambulance Services<br />
4.Pathology<br />
5. Radiology & Ultrasonology<br />
6.Physiotherephy<br/>
7.Cardiology<br />
8.General Medicine<br />
9.general Surgery<br />
10.Nero Surgery<br />
</td>
</tr>
<tr>
<tdcolspan="4">&nbsp;</td>
</tr>
</table>
</asp:Content>
<asp:ContentID="Content3" ContentPlaceHolderID="footer" runat="server">
</asp:Content>
HOSPITAL MANAGEMENT SYSTEM

ABOUT US.ASPX

<%@ Page Title="" Language="C#"MasterPageFile="~/master1.Master" AutoEventWireup="true"

CodeBehind="About.aspx.cs"Inherits="hospital_management.About"%>

<asp:ContentID="Content1" ContentPlaceHolderID="head" runat="server">

</asp:Content>
<asp:ContentID="Content2" ContentPlaceHolderID="Content" runat="server">

<style type="text/css">
.auto-style1 {
text-align: center;
}
</style>
<style type="text/css">
.auto-style1 {
text-align: center;
}
</style>
<style type="text/css">
.auto-style1 {
HOSPITAL MANAGEMENT SYSTEM

text-align: center;
}
</style>

<table style="width: 100%;">

<tr>
<td>
<h1 style="align-content: center; background-color: blue; color: white;" class="auto-style1"><b>About
Us</b></h1>
</td>

</tr>
<tr>
<td class="auto-style1">
<br />
<asp:Image ID="Image1" runat="server" Height="270px" ImageUrl="~/scripts/doctor group.png"
Width="650px" />
<br />
</td>
</tr>

<tr>

<td style="color: blue;">

<h2>Dear All</h2>
<p>
Our Hospital which was established in 1968.With an aim of providing serice to people
charity and excellence.this is a 404 bedded multispeciality ISO certified ,NABL accredicated hospital
offerig excellent care in affordable price.The main motto of the institute is care ,conern and commitment
to the patient .
</p>

<b> The mix of activity includes:</b><br />

1. Patient care.
<br />
2. Community health programs
.<br />
3. school health programs
.<br />
4. CSR activity. <br />

<br />
<b>Thank You</b><br />
</td>
</tr>

</table>
</asp:Content>
<asp:ContentID="Content3" ContentPlaceHolderID="footer" runat="server">
</asp:Content>
HOSPITAL MANAGEMENT SYSTEM

5.3SYSTEM TESTING

One of the purposes of the testing is to validate and verify the system. Verification means
checking the system to ensure that it is doing what the function is supposed to do and Validation
means checking to ensure that system is doing what the user wants it to do.
No program or system design is perfect; communication between the user and the
designer is not always complete or clear, and time is usually short. The result is errors and more
errors. Theoretically, a newly designed system should have all the pieces in working order, but
in reality, each piece works independently. Now is the time to put all the pieces into one system
and test it to determine whether it meets the user's requirements. This is the best chance to
detect and correct errors before the system is implemented. The purpose of system testing is to
consider all the likely variations to which it will be subjected and then push the system to its
limits. If we implement the system without proper testing then it might cause the problems.

1. Communication between the user and the designer.

2. The programmer's ability to generate a code that reflects exactly the system specification.

3. The time frame for the design.

Theoretically, a new designed system should have all the pieces in working order, but in reality,
each piece works independently. Now is the time to put all the pieces into one system and test

it to determine whether it meets the requirements of the user. The process of system testing and
the steps taken to validate and prepare a system for final implementation are:

LEVELS OF TESTING:

The different types of testing are as follows:

HOSPITAL MANAGEMENT SYSTEM

Unit Testing:
This is the smallest testable unit of a computer system and is normally tested using the white
box testing. The author of the programs usually carries out unit

tests.

This is the test in the development process and ensures that each unique path of the
project performs accurately to the documented specifications and contains clearly defined

inputs and expected results. In the unit testing the analyst tests the program making up a
system. The software units in a system are the modules and routines that are assembled and
integrated to perform a specific function. In a large system, many modules on different levels
are needed.
Unit testing can be performed from the bottom up starting with the smallest and
lowest level modules and proceeding one at a time. For each module in a bottom-up testing, a
short program executes the module and provides the needed data. Each module

was tested to ascertain that it fully performs as expected.

In integration testing, this is the test in the development process and ensures that each
unique path of the project performs accurately to the documented specifications and contains
clearly defined inputs and expected results. In the unit testing the analyst tests the program
making up a system. The software units in a system are the modules and routines that are
assembled and integrated to perform a specific function. In a large system, many modules on
different levels are needed.
Unit testing can be performed from the bottom up starting with the smallest and
lowest level modules and proceeding one at a time. For each module in a bottom-up testing, a
short program executes the module and provides the needed data. Each module

was tested to ascertain that it fully performs as expected.

Integration Testing:
HOSPITAL MANAGEMENT SYSTEM

In integration testing, the different units of the system are integrated together to form the
complete system and this type of testing checks the system as whole to ensure that it is doing
what is supposed to do. The testing of an integrated system can be carried out top-down,
bottom-up, or big-bang. In this type of testing, some parts will be tested with white box testing
and some with black box testing techniques. This type of testing plays very important role in
increasing the systems productivity. We have checked our system by using the integration
testing techniques.

System Testing:

A part from testing the system to validate the functionality of software against the
requirements, it is also necessary to test the non-functional aspect of the system. Some

examples of non-functional tools include tests to check performance, data security,

usability/user friendliness, volume, load/stress that we have used in our project to test the
various modules.

System testing consists of the following steps:

1. Program(s) testing.

2. String testing.

3. System testing.

4. System documentation.

5. User acceptance testing.

Field Testing:

This is a special type of testing that may be very important in some projects. Here the
system is tested in the actual operational surroundings. The interfaces with other systems and

the real world are checked. This type of testing is very rarely used.
HOSPITAL MANAGEMENT SYSTEM

Acceptance Testing:
After the developer has completed all rounds of testing and he is satisfied with the system, then

the user takes over and re-tests the system from his point of view to judge whether it is

acceptable according to some previously identified criteria. This is almost always a tricky

situation in the project because of the inherent conflict between the developer and the user. In

this project, it is the job of the bookstores to check the system that whether the made system

fulfills the goals or not.

Why System Testing?

Testing is vital to the success of the system. System testing makes a logical assumption

that if all the parts of the system are correct, the goal will be successfully achieved. Inadequate

testing results in two types of problems:

1. The time lag between the cause and the appearance of the problem.

2. The effect of system errors on the files and records within the system.

Another reason for system testing is its utility as a user-oriented vehicle before

implementation.

Activity Network for System

Testing

The test plan entails the following activities:

1. Prepare test plan.

2. Specify conditions for user acceptance testing.

3. Prepare test data for program testing.

4. Prepare test data for transaction path testing.

HOSPITAL MANAGEMENT
SYSTEM

5. Plan user training.

6. Compile/assemble programs.

7. Prepare job performance aids.

8. Prepare operational documents.

Prepare Test
A workable test plan must be prepared in accordance with established design

specifications. It includes the following items:

• Outputs expected from the system.

• Criteria for evaluating outputs.

• A volume of test data.

• Procedure for using test data.

• Personnel and training requirements.

Specify Conditions for User Acceptance Testing

Planning for user acceptance testing calls for the analyst and the user to agree on conditions

for the test.

Prepare Test Data for Program Testing

As each program is coded, test data are prepared and documented to ensure that all aspects of

the program are properly tested.

Prepare Test Data for Transaction Path Testing

This activity develops the data required for testing every condition and transactions to be
introduced into the system. The path of each transaction from origin to destination is carefully

tested reliable results.

Plan User Training

User training is designed to prepare the user for testing and converting the system.

User involvement and training take place parallel with programming for three reasons:

• The system group has time available to spend on training while the programs are

being written.
HOSPITAL MANAGEMENT SYSTEM

• Initiating a user-training program gives the systems group a clearer image of the

user's interest in the new system.

• A trained user participates more effectively in system testing.

The training plan is followed by preparation of the user training manual and other text

materials.

Compile / Assemble Programs

All programs have to be compiled / assembled for testing.

Prepare Job Performance Aids

In this activity the materials to be used by personnel to run the system are specified and
scheduled. This includes a display of materials.
Prepare Operational Documents
During the test plan stage, all operational documents are finalized including copies of the
operational formats required by the candidate system.

System testing

The computer department to ensure that the system functions as specified does this testing. This
testing is important to ensure that a working system is handed over to the user for acceptance

testing.

Acceptance testing.

The user to ensure that the system functions, as the user actually wanted performs this testing.
With prototyping techniques, this stage becomes very much a formality to check the accuracy

and completeness of processing. The screen layouts and output should already have been tested

during the prototyping phase.

An error in the program code can remain undetected indefinitely. To prevent this from

happening the code was tested at various levels. To successfully test a system, each condition,
HOSPITAL MANAGEMENT SYSTEM

and combinations of conditions had to be tested. Each program was tested and linked to other

programs. This unit of program is tested and linked to other units and so on until the complete

system has been tested.

The purpose of testing is to ensure that each program is fully tested. To do so a test

plan had to be created. The test plan consists of a number of test runs such as the valid paths

through the code, and the exception and error handling paths. For each test run there is a list

of conditions tested, the test data used and the result expected. The test plan was then reviewed

to check that each path through the code is tested correctly. It is the responsibility of the

programmer to collect the data that will produce the required test condition.

VERIFICATION AND VALIDATION (V&V):

The objectives of verification, validity activities are to assess and improve the quality of the
work products generated during development and modification of the software. Quality

depends upon the various attributes like correctness, completeness, consistency, reliability,

usefulness, usability, efficiency and conformance to standards.

The terms verification and validation are used synonymously. These are defined as under: -

Verification: “Are we building the product right?”

Validation: “Are we building the right product?”

Verification activities include proving, testing, and reviews. Validation is the process of

evaluating software at the end of the software development to ensure compliance with the
software requirements. Testing is a common method of validation. Clearly, for high reliability

we need to perform both activities. Together, they are often called V&V

activities.
HOSPITAL MANAGEMENT SYSTEM

The major V&V activities for software development are inspection, reviews, and testing

(both static and dynamic). The V&V plan identifies the different V&V tasks for the different

phases and specifies how these tasks contribute to the project V&V goals. The methods to be

used for performing these V&V activities, the responsibilities and milestones for each of these

activities, inputs and outputs for each V&V task, and criteria for evaluating the outputs are also

specified.

The two major V&V approaches are testing and inspections. Testing is an activity that can be
generally performed only on code. It is an important activity and is discussed in detail in a
later chapter. Inspection is a more general activity that can be applied to any work product,
including code. Many of the V&V tasks are such that for them, an inspection type of activity
is the only possible way to perform the tasks (e.g. trace ability and document evaluation).
Due to this, inspections play a significant role in verification.

5.4TEST CASE
Test Test Scenario Pre steps Input data Expected Actual Staus
Case ID requisite Output Output

TC_01 Check Testfiled & 1Select P:abhi User As PASS

customer Number plain text K:1234 should expected
login with filed 2.Enter login into
valid data should be numeric application
enable key
TC_02 Check Testfiled & 1Select P: abhi User Error Fail
customer Number plain text K:123@ should
login with filed 2.Enter login into
invalid data should be numeric application
enable key
No special 3.Enter
charater special
charater
TC_03 Check Testfiled & 1Select P: abhi User As PASS
Members Number plain text K:1234 should expected
login with filed 2.Enter login into
valid data should be numeric application
enable key
TC-04 Check Testfiled & 1Select P: abhi User Error FAIL
Members Number plain text K:1234 should
filed
HOSPITAL MANAGEMENT SYSTEM

login with should be 2.Enter login into

invalid data enable numeric application
key
TC-05 Check Admin Testfiled & 1Select P: abhi User As PASS
login with Number plain text K:1234 should Expected
valid data filed 2.Enter login into
should be numeric application
enable key
TC-06 Check Admin Testfiled & 1Select P: abhi User Error FAIL
login with Number plain text K:1234 should
invalid data filed 2.Enter login into
should be numeric application
enable key
TC-07 Check Book Testfiled & 1Select P: abhi User As PASS
inventory Number plain text K:1234 should Expected
with valid filed 2.Enter login into
data should be numeric application
enable key
TC-08 Check Book Testfiled & 1Select P: abhi User Error FAIL
inventory Number plain text K:1234 should
without valid filed 2.Enter login into
data should be numeric application
enable key
TC-09 Check Book Testfiled & 1Select P: abhi User As PASS
inventory Number plain text K:1234 should Expected
with valid filed 2.Enter login into
data should be numeric application
enable key
TC-10 Check Book Testfiled & 1Select P: abhi User Error FAIL
inventory Number plain text K:1234 should
with invalid filed 2.Enter login into
data should be numeric application
enable key
TC-11 Check user Testfiled & 1Select P: abhi User As PASS
profile with Number plain text K:1234 should Expected
valid data filed 2.Enter login into
should be numeric application
enable key
TC-12 Check user Testfiled & 1Select P: abhi User Error FAIL
profile with Number plain text K:1234 should
invalid data filed 2.Enter login into
should be numeric application
enable key
TC-13 Check user Testfiled & 1Select P: abhi User As PASS
profile with Number plain text K:1234 should Expected
valid data filed 2.Enter login into
should be numeric application
enable key
TC-14 Check user Testfiled & 1Select P: abhi User Error FAIL
profile with Number plain text K:1234 should
invalid data filed 2.Enter login into
should be numeric application
enable key
HOSPITAL MANAGEMENT SYSTEM

TC-15 Check Admin Testfiled & 1Select P: abhi User As PASS

author profile Number plain text K:1234 should Expected
with valid filed should 2.Enter login into
data be enable numeric application
key
TC-16 Check Admin Testfiled & 1Select P: abhi User Error FAIL
book issue Number plain text K:1234 should
profile profile filed should 2.Enter login into
with invalid be enable numeric application
data key
TC-17 Check admin Testfiled & 1Select P: abhi User As PASS
book issue Number plain text K:1234 should Expected
profile with filed should 2.Enter login into
valid data be enable numeric application
key
TC-09 Check Testfiled & 1Select P: abhi User As PASS
publisher Number plain text K:1234 should Expected
management filed should 2.Enter login into
with valid be enable numeric application
data key
TC-10 Chec Testfiled & 1Select P: abhi User Error FAIL
Publisher Number plain text K:1234 should
Management filed should 2.Enter login into
invalid data be enable numeric application
key
TC-16 Check Admin Testfiled & 1Select P: abhi User As PASS
author profile Number plain text K:1234 should Expected
profile with filed 2.Enter login into
valid data should be numeric application
enable key
TC-10 Chec Menber Testfiled & 1Select P: abhi User Error FAIL
management Number plain text K:1234 should
invalid data filed 2.Enter login into
should be numeric application
enable key
HOSPITAL MANAGEMENT SYSTEM

CHAPTER 6: - RESULTS AND DISCUSSION

Homepage

Login page
HOSPITAL MANAGEMENT SYSTEM

Register page
HOSPITAL MANAGEMENT SYSTEM

Dashboard page
HOSPITAL MANAGEMENT SYSTEM

Patient list

Doctor list

Appointment List
HOSPITAL MANAGEMENT SYSTEM

CONTACT:
 CHAPTER 7: - CONCLUSIONS
7.1Conclusions

This project has been a rewarding experience in more than one way. The entire project
work has enlightened us in the following areas.

a) We have gained an insight into the working of the HOSPITAL. This represents a
typical real world situation.

b) Our understanding of database design has been strengthened this is because in order
to generate the final reports of database designing has to be properly followed.

c) Scheduling a project and adhering to that schedule creates a strong sense of

time management.

d) Sense of teamwork has developed and confidence of handling real life project has
increased to a great extent.

e) Initially, there were problem with the validation but with discussions, we were
to implement validations.

Limitations of the system

o Online payment is not available at this version.
o Data delete & edit system is not available
for all section.
o User account not verified by Mobile SMS not
available in this system. o Loss of data due
to mismanagement.

7.2Future plan

o Diagnostics billing system.

o This application avoids the manual work and the problems concern with it. It is an easy
way to obtain the information regarding the various travel services that are present in our
System. Well I and my team member have worked hard in order to present an improved
website better than the existing one’s regarding the information about the various
activities. Still, we found out that the project can be done in a better way. Primarily, In this
system patient login and then go to reception. By using this patient will send request for
consulting the doctor. Reception will set the date for doctor appointments. After that
doctor see his appointments and see the patients, surgeries also done. The next
enhancement is, we will develop online services. That mean, if patient have any problems
he can send his problem to the doctor through internet from his home then doctor will
send reply to him. In this patients have some login name and password.
HOSPITAL MANAGEMENT SYSTEM

7.3REFERENCES

Asp.Net: The Complete Reference

Book by Matthew MacDonald

Microsoft ASP.NET and AJAX: Architecting Web Applications

Book by Dino Esposito

Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition

Book by Dušan Petkovic

WEBSITES:
www.google.com
www.microsoft.com