A Project Report
Submitted to the Rajasthan Technical University, Kota in
Partial fulfillment of the requirement for the degree of
MASTER OF COMPUTER APPLICATIONS
Patient Case Similarity
MCA-452
(.NET MINI PROJECT)
Dr. Preeti Tiwari Submitted By
Gaurav Sharma –(MCA/2018/3647)
Assistant Professor
Indra Koli –(MCA/2018/3838)
IIIM,Jaipur
Komal Sharma –(MCA/2018/3697)
Parth Mehta –(MCA/2018/3659)
International School of Informatics & Management, Technical Campus, Jaipur
Affiliated to
Rajasthan Technical University, Kota
MCA-2018
May, 2019
CERTIFICATE
This is to certify that Gaurav Sharma, Indra Koli, Komal Sharma and Parth Mehta is/was under training from
07 jan 2019 (Start date) to 30 april 2019 (End date) under my supervision for training on the project, Patient Case
Similarity (Paper Title: .Net Project, Paper Code :451). This report on the project is being submitted to the
Rajasthan Technical University, Kota in partial fulfillment of the requirement for the award of the Degree of
Master of Computer Applications.
I wish him/her great success in all of his/ her future endeavors.
Dr. Preeti Tiwari
Assistant Professor
International School of Informatics & Management, Technical Campus, Jaipur
Date:
ACKNOWLEDGEMENT
The satisfaction that accompanies the successful completion of any task would be incomplete without
the mention of people whose ceaseless cooperation made it possible, whose constant guidance and
encouragement crown all efforts with success.
I thank Dr. Ashok Gupta, Director, International School of Informatics and Management, for giving
me an opportunity to learn and get real work experience.
I also extend my sincere thanks to Dr. Manju Nair, Principal, International School of Informatics and
Management, for providing me an opportunity to build our programming capabilities
I am thankful to Dr. Swati V. Chande, Head of Department(Computer Sciences), International School
of Informatics and Management, for her constant support and encouragement given throughout the
development of the project.
I am also grateful to my project guide Dr. Preeti Tiwari, Assistant Professor, Computer Sciences for
their guidance, inspiration and constructive suggestions that helped me in the preparation of this
project.
I heartily thank our internal project guide Dr. Preeti Tiwari, Assistant Professor, Computer Science,
International School of Informatics and Management, for her/his guidance and suggestions during this
project work.
My sincere thanks for their constant encouragement, support and guidance to the faculty members of
Computer Science department at International School of Informatics and Management. Also, I would
like to extend my gratefulness to the staff in lab, office and library for their timely support.
I also thank my parents, family members and friends for their continuous support, inspiration and
encouragement without which this project would not have been success.
Gaurav Sharma
Indra Koli
Komal Sharma
Parth Mehta
INDEX TABLE
CONTENT
ACKNOWLEDGEMENT
CERTIFICATE
2 PROJECT SPECIFICATION
2.1 PROJECT OVERVIEW
2.2 PROJECT NEED
3 SPECIFIC REQUIREMENT
3.1 HARDWARE INTERFACE
3.2 SOFTWARE INTERFACE
4 SOFTWARE PRODUCT FEATURES
4.1 SYSTEM ARCHITECTURE
4.2 DATABASE REQUIREMENT
4.3ER DIGRAM
4.4DATA FLOW DIGRAM
4.5USER-INTERFACE
5. CODING
6. CONCLUSION
7. BIBLIOGRAPHY
2 Project Specification
2.1 Project overview
• Usually, the people of India mainly depend on agriculture works from the ancient age of the
nation. After Indian independent in 1947, human lifestyle was gradually changed and they search
for new sources of income to survive. From the year of 1981 Indian government provided many
facilities to set up private industries. With the cooperation of government, last 30 years Indian
private firms or industries increased vastly. Now, India is one of the best economically growing
countries in the world.
• The rapid growing industrialization is leading lots of environmental issues by its uncontrolled
polluted emission. Other reasons of pollutions in India are the destruction of forests, emissions of
vehicles, land degradation due to use of poisonous insecticide for agriculture, shortage of natural
resources, rampant burning of wood fuel and many more. Pollution is the main reason to lead lots
of disease, health issues and long-term livelihood impact.
Land pollution in India is due to the poisonous pesticides and fertilizers as well as corrosion
during 2009, the issue of Uranium poisoning in the state of Punjab came into light, caused by fly
ash ponds of thermal power stations, which reportedly lead to severe birth defects in children in
the Faridkot and Bhatinda districts of the state. Other main reason of this type of pollution is poor
garbage disposal services in both the rural and urban areas of India. It is very common in India to
find out a heap of garbage on the Street corners.
2.2 Project Need
The Purpose of our Project is to develop GUI based system i.e. Platform independent & user
friendly, which can be can handled by any user it is reliable medium to -:
Reduce the use of harmful products to the environment.
Reduce the amount of plastic you use.
Reduce your garbage amount.
Reduce paper use.
3 SOFTWARE REQUIREMENTS
3.1 SOFTWARE INTERFACE
Backend C# with ASP.Net
Frontend Html, CSS, JavaScript
Software Visual Studio 2010 and onward
Database Microsoft SQL server
3.2HARDWARE INTERFACE
Processor 2.00 GHZ
RAM 4.00 GB (recommended)
Hard disk Minimum requirement 80 GB
Operating System Windows (recommended)
4 SOFTWARE PRODUCT FEATURES
4.1 SYSTEM ARCHITECTURE
Keeping in mind above problem we have decided to make software eliminating above problems as
well as providing some more facilities to the users.
4.2 DATABASE REQUIREMENT
Microsoft SQL Server is a relational database management system developed by Microsoft. As a
database server, it is a software product with the primary function of storing and retrieving data as
requested by other software applications—which may run either on the same computer or on another
computer across a network (including the Internet).
Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different
audiences and for workloads ranging from small single-machine applications to large Internet-facing
applications with many concurrent users
The original SQL Server code was developed in the 1980s by the former Sybase Inc., which is now
owned by SAP. Sybase initially built the software to run on Unix systems and minicomputer
platforms. It, Microsoft and Ashton-Tate Corp., then the leading vendor of PC databases, teamed up to
produce the first version of what became Microsoft SQL Server, designed for the OS/2 operating
system and released in 1989.
Ashton-Tate stepped away after that, but Microsoft and Sybase continued their partnership until 1994,
when Microsoft took over all development and marketing of SQL Server for its own operating
systems. The year before, with the Sybase relationship starting to unravel, Microsoft had also made
the software available on the newly released Windows NT after modifying the 16-bit OS/2 code base
to create a 32-bit implementation with added features; it focused on the Windows code going forward.
In 1996, Sybase renamed its version Adaptive Server Enterprise, leaving the SQL Server name to
Microsoft.
4.3 E-R diagram
Cardinality: Cardinality is the specification of the number of occurrences of one [object] that can be
related to the number of occurrences of another [object].
Cardinality is usually expressed as simply 'one' or 'many.'
For example, a husband can have only one wife (in most cultures), while a parent can have many
children. Taking into consideration all combinations aof 'one' and 'many,' two [objects] can be related
as:-
One-to-one (l:l): An occurrence of [object] 'A' can relate to one and only one occurrence of
[object] 'B,' and an occurrence of 'B' can relate to only one occurrence of 'A.'
One-to-many (l:N): One occurrence of [object] 'A' can relate to one or many occurrences of
[object] 'B,' but an occurrence of 'B' can relate to only one occurrence of 'A. 'For example, a
mother can have many children, but a child can have only one mother.
Many-to-many (M:N): An occurrence of [object] 'A' can relate to one or more occurrences of 'B,'
while an occurrence of 'B' can relate to one or more occurrences of 'A. 'For example, an uncle can
have many nephews, while a nephew can have many uncles.
1.Entity
A data entity is anything real or abstract about which we want to store data. Entity types fall into five
classes: roles, events, locations, tangible things or concepts. E.g. employee, payment, campus, book.
Specific examples of an entity are called instances. E.g. the employee John Jones, Mary Smith's
payment, etc.
2.Relationship
A data relationship is a natural association that exists between one or more entities. E.g. Employees
process payments. .
3.Attribute
A data attribute is a characteristic common to all or most instances of a particular entity. Synonyms
include property, data element, and field. E.g. Name, address, Employee Number, pay rate are all
attributes of the entity employee. An attribute or combination of attributes that uniquely identifies one
and only one instance of an entity is called a primary key or identifier. E.g. Employee Number is a
primary key for Employee.
E-R Diagram
4.4Data Flow diagram
A data flow diagram shows the way information flows through a process or system. It includes data
inputs and outputs, data stores, and the various sub-processes the data moves through. DFDs are built
using standardized symbols and notation to describe various entities and their relationships.
Data flow diagrams visually represent systems and processes that would be hard to describe in a
chunk of text. You can use these diagrams to map out an existing system and make it better or to plan
out a new system for implementation.
Logical and Physical DFD
Logical data flow diagrams focus on what happens in a particular information flow: what
information is being transmitted, what entities are receiving that info, what general processes occur,
etc. The processes described in a logical DFD are business activities—a logical DFD doesn’t delve
into the technical aspects of a process or system. Non-technical employees should be able to
understand these diagrams.
Physical data flow diagrams focus on how things happen in an information flow. These diagrams
specify the software, hardware, files, and people involved in an information flow. A detailed physical
data flow diagram can facilitate the development of the code needed to implement a data system.
Symbols used in data flow diagram
1. -: Source rectangle, which defines or destination.
2. -: Arrow, which shows dataflow.
3. -: Circle, which represent a process that transforms data into outgoing flow.
4. -: Open rectangle, which shows a data store.
Level 0
Level1
Level2
4.5USER-INTERFACE
Home
Sinus
Malaria
Appendicitis
Thyroid
Registration
Database
5. Coding
Sinus(Form)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class Default2 : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection("Data
Source=(LocalDB)\\v11.0;AttachDbFilename=C:\\Users\\Gaurav\\Documents\\Demo.mdf;Integrated
Security=True;Connect Timeout=30");
SqlDataReader reader = null;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button3_Click(object sender, EventArgs e)
{
try
{
conn.Open();
if (FileUpload1.HasFile)
{
String vfile = FileUpload1.FileName.ToString();
FileUpload1.SaveAs(Server.MapPath("~/Uploads/" + FileUpload1.FileName));
LabMessage.Text = "File Upload";
LabMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
LabMessage.Text = " Please Select a File to Upload";
LabMessage.ForeColor = System.Drawing.Color.Red;
}
String vUploadReport = FileUpload1.FileName.ToString();
int vP_Id = Convert.ToInt32(TextBox7.Text);
String vFirstName = TextBox1.Text;
String vLastName = TextBox2.Text;
String vContact = TextBox3.Text;
String vDisease = TextBox8.Text;
String vAge = TextBox9.Text;
String vGender = DropDownList1.SelectedValue.ToString(); ;
String vMedicine1 = TextBox5.Text;
String vMedicine2 = TextBox6.Text;
String insertstring = "insert into Disease
(P_Id,FirstName,LastName,Contact,Disease,UploadReport,Age,Gender,Medicine1,Medicine2)
values('" + vP_Id + "','" + vFirstName + "','" + vLastName + "','" + vContact + "','" +
vDisease + "','" + vUploadReport + "','" + vAge + "','" + vGender + "','" + vMedicine1 + "','"
+ vMedicine2 + "')";
SqlCommand cmd = new SqlCommand(insertstring, conn);
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
}
Malaria (Form)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class Default2 : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection("Data
Source=(LocalDB)\\v11.0;AttachDbFilename=C:\\Users\\Gaurav\\Documents\\Demo.mdf;Integrated
Security=True;Connect Timeout=30");
SqlDataReader reader = null;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button3_Click(object sender, EventArgs e)
{
try
{
conn.Open();
if (FileUpload1.HasFile)
{
String vfile = FileUpload1.FileName.ToString();
FileUpload1.SaveAs(Server.MapPath("~/Uploads/" + FileUpload1.FileName));
LabMessage.Text = "File Upload";
LabMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
LabMessage.Text = " Please Select a File to Upload";
LabMessage.ForeColor = System.Drawing.Color.Red;
}
String vUploadReport = FileUpload1.FileName.ToString();
int vP_Id = Convert.ToInt32(TextBox7.Text);
String vFirstName = TextBox1.Text;
String vLastName = TextBox2.Text;
String vContact = TextBox3.Text;
String vDisease = TextBox8.Text;
String vAge = TextBox9.Text;
String vGender = DropDownList1.SelectedValue.ToString(); ;
String vMedicine1 = TextBox5.Text;
String vMedicine2 = TextBox6.Text;
String insertstring = "insert into Disease
(P_Id,FirstName,LastName,Contact,Disease,UploadReport,Age,Gender,Medicine1,Medicine2)
values('" + vP_Id + "','" + vFirstName + "','" + vLastName + "','" + vContact + "','" +
vDisease + "','" + vUploadReport + "','" + vAge + "','" + vGender + "','" + vMedicine1 + "','"
+ vMedicine2 + "')";
SqlCommand cmd = new SqlCommand(insertstring, conn);
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
}
Thyroid (Form)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class Default2 : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection("Data
Source=(LocalDB)\\v11.0;AttachDbFilename=C:\\Users\\Gaurav\\Documents\\Demo.mdf;Integrated
Security=True;Connect Timeout=30");
SqlDataReader reader = null;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button3_Click(object sender, EventArgs e)
{
try
{
conn.Open();
if (FileUpload1.HasFile)
{
String vfile = FileUpload1.FileName.ToString();
FileUpload1.SaveAs(Server.MapPath("~/Uploads/" + FileUpload1.FileName));
LabMessage.Text = "File Upload";
LabMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
LabMessage.Text = " Please Select a File to Upload";
LabMessage.ForeColor = System.Drawing.Color.Red;
}
String vUploadReport = FileUpload1.FileName.ToString();
int vP_Id = Convert.ToInt32(TextBox7.Text);
String vFirstName = TextBox1.Text;
String vLastName = TextBox2.Text;
String vContact = TextBox3.Text;
String vDisease = TextBox8.Text;
String vAge = TextBox9.Text;
String vGender = DropDownList1.SelectedValue.ToString(); ;
String vMedicine1 = TextBox5.Text;
String vMedicine2 = TextBox6.Text;
String insertstring = "insert into Disease
(P_Id,FirstName,LastName,Contact,Disease,UploadReport,Age,Gender,Medicine1,Medicine2)
values('" + vP_Id + "','" + vFirstName + "','" + vLastName + "','" + vContact + "','" +
vDisease + "','" + vUploadReport + "','" + vAge + "','" + vGender + "','" + vMedicine1 + "','"
+ vMedicine2 + "')";
SqlCommand cmd = new SqlCommand(insertstring, conn);
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
}
Appendicitis
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class Default2 : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection("Data
Source=(LocalDB)\\v11.0;AttachDbFilename=C:\\Users\\Gaurav\\Documents\\Demo.mdf;Integrated
Security=True;Connect Timeout=30");
SqlDataReader reader = null;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button3_Click(object sender, EventArgs e)
{
try
{
conn.Open();
if (FileUpload1.HasFile)
{
String vfile = FileUpload1.FileName.ToString();
FileUpload1.SaveAs(Server.MapPath("~/Uploads/" + FileUpload1.FileName));
LabMessage.Text = "File Upload";
LabMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
LabMessage.Text = " Please Select a File to Upload";
LabMessage.ForeColor = System.Drawing.Color.Red;
}
String vUploadReport = FileUpload1.FileName.ToString();
int vP_Id = Convert.ToInt32(TextBox7.Text);
String vFirstName = TextBox1.Text;
String vLastName = TextBox2.Text;
String vContact = TextBox3.Text;
String vDisease = TextBox8.Text;
String vAge = TextBox9.Text;
String vGender = DropDownList1.SelectedValue.ToString(); ;
String vMedicine1 = TextBox5.Text;
String vMedicine2 = TextBox6.Text;
String insertstring = "insert into Disease
(P_Id,FirstName,LastName,Contact,Disease,UploadReport,Age,Gender,Medicine1,Medicine2)
values('" + vP_Id + "','" + vFirstName + "','" + vLastName + "','" + vContact + "','" +
vDisease + "','" + vUploadReport + "','" + vAge + "','" + vGender + "','" + vMedicine1 + "','"
+ vMedicine2 + "')";
SqlCommand cmd = new SqlCommand(insertstring, conn);
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
}
Registration
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Sql;
using System.Data;
using System.Data.SqlClient;
namespace WebApplication6
{
public partial class WebForm5 : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection("Data
Source=(LocalDB)\\v11.0;AttachDbFilename=C:\\Users\\Gaurav\\Documents\\register.mdf;Integrated
Security=True;Connect Timeout=30");
SqlDataReader rdr = null;
protected void Page_Load(object sender, EventArgs e)
{
form1.Style["BACKGROUND-COLOR"] = "black";
protected void Button1_Click(object sender, EventArgs e)
{
try
{
conn.Open();
int vpid = Convert.ToInt16(TextBox1.Text);
string vname = TextBox2.Text;
string vgender = Convert.ToString(DropDownList1.SelectedValue);
double vcontact = Convert.ToDouble(TextBox3.Text);
int vage = Convert.ToInt16(TextBox4.Text);
string vaddress = TextBox5.Text;
string insertstring = "insert into Registeration values(" + vpid + ",'" + vname + "','" + vgender + "'," + vcontact +
"," + vage + ",'" + vaddress + "')";
SqlCommand cmd = new SqlCommand(insertstring, conn);
cmd.ExecuteNonQuery();
}
finally
{
if (conn != null) conn.Close();
if (rdr != null) rdr.Close();
}
Label7.Text = "Paitent registered successfully";
Response.Redirect("successfull.aspx");
}
}
}
5. CONCLUSION
The system providing a platform to Patient and Doctor can track the patient disease as quick as possible
and keep it or Store it in database if the new patient come with the same disease can be given treatment as
soon as possible. This System give facility to Doctor and Patient like Time saving, Accurate medicine
stock management, Easy access for patient and Provide better services. The system is easy to use and the
Doctor has the great advantage of a systematic way to key record and effectively use for the Patient that
have same case then those patient can be give a the best treatment according to their disease and can store
the record of the new Patient which have not have the same
6. BIBLIOGRAPHY
REFERENCES:-
Website:
www.codeproject.com
www.w3school.com
www.google.com
