project repo

8/3/2019 Project Repo

1/132

Project Report

ON

EMPLOYEE CLAIM REIMBURSEMENT (ECRS)AT

Engineers India Limited (EIL).

By

VINOD ROHILLA

Department of Computer Applications,

Cochin University of Science and Technology

Kochi-682022

April, 2009


2/132

Engineers India Limited

CERTIFICATE

This is to certify that the project titled EMPLOYEE CLAIM REIMBURSEMENT (ECRS)being submitted by Mr.VINOD ROHILLA, 6th Semester MCA students of Department of

Computer Applications, GNIT in partial fulfillment of the requirements for the award of Master

in Computer Applications has been completed under the supervision of Mr. R.K.SINGH at

Engineers India Limited, 1-Bhikaiji Cama Place, New Delhi during the period from 19,

January, 2009 to 30 April, 2009.His performance during the project work has been excellent.

The work has not been submitted to any other institution or University for the award of any

degree/diploma to the best of knowledge.

Place: New Delhi Mr. R.K.SINGHDate: Senior Manager (ITS)

Engineers India Limited1, Bhikaiji Cama Place

New Delhi-110066


3/132

ACKNOWLEDGEMENTS

The satisfaction and euphoria that accompany the successful completion of any task

would be incomplete without mentioning the names of people who made it possible, whose

constant guidance and encouragement crowns all efforts with success.

I extend my gratitude to Mr. D. K. Kakkar, General Manager - Information Technology

Services (ITS), Engineers India Limited, New Delhi for providing me with excellent

infrastructure and awesome environment that laid potentially strong foundation for my

professional life.

I would like to express my profound thanks to Mr. R.K.SINGH, Senior Manager, ITS

for providing me the opportunity to work on the project, for assigning me a responsible role in

the module and guidance throughout my project tenure.

I extend my heartfelt thanks to my parents, friends and well wishers for their support and

timely help.

Above all I thank the Almighty for his blessings.

VINOD ROHILLA


4/132

TABLE OF CONTENTS

COMPANY PROFILE.....

1. ENGINEERS INDIA LIMITED

1.1. EIL Profile...........................................................................................................

1.1.1. Vision Statement...........................................................................................

1.1.2. Mission Statement........................................................................................

1.2. Historical Background........................................................................................

1.2.1. Petroleum Refineries....................................................................................

1.2.2. Fertilizers......................................................................................................

1.2.3. Pipelines........................................................................................................

1.2.4. Oil and Gas processing................................................................................

1.2.5. Power.............................................................................................................

1.2.6. Ports and terminals......................................................................................

1.2.7. Ocean Engineering.......................................................................................

1.2.8. Chemical........................................................................................................

1.2.9. Metallurgy.....................................................................................................

1.3. Services Offered by EIL.....................................................................................

1.3.1. Feasibility Studies.........................................................................................

1.3.2. Prefeasibility Studies....................................................................................

1.3.3. Detailed Feasibility Studies.........................................................................

1.3.4. Heat and Mass Transfer Equipment Design.............................................

1.3.5. Detailed Engineering....................................................................................

1.3.6. Project Management Consultancy..............................................................

1.3.7. Environmental Services...............................................................................

1.3.8. Planning and Scheduling.............................................................................

1.3.9. Construction Management..........................................................................

1.3.10. Cost Engineering........................................................................................

1.3.11. Procurement...............................................................................................

1.3.12. Commissioning and Plant Start up...........................................................

1.4. Information Technology Services Division.......................................................

1.4.1. Introduction..................................................................................................

1.4.2. Range of IT Services

2. Chapter- 2. INTRODUCTION..

2.1 Introduction ..

2.2Objective .2.3 System Analysis.....

2.4 Analysis Model..

2.5 Feasibility study....

2.6 Literature Survey.

2.7 Project Planning...

2.7.1 Process Model..

2.7.2 Work Breakdown Structure..


5/132

3. Chapter-3.DESIGN OF THE SYSTEM..............

3.1 Hardware/Software Requirements..

3.2 System Requirements3.3 System Specification..

3.4 Flow Chart3.5 Level-0 Data Flow Diagram 3.6 Level-1 Data Flow Diagram

3.7 Entity Relationship Diagram..

3.8 Design Structure.

4. Chapter-4. IMPLEMENTATION AND CODING...

4.1 Snapshots & Coding..........

5. Chapter-5. TESTING AND TEST RESULTS..

5.1 Validation...

5.2 Testing5.3 Test Cases...

6. Chapter-6. SYSTEM SECURITY.

6.1 Features.

7. Chapter-7. RESULTS AND CONCLUSION......

7.1 Conclusion.7.2 Appendix7.3 References..


6/132

COMPANY

PROFILE


7/132

ENGINEERS INDIA LIMITED

EIL ProfileEngineers India Limited (EIL) was established on March 15, 1965, as a joint venture

between the government of India and Bechtel Corporation of USA with the following prime

objectives:

To establish, provide, maintain and perform engineering and related technical and

consultancy services for petroleum projects including but not limited to, petroleum refineries, oil

field development, oil and gas pipelines, petrochemical facilities, chemical intermediaries and all

other types of industrial projects

In addition to petroleum refineries, EIL has diversified into other fields such as pipelines,

chemicals and oil and gas processing, etc. EIL provides a complete range of project services in

the fields and has emerged as South Asias leading design and engineering company.

EIL has under gone through more than 4000 assignments, 250 projects worth more than

US$ 35 billion in installed cost, successfully completed and operating smoothly creating an array

of satisfied clients and rising the turnover and profits. The major projects under taken by the

company includes 30 Petroleum Projects, 6 Petroleum Complexes, 200 Offshore Platforms, 31

Oil and Gas Processing Projects, 25 Mining and Metallurgical Projects, 8 Fertilizers Projects, 31

Pipelines Projects and 11 Ports and Terminals. EIL has also worked abroad creditability in

several countries of West Asia, North Africa, Europe and South East Asia including Algeria,

Abu Dhabi, Iran, Kuwait, Malaysia, Norway, Qatar, Saudi Arabia, Sri Lanka, UAE and Vietnam.

Vision Statement

To become a globally Competitive EPC & Consultancy Organization.

Mission Statement

To achieve international standards of excellence with a focus on customer satisfaction.

To provide high quality, safe and energy-efficient services in Process Design,

Engineering, Procurement, Construction with overall project Management in


8/132

Hydrocarbon, Metallurgy, Power and Ports & Terminals as well as Information

Technology and other selected sectors of Industry.

To achieve prominence in developing, adopting and assimilating state-of-the-art

technology for competitive advantage.

To maximize creation of wealth, value and satisfaction for stake holders.

To foster a culture of participation and innovation for employees' growth and

contribution through a climate of fairness and transparency in operation.

To acquire and provide technology and services through sustained Research &

Development and linkage among Engineering Organizations, Equipment Manufacturers,

Operating Companies and R&D Organizations to upgrade technologies on a continuous

basis.

To cultivate high standards of ethics and quality for a strong corporate identity and brand

equity.

To help enrich the quality of life of the community and preserve ecological balance and

heritage through the services provided with a strong environmental conscience.

Historical Background

The foundation of the consultancy profession in India was laid soon after independence.

The sixties saw the advent of major consultancy and engineering organization in the country with

the setting up of a number of design and engineering organizations, in both private sector as well

as public sector. Of these, Engineers India Ltd. Was the most prominent which was created in

1965 as a joint venture of the government of India (holding 51% shares) and Bechtel, a U.S.

based company (holding 49% shares) to provide engineering and related services for petroleum

and other industrial projects. In 1967, EIL became a wholly owned Government of India

Undertaking.

Engineers India Limited has been serving the process industry providing a completerange of project services. Initially, it started with engineering work for petroleum refineries and

diversified over the years, to add other fields of activity as well as other services. In response to

the changing business environment, Engineers India went through several stages of development

and has gradually evolved into an engineering company serving a wide range of industries

including petroleum refineries, petrochemicals, oils and gas processing projects, pipelines,


9/132

offshore platforms, fertilizers, chemical fibers and metallurgical industries providing a complete

range of project services .

It provides consultancy in the following fields of operation:

Petroleum

Pipelines

Oil and Gas Processing

Fertilizers

Ports & Terminals

Petrochemicals

Offshore Structure & Platforms

Chemicals

Metallurgy

Petroleum Refineries

Engineers India Limited has provided its services for over a dozen projects with a

combined refining capacity of 23 million tones/annum (460,000 bbls/day) and is working on

several other projects with a total refining capacity of over 25 million tones/annum (500,000

bbls/day). The projects include grassroots as well as expansion revamp projects of all refining

companies in India apart from refinery projects abroad. EIL has developed skills to such an

extent that barring the process design of a few licensed units; EIL can execute complete

petroleum refinery projects on its own. In addition to technologies for the main refinery units,

EIL also has technologies for lube refinery complexes.

Fertilizers

Engineers India Limited provides complete services starting with feasibility study up to

commissioning for fertilizer plants based on gas, naphtha and fuel oil. EIL has worked withrenowned licensors/contractors on various assignments for ammonia, urea and phosphates

fertilizer plants, in India and abroad.


10/132

Pipelines

Engineers India has the capability to plan and execute long distance cross country and

submarine pipelines for transportation of crude oil, petroleum products, gases, two phase fluids

and slurries. It provides services such as conceptual scheme, feasibility study, on site

investigations and route survey, cathodic protection and telemetry, telecommunication and

telesupervisory control for pipeline projects besides other project services such as design and

engineering, procurement, construction supervision and project management.

Oil and Gas processing

Engineers India Limited has expertise for Crude Oil processing plants such as:

Crude Gathering Stations

Multistage Separation

Crude Desalting

Dehydration and Heavy Oil/Sour Oil Processing.

It also has capabilities for implementing Gas Conditioning and Processing Plants

including Gas Collection Systems, Compressor Stations, and Solid/Liquid Desiccant

Dehydration, Dew point Depression, Impurities and Acid gases removal and Cryogenic Natural

Gas Liquids recovery such as LPG and Ethane / Propane recovery. It has handled a number of

such plants for the Oil and Natural Gas Corporation. Limited (ONGC) and Gas Authority of

India Ltd (GAIL). It has also provided consultancy for LPG and LNG projects of Sonatrach in

Algeria.

Power

In the field of power, EIL has undertaken assignments for captive power plants in large

process plants such as petroleum refineries, petrochemical complexes, etc. and has undertaken

feasibility studies for refinery residue based power projects.

EIL has association with: -Foster Wheeler Italiana for Residue Based Power Plants

Kema, Nederland for Renovation & Modernization and Life extension studies for Existing

Power Plants.


11/132

Ports and Terminals

The Ports & Terminals Division of EIL takes up projects such as jetties, SPMs, MBMs at

waterfronts or near to shore and related submarine pipelines with onshore facilities like

terminals, etc. The areas of operation include:

Master Plans for Ports

Technical assistance in Marine Surveys

Port Facilities/Jetties

Inland Terminals for receipt, storage and dispatch of liquid cargo in both pressurized and

cryogenic conditions

Offshore Handling Facilities including:

Single Buoy Moorings

Multi Buoy Moorings

Submarine Pipelines

Port based Terminals for receipt, storage and dispatch of:

Hydrocarbon products

Chemicals & Petrochemicals

Dry cargo both in bulk and bagged condition

Ocean Engineering

Engineers India's Ocean Engineering Division was formed in 1971 and has been involved

in the development of India's offshore oil and gas fields since then. Engineers India has wide

capabilities for providing full range of services needed to plan, design, engineer, construct and

commission ocean engineering projects such as oil and gas platforms, offshore oil terminals, oil

and fertilizer loading berths, intake structures, SBMs, offshore lighthouses, floating pump houses

and fabrication yards.

Chemical

EIL has expertise for chemical plants such as membrane cell technology based caustic

soda plants, soda ash, vaccine, insecticides etc., for which complete range of services can be

offered.


12/132

Metallurgy

In the field of metallurgy, EIL can render a comprehensive range of consultancy and

engineering services for zinc, lead, aluminum, copper, cadmium, silver, nickel, magnesium,

titanium, etc. and also for sponge iron. In addition, EIL can provide services for mine

development and beneficiation plants. The specialized services include Studies for Scaling up of

Pilot Plant to Industrial Plant, Process & Licensor selection, Optimization of the process

parameters, Energy Conservation etc. The areas of operation encompass:

Exploration data review, Geostatistical Ore reserve estimation and Ore Body modeling.

Planning and Design of Open Pit Mines, Pit Optimization Studies and Quality control.

Environmental studies for Mines.

Ore handling, storage and long distance conveying.

Design of Mineral Processing Plant and simulation & Optimization of crushing, grinding

and beneficiation circuits including conventional as well as column flotation cells.

Hydrometallurgical plants such as alumina refineries and lead smelters.

Pyro/electro metallurgical plants such as primary Aluminum and lead smelters. Design of

environment friendly tailings disposal/ stacking systems.

Services Offered by EILFeasibility Studies

EIL's experience in a variety of fields is available to clients for expansion or

diversification of their activities. Services offered include preliminary studies to examine the

viability of project, market potential of products, techno-economic evaluation, capital and

operating cost estimates etc

Prefeasibility Studies

To examine the viability of the project, market potential of products, techno-economic

evaluation, capital & operating cost estimates, etc.


13/132

Detailed Feasibility Studies

EIL also undertakes detailed feasibility studies to form the final cost of the project.

These detailed feasibility reports are also bankable to ensure that financial institutions can use

them for lending purposes.

EIL's project management services comprise direction and coordination of the activities

leading to the completion of a job in accordance with terms of the contract, in compliance with

the job schedule and to the satisfaction of the client. The efforts of various agencies such as

licensors, sub-contractors & EIL's different departments are brought together in a logical pattern

to result in fruitful culmination of the project.

Heat and Mass Transfer Equipment Design

Heat and Mass Transfer Division (HMTD) specializes in design and revamp of heat &

mass transfer equipment & related process package systems as part of overall EIL project or as

individual direct assignment to meet the requirement of new as well as existing plants.

Experience of HMTD in design and revamp of heat and mass transfer equipment system is

unparalleled.

The experienced manpower resources in HMTD carry out a wide range of services for the

following heat & mass transfer equipment, process and energy systems:

Fired Heaters & Air Preheating System

Heat Exchangers

Trays

Packing & Packed Tower Internals

Gas Dehydration System and Oil - Water - Gas Separators

Vacuum Ejector System, Process Waste Heat & CO Boiler and Incinerators

Deaerators

Desalters

Detailed Engineering

The process design package is converted into detailed engineering drawings and

documents by specialist civil, structural, mechanical, and electrical & instrumentation engineers,


14/132

Computer aided design techniques are extensively used as design aides to help develop optimum

layout & design to assure maximum construction, operational & maintenance convenience.

Detailed engineering leads to identification & specification of equipment and materials

for procurement & needs of construction activities at site.

Specialized Services are provided in the fields of static & dynamic analysis of equipment,

structures, geotechnical engineering, rotating equipment & troubleshooting.

Project Management Consultancy

. The experience gained in the implementation of complex integrated projects has enabled

Engineers India to undertake the role of Project Management Consultant. As Project

Management Consultant, EIL provides management services required for smooth

implementation of a complex project. It takes full responsibility for the overall co-ordination and

integration of functioning of all agencies engaged in the implementation of the entire project and

ensures the completion on schedule and within the budgeted cost.

EIL's scope as Project Management Consultant broadly covers the following:

Conceptualization of the Project

Technology Selection.

Developing Design Basis.

Selection of EPC Contractors.

Project Management including supervision, co-ordination, planning and scheduling

services, etc.

Quality Assurance at all stages of the project implementation, viz. process design,

detailed engineering, procurement and construction.

Assistance in inspection, testing, pre-commissioning and commissioning of facilities.

Environmental Services

EIL offers extensive services in the field of environmental engineering such as

Environment impact assessment, Waste water treatment, Water treatment, Solids and hazardous

waste management, Environmental audits, Resource recovery and recycle, Pollution prevention

and Waste minimization, etc. These services are provided for Petroleum Refineries,

Petrochemical Plants, Pipeline Projects, Oil/Gas Installations and Chemical Ports, Terminals,


15/132

SBM's and Jetties and Non-ferrous Metallurgical projects. EIL's close familiarity with the

technologies involved in the process industry gives it a unique advantage for undertaking

environment-related assignments.

Planning and Scheduling

EIL ensures effective and timely execution of projects through detailed planning and

micro scheduling along with continuous monitoring. For this purpose, the industry standard

PRIMA VERA software is used for computerized network analysis (PERT/CPM). Other

software packages such as HOST, CPS, MCS, and COSMAS etc. are used for home office

scheduling, construction, and planning and material control. Detailed schedules for engineering,

ordering, manufacturing, delivery, tendering and construction are developed. These schedules are

reviewed and updated and project completion outlook analyzed and corrective actions taken

regularly. In addition, physical progress of the project is measured and reported through a well-

designed reporting system, which enables complete evaluation of project performance.

Construction Management

EIL's Construction Division provides total construction management services at site

including selection of construction contractors, warehouse management, quality control/quality

assurance, process monitoring & scheduling, review of heavy erection schemes, safety etc.

Depending on client's need, EIL takes total site responsibility from survey & soil investigation to

mechanical completion & assistance in commissioning. Use of modern construction techniques,

innovative construction procedures, emphasis on QA/QC are some of the hallmarks based on

which it has been possible for EIL to reduce construction time of projects yet providing work of

highest quality.

Cost Engineering

EILs cost engineering services help the project management team in exercising

practically online control of the costs vis--vis project execution budgets through application of

latest techniques of Project Cost Management. Large dynamic database & in-house developed

programs operating on PC platform are used in estimating costs of work packages prior to their

award. A periodic 'Cost-to-Completion' projection is made through in-house developed program


16/132

"CEMOS" software to assist the Project Manager & Owner in taking timely decisions & actions.

The cost engineering systems employed are kept updated through the latest developments in cost

management techniques as also through experience gained while working on international

projects.

Procurement

EIL offers comprehensive procurement services through a highly professional purchase

team, effective monitoring and expediting group, a well experienced and qualified multi-

disciplinary inspection force and a specialist group for route survey and planning for multi model

movement of over dimensional consignments.

Following comprehensive procurement services are provided

Vendor identification, evaluation & enlistment.

Entire purchase activity, floating of enquiry to placement of order.

Order placement

Progress monitoring & Expediting

Inspection

Transportation planning & control

Safety certification under Static & Mobile Pressure Vessels (SMPV) rules of the Chief

Controller of Explosives

Statutory inspection in Europe & Japan under Indian Bouler Regulations.

A databank, providing significant information on capable vendors all over the world, is

maintained and constantly updated. EIL's twelve inspection offices in the country provide

competitive and prompt services in India. Overseas offices in Tokyo & London offer

procurement/inspection services outside India in the Far East & Europe.

Commissioning and Plant Start up

EIL's Commissioning team associates itself with the project right from the process design

stage. It reviews process & engineering design documents especially with respect to operability

& safety. The team also prepares operation manuals providing instructions for plant start-up,

shutdown & handling various emergencies. It provides guidelines and supervises pre

commissioning & commissioning activities at site. EIL's responsibility continues till production


17/132

of specification products has been established to the full satisfaction of the customers. The team

assists process department in conducting performance guarantee tests in order to establish plant

operation at design throughputs with product of specified quality. EIL also provides technical

guidance to customers in the area of troubleshooting.

Information Technology Services (ITS) Division

Introduction

Information Technology Services (ITS), a division of EIL has a well-knit team of over

100 multidisciplinary professionals who are well qualified and experienced in providing software

related and networking design services. Over the last 25 years, ITS has developed a large

number of integrated software packages for use within EIL in the areas of process design,

engineering, procurement, project management and construction. This experience along with the

domain knowledge in various functional disciplines has given an edge to ITS for providing value

added services to its clients in Oil Industry in particular and others in general. ITS has

spearheaded the task of making EIL a leader both in terms of software usage and having state-of-

the-art computing facilities and communication infrastructure leading to enterprise connectivity.

ITS over the years has executed a number of offshore and onshore software development

assignments for clients in India and abroad. The application areas covered are engineering

solutions, business applications (viz. materials management, maintenance management, financial

accounting, and personnel management), integrated plant information systems, intranet

development, operations research etc.

An overview of range of services along with assignments handled and clientele

highlighting EIL's IT experience is enumerated hereafter.

Range of IT Services

Preparation of a Master Plan and Its Implementation

EIL has executed a number of assignments in the areas of configuration assessment,

evaluation, selection and acceptance testing of computer and communication systems and

implementation for clients like:

Gas Authority of India Ltd.

Bongaigaon Refinery & Petrochemicals Ltd.


18/132

Electricity Boards etc.

EIL has also executed studies involving preparation of Refinery wide Master Plans taking

into consideration the integration of DCS, process functions & management information systems

for clients like:

Indian Oil Corporation,

Cochin Refineries

Bharat Petroleum Corporation Limited.

Customized Software Development for Engineering and Business Application

EIL has undertaken a number of customized software development and implementation

assignments in the following application areas:

Implementation of Plant Design Systems on PDS & PDMS platforms for Aker

Corporation, Norway & PIDEC in Iran.

On-line Integrated Materials Information System covering activities like indents,

purchase, stores issues/receipts, material accounting for operating plants namely Indian

Petrochemicals Corporation Ltd., Oil & Natural Gas Corporation, Bongaigaon Refinery &

Petrochemicals Ltd.

Computer Aided Maintenance Information System covering preventive & predictive

maintenance, work order, maintenance cost & breakdown history for BIPC, Iran. Financial

Management Systems including books, ledgers (main & subsidiary), balance sheet, & asset

account for major electrical utilities.

Plant Database Creation & Document Management

EIL has developed software, which provides for value added transfer of integrated plant

information system from EPC contractor to the client on electronic media. This software has

been implemented for Panipat Refinery Project and many other jobs are in advanced stage of

finalization.


19/132

Internet Application Development and Implementation

EIL has developed expertise in development of JAVA & HTML based applications for

implementation on Intranet. In addition to having Intranet for in-house needs, an assignment has

recently been completed for Gas Authority of India Ltd.

Enterprise Recourse Planning (ERP) Implementation

EIL has trained its software specialists and domain experts on the implementation of ERP

solutions. Currently a number of jobs are planned to be taken for Oil Industry in India in

association with our business partners M/s RAMCO for their ERP product, namely MARSHAL.

Operations Research (Linear Programming, Transport Models and Queuing)EIL has

executed a number of assignments involving OR techniques for the Ministry of Petroleum, Govt.

of India and also a study based on queuing model for a port in Malaysia. Major investment

decisions have been taken by the clients based on these optimization studies.


20/132

INTRODUCTION


21/132

About Project:Employee Claim Reimbursement System

This is a web based application (client server application) where employees of the

company can submit and make entry for the different claims like monthly telephone bill,

conveyance, indoor or outdoor trips made by employees, request for car for company work,

and others. They are privileged by this system as the employees can easily avail all the

claims by logging on the Company intranet i.e. EIL portal. Also it will be easy for the HR to

process the claims, and will be less tedious. It will reduce the maintenance of files.

Every employee depending on his/her post/level has a limit to which he can get reimbursed

about his claim and can apply only once in a month these all checks will be maintained by

the system to see whether the claim is in limit and if not then what portion of it can be

reimbursed .Thus it will reduce the work of administrative people. Also the system

generates crystal reports monthly after processing the claims and notifications are sent to

employees to make them aware about status of there claims they had applied.

Each employee has his/her user id and password to log on the companys intranet, can

submit the application for reimbursement and he/she can check the status of whether

his/her claims are processed are not.

Present Scenario

At present this work is all manual, that is there existing hard copy forms in which they

submit there claims and a file is maintained both by HR and administration.

This results in bulky and tedious work while reviewing and approving there claims also if

any checks are to be considered at a later stage it is difficult to maintain the file and go

through all.

Also employees have to keep visiting the HR department to know the status of thereapplication.


22/132

Proposed Solution

The ITS department at EIL is developing the web application called Employee ClaimReimbursement Management System for EIL portal. The application has centralized database in

oracle at head-office at Delhi. The application sever will be customized to provide access tousers at head-office, regional offices, through local intranet at EIL. The users will have access todifferent claim forms which they can fill and submit directly from there system and can alsoview /check the status of there forms when they have been processed and how much claimedamount has been reimbursed.

The administration and HR will be able to view data, process claims and print reports.This system takes care of both the user interface and the back-end efficiently. Interface of thesystem take care of the following issues:

Keeping the usage profile of the users in mind, interface is developed such that it takes

minimum amount of time with least possibility of error which can be made. Consistency of data entry transactions.

Minimal input actions by user.

Compatibility of data entry with data display.

Flexibility for user control of data entry.

Improved clarity and comprehensibility.

Well designed web forms to target the exact needs.

Back-end of the system is takes care of:

Well designed table to maintain consistency of data with minimum redundancy.

Data integrity.

Scope of Project

Following are the scope to assist the employees for the following purposes:

Create and maintain employee claim reimburse forms and database.

Online checklist status, monitoring and updating.

Report generation.

Building of knowledge base.

Online data communication between administration, HR and employee.

System wise report in specific format (crystal reports)


23/132

OBJECTIVES

Employee Claim Reimbursement System is the most important and essential function of

an organization. The Product Employee Claim Reimbursement System handles all the

claim/Approval activities for Employee of an organization. The Employee database is

maintained. Claim Reimbursement systems Automation is an important feature of the

project.


24/132

SYSTEM ANALYSIS

Analysis is the study of problem prior to making some action. In the specific

domain of computer system development analysis refers to the study of some business area

application, usually leading to the specification of the new system. The action that is to be taken

later on is implementation of the system. While analyzing, analyzer has to involve himself

deeply in the analysis task. If analysis of the system is wrongly understood then it will lead to

wrong design and subsequently to unwanted system. Most organizations appoint a project team

to do system development. The team is likely to be composed of system analysts, programmers

and users. A project leader is appointed to guide the project.

An organization first senses that there is a problem. The problem must be defined which is the

most difficult task that an organization faces. Several questions must be posed like:

What is the problem?

How complex is it?

What are its causes?

What are the possible solutions to the problem?

What types of benefits are expected once the problem is solved?

After analyzing the requirements of the task to be performed, the next step is to analyze the

problem and understand its context. The first activity in the phase is studying the existing system

thoroughly its working, flow of information and then analyzing its limitations. The second

activity is to understand the requirements and domain of the new system, which eradicates the

limitations of the existing system. Both the activities are equally important, but the first activity

serves as a basis of giving the functional specifications and then successful design of the system

is more difficult and requires creative thinking. It can be made effective only when we have

thorough understanding of the existing system. The process becomes even more difficult when

the existing system is almost entirely different from the one to be developed.


25/132

ANALYSIS MODEL

The model that is basically being followed is the WATERFALL MODEL, which states

that the phases are organized in a linear order. First of all the feasibility study is done. Once the

part is over the Requirement Analysis and Project Planning begins. The design starts after the

requirements analysis is complete and the coding begins after the design is complete. Once the

coding is completed, the testing is done. In this model the sequence of activities performed in

software development project are:

Requirement Analysis

Project Planning

System Design

Coding

Unit Testing

System Integration and Testing

Here the linear ordering of these activities is critical .Output of one phase is the input ofanother phase. The output of each phase is to be consistent with overall requirement of the

system. Some of the qualities of spiral model are also incorporated like after the people

concerned with.

Some of the qualities of spiral model are also incorporated like after Interface designing the user

was asked to validate the design as per the requirements. Interaction with the user was also done

from time to time for identifying further requirements.

WATERFALL Model was being chosen because all the requirements were known beforehand

and the objective of our software development is the computerization/automation of an already

existing manual working system.


26/132

Fig. Various Stages of WATERFALL MODEL

Requirement Analysis &Specification

Design

Implementation & Unittesting

Operation & Maintenance.

Integration & SystemTesting


27/132

Requirement Analysis & Specification Phase

The goal of this phase is to understand the exact requirements of the customer

and to document them properly. The requirements describe the what of the system, not the

how. This phase produces a large document, written in a natural language, contains a

description of what the system will do without describing how it will be done. The resultant

document is known as Software Requirement Specification (SRS).

The SRS document may act as a contract between the developer & customer.

Design Phase

The goal of this phase is to transform the requirements specification into a structure thatis suitable for implementation in some programming language.

Here, overall software architecture is defined, and the high level and detailed design work

is performed. This work is documented and known as software design description (SDD)

document.

Implementation & Unit testing Phase

During this phase, design is implemented. If SDD is complete, the implementation or coding

phase proceeds smoothly.

During Testing, the major activities are centered around the examination and modification of

the code. Initially small modules are tested in isolation from the rest of the software product.

Integration & system testing Phase

This is a very important phase. Effective testing will contribute to the delivery ofhigher quality software products, more satisfied users, lower maintenance costs, a and more

accurate and reliable results. It is a very expensive activity and consumes one third to one-half of

the cost of a typical developments project.


28/132

As we know, the purpose of unit testing is to determine that each independent module is

correctly implemented. This gives a little chance to determine that the interface between modules

is also correct, and for this reason integration testing of the entire system is done whereas

software is part of the system. This is essential to build confidence in the developers before

software is delivered to the customer or released in the market.

Operation & Maintenance phase

Software maintenance is a task that every development group has to face, when the software is

delivered to the customers site, installed and is operational.

Therefore, release of software inaugurates the operation and maintenance phase of the life cycle.

The time spent and effort required to keep the software operational after is very significant.

Despite the fact that it is very important and challenging task; it is routinely the poorly managed

headache that nobody wants to face.

Software maintenance is a very broad activity that includes error correction, enhancement of

capabilities and optimization. The purpose of this phase is to preserve the value of the software

overtime. This phase of this phase for 5-50 years whereas development may be 1-3 years.


29/132

FEASIBILITY STUDY

A feasibility study determines whether the proposed solution is feasible based on the priorities of

the requirements of the organization. A feasibility study culminates in a feasibility report that

recommends a solution. It helps you to evaluate the cost-effectiveness of a proposed system.

The feasibility study is carried out to test if the proposed system is worth being implemented.

Given unlimited resources and infinite time, all projects are feasible.

After performing a Preliminary Investigation, gathering and interpreting data and details

concerning the project, a Feasibility Check is done which involves a series of steps to check the

Technical, Financial and Operational feasibilities.

During this phase, various solutions to the existing problems were examined.

For each of these solutions the Cost and Benefits were the major criteria to be examined before

deciding on any of the proposed systems.

These Solutions would provide coverage of the following:

a) Specification of information to be made available by the system.

b) A clear cut description of what tasks will be done manually and what needs to be

handled by the automated system.

c) Specifications of new computing equipment needed.

A system that passes the feasibility tests is considered a feasible system. Let us see some

feasible tests in my project.


30/132

TECHNICAL FEASIBILITY

It is related to the software and equipment specified in the design for implementing a new

system. Technical feasibility is a study of function, performance and constraints that may affect

the ability to achieve an acceptable system. During technical analysis, the analyst evaluates the

technical merits of the system, at the same time collecting additional information about

performance, reliability, maintainability and productivity. Technical feasibility is frequently the

most difficult areas to assess.

The main technical issue raised during feasibility is the existence of necessary

technology and whether the proposed equipment has the capacity to hold required data. The

technical guarantee of accuracy, reliability, ease and data were also investigated.

Assessing System Performance: It involves ensuring that the system responds to user queries

and is efficient, reliable, accurate and easy to use. Since we have the excellent network setup

which is supported and excellent configuration of servers with 80 GB hard disk and 512 MB

RAM, it satisfies the performance requirement.

After the conducting the technical analysis we found that our project fulfills all the technical

pre-requisites, the network environments if necessary are also adaptable according to the

project.

ECONOMIC FEASIBILITY

This feasibility has great importance as it can outweigh other feasibilities because costs affect

organization decisions. The concept of Economic Feasibility deals with the fact that a system


31/132

that can be developed and will be used on installation must be profitable for the Organization.

The cost to conduct a full system investigation, the cost of hardware and software, the benefits in

the form of reduced expenditure are all discussed during the economic feasibility.

Return on Investment

i. There will be cost reduction in terms of maintaining huge amounts of

paper records, stationary, humans.

ii. There will be tracking of the Subscribers from a centralized database.

iii. Subscriber satisfaction will lead to more upgrades and reduce the

downgrades.

Cost of No Change

The cost will be in terms of utilization of resources leading to the cost to the

company. Since our cost of project is our efforts, which is obviously less than the

long-term gain for the company, the project should be made.


32/132

Literature Survey

A lot of literature survey was done before getting started with the project. Some of the

main outcomes of it were as follows:

GUI guidelines for Web Based Project

References have been taken from Quality Document No.8-2000-0005 at EIL. This

document defines the GUI Guidelines to be followed while developing the Web Based

Application.

Login Web Page: It is mandatory that login page does not scroll in horizontal. Users shall

also avoid scrolling of page vertically.

Application Page (After Login): Application page may be designed either with top menu

only or tree menu at left or both tree and top menu depending upon the requirement of

application. However if tree menu is used it shall be on the left side of the page. All the

pages to appear after the login page shall have a provision for signing out of the

application. Sign Out link shall appear in the top-right corner of the page. Application

name shall appear in the top-left corner of the page. Header section consisting of the

bands showing application full name and top menu shall appear in all pages.

Components in Content Page: Content pages shall be enclosed in a panel and form name

shall be displayed on the top of page. Relevant classes for the common controls used on

the pages.

Messages

o Tool tips: Tool tips shall be provided wherever necessary to help the user.

o Status and Error Messages: Pages shall flash the appropriate messages at the top

of the page below the form name. Developers shall provide messages whenever

state of the application changes to keep the user informed.

o Confirmation Messages: Developers shall reconfirm by displaying prompt

messages while performing critical operation like data deletion etc. Confirmation

messages shall be displayed in a popup window.


33/132

Project Planning

Process ModelThe process model used at EIL is Software Development Life Cycle (SDLC) Process

Model. At EIL, the SDLC procedure is define in their quality document. The software

development process consists of the following sub processes:

Scope Definition

System Analysis and Design Program

Development and Testing

Implementation

Configuration Management: This sub process is applicable to all the above sub processes

Scope Definition

This sub-process consists of activities such as receipt of customer request, nomination of

coordinator, identification of scope of work, preparation of project plan, delivery of the scope

document and controls. For implementation type of job this activity is carried out under the name

of requirement specification.

System Analysis and Design Program

This sub-process consists of activities such as formation of SDT, detail study of the

existing system, design specifications of the proposed system, program specifications of the

proposed system and the controls.

Development and Testing

Based on the system analysis and design document, the software programs shall be developed by

the SDT. A modular approach with structured concepts is to be employed to facilitate easy

understanding and maintenance. During the development of the programs following are to be

ensured

Naming conventions of variables, fields, records, files, labels, program modules screens,

help messages etc. and consistency in the coding to be maintained.


34/132

Suitable annotations are to be included in the program code. Debugging aids and

messages to be deployed.

Consistency of individual module version is to be ensured.

Implementation

Finally developed software is implemented in the user premises. The following needs to be

performed:

Preparation for Installation

Installation

Testing and Parallel Run Bugs removal

Training

Acceptance

Warranty Period and Maintenance

Job Closure

Backup submission

Release of resources


35/132

Work Break down Structure

The team members will not be dedicated to specific projects and can be assigned todifferent sub projects based on need. To begin with, the different streams are formed with the

team members as shown in the organization structure diagram.

Figure 2: Work Break down Structure

Project Specific Skill Requirements

Role Skill Requirement

Developer Visual Studio (Development Environment).

ASP.NET VB Programming.

Oracle Database design & PL/SQL Programming.

Table 1 : Skill Requirements

D.K.Kakkar(GroupLeader)

R.K.SINGH

(Team Leader)

VINODROHILLA


36/132

Risks

The details of the risks perceived in the project are given here, the severity of the same,

the probability of the same and the mitigation actions. Severity can be Critical, Major, Minor and

the Probability can be High, Medium or Low.

Risk Severity Probability Mitigation

plan

Owner

Performanceof the system

being low

Critical Medium Get anarchitect tofocus on

performanceissues

PM

Requirement

Changes

Critical Medium To accept

changes thatcan beaccommodated within thecurrentrelease andto postponethe others tothe next

release.Table 2 : Risks

Assumptions/ Constraints

AssumptionsECRS will target ONLY Windows OS on IntelArchitecture.

The super user can only create the project.

The construction coordinator, project coordinator

and lead engineer has edit rights.The job engineer doesnt have edit rights.

Constraints

Once the project is created, it can be deleted by anITS coordinator. Even Super user can not deletethe project created.

Table 3 : Assumption/Constraints


37/132

Actual Status

As of writing of this document the Development Code for administrator module is still

undergoing modifications. The Unit Testing for the module is done as the project is progressing.

The current version is successfully creating project and its details, assigning job wise

responsibility, importing data, enquiries based on project no and report generation. The reasons

for modifications are due to the change in the user requirement.


38/132

DESIGN OF THE

SYSTEM


39/132

SOFTWARE/HARDWARE SPECIFICATION

Hardware Specification

SERVER

A Server with Pentium 500 MHz or higher processor, 512MB RAM.

Minimum 5 GB Hard Disk Space Recommended.

800X600 Pixels Screen Resolution for proper viewing of Screens.

CLIENT

A PC with Pentium/Celeron Processor, 256MB RAM

800X600 Pixels Screen Resolution for proper viewing of Screens.

Software Specification

Operating system to be used : Microsoft Windows 2000 Professional or XP.

RDBMS to be used : Oracle 10i.

Scripting language to be used : VB.NET

Editing and debugging tools : Microsoft visual studio.net 2005

Web technology used : ASP.net

Web server to be used : Microsoft visual web developer.

Web Browser : Microsoft Internet explorer 5.0 or Higher.


40/132

Detailed Analysis

In this section I have used various modeling techniques to show the details of the project.The various models available in this section include the following:

Flow Chart

E-R Diagram

Data Flow Diagram

o Level 0

o Level 1

Database Design


41/132

VerifyAuthority

Main menu

MedicalClaim

TelephoneReimbursement

Claim forTravelExpenses

MeetingClaim

Requisitionform

Reports

Database

Flow Chart


42/132

E-R Diagram (ECRS)

EMPLOYEE

Empname Empno_

Designation

Password

Email

Level Mobileno.

Landlineno.

Claim/Approval

HasWORKSON

Dependents

Dep id NameStatus

Relationship

MedicalDae

Amount

Claimno

CarRequisit-

ion

Place_visit

Purpos

e

To_date

From_date

Directory

Type

Address

Exo

TravelAbroad

Dep_going

Country

Sponsored

Expense Claim

OfficialPurpose

AdvanceDrawnTotal

Expenseon meals

No. OfPerson

s

Joiningdate


43/132

Physical Design (DFD)

DFD means data flow diagram. Before developing software, programmer should

have a clear picture of DFD. A DFD shows the movement of data through the different

transformations or processes in the system. Named circles show the processes and data named

arrows represent flows and a rectangle represents a source or sink. A DFD can be considered as

an abstract of the logic of an information-oriented or a process-oriented system flow-chart. For

these reasons DFDs are often referred to as logical flow diagrams. The four basic symbols used

to construct data flow diagrams are shown below:

A rectangle represents a data source or destination.

A directed line represents the flows of data, which

is data stream.

An enclosed figure, usually a circle or an oval

bubble, represents a process that transforms data

streams.

An open-ended rectangle represents data storage.

The Data Flow Diagram basically serves two purposes.

1. Provide a graphical tool, which can be used effectively by the analyst to explain

the understanding of the system to the user.

2. They can be effectively converted into structured charts, Which effectively help

in the designing of the system


44/132

Context Level DFD

Level 0 DFD

ECRSYSTEM

EMPLOYEE

LoginVerification

Authentication

Database


45/132

DFD Level 1

AuthorizeduserLoginUser

Home Page

Claim/ApprovalDatabase

Updation

DataEntry

Validation

Reportgeneration Database

Report

Invalid user

Valid user

Invalid

Valid


46/132

TABLES USED IN THE WEBSITES

1. VINEMP

Name Null? Type------------------------------- -------- ----ID NUMBER(2)NAME VARCHAR2(10)ORGN VARCHAR2(10)SALARY NUMBER(5)JOIN_DATE DATE

2. VINEMP1

Name Null? Type------------------------------- -------- ----EMPNO NOT NULL NUMBER(4)NAME VARCHAR2(20)LVL NUMBER(2)LVL_DESC VARCHAR2(20)

3. ABROAD

Name Null? Type------------------------------- -------- ----SNO NUMBER(2)EMPNO NUMBER(4)NAME VARCHAR2(20)LVL VARCHAR2(10)FROM_DATE VARCHAR2(20)TO_DATE VARCHAR2(20)PURPOSE VARCHAR2(30)PLACE_VISIT VARCHAR2(20)

4. ABROAD1Name Null? Type------------------------------- -------- ----


47/132

SNO NOT NULL NUMBER(38)EMPNO NOT NULL NUMBER(38)NAME VARCHAR2(15)LVL VARCHAR2(20)FROM_DATE DATE

TO_DATE DATEPLACE_VISIT VARCHAR2(15)PURPOSE VARCHAR2(20)

5. PASSWORD1

Name Null? Type------------------------------- -------- ----EMPNO NUMBER(4)PASSWORD VARCHAR2(10)

ENAME VARCHAR2(10)DESG VARCHAR2(15)DEPT NUMBER(2)ICOM_NO VARCHAR2(4)

6. CLAIM

Name Null? Type------------------------------- -------- ----NAME VARCHAR2(10)EMPNO NUMBER(4)

DESG VARCHAR2(10)DEPT VARCHAR2(10)PURPOSE VARCHAR2(10)NOP NUMBER(4)CDATE DATETOTAL NUMBER(6,2)ADVANCE NUMBER(6,2)UNBAL NUMBER(6,2)UBDATE DATEBUDGET NUMBER(6,2)YEAR NUMBER(4)

CAMNT NUMBER(6,2)MEALS VARCHAR2(50)MEAL_EXP NUMBER(5)OTHER_EXP NUMBER(5)TIPS NUMBER(5)

7. Travel


48/132

Name Null? Type------------------------------- -------- ----SNO NUMBER(4)EMPNO VARCHAR2(4)COUNTRY VARCHAR2(25)

ADDRESS VARCHAR2(100)FROM_DATE DATETO_DATE DATEPLANVISIT VARCHAR2(20)COUNTRY2 VARCHAR2(20)TRV_OPTION VARCHAR2(30)SRC_NAME VARCHAR2(20)PURPOSE VARCHAR2(20)DEPT NUMBER(2)DESG VARCHAR2(10)ENAME VARCHAR2(10)

ICOM_NO NUMBER(5)RELATION VARCHAR2(20)REC_DATE DATE

8. DEP_MEMBERName Null? Type------------------------------- -------- ----SNO NUMBER(3)EMPNO NUMBER(4)

NAME VARCHAR2(20)RELATION VARCHAR2(20)DEPID NOT NULL NUMBER(3)

9. PASS

Name Null? Type------------------------------- -------- ----ID NUMBER(4)

NAME VARCHAR2(15)PASSWORD VARCHAR2(20)

10. DEPENDENT

Name Null? Type------------------------------- -------- ----


49/132

SNO NUMBER(4)EMPNO NUMBER(4)DEP_ID NUMBER(4)

11. MEM_GOING

Name Null? Type------------------------------- -------- ----EMPNO NUMBER(4)NAME VARCHAR2(20)DEPID NUMBER(2)RELATION VARCHAR2(20)

12. PDEV_MEMB_BODY

Name Null? Type------------------------------- -------- ----PROF_BODY_CODE NOT NULL VARCHAR2(5)BODY_NAME NOT NULL VARCHAR2(50)ADD_BODY VARCHAR2(150)ADD_CITY VARCHAR2(50)ADD_STATE VARCHAR2(50)STD_CODE VARCHAR2(6)PHONE_NO VARCHAR2(50)FAX_NO VARCHAR2(30)E_MAIL VARCHAR2(30)

WEB_URL VARCHAR2(30)UPDATE_DATE NOT NULL DATEUPDATE_BY NOT NULL VARCHAR2(5)

13. PDEV_MEMB_CAT_DET

Name Null? Type------------------------------- -------- ----PROF_BODY_CODE NOT NULL VARCHAR2(5)MEMB_CAT_CODE NOT NULL VARCHAR2(5)MEMB_CAT_NAME NOT NULL VARCHAR2(50)

ENROLL_FEE NUMBER(10,2)ANNUAL_FEE NOT NULL NUMBER(10,2)UPDATE_DATE NOT NULL DATEUPDATE_BY NOT NULL VARCHAR2(5)WEF DATE

14. PDEV_CLAIM_INFO


50/132

Name Null? Type------------------------------- -------- ----CLAIM_NO NOT NULL NUMBER(12)CLAIM_DATE NOT NULL DATEEMP_NO NOT NULL VARCHAR2(4)

MEMB_NO NOT NULL VARCHAR2(15)MEMB_DATE NOT NULL DATEPROF_BODY_CODE NOT NULL VARCHAR2(5)MEMB_CAT_CODE NOT NULL VARCHAR2(5)MEMB_VALIDITY_CODE NOT NULL VARCHAR2(1)ENROLL_FEE NUMBER(10,2)ANNUAL_FEE NOT NULL NUMBER(10,2)RCPT_NO NOT NULL VARCHAR2(15)RCPT_DATE NOT NULL DATECLAIMED_AMT NOT NULL NUMBER(10,2)APPROVED_AMT NUMBER(12,2)

RELEASED_AMT NUMBER(10,2)BAL_AMT NUMBER(10,2)DOC_RECV_ON DATEAPPROVED_ON DATEPMT_RELEASED_ON DATEMEMB_DUE_DATE DATEPROC_STATUS NOT NULL VARCHAR2(2)PROC_MONTH NOT NULL NUMBER(2)PROC_YEAR NOT NULL NUMBER(4)PROC_DATE NOT NULL DATEPROC_BY NOT NULL VARCHAR2(5)

REMARKS VARCHAR2(200)SR_NO NUMBER(2)NXT_PMT_REL_DT DATEMEMB_FEE NUMBER(10,2)BANK_FEE NUMBER(10,2)

15. med_claim_details

Name Null? Type

------------------------------- -------- ----EMP_NO NOT NULL CHAR(4)CLAIM_NO NOT NULL NUMBER(5)TYPE CHAR(1)DATE1 DATERATE VARCHAR2(40)MISC VARCHAR2(40)DATE2 DATE


51/132

CLAIMED_AMT NUMBER(12)DIS_AMT NUMBER(12)SL_NO FLOAT(*)REASON NUMBER(22)TYPE_SERIAL_NO NOT NULL VARCHAR2(3)

EX_DATE VARCHAR2(20)EX_DATE1 VARCHAR2(20)

16. DirectoryName Null? Type------------------------------- -------- ----EMPNO NUMBER(4)DT_JOIN DATELANDLINE NUMBER(15)MOBILE NUMBER(11)

TYPE VARCHAR2(20)SEPT_LINE NUMBER(10)EXTNO NUMBER(4)ADDRESS VARCHAR2(40)

Screen Shots


52/132

LOGIN FORM

CODING

Imports System.Data.oledb


53/132

Namespace ProfDev PartialClass Login Inherits System.Web.UI.Page

#Region" Web Form Designer Generated Code "

'This call is required by the Web Form Designer. PrivateSub

InitializeComponent()

EndSub

PrivateSub Page_Init(ByVal sender As System.Object, ByVal e AsSystem.EventArgs) HandlesMyBase.Init 'CODEGEN: This method call is required by the Web Form Designer 'Do not modify it using the code editor.

InitializeComponent() EndSub

#EndRegion PrivateSub Page_Load(ByVal sender As System.Object, ByVal e AsSystem.EventArgs) HandlesMyBase.Load 'Put user code to initialize the page here Dim logout AsInteger = Request.Params("logout") If IsPostBack() = FalseThen If logout = 1 Then

Session.Abandon() EndIf EndIf EndSub

ProtectedSub btnLogin_Click(ByVal sender AsObject, ByVal e AsSystem.EventArgs) Handles btnLogin.Click Dim User_id AsString = txtUserId.Text Dim pword AsString = txtPassword.Text Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.AppSettings( "ConnectionString")) Dim cmd As OleDbCommand = New OleDbCommand

cmd.CommandText = "select * from PASSWORD1 where trim(EMPNO)='" +User_id + "' and trim(PASSWORD)='" + pword.ToUpper + "' "

cmd.Connection = myConnmyConn.Open()

Try Dim dr As OleDbDataReader = cmd.ExecuteReader

If dr.HasRows Then

dr.Read() If dr.HasRows Then

Session("userID") = User_idSession("password") = pword

Response.Redirect("./home.aspx") Else

Session("userID") = ""


54/132

lblError.Text = "Invalid password." EndIf Else

Session("userID") = ""lblError.Text = "The user is not a valid user."

EndIf Finally EndTry

myConn.Close()

EndSub

ProtectedSub txtUserId_TextChanged(ByVal sender AsObject, ByVal e As

System.EventArgs) Handles txtUserId.TextChanged

EndSub EndClass

EndNamespace

MAIN WINDOW


55/132

CODINGImports System.Data.oledb


56/132

PartialClass Home Inherits System.Web.UI.Page ProtectedSub Page_Load(ByVal sender AsObject, ByVal e AsSystem.EventArgs) HandlesMe.Load

TextBox1.Text = Session("userID")TextBox2.Text = Session("password")

EndSub

ProtectedSub Button1_Click(ByVal sender AsObject, ByVal e AsSystem.EventArgs) Handles Button1.Click Dim User_id AsInteger = Session("userID") Dim U_name AsString = TextBox1.Text Dim N_pass AsString = TextBox3.Text Dim R_pass AsString = TextBox4.Text

If (N_pass = R_pass) Then Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.AppSettings( "ConnectionString"))

Dim cmd As OleDbCommand = New OleDbCommand Dim strsql AsString

cmd.Connection = myConnmyConn.Open()

Try

strsql = "update password set password='" + N_pass + "' whereEMPNO=" + User_id.ToString + " "

cmd = New OleDbCommand(strsql, myConn)cmd.CommandText = strsqlcmd.Connection = myConn

Dim res AsInteger = cmd.ExecuteNonQuery() If res


57/132

PROFESSIONAL BODY FORM


58/132

CODING


59/132

Imports System.Data.oledbImports System.DateTimePartialClass AddProfBody Inherits System.Web.UI.Page ProtectedSub Page_Load(ByVal sender AsObject, ByVal e AsSystem.EventArgs) HandlesMe.Load If IsPostBack = FalseThen If Session("userID") = ""Then

Response.Redirect("./Default.aspx") EndIf

oleDBAck.SelectCommand = "SELECT ROWNUM,PROF_BODY_CODE,BODY_NAME, ADD_BODY, ADD_CITY, ADD_STATE, STD_CODE, PHONE_NO, FAX_NO, E_MAIL,WEB_URL FROM (select * from PDEV_MEMB_BODY order by BODY_NAME asc) "

lblErr.Text = "" EndIf EndSub ProtectedSub InsertRecord(ByVal sender AsObject, ByVal e As EventArgs)

Dim bodyCode AsString = CType(txtProfBodyCode.Text, String).ToUpper Dim bodyName AsString = CType(txtProfBodyName.Text, String).ToUpper

Dim addr AsString = CType(txtAddress.Text, String) Dim city AsString = CType(txtCity.Text, String) Dim state AsString = CType(txtState.Text, String) Dim std AsString = CType(txtSTD.Text, String) Dim phNo AsString = CType(txtPhNo.Text, String) Dim faxNo AsString = CType(txtFaxNo.Text, String) Dim email AsString = CType(txtEmail.Text, String) Dim url AsString = CType(txtURL.Text, String) Dim updtBy AsString = Session("UserId") Dim res AsInteger

Dim flag AsBoolean = False Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.AppSettings( "OraConnString")) Dim cmd1 As OleDbCommand = New OleDbCommand Dim cmd2 As OleDbCommand = New OleDbCommand

Dim strDate = Now.ToString("dd-MMM-yyyy").ToUpper If txtValidation() Then

cmd1.CommandText = "select PROF_BODY_CODE from PDEV_MEMB_BODYwhere PROF_BODY_CODE='" + bodyCode + "' "

cmd1.Connection = myConnmyConn.Open()

Dim dr As OleDbDataReader = cmd1.ExecuteReader() If dr.HasRows Then

lblErr.Text = "This Code is exist in Database."

txtProfBodyCode.Focus()dr.Close()

ExitSub EndIf

dr.Close() Try

cmd2.CommandText = "INSERT INTO PDEV_MEMB_BODY VALUES('" +bodyCode + "','" + bodyName + "','" + addr + "','" + city + "','" + state +"', '" + std + "', '" + phNo + "','" + faxNo + "','" + email + "','" + url +"','" + strDate + "','" + updtBy + "')"


60/132

cmd2.Connection = myConn If myConn.State = Data.ConnectionState.Closed ThenmyConn.Open()

res = cmd2.ExecuteNonQuery() Catch ee As OleDbException

lblErr.Text = "Can Not be Inserted, DB Problem." Finally

myConn.Close() EndTry If res > 0 Then

oleDBAck.SelectCommand = "SELECT ROWNUM,PROF_BODY_CODE,BODY_NAME, ADD_BODY, ADD_CITY, ADD_STATE, STD_CODE, PHONE_NO, FAX_NO, E_MAIL,WEB_URL FROM (select * from PDEV_MEMB_BODY order by BODY_NAME asc) "

lblErr.Text = "Data Saved!" EndIf EndIf EndSub Function txtValidation() AsBoolean If txtProfBodyCode.Text.Length 0 AndNot IsNumeric(txtPhNo.Text) Then

lblErr.Text = "Phone No is not Numeric."txtPhNo.Focus()

ReturnFalse EndIf If txtFaxNo.Text.Length > 0 AndNot IsNumeric(txtFaxNo.Text) Then

lblErr.Text = "Fax No is not Numeric."txtFaxNo.Focus()

ReturnFalse EndIf If txtEmail.Text.Length > 0 And InStr(txtEmail.Text, "@") Then

lblErr.Text = "Email id is not valid."txtEmail.Focus()

ReturnFalse EndIf

lblErr.Text = "" ReturnTrue EndFunction Function resetAll()

txtProfBodyCode.Text = ""txtProfBodyName.Text = ""txtAddress.Text = ""


61/132

txtState.Text = ""txtSTD.Text = ""txtPhNo.Text = ""txtFaxNo.Text = ""txtEmail.Text = ""txtURL.Text = ""

EndFunctionEndClass

EDIT/DELETE PROFESSIONAL BODY FORM


62/132

CODING


63/132

Imports System.Data.oledbImports System.DateTimePartialClass EditProfBody Inherits System.Web.UI.Page ProtectedSub Page_Load(ByVal sender AsObject, ByVal e AsSystem.EventArgs) HandlesMe.Load If IsPostBack = FalseThen If Session("userID") = ""Then


setGridView() EndIf

lblErr.Text = ""txtBodyCode.Enabled = False

EndSub PrivateSub setGridView()

oleDBAck.SelectCommand = "SELECT PROF_BODY_CODE, BODY_NAME, ADD_BODY,ADD_CITY, ADD_STATE, STD_CODE, PHONE_NO, FAX_NO, E_MAIL, WEB_URL FROM (select* from PDEV_MEMB_BODY order by PROF_BODY_CODE asc) " EndSub

ProtectedSub EditRecord(ByVal sender AsObject, ByVal e As EventArgs) Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.AppSettings( "OraConnString")) Dim cmd As OleDbCommand = New OleDbCommand

Dim bodyCode AsString = CType(txtBodyCode.Text, String).ToUpper Dim bodyName AsString = CType(txtProfBodyName.Text, String).ToUpper Dim addr AsString = CType(txtAddress.Text, String).ToUpper Dim city AsString = CType(txtCity.Text, String).ToUpper Dim state AsString = CType(txtState.Text, String).ToUpper Dim std AsString = CType(txtSTD.Text, String) Dim phNo AsString = CType(txtPhNo.Text, String) Dim faxNo AsString = CType(txtFaxNo.Text, String) Dim email AsString = CType(txtEmail.Text, String).ToUpper Dim url AsString = CType(txtURL.Text, String).ToUpper

Dim updtBy AsString = Session("UserId") Dim strDate = Now.ToString("dd-MMM-yyyy").ToUpper

If txtValidation() Then Try

cmd.CommandText = "update PDEV_MEMB_BODY set BODY_NAME='" +bodyName + "', ADD_BODY='" + addr + "', ADD_CITY='" + city + "', ADD_STATE='"+ state + "', STD_CODE='" + std + "', PHONE_NO='" + phNo + "', FAX_NO='" +faxNo + "', E_MAIL='" + email + "', WEB_URL='" + url + "', UPDATE_DATE='" +strDate + "', UPDATE_BY='" + updtBy + "' where PROF_BODY_CODE='" + bodyCode +

"' "cmd.Connection = myConn

If myConn.State = Data.ConnectionState.Closed ThenmyConn.Open()

cmd.ExecuteNonQuery()setGridView()

Catch ee As ExceptionlblErr.Text = "Error in Updation."

FinallymyConn.Close()


64/132

myConn.Dispose() EndTry EndIf EndSub Function txtValidation() AsBoolean If txtProfBodyName.Text.Length 0 AndNot IsNumeric(txtSTD.Text) ThenlblErr.Text = "STD No is not Numeric."txtSTD.Focus()

ReturnFalse EndIf If txtPhNo.Text.Length > 0 AndNot IsNumeric(txtPhNo.Text) Then

lblErr.Text = "Phone No is not Numeric."txtPhNo.Focus()

ReturnFalse

EndIf If txtFaxNo.Text.Length > 0 AndNot IsNumeric(txtFaxNo.Text) Then

lblErr.Text = "Fax No is not Numeric."txtFaxNo.Focus()

ReturnFalse EndIf

lblErr.Text = "" ReturnTrue EndFunction ProtectedSub DeleteRecord(ByVal sender AsObject, ByVal e As EventArgs) Dim bodyCode AsString = CType(txtBodyCode.Text, String).ToUpper Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.AppSettings( "OraConnString")) Dim cmd As OleDbCommand = New OleDbCommand Try

cmd.CommandText = "delete from PDEV_MEMB_BODY wherePROF_BODY_CODE='" + bodyCode + "' and PROF_BODY_CODE NOT IN(SELECTPROF_BODY_CODE FROM PDEV_CLAIM_INFO) "

cmd.Connection = myConn If myConn.State = Data.ConnectionState.Closed Then myConn.Open() Dim res AsInteger = cmd.ExecuteNonQuery() If res > 0 Then

setGridView()clearAll()

Else

lblErr.Text = "Record is in use, Can not be deleted." EndIf Catch ee As Exception

lblErr.Text = "Error in Deletion." Finally

myConn.Close() EndTry EndSub ProtectedSub DisplayRecord(ByVal bodyCode AsString)


65/132

Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.AppSettings( "OraConnString")) Dim cmd As OleDbCommand = New OleDbCommand Dim dr As OleDbDataReader

cmd.CommandText = "select PROF_BODY_CODE, BODY_NAME, nvl(ADD_BODY,0),nvl(ADD_CITY,0), nvl(ADD_STATE,0), nvl(STD_CODE,'0'), nvl(PHONE_NO,'0'),nvl(FAX_NO,'0'), nvl(E_MAIL,'0'), nvl(WEB_URL,'0'), UPDATE_DATE, UPDATE_BYfrom PDEV_MEMB_BODY where PROF_BODY_CODE = '" + bodyCode + "' "

cmd.Connection = myConn If myConn.State = Data.ConnectionState.Closed Then myConn.Open()

dr = cmd.ExecuteReader() If dr.HasRows Then

dr.Read()txtBodyCode.Text = bodyCodetxtProfBodyName.Text = dr.GetValue(1)

If dr.GetValue(2) = "0"ThentxtAddress.Text = ""

ElsetxtAddress.Text = dr.GetValue(2)

EndIf If dr.GetValue(3) = "0"Then

txtCity.Text = "" Else

txtCity.Text = dr.GetValue(3) EndIf If dr.GetValue(4) = "0"Then

txtState.Text = "" Else

txtState.Text = dr.GetValue(4) EndIf

If dr.GetValue(5) = "0"ThentxtSTD.Text = ""

ElsetxtSTD.Text = dr.GetValue(5)


txtPhNo.Text = "" Else

txtPhNo.Text = dr.GetValue(6) EndIf If dr.GetValue(7) = "0"Then

txtFaxNo.Text = "" Else

txtFaxNo.Text = dr.GetValue(7) EndIf

If dr.GetValue(8) = "0"ThentxtEmail.Text = ""

ElsetxtEmail.Text = dr.GetValue(8)


txtURL.Text = "" Else

txtURL.Text = dr.GetValue(9) EndIf


66/132

ElsetxtProfBodyName.Text = ""txtAddress.Text = ""txtCity.Text = ""txtState.Text = ""txtSTD.Text = ""txtPhNo.Text = ""txtFaxNo.Text = ""txtEmail.Text = ""txtURL.Text = ""

EndIftxtProfBodyName.Focus()dr.Close()myConn.Close()

EndSub ProtectedSub rdbSelect(ByVal sender AsObject, ByVal e As EventArgs) 'Clear the existing selected row

Dim rdb As RadioButton = CType(sender, RadioButton) ForEach gvr As GridViewRow In GridView1.Rows() CType(gvr.FindControl("rdbStatus"), RadioButton).Checked = False

Next 'Set the new selected row Dim row As GridViewRow = rdb.NamingContainer CType(row.FindControl("rdbStatus"), RadioButton).Checked = True Dim lbl As Label = CType(row.FindControl("lblBodyCode"), Label)

DisplayRecord(lbl.Text) EndSub PrivateSub clearAll()

txtBodyCode.Text = ""txtProfBodyName.Text = ""txtAddress.Text = ""txtCity.Text = ""txtState.Text = ""txtSTD.Text = ""txtPhNo.Text = ""txtFaxNo.Text = ""txtEmail.Text = ""txtURL.Text = ""

EndSub

EndClass

PROFESSIONAL CATEGORY DETAILS FORM


67/132

CODING

Imports System.Data.oledb


68/132

Imports System.DateTimePartialClass AddProfBodyCat Inherits System.Web.UI.Page ProtectedSub Page_Load(ByVal sender AsObject, ByVal e AsSystem.EventArgs) HandlesMe.Load If IsPostBack = FalseThen If Session("userID") = ""Then


setBodyNames()setGridView()txtwef.Enabled = False

EndIf

EndSub PrivateSub setGridView()

oleDBAck.SelectCommand = "SELECT PROF_BODY_CODE, MEMB_CAT_CODE,MEMB_CAT_NAME, ENROLL_FEE, ANNUAL_FEE, UPDATE_DATE, UPDATE_BY,to_char(WEF,'DD/MM/YYYY') WEF FROM PDEV_MEMB_CAT_DET where PROF_BODY_CODE='"

+ txtProfBodyCode.Text + "'" EndSub ProtectedSub fillGrid(ByVal sender AsObject, ByVal e AsSystem.EventArgs)

setGridView()txtMembCatCode.Focus()txtwef.Text = Now.Date.ToString("dd-MMM-yyyy").ToUpperclearAll()

EndSub PrivateSub setBodyNames() Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.AppSettings( "OraConnString")) Dim cmd As OleDbCommand Dim dr As OleDbDataReader Dim strsql AsString Try

strsql = "SELECT PROF_BODY_CODE,BODY_NAME FROM PDEV_MEMB_BODYorder by BODY_NAME" If myConn.State = Data.ConnectionState.Closed Then myConn.Open()

cmd = New OleDbCommand(strsql, myConn)dr = cmd.ExecuteReader

If dr.HasRows ThentxtProfBodyCode.DataSource = drtxtProfBodyCode.DataTextField = "BODY_NAME"txtProfBodyCode.DataValueField = "PROF_BODY_CODE"txtProfBodyCode.DataBind()

ElsetxtProfBodyCode.Items.Insert(0, "Select")txtProfBodyCode.Items(0).Value = "Select"

EndIf

Catch ee As ExceptionlblErr.Text = "Error in Selection."

FinallymyConn.Close()myConn.Dispose()


69/132

EndTry EndSub ProtectedSub InsertData(ByVal sender AsObject, ByVal e As EventArgs) Dim bodyCode AsString = CType(txtProfBodyCode.Text, String).ToUpper Dim catCode AsString = CType(txtMembCatCode.Text, String).ToUpper Dim catName AsString = CType(txtMembCatName.Text, String).ToUpper Dim enrollFee AsDouble = CType(txtEnrollFee.Text, Double) Dim AnnualFee AsDouble = CType(txtAnnualFee.Text, Double)

Dim updtBy AsString = Session("UserId") Dim strDate = CType(txtwef.Text, String).ToUpper

Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.AppSettings( "OraConnString")) Dim cmd1 As OleDbCommand = New OleDbCommand Dim cmd2 As OleDbCommand = New OleDbCommand Dim dr As OleDbDataReader Try

cmd1.CommandText = "select MEMB_CAT_CODE from PDEV_MEMB_CAT_DET

where PROF_BODY_CODE='" + bodyCode + "' and MEMB_CAT_CODE='" + catCode + "' "cmd1.Connection = myConn

If myConn.State = Data.ConnectionState.Closed Then myConn.Open()dr = cmd1.ExecuteReader()

If dr.HasRows ThenlblErr.Text = "This Category Already Exists with this

Professional Body."txtMembCatCode.Focus()

ExitSub EndIf Catch ee As Exception

lblErr.Text = "Error in Insertion." Finally

dr.Close() EndTry

Trycmd2.CommandText = "INSERT INTO PDEV_MEMB_CAT_DET(PROF_BODY_CODE,

MEMB_CAT_CODE, MEMB_CAT_NAME,ENROLL_FEE, ANNUAL_FEE, UPDATE_DATE,UPDATE_BY,WEF) VALUES('" + bodyCode + "','" + catCode + "','" + catName + "'," &enrollFee & "," & AnnualFee & ", '" + Format(Now, "dd-mmm-yyyy") + "', '" +updtBy + "','" + strDate + "')"

cmd2.Connection = myConn If myConn.State = Data.ConnectionState.Closed Then myConn.Open() Dim res AsInteger = cmd2.ExecuteNonQuery() If res


70/132

EndSub PrivateSub clearAll()

txtMembCatCode.Text = ""txtMembCatName.Text = ""txtEnrollFee.Text = ""txtAnnualFee.Text = ""lblErr.Text = ""

EndSubEndClass

EDIT/DELETE PROFESSIONAL DETAILS FORM


71/132

CODING

Imports System.Data.oledbImports System.DateTimePartialClass EditProfBodyCat


72/132

Inherits System.Web.UI.Page ProtectedSub Page_Load(ByVal sender AsObject, ByVal e AsSystem.EventArgs) HandlesMe.Load If IsPostBack = FalseThen If Session("userID") = ""Then


SetBodyNames() EndIf

lblErr.Text = ""txtwef.Enabled = False

EndSub PrivateSub SetBodyNames() Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.AppSettings( "OraConnString")) Dim cmd As OleDbCommand Dim strsql AsString Dim dr As OleDbDataReader

Trystrsql = "SELECT PROF_BODY_CODE,BODY_NAME FROM PDEV_MEMB_BODY

ORDER BY BODY_NAME" If myConn.State = Data.ConnectionState.Closed Then myConn.Open()


If dr.HasRows ThentxtProfBodyCode.DataSource = drtxtProfBodyCode.DataTextField = "BODY_NAME"txtProfBodyCode.DataValueField = "PROF_BODY_CODE"txtProfBodyCode.DataBind()setCatNames()

ElsetxtProfBodyCode.Items.Insert(0, "Select")txtProfBodyCode.Items(0).Value = "Select"

EndIf Catch ee As Exception

lblErr.Text = "Error in Selection." Finally

myConn.Close()myConn.Dispose()

EndTry EndSub PrivateSub SetCatNames() Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.AppSettings( "OraConnString"))

Dim cmd As OleDbCommand Dim strsql AsString Dim dr As OleDbDataReader Try

strsql = "select MEMB_CAT_CODE,MEMB_CAT_NAME fromPDEV_MEMB_CAT_DET where PROF_BODY_CODE = '" + txtProfBodyCode.Text + "' " If myConn.State = Data.ConnectionState.Closed Then myConn.Open()


If dr.HasRows Then


73/132

txtMembCatCode.DataSource = drtxtMembCatCode.DataTextField = "MEMB_CAT_NAME"txtMembCatCode.DataValueField = "MEMB_CAT_CODE"txtMembCatCode.DataBind()SetCatDetail()

ElsetxtMembCatCode.Items.Clear()txtMembCatCode.Items.Insert(0, "Select")txtMembCatCode.Items(0).Value = "Select"clearAll()

EndIf Catch ee As Exception

lblErr.Text = "Error in Selection." Finally

myConn.Close()myConn.Dispose()

EndTry EndSub ProtectedSub EditRecord(ByVal sender AsObject, ByVal e As EventArgs) Dim bodyCode AsString = CType(txtProfBodyCode.Text, String).ToUpper

Dim catCode AsString = CType(txtMembCatCode.Text, String).ToUpper Dim enrollFee AsDouble = CType(txtEnrollFee.Text, Double) Dim AnnualFee AsDouble = CType(txtAnnualFee.Text, Double) Dim updtBy AsString = Session("UserId") Dim strDate = Now.ToString("dd-MMM-yyyy").ToUpper Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.AppSettings( "OraConnString")) Dim cmd1 As OleDbCommand = New OleDbCommand Try

cmd1.CommandText = "update PDEV_MEMB_CAT_DET set ENROLL_FEE=" &enrollFee & ", ANNUAL_FEE=" & AnnualFee & ", UPDATE_DATE='" + strDate + "',UPDATE_BY='" + updtBy + "' where PROF_BODY_CODE='" + bodyCode + "' andMEMB_CAT_CODE='" + catCode + "'"

cmd1.Connection = myConn If myConn.State = Data.ConnectionState.Closed Then myConn.Open() Dim res AsInteger = cmd1.ExecuteNonQuery() If res >= 1 Then

lblErr.Text = "Record Saved." EndIf Catch ee As Exception

lblErr.Text = "Error in Editing." Finally

myConn.Close() EndTry EndSub ProtectedSub DeleteRecord(ByVal sender AsObject, ByVal e As EventArgs)

Dim catCode AsString = CType(txtMembCatCode.Text, String).ToUpper Dim bodyCode AsString = CType(txtProfBodyCode.Text, String).ToUpper Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.AppSettings( "OraConnString")) Dim cmd1 As OleDbCommand = New OleDbCommand Try

cmd1.CommandText = "delete from PDEV_MEMB_CAT_DET whereMEMB_CAT_CODE='" + catCode + "' and PROF_BODY_CODE='" + bodyCode + "' andMEMB_CAT_CODE NOT IN(SELECT MEMB_CAT_CODE FROM PDEV_CLAIM_INFO)"


74/132

cmd1.Connection = myConn If myConn.State = Data.ConnectionState.Open Then myConn.Close()

myConn.Open() Dim res AsInteger = cmd1.ExecuteNonQuery() If res


75/132

txtAnnualFee.Text = ""txtwef.Text = ""lblErr.Text = ""

EndSub

EndClass

CLAIM FORM


76/132

CODING

Imports System.data.OleDbPartialClass claim Inherits System.Web.UI.Page Dim Flag1 = 0


77/132

ProtectedSub Page_Load(ByVal sender AsObject, ByVal e AsSystem.EventArgs) HandlesMe.Load

TextBox2.Text = Session("userID") Dim EMPNO AsInteger = TextBox2.Text Dim strsql AsString Dim strsql1 AsString

Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings( "ConnectionString2").ToString)

Try Dim dr As OleDbDataReader Dim cmd1 As OleDbCommand = New OleDbCommand Dim cmd2 As OleDbCommand = New OleDbCommand

strsql = "Select * from PASSWORD1 WHERE EMPNO= " & EMPNO & ""myConn.Open()

cmd1.CommandText = strsqlcmd1.Connection = myConndr = cmd1.ExecuteReader()

If dr.HasRows Thendr.Read()TextBox1.Text = dr.GetValue(2)TextBox3.Text = dr.GetValue(3)TextBox4.Text = dr.GetValue(4)

EndIfdr.Close()

Catch ex As ExceptionTextBox7.Text = "Error in loading"

FinallymyConn.Close()

EndTry EndSub

ProtectedSub Button1_Click(ByVal sender AsObject, ByVal e AsSystem.EventArgs) Handles Button1.Click Dim NAME AsString = CType(TextBox1.Text, String) Dim EMPNO AsInteger = CType(TextBox2.Text, Integer) Dim DESC AsString = CType(TextBox3.Text, String) Dim DPTNO AsString = CType(TextBox4.Text, String) Dim PURPOSE AsString = CType(RadioButtonList1.SelectedValue, String) Dim PERSON AsInteger = CType(TextBox5.Text, Integer) Dim da_te AsString = CType(TextBox6.Text, String) Dim Meals AsInteger = CType(MS.Text, Integer)

Dim otr_exp AsInteger = CType(OT_EXP.Text, Integer) Dim TIP AsInteger = CType(Tips.Text, Integer)

TextBox10.Text = Meals + otr_exp + TIP Dim total AsInteger = TextBox10.Text Dim Adv_drawn AsInteger = CType(TextBox11.Text, Integer) Dim Bal_due AsInteger = CType(TextBox12.Text, Integer) Dim UN_bal AsInteger = CType(TextBox13.Text, Integer) Dim dat_e AsString = CType(TextBox14.Text, String) Dim BUDGET AsInteger = CType(TextBox15.Text, Integer) Dim F_year AsInteger = CType(TextBox16.Text, Integer)


78/132

Dim Cum_Amnt AsInteger = CType(TextBox17.Text, Integer)

Dim myConn As OleDbConnection = NewOleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings( "ConnectionString2").ToString) Dim strsql AsString Dim cmd1 As OleDbCommand 'Dim tmstr As String

myConn.Open() Try

strsql = "INSERT INTOclaim(NAME,EMPNO,DESG,DEPT,NOP,CDATE,MEAL_EXP,OTHER_EXP,TIPS,TOTAL,ADVANCE,UNBAL,UBDATE,BUDGET,YEAR,CAMNT,PURPOSE,MEALS)VALUES ('" + NAME + "' , " + EMPNO.ToString + ",'" + DESC + "', '" + DPTNO +"'," + PERSON.ToString + ",'" + da_te + "'," + Meals.ToString + "," +otr_exp.ToString + "," + TIP.ToString + ", " + total.ToString + "," +

Adv_drawn.ToString + ", " + UN_bal.ToString + ",'" + dat_e + "'," +BUDGET.ToString + "," + F_year.ToString + "," + Cum_Amnt.ToString + "," If (RadioButtonList1.SelectedValue = "B") Then

strsql = strsql + "'BusiMeet'" ElseIf (RadioButtonList1.SelectedValue = "O") Then

strsql = strsql + "'OfficeMeet'" EndIf

strsql += ","

If (breakfast.Checked = TrueAnd tea.Checked = TrueAndlunch.Checked = TrueAnd dinner.Checked = True) Then

strsql = strsql + "'breakfast,tea,lunch,dinner'" ElseIf (breakfast.Checked = TrueAnd tea.Checked = TrueAndlunch.Checked = True) Then

strsql = strsql + "'breakfast,tea,lunch'" ElseIf (breakfast.Checked = TrueAnd tea.Checked = TrueAnddinner.Checked = True) Then

strsql = strsql + "'breakfast,tea,dinner'" ElseIf (tea.Checked = TrueAnd lunch.Checked = TrueAnddinner.Checked = True) Then

strsql = strsql + "'tea,lunch,dinner'" ElseIf (breakfast.Checked = TrueAnd lunch.Checked = TrueAnddinner.Checked = True) Then

strsql = strsql + "'breakfast,lunch,dinner'" ElseIf (breakfast.Checked = TrueAnd tea.Checked = True) Then

strsql = strsql + "'breakfast,tea'" ElseIf (lunch.Checked = TrueAnd tea.Checked = Tru

project repo

Documents