Live Project - 4.  Web Based Claims Processing System (WCPS)

Type : Web, Technology : ASP.Net, C#, SQL Server; Credit : AJProfessionals

Who can use this project ?

• Submission of semester and final year college student for academic purpose.

• Student who are submitting their mini, major project for BE, BCA, BSC-IT, BIT, MBA, MCA, MS, this project is well commented, ready made project documentation available for submission.

• Who want to learn asp and database programming in visual basic script.

• Student of Mumbai, Delhi, Calcutta, Chennai, Pune, Bangalore University of India and other international university.

• IGNOU, SMU, DOEACC student.

• How to develop web application by using Microsoft ASP.Net (C#) Technology.

• To learn ASP.Net, C#, ADO.Net, SQL Server programming.

• How to host web application in IIS - Internet Information Server.
   

Abstract
P2P is a company which is having an employee strength of at least 1500. 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 to the account of the employee based on the mail.
 

Solution
After analysis the requirement we decide that we need to create following web pages

• Home Page
• Login Page
• My Account
• Apply Claim
• View Claim Status
• Add new employee
• Employee List
• Edit Employee Details
• Approve/Reject Claim
• Change Password
• Logout

Deployment Environment

• Database Server
  OS – Win 2003 Enterprise Server
  MS Access
  HDD – Min 10 GB, Recommended 25 GB
  RAM – Min 1 GB, Recommended 2 GB
  Processor - Pentium Dual Xenon Processor
   

• Application Server
  OS – Win 2003 Enterprise Server
  IIS – Internet Information Server
  .NET Framework 2.0
  HDD – Min 5 GB, Recommended 10 GB
  RAM – Min 1 GB, Recommended 2 GB
  Processor - Pentium Dual Xenon Processor
   

• Workstation: The online registration system web application will operate with the following Web Browsers: Microsoft Internet Explorer version 5.0, 6.0. 7.0.
   

Development Tools and Technologies

• ASP.Net and C#
  -Powerful, Flexible, Simplified Data Access
  -Direct Access to the Windows Back office Server Platform.
  -Full Object-Oriented Constructs
   

• SQL Server
  -Integration with Windows Back office servers
  -Integration with Microsoft .NET Enterprise Servers.
  -Scalability, Reliability, Automating Tasks, Centralized Management

Download the project documentation, source code, database and report files.

For any query and help regarding this project visit.
http://www.programmer2programmer.net/forums/forum_main.aspx?forum_id=6

Click here to view the online demo of the application.