Health Care System

UNDERGRADUATE PROJECT
Submitted in partial fulfillment of the requirements of software

development project II for the degree of

[Link]. Eng. in CSE

UNDER SUPPERVISION OF:

Dipu Akter Shila

Teaching Assistant, Dept. of CSE

Bangladesh University of Business & Technology

Bangladesh University of Business

&

Technology

Dhaka-1216, March 2021

 Health Care System

Group Members List

Nusrat Jahan Shammey-18192103198

Sayefa Arafah -18192103189
Sadiya Akter Mim-18192103184

Bangladesh University of Business

&

Technology

Department of Computer Science & Engineering

 Declaration of Authorship

We, Nusrat Shammey, Sayefa Arafah Arpona and Sadiya Akter Mim are
declaring that this project called “Online Health Care” and the work
presented in it are our own. We are confirming that:

• We have done this whole work mainly while in student for a [Link].
Engineering in CSE at this university.
• This has been clearly stated that any part of this software
development project has previously been submitted for a degree or
any other qualification at this university or any other institution.
• This is always clearly assigned that we have discussed the published
work of others.
• We always stated that we have quoted from the works of others this.
Without this quotation this thesis is entirely our own work.
• All main sources of help have been acknowledged by us.
• Where the thesis based on work done by ourselves jointly with
others. Exactly what was done by others and what we have
contributed by us, we have made that clear.

i
 Certificate

This is to certify that the project called,” Health Care System” and
submitted by Nusrat Jahan Shammey Id No:18192103198, Sayefa Arafah
Id No:18192103189 and Sadiya Akter Mim Id No: 18192103184 in
partial fulfillment of the requirement of form the work done by them under
my supervision.

Dipu Akter Shila,

Teaching Assistant,
Department of CSE.
Bangladesh University of Business and Technology (BUBT)

ii
 Dedication
Dedicated to our parents for all their love and inspiration.

iii
 Abstract
The most common phenomenon now-a-days is COVID-19. This
pandemic situation has brought the whole world down to its knees.
Healthcare sector took the major blow from the situation. Healthcare
System deals with the problem that basic healthcare services are mostly
out of the reach for majority of population. It can save time and ensure
healthcare for a wider range of people. It deals with doctor details and
patient details. Gives chance to communicate instantly with required
doctor. Patient can text their health problem and get the primary solution.
Patients can also pass their comments about ‘ Healthcare System’.

iv
 ACKNOWLEDGEMENT
In the name of Allah, most Beneficent and most Merciful. Praise be to
Allah who gave us strength, determination, staying power and ability to
complete this work. We are thankful to Almighty Allah for helping us in
each and every step. This project required lot of work, patience and
dedication. Still, implementation would not have been possible if we
didn’t have a support of many individuals and team members. Therefore,
we would like to extend our sincere gratitude to all of them.
First of all, we are thankful to our supervisor, Dipu Akter Shila, Teaching
assistant, Department of Computer Science and Technology, for
providing necessary guidance, continuous support and motivation
pertaining to the supervision and completion of this project. Without her
superior knowledge and experience, the project would lack in quality of
outcomes, and thus her support has been essential. We would like to
express our sincere thanks towards all our team members who devoted
their time and knowledge and put all their efforts in the implementation
of this project. Nevertheless, we express our gratitude towards our
families especially to our parents for their kind co-operation and
encouragement which help us in completion of this project. May Allah
reward all of them for their continuous support, for helping us sincerely
and putting all their efforts in this whole time period of our project.
v
 Approval
This project “Healthcare System” Submitted by Nusrat Jahan Shammey,
Sayefa Arafah, Sadiya Akter Mim. ID:18192103198, 18192103189 and
18192103184 Department of Computer Science and Engineering (CSE),
Bangladesh University of Business and Technology (BUBT) under the
supervision of Dipu Akter Shila, Teaching Assistant, Department of
Computer Science and Engineering has been accepted as satisfactory for
the partial fulfillment of the requirement for the degree of Bachelor of
Science ([Link]. Eng.) in Computer Science and Engineering and approved
as to its style and contents.

Supervisor:
Dipu Akter Shila,
Teaching Assistant,
Department of CSE.
Bangladesh University of Business and Technology (BUBT)

Chairman:
Dr. Muhammad Firoz Mridha
Associate Professor and Chairman
Department of CSE
Bangladesh University of Business and Technology (BUBT)
vi
Contents
Declaration of Authorship……………………………………………………….. i

Certificate………………………………………………………………………...ii

Dedication……………………………………………………………………….iii

Abstract………………………………………………………………………….iv

Acknowledgement……………………………………………………………….v

Approval…………………………………………………………………………vi

Chapter 1

Introduction

1.1 Introduction………………………………………………………………...1

Chapter 2

Project Review

2.1 Project Database……………………………………………………………2

2.2 Health Care System……………………………………………….……..3-4

2.3 Health Care & Database Management System………………………….4-5

2.4 Data Management…………………………………………………………5

Chapter 3

Technology

3.1 Software………………………………………………………………….6-7

3.1.1 Microsoft Visual Studio……………………………………..................6-7

3.2 Programming Language………………………………………………...8-10

3.3 Database………………………………………….……………….……10-11

3.3.1 MySQL……………………………………………………….............10-11
Chapter 4

System Analysis &Architecture Design

4.1 System User Analysis…………………………………………….………….11

4.1.1 Admin…………………………………………………..……….................12

4.1.2 Doctor……………………………………………………………………...12

4.1.3 Patient……………………………………………………………………...12

4.2 Architecture Design……………………………………………………....12-14

Chapter 5

Access System

5.1 Description ……………………………………………………….,,,,,…….14

5.2 Manual …………………………………………………………………14-25

5.3 E-R Diagram ………………………………………………………………26

Chapter 6

Code Analysis

6.1 Code……………………………………………………………………27-64

Chapter 7

7.1 Future Work………………………………………………………………64

7.2 Conclusion………………………………………………………………...64
Chapter 1

Introduction
1.1: Introduction
Health Care System deals with online based medication. Through this
people can get medical advice for any kind of diseases. In this there will
be qualified doctors from different department of medical science who
will give the treatment to the patient as their diseases. Here will be a
conversation part for doctor and patient to communicate with each other.
Our design can help us to know what is happening in the software, the
current status of doctor and patient. The Health Care System is an online
medication for people. It can prevent the time waste of travelling. People
will get the treatment at their home through online.
We know that the travelling to a hospital takes too much time. When
someone go to a hospital for any treatment, he/she needs to get an
appointment for particular doctor, and also needs to wait till the call. It is
also time consuming to find the desired doctor in a very big hospital.
Sometimes some people become so much week to go to hospital, so for
them it will be easier to get the treatment. In this software there are some
steps to get treatments, they are very impotent. The admin of the software
will monitor the updates and manage the software. Admin needs to login
first to do that. In the doctors’ part doctors will get mail from patient and
then the treatment will start. Patient needs to register first to get into the
software then needs to login. Then he/she can choose the doctor he/she
wants to talk.
1
Chapter 2
Project Review
2.1 Project Database

Project management skills are put to good use for this project. Having
gone through project management modules in Time Series Analysis,
Optimization and with two interns Project Management for Business and
IT respectively, they enhanced my knowledge on managing a project.
Project management focuses on achieving the objectives by applying
five processes presented in Figure below.

2.2 Health Care System

It is helpful for everyone. It saves our time. They record all patient and
doctors’ details.
2
2.3 HealthCare and Database management system
A database is an integrated collection of data, usually so large that it has
to be stored on secondary storage devices such as disks or tapes. This data
can be maintained as a collection of operating system files, or stored in a
DBMS (database management system). A Database Management System
(DBMS) is computer software designed for the purpose of managing
databases based on a variety of data models. A DBMS is a complex set of
software programs that controls the organization, storage, management,
and retrieval of data in a database. DBMS are categorized according to
their data structures or types; sometime DBMS is also known as Database
Manager. It is a set of pre written programs that are used to store, update
and retrieve a Database. When a DBMS is used, information systems can
be changed much more easily as the organization’s information
requirements change. New categories of data can be added to the database
without disruption to the existing system. Organizations may use one kind
of DBMS for daily transaction processing and then move the detail onto
another computer that uses another DBMS better suited for random
inquiries and analysis.

Advantages of DBMS
• Improved strategic use of corporate data

• Reduced complexity of the organization’s

information systems environment

3
• Reduced data redundancy and inconsistency

• Enhanced data integrity

• Application-data independence

• Improved security

• Reduced application development and maintenance costs

• Improved flexibility of information system

• Increased access and availability of data and information

• Logical Physical data independence

• Concurrent access anomalies.

• Facilitate atomized problem.

• Provides central control on the system through DBA

4
2.4 Data management

According to patient records manual prepared by admin the creation

and maintenance of records relating to the doctor of this are essential
to:

• managing the relationship between the doctor and the patient;

• providing support and other services and facilities to the patient;
• controlling the massaging and feedback with patient and
doctor both are maintain admin;

A patient is an individual who is registered for a doctor.

A patient record/data contains information directly related to a

patient, which means that the record is personally identifiable.
Personal identifiers that relate a record to a patient include
patient name, patient email, patient phone number.
Patient and doctor records/data presented by the admin.
Admin can manage everything such as message, feedback and
also can change all information.

5
Chapter 3
Technology
3.1 Software
3.1.1 Microsoft Visual Studio
Microsoft Visual Studio is an integrated development environment (IDE)
from Microsoft. It is used to develop computer programs, as well
as websites, web apps, web services and mobile apps. Visual Studio uses
Microsoft software development platforms such as Windows
API, Windows Forms, Windows Presentation Foundation, Windows
Store and Microsoft Silverlight. It can produce both native
code and managed code.
Visual Studio includes a code editor supporting IntelliSense (the code
completion component) as well as code refactoring. The integrated
debugger works both as a source-level debugger and a machine-level
debugger. Other built-in tools include a code profiler, designer for
building GUI applications, web designer, class designer, and database
schema designer. It accepts plug-ins that expand the functionality at
almost every level—including adding support for source control systems
(like Subversion and Git) and adding new toolsets like editors and

visual designers for domain-specific languages or toolsets for other

aspects of the software development lifecycle (like the Azure
DevOps client: Team Explorer).
6
Visual Studio supports 36 different programming languages and allows
the code editor and debugger to support (to varying degrees) nearly any
programming language, provided a language-specific service exists.
Built-in languages include C, C++,Visual Basic .Net,
C#,F#, JavaScript, TypeScript, XML, XSLT, HTML, and CSS. Support
for other languages such as Python,[9] Ruby, [Link], and M among
others is available via plug-ins. Java (and J#) were supported in the past.
The most basic edition of Visual Studio, the Community edition, is
available free of charge. The slogan for Visual Studio Community edition
is "Free, fully-featured IDE for students, open-source and individual
developers".
The latest production-ready Visual Studio version is 2019, with older
versions such as 2012 and 2013 on Extended Support, and 2015 and 2017
on Mainstream Support. [Wikipedia]

7
3.2 Programming Language
3.2.1 C# Language
During the development of the .NET Framework, the class libraries were
originally written using a managed code compiler system called "Simple
Managed C" (SMC). In January 1999, Anders Hejlsberg formed a team
to build a new language at the time called Cool, which stood for "C-
like Object Oriented Language". Microsoft had considered keeping the
name "Cool" as the final name of the language, but chose not to do so for
trademark reasons. By the time the .NET project was publicly announced
at the July 2000 Professional Developers Conference, the language had
been renamed C#, and the class libraries and [Link] runtime had been
ported to C#.
Hejlsberg is C#'s principal designer and lead architect at Microsoft, and
was previously involved with the design of Turbo Pascal, Embarcadero
Delphi (formerly CodeGear Delphi, Inprise Delphi and Borland Delphi),
and Visual J++. In interviews and technical papers he has stated that
flaws in most major programming languages (e.g. C++, Java, Delphi,
and Smalltalk) drove the fundamentals of the Common Language
Runtime (CLR), which, in turn, drove the design of the C# language itself.
James Gosling, who created the Java programming language in 1994,
and Bill Joy, a co-founder of Sun Microsystems, the originator of Java,
called C# an "imitation" of Java; Gosling further said that "[C# is] sort of
Java with reliability, productivity and security deleted." Klaus Kreft and
Angelika Langer (authors of a C++ streams book) stated in a blog post
that "Java and C# are almost identical programming languages. Boring
repetition that lacks innovation,” "Hardly anybody will claim that Java or
C# are revolutionary programming languages that changed the way we
write programs," and "C# borrowed a lot from Java - and vice versa. Now
that C# supports boxing and unboxing, we'll have a very similar feature
in Java." In July 2000, Hejlsberg said that C# is "not a Java clone" and is
"much closer to C++" in its design.
8
Since the release of C# 2.0 in November 2005, the C# and Java languages
have evolved on increasingly divergent trajectories, becoming two quite
different languages. One of the first major departures came with the
addition of generics to both languages, with vastly different
implementations. C# makes use of reification to provide "first-class"
generic objects that can be used like any other class, with code
generation performed at class-load time.[28] Furthermore, C# has
added several major features to accommodate functional-style
programming, culminating in the LINQ extensions released with C# 3.0
and its supporting framework of lambda expressions, extension methods,
and anonymous types. These features enable C# programmers to use
functional programming techniques, such as closures, when it is
advantageous to their application. The LINQ extensions and the
functional imports help developers reduce the amount of boilerplate
code that is included in common tasks like querying a database, parsing
an xml file, or searching through a data structure, shifting the emphasis
onto the actual program logic to help improve readability and
maintainability.
9
C# used to have a mascot called Andy (named after Anders Hejlsberg). It
was retired on January 29, 2004.
C# was originally submitted to the ISO subcommittee JTC 1/SC 22 for
review, under ISO/IEC 23270:2003, was withdrawn and was then
approved under ISO/IEC 23270:2006. The 23270:2006 is with drawned
under 23270:2018 and approved with this version. [Wikipedia]

3.3 Database
3.3.1 MySQL
MySQL is written in C and C++. Its SQL parser is written in yacc, but it
uses a home-brewed lexical analyzer. MySQL works on many system
platforms, including AIX, BSDi, FreeBSD, HP-UX, ArcaOS,
eComStation, i5/OS, IRIX, Linux, macOS, Microsoft
Windows, NetBSD, Novell
NetWare, OpenBSD, OpenSolaris, OS/2 Warp, QNX, Oracle
Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos
and Tru64. A port of MySQL to OpenVMS also exists.
The MySQL server software itself and the client libraries use dual-
licensing distribution. They are offered under GPL version 2, or a
proprietary license.
Support can be obtained from the official manual. Free support
additionally is available in different IRC channels and forums. Oracle
offers paid support via its MySQL Enterprise products. They differ in the
scope of services and in price. Additionally, a number of third-party
organizations exist to provide support and services.
MySQL has received positive reviews, and reviewers noticed it "performs
extremely well in the average case" and that the "developer interfaces are
there, and the documentation (not to mention feedback in the real world
via Web sites and the like) is very, very good". It has also been tested to
10
be a "fast, stable and true multi-user, multi-threaded SQL database
server".

Chapter 4
System Analysis & Architectural Design:
4.1 System User Analysis
The “Health Care System” has three type of user and they can access the
system.
User:

• Admin
• Doctor
• Patient

4.1.1 Admin:
Like another system in this system admin also can access all the modules.
They can create record, search record, view all record of patient and also
can update or modify of Doctor. But create, update and delete options
11
access is only under them. Any second party couldn’t access these
options.

4.1.2 Doctor:
Doctor can access some modules. They can view patient list, search any
patient information, check request and reply patient massage.

4.1.3 Patient:
Patient can access only two options. They can search doctor information
and show their own record, by using email address. But there exists one
condition. There must have to be stored record for the email that they
search.

4.2 Architectural Design:

Healthcare is a system which has major components such as create record,

update record, delete record, search record, show record for doctor,
patient, messages, feedback. It performs specific statement for specific
user,
Admin can add new doctor information, update their information, delete
any doctor from the system, show all data records. Patient can view
doctors list. Doctors can also find the information of their patients.
12
Patients can add their information themselves by providing in the forms.
Their sensitive information like password can’t be viewed by the doctors
or any other user. So, their information is safely stored.

After running the system, it will display the page like this and it’s
not the home page.

After clicking start the user gets option whether he/she is an

admin or doctor or patient.

13
The complete design of this system is in chapter 6(Access System).

Chapter 5
Access System
5.1 Description
By reading this chapter user can know about every options of this system
as like, how to operate this system, who can operate this system and all
restrictions.

5.2 Manual
At the first execution the system you can see this page.

14
Then press the start button and see the home page
And the home page look like this, where you can see the options
serially like

• Admin
• Doctor
• Patient

15
Press Admin button and see the admin login page:

After proving proper username and password admin gets the option list:

If Admin clicks the DoctorInfo button he/she get option to add,

update or delete doctor’s information

16
If Admin clicks the ViewDoctorList button he/she gets the data
records of every existing doctors

17
He/she can also search information for any particular doctor by
providing the doctor id.

If Admin clicks the ViewPatientList button he/she gets the data

records of every patients

18
If Admin clicks the ViewMessageBox button he/she gets to see if
any message is pending or completed because admin can view
current messages going on between doctors and patients

If Admin clicks the ViewMessageBox button he/she gets to see

the feedback from the users about the system

19
If the user press Doctor button, gets the doctor login form

After logging in,doctor gets some options

20
After Clicking View_Patients doctor gets the list of existing patients

Doctor can also search any particuler patient’s details

21
After Clicking Check_Request button doctor can check if patients have asked for
treatment or not

After receiving request, doctors can start conversation

22
If users click the Patient button and see the patient Registration page.
After registering he/she can log in the system

23
Here is the log in form,

After entering the system, patients can choose what type of doctor they
need. Even choose the desired doctor prom the list

24
After getting the doctor id,patients can ask for treatment by messaging the
choosen doctor

After completing the conversation the patients get option to share their
opinion about the doctor or the system before leaving the system

25
5.3 E-R Diagram:

26
Chapter 6
Code Analysis:
Form1:
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Start_Click(object sender, EventArgs e)

{
[Link]();
Menu ss = new Menu();
[Link]();
}
}
}

27
Menu:
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class Menu : Form
{
public Menu()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)

{

[Link]();
AdminLogIn1 ss = new AdminLogIn1();
[Link]();
}

private void button3_Click(object sender, EventArgs e)

{
[Link]();
PatientLogIn ss = new PatientLogIn();
[Link]();
}
28
 private void Doctorlogin_Click(object sender, EventArgs e)
{
[Link]();
DoctorLogIn ss = new DoctorLogIn();
[Link]();
}
}
}

AdminLogIn:
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class AdminLogIn1 : Form
{
public AdminLogIn1()
{
InitializeComponent();
}

private void button2_Click(object sender, EventArgs e)

{
[Link]();
29
}
 private void button1_Click(object sender, EventArgs e)
{
SqlConnection sqlcon = new SqlConnection(@"Data Source =
(LocalDB)\MSSQLLocalDB; AttachDbFilename =
C:\Users\User\Documents\[Link]; Integrated Security = True;
Connect Timeout = 30");
string query = "Select * From LogIn Where Username='" +
[Link]() + "' and Password ='" +
[Link]() + "'";
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
DataTable dt = new DataTable();
[Link](dt);
if ([Link] == 1)
{

AdminOptions ob1 = new AdminOptions();

[Link]();
[Link]();
}
else
{
[Link]("Please double check your Username and
password");
}
}
}
}

AdminOptions:
using System;

30
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class AdminOptions : Form
{
public AdminOptions()
{
InitializeComponent();
}

private void button2_Click(object sender, EventArgs e)

{
[Link]();
ViewDoctors ss = new ViewDoctors();
[Link]();
}
private void button1_Click(object sender, EventArgs e)
{
[Link]();
AddDoctor ss = new AddDoctor();
[Link]();
}

private void button3_Click(object sender, EventArgs e)

{
31
 [Link]();
ViewPatient ss = new ViewPatient();
[Link]();
}

private void button4_Click(object sender, EventArgs e)

{
[Link]();
AdminLogIn1 ss = new AdminLogIn1();
[Link]();
}

private void button5_Click(object sender, EventArgs e)

{

}
private void button5_Click_1(object sender, EventArgs e)
{

[Link]();
ViewMsgBox ss = new ViewMsgBox();
[Link]();
}

private void button6_Click(object sender, EventArgs e)

{
[Link]();
CheckFeedback ss = new CheckFeedback();
[Link]();
}
}
}

32
AddDoctor:
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class AddDoctor : Form
{
public AddDoctor()
{
InitializeComponent();
}

private void AddDoctor_Load(object sender, EventArgs e)

{

private void back_Click(object sender, EventArgs e)

{
[Link]();
AdminOptions ss = new AdminOptions();
[Link]();
}

private void save_Click(object sender, EventArgs e)

33
 {
try
{
int id = Convert.ToInt32([Link]);
string name = [Link];
String type = [Link];
string quali = [Link];
string gender = [Link];
int age = Convert.ToInt32([Link]);
string mobile = [Link];
string email = [Link];

SqlConnection con = new SqlConnection();

[Link] = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User
\Documents\[Link];Integrated Security=True;Connect
Timeout=30";
SqlCommand cmd = new SqlCommand();
[Link] = con;
[Link] = "insert into Doctors values ('" + id + "','"
+ name + "','" + type + "','" + quali + "','" + gender + "','" + age + "','" +
mobile + "','" + email + "')";
SqlDataAdapter DA = new SqlDataAdapter(cmd);
DataSet d5 = new DataSet();
[Link](d5);
[Link]("Inserted successfully");
}
catch(Exception)
{
[Link]("Give proper information");
}
[Link]();
[Link]();
34
 [Link]();
[Link]();
[Link]();
[Link]();
[Link]();
[Link]();

private void label1_Click(object sender, EventArgs e)

{

private void button1_Click(object sender, EventArgs e)

{
try
{

SqlConnection con = new SqlConnection();

[Link] = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User
\Documents\[Link];Integrated Security=True;Connect
Timeout=30";
SqlCommand cmd = new SqlCommand();
[Link] = con;
[Link] = "Update Doctors set Name='" +
[Link] + "',Type='" + [Link] +
"',Qualification='" + [Link] + "',Gender='" +
[Link] + "',Age='" + [Link] + "',Mobile='" +
[Link] + "',Email='" + [Link] + "'where Id='"
+ [Link] + "'";
SqlDataAdapter DA = new SqlDataAdapter(cmd);
35
 DataSet d2 = new DataSet();
[Link](d2);
[Link]("Updated successfully");
}
catch (Exception)
{
[Link]("Give proper information");
}
[Link]();
[Link]();
[Link]();
[Link]();
[Link]();
[Link]();
[Link]();
[Link]();

private void button2_Click(object sender, EventArgs e)

{

try {

int id = Convert.ToInt32([Link]);
SqlConnection con = new SqlConnection();
[Link] = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User
\Documents\[Link];Integrated Security=True;Connect
Timeout=30";
SqlCommand cmd = new SqlCommand();
[Link] = con;
[Link] = "Delete from Doctors where Id='" +
[Link] + "'";
36
 SqlDataAdapter DA = new SqlDataAdapter(cmd);
DataSet d5 = new DataSet();
[Link](d5);
[Link]("Deleted successfully");
}
catch (Exception)
{
[Link]("Give proper information");
}
[Link]();
[Link]();
[Link]();
[Link]();
[Link]();
[Link]();
[Link]();
[Link]();

}
}
}
CheckFeedback:
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace OnlineHealthCare
{
37
 public partial class CheckFeedback : Form
{
string connectionstring = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User
\Documents\[Link];Integrated Security=True;Connect
Timeout=30";
public CheckFeedback()
{
InitializeComponent();
}

private void button2_Click(object sender, EventArgs e)

{
[Link]();
AdminOptions ss = new AdminOptions();
[Link]();
}

private void button1_Click(object sender, EventArgs e)

{
using (SqlConnection sqlcon = new
SqlConnection(connectionstring))
{
[Link]();
SqlDataAdapter sqlDa = new SqlDataAdapter("Select * from
Feedback", sqlcon);
DataTable dtbl = new DataTable();
[Link](dtbl);
[Link] = dtbl;
}}
}
}
DoctorLogIn:
using System;
38
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class DoctorLogIn : Form
{
public DoctorLogIn()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)

{
SqlConnection sqlcon = new SqlConnection(@"Data Source =
(LocalDB)\MSSQLLocalDB; AttachDbFilename =
C:\Users\User\Documents\[Link]; Integrated Security = True;
Connect Timeout = 30");
string query = "Select * From Doctors Where ID='" +
[Link]() + "' and Name ='" + [Link]() +
"'";
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
DataTable dt = new DataTable();
[Link](dt);
if ([Link] == 1)
{
39
 DoctorWork ob1 = new DoctorWork();
[Link]();
[Link]();
}
else
{
[Link]("Please double check your Username and
password");
}
}

private void button2_Click(object sender, EventArgs e)

{
[Link]();
}
}
}

DoctorWork:
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class DoctorWork : Form
40
 {
public DoctorWork()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)

{
[Link]();
SearchPatient ss = new SearchPatient();
[Link]();
}
private void button3_Click(object sender, EventArgs e)
{
[Link]();
DoctorLogIn ss = new DoctorLogIn();
[Link]();
}

private void button2_Click(object sender, EventArgs e)

{
[Link]();
ViewRequest ss = new ViewRequest();
[Link]();
}
}
}

PatientLogIn:
using System;
using [Link];
using [Link];
41
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class PatientLogIn : Form
{
public PatientLogIn()
{
InitializeComponent();
}

private void label3_Click(object sender, EventArgs e)

{

private void button1_Click(object sender, EventArgs e)

{
try
{
string name = [Link];
int age = Convert.ToInt32([Link]);
string Gender = [Link];
string Mobile = [Link];
string Email = [Link];
string Pass = [Link];
SqlConnection con = new SqlConnection();

42
 [Link] = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User
\Documents\[Link];Integrated Security=True;Connect
Timeout=30";
SqlCommand cmd = new SqlCommand();
[Link] = con;
[Link] = "insert into Patient values('" + name + "','"
+ age + "','" + Gender + "','" + Mobile + "','" + Email + "','" + Pass + "')";
SqlDataAdapter DA = new SqlDataAdapter(cmd);
DataSet d4 = new DataSet();
[Link](d4);
[Link]("Now you need to log in");
}
catch (Exception)
{
[Link]("Give proper information");
}
[Link]();
[Link]();
[Link]();
[Link]();
[Link]();
[Link]();

private void button2_Click(object sender, EventArgs e)

{
[Link]();
PlogIn ss = new PlogIn();
[Link]();
}
}
}
43
PatientWork:
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class PatientWork : Form
{

public PatientWork()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)

{

SqlConnection sqlcon = new SqlConnection(@"Data Source =

(LocalDB)\MSSQLLocalDB; AttachDbFilename =
C:\Users\User\Documents\[Link]; Integrated Security = True;
Connect Timeout = 30");
string query = "Select * From Doctors Where Type='" +
[Link]() + "'";
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
DataTable dt = new DataTable();
44
 [Link](dt);
[Link] = dt;

private void next_Click(object sender, EventArgs e)

{
[Link]();
Pmsg ss = new Pmsg();
[Link]();
}

private void button2_Click(object sender, EventArgs e)

{
[Link]();
PlogIn ss = new PlogIn();
[Link]();
}
}
}

PLogIn:

using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
45
namespace OnlineHealthCare
{
public partial class PlogIn : Form
{
public PlogIn()
{
InitializeComponent();
}

private void login_Click(object sender, EventArgs e)

{
SqlConnection sqlcon = new SqlConnection(@"Data Source =
(LocalDB)\MSSQLLocalDB; AttachDbFilename =
C:\Users\User\Documents\[Link]; Integrated Security = True;
Connect Timeout = 30");
string query = "Select * From Patient Where Email='" +
[Link]() + "' and Password ='" +
[Link]() + "'";
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
DataTable dt = new DataTable();
[Link](dt);
if ([Link] == 1)
{

PatientWork ob1 = new PatientWork();

[Link]();
[Link]();
}
else
{
[Link]("Please double check your Email and
password");
46
 }
}
}
}

PMsg:
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class Pmsg : Form
{

public Pmsg()
{
InitializeComponent();
}

private void Pmsg_Load(object sender, EventArgs e)

{

}
47
 private void button2_Click(object sender, EventArgs e)
{
SqlConnection sqlcon = new SqlConnection(@"Data Source =
(LocalDB)\MSSQLLocalDB; AttachDbFilename =
C:\Users\User\Documents\[Link]; Integrated Security = True;
Connect Timeout = 30");
string query = "Update Msgg set Msg='" +
[Link]() + "' where Email='" +
[Link]() + "'";
SqlDataAdapter sdaa = new SqlDataAdapter(query, sqlcon);
DataTable dy = new DataTable();
[Link](dy);
[Link]();
}

private void button1_Click(object sender, EventArgs e)

{
try
{
string code = [Link];
string email = [Link];
int id = Convert.ToInt32([Link]);
string name = [Link];
SqlConnection con = new SqlConnection();
con. ConnectionString = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User
\Documents\[Link];Integrated Security=True;Connect
Timeout=30";
SqlCommand cmd = new SqlCommand();
[Link] = con;
[Link] = "insert into Msgg values('" + code + "','"
+ email + "','" + id + "','" + name + "')";
SqlDataAdapter DA = new SqlDataAdapter(cmd);
DataSet d4 = new DataSet();
48
 [Link](d4);
[Link]("Now write your message");
}
catch (Exception)
{
[Link]("Give proper information");
}
}

private void button3_Click(object sender, EventArgs e)

{
SqlConnection sqlcon = new SqlConnection(@"Data Source =
(LocalDB)\MSSQLLocalDB; AttachDbFilename =
C:\Users\User\Documents\[Link]; Integrated Security = True;
Connect Timeout = 30");
string query = "Select * From Msgg Where Email='" +
[Link]() + "'";
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
DataTable dt = new DataTable();
[Link](dt);
[Link] = dt;
}

private void button3_Click_1(object sender, EventArgs e)

{

[Link]();
Feedback ss = new Feedback();
[Link]();
}
}
}

ReplyMsg:
49
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class ReplyMsg : Form
{
public ReplyMsg()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)

{
SqlConnection sqlcon = new SqlConnection(@"Data Source =
(LocalDB)\MSSQLLocalDB; AttachDbFilename =
C:\Users\User\Documents\[Link]; Integrated Security = True;
Connect Timeout = 30");
string query = "Update Msgg set Msg='" +
[Link]() + "' where Email='" +
[Link]() + "'";
SqlDataAdapter sdaa = new SqlDataAdapter(query, sqlcon);
DataTable dy = new DataTable();
[Link](dy);
[Link]();
}
50
 private void button2_Click(object sender, EventArgs e)
{
SqlConnection sqlcon = new SqlConnection(@"Data Source =
(LocalDB)\MSSQLLocalDB; AttachDbFilename =
C:\Users\User\Documents\[Link]; Integrated Security = True;
Connect Timeout = 30");
string query = "Select * From Msgg Where Email='" +
[Link]() + "'";
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
DataTable dt = new DataTable();
[Link](dt);
[Link] = dt;
}

private void button3_Click(object sender, EventArgs e)

{
[Link]();
ViewRequest ss = new ViewRequest();
[Link]();
}
}
}

SearchDoctor:
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
51
namespace OnlineHealthCare
{
public partial class SearchDoctor : Form
{
public SearchDoctor()
{
InitializeComponent();
}

private void Search_Click(object sender, EventArgs e)

{
SqlConnection sqlcon = new SqlConnection(@"Data Source =
(LocalDB)\MSSQLLocalDB; AttachDbFilename =
C:\Users\User\Documents\[Link]; Integrated Security = True;
Connect Timeout = 30");
string query = "Select * From Doctors Where Id ='" +
[Link]() + "'";
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
DataTable dt = new DataTable();
[Link](dt);
[Link] = dt;
}

private void Back_Click(object sender, EventArgs e)

{
[Link]();
ViewDoctors ss = new ViewDoctors();
[Link]();
}
}
}

SearchPatient:
52
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class SearchPatient : Form
{
string connectionstring = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User
\Documents\[Link];Integrated Security=True;Connect
Timeout=30";
public SearchPatient()
{
InitializeComponent();
}

private void GetPatient_Click(object sender, EventArgs e)

{
using (SqlConnection sqlcon = new
SqlConnection(connectionstring))
{
[Link]();
SqlDataAdapter sqlDa = new SqlDataAdapter("Select
Name,Age,Gender,Email from Patient", sqlcon);
DataTable dtbl = new DataTable();
[Link](dtbl);
53
 [Link] = dtbl;
}
}

private void button1_Click(object sender, EventArgs e)

{

[Link]();
SearchPatient2 ss = new SearchPatient2();
[Link]();
}

private void button2_Click(object sender, EventArgs e)

{
[Link]();
DoctorWork ss = new DoctorWork();
[Link]();

}
}
}

SearchPatient2:
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
54
namespace OnlineHealthCare
{
public partial class SearchPatient2 : Form
{
public SearchPatient2()
{
InitializeComponent();
}

private void Search_Click(object sender, EventArgs e)

{
SqlConnection sqlcon = new SqlConnection(@"Data Source =
(LocalDB)\MSSQLLocalDB; AttachDbFilename =
C:\Users\User\Documents\[Link]; Integrated Security = True;
Connect Timeout = 30");
string query = "Select Name,Age,Gender,Email From Patient
Where Email ='" + [Link]() + "'";
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
DataTable dt = new DataTable();
[Link](dt);
[Link] = dt;
}
private void back_Click(object sender, EventArgs e)
{[Link]();
SearchPatient ss = new SearchPatient();
[Link]();}}}
ViewDoctor:

using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
55
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{

public partial class ViewDoctors : Form

{
string connectionstring = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User
\Documents\[Link];Integrated Security=True;Connect
Timeout=30";
public ViewDoctors()
{
InitializeComponent();
}

private void ViewDoctors_Load(object sender, EventArgs e)

{

private void View_Click(object sender, EventArgs e)

{
using(SqlConnection sqlcon = new
SqlConnection(connectionstring))
{
[Link]();
SqlDataAdapter sqlDa = new SqlDataAdapter("Select * from
Doctors", sqlcon);
56
 DataTable dtbl = new DataTable();
[Link](dtbl);
[Link] = dtbl;
}
}
private void button1_Click(object sender, EventArgs e)
{
[Link]();
AdminOptions ss = new AdminOptions();
[Link]();
}
private void button2_Click(object sender, EventArgs e)
{

[Link]();
SearchDoctor ss = new SearchDoctor();
[Link]();}}}
ViewMsgBox:

using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class ViewMsgBox : Form
{
57
string connectionstring = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User
\Documents\[Link];Integrated Security=True;Connect
Timeout=30";
public ViewMsgBox()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)

{
using (SqlConnection sqlcon = new
SqlConnection(connectionstring))
{
[Link]();
SqlDataAdapter sqlDa = new SqlDataAdapter("Select * from
Msgg", sqlcon);
DataTable dtbl = new DataTable();
[Link](dtbl);
[Link] = dtbl;
}
}

private void button2_Click(object sender, EventArgs e)

{
[Link]();
AdminOptions ss = new AdminOptions();
[Link]();
}
}
}

58
ViewPatient:

using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class ViewPatient : Form
{
string connectionstring = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User
\Documents\[Link];Integrated Security=True;Connect
Timeout=30";
public ViewPatient()
{
InitializeComponent();
}

private void back_Click(object sender, EventArgs e)

{
[Link]();
AdminOptions ss = new AdminOptions();
59
 [Link]();
}

private void view_Click(object sender, EventArgs e)

{
using (SqlConnection sqlcon = new
SqlConnection(connectionstring))
{
[Link]();
SqlDataAdapter sqlDa = new SqlDataAdapter("Select * from
Patient", sqlcon);
DataTable dtbl = new DataTable();
[Link](dtbl);
[Link] = dtbl;
}
}

private void dataG_CellContentClick(object sender,

DataGridViewCellEventArgs e)
{

}
}
}

ViewRequest:

using System;
using [Link];
using [Link];
using [Link];
using [Link];
60
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class ViewRequest : Form
{
public ViewRequest()
{
InitializeComponent();
}

private void Check_Click(object sender, EventArgs e)

{
SqlConnection sqlcon = new SqlConnection(@"Data Source =
(LocalDB)\MSSQLLocalDB; AttachDbFilename =
C:\Users\User\Documents\[Link]; Integrated Security = True;
Connect Timeout = 30");
string query = "Select * From Msgg Where DoctorId='" +
[Link]() + "'";
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
DataTable dt = new DataTable();
[Link](dt);
[Link] = dt;
}

private void button1_Click(object sender, EventArgs e)

{

[Link]();
ReplyMsg ss = new ReplyMsg();
61
 [Link]();
}

private void button2_Click(object sender, EventArgs e)

{
[Link]();
DoctorWork ss = new DoctorWork();
[Link]();
}
}
}

Feedback:
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace OnlineHealthCare
{
public partial class Feedback : Form
{
public Feedback()
{
62
 InitializeComponent();
}

private void Done_Click(object sender, EventArgs e)

{
try
{

string email = [Link];

int id = Convert.ToInt32([Link]);
string fb = [Link];
SqlConnection con = new SqlConnection();
[Link] = @"Data
Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User
\Documents\[Link];Integrated Security=True;Connect
Timeout=30";
SqlCommand cmd = new SqlCommand();
[Link] = con;
[Link] = "insert into Feedback values('" + email
+ "','" + id + "','" + fb + "')";
SqlDataAdapter DA = new SqlDataAdapter(cmd);
DataSet d4 = new DataSet();
[Link](d4);
[Link]("Thanks for sharing your opinion");
}
catch (Exception)
{
[Link]("Give proper information");
}
[Link]();
[Link]();
[Link]();
}

63
 private void button1_Click(object sender, EventArgs e)
{
[Link]();
}
}
}

Chapter 7
7.1 Future Work
Due to lack of knowledge and resource we couldn’t do the project
at hearts content. There is obviously room for improvement and we
intent to work on this project further in future. There are some
features that we would like to add in future like enable video
chatting option to add some elaborated features, like the option to
submit pathological test reports. We would like to made this
software more user friendly. We will also work on providing better
security because it is two sophisticated system to get hacked.

7.2 CONCLUSION
To keep pace with the rapid evolving world, resorting to modern ICT is
the only way. With the increasing demand of modern e-healthcare we
need to come up with ideas that would provide simultaneously fast,
efficient, time saving and userfriendly healthcare service. And we believe
in our heart that our project meets these conditions.

64