Process Flow Chart - PRELIMINARY DESIGN - Web Based Claim Processing System

4. PRELIMINARY DESIGN

4.4 Process Flow Chart

Start

Modul e Selecti

CPD on Employee

View Pending Claim Status

Approve / Reject Claim

Manage Employee

Apply New Claim

View Status

Stop

4.5 Entity Data Model Diagram 1

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

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

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.

• To optimize the query which is embedded in the system.

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

Main.aspx

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

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

.style1 {

width: 26%;

} .style2 {

width: 157px;

} .style3 {

width: 1291px;

height: 159px;

} </style>

</head>

</tr>

</table>

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

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

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

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

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

<td>

<asp:TextBox ID="TextBox1" runat="server" ontextchanged="TextBox1_TextChanged"

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

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

<td>

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>

<marquee direction= "left" >Amit Gautam, Mca 2013</marquee>

</div>

public partial class Main : System.Web.UI.Page

{ protected void Page_Load(object sender, EventArgs e) {

}

protected void TextBox1_TextChanged(object sender, EventArgs e) {

}

try

Home.aspx

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

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

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

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

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

<asp:LinkButton ID="LinkButton2" runat="server" ForeColor="#FF6600"

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

<legend>Control Panel</legend>

<tr>

 <asp:Image ID="Image1" runat="server" Height="205px"

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

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

</a>

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

con.Close();

if (i > 0) {

LinkButton2.Visible = true;

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

} } }

Reg.aspx

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

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

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

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

.style2 {

width: 600px;

height:500px;

}

.style4 {

width: 276px;

margin-left: 80px;

}

.style5 {

width: 1284px;

height: 24px;

} .style7

height: 9px;

margin-left: 80px;

<font color="#a44976"> Employee Registration</font></h2>

<asp:Label ID="Label1" runat="server" ForeColor="#FF3300"

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

<br />

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

<asp:DropDownList ID="DropDownList1" runat="server" Height="25px"

Width="160px">

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

ControlToValidate="DropDownList1" ErrorMessage="RequiredFieldValidator"

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

<asp:DropDownList ID="DropDownList2" runat="server" Height="25px"

Width="160px">

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

ControlToValidate="DropDownList2" ErrorMessage="RequiredFieldValidator"

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

<asp:DropDownList ID="DropDownList7" runat="server" Height="25px"

<tr>

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"

ControlToValidate="TextBox3" ErrorMessage="RegularExpressionValidator"

ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+

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

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

<asp:ListItem>06</asp:ListItem>

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

ControlToValidate="DropDownList5" ErrorMessage="RequiredFieldValidator"

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

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

ControlToValidate="TextBox4" ErrorMessage="RequiredFieldValidator"

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

ControlToValidate="TextBox5" ErrorMessage="RequiredFieldValidator"

<asp:DropDownList ID="DropDownList6" runat="server" Height="25px"

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

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

ControlToValidate="DropDownList6" ErrorMessage="RequiredFieldValidator"

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

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

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

</td>

<td>

<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server"

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

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

</td>

<td>

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

ControlToValidate="TextBox8" ErrorMessage="RequiredFieldValidator"

public partial class Reg : System.Web.UI.Page {

SqlConnection con =new SqlConnection(db.connection);

// SqlCommandBuilder cb;

//DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter();

protected void Button1_Click(object sender, EventArgs e) {

da.InsertCommand = new SqlCommand("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();

empdetail.aspx

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

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

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

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

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

<asp:Panel ID="Panel1" runat="server" ScrollBars="Vertical"

Width="800px" >

<asp:GridView ID="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">

using System.Collections.Generic;

public partial class Default3 : System.Web.UI.Page {

SqlConnection con;

SqlDataAdapter da;

DataSet ds=new DataSet();

protected void Page_Load(object sender, EventArgs e) {

con = new SqlConnection(db.connection);

da = new SqlDataAdapter("SELECT * FROM REGISTRATION", con);

da.Fill(ds);

GridView1.DataSource = ds.Tables[0];

GridView1.DataBind();

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) {

GridView1.EditIndex = -1;

GridView1.DataBind();

}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) {

}

protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e) {

}

protected void 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;

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;

protected void GridView1_Sorting(object sender, GridViewSortEventArgs e) {

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) {

GridView1.PageIndex = e.NewPageIndex;

GridView1.DataBind();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {

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

con.Open();

cmd.ExecuteNonQuery();

con.Close();

da = new SqlDataAdapter("SELECT * FROM REGISTRATION", con);

da.Fill(ds);

GridView1.DataSource = ds.Tables[0];

GridView1.DataBind();

}

protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e) {

Uhome.aspx

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

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

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

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

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

<asp:LinkButton ID="LinkButton2" runat="server" ForeColor="#FF5050"

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

<br />

<legend>Control Panel</legend>

<tr>

<td>

<asp:Image ID="Image1" runat="server"

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

</a>

</td>

<td>

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

</a>

</td>

aboutus.aspx

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

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

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

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

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;

public partial class aboutus : System.Web.UI.Page

Uclaim.aspx

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

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

<asp:Content ID="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

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<font color="#a44976"> Application For Medical Facility</font></h2>

<p>

<br />

<legend>Application </legend>

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

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

</asp:DropDownList>

</td>

<td>

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

ControlToValidate="DropDownList5" ErrorMessage="RequiredFieldValidator"

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

ControlToValidate="DropDownList6" ErrorMessage="RequiredFieldValidator"

</td>

public partial class uclaim : System.Web.UI.Page {

TextBox9.Text = Session["desig"].ToString();

protected void Button1_Click(object sender, EventArgs e) {

if (Convert.ToInt32(TextBox6.Text) < u) {

con.Open();

cmd.InsertCommand = new SqlCommand("uapp", con);

cmd.InsertCommand.CommandType = CommandType.StoredProcedure;

cmd.InsertCommand.Parameters.AddWithValue("@empid", TextBox1.Text);

cmd.InsertCommand.Parameters.AddWithValue("@pname", TextBox3.Text);

cmd.InsertCommand.Parameters.AddWithValue("@relation", TextBox4.Text);

cmd.InsertCommand.Parameters.AddWithValue("@hospital", TextBox5.Text);

cmd.InsertCommand.Parameters.AddWithValue("@apptype", DropDownList6.Text);

cmd.InsertCommand.Parameters.AddWithValue("@description", TextBox7.Text);

cmd.InsertCommand.Parameters.AddWithValue("@camount", TextBox6.Text);

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

cmd.InsertCommand.Parameters.AddWithValue("@status", "Pending");

// cmd.InsertCommand.Parameters.AddWithValue("@seen", "");

// cmd.InsertCommand.Parameters.AddWithValue("@aprove", "");

cmd.InsertCommand.Parameters.AddWithValue("@amount", "");

cmd.InsertCommand.Parameters.AddWithValue("@adate", "");

cmd.InsertCommand.Parameters.AddWithValue("@apdescriptiont", "");

cmd.InsertCommand.Parameters.AddWithValue("@apseen", "");

cmd.InsertCommand.ExecuteNonQuery();

con.Close();

Response.Write("<script>javascript:alert('Your Claim Is Successfully Submited')</script>");

Server.Transfer("uhome.aspx");

} else {

Response.Write("<script>javascript:alert('Your Maximum Limit Is '+"+ u +")</script>");}

Uchangepass.aspx

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

AutoEventWireup="true" CodeFile="Uchangepass.aspx.cs" Inherits="Default2" %>

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

.style2 {

width: 157px;

} .style3 {

width: 1291px;

} .style4 {

width: 1291px;

height: 1px;

} .style5 {

height: 1px;

</tr>

public partial class Default2 : System.Web.UI.Page {

SqlConnection con;

SqlCommand cmd;

int id;

protected void Page_Load(object sender, EventArgs e) {

protected void Button1_Click(object sender, EventArgs e) {

con.Open();

cmd = new SqlCommand("UPDATE REGISTRATION SET PASSWORD='" + TextBox2.Text + "' WHERE EMPID=" + id + " AND PASSWORD='" + TextBox1.Text + "'", con);

int j = cmd.ExecuteNonQuery();

Default.aspx

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

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

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

.style2 {

width: 600px;

} .style5 {

width: 153px;

height: 23px;

} .style6 {

width: 186px;

margin-left: 80px;

height: 23px;

} .style7

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<font color="#a44976"> Aprove/Reject Apllication</font></h2>

<legend> Aprove/Reject Claim </legend>

<td class="style7" rowspan="9" style=" vertical-align:top"><font color="#9b528a"

size="5px" > Claim Limit</font>

Claim Date</td>

<td>

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

ControlToValidate="TextBox6" ErrorMessage="Can Not Be

public partial class _Default : System.Web.UI.Page {

SqlConnection con;

SqlCommand cmd;

cmd = new SqlCommand("SELECT

REGISTRATION.EMPNAME,REGISTRATION.DEPARTMENT,REGISTRATION.DESIGNATION, CLAIM.EMPID, CLAIM.PNAME,CLAIM.RELATION,CLAIM.HOSPITAL,CLAIM.APPTYPE,CLAIM.CLAIMAMOUNT,CLAIM.CDAT E FROM REGISTRATION,CLAIM WHERE REGISTRATION.EMPID=CLAIM.EMPID AND CLAIM.APPID=" + Session["appid"].ToString() + "", con);

Dictionary<string,int> lm=l.climit();

ListBox1.Items.Add("Designation"+" "+ "Upto");

foreach(KeyValuePair<string,int> kv in lm) {

ListBox1.Items.Add(kv.Key + " " + kv.Value);

} }

protected void Button1_Click(object sender, EventArgs e) {

if (s == null) {

Response.Write(" <script>javascript:alert('Please Cheack The RadioButton') </script> ");

} else {

cmd = new SqlCommand("UPDATE CLAIM SET STATUS='"+s

s = RadioButton1.Text;

}

protected void RadioButton2_CheckedChanged(object sender, EventArgs e) {

s = RadioButton2.Text;

TextBox6.Text = "0";

TextBox6.Enabled = false;

} }

ustatus.aspx

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

AutoEventWireup="true" CodeFile="ustatus.aspx.cs" Inherits="Default2" %>

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

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

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

<asp:DropDownList ID="DropDownList1" runat="server" Height="28px"

Width="169px" AutoPostBack="True"

onselectedindexchanged="DropDownList1_SelectedIndexChanged">

<asp:ListItem>All</asp:ListItem>

<asp:ListItem>Pending</asp:ListItem>

<asp:ListItem>Aproved</asp:ListItem>

<asp:ListItem>Reject</asp:ListItem>

</asp:DropDownList>

<br />

<asp:GridView ID="GridView1" runat="server">

</asp:GridView>

<br />

</asp:Content>

ustatus.aspx.cs

using System;

using System.Collections.Generic;

using System.Linq;

con = new SqlConnection(db.connection);

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) {

Response.Write(DropDownList1.Text);

break;

} } } }

contactus.aspx

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

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

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

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<p>

Project Team Member</center></p>

<p>

Name: Amit Kumar Gautam</p>

<p>

EmailId: <a

href="mailto:[email protected]">[email protected]</a></p>

<p>

Venue: Near Railway Crossing, BARHAN, Distt-AGRA</p>

<p>

Mob_No- 7417853858</p>

</asp:Content>

aprove.aspx

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

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

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

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<font color="#a44976">Employee Detail</font></h2>

<asp:DropDownList ID="DropDownList1" runat="server" Height="28px"

Width="169px" AutoPostBack="True"

onselectedindexchanged="DropDownList1_SelectedIndexChanged">

<asp:ListItem>All</asp:ListItem>

<asp:ListItem>Pending</asp:ListItem>

<asp:ListItem Value="Approved">Aproved</asp:ListItem>

<asp:ListItem>Reject</asp:ListItem>

</asp:DropDownList>

<asp:GridView ID="GridView1" runat="server" AutoGenerateEditButton="True"

DataKeyNames="appid" DataMember="appid" onrowediting="GridView1_RowEditing">

In document Web Based Claim Processing System (Page 29-100)