Patron

SYNOPSIS OVERVIEW: Patron preservation system is the third party Administrator (TPA) would tie up with the organizations and all the hospitalization services would be on cash less basis for an employee of the organization. The third party administrator is a specialized health service provider rendering a variety of services like networking with hospitals, arranging for hospitalization and claim processing and settlement to an employee of an organization. The employee has full freedom to choose hospitals from the empanelled network and utilize the service as per choice. During the emergency period employee can use the medical card. At the any time of admission, treatment is provided by hospitals without payment. SCOPE:

•

Maintain database of all TPA users

•

Issue of identity card to all TPA users

•

Check various investigations

•

Provide Cashless service

•

Search the hospitals near to us

•

Provide reimbursement method

INTRODUCTION Patron preservation suite for health care is a new system introduced mainly to provide employees of certain organization the safe and risk free treatment for their serious illness. A to the hospital, and as soon as possible the TPA will indicate the appointment for the treatment to the employee. Incase of emergency treatment the employee is TPA who just has tie-ups with many organizations and hospitals does this. Each and every employee will be provide a separate ID and using that their treatment details and all other details are secured. Main highlight of this project is that each and every employee would be provided a Medical Card, which has to submitted when asked. This project supports two kinds of treatments like Emergencies and normal treatment. In case of normal treatment the employee has to fill in a request form and have to send to the TPA, which would be forwarded allowed to get treated first and the he can claim the amount from the TPA by filling in the necessary requisition form.

1.1 ORGANIZATION PROFILE Leading Software Technologies (here after called as LST) started in 2000 located at the Temple Tower, Chennai, which is a very familiar place for business people and offices. Since its inception, LST is training students as well as Business organizations on software and solution provider with a vision to develop Enterprise information System (EIS) with a specific approach on the organization focus and needs. Started with a professional approach to problem identification, analysis and solving, the team has also widened the scope of activities from web-based projects to smart card solutions for enterprises. A productive application development environment is created to raise the level of performance of each individual to meet the demand of constant customer requirement.

Area of service •

Provides Software solutions to the organizations.

•

Maintaining and monitoring the existing system in an organization.

•

LST is also into training the professional students and working professionals on latest Technologies and in inculcating the professional careers. A structured approach for software development life cycle (SDLC) has been

adopted to ensure a streamlined analysis of a problem, to understand and deliver in line with the customer requirements. Elements of structured system analysis including: Requirement study, system analysis and design, software development quality assurance, documentation enhancement and system maintenance are strictly followed to achieve the immediate and long term business objectives of the client.

Team Structure The hierarchy of our team is like this, headed by Project Manager and under him Senior Programmer Analyst, Jr. Analyst, Programmer Assistant and Trainer in Lab,

Software Professionals and etc. Everyone has their own responsibilities of their work and dedicated to train the people to achieve the goals on time. Ultimately our customer satisfaction leads us to our business success.

Customer Support Besides Software development, we also involve in Customer Support that enhances the quality of technical support to ensure basic technical support. Post implementation maintenance support is provided to ensure smooth operation of the customer system. Suggestion for continuous improvement of the system is provided to upgrade the latest emerging technologies.

Training Techniques Using the training division as one of its basis, LST has very strong manpower management capability. The students or professionals who undergo training are carefully screened and their abilities are tested before they are added to the database.

Infrastructure In addition to the above, LST has its own sourcing unit with all facilities like individual care, computer with LAN and network connection, Lab etc., with professional guidance. LST remains in constant touch with the companies and inducts regular appraisals and continues to monitor the personnel performance. Regular interactions with the HR department, team leaders and project leaders take place to monitor their needs and the performance.

Leading Company Services LST specializes in providing technology experts to fill key roles that make a difference on your critical software projects. LST consultants specialize in advanced technologies in the areas of Unified Process and Unified Modeling Language, Usability,

Strategy

and

Management,

Process,

Requirements,

Programming, Quality Assurance and Tools. LST consultants are:

Architecture,

•

Highest quality, with skills and expertise equivalent the best and brightest in the industry

•

Lower cost than consultants provided through higher-overhead operations

•

Validated through a rigorous qualification process

•

Effective, providing big results in a short timeframes

•

Experienced in participation in multiple large and/or complex projects

•

Knowledgeable and experienced with latest technologies and techniques

•

Consistent in their approach, documentation and mentoring

Available to travel worldwide

M/s Leading Software Technologies Ground Floor, Temple Tower, 672, Anna Salai, Nandanam, Chennai – 600 035 India Phone : +91 44 52131218, +91 9840491074, +91 94441 36757 Email : [email protected], [email protected] URL

: www.lstpark.com

PROJECT DESCRIPTION Patron preservation suite for health care is a new system introduced mainly to provide employees of certain organization, the safe and risk free treatment for their serious illness. A TPA who just has tie-ups with many organizations and hospitals does this. This project supports two kinds of treatments like Emergencies and normal treatment. In case of normal treatment the employee has to fill in a request form and have to send to the TPA, which would be forwarded to the hospital, and as soon as possible the TPA will indicate the appointment for the treatment to the employee. Incase of emergency treatment the employee is allowed to get treatment first and the he can claim the amount from the TPA by filling in the necessary requisition form. MODULE DESCRIPTION 1. TPA Function 2. HR 3. Employee 4. Hospital 5. Banking 1. TPA: The TPA plays vital role.TPA has tie-up with number of hospital and organization. It maintains the hospital details in order to request for the treatment for the registered employee as well as it maintains organization details to provide medical treatment for the employees. It maintains the registered employee details. It also has contact with the

financial organization to transact money for the bill submitted by the hospital. The TPA provide med claim card to the employees to use in the case of emergency.

2. Organization Details: The new organization has to register to the TPA in order to tie-up with TPA and get medical facility for their employees. It maintains the details of the employees and also provided it to TPA.TPA will register the employee details according to the information given by the organization. Based on their designation medical treatment is provided for the employee. After the treatment, treatment details maintain by the organization along with the employee detail. 3. Employee Details: The employee’s of the tie-up organization request to the TPA for the medical treatment. Employees requisition to the TPA either pre request or post request, which means treatment, is after the request to the TPA or treatment is before the request to TPA. Employee has med iclaim card, which has been used during emergency period .The TPA will verify the details of the employee through the employee details maintain by him.

4. Hospital Details: The new Hospital has to register to the TPA in order to tie up with the TPA.Hospital will receive the employee’s request through TPA for the treatment before four days in advance. In case of emergency the hospitals will provide treatment to the employees using the medi claim card issued by TPA. After the treatment the hospital sends the bill to the TPA. Then the hospitals receive the confirmation letter from the TPA through the organization for the settlement of bills. 5. Banking Details:

The Bank maintains the details of the TPA for the treatment provided for the employees. The TPA settles the money to the hospital through the bank. The bank also maintains the details of the hospitals, which has tie up with the TPA.

SYSTEM ANALYSIS Existing System: •

As of now medical expenses are very high for each and every treatment and many suffer a lot to pay their treatment bill.

•

To support this there was introduced Medical Polices by many policy companies. Many find it very difficult to claim it and use it.

•

As there is no new technologies are introduced in it.

Proposed System: To overcome the existing limitations of the system we found that there is need for improve the existing system .The structure of the proposed system is some different from existing system. •

In proposed system the policy agency has tie-ups with many organizations and hospitals.

•

Employees of the organization can have a safe treatment in required time

•

There is no need to go in search for money for the treatment.

•

All this is taken care by the TPA (Third Party Administrator), who provides the medi claim policies, to all the employees in the tie-up organization.

•

In case of the treatment that had been taken already is also entertained and the cash spent for the same is reimbursed. So, one gets a safe and good treatment in leading hospitals.

•

All the medi claim holders will be provided a Photo ID Card, which would be submitted when asked.

SYSTEM REQUIREMENTS HARDWARE REQUIREMENTS

Processor

: PIV with 2.8GHz

Operating System: Windows 2000 RAM

: 512MB

Hard Disk

: 40GB

Monitor

: 15”

Keyboard

: 107 Keys

Mouse

: Optical Mouse

SOFTWARE REQUIREMENTS Technology

:

ASP.NET 2003

Architecture

:

.Net Framework 1.0

Server

:

IIS 5.0

Coding Tools

: C#. NET, JavaScript

Database

:

MS SQL Server

SOFTWARE DESCRIPTION FRONT-END:

ASP.NET

AN OVERVIEW OF ASP.NET: ABOUT ASP.NET Architecture, server functionality, and development tools. It is one of the famous relational DBMS. MICROSOFT .NET ARCHITECTURE Microsoft describes the .NET framework variously as “a new computing platform designed to simply application development in the highly distributed environment of the internet “and as “an XML web services platform that will enable developers to create programs that transcent device boundaries and fully harness the connectivity of the internet”. Some of the features and innovations that are the underpinnings of the .NET Framework are given below:  The Common Language RunTime (CLR)  Managed execution  The Common Type System (CTS)  Cross Language Interoperability  The .NET Framework Class Library  Namespaces

 Assemblies  Application  Security  Deploying And Configuring .NET Application  Web Services  Windows Forms ASP.NET The features listed above had made the .NET very famous architecture and today plenty of web applications are being developed in this platform. We can see about three important components of this framework, which are used in this project. They are  VB.NET  ASP.NET  ADO.NET MICROSOFT ASP.NET ASP.NET is the latest version of Microsoft’s Active Server Pages technology (ASP).

WEB FORMS Web Forms are an ASP.NET technology that uses to create programmable web pages. Web Forms render themselves as browser compatible HTML and Script, which allows any browser on any platform to view this page. Using web forms, you create web pages by dragging and dropping controls onto the designer and then adding code. . NET FRAMEWORK

 The .NET Framework is a common environment for building, deploying and running web application and web services.

 The .NET Framework contains a common language runtime and common class libraries-like ADO.NET, ASP.NET, Windows Forms-to provide advanced standard services that can be integrated into a variety of computer systems.  The .NET Framework provides a feature-rich application environment, simplified development and easy integration between a numbers of different development languages.  Currently it supports C++, C#, Visual Basic and Jscript  The ASP.NET provides increased performance by running compiled codes. New in ASP.NET  Better Language Support  Programmable Controls  Event-driven programming  XML-based components  User authentication, with accounts and roles  Higher Scalability Language Support  ASP.NET uses the new ADO.NET  ASP.NET supports full Visual Basic, not VB Script.  ASP.NET supports C#(C Sharp) and C++.  ASP.NET supports Jscript. ASP.NET Controls  ASP.NET contains a large set of HTML controls .Almost all HTML elements on a page can be defined as ASP.NET control objects that can be controlled by scripts.

 ASP.NET also contains a new set of object oriented input controls , like programmable list boxes and validations controls  A new data grid control supports sorting, data paging and everything you expect from dataset control.

ASP.NET Components ASP.NET components are heavily based on XML.Like the new AD Rotator that uses XML to store advertisement information and configuration. An ASP.NET page has the extension .aspx. If a browser requests an ASP.NET page, the server processes any executable code in the page,before the result is sent back to the browser. ASP.NET-Server Controls ASP.NET has solved the “spaghetic-code” problem described above with server controls. Server controls are tags that are understood by the server. There are three kinds of server controls:  HTML Server controls-Traditional HTML Tags  Web Server Controls-New ASP.NET Tags  Validation Server control-For Input Validation ASP.NET-HTML Server Controls HTML Server controls are HTML tags understood by the server. HTML elements in ASP.NET files are,by default,treated as text. To make these elements programmable, add a runat =”server” attribute to the HTML element. This attribute indicates that the element should be treated as a server control. The id

attribute is added to identify the server control. The id reference can be used to manipulate the server control at run time. All HTML server controls must be within a

tag with the runat=”server” attribute. The runat=”server” attribute indicates that the form should be processed on the server. It also indicates that the enclosed controls can be accessed by server scripts. ASP.NET-Web Server Controls Web Server controls are special ASP.NET tags understood by the server. Like HTML server controls, web server controls are also created on the server and they require a runat=”server” attribute to work. However, web server controls do not necessarily map to any existing HTML elements and they may represent more complex elements. The Page_ Load Event The Page_Laod event is one of many events that ASP.NET understands.The Page_Load event is triggered when a page loads,and ASP.NET will automatically call the subroutine Page_Load,and execute the code insude it. The Page.IsPostBack Property The Page_Load subroutine runs EVERY time the page is loaded. If you want to execute the code in the page_Load subroutine only the FIRST time the page is loaded, you can use the Page.IsPostBack property. If the Page.IsPostBack property is false, the page is loaded for the first time, if it is true, the page is posted back to the server. ASP.NET Validation Controls

•

Required field Validator- Makes sure that user enters data in the associated data entry control.

•

Compare Validator- Uses comparison operators to compare user-entered data to a constant value or the value in another data entry control.

•

Range Validator- Makes sure that user enters data in between the given lower and upper boundaries (Range).

•

Regular Expression Validator – Makes sure that the user-entered data matches a regular expression pattern.

•

Custom Validator- Makes sure that user-entered data passes validation criteria that you set yourself.

Data Grids in ASP.NET Web Server Data Grids are much similar to windows form data grids. But there are some differences. It uses HTML table to display data. Different column types can be used are as follows:Bound Column shows a column bound to a field in a data source Button Column shows a button for each item in the column. Hyperlink Columns shows a hyperlink for each column Auto Generate Columns true which means that for each field a column will be created. Web Applications  ASP.NET defines a Web application as the “Sum of all files, pages, handlers, modules, and executable code that can be invoked or run in the scope of a given virtual directory on a web application server”  Distributed Applications

Presentation

Middle Tier Internet

Web Form

Database

Web Service

MICROSOFT ADO.NET A data provider in the .NET framework enables you to connect to a data source in order to retrieve and modify data from the data source. A .NET data provider also serves as a bridge between a data source and an ADO.NET Dataset. The following table lists the .NET Data Providers that are included in the .NET Framework. . NET data Provider

Description

SQL Server.NET Data Provider

For crosoftSQL Server 7.0 or later

OLE DB.NET Data Provider

For data sources exposed using OLE DB

Most database systems currently available are already accessible by ADO.NET through an existing OLE DB provider and the OLE DB.NET Data Provider. In addition, you can expose many data sources directly using XML. ADO.NET also provides you with a minimal set of interfaces to enable you to implement your own .NET Data Provider. This section discusses the interfaces and classes you would use, and how to use them. There are a number of advantages to implementing a custom .NET Data Provider, including:

 Simplified data access architecture, often with better maintainability and improved performance.  The ability to directly expose provider-specific behavior to consumers.  A specific interface for your consumers to access your data source between the .NET Framework. The functionality provided by a .NET data provider can be divided into the following categories:

 The complete form of a .NET data provider supports both interaction with the Dataset and connected data access using connections, commands, transactions and so on.  When implementing a .NET data provider,it is important that you define the following: •

Which interfaces and classes you will implement.

•

What the naming convention for your classes will be.

•

Which constructors, methods, properties,and events you will implement.

•

What namespace you will use for your .NET data provider.

•

Which DDL will contain your .NET data provider.

DATABASE REFERENCES The database project now includes the concept of database reference. A database reference is simply a pointer to a database. Whenever you create a database

Reference, the database project immediately checks the list of database connections in Server Explorer and if there is no connection to that database, it creates such a connection for you automatically. A database reference differs from a database connection, because a reference merely a pointer; it does not allow you to enumerate the contents of the database. A database connection, on the other hand, lets you inspect the contents of the database. A database reference is persisted with the database project. When you save a project to disk, the reference is saved.

BACK END:

SQL SERVER 2000

SQL SERVER INTRODUCTION SQL stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter. A relational database system contains one or more objects called tables. The data or information for the database are stored in these tables. Tables are uniquely identified by their names and are comprised of columns and rows. Columns contain the column name, data type, and any other attributes for the column. Rows contain the records or data for the columns

What are constraints? When tables are created, it is common for one or more columns to have constraints associated with them. A constraint is basically a rule associated with a column that the data entered into that column must follow. For example, a "unique" constraint specifies that no two records can have the same value in a particular column. They must all be unique. The other two most popular constraints are "not null" which specifies that a column can't be left blank, and "primary key". A "primary key" constraint defines a unique identification of each record (or row) in a table. Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks.

•

Precompiled execution. SQL Server compiles each stored procedure once and then reutilizes the execution plan. This results in tremendous performance boosts when stored procedures are called repeatedly.

•

Reduced client/server traffic. If network bandwidth is a concern in your environment, you'll be happy to learn that stored procedures can reduce long SQL queries to a single line that is transmitted over the wire.

•

Efficient reuse of code and programming abstraction. Stored procedures can be used by multiple users and client programs. If you utilize them in a planned manner, you'll find the development cycle takes less time.

•

Enhanced security controls. You can grant users permission to execute a stored procedure independently of underlying table permissions.

Stored procedures are extremely similar to the constructs seen in other programming languages. They accept data in the form of input parameters that are specified at execution time. These input parameters (if implemented) are utilized in the execution of a series of statements that produce some result. This result is returned to the calling environment through the use of a recordset, output parameters and a return

code. That may sound like a mouthful, but you'll find that stored procedures are actually quite simple Introduction to Microsoft SQL Server 2000 Microsoft SQL Server 2000 is a full-featured relational database management system (RDBMS) that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. In this article, we'll cover six of the more frequently used tools: Enterprise Manager, Query Analyzer, SQL Profiler, Service Manager, Data Transformation Services and Books Online. Let's take a brief look at each:

Enterprise Manager is the main administrative console for SQL Server installations. It provides you with a graphical "birds-eye" view of all of the SQL Server installations on your network. You can perform high-level administrative functions that affect one or more servers, schedule common maintenance tasks or create and modify the structure of individual databases. Query Analyzer offers a quick and dirty method for performing queries against any of your SQL Server databases. It's a great way to quickly pull information out of a database in response to a user request, test queries before implementing them in other applications, create/modify stored procedures and execute administrative tasks SQL Profiler provides a window into the inner workings of your database. You can monitor many different event types and observe database performance in real time. SQL Profiler allows you to capture and replay system "traces" that log various activities. It's a great tool for optimizing databases with performance issues or troubleshooting particular problems. Service Manager is used to control the MSSQLServer (the main SQL Server process),

MSDTC (Microsoft Distributed Transaction Coordinator) and SQLServerAgent processes. An icon for this service normally resides in the system tray of machines running SQL Server. You can use Service Manager to start, stop or pause any one of the ervices. Data Transformation Services (DTS) provide an extremely flexible method for importing and exporting data between a Microsoft SQL Server installation and a large variety of other formats. The most commonly used DTS application is the "Import and Export Data" wizard found in the SQL Server program group.

MICROSOFT SQL SEVER 7.0 Microsoft SQL sever is a Structured Query Language (SQL) based, client/sever relational database. Each of these terms describes a fundamental part of the architecture of SQL server. Microsoft SQL Server version 7.0 is a significant new release of SQLServer with version 7.0 SQL Server has been redesigned to provide important new server architecture and graphical administration features, while maintaining ANSI and SQL Server 6.x compatibility. Enhancements have also been made to SQL server architecture, server functionality, and development tools. It is one of the very famous relation DBMS.

RELATIONAL DATABASE There are different ways to organize data in a database but relational databases are one of the most effective. Relational database system are an application of mathematical set theory to the problem of effectively organizing data. In a relational database, data is collected into tables (called relations in relational theory). A table represents some class of objects that are important to an organization. For example, a company may have a database with a table for employees, another table for customer, and another for stores. Each table comprises columns and rows (attributes and tuples in relational theory. Each column represents some attribute of the object represented by the table. Microsoft SQL Server simplifies the development, deployment, maintenance, and management of your database applications with its redesigned architecture. SQL Server7.0 supports application that span a broad range of platforms: from personal systems, such as desktop and notebook computers, to high-end symmetric multiprocessing (SMP) servers with 8 to 16 processors, several gigabytes of memory, and a terabyte or more of disk storage.

MICROSOFT SQL SERVER 2000 FEATURES INCLUDE:  Internet Integration The SQL Server 2000 database engine includes integrated XML support. It also has the scalability, availability, and security features required to operate as the data storage component of the largest web sites. The SQL Server 2000 programming model is integrated with the Window DNA architecture for developing web applications, and SQL Server 2000 supports features such as English queries and powerful search capabilities in Web applications.  Scalability and Availability The same database engine can be used across platform ranging from laptop computers running Microsoft Windows 98 through large, multiprocessor servers running Microsoft Windows 2000 Data Center Edition. SQL Server 2000 enterprise Edition supports features such as federated servers, indexed views, and large memory support that allow it to scale to the performance levels required by the largest web sites.  Enterprise-Level Database Features The SQL Server 2000 relational database engine supports the features required to support demanding data processing environments. The database engine protects data integrity while minimizing the overhead of managing thousands of users concurrently modifying the database. SQL Server 2000 distributed queries allow you to reference data from multiple sources as if it were a part of a SQL Server 2000 database, while at the same time, the distributed transaction support protects the integrity of any updates of the distributed data.

Replication allows your to also maintain multiple copies of data, while ensuring that the separate copies remain synchronized. You can replicate a set of data to multiple, mobile, disconnected users, have them work autonomously, and then merge their modification back to the publisher.  Ease of installation, deployment, and use SQL Server 2000 includes a set of administrative and development tools that improve upon the process of installing, deploying, managing, and using SQL Server across several sites. SQL Server 2000 also supports a standards-based programming model integrated with the Windows part of building powerful and scalable systems. These features allow you to rapidly deliver SQL Server applications that customers can implement with a minimum of installation and administrative overhead.  Data Warehousing SQL Server 2000 includes tools for extracting and analyzing summary data for online analytical processing. SQL Server also includes tools for visually designing database and analyzing data using English-based questions. We have plenty more features like creating procedures, triggers, schemas etc. Microsoft SQL Server is one among the most effective database in today’s IT Market. User controls Introduction to Microsoft SQL Server 2000 Microsoft SQL Server 2000 is a full-featured relational database management system (RDBMS) that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. In this article, we'll cover six of the more frequently used tools: Enterprise Manager, Query Analyzer, SQL Profiler, Service Manager, Data Transformation Services and Books Online. Let's take a brief look at each:

Enterprise Manager is the main administrative console for SQL Server installations. It provides you with a graphical "birds-eye" view of all of the SQL Server installations on your network. You can perform high-level administrative functions that affect one or more servers, schedule common maintenance tasks or create and modify the structure of individual databases. Query Analyzer offers a quick and dirty method for performing queries against any of your SQL Server databases. It's a great way to quickly pull information out of a database in response to a user request, test queries before implementing them in other applications, create/modify stored procedures and execute administrative tasks SQL Profiler provides a window into the inner workings of your database. You can monitor many different event types and observe database performance in real time. SQL Profiler allows you to capture and replay system "traces" that log various activities. It's a great tool for optimizing databases with performance issues or troubleshooting particular problems. Service Manager is used to control the MSSQLServer (the main SQL Server process), MSDTC (Microsoft Distributed Transaction Coordinator) and SQLServerAgent processes. An icon for this service normally resides in the system tray of machines running SQL Server. You can use Service Manager to start, stop or pause any one of these services. Data Transformation Services (DTS) provide an extremely flexible method for importing and exporting data between a Microsoft SQL Server installation and a large variety of other formats. The most commonly used DTS application is the "Import and Export Data" wizard found in the SQL Server program group. •

Mobile controls

DATA BINDING

You can bind Web Forms control properties to any data in a data store. This socalled data binding gives you nearly complete control over how data moves to the page and back again to the data store. Page Class When a page is loaded, the ASP.NET runtime generates and instantiates a Page class. This object forms a collection of your separate components (like visual elements and business logic). So all (visual and code) elements are accessible through this object.

MICROSOFT WINDOWS 2000 Windows 2000 is an operating system. An Operating system belongs to a special category of software called system software and performs three major functions:  It acts like the resource manager of the computer i.e. it controls and co-ordinates the

various

resources

of

the

computer

like

Memory (RAM),Storage

Devices(Floppy Disk & Hard Disk Drives), input & output Devices(keyboard, mouse, Monitor, Printer etc.  It acts as an interpreter between other software and hardware.  It manages all our files & folders and allows us to do various file/disk

ABOUT WINDOWS 2000

Incidentally, Window is called so because we can work on several windows at the same time. One of the severe drawbacks of DOS (Disk Operating System) based

programs is that we can work only cumbersome but is also a waste of time. Needless to say this process is not only cumbersome but, several such operations simultaneously without having to exit any other programs. These individual programs runs in separate windows that can be minimized when not in use and maximized in use.

FEATURES OF WINDOWS 2000

 Windows 2000 is considered more user friendly than its counterpart MS DOS. It can support long file names as compared to the eight letter file name supported by DOS. Starting in Windows 2000, files could have names up to 255 characters long.  A Web browser called with Internet Explorer comes as part of Windows 2000.It offers us to access to a vast collection of world knowledge (web is collection of documents) through a worldwide conglomerate of numerous Computer networks.  Windows 2000 has another important feature called Outlook Express. With Outlook Express, we can send and receive electronic mail (e-mail) message. Outlook Express also provides facility for managing these messages.

 Windows 2000 provided Internet collaboration through its yet another feature called Net Meeting. It helps us in working together, sharing information and exchanging files and documents during conference using data, audio, and video.  Windows 2000 provides us with Security Zones feature. This feature helps us to assign security options to websites. Our approval would be a must before opening a file or running a program from the Internet. This feature restricts us to explore different sites by selecting the desired security level.

SYSTEM DESIGN

FUNCTION DIAGRAM YOU REQUIRE

HOSPITALISATION

NETWORK HOSPITAL

EMERGENCY

PLANNED HOSPITAL Submit

pre-Authorization

on request to TPA 4 days in

After admission hospital will intimate TPA with request for authorization

advance

TPA scrutinizes and on case-to-case basis will authorize hospital

Pre admission authorization provide you get cashless

facility

Your get treated and prior to discharge complete claim form and scrutinized and sign all relevant bills

You pay non-medical expenses directly

DATA TPA FLOW paysDIAGRAM bills to the hospitals

LEVEL-1

TPA

EMPLOYEE

ORGANIZA

HOSPITAL

-TION

LOGIN

TPA HOME PAGE

EMPLOYEE HOME PAGE

ORGANIZA -TION HOME PAGE

HOSPITAL HOME PAGE

LEVEL-2 LOG IN

ORGANISATION DETAILS

VIEW DETAILS

HOSPITAL DETAILS

VIEW DETAILS

VIEW REQUEST

EMPREGIS PPS_ AMOUNT TRANSAC-TION

PAYMENT SELECTION MAIL MAILING

CHECK MAIL

PHOTO ID SELECTION

EMPLOYEE REGISTRATION

LOG OUT

LEVEL-3 LOG IN

CHANGE REGISTRATION VIEW PASSWORD DETIALS

SELEC-TION PROCESS VIEW DETIALS

TPA

PREREQUEST

POSTREQUEST

MAILING

LOGIN

C HEC K MAIL

MAIL

CHANG E PROCES S

VIEW LOG OUT

DETIALS

P R O C E S S

TPA

LEVEL-4

LOG IN

EMPLOYEE DETIALS

VIEW EMPLOYEE DETIALS

CHANGE PASSWORD

RENIVAL FORM

MAILING

CHANG E PROCES

PROCES S

CHECK MAIL

LOG OUT

LOGIN

TPA

MAIL

LEVEL-5

LOG IN

TREATMENT DETIALS

PROCESS

BILL DETIALS PROCESS

VIEW\EDIT DETIALS

VIEW BILL DETIALS

VIEW DETIALS

MAILING PROCESS

LOG OUT

VIEW TREATMENT DETIALS

MAIL

DABLE DESIGN

TABLE 1-pps_empregis

FIELD NAME mediid empname desig dob permaddr parea ppin tempaddr tarea tpin doj gender contno martial sal pno

DATA TYPE

SIZE

DESCRIPTION

varchar(prim.key) varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar

100 500 100 100 1000 50 50 1000 50 50 100 10 100 15 50 100

Medical ID Employee Name Designation Date of Birth Permanent Address Permanent Area Permanent Pincode Temporary Address Temporary Area Temporary pincode Date of Join Gender Contact Number Martial Salary Phonenumber

mediallw bg email empuser emppass

varchar varchar varchar varchar varchar

50 10 500 500 200

Medical Allowance Blood Group Email Employee username Employee Password

TABLE 2 –pps_hospreg FIELD NAME hospID hospName address area state pincode phno url cperson cno desgi nod nosur spec email uname pwd

DATA TYPE int(Prim.key) varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar int int varchar varchar varchar varchar

SIZE 500 1000 80 80 80 80 80 100 50 500 100 80 250 250

DESCRIPTION Hospital ID Hospital name Address Area State Pincode Phone No URL Contact Person Contact No Designation No of Doctors No of Surgen Specilist Email UserName Password

TABLE 3-pps_bill FIELD NAME mediid patietName gender treatmentStartDate endingDate extcharge surgcost totamt billdt

DATA TYPE varchar(foreign key) varchar varchar varchar varchar varchar varchar varchar varchar

SIZE 500 500 10 20 20 50 500 50 1000

DESCRIPTION Medical Id Patient Name Gender Treatment Start Date Ending Date Extra charge Surgery cost Total Amount Bill details

TABLE 4-pps_treatmtdetails FIELD NAME mediid orgname patname gender trtsd trted trtmtcost trtdet

DATA TYPE varchar(foreign key) varchar varchar varchar varchar varchar varchar varchar

SIZE 100 500 500 10 20 20 80 1000

DESCRIPTION Medical Id Organization Name Patient name Gender Treatment start date Treatment end date Treatment cost Treatment details

TABLE 5-post_req FIELD NAME mid orgname hname hadd treat dname name fgender frelation age doa dod des bdate other

DATA TYPE int(foreign key) varchar varchar varchar varchar varchar varchar varchar varchar int varchar varchar varchar varchar varchar

SIZE 50 50 50 50 50 50 50 50 50 50 50 50 50

DESCRIPTION Medical ID Orgaisation name Hospital name Hoapital address Treatment details Doctor name Name Family Gender Family Relation Age Date of admission Date of discharge Designation Bill date Other detail

TABLE 6-pps_prereq FIELD NAME orgname mediid hospname hcity hstate trtmtfor doj drname fname frela fgender fage totcos other

DATA TYPE varchar int varchar varchar varchar varchar varchar varchar varchar varchar varchar int int varchar

SIZE 50 100 50 50 100 50 50 50 50 50 200

DESCRIPTION Organization name Medical id Hospital name Hospital city Hospital state Treatment for Date of join Doctor name Family name Family relation Family gender Family age Total cost Other detials

TABLE 7-pps_renival FIELD AME orgid ced rd

DATA TYPE int(prim.key) int int

SIZE

DESCRIPTION Organisation name Contract ending date Renival date

DATA TYPE int(prim.key) Varchar Varchar

SIZE

DESCRIPTION User id Password Email

TABLE 8-pps_login FIELD NAME uid pwd email

20 200

TABLE 9-pps_orgregis FIELD NAME orgid orgname addr city state zipcode orgtype url coperson connumb desig email empclaim dor orguser

DATA TYPE int(prim.key) varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar

SIZE

orgpass

varchar

500

500 1000 80 80 80 500 500 500 80 500 500 500 80 500

DESCRIPTION Organization ID Organisation name Address City State Zipcode Organization type URL Contactperson Contactnumber Designation Email Employeeclaim Date of request Organization user name Orgaization user password

IMPLEMENTATION

SITE HOME PAGE 





Login  All user can enter their home page through login alone.The invalid login cannot accept by the Patron Preservatio System. Forget Password  User can recall their password through this forget password.

New User Type o Organisation Registration Request  The new organisation can register their details . o Hospital Registration Request  The new hospital can register their details .

TPA HOME PAGE 

Organisation Details  TPA can view tie-up organization details.



Hospital Details  TPA can view tie-up hospital details. View Request  TPA can view tie-up employee details. Payment Selection  TPA can view and transaction the payment through this. Mailing  TPA can request and reply.

  



Photo ID Selection  Employee’s photos are scaned and provide medical ID card.



Employee Registration  TPA can register the employee details and update the information.

EMPLOYEE HOMEPAGE 

Requestion o Pre-Request  Employee can register their details before treatment. o Post-Request  Employee can register their details after treatment.



Mailing  TPA can request and reply. Change Password  Employee can change their password as their wish. View/Edit Details  Employee can view and edit their registration.

 

ORGANISATION HOME PAGE   



Employee Details  Organisation can view their employee details. Change Password  Organisation can change their password as their wish. Renival  Organisation can renival their contract with TPA. Mailing  Organisation can request and reply.

HOSPITAL HOME PAGE

 

 

Treatment Details  Hospital can enter the employee’s treatment details. Bill Details  Hospital can enter the employee’s treatment payment details. View/Edit Details  Hospital can view and edit the treatment and bill details. Mailing  Hospital can request and reply.

SOFTWARE TESTING Software testing is a set of activity that can be planned in advance and conducted systematically. It is a critical element of software quality assurance and represents the ultimate review of specification, design and coding. Software Testing is essential for correcting errors. Otherwise the Program or the Project is not said to be complete. Quality assurance is done by  Testing  Verification and validation Even a small error can lead a problem. For example, suppose the id of particular user shows some irrelevant information (i.e. showing some other user’s information). It creates a problem in some situation. TYPES OF TESTING DONE “Resource Scheduling System” was tested along with the following guidelines prove its validity. It was tested using the following of techniques of software testing.  Unit Testing

 Integration Testing  Validation Testing  System Testing  White box testing  Block box Testing

UNIT TESTING Unit testing focuses verification effort on the smallest unit of Software design (i.e), the module. Unit testing exercises specific paths in a module’s control structure to ensure complete coverage and maximum error detection. This test focuses on each individually, ensuring that it functioned properly as a unit. Hence, the name is Unit Testing. In this project, after completion of each module the validity and performance of the module tested. The input and output data are checked. The following modules are checked. 1. TPA function 2. HR 3. Employee 4. Hospital 5. Banking

The test data is applied for the new card registration. Every now and then corrections are made. Similar tests are applied for card validation and transaction modules.

INTEGRATION TESTING All the tested modules are combined as a single system and the entire program is test as a whole with the original data. After the Software has been integrated a set of highorder tests are conducted. The main objective in this testing process is to take unit-tested modules and build a program structure that has been dictated by design.

THE FOLLOWING ARE THE TYPES OF INTEGRATION TESTING: TOP DOWN INTEGRATION This method is an incremental approach to the construction of program structure. Modules are integrated by moving downward through the control hierarchy, beginning with the main program module,. The module subordinates to the main program module are incorporated into the structure in either a depth first or breadth-first manner. Bottom-Up Integration This method begins the construction and testing with the modules at the lowest level in the program structure. Since the modules are integrated from the bottom up, processing required for modules subordinate to a give level is always available and the need for stubs is eliminated. The bottom-up integration strategy may be implemented with the following steps. After integration of these modules, the performance and reliability of the software was tested.

Unit Testing In unit testing, main concern is of testing of all the individual components of the system. The units are tested and not their dependencies. The unit testing was successfully performed on the current project.

.

Integration Testing After testing the individual components and the various paths of the system now it’s necessary to verify that the components behave appropriately when they are integrated with other modules.

CONCLUSION System Analysis, Design and Implementation and also analyzing the hardware and software requirements through out the process of development of the system are known through this project. This system would help the Employee, Organization, and Third Party Administrator in performing their task in amore efficient way than they do at present. By this project I able to know about medical claim policy domain. The suggestion forwarded in the proposed software has been successfully completed and the final threshold of application has been crossed weaving through the system developed. I hope to do so even better and approach even further milestones in our career. This system prepares different types of reports, which was complex earlier while following it manually and now made it as simple to use. I am very happy to conclude this documentation work by saying the phase “To get together is the beginning, to say together is the progress, to work together is the success ” and “work always respected and rewarded”.

During the course of my project work, I had the best knowledge from all sides about information of project and life style. I also had the good manners, which boost me as complete software professional. This new system will be very much helpful for the entire user and I once again thank everybody who helped me through out the project. .

FUTURE ENHANCEMENT

This Project is aimed to focus on area of Internet. Now this has been achieved. Later this project can be developed in such a way that the employee can access this “Patron Preservation Suit for Health Care” for non-network hospital.

BIBLIOGRAPHY

 Mirdula Pariha, Jeff Webb, “Microsoft ASP.NET”, Tata Mac Graw Hill.  Paul Nielson, “Microsoft SQL Server”, Tata Mac Graw Hill.

ONLINE REFERENCES  ASP.NET www.asp.net www.discountasp.net

 SQL Server www.sql-server-performance.com

SOURCE CODE

ORGANIZATION EDIT:

public class orgidedit : System.Web.UI.Page

{ protected System.Web.UI.WebControls.DataGrid DataGrid1; protected System.Web.UI.WebControls.LinkButton LinkButton1; static string orgid; private void Page_Load(object sender, System.EventArgs e) { if(!Page.IsPostBack) { bind();

} } #region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN: This call is required by the ASP.NET Web Form Designer. // InitializeComponent(); base.OnInit(e); } /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// private void InitializeComponent() { this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_CancelC ommand); this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCom mand); this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateC ommand);

this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteC ommand); this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged); this.LinkButton1.Click += new System.EventHandler(this.LinkButton1_Click); this.Load += new System.EventHandler(this.Page_Load); } #endregion public void bind() { SqlConnection con=new SqlConnection("data source=lstnet2;initial catalog=patron;uid=sa;pwd=sa"); con.Open(); SqlDataAdapter da=new SqlDataAdapter("select * from neworgg1",con); DataSet ds=new DataSet(); da.Fill(ds); DataGrid1.DataSource=ds; DataGrid1.DataBind(); } private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { orgid=e.Item.Cells[2].Text; DataGrid1.EditItemIndex=e.Item.ItemIndex; bind(); }

private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { TextBox tb=(TextBox)e.Item.Cells[2].Controls[0]; TextBox tb1=(TextBox)e.Item.Cells[3].Controls[0]; SqlConnection con=new SqlConnection("data source=lstnet2;initial catalog=patron;uid=sa;pwd=sa"); con.Open(); SqlCommand cmd=new SqlCommand("update neworgg1 set orggname='"+tb1.Text+"' where orgid="+orgid+"",con); cmd.ExecuteNonQuery(); con.Close(); DataGrid1.EditItemIndex=-1; bind(); } private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { SqlConnection con=new SqlConnection("data source=lstnet2;initial catalog=patron;uid=sa;pwd=sa"); con.Open(); SqlCommand cmd=new SqlCommand("delete from neworgg1 where orgid="+e.Item.Cells[2].Text+"",con); cmd.ExecuteNonQuery(); con.Close(); DataGrid1.EditItemIndex=-1; bind(); }

private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { DataGrid1.EditItemIndex=-1; bind(); } private void LinkButton1_Click(object sender, System.EventArgs e) { Response.Redirect("orgid.aspx"); }

PRE-REQUEST: private void Page_Load(object sender, System.EventArgs e) { for(int i=1;i<=31;i++) { ddl3.Items.Add(i.ToString()); } for(int i=1990;i<=2010;i++) { ddl5.Items.Add(i.ToString()); } }

#region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN: This call is required by the ASP.NET Web Form Designer. // InitializeComponent(); base.OnInit(e); } /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// private void InitializeComponent() { this.txtorgname.TextChanged += new System.EventHandler(this.txtorgname_TextChanged); this.ddl5.SelectedIndexChanged += new System.EventHandler(this.ddl5_SelectedIndexChanged); this.submit.Click += new System.Web.UI.ImageClickEventHandler(this.submit_Click); this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click); this.Load += new System.EventHandler(this.Page_Load); } #endregion

private void ddl4_SelectedIndexChanged(object sender, System.EventArgs e) { } private void txteid_TextChanged(object sender, System.EventArgs e) { } private void ddl5_SelectedIndexChanged(object sender, System.EventArgs e) { } private void submit_Click(object sender, System.Web.UI.ImageClickEventArgs e) { Patron.Business_Logic.inserting r=new Patron.Business_Logic.inserting(); r.orgname=txtorgname.Text; r.mediid=txtmid.Text; r.hospname=txthospname.Text; r.hcity=txtcity.Text; r.hstate=txtstate.Text; r.trtmtfor=txttfor.Text; r.doj=ddl4.SelectedItem.Text+ddl3.SelectedItem.Text+ddl5.SelectedItem.Text; r.drname=txtdname.Text;

r.fname=txtfname.Text; r.frela=txtfrel.Text; r.fgender=rblg.SelectedItem.Text; r.fage=Txtage.Text; r.totcost=txttcost.Text; string Filename=System.IO.Path.GetFileName(File1.PostedFile.FileName); File1.PostedFile.SaveAs("d://gaja.bhu"+"//"+Filename); r.other=Filename.ToString(); r.insertt(); } private void browsebtn_Click(object sender, System.EventArgs e) { } private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e) { txtorgname.Text=""; txtmid.Text=""; txthospname.Text=""; txtcity.Text=""; txtstate.Text=""; txttfor.Text=""; ddl4.SelectedItem.Text=""; ddl3.SelectedItem.Text=""; ddl5.SelectedItem.Text=""; txtdname.Text=""; txtfname.Text="";

txtfrel.Text=""; Txtage.Text=""; txttcost.Text="";

} REMAINDERS: private void Page_Load(object sender, System.EventArgs e) { if(!IsPostBack) { Bussiness_Logic.Connection c=new LCS.Bussiness_Logic.Connection(); Bussiness_Logic .Insertion ins =new LCS.Bussiness_Logic.Insertion (); DataSet ds= ins.remselection(); if(ds.Tables[0].Rows.Count!=0) { for(int j=0;j
#region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN: This call is required by the ASP.NET Web Form Designer. // InitializeComponent(); base.OnInit(e); } /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// private void InitializeComponent() { this.cal1.SelectionChanged += new System.EventHandler(this.cal1_SelectionChanged); this.ddlid.SelectedIndexChanged += new System.EventHandler(this.ddlid_SelectedIndexChanged); this.txtdate.TextChanged += new System.EventHandler(this.txtdate_TextChanged); this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click); this.Load += new System.EventHandler(this.Page_Load); } #endregion private void btnupdate_Click(object sender, System.EventArgs e)

{ } private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e) { Bussiness_Logic.Connection c =new LCS.Bussiness_Logic.Connection(); Bussiness_Logic.Insertion ins= new LCS.Bussiness_Logic.Insertion (); ins.remid=ddlid.SelectedItem.Text; ins.remtxt =txtremtext2.Text; ins.remdate =txtdate.Text; ins.remupdate(); } private void cal1_SelectionChanged(object sender, System.EventArgs e) { txtdate.Text= cal1.SelectedDate.ToShortDateString(); } private void txtdate_TextChanged(object sender, System.EventArgs e) { } private void ddlid_SelectedIndexChanged(object sender, System.EventArgs e) {

Bussiness_Logic.Insertion ins=new LCS.Bussiness_Logic.Insertion(); ins.remid=ddlid.SelectedItem.Text; DataSet ds=ins.remainselect(); //DataView dv=ds.Tables[0].DefaultView; //dv.RowFilter="remid='"+ddlid.SelectedItem.Text+"'"; txtremtext2.Text=ds.Tables[0].Rows[0][1].ToString(); txtdate.Text=ds.Tables[0].Rows[0][2].ToString(); } } }

SAMPLE SCREENS

LOGIN FORM

PRE-REQUEST FORM

POST REUEST

POSTREQ REPORT

MASTER ENTRY-ORG ADD

ORG-EDIT

EMPLOYEE REGISTRATION

TREATMENT DETAILS

BILL DETAILS

ADD HOSPITAL DETAILS

ADD REMAINDERS