1

CHAPTER - 1

SYNOPSIS

1.1 Name of project Health services & medical events tracking system

1.2 Object/Vision To maintain a website which provide details of ongoing &

upcoming medical events in a city also providing some other

health related services.

1.3 Users of the

system

1. Admin

2. Registered members-

a. Organizations (those which arrange events).

b. Users (those receiving health services &

participating in events)

c. Hospital representatives

d. Health experts

3. Guest

1.4 Functional

Requirement

1. Admin approves registration of user, manage users,

appoints doctor, edits & approves details of hospitals

and doctors etc.

2. Organization can register and post details about their

events or requirements. Can see details of participating

users and contact them.

3. User can register, subscribe for specific events.

4. Users can also post/read health related articles.

5. A registered user or guest can search about hospitals and

specialized doctors.

6. Users can give feedback.

7. Hospital representatives can give brief description about

their hospital.

1.5 Non Functional

Requirement

1. More advance than existing system, better for society.

2. 24x7 availability

3. Data access from database and code is secure

4. System will be easily scalable to accommodate large

traffic.

5. Maintenance will be easy

2

1.6 Optional

Features

1. Organization can search participating users for his

details.

2. Interaction among users.

3. A forum for health related queries.

1.7 User Interface

Priorities

1. Professional look and feel

2. Reports exporting facility.

3. Doctor consultancy avail.

4. Support major modern browsers.

5. Use of AJAX in forms; wherever required.

6. Reporting via Crystal reports.

1.8 Reports Reports can be generated on monthly basis of Organized events

and their participating users , number of patients who got help

from system, registered organizations etc.

1.9 Other Important

Issues

1. Notification, if change of events timings to its

subscriber.

2. Timely reminders of oncoming events.

1.10 Team Size 3

1.11 Technology to

be used

1. ASP.NET With C#, AJAX

2. For designing HTML,CSS

3. For Database connectivity ADO.NET

1.12 Tools to be used 1. Microsoft Visual studio-2012

2. MS-SQL Server 2012

1.13 Final

deliverable must

include

1. Application archive with source code.

2. Script of complete Database(.sql file)

3. Complete Source Code.

3

CHAPTER - 2

Scope of work And Boundary conditions

2.1 Scope of Work

The project “Health services & Medical events tracking system” is an attempt to create a

web based system that will aid the users with their health related queries, and, will keep

them updated about various medical events in a city & the various details regarding those

events. Also it will allow organizations to create such events online.

This project is intended for all those people & organizations that seek medical services in

their area; and also, for those looking for solutions to their health related problems. An

individual/organization can select an area to see all the ongoing/upcoming health related

services or medical campaigns in that area to participate in them or they may simply read

or post health related articles or post their relevant queries for solution by experts.

It provides a very good centralized platform to all such services & their hosts. Small

organizations intending to host medical events in a city can take the advantage of free

publicity of their events through this site. It will also help them to reduce the amount of

paper work needed to be done during such events, as all the data will be maintained

online, so they are left with only the task of user verification at the time of event; making

the project economically very viable for them.

Individuals can use this web based system, to keep themselves informed about diseases,

new inventions in area of medical science etc. with the help of article section on this

system.

All in all, with the help of this project, awareness for health related services &

encouragement among the common people for the same can be propagated, proving

beneficial for all of us.

4

2.2 Boundary Conditions

There are some conditions which should be fulfilled for implementing this project. They

are as follows:

Admin must have some offline means to verify integrity of hospital &

organizations registered on this system.

To verify the integrity of hospitals & organizations through online means, the

project should be provided data from the respective medical councils, in form of

web service.

Interaction among the users of this system has not been fully designed; yet to be

completed.

Number of total users participating or following an event cannot be known by

another user.

After a user has been registered for the event, the hosting organization is required

to verify the identity of the person on the day of event, through his personal

identification documents viz. driving license, voter id card etc.

Some sections solely accessible to registered users; no access to guest or visitor.

General design for this project allows this project mostly to be usable for a single

country (i.e. India), not suitable for international users to an extent.

Presently, those following/registered in events are not notified of change in event

details.

5

CHAPTER - 3

PROJECT MODULES

In this chapter, we discuss the design of all the modules into which the project was

divided. This Section Contains the detailed design description of all the modules.

The development of the project was divided into 7 major modules.

1. Authentication

2. Account management

3. Events

4. Article section

5. Notification/alerts

6. Directory services

7. Reporting

Description of each of these modules is as follows:

3.1 Authentication: This module deals with registration of various types of users on the

system & managing their logging in & out of the system, once registered.

Registration:

Three forms of registration are open to all users- register as organization

representative, register as hospital representative & user registration. Apart from

these health experts on the site can be registered by the admin only.

After registration their data is submitted to the database.

Log in:

All the registered members of the site can gain access to the site using the email id

& password used at their time of registration. A login panel is available to all

guest pages in the upper section of the page. Session plays key role after login.

Some resources of the system only available to registered members.

Log out:

A registered member is free to log out of the system anytime he/she wants, after

his/ her login on the system. Upon logging out his/her session is cleared by calling

appropriate methods & they are also redirected to the home page.

6

3.2 Account management: Accounts are managed by the system admin.

After an organization or a hospital has registered on the system, the admin has the

duty of verifying their integrity. Only after admin staff has verified their details,

they are approved to be the part of the system. For this admin has a separate

section where all the organizations & hospital are listed, along with their

verification status. Admin has the power to approve any of them after they

register on the system or the admin may simple remove the organization/hospital

from the system.

After removal from the system their data is also deleted from the database.

Admin can also unlock locked accounts; locked due to security reasons.

3.3 Events: Events are created by the organizations registered on the system. Users, apart

from admin, hospital representatives, and organization representatives can take part in

these events.

Create event:

Only an organization registered on the system can create an event. To create an

event an organization must provide the basic details for the event such as- event

name, date/time, venue & contact details etc.

Following event:

Following an event means, the user or the guest submits his email id/ mob number

to the organization so that he/she may receive updates about the events through

these methods.

It is possible that a user may only follow an event, without submitting his data to

take part in the event.

Available to guests & registered individuals

Event participation:

An event which allows users to register for an event online has its own

registration page. A register user can register himself or he can register another

user also. A guest can also register himself for the event. An image of the

registering user is required to complete the registration form.

After the registration process is completed, the user is provided with a unique

participation ID, which he/she is required to produce at the event venue to verify

his details along with some personal id.

7

View participants:

An organization can view all the events hosted by it & also the information of the

users participating in those events.

3.4 Article section: In this module health related article can be post by registered user,

and any user can view article.

Post article:

Any registered user can post or upload new article. For each new article all detail

related to the article like author name, date of publish, disease name, related photo

should require. And then article content can be posted or uploaded.

View /delete /approve post: In this part admin can view posted, delete, approve

article which is posted by a registered user.

Search article:

Any registered and non-registered user can search article. Article can be search by

author name or disease name. Both author name and disease name will be shown

in drop down .Searched result will be show will be clickable.

Show article:

After click on searched result it will redirect us on new page where related article

will be shown.

3.5 Notification/alerts: Various forms of alerts on this system are:

Event alerts:

When a new event is added to the system, it is displayed on the home page to all

the users, creating an event alert system. Apart from home page, a separate

section shows all the events created on the system, where, also many searching

criteria can also be applied.

Event notifications:

A user following an event can receive notifications regarding event updates on his

email id. A user registering for an event submits his mob number as well to

receive notifications on his mobile.

8

Successful registration notification:

Notifications are also sent to the user’s mail account after completing the

registration process & getting successfully registered on the system.

3.6 Directory services: These services display directory static directory data to the user

of a particular city. It includes contact nos. & other communication details

3.7 Reporting: Reporting module has been accomplished by using crystal reports, where

admin can view the details of all the organizations registered on the system with their

details in form of report.

9

CHAPTER - 4

TEST CASES

S.No

Test

Case

No.

Test Case

Name

Test Case

Description

Test

Steps Result

Status

(PASS/FA

IL)

1 TC-

01

validation on

registration-1

Registration

on website

fill the

entries

An error

message

“please fill all

the entries"

will be

displayed if

any entry left

unfilled

Pass

2

TC-

02

validation on

registration-2

Password

and

confirm

password

should be

same

An error

message

“confirm

password is

not same"

when both

passwords do

not match

Pass

3 TC-

03

validation on

registration-3

Checking

for email

id already

registered

An error

message

“This email id

has already

been

registered”

when email id

already

registered

Pass

4 TC-

04

validation on

registration-4

Checking

for

correct

pattern of

date

entered

An error

message

“Invalid

pattern” on

invalid pattern

Pass

5 TC-

05

validation on

registration-5

Checking

for

correct

pattern of

entered

mobile

An error

message

“Mobile no

must contain

10 digits

only” on non-

Pass

10

no numeric input.

6 TC-

06

validation on

registration-6

Checking

for

correct

pattern

on

entered

email-id

An error

message

“Invalid email

id” on invalid

email id

pattern

Pass

7 TC-

07

validation on

log in-1

Logging as

user

Fill the

entries

An error

message

“please fill all

the entries"

will be

displayed if

any entry left

unfilled

Pass

8 TC-

08

validation on

log in-2

Invalid

details

an error

message

"login/passwo

rd incorrect"

Pass

9 TC-

09

validation on

log in-1

Logging as

health expert

Fill the

entries

An error

message

“please fill all

the entries"

will be

displayed if

any entry left

unfilled

Pass

10 TC-

10

validation on

log in-2

Invalid

details

an error

message

"login/passwo

rd incorrect"

Pass

11 TC-

11

validation on

log in-1

Logging as

organization

representative

Fill the

entries

An error

message

“please fill all

the entries"

will be

displayed if

any entry left

unfilled

Pass

11

12 TC-

12

validation on

log in-2

Invalid

details

an error

message

"login/passwo

rd incorrect"

Pass

13 TC-

13

validation on

log in-1 Logging as

hospital

representative

Fill the

entries

An error

message

“please fill all

the entries"

will be

displayed if

any entry left

unfilled

Pass

14 TC-

14

validation on

log in-2

Invalid

details

an error

message

"login/passwo

rd incorrect"

Pass

15

16

TC-

15

TC-

16

validation on

log in-1

validation on

log in-2

Logging as

admin

fill the

entries

Invalid

details

An error

message

“please fill all

the entries"

will be

displayed if

any entry left

unfilled

an error

message

“login/passwo

rd incorrect

”

Pass

Pass

17 TC-

17

Validation on

adding health

expert-1

Admin

adding health

expert

Fill the

entries

An error

message

“please fill all

the entries"

will be

displayed if

any entry left

unfilled

Pass

12

18 TC-

18

Validation on

adding health

expert-2

Password

and

confirm

password

should be

same

An error

message

“confirm

password is

not same"

when both

passwords do

not match

Pass

19 TC-

19

Validation on

adding health

expert-3

Checking

for email

id already

registered

An error

message

“This email id

has already

been

registered”

when email id

already

registered

Pass

20 TC-

20

Validation on

adding health

expert -4

Checking

for

correct

pattern of

date

entered

An error

message

“Invalid

pattern” on

invalid pattern

Pass

21 TC-

21

Validation on

adding health

expert -5

Checking

for

correct

pattern of

entered

mobile

no

An error

message

“Mobile no

must contain

10 digits

only” on non-

numeric input.

Pass

22 TC-

22

Validation on

adding health

expert -6

Checking

for

correct

pattern

on

entered

email-id

An error

message

“Invalid email

id” on invalid

email id

pattern

Pass

23 TC-

23

Validation

when creating

an event-1

Organization

creating an

event

Fill the

entries

An error

message

“please fill all

the entries"

will be

displayed if

any entry left

unfilled

Pass

13

24 TC-

24

Validation

when creating

an event-2

Checking

for

correct

pattern of

entered

contact

no

An error

message

“Only

numeric are

allowed” on

non-numeric

input

Pass

25 TC-

01

validation on

event

registration-1

Registering in

an event

fill the

entries

An error

message

“please fill all

the entries"

will be

displayed if

any entry left

unfilled

Pass

26

TC-

26

validation on

event

registration-2

Password

and

confirm

password

should be

same

An error

message

“confirm

password is

not same"

when both

passwords do

not match

Pass

27 TC-

27

validation on

event

registration-3

Checking

for

correct

pattern of

date

entered

An error

message

“Invalid

pattern” on

invalid pattern

Pass

28 TC-

28

validation on

event

registration-4

Checking

for

correct

pattern of

entered

mobile

no

An error

message

“Mobile no

must contain

10 digits

only” on non-

numeric input.

Pass

29 TC-

29

validation on

event

registration-5

Checking

for

correct

pattern

on

entered

email-id

An error

message

“Invalid email

id” on invalid

email id

pattern

Pass

Table 4.1: Test cases of relative modules

14

CHAPTER - 5

DATABASE SCHEMA

Tables description:

5.1 User registration table :

Table 5.1: User registration table

5.2 Organization registration table:-1

Table 5.2: Organization registration table

15

5.3 Hospital registration table:-

Table 5.3: Hospital registration table

5.4 Login table:

Table 5.4: Login Table

16

5.5.a) Health Expert Registration table

Table 5.5.a: Health Expert Registration table

5.5.b) Health expert professional details table

Table : 5.5.b) Health expert professional details table

17

5.5.c) Health expert qualification details table

Table : 5.5.c) Health expert qualification details table

5.6.a) Event types table

Table :5.6.a) Event types table

5.6.b) Event details table

Table : 5.6.b) Event details table

18

5.6.c) Event contact details table

Table :5.6.c) Event contact details table

5.6.d) Event participants table

Table :5.6.d) Event participants table

19

5.7.a) Article author record table

Table :5.7.a) Article author record table

5.7.b) Article details table

Table :5.7.b) Article details table

5.7.c) Disease list table

Table : 5.7.c) Disease list table

20

5.8.a) Notification types table

Table 5.8.a) Notification types table

5.8.b) Notifications table

Table 5.8.b) Notifications table

21

CHAPTER - 6

USER INTERFACES

6.1 Home Page

Fig.: 6.1 Home Page

22

6.2. User registration

Fig.: 6.2 User registration

6.3 Organization registration

Fig.:6.3 Organization registration

23

6.4. Hospital registration

Fig.: 6.4. Hospital registration

6.5. Article search

Fig.: 6.5. Article search

24

6.6 Article show

Fig.:6.6 Article show

6.7. Admin home page

Fig.:6.7. Admin home page

25

6.8. Admin add health expert

Fig.:6.8. Admin add health expert

6.9. Admin organization management page

Fig.:6.9. Admin organization management page

26

6.10. Organization Create event

Fig.:6.10. Organization Create event

6.11. Event registration form

Fig.:6.11. Event registration form

27

CHAPTER - 7

DEBUGGING SCREEN SHOTS

7.1 This Shows index out of bound exception

Fig.: 7.1 Index out of bound exception

7.2 Null reference exception error in find control method

Fig.:7.2 Null reference exception error in Find Control method

28

7.3 Null reference exception error in session usage

Fig.7.3: Null reference exception error in session usage

7.4 Column does not exist

Fig.7.4: Column does not exist

29

7.5 Argument missing error

Fig.: 7.5 Argument missing error

30

CHAPTER - 8

FUTURE SCOPE OF PROJECT

The project “Health services & medical events tracking system” is a generous attempt

to contribute something worthy to the society.

The features designed in this project are provided to increase health awareness in the

society and attempts to increase people’s participation in health related activities.

Currently this project is only designed keeping in mind needs of the citizens of India,

but, in future this project could encompass its support globally.

Some features such as detailed reporting of users, medical consultancy & question

answer forum are yet to be fully implemented & when the same is done, the project

usability will increase manifold.

This project has many advantages over conventional system of events and health

organization. This system will simplify the way of health care, reduce the paper work

and come with several improvements in near future.

31

CHAPTER - 9

REPORT FROM GUIDE AND RECOMMENDATION

32

CHAPTER - 10

FAQS ABOUT PROJECT

1. For whom this project is designed?

Ans. This project is designed for the each person of the society, wishing to take part

in health services, medical camps, locating health services in that area & become

aware of new inventions in field of medical.

2. Which type of users does this system attract?

Ans. Individuals of our society, organizations working for health awareness,

hospitals and health specialists (recruited by admin only).

3. Where user verification is mandatory?

Ans. User verification is essential when approving organizations, hospitals & health

experts to the system, as all of them will be responsible for directly providing health

services to the people so it is mandatory & site owner’s responsibility to verify the

authenticity of these members through proper scrutiny of documents.

4. Which sections of the site are accessible to the guest users?

Ans. A normal visitor can take participate in the online registration of events, read

articles posted on the website & view other similar static content without registering

on the website.

5. Are there any services which require fee or cost?

Ans. No.

6. Would there be redundancy in the data at the back end?

Ans. No, redundancy has been almost completely removed by means of

normalization & duplicate data is only allowed when it can’t be avoided. For eg: in

event registration

33

7. Why you chose asp.net for project development?

Ans. Visual Studio 2012 supports development in asp.net & it is an excellent IDE

with all the debugging features & designing could be done easily. And also asp.net

with C# is very powerful & easy to use for dynamic web page generation.

34

REFERENCES

[1] www.wikipedia.org

[2] www.stackoverflow.com

[3] www.codeproject.com

[4] “Mastering Visual C#.Net” By Jason Price, Mike Gunderloy

[5] “ASP .NET Programming with C# & SQL Server” By Don Gosselin

[6] “Microsoft Visual Studio 2012 Unleashed” By Mike Snell, Lars Powers