Web Based Claim Processing System

(1)

A

PRACTICAL TRAINING REPORT

ON

Web Claim Processing System

SUBMITTED IN PARTIAL FULFILLMENT OF THE REQUIREMENT

FOR

COMPLETION OF DEGREE

MASTER OF COMPUTER APPLICATION

BY

Name: Amit Kumar Gautam

Roll No-1006514003

(2)

ACKNOWLEDGEMENT

Keep away from people who try to belittle your ambitions. Small

people always do that, but the really great make you feel that you too,

can become great.

I take this opportunity to express my sincere thanks and deep

gratitude to all those people who extended their wholehearted co-operation

and have helped me in completing this project successfully.

First of all, I would like to thank Mr. Nitin, Director (ZXXXX) for

creating opportunities to undertake me in the esteemed organization.

Special thanks to Mr.Ranjan Project Manager for all the help and

guidance extended to me by him in every stage during my training. His

inspiring suggestions and timely guidance enabled me to perceive the various

aspects of the project in a new light.

I am highly indebted and graceful to xxxx(Project Leader) and

xxxx (Team Leader) for Their strict supervision, constant encouragement,

inspiration and guidance, which ensure the worthiness of my work. Working

under them was an enrich experience. I express my sincere thanks to my

senior of software development department for their encouragement and

valuable suggestion

I would also thank to my Mr.-Pradeep Maheswari, HOD (MCA

Dept.) & my internal project guide Mr. Ranjan who guided me a lot in

completing this project.I would also like to thank my parents & project mate

for guiding and encouraging me throughout the duration of the project.

(3)

DECLARATION

I, Amit Kumar Gautam-, hereby declare that the report of the project

entitled “XXXXXX” has not presented as a part of any other academic work to

get my degree or certificate except B.S.A COLEEGE OF ENGINEERING AND

TECHNOLOGY,MATHURA for the fulfillment of the requirements for the

degree of Master of Computer Application.

Name: Amit Kumar

Gautam

(4)

CERTIFICATE OF ORIGINALITY

This is to certify that the project entitled xxxx being submitted for the

partial fulfillment of degree of MCA, session 2010-2013, is a record of work

carried out by Name under my guidance and supervision.

This is to further certify that the student has attended the Multisoft

Systems, NOIDA for the 6 months after the fifth semester theory exams. His

work has been satisfactory and commendable.

I wish him success in his life.

Date:

Place:

(5)

CERTIFICATE

This is to certify that Name, a bonefide student of MCA of batch 2010has

completed the Project titled “Web Claim Processing System” being

submitted for the partial fulfillment of degree of MCA.

This is to further certify that the student has attended the College name

. and XXXXXXX, NOIDA for the 6 months after the fifth semester theory

exams. His work has been satisfactory and commendable.

Date:

Mr. ---

HOD MCA Department

Place:

College name

(6)

1.1 Purpose...8

1.2 Objective...9

1.3 Project Scope...10

1.4 Technologies...10

1.4.1 Operating Environment...10

...10

1.4.2 Deployment Environment...11

1.4.3 Development Tools and Technologies...12

1.4.4 Development Environment...15

2. OVERALL DESCRIPTION...16

2.1 User Characteristics...16

2.1.1 Employee...16

2.1.2 CPD - Claims Processing Department ...16

2. 2.Assumptions...16

3. SYSTEM FEATURES...17

3. 1.Systern features...17

3.1.1 .Description:...17

3.1 .2.Constraints...17

4. PRELIMINARY DESIGN...18

4.1 Use Case...18

4.2 Specification of actors...19

4.2.1 Employee...19

4.2.2 CPD - Claims Processing Department...19

4.3 Specification of Use Cases...20

4.3.1 Use Case Manage Employee...20

4.3.2 Use Case. Apply Claim...23

4.3.3 Use Case. Approve Claim...25

4.3.4 Use Case. System Login...27

4.4 Process Flow Chart

...29

(7)

(8)

1. Problem Definition and scope of project

1.1 Purpose

ABC is a company which is having employee strength of at least 1000. All the

employees are provided medical reimbursement facility which means that the

expenditure incurred by the employee for treatment is reimbursed by the

company. For reimbursement, the employee needs to fill in a form detailing

the treatment undertaken which includes the name & cost of medicines,

laboratory tests, surgery. The form is duly signed by the employee and it will

be sent to the concerned Claims Processing Department (CPD) by messenger

for processing. CPD will process it and the order regarding the reimbursement

is sent to the Cash counter (CC) where in the employee can come and receive

the reimbursement amount.

Some of the problems associated with the above mentioned process are listed

below:

• The form may miss during transit

• The form is prone to weariness due to which the company may not be

able to read data in it after some years.

• The employees who claimed for medical reimbursement need to visit the

CC from time to time enquiring about the status of their application. This

results in enormous wastage of time of the employee.

To overcome these problems, it is proposed to develop a software titled Web

Based Claims Processing System (WCPS) which is web based so that the

employee can fill the form online and submit it so that the form is sent to CPD

through Internet. At CPD, the form needs to be checked automatically by a

program which will compute the amount that needs to be reimbursed to the

employee for the treatment undertaken. Any excess amount claimed by the

employee is ignored by the software. The amount computed will be routed to

the e-mail account of the employee as well as to the Bank which holds the

accounts of all the employees of the company. The bank will credit the amount

(9)

1.2 Objective

Web Based Claims Processing System (WCPS) is complete end to end solution

to cover all aspects of online claim and reimbursement system.

The basic objective of developing this project is:

• Provides complete web site solution, including employee registration,

enter new claim, approve/ reject claim. Complete web based

administration.

• The Web Based Claims Processing System can automatically display

pending claim count in the main page of employee of Claims Processing

Department (CPD).

• Employee can view their claim status online and all claims can be treated

as Pending, Approved and Rejected.

• Employee of CPD can add, edit employee details, all employees are

identified by the employee no. Employee no will be unique throughout

the system.

• System must store audit trail of all DML transaction, like it stores

employee no, time stamp in the database for add, edit, delete operation.

• System should capture lat login time for all the employees.

• Complete web based system no installation required to run the

application in client system.

(10)

1.3 Project Scope

The Web Based Claims Processing System (WCPS) will permit to enter new

claim, track the claim status and maintaining master information. The main

users of the project are Employee of all departments and Employee of CPD –

Claim Processing Department.

From an end-user perspective, the Web Based Claims Processing System

Project consists of two functional elements: enhanced Employee modules for

Login, Apply for new claim, view status of already applied claim. And CPD

module for approve/reject claim, view pending status, Add/Edit employee

details.

1.4 Technologies

1.4.1 Operating Environment

OE-1:

The WCPS web application will operate with the following

Web Browsers: Microsoft Internet Explorer version 5.0, 6.0. 7.0

OE-2:

The WCPS web application shall operate on a server running

the latest versions of IIS (Internet Information Server).

OE-3: The WCPS web application shall permit user access from Internet

connection

OE-4: Operating System: Windows 2000. XP

OE-5: Software requirements: SQL Server 2008, .net framework 2.0.

OE-6: Languages used are asp.net using c# and scripting is done using

(11)

1.4.2 Deployment Environment

DE-1:

Database Server

OS – Win 2003 Enterprise Server

SQL Server 2005

HDD – Min 10 GB, Recommended 25 GB

RAM – Min 2 GB, Recommended 4 GB

Processor - Pentium Dual Xenon Processor

DE-2:

Application Server

OS – Win 2003 Enterprise Server

IIS – Internet Information Server

HDD – Min 5 GB, Recommended 10 GB

RAM – Min 2 GB, Recommended 4 GB

Processor - Pentium Dual Xenon Processor

DE-3:

The WCPS web application will operate with the following

Web Browsers: Microsoft Internet Explorer version 5.0, 6.0. 7.0.

(12)

1.4.3 Development Tools and Technologies

DT-1:

ASP.Net

As we need to develop Web Application for Web Based Claims

Processing System (WCPS). We will use ASP.Net as it is the new

Microsoft technology to develop any application which support and

integrate other server product for the internet. By ASP.Net we can

develop in web application by .NET framework and manage

environment with any .NET support language like VB.Net and C#.

DT-2: C#

.NET is built on the Windows Server System to take major

advantage of the OS and which comes with a host of different

servers which allows for building, deploying, managing and

maintaining Web-based solutions. The Windows Server System is

designed with performance as priority and it provides scalability,

reliability, and manageability for the global, Web-enabled

enterprise. The Windows Server System integrated software

products are built for interoperability using open Web standards

such as XML and SOAP.

.NET is a "Software Platform". It is a language-neutral environment

for developing rich .NET experiences and building applications that

can easily and securely operate within it. When developed

applications are deployed, those applications will target .NET and

will execute wherever .NET is implemented instead of targeting a

particular Hardware/OS combination. The components that make

(13)

application and reallocation of memory for resources that are not

needed.

The .NET Framework is designed for cross-language compatibility.

Cross-language compatibility means, an application written in

Visual Basic .NET may reference a DLL file written in C# (C-Sharp).

A Visual Basic .NET class might be derived from a C# class or vice

versa.

The .NET Framework consists of two main components:

Common Language Runtime (CLR)

Class Libraries

The advantage of C# includes

Powerful Windows-based Applications

Building Web-based Applications

Simplified Deployment

• Powerful, Flexible, Simplified Data Access

• Improved Coding

• Direct Access to the Platform

• Full Object-Oriented Constructs

• XML Web Services

• COM Interoperability

DT-3: SQL Server 2008

WCPS Application uses SQL Server 2008 as storing the data.

Microsoft SQL Server 2008 as our database and it has so many

(14)

• Scalability

• Replication

• Centralized Management

• Reliability

(15)

1.4.4 Development Environment

DE-1:

1.Visual Studio 2010 IDE

Most advanced integrated development environment for

developing .NET application. Microsoft Visual Studio is an

integrated development environment (IDE) from Microsoft. It can

be used to develop console and graphical user interface

applications along with Windows Forms applications, web sites,

web applications, and web services in both native code together

with managed code for all platforms supported by Microsoft

Windows, Windows Mobile, Windows CE, .NET Framework, .NET

Compact Framework and Microsoft Silverlight.

Visual Studio includes a code editor supporting IntelliSense as well

as code refactoring. The integrated debugger works both as a

source-level debugger and a machine-level debugger. Other

built-in tools built-include a forms designer for buildbuilt-ing GUI applications, web

designer, class designer, and database schema designer. It allows

plug-ins to be added that enhance the functionality at almost every

level - including adding support for source control systems (like

Subversion and Visual SourceSafe) to adding new toolsets like

editors and visual designers for domain-specific languages or

toolsets for other aspects of the software development lifecycle

(like the Team Foundation Server client: Team Explorer).

Visual Studio supports languages by means of language services,

which allow any programming language to be supported (to

(16)

available via language services which are to be installed

separately. It also supports XML/XSLT, HTML/XHTML, JavaScript and

CSS. Language-specific versions of Visual Studio also exist which

provide more limited language services to the user. These

individual packages are called Microsoft Visual Basic, Visual J#,

Visual C#, and Visual C++.

2. Overall Description

2.1 User Characteristics

2.1.1 Employee

Able to login, apply for new claim, view claim status, change password.

2.1.2 CPD - Claims Processing Department

CPD Employee can add new employee, edit employee details, approve / reject

claim, view status, change his/her own password.

2. 2.Assumptions

(17)

3. System Features

3. 1.Systern features

3.1.1 .Description:

Proposed to develop a software titled Web Based Claims Processing System

(WCPS) which is web based so that the employee can fill the form online and

submit it so that the form is sent to CPD through Internet. At CPD, the form

needs to be checked automatically by a program which will compute the

amount that needs to be reimbursed to the employee for the treatment

undertaken. Any excess amount claimed by the employee is ignored by the

software. The amount computed will be routed to the e-mail account of the

employee as well as to the Bank which holds the accounts of all the employees

of the company. The bank will credit the amount to the account of the

employee based on the mail.

3.1 .2.Constraints

Linking and integration with other legacy system for data sharing. Connecting

to third-party OLAP applications for generating reports. Etc.

(18)

4. Preliminary Design

4.1 Use Case

Web Based Claims Processing System (WCPS) 1.0 will address the following

use cases. The complete usage scenarios will be completed during the

information-gathering process. Use cases will be created and prioritized.

Selected use cases will be expanded into usage scenarios and features that

are derived from both use cases and the usage

scenario

Employee Syemst Login Manage Employee Approve Claim Apply for Claim

(19)

[Web Based Claims Processing System (WCPS) Usage Scenario – This usage

scenario, or scenario for short, describes a real-world example of how one or

more people or organizations interact with Web Based Claims Processing

System (WCPS). It describes the steps, events, and/or actions which occur

during the interaction. This Usage scenarios indicating exactly how someone

works with the user interface, or reasonably high level describing the critical

business actions but not the indicating how they’re performed. ]

4.2 Specification of actors

The following actors are defined so far in the analysis phase of the Web Based

Claims Processing System (WCPS) development process.

4.2.1 Employee

Employee

Element Details

Description An employee is a user of the Web Based Claims Processing System (WCPS) system.

Examples An Employee apply for new claim and view the status of his/her own claim.

4.2.2 CPD - Claims Processing Department

(20)

4.3 Specification of Use Cases

4.3.1 Use Case

Manage Employee

Manage Employee

Actor CPD

Trigger Employee is not registered in the System and the CPD wish to Add new employee into the WCPS.

Pre Conditions Employee no is not listed in the system. CPD opens the new employee page, and the new employee page is displayed. Post Conditions Employee is registered in the system, new employee no is

generated.

Normal course 1. New Employee page appears on the screen

2. System increment the last registered Employee No by 1 to get the No for the new employee.

3. CPD fill in the Employee’s information including Name, Department, Designation, Date of Birth, Email ID, Adress(es), Phone number(s),

4. System update

Alternative courses 3a. Not all mandatory data fields are filled

(21)

Use Case Diagram : Manage Employee

CPD Employee Registration Validate Information Generate new employee no Update Database Employee List

(22)

[Use Case: Manage Employee – This use case scenario, or scenario for short,

describes how CPD will add new employee into Web Based Claims Processing

System (WCPS). It describes the steps, events, and/or actions which occur

during the interaction. This Usage scenarios indicating exactly how someone

works with the employee registration interface. ]

(23)

4.3.2 Use Case.

Apply Claim

Mange Question Banks

Actor Employee

Trigger Apply for new claim

Pre Conditions Employee wish to apply for new claim and having login rights to WCPS.

Post Conditions New claim is saved, and details are listed in pending claim details.

Normal Event Flow 1. The employee open the new claim page

2. Employee select claim type. Enter amount, and remark. 3. Employee update the System by confirming the data

entered into the new claim form.

4. System saved the claim and display claim details in pending lists.

Variations 3a. Mandatory fields in the claim form are missing

3a1. The system reject the entry and system update with an error message about missing mandatory fields.

(24)

Use Case Diagram: Apply Claim

[Use Case: Apply Claim – This use case scenario, or scenario for short,

describes how employee will apply new claim into Web Based Claims

Processing System (WCPS). It describes the steps, events, and/or actions

which occur during the interaction. ]

Employee New Claim Claim Type Check Duplicate Validation Add to Catalog

(25)

4.3.3 Use Case.

Approve Claim

Approve Claim

Actor CPD

Trigger CPD staff wants to approve claim

Pre Conditions The CPD staff must register into the system, the CPD is logged into the system, and the system display pending list for claim need to approve.

Post Conditions Claim status is updated and Employee can view the status of his / her claim.

Normal event flow 1. CPD logged in.

2. System displays all pending claim details. 3. CPD selects the claim, view the details

4. CPD updated the claim status, like approved / reject, enters remarks.

5. CPD logged out from the system.

(26)

Use Case Diagram: Approve Claim

[Use Case: Approve Claim – This use case scenario, or scenario for short,

describes how CPD staff approved claim in Web Based Claims Processing

System (WCPS). It describes the steps, events, and/or actions which occur

during the interaction. ]

CPD Pending Claim List Claim Master Navigate Claim List View Claim Details Update Claim Status

(27)

4.3.4 Use Case.

System Login

System Login

Actor Employee, CPD

Trigger The user wish to start using the system. Pre Conditions The user is not logged into the system.

Post Conditions The user is logged into the system, and the system menu is displayed.

Normal course 1. The user click the link for theWCPS and a login page appear on the screen.

2. The user types his username and password into the form and press the login button.

3. The system confirms that the user is logged on. Alternative courses 2a. The user is not a valid user or the user name or the

password is mistyped.

2a1. The system reject login with an error message that express wrong

(28)

Use Case Diagram: System Login

[Use Case: System Login – This use case scenario, or scenario for short,

describes how actors will perform login Web Based Claims Processing System

(WCPS). It describes the steps, events, and/or actions which occur during the

interaction. ]

Employee Login to System CPD Employee Master Identified the type of Employee System menu displayed

(29)

4.4 Process Flow Chart

Start Login Modul e Selecti on CPD Employee View Pending Claim Status Approve / Reject Claim Manage Employee Apply New Claim View Status Stop

(30)

(31)

4.7 Data Dictionary

Table: emp_master

Column Name

Data Type

Field Length

Empid

int

4 Empname

varchar

50 Department

varchar

20 Designation

varchar

20 Emailid

varchar

50 Dob

varchar

10 Address

varchar

50 City

varchar

20 State

varchar

20 Mobile

varchar

11 acno

varchar

20 bank

varchar

50 password

varchar

20 utype

varchar

50

(32)

Table: emp_claims

Column Name

Data Type

Field Length

appid

int

4 empid

int

4 pname

varchar

50 hospital

varchar

50 realtion

varchar

50 apptype

varchar

50 discription

varchar

50 claimamount

int

4 cdate

varchar

20 status

varchar

50 apamount

int

4 apdate

varchar

20 apdiscription

varchar

50

(33)

This project was developed to fulfill user requirement; however there are lots

of scope to improve the performance of the Web Based Claims Processing

System (WCPS) in the area of user interface, database performance, and query

processing time. Etc.

So there are many things for future enhancement of this project. The future

enhancements that are possible in the project are as follows.

• Linking and integration of other online web sites.

• Integration with other legacy accounting database through Web Services

• Connection to third-party OLAP applications

• In the area of data security and system security.

• Provide more online tips and help.

(34)

6. Bibliography

6.1 Websites

Following websites are referring to create this project reports.

• http://www.google.com

• http://www.microsoft.com

• http://www.programmer2programmer.net

• http://www.codeproject.com

• http://www.asp.net

• http://www.asp123.com

• http://www.wikipedia.org

6.2 Books

Following books and ebook are used to complete this project reports.

• Mastering C# (Paperback)

• SQL Server Bible (Paperback)

• .NET Black Book (Paperback)

• Professional C#, 2nd Edition (Paperback)

• Professional ASP.NET (Paperback)

• MCAD/MCSD Self-Paced Training Kit: Developing Web Applications with

Microsoft® Visual Basic® .NET and Microsoft Visual C#® .NET, Second

(35)

Main.aspx

<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="Main.aspx.cs"Inherits="Main" %>

<!DOCTYPEhtmlPUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <htmlxmlns="http://www.w3.org/1999/xhtml">

<headrunat="server">

<marqueedirection="left">B.S.A College Of Engineerinf & Technology , Mathura </marquee>

<styletype="text/css">

.style1 { width: 26%; } .style2 { width: 157px; } .style3 { width: 1291px; height: 159px; } </style> </head>

(36)

</tr>

</table>

<h2style="border: thin solid #800080; width:100%; text-align:center">

<fontcolor="#a44976"> Welcome To B.S.A.C.E.T, Mathura</font></h2><br/><center>

<asp:LabelID="Label1"runat="server"Text="Wrong User ID Or Password"

Font-Bold="True"Font-Italic="True"ForeColor="#FF3300"Font-Size="Medium"

Visible="False"></asp:Label>

<tablewidth="100%"> <tr> <tdstyle="width:15%"></td>

<tdstyle="width:20%"><imgsrc="image/user_login.jpg"width="100%"/></td>

<tdclass="style1">

<fieldsetstyle="width: 331px">

<legend>Login</legend>

<tablecellspacing="5px"

style="color: #0000FF; font-family: 'Times New Roman', Times, serif; width: 334px;

height: 92px; vertical-align:top; vertical-align:text-top">

<tr>

<tdclass="style2"valign="top">Enter The Employee/Admin ID</td>

<td>

<asp:TextBoxID="TextBox1"runat="server"ontextchanged="TextBox1_TextChanged"

BackColor="#FBFCFB"BorderColor="#FFFF99"ForeColor="#0000FF"

Font-Bold="True"></asp:TextBox>

<br/>

<asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"

ErrorMessage="Please Enter The Id"ControlToValidate="TextBox1"

ForeColor="#FF0066"></asp:RequiredFieldValidator></td>

</tr>

<tr>

<tdclass="style2"valign="top">Enter The PassWord</td>

<td>

<asp:TextBoxID="TextBox2"runat="server"BackColor="#FBFCFB"

BorderColor="#FFFF99"ForeColor="#0000FF"Font-Bold="True"

TextMode="Password"></asp:TextBox>

<br/>

ErrorMessage="Please Enter PassWord"ControlToValidate="TextBox2"

ForeColor="#FF0066"></asp:RequiredFieldValidator></td>

</tr>

(37)

<tdstyle="width:15%"></td> </tr> </table> </center> </asp:Panel>

<pstyle="text-align:justify">

I have done Training in Multisoft Systems,Noida. At MultiSoft Systems we go beyond

traditional staffing methods to bring you the results you need. We have the experience and knowledge to design custom recruiting programs and strategies that will provide the precise solution to your unique situation.

</p>

<marqueedirection="left">Amit Gautam, Mca 2013</marquee> </div> </form> </body> </html> Main.aspx.cs using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient;

publicpartialclassMain : System.Web.UI.Page

{

protectedvoid Page_Load(object sender, EventArgs e) {

}

protectedvoid TextBox1_TextChanged(object sender, EventArgs e) {

(38)

try

{

dr = cmd.ExecuteReader(); if (dr.Read())

{

string utype = dr[1].ToString(); if (utype == "Admin")

{

Session["uname"] = dr[2].ToString(); Session["admin"] = dr[1].ToString(); Session["empid"] = dr[0].ToString(); Session["dept"] = dr[3].ToString(); Session["desig"] = dr[4].ToString(); Response.Redirect("Home.aspx"); }

elseif (utype == "User" || utype == "Employee") {

Session["uname"] = dr[2].ToString(); Session["user"] = dr[1].ToString(); Session["empid"] = dr[0].ToString(); Session["dept"] = dr[3].ToString(); Session["desig"] = dr[4].ToString(); Response.Redirect("Uhome.aspx"); }

else

{

Label1.Visible = true;

Label1.Text = "Not A Vailid User"; }

} else

{

Label1.Text = "Wrong User ID Or Password"; }

} catch

{

Label1.Text = "Please Enter The Employe ID Provided By Company";

(39)

Home.aspx

<%@PageTitle=""Language="C#"MasterPageFile="~/Site.master"AutoEventWireup="true"

CodeFile="home.aspx.cs"Inherits="_Default" %>

<asp:ContentID="Content1"ContentPlaceHolderID="head"Runat="Server"> </asp:Content>

<asp:ContentID="Content2"ContentPlaceHolderID="ContentPlaceHolder1"Runat="Server">

<h2style="border: thin solid #800080; width:100%; text-align:center"> <fontcolor="#a44976"> Welcome To B.S.A.C.E.T, Mathura</font></h2>

<asp:LinkButtonID="LinkButton2"runat="server"ForeColor="#FF6600"

Visible="False"PostBackUrl="~/aprove.aspx">LinkButton</asp:LinkButton><br/>

<fieldsetstyle="width:90%">

<legend>Control Panel</legend>

<tablewidth="100%">

<tr>

<tdwidth="30%">

<ahref="Reg.aspx">

 <asp:ImageID="Image1"runat="server"Height="205px"

ImageUrl="~/image/logo-registration-services-250x250.jpg"

ToolTip="Registration"Width="180px"/>

(40)

<tdwidth="30%">

<ahref="Changepass.aspx">

ImageUrl="~/image/lim.png"ToolTip="Change Password"Width="180px"/>

</a> </td> </tr> <tr> <tdwidth="30%"> <ahref="empdetail.aspx">

ImageUrl="~/image/stock-vector-user-login-vector-icon-isolated-96506144.jpg"

ToolTip="View Employee Detail"Width="180px"/>

 </a></td>

<tdwidth="30%">

<ahref="aprove.aspx">

ImageUrl="~/image/FreelancerMarketplace-1577.jpg"ToolTip="View Employee Claim"

Width="180px"/>

 </a></td>

<tdwidth="30%">

<ahref="Reg.aspx">

ImageUrl="~/image/FreelancerMarketplace-1577.jpg"ToolTip="View Employee Claim" Width="180px"/>  </a></td> </tr> </table> </fieldset> </asp:Content>

home.aspx.cs

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

(41)

int i = (int)cmd.ExecuteScalar(); con.Close();

if (i > 0) {

LinkButton2.Visible = true;

LinkButton2.Text = "You Have " + i.ToString() + " More Pending Claim"; }

} }

(42)

Reg.aspx

CodeFile="Reg.aspx.cs"Inherits="Reg" %>

<%@Registersrc="WebUserControl2.ascx"tagname="WebUserControl2"tagprefix="uc1" %>

<asp:ContentID="Content1"ContentPlaceHolderID="head"Runat="Server">

.style2 { width: 600px; height:500px; } .style4 { width: 276px; margin-left: 80px; } .style5 { width: 1284px; height: 24px; } .style7

(43)

height: 9px; } .style10 { width: 1284px; height: 2px; } .style11 { width: 276px; margin-left: 80px; height: 2px; } .style12 { height: 2px; } .style16 { width: 1284px; } .style17 { width: 1284px; height: 18px; } .style18 { width: 276px; margin-left: 80px; height: 18px; } .style19 { height: 18px; } .style20 { width: 1284px; height: 13px; } .style21 { width: 276px; margin-left: 80px; height: 13px; } .style22 { height: 13px;

(44)

margin-left: 80px; height: 20px; } .style25 { height: 20px; } .style26 { width: 1284px; height: 19px; } .style27 { width: 276px; margin-left: 80px; height: 19px; } .style28 { height: 19px; } .style29 { width: 1284px; height: 30px; } .style30 { width: 276px; margin-left: 80px; height: 30px; } .style31 { height: 30px; } </style> </asp:Content>

<h2style="border: thin solid #800080; width:100%; text-align:center"> <fontcolor="#a44976"> Employee Registration</font></h2>

<asp:LabelID="Label1"runat="server"ForeColor="#FF3300"

Text="You Have Successfully Added A New Record"Visible="False"></asp:Label></center>

(45)

SetFocusOnError="True"></asp:RequiredFieldValidator> </td> </tr> <tr> <tdclass="style5"> Department</td> <tdclass="style4">

<asp:DropDownListID="DropDownList1"runat="server"Height="25px"

Width="160px">

<asp:ListItem>Select Department</asp:ListItem>

<asp:ListItem>IT</asp:ListItem>

<asp:ListItem>CS</asp:ListItem>

<asp:ListItem>EC</asp:ListItem>

<asp:ListItem>Sales</asp:ListItem>

<asp:ListItem>MCA</asp:ListItem>

</asp:DropDownList>

</td>

<td>

<asp:RequiredFieldValidator ID="RequiredFieldValidator3"runat="server"

ControlToValidate="DropDownList1"ErrorMessage="RequiredFieldValidator"

SetFocusOnError="True"></asp:RequiredFieldValidator>

</td> </tr> <tr> <tdclass="style26"> Designation</td> <tdclass="style27">

Width="160px">

<asp:ListItem>Select Designation</asp:ListItem>

<asp:ListItem>Developer</asp:ListItem>

<asp:ListItem>Tester</asp:ListItem>

<asp:ListItem>Designer</asp:ListItem>

<asp:ListItem>Team Leader</asp:ListItem>

<asp:ListItem>Project Manager</asp:ListItem>

<asp:ListItem>Trainer</asp:ListItem>

<asp:ListItem>Admin</asp:ListItem>

</asp:DropDownList>

</td>

<tdclass="style28">

</td> </tr> <tr> <tdclass="style17"> User Type</td> <tdclass="style18">

(46)

<tr>

<tdclass="style23">

Email Id</td>

<tdclass="style24">

<asp:TextBoxID="TextBox3"runat="server"Height="19px"

Width="156px"></asp:TextBox>

</td>

<tdclass="style25">

<asp:RegularExpressionValidatorID="RegularExpressionValidator1"runat="server"

ControlToValidate="TextBox3"ErrorMessage="RegularExpressionValidator"

ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+ ([-.]\w+)*"></asp:RegularExpressionValidator> </td> </tr> <tr> <tdclass="style16"> Date Of Birth</td> <tdclass="style4">

<asp:DropDownListID="DropDownList3"runat="server"Height="25px">

<asp:ListItem>DD</asp:ListItem>

<asp:ListItem>1</asp:ListItem>

(47)

</asp:DropDownList>

<asp:DropDownListID="DropDownList5"runat="server"

style="height: 25px; width: 55px">

<asp:ListItem>YYYY</asp:ListItem>

</asp:DropDownList>

</td>

<td>

</td> </tr> <tr> <tdclass="style20"> Address</td> <tdclass="style21">

</td>

<tdclass="style22">

ControlToValidate="TextBox4"ErrorMessage="RequiredFieldValidator"

</td> </tr> <tr> <tdclass="style16"> City</td> <tdclass="style4">

</td>

<td>

</td> </tr> <tr> <tdclass="style16"> State</td> <tdclass="style4">

(48)

<asp:ListItem>Haryana</asp:ListItem>

<asp:ListItem>Himachal Pradesh</asp:ListItem>

<asp:ListItem>Jammu and Kashmir</asp:ListItem>

<asp:ListItem>Jharkhand</asp:ListItem>

<asp:ListItem>Karnataka</asp:ListItem>

<asp:ListItem>Kerala</asp:ListItem>

<asp:ListItem>Madhya Pradesh</asp:ListItem>

<asp:ListItem>Maharashtra</asp:ListItem>

<asp:ListItem>Manipur</asp:ListItem>

<asp:ListItem>Meghalaya</asp:ListItem>

<asp:ListItem>Mizoram</asp:ListItem>

<asp:ListItem>Nagaland</asp:ListItem>

<asp:ListItem>Orissa</asp:ListItem>

<asp:ListItem>Punjab</asp:ListItem>

<asp:ListItem>Rajasthan</asp:ListItem>

<asp:ListItem>Sikkim</asp:ListItem>

<asp:ListItem>Tamil Nadu</asp:ListItem>

<asp:ListItem>Tripura</asp:ListItem>

<asp:ListItem>Uttarakhand</asp:ListItem>

<asp:ListItem>Uttar Pradesh</asp:ListItem>

<asp:ListItem>West Bengal</asp:ListItem>

</asp:DropDownList>

</td>

<td>

</td> </tr> <tr> <tdclass="style16"> Mobile No.</td> <tdclass="style4">

<asp:TextBoxID="TextBox6"runat="server"Height="19px"Width="156px"

MaxLength="11"></asp:TextBox>

</td>

<td>

<asp:RegularExpressionValidatorID="RegularExpressionValidator2"runat="server"

ControlToValidate="TextBox6"ErrorMessage="Wrong Mobile No"

ValidationExpression="\d\d\d\d\d\d\d\d\d\d"></asp:RegularExpressionValidator>

</td> </tr> <tr> <tdclass="style17"> Account No.</td> <tdclass="style18">

(49)

<td>

</td> </tr> <tr> <tdclass="style10"> PassWord</td> <tdclass="style11">

</td> <tdclass="style12"> </td> </tr> <tr> <tdclass="style9">       

<inputid="Reset1"type="reset"value="Clear"

style="background-color: #A52B5E; color: #FBFCFB;" /></td>

<tdclass="style7">

<asp:ButtonID="Button1"runat="server"Text="Save"Width="109px"

onclick="Button1_Click"Height="27px"BackColor="#A52B5E"

ForeColor="#FBFCFB"/> </td> <tdclass="style8"> </td> </tr> </table> </fieldset> </asp:Content>

Reg.aspx.cs

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;

publicpartialclassReg : System.Web.UI.Page

(50)

SqlConnection con =newSqlConnection(db.connection); // SqlCommandBuilder cb;

//DataSet ds = new DataSet();

SqlDataAdapter da = newSqlDataAdapter();

protectedvoid Button1_Click(object sender, EventArgs e) {

da.InsertCommand = newSqlCommand("regiemp", con); // cb = new SqlCommandBuilder(da);

con.Open();

da.InsertCommand.CommandType = CommandType.StoredProcedure;

da.InsertCommand.Parameters.AddWithValue("@ename", TextBox2.Text); da.InsertCommand.Parameters.AddWithValue("@dep", DropDownList1.Text); da.InsertCommand.Parameters.AddWithValue("@desig", DropDownList2.Text); da.InsertCommand.Parameters.AddWithValue("@email", TextBox3.Text);

//string s = DropDownList3.Text + "/" + DropDownList4.Text + "/" + DropDownList5.Text;

da.InsertCommand.Parameters.AddWithValue("@dob", DropDownList3.Text + "/" + DropDownList4.Text + "/" + DropDownList5.Text);

da.InsertCommand.Parameters.AddWithValue("@add", TextBox4.Text); da.InsertCommand.Parameters.AddWithValue("@city", TextBox5.Text);

da.InsertCommand.Parameters.AddWithValue("@state", DropDownList6.Text); da.InsertCommand.Parameters.AddWithValue("@mobile", TextBox6.Text); da.InsertCommand.Parameters.AddWithValue("@acno", TextBox7.Text); da.InsertCommand.Parameters.AddWithValue("@bank", TextBox8.Text);

da.InsertCommand.Parameters.AddWithValue("@pass", TextBox9.Text); da.InsertCommand.Parameters.AddWithValue("@utype", DropDownList7.Text); int i = da.InsertCommand.ExecuteNonQuery(); if (i > 0) { Label1.Visible = true; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; TextBox5.Text = ""; TextBox6.Text = ""; TextBox7.Text = ""; TextBox8.Text = ""; TextBox9.Text = ""; } else { Label1.Visible = false; } con.Close(); }

(51)

empdetail.aspx

CodeFile="empdetail.aspx.cs"Inherits="Default3" %>

<h2style="border: thin solid #800080; width:100%; text-align:center">

<fontcolor="#a44976">Claim Detail</font></h2>

<asp:PanelID="Panel1"runat="server"ScrollBars="Vertical"

Width="800px" >

<asp:GridViewID="GridView1"runat="server"AllowPaging="True"

AutoGenerateSelectButton="True"Width="123px" EnableTheming="False"Height="225px"

AllowSorting="True"BackColor="White"BorderColor="#CC9966"BorderStyle="None"

BorderWidth="1px"CellPadding="4"GridLines="Vertical"PageSize="5"

onrowcancelingedit="GridView1_RowCancelingEdit"

onrowupdated="GridView1_RowUpdated"onrowupdating="GridView1_RowUpdating"

onselectedindexchanged="GridView1_SelectedIndexChanged"

DataKeyNames="empid"DataMember="empid"

onpageindexchanging="GridView1_PageIndexChanging"

onrowediting="GridView1_RowEditing"onsorting="GridView1_Sorting"

onrowdeleted="GridView1_RowDeleted"onrowdeleting="GridView1_RowDeleting"

EnablePersistedSelection="True">

<FooterStyleBackColor="#FFFFCC"ForeColor="#330099"/>

<HeaderStyleBackColor="#990000"Font-Bold="True"ForeColor="#FFFFCC"/>

<PagerStyleBackColor="#FFFFCC"ForeColor="#330099"HorizontalAlign="Center"/> <RowStyleBackColor="White"ForeColor="#330099"/>

<SelectedRowStyleBackColor="#FFCC66"Font-Bold="True"ForeColor="#663399"/>

<SortedAscendingCellStyleBackColor="#FEFCEB"/>

(52)

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;

publicpartialclassDefault3 : System.Web.UI.Page

{

SqlConnection con; SqlDataAdapter da;

DataSet ds=newDataSet();

protectedvoid Page_Load(object sender, EventArgs e) {

con = newSqlConnection(db.connection);

da = newSqlDataAdapter("SELECT * FROM REGISTRATION", con); da.Fill(ds);

GridView1.DataSource = ds.Tables[0]; GridView1.DataBind();

}

protectedvoid GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) {

GridView1.EditIndex = -1; GridView1.DataBind(); }

protectedvoid GridView1_SelectedIndexChanged(object sender, EventArgs e) {

}

protectedvoid GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e) {

}

protectedvoid GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {

int id = Convert.ToInt32( GridView1.Rows[e.RowIndex].Cells[1].Text);

string name = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text; string dept = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text; string desig = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text; string Emailid = ((TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text; string dob = ((TextBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[0]).Text; string address = ((TextBox)GridView1.Rows[e.RowIndex].Cells[7].Controls[0]).Text; string city = ((TextBox)GridView1.Rows[e.RowIndex].Cells[8].Controls[0]).Text;

(53)

ACNO='"+ acno +"',BANK='"+bank +"', JDATE='"+ jdate+"', PASSWORD='"+ passwored +"', UTYPE='"+ utype+"' WHERE EMPID='"+ id+"' ",con);

int j= cmd.ExecuteNonQuery(); Response.Write(id.ToString()+name); // GridView1.EditIndex = -1; con.Close(); GridView1.EditIndex = -1; GridView1.DataBind(); }

protectedvoid GridView1_Sorting(object sender, GridViewSortEventArgs e) {

DataView dv = newDataView(ds.Tables[0]); dv.Sort = e.SortExpression;

GridView1.DataSource = dv; GridView1.DataBind(); }

protectedvoid GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) {

GridView1.PageIndex = e.NewPageIndex; GridView1.DataBind();

}

protectedvoid GridView1_RowEditing(object sender, GridViewEditEventArgs e) {

}

protectedvoid GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {

SqlCommand cmd = newSqlCommand("DELETE FROM REGISTRATION WHERE EMPID=" + GridView1.Rows[e.RowIndex].Cells[1].Text + "", con);

con.Open();

cmd.ExecuteNonQuery(); con.Close();

da = newSqlDataAdapter("SELECT * FROM REGISTRATION", con); da.Fill(ds);

GridView1.DataSource = ds.Tables[0]; GridView1.DataBind();

}

protectedvoid GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e) { GridView1.DeleteRow(1); GridView1.DataBind(); } }

(54)

Uhome.aspx

<%@PageTitle=""Language="C#"MasterPageFile="~/userMaster.master"

AutoEventWireup="true"CodeFile="uhome.aspx.cs"Inherits="uhome" %>

<h2style="border: thin solid #800080; width:100%; text-align:center"> <fontcolor="#a44976"> Welcome To B.S.A.C.E.T, Mathura</font></h2>

<asp:LinkButtonID="LinkButton2"runat="server"ForeColor="#FF5050"

Visible="False"PostBackUrl="~/ustatus.aspx">LinkButton</asp:LinkButton>

<br/>

<fieldsetstyle="width:90%">

<legend>Control Panel</legend>

<tableclass="style1">

<tr>

<td>

<ahref="uclaim.aspx"> <asp:ImageID="Image1"runat="server"

ImageUrl="~/image/serviceprovider_icon.jpg"ToolTip="Application"/>

</a>

</td>

<td>

<ahref="ustatus.aspx">

<asp:ImageID="Image2"runat="server"ImageUrl="~/image/images (2).jpg"ToolTip="View Status"/>

</a>

(55)

aboutus.aspx

AutoEventWireup="true"CodeFile="aboutus.aspx.cs"Inherits="aboutus" %>

Web Based Claims Processing System (WCPS) which is web based so that the employee can fill the form online and submit it so that the form is sent to CPD through Internet.ABC is a company which is having employee strength of at least 1000. All the employees are provided medical

reimbursement facility which means that the expenditure incurred by the employee for treatment is reimbursed by the company. For reimbursement, the employee needs to fill in a form detailing the treatment undertaken which includes the name & cost of medicines, laboratory tests, surgery. The form is duly signed by the employee and it will be sent to the concerned Claims Processing

Department (CPD) by messenger for processing. CPD will process it and the order regarding the reimbursement is sent to the Cash counter (CC) where in the employee can come and receive the reimbursement amount. </asp:Content>

aboutus.aspx.cs

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

(56)

Uclaim.aspx

AutoEventWireup="true"CodeFile="uclaim.aspx.cs"Inherits="uclaim" %>

<asp:ContentID="Content1"ContentPlaceHolderID="head"Runat="Server">

.style2 { width: 1333px; } .style5 { width: 153px; height: 23px; font-size: smaller; } .style6 { width: 186px; margin-left: 80px; height: 23px; } .style7 { height: 23px; } .style3

(57)

</style> </asp:Content>

<h2style="border: thin solid #800080; width:100%; text-align:center"> <fontcolor="#a44976"> Application For Medical Facility</font></h2>

<p>

<br/>

<fieldsetstyle="width:320px; vertical-align:middle; margin-left:100px ">

<legend>Application </legend>

<tableclass="style2">

<tr>

<tdclass="style5">

Empid</td>

<tdclass="style6">

Enabled="False"></asp:TextBox>

</td> <tdclass="style7">  </td> </tr> <tr> <tdclass="style3"> Name</td> <tdclass="style4">

</td> <td>  </td> </tr> <tr> <tdclass="style3"> Department</td> <tdclass="style4">

</td> <td>  </td> </tr> <tr> <tdclass="style3"> Designation</td> <tdclass="style4">

</td>

<td>

 </td>

(58)

ControlToValidate="TextBox3"ErrorMessage="Enter The Patient Name"

</td> </tr> <tr> <tdclass="style3"> Claim Date</td> <tdclass="style4">

<asp:ListItem>DD</asp:ListItem>

</asp:DropDownList>

<asp:ListItem>MM</asp:ListItem>

(59)

<asp:ListItem>YYYY</asp:ListItem>

</asp:DropDownList>

</td>

<td>

</td> </tr> <tr> <tdclass="style3"> Relation</td> <tdclass="style4">

</td>

<td>

</td> </tr> <tr> <tdclass="style3"> Hospital Name</td> <tdclass="style4">

</td>

<td>

</td> </tr> <tr> <tdclass="style3"> Type</td> <tdclass="style4">

Width="160px">

<asp:ListItem>Select Type</asp:ListItem>

<asp:ListItem>Surgery</asp:ListItem>

<asp:ListItem>Medicine</asp:ListItem>

<asp:ListItem>Fracture</asp:ListItem>

</asp:DropDownList>

</td>

<td>

Web Based Claim Processing System

A

PRACTICAL TRAINING REPORT

ON

Web Claim Processing System

SUBMITTED IN PARTIAL FULFILLMENT OF THE REQUIREMENT

FOR

COMPLETION OF DEGREE

MASTER OF COMPUTER APPLICATION

BY

Name: Amit Kumar Gautam

Roll No-1006514003

ACKNOWLEDGEMENT

Keep away from people who try to belittle your ambitions. Small

people always do that, but the really great make you feel that you too,

can become great.

I take this opportunity to express my sincere thanks and deep

gratitude to all those people who extended their wholehearted co-operation

and have helped me in completing this project successfully.

First of all, I would like to thank Mr. Nitin, Director (ZXXXX) for

creating opportunities to undertake me in the esteemed organization.

Special thanks to Mr.Ranjan Project Manager for all the help and

guidance extended to me by him in every stage during my training. His

inspiring suggestions and timely guidance enabled me to perceive the various

aspects of the project in a new light.

I am highly indebted and graceful to xxxx(Project Leader) and

xxxx (Team Leader) for Their strict supervision, constant encouragement,

inspiration and guidance, which ensure the worthiness of my work. Working

under them was an enrich experience. I express my sincere thanks to my

senior of software development department for their encouragement and

valuable suggestion

I would also thank to my Mr.-Pradeep Maheswari, HOD (MCA

Dept.) & my internal project guide Mr. Ranjan who guided me a lot in

completing this project.I would also like to thank my parents & project mate

for guiding and encouraging me throughout the duration of the project.

DECLARATION

I, Amit Kumar Gautam-, hereby declare that the report of the project

entitled “XXXXXX” has not presented as a part of any other academic work to

get my degree or certificate except B.S.A COLEEGE OF ENGINEERING AND

TECHNOLOGY,MATHURA for the fulfillment of the requirements for the

degree of Master of Computer Application.

Name: Amit Kumar

Gautam

CERTIFICATE OF ORIGINALITY

This is to certify that the project entitled xxxx being submitted for the

partial fulfillment of degree of MCA, session 2010-2013, is a record of work

carried out by Name under my guidance and supervision.

This is to further certify that the student has attended the Multisoft

Systems, NOIDA for the 6 months after the fifth semester theory exams. His

work has been satisfactory and commendable.

I wish him success in his life.

Date:

Place:

CERTIFICATE

This is to certify that Name, a bonefide student of MCA of batch 2010has

completed the Project titled “Web Claim Processing System” being

submitted for the partial fulfillment of degree of MCA.

This is to further certify that the student has attended the College name

. and XXXXXXX, NOIDA for the 6 months after the fifth semester theory

exams. His work has been satisfactory and commendable.

Date:

Mr. ---

HOD MCA Department

Place:

College name

TABLE OF CONTENTS

1.1 Purpose...8

1.2 Objective...9

1.3 Project Scope...10

1.4 Technologies...10

1.4.1 Operating Environment...10

...10

1.4.2 Deployment Environment...11

1.4.3 Development Tools and Technologies...12

1.4.4 Development Environment...15

2.1 User Characteristics...16

2.1.1 Employee...16

2.1.2 CPD - Claims Processing Department ...16

2. 2.Assumptions...16

3. 1.Systern features...17