Software Engineering Project with UML diagrams for a database system of employees made using HTML, CSS as front end and PHP and SQL as backend. Note that this is just the SRS or Software Re…Full description
Full description
Full description
Akk hereFull description
leave management systemFull description
Employee Management SystemFull description
project in c++ about employee management system
Full description
The aim of our project is to develop a system that is meant to partially computerize the work performed in the Employee Management System. In this software we can add employee details according to ...
The aim of our project is to develop a system that is meant to partially computerize the work performed in the Employee Management System. In this software we can add employee details according to ...
The "EMPLOYEE MANAGEMENT SYSTEM" has been developed to override the problems prevailing in the practicing manual system. This software is supported to eliminate and in some cases reduce the hardshi...Full description
Enterprise system for managementFull description
Employee Management SyatemFull description
Employee Payroll System made in JAVAFull description
B.tech 4th minor project documentationFull description
its a project on student record
this is a abstract for placement mangement system project using java
Hotel management system - SRS documentFull description
SRS in IEEE format
a system report on resort management system .
SRS in IEEE format
Full description
Employee Management System for DGLW
by
Shahida Tarannum
Submitted in partial fulfillment of the requirements of the degree of
M. Sc. Tech Industrial Mathematics Mathematics with Computer Application
to the
DEPARTMENT OF MATHEMATICS FACULTY OF NATURAL SCIENCES JAMIA MILLIA ISLAMIA NEW DELHI-110025 July 2007
GOVERNMENT OF INDIA MINISTRY OF COMMUNICATION & INFORMATION TECHNOLOGY DEPARTMENT OF INFORMATION TECHNOLOGY
NATIONAL INFORMATICS CENTER This is to certify that Ms Shahida Tarannum Student ID No. 9857,a student of M.Sc. Tech Industrial Industrial Mathematics with Computer Computer Applications Applications from Jamia Jamia Millia Islamia, New Delhi has done her full-semester project training at Labour Information Systems Division, NIC, New Delhi, from 01/03/07 to 10/07/07. The project work entitled “ Employee Management System ” embodies the work done by Ms Shahida Tarannum during her above full semester project training period.
PROJECT GUIDE/HOD
Head, Training Division
2
ACKNOWLEDGEMENT
First of all, let me thank the Almighty God and my Parents who are the most graceful and merciful for their blessing that Contributed to the successful completion of my project. I would like to take this opportunity to express my profound sense of gratitude and respect to all those who helped me throughout the duration of this project. The Jamia Millia Islamia, in particular has been the source of inspiration for me. I acknowledge the effort of those who have contributed significantly to my project. I express my sincere gratitude and thankfulness towards Prof. Mohd. Rais Khan, Head, Department of Mathematics, Mathematics, Jamia Millia Islamia Islamia for his valuable valuable time and guidance throughout throughout this course. I feel privile privileged ged to offer offer my sincere sincere thank thankss and deep deep sense sense of gratitu gratitude de to
Mrs. Mrs.
Rachna Rachna Shrivastava Shrivastava,, Technical Technical Director Director NIC, Mrs J.R.D J.R.D Kailey, Kailey, Senior Senior Technical Technical Director NIC, NIC, Mr. Alok Roy, Scientist D, NIC, for expressing their confidence in me by letting me work on a project of this magnitude and using the latest technologies and providing their support, help & encouragement in implementing this Project. I would like to express my sincere gratitude towards all my teachers, especially Dr. Muha Muhamm mmad ad Abul Abulai aish sh for for thei theirr skil skillf lful ul Teac Teachi hing ng,, prec precio ious us sugg sugges esti tion onss and and encouragements. Last but not the least I would like to mention the name of Prof. Sharfu Sharfuddi ddin n Ahmed Ahmed for his tremend tremendous ous helpin helping g nature nature.. I regret regret any inadve inadverten rtentt omissions.
Shahida Tarannum
3
ABSTRACT
A well well planne planned, d, system systematic aticall ally y execut executed ed indust industria riall trainin training g helps helps a great great deal deal in inculc inculcatin ating g a good good work work cultur culture. e. It provid provides es a linkag linkagee between between students students and the industry in order to develop awareness of the industrial approach to problem solving based on broad understanding of operations of the industrial organizations. This project entitled “Employee Management System ” has been designed towards improving the Management of Employee Information in the f ield offices of DGLW. It maintains Seniority, Leave Records, Transfer & Postings and other basic information of Employee. Various MIS reports can be generated through it Viz. Leave Order, Seniority List, Vacancy Position and CR Status etc. It is a web-based application; it will be accessed simultaneously from many field offices of DGLW. Field offices are suppos supposed ed to enter enter inform informati ation on of Employ Employee ee of their their region region.. This This inform informati ation on is compiled and used at Headquarter Level for MIS purposes. The project has been an enriching experience for me in the field of programming and Enterprise Application development. The project has been developed to fulfill the requirements of the Employees in Labour Ministry. The tools and technologies used for developing the software are ASP for analysis and design phases for developing the code for the application and SQL SERVER as the back end tool on Microsoft Mic rosoft windows 2000 platform.
1.1 Background 1.2 Motivation 1.3 Organization 1.3.1 National Informatics Center 1.3.2 Labour information System Division 1.4 Realization of the Problem 1.5 Broad outline of work
1 1 1 2 4 4 5
Formulation……………………………… …………………………… ………… 2. Problem Formulation……………
6
2.1 Detailed Description of the Project 2.1.1 Major Functions 2.2 Methodology used for Carrying out the Study 2.3 Business Process 2.4 Existing System 2.5 The Proposed System
6 7 7 8 8 8
Design………………………………….. ….. 3. System Analysis and Design………………………………
9
3.1 3.1 Defi Defini ning ng a Syst System em 3.1.1 System Lifecycle 3.1.2 System Analysis 3.2 An Analysis and Development of the Actual System 3.3 Project Overview 3.3.1 Product Prospective 3.3.2 User Interface 3.3.3 Hardware and Software Interface 3.3.4 Memory Constraints 3.3.5 Product Functions 3.4 Constraints 3.4.1 General Constraints 3.4.2 Hardware Constraints 3.4.3 Security Constraints 3.4.4 Assumptions and Dependencies 3.5 Feasibility Study 3.5.1 Technical Feasibility 3.5.2 Operational Feasibility
9
11 11 11 11 12 12 12 12 12 13 13 13 14 14 15
5
3.5.3 Economic Feasibility 3.5.4 Legal Feasibility 3.6 Information Gathering 3.6.1 Information about Project 3.6.2 Information Sources 3.7 DFD’s 3.8 Processing Logic 3.8.1 Reports Generated by the System 3.8.2 Data Structures 3.9 Application Architecture 3.10 Database Architecture 3.11 Input Output Specification 3.11.1 Screen Layout 3.11.2 Navigation (Menu description) 3.11.3 Help Facilities 3.11.4 Error Messages 3.12 Choices of Tools and Technologies 3.12.1 ASP 3.12.2 ASP Programming 3.12.3 Parsing ASP Code 3.12.4 Connecting to Database
Conclusion……………………………… ………………………… ……… 5. Result and Conclusion…………… 5.1 Conclusions 5.2 Future Scope of Improvement
53 53 53
Annexures………………………………………………………
6
A. B. C. D. E. F.
Sample Forms Sample Reports Sample code List of Common Validations Definition Glossary Bibliography
54-91 92-103 104-126 127 128 129
7
CHAPER 1 INTRODUCTION This section presents the background and motivation of the system that has been designed and prototyped in this project. The section also reviews the objective of the project.
1.1Background In terms of background the Employee Management System for DGLW project referred referred as Direct Directora orate te Genera Generall of Labou Labourr Welfare Welfare.. Labour Labour Inform Informati ation on System Systemss Division (LISD) of NIC is actively involved in development of the application for Directorate General of Labour Welfare (DGLW). DGLW has its Headquarter in Delhi Delhi and its field field office officess are spread spread across across the countr country. y. Syste System m mainta maintains ins the information regarding Human Resources through field offices. So, that manpower can be monitored at Headquarter. The application software takes care of database and day to day operations. For the ease of the user the web-based application is developed using ASP and SQL server in the back .The different modules were added to the system as per DGLW Desk requirement and are being integrated into this web-based application.
1.2
Motivation
Reali Realizi zing ng a high higher er need need of deve develo lopm pment ent effo efforts rts and and the the inve invest stme ment nt of time time,, developing uniform, more user-friendly application software for
implementation.
With keeping use in mind, supporting existing business process of DGLW appears as a fruitful concept for adding more value through a web based application. There by increasing quality of services offered.
8
1.2Organization 1.3 1.3 This This sect sectio ion n list listss the the name name of the the orga organi niza zatio tion n for for whic which h we desi design gned ed and and prototyped this project.
1.3.1 National Informatics center (NIC) National Informatics Centre (NIC) of the Department of Information Technology is providing network backbone and e-Governance support to Central Government, State Governments, UT Administrations, Districts and other Government bodies. It offers a wide wide range range of ICT servic services es includ including ing Nation Nationwid widee Commun Communicat ication ion Network Network for decentralized planning, improvement in Government services and wider transparency of nati nation onal al and and local local Gove Govern rnme ment nts. s. NIC assi assist stss in impl implem emen enti ting ng Info Inform rmat atio ion n Technology Projects, in close collaboration with Central and State Governments, in the areas of (a) Centrally sponsored schemes and Central sector schemes, (b) State sector sector and State State sponso sponsored red project projects, s, and (c) Distri District ct Admini Administr stratio ation n sponso sponsored red projects. NIC endeavors to ensure that the latest technology in all areas of IT is available to its users. NIC Headquarters Headquarters is based in New Delhi. At NIC Headquarters, a large number of
Application Divisions exist which provide total Informatics Support to the Ministries and Departm Department entss of the Centra Centrall Govern Governmen ment. t. NIC comput computer er cells cells are located located in almos almostt all the the Mini Minist stry ry Bhav Bhavan anss of the the Cent Central ral Gove Govern rnme ment nt and and Apex Apex Offic Offices es including the Prime Minister’s Office, the Rashtrapati Bhawan and the Parliament House. Apart from this, NIC has various Resource Divisions at the Headquarters, which specialize specialize into different different areas of IT and facilitate facilitate the Application Application Divisions Divisions as well as other NIC Centers in providing state-of-the-art services to the Govt. State level level, NICs At the the State NICs State/ State/UTs UTs Units Units provid providee inform informati atics cs suppor supportt to their their
respective State Government and at the District level laid the NIC District Informatics Offices. NIC has conceptualized, developed and implemented a very large number of projects for various Central and State Government Ministries, Departments and Organizations. Many of these projects are continuing projects being carried out by various divisions of NIC at New Delhi Headquarters and State/District centres throughout the country.
9
Some of the most important note worthy projects, which offer a glimpse of the multifaceted, diverse activities of NIC, touching upon all spheres of e-governance and thereby influencing the lives of millions of citizens of India are given below: •
Agricultural Marketing Information Network (AGMARKNET)
•
Central Passport System
•
Community Information Centers (CICs)
•
Computerized Rural Information Systems Project (CRISP)
•
Court Information System (COURTIS)
•
Department of Agriculture Network (DACNET)
•
Examination Results Portal
•
India Image
•
Land Records Information System (LRIS)
•
National Hazardous Waste Information System (NHWIS)
•
Public Grievance Redress and Monitoring System (PGRAMS)
•
Spatial Data Infrastructure (SDI)
•
Training
•
Video Conferencing Web Site of NIC
http://indiaimage.nic.in/
10
1.3.2 Labour Information System Division LISD, a unit of NIC is assisting various organizations under the ministry of Labour in identifying the computerization needs to improve efficiency and overcome difficulties in manual system, preparing system specifications, developing software for identified application application system and organizing organizing training training for computerized computerized operations operations and their applic applicatio ation n system system.. The The NIC-MO NIC-MOL L comput computer er center center in ShramS ShramShak hakti ti Bhavan Bhavan is connected connected to countrywid countrywidee NIC network (NICNET) (NICNET) through through communicat communication ion lines. lines. LISD LISD has already already initia initiated ted comput computeriz erized ed in areas areas of Indust Industrial rial Relati Relations ons,, Labour Labour welfa welfare, re, Socia Sociall Secu Securi rity ty,, Labo Labour ur Stat Statis istic ticss and and Empl Employ oyme ment nt and and Manp Manpow ower er Information. NIC-MOL Computer center is connected to NICNET, India’s First satellite based operational network, which has over 750 odes geographically distributed all over the countr country y connec connectin ting g all distric districts, ts, State/ State/UT UT capita capitals ls and Centra Centrall Govt. Govt. Minist Ministrie riess /Departments for information exchange. The NIC-MOL computer center has also been connected to the Internet and a separate Internet address has been given for Labour Ministry.
1.4
Realization of the Problem
The Present system is manual and thus it is not user friendly. The proposed system DGLW will be implemented as an Intranet application. The application software will be hosted on the MOLDB (Ministry of Labour & Employment Database server) web server located at NIC Computer Cell, Ministry of Labour, Shram Shakti Bhawan, Rafi Marg, New Delhi. The application software will be developed in ASP, JavaScript, VB Script and HTML. The central database is based on MS SQL Server 2000. The system can be accessed over the Intranet connecting all the Intranet of Ministry of Labour & Employment nodes. Clients equipped with web-browsers can access the system from any of the Intranet Nodes. The function of the system will be managing Employees at various field offices from the Head Quarter .It manages information about Employees of DGLW at various Field Field office offices. s. It manage managess inform informati ation on regard regarding ing Human Human Resour Resources ces throug through h field field offices. So, that manpower can be monitored at Head Quarter.
11
1.5 Broad outline of work Chapter 1> This chapter has introduced the problem along with brief description of
the project. Chapter 2> The second chapter describes describes the problem formulation. formulation. What is need of
work? Chapter 3> This chapter deals with analysis and design of the system, application of
new system, the hardware and software requirements for implementing the system and stating the choice of the language used. This chapte chapterr discus discusses ses the impleme implementa ntatio tion n part part of the syste system. m. The Chapter Chapter 4> This hardware and software requirement for implementing the system have been discussed. The operation manual and input requirement to the system have also taken up in this chapter. Chapter 5> This chapter deals with result and discussion of the new system, stating
interpretation of the results, importance of the work.
12
CHAPTER 2 PROBLEM FORMULATION Introduction Prob Problem lem intr introd oduc ucti tion on or prob problem lem stat statin ing g is the the start startin ing g poin pointt of the the soft softwa ware re development activity. The objective of this statement is to answer: Exactly what must
the system do? The software project is initiated by the client’s need. In the beginning, these needs are on the minds of various people in the client’s organization. The analyst has to identify the requirements by talking to the people and understanding to their needs .it gores without saying that an accurate and through understanding of Software requirements are essentials to the success of software development effort. all further further development development like system system analysis, analysis, System design and coding coding will depend on how accurate and well understood the requirements are poorly analyzed and specified software will disappoint the user and will bring brief to the developer. No matter how well designed and well coded the software is. Software requirement appears to be a rela relati tive vely ly sim simple ple
tas task, but appe appear aran ance cess
are are
ofte often n
dece deceiv ivin ing. g. Chan hances ces
of
misint misinterp erpreta retatio tion n are very very high, high, ambigu ambiguity ity is probab probable le and commun communica icatio tion n gap bet betwe ween en cust custom omer er and and deve develo lope perr is boun bound d to brin bring g conf confus usio ions ns.. Requ Requir irem emen entt understanding begins with a clear and concise heading stating in a sentence the task to be performed. Then Requirements are described in a technical manner in precise statements.
2.1
DETAILED DESCRIPTION OF THE PROJECT
Labour Information Systems Division of NIC is actively involved in development of the application for Directorate General of Labour Welfare. In all, application systems were to be developed and implemented at CLC Division in Labour Ministry. System maintains the information about the Employee records, it maintain the each and every record about the employee regarding their posting, leave, vacancy position etc., it maintains the details of all Employees located at various field offices. The application softwa software re takes takes care of databa database se and day-to day-to-da -day y operati operations ons.. DGLW (Directorate
13
General of Labour Welfare) has its Headquarter in Delhi and its field offices are spread across the country. This project will help in capturing information regarding Human Resources through field offices. So, that manpower can be monitored at Head Quarter. For the ease of the user and for the public the existing systems were migrated to web-based applications.
2.1.1 Major Functions 1.
Employee Management
The function of the system will be managing Employees at various field offices from the Head Quarter .It manages information about Employees of DGLW at various Field Field office offices. s. It manage managess inform informati ation on regard regarding ing Human Human Resour Resources ces throug through h field field offices. So, that manpower can be monitored at Head Quarter.
2.2
METHODOLOGY TO BE USED CARRYING OUT THE STUDY •
Studyi Studying ng the existi existing ng system system.. This This will will involv involvee the amount of information, the manpower equipment space and other resources used for the information storage.
•
After After analys analysing ing the existi existing ng setup setup this this study study would would sugges suggestt a new manage managemen mentt setup. setup. The benefits benefits and disadv disadvant antage agess of existi existing ng and new system system would would be critically revised.
•
Cost Benefit Analysis study will done.
•
The database structure and information storage retrieval process will also be studied and a new system for faster response response using operation operation research techniques techniques will be designed.
2.3
BUSINESS PROCESSES
2.4
Existing System
14
The existing system comprises of a system in which details are to be manually handled. This is not user friendly.
2.5
The proposed system
It will be able to manage information about Employee in more user fr iendly way. This system will manage Employees information at various field offices. User ID and password has been given to all the field offices so that they can enter their employee’s information information into central database. Their access to the central database is restricted restricted to their information only. Various reports based on the data entered by employees at field offices are generated at Head Quarter. These reports are helpful in Manpower management decisions.
15
CHAPTER 3 SYSTEM ANALYSIS AND DESIGN 3.1Defining A System Collections of components, which are interconnected, and work together to realize some objective, form a system. There are three major components in every system, namely input, processing and output.
Input
Output
Processing
3.1.1 Systems Life Cycle The sequencing of various activities required for developing and maintaining systems in an ordered form is referred as Systems Life Cycle. It helps in establishing a system pro proje ject ct plan plan as it give givess overa overall ll list list of proc proces esss and and subsub-pr proc oces esse sess requ requir ired ed for for developing any system. system. Here, the systems life cycle will be be discussed with reference to the development of Employee Management System. Broadly, following are the different activities to be considered while defining the systems development cycle for the said project:
Problem Definition
Systems analysis
Study of existing system
Drawbacks of the existing system
16
Proposed system
Systems Requirement study
Data flow analysis
Feasibility study
Systems design
Input Design (Database & Forms)
Updation
Query /Report Design
Administration
Testing
Implementation
Maintenance
3.1.2 System Analysis System analysis is a logical process; the objective of this phase is not actually to solve the problem but to determine what must be done to solve the problem. The basic objective of the analysis stage is to develop the logical model of the system using tools such as the data flow diagram and elementary data description of the elementary algorithm. The logical model is Subject to review by both the management and the user who agree that the model does in fact reflect what should be done to solve the problem. System analysis is not a precise science. It is in fact more of an art, aided by scientific approach to find definition and recording data, gathering traditional structures is only one part of the system analysis, the next step is to examine the data, assess the situation and looking at the alternatives.
3.2
Analysis Analys is and development develo pment of the actual actua l solution solutio n
17
A complete understanding of the requirement for the new system is very important for the successful development of a software product. Requirement Specification is the foundation in the process of software development .All further developments like syst system em anal analys ysis is;; desi design gnin ing g and and codi coding ng will will depe depend nd on how how accur accurat atee and and well well docu docume ment nted ed
the the
Requ Requir irem emen entt
Spec Specif ific icat atio ion n
is. is.
Requirement specification appears to be a relatively simple task, but appearance is ofte often n dece deceiv ivin ing. g.
There There is alwa always ys a chan chance ce of wron wrong g speci specifi fica catio tion n beca becaus usee of
communicati communication on gap between the user and the Developer. Developer. Requirement Requirement Specification Specification begins with a clear statement of the problem and the task to be performed. Then the requirement is described in a technical manner in precise statements. After the initial specification specification reports are received, received, they are analyzed and redefined redefined through customer interaction.
3.3
Project Overview
3.3.1 Product prospective It will be able to manage information about Employee in more user fr iendly way. This system will manage Employees information at various field offices. User ID and password has been given to all the field offices so that they can enter their employee’s information information into central database. Their access to the central database is restricted restricted to their information only. Various reports based on the data entered by employees at field offices are generated at Head Quarter. These reports are helpful in Manpower management decisions.
3.3.2 User Interface
The system will be having user privileges based menu.
User will have to select the options form the given menu.
The system will be entering the information into the database to generate
reports.
The forms will be designed to enter the data.
18
Buttons will be used to insert, retrieve or modify the data.
Link Linkss will will be prov provid ided ed to shif shiftt from from one one form form to another.
3.3.3 Hardware – Software Interface An Internet Web Server, running IIS, in this case Windows 2000 advanced server is used to host the application. The application software, Employee Management, is developed in ASP, JavaScript, and HTML. The backend database is MS SQL Server 2000. The Client systems with internet facility equipped with web browser will be able to access the system
3.3.4 Memory Constraints No memory constraints are applicable. A normal memory configuration is more than sufficient.
3.3.5 Product Function It is advisable to have weekly data backups. The system administrator will do the data recovery. Selection of panel is user-initiated operation, while indent handling is client initiated
3.4
Constraints
3.4.1 General Constraints 1) This This system system will will not not take take care care of any virus virus probl problem em,, which might occur either on the client or the server syst system em.. Avoi Avoidi ding ng the the use use of pira pirated ted softw softwar aree and and ensuring that floppies and other removable media are scan scanne ned d for for viru viruse sess befo before re use use coul could d mini minimi mize ze the the possibility of viral infection.
19
2) Recove Recovery ry of data data after a syste system m crash crash will be possi possible ble only if backups are taken at regular intervals. 3) Manual Manual interfaces interfaces cannot cannot be fully fully avoided avoided.. Document Documented ed proofs like dates etc. will have to be verified by the concerned staff before entering it into the computerized system
3.4.2
Hardware Constraints
Cons Constr trai aint ntss of the the Inte Intern rnet et & Intr Intran anet et will will be appl applic icab able le to the the syst system em.. The The performance of the system will be dependent on the network conditions like network congestion, bandwidth etc. The primary memory (RAM) and the secondary memory (Hard Disk Space) requirement of the system at the client end will be the same as that required by the web browser and the operating system. At the server end memory requi require reme ment ntss will will be that that of the the serv server er soft softwa ware re (Opera (Operati ting ng syst system em,, Data Databa base se Software, etc) and the space required to store the data. The space required to store the data would increase as more and more records are added to the system.
3.4.3 Security Constraints User will be authenticated by the use of username and passwords. This does not Provide complete security and the system could be hacked into. Use of secure Socket Layer (SSL) is recommended. Use of SSL prevents any unauthorized access as all communications are encrypted. Valid Digital Certificates are required for this at the server end and the client web browser should have support for SSL.
3.4.4 Assumptions and Dependencies
20
1. It is assumed that the user is familiar with the basic computer fundamentals. 2. Time Timely ly back backup up of of data data shoul should d be taken to avoid data loss in case of system crash. 3. The
use of pirated software
should be avoided as it may lead to data loss and system crashes due to viral infections. 4. Flop loppies pies and and oth other rem removabl vablee medi mediaa shou should ld be scan scanne ned d for for viruses before use. 5. Proper Proper conf configu igurat ration ion of of the the client client,, databa database se server server and networ network k is necess essary
for for
the
system
to
function as intended. 6. It
is
assumed
that
the
maintenance of the database will be be assi assign gned ed to the the auth author oriz ized ed person only. 7. Only Only autho authori rize zed d pers person onss will will be allowed inside the server room.
3.5
Feasibility Study
The main main object objective ive of the feasibi feasibilit lity y study study is to treat treat the technic technical, al, Operat Operation ional, al, logical and economic feasibility of developing the computerized system. All systems are feasible, given unlimited resources and infinite time. It is both necessary and prudent to evaluate the feasibility of the project at System study phase itself. The feasibility study to be conduced for this project Involves. 1. Technical Feasibility
3.5.1 Technical Feasibility Techni Technical cal feasibi feasibilit lity y includ includes es Risk Risk Resour Resources ces availa availabil bility ity and technol technologi ogies. es. The manage managemen mentt provid provides es latest latest hardwa hardware re and softwa software re facilit facilities ies for the succes successfu sfull comple completion tion of the projec projects. ts. With With these these latest latest hardwa hardware re and software software suppor supportt the system will perform extremely well. The system is available through Internet.
3.5.2 Operational Feasibility In the existing manual system it is very difficult to maintain and update huge amount of info inform rmat atio ion. n. The The deve develo lopm pmen entt of the the syste ystem m was was star starte ted d beca becaus usee of the the requir requireme ement nt put forward forward by the manage managemen mentt of the concern concerned ed departm department ent.. This This system, will handles the request in a better way and make the process easier thus, it is sure that the system developed is operationally feasible.
3.5.3 Economic Feasibility In the economic feasibility the development cost of the system is evaluated weighing it against the ultimate benefit derived from the new system. It is found that the benefit, from the new system would be more than the cost and time involved in its development.
3.5.4 Legal Feasibility In the legal feasibility it is necessary to check that the software we are going to develop is legally correct which means that the ideas which we have taken for the proposed system will be legally implemented or not. So, it is also an important step in feasibility study.
3.6
Information Gathering
22
We have taken an approach of gathering information with sensitivity and precautions.
3.6.1 Information about project: During the analysis, we collected whole information from “Mr. Alok Roy”, Scientist ‘D’, NIC, and staff members of the DGLW, Labour ministry, New Delhi.
3.6.2 Information Sources: We have collected the information about the current system from: 1. Reports 2. Personal staff 3. System Documentation 4. Trainees 5. Existing System
Region, Station, Emp_name , Emp_ID Listing Employee s
Region,Station, Emp_name,Emp_I D Find particular EmployeeC R entry
Update EmployeeCR entry
Emp_ID,Cry ear,Received, remarks EmployeeCR
Emp_ID,E mp_name
Employee
Add new entry of EmployeeC R
Emp_ID,Cry ear,Received, remarks
User
29
3.8
Processing Logic
The Employee Management System has been designed and developed for various field offices of DGLW to capture the information about human resources. Various details details about the Employee Employee is entered in the system system with all details like Employee Employee name, Designation, Date of birth, Station, Region, seniority, etc. There are some major activities which is taking care by the Employee Management System.
•
Employee Management System
All of the Employee record such as his name, designation, Region of posting, station of posting, his salary detail, seniority level, date of joining, qualification etc., is entered entered into into the comput computeriz erized ed syste system m by the Employ Employees ees at variou variouss Region Regional al Offices.
DGLW Vacancy Position Information
This file contains the information regarding Vacancy Position at various regional offices offices.. Such Such as statio station, n, sanctio sanctioned ned streng strength, th, number number of perman permanent ent filled filled posts posts,, number of temporary filled posts etc,
DGLW Employee detail
This file stores multiple information of Employee. Each employee has a separate record record regard regarding ing his basic basic inform informatio ation n such such as his design designatio ation, n, region region of postin posting g ,basic salary, seniority level, DOB, date of joining, date of retirement, qualification etc.,.
DGLW Employee Posting/Transfer detail
After After some some certain certain specifi specified ed time time employ employees ees are Posted Posted/Tr /Trans ansfer ferred red to differe different nt Stations of different Regions this file keep track of Posting/Transfer record of the Employees. On giving these details, some reports and queries are generated by the system.
30
3.8.1 Reports Generated Generated by the System (a) (a)
List List of of Vaca Vacanc ncy y Deta Detail il des desig igna nati tion on wis wisee
(b) (b)
List List of Vaca Vacanc ncy y Det Detai aill Reg Regio ion n wis wisee
(c) (c)
List List of of Vacan Vacancy cy Deta Detail il Reg Regio ion n and and Desi Design gnat atio ion n wise wise
(d)
Vacancy Position Report for a particular Region, Station, Designation
(e) (e)
Vacan Vacancy cy Pos Posit itio ion n Repo Report rt for for a part particu icula larr Regi Region on
(f)
Vacancy Vacancy Posit Position ion Report Report for a part particu icular lar Design Designati ation on
3.8.4
Data Structures
The Database Database DGLW contai contains ns the tables tables that that contai contain n the inform informati ation on related related to system and the data needed to run the software. The tables are discussed in detail: Directorate General of Labour Welfare (DGLW) 1. BalanceL ceLeave
:Tabl able con contains the information of balance leav eaves of the
Employee 2. Payscale
:Table contains information of Employee’s basic salary,
increment 3. Defaults
: Table contains default information about Employee
4. EmpAddress ess
: It It contains th the Address of all Em Employee
5. Employ Employee ee
: contai contains ns all the inform informati ation on about about employ employee ee regard regarding ing his date date
of joining, seniority, posting region and all other 6. EmployeeC EmployeeCR R
: Table contains contains information information about Employee’s Employee’s CR 7. GnrlCode
: Code directory of Designation
8. GnrlDir
:Table contains of code directory
9. Leave
: Table contains information about leave
10. LeaveA LeaveAppl pplicat ication ion : Table Table contai contains ns record record of the applic applicatio ation n applied for leave
31
11. Leo
:
Table
contains
basic
information
about
Employee 12. Menuta Menutable ble
: Table Table contai contains ns the Menu Menu item item for dynami dynamicc
generation 13.
Posting
: Ta T able co c ontains in i nformation ab a bout
Employee’s posting at various Regions 14. Region Region
: Region Region code directory directory
15. SectionPosting
: Di Division co code di directory
16. Station
: Station code directory
17. 17. Stat Status usLe Leav avee
: Table Table conta contain inss inform informat atio ion n about about stat status us of the the
leave taken 18.
UserTable
: Table contains the information of
various users of the Software 19.
VacancyPosition : Table contains information about vacancy
position at various Regions
3.9
Application Architecture
Most of the user’s database system today is not present at user premises, but clients connect to it through a network. We can therefore differentiate between client and server machine. In our system the information about personnel and post exist in the central database. But it need to be accessed from DGLW offices all over India so that employees can view, enter or modifies their personal information through their user-id and password. This can be done only through web based application architecture, as shown in the next page.
32
User
Application Client (Employees)
Application Server
Database System
Fig: 3. 3.0
Three –t –tier Ar Architecture
33
34
Tables used:
3.10 Database Architecture
Fig: 3.1
Table: BalanceLeave
Fig: 3.2
Table: Paysclale
35
Fig: 3.3
Table: Defaults
Fig: 3.4
Table: EmpAddress
36
Fig: 3.5
Table: Employee
Fig: 3.6
Table: EmployeeCR
37
Fig: 3.7
Table: GnrlCode
Fig: 3.8
Table: GnrlDir
38
Fig: 3.9
Table: Leave
Fig: 3.10
Table: LeaveApplication
39
Fig: 3.11
Table:LEO
Fig: 3.12
Table: Me MenuTable
40
Fig: 3. 3.13
Table:Posting
Fig: 3.14
Table: Region
41
Fig: 3.15
Table: Se SectionPosting
Fig: 3.16
Table: Station
42
Fig: 3.17
Table: StatusLeave
Fig: 3.18
Table: Us UserTable
43
Fig: 3. 3.19
Table: Va VacancyPosition
44
45
46
3.11 Input / Output Specification 3.11.1 Screen Layouts For Screen layouts refer annexure Forms Layouts.
3.11.2 Report Layout For report layout refer annexure Report Layouts.
3.11.3 Navigation (Menu Description) From the DGLW Portal the user will login by given userID and password in the login dialogue box. After user validation the system will display the customized home page and menu options depending upon user roles and access permissions.
3.11 3.11.4 .4 He Help lp Faci Facili liti ties es Document has user manual to the user separately. On line User Manual has not been planned yet.
3.11.5Error Messages Messages Suitable error messages should be flashed on error arising from Data inputs, which is easily understood by the user.
3.12 3.12 Choi Choice ce of Too Tools ls and and Tec Techn hnol olog ogie iess Introduction Technologies and tools are strongly related to the approach of software development. What the tools can or cannot do significantly impact what principles that can be used, as well well as what what objecti objectives ves that can be fulfil fulfilled led.. While While select selection ion of a particu particular lar meth method odol olog ogy y may may impl imply y use use of certa certain in tool tools, s, the the tool toolss them themse selv lves es ofte often n leave leave sign signif ifica icant nt room room for for deve develo lope pers rs to choo choose se how how to use use them them.. The The sele selecti ction on has has
47
therefore been based mainly on the objectives of the project, while the methodologies were selected after the tools were selected, due to the fact that technologies technologies and tools poses certain restrictions of how development can be done.
3.12.1 ASP ASP stands for Active Server Pages, and it is Microsoft's implementation of serverside scripting. In short, this server-site scripting basically means that a script is parsed and executed by the server. When a user requests a web-page containing ASP, the web-server will parse code and send the result to the user, so the ASP code will never reach the user's browser. This is the exact opposite of JavaScript. You don't need to be a programmer to understand ASP, but you should have some HTML knowledge, as the actual design of the web page will require it. To use ASP scripts, you must have installed Microsoft's IIS (Internet Information Services Services), ), which which is a web-se web-serve rverr includ included ed in Window Windowss 2000 2000 and Window Windowss XP Professional. It is also a part of the Windows NT 4.0 Option Pack, which can be down downlo load aded ed from from Micro Microso soft' ft'ss webweb-si site te.. If IIS IIS is not not alre alread ady y inst instal alle led d on your your comput computer, er, you can instal installl it using using the Add/Re Add/Remov movee Progra Programs ms sectio section n within within the Windows Control Panel. The ASP engine is included within IIS, so you won't have to download download it and install install it separately. separately. You must have Windows Windows NT 4.0 or later to run IIS, so if you use Windows 98 you should install PWS (Personal Web Server), which is the smaller brother of IIS. You can use ASP code to do a lot of things: dynamically edit, change or add any content to a web-page, access and query databases, read or write files, connect to remote computers, create images - the only limit is your imagination. The most obvious difference from HTML files is that ASP files have the extension ".asp", but this doesn't mean that you need to separate the ASP code from the HTML code in different files; you can use one file which will include both HTML and ASP code. The web-server won't mind at all, it will parse the ASP code and forget about the HTML code. Depending on your ASP code, the web-server will output some HTML instead of the ASP code, so the web-browser will only see HTML. This provides a higher level of security, because nobody will be able to view your ASP code, and copy it and use it on their own web-page. Furthermore, you don't need
48
any extra components for your web-browser, because the ASP files are returned in plain HTML, so they can be viewed in any web-browser. In case you don't have Windows, you should know that some companies also didn't like the fact the ASP was only available for Windows platforms, so they decided to adapt ASP to other operating systems. So they created technologies like Chili ASP and iASP, which allow you to take advantage of the ASP technology while using other web-servers, not just IIS. And because other web-servers run on many operating systems - like Apache web-server - this extends the ASP technology too, so it can run on other operating systems. Active Server Pages or ASP, as it is more commonly known, is a technology that enable enabless you to make make dynami dynamicc and intera interacti ctive ve web pages. pages. ASP uses server server-si -side de scripting to dynamically produce web pages that are not affected by the type of browser the web site visitor is using. The default scripting language used for writing ASP ASP is VBSc VBScri ript pt,, alth althou ough gh you you can can use use othe otherr scri script ptin ing g lang langua uage gess like like JScr JScrip iptt (Microsoft's version of JavaScript). ASP pages have the extension .asp instead of .htm, when a page with the extension .asp is requested by a browser the web server knows to interpret any ASP contained within the web page before sending the HTML produced produced to the browser. browser. This way all the ASP is run on the web server and no ASP will ever be passed to the web browser. Just simply just simply opening the page in a web browser cannot run any web pages containing ASP. The page must be requested through a web server that supports ASP, this is why ASP stands for Active Server Pages, no server, and no active pages. As ASP was first introduced by Microsoft on its web server, Internet Information Services (IIS) that runs on Windows 2000/XP Pro/NT4, it is this web server that ASP pages usually run best on. For those of you running Windows and wish to play around with ASP on your own system you will need to install Microsoft's Internet Information Services (IIS). Lucky IIS or its micro version Personal Web Server (PWS) comes free with Windows. For Windows users you can find Internet Information Services (IIS) or Personal Web Server (PWS) in the following places:
Windows 2000/XP Pro - IIS can be found in 'Add/Remove Programs' in the
'Control Panel'.
Windows 98 - PWS can be found under 'add-ons' on the Windows 98 CD.
49
Windows NT4/95 -You can get hold of IIS by downloading the NT4 Option
Pack from Microsoft (don't be fooled by the name as it also runs on Windows 95).
Windows ME - IIS and PWS are not supported on this operating system.
Windows XP Home Edition - IIS and PWS are not supported on this
3.12.2 ASP Programming Active Server Pages ( ASP ) programming is writing code to facilitate ASP functionality
on websites. Such functionality includes the delivery of dynamic, database-driven content to website viewers without taxing the server-side system. ASP programming involves writing ASP files and HTML files. The ASP code is placed within the HTML pag pages es,, enclo enclose sed d in spec specia iall tags. tags. When When you you need need to make make chan change gess in the the ASP ASP programming code, you need change only the ASP files; the HTML files, which do nothing but go and get the ASP files' coding, need not be changed. ASP files have a file extension of .asp, much like HTML files have file extensions of either .htm or .html. The HTML files that contain the ASP instructions enclose those instructions within tags that look like this: Notice that unlike HTML, the ASP ending tag does not include a slash. To send the results of an ASP instruction directly to a browser, you add an equal’s sign: <%=. ASP programming involves scripting in Visual Basic Script, Jscript, Perl, Python, or other languages. Certain modifications are necessary, but the programmer who has written code in these other languages will find ASP programming to be familiar indeed. The two languages that work the best for ASP programming are VBScript and Jscript. One common use of ASP programming programming is to gather gather data from the user and display display it at another time. For example, you can use ASP programming to query the user to type in his or her name and then display that name on subsequent pages during the user's visit. Once the name is input, the ASP programming protocols transfer that data to the requisite database, from which it can be accessed by other HTML pages that contain the coding guiding such requests. Such data requests and displays can be as complex as you want to make them.
50
Written data isn’t the only thing that can be uploaded to your website using ASP programming. You can design forms that allow users to upload image files to your site as well. Real estate websites are perfect examples of sites that can take advantage of this functionality. ASP programming also comes in handy when your HTML pages and what they display involve accessing large databases containing tons of data. In this case, you will really appreciate the benefits of not having to change HTML files when you update update the parame parameter terss of your your databa databases ses.. ASP progra programmi mming ng makes makes this this proces processs simple.
3.12.3 Parsing ASP Code In order to correctly parse (process) a selection of ASP code, no matter how long and complex, you need a HTTP web server. Generally, ASP pages run under Microsoft’s Internet Information Server (IIS), which comes as an optional installation from the Windows 2000 and XP Professional CD's. Windows 98 includes a cut down version of IIS called Personal web server (PWS) The ASP parsing is enabled via the ASP DLL. This enables any piece of code encased within the ASP tags (<% and %>) to be parsed as ASP. The rest of the HTML page will be untouched and processed by the web browser client side. ASP can be embedded within HTML. The example below shows how you would create a table and place a simple date function to return the current date and time.
The date/time is <% = now() %>
The process of embedding ASP within HTML is known as "spaghetti coding".
51
3.12.4 Connecting to a Database One of the major features of ASP is database connectivity. ASP can be used to connect connect primarily primarily to Microsoft Access or SQL Server database. an ASP script can contain contain Structured Structured query language language (SQL) statements statements to insert , delete and update records within a database (to name just a few) For example : SELECT * FROM FROM myTable WHERE myValue = 'myValue'
INSERT INTO myTable (value1) VALUES ("myValue") A database connection is done via a connection string in the ASP source code. There are two ways this is generally done, one is using a data source name (DSN) and the oth other is usin using g a DSNDSN-Le Less ss conn connec ecti tion on stri string ng,, whic which h inst instea ead d can can use use the the
Server.MapPath method or physical pathname to locate the database. An example connection string using a DSN: <% dim strConnection, dbase 'Create string with the name of the data source strConnection = "MyDSN"
Set dbase = Server.CreateObject("ADODB.Connection") 'Open database dbase.Open strConnection, "user", "password" %> DSN's are created using the ODBC data source administrator. This can be found in your system32 folder or within control panel. When you set up a data source name you are required to input the data source name, plus the database that it connects to and the path of that database. A user ID and password are also necessary, which is what will be within the two "", "" parameters in the dbase.Open line. Example of a dsn-less connection, c onnection, using Server.MapPath:
%> If you wanted to enter a physical path, the Server.MapPath method could be removed and in its place, something like "C:\somefolder\somedatabase.mdb". In order to create a path to the database, Server.MapPath maps the path back to web server root that the pages are running on, via the directory you have specified. It's advantageous to keep a connectionstring in an external file and include it using the method.
53
CHAPTER 4 TESTING AND IMPLEMENTATION 4.1
Objectives of Testing:
This section introduces the concept of testing and how important is, for the successful implementation of the project. Different phases of testing are described along with the level of testing incorporated in this particular project. Testing is vital to the success of any system. Testing is done at different stages within the phase. System testing makes a logical assumption that if all phases of the system are correct, the goals will be achieved successfully. Inadequate testing at all leads to errors that may come up after a long time when correction would be extremely difficult. Another objective of testing is its utility as a user-oriented vehicle before implementation. The testing of the system was done on both artificial and live data. Testing involves operation of a system or application under controlled conditions and evaluating the results (e.g., “if the user is in interface A of the application while using hardware B and does C, then D should not happen”). The controlled conditions should include both normal and abnormal conditions. Typically, the project team includes a mix of testers and developers who work closely together, with the overall QA processes being monitored by the project managers.
4.2
Types of Testing
4.2. 4.2.1 1 Blac Black k Box Box Te Testi sting ng Also known as functional testing, this is a software testing technique whereby the tester does not know the internal working of the item being tested. Black-box test design design treats the system as a “black-box”, “black-box”, so it does not explicitly explicitly use knowledge knowledge of the internal structure. Black-box Black- box test design is usually described as focusing on testing functional functional requirements. requirements. Synonyms Synonyms for black-box black-box includes: includes: behavioral, behavioral, functional, functional, opaque-box and closed-box.
54
4.2.2 White Box Testing White box test design allows one to peek inside the “box”, and it focuses specifically on using using internal internal knowled knowledge ge of the software software to guide guide the select selection ion of test test data. data. Synonyms for white-box include: structural, glass-box and clear -box.
4.2.3 Condition Testing An improvement over White-box testing, the process of condition testing ensures that a controlling expression has been adequately exercised whist the software is under test by constructing a constraint set for every expression and then ensuring that every member on the constraint set is included in the values whish are presented to the expression
4.2.4 Data Life-Cycle Testing It is based upon the consideration that in the software code, a variable is at some stage created created,, and subseque subsequentl ntly y may have have its value value change changed d or used used in a contro controlli lling ng expression several times before being destroyed. If only locally declared Boolean used in control conditions are considered then an examination of the sources code will indicate the place in the source code where the variable is created, places where it is given a value is used as a part of a control expression and the place where it is destroyed. This approach to testing requires all possible feasible lifecycles of the variable to be covered whilst the module is under test.
4.2.5 Unit Testing The purpose of this phase is to test the individual units of the developing software component. This phase is recursive and is to be repeated, as many as there are, levels of test testin ing. g. In the the DGLW DGLW proj projec ect, t, each each indi indivi vidu dual al form form has has been been test tested ed usin using g techniques of testing namely: Client side testing using JavaScript. Each individual form has been validated so that user enters only valid data at every time.
55
4.2.6 Functional Testing: This is done for each module / sub module of the system. Functional testing serve as a means of validating whether the functionality of the system Confers the original user requirement i.e. does the module do what it was supposed to do? Separate schedules were made for functional testing. It involves preparation of the test data, writing of test cases, testing for conformance to test cases and preparation of bugs listing for non-conformities.
4.2.7 System Testing: System testing is done when the entire system has been fully integrated. The purpose of the system testing is to test how the different modules interact with each other and whether the entire system provides the functionality that was expected. System testing consists of the following steps: a) Prog Progra ram m Test Testin ing g b) b) Stri String ng Test Testin ing g c) Syste ystem m Test Testin ing g d) Syst System em Doc Docum umen entat tatio ion n e) User User Accep Acceptan tance ce Tes Testi ting ng
4.3
Various Levels Of Testing
Before implementation the system is tested at two levels: Level 1 Level 2
4.3.1 Level 1 Testing (Alpha Testing) At this level a test data is prepared for testing. Project leaders test the system on this test data keeping the following points into consideration: ● Proper error handling
56
● Exit Pints in code ● Exception handling ● Input / Output format ● Glass box testing ● Black box testing If the system is through with testing phase at LEVEL 1 then it is passed on to LEVEL 2.
4.3.2 Level 2 Testing (Beta Testing) Here the testing is done on the live database. If errors are detected then it is sent back to LEVEL 1 for modification otherwise it is passed on to LEVEL 3. This is the level at which the system actually becomes live and implemented for the use of END USERS. We have also checked the proposed system for :
Recovery & Security A forced forced system system failure failure is induce induced d to test a backup backup recover recovery y proced procedure ure for file file integrity. Inaccurate data are entered to see how the system responds in terms of error detection and protection. Related to file integrity is a test to demonstrate that data and programs are secure from unauthorized access.
Usability Documentation & Procedure: The usability test verifies the user-friendly nature of the system. This relates to normal operating and error-handling procedures.
4.4
Quality Assurance
Proper documentation is must for mainframe of any software. Apart from In-line documentation while coding. Help coding, help files corresponding to each program were prepared so as to tackle the person-dependency of the existing system.
57
4.5
System Implementation
Duri During ng the the impl implem ement entat atio ion n stag stagee the the syst system em is phys physic ical ally ly crea created ted.. Nece Necess ssary ary programs are coded, debugged and documented. A new hardware is selected, ordered and installed.
4.6
System Specification Every computer system consists of three major elements. 1. The Hardware 2. Application Software such as visual studio. 3. Operating system
For successful operation of the package following must be kept in mind: Too many packages should not be used, as very few systems may have all those packages installed due to memory problem. Thus, the compatibility of the system developed will get reduced.
4.6.1 Hardware Requirements Intel Pentium processor at 500 MHz or faster, minimum of 364 MB available disk space for installatio installation n (including (including IBM SDK), minimum minimum of 256 MB memory,512 memory,512 MB recommended, CD-ROM drive.
4.6.2 Software Requirements The The appl applic icat atio ion n soft softwa ware re is host hosted ed on the the MOLD MOLDB B (Min (Minis istr try y of Labo Labour ur & Employment Database server) web server located at NIC Computer Cell, Ministry of Labour, Shram Shakti Bhawan, Rafi Marg, New Delhi. The application software is developed in ASP, JavaScript, and HTML. The central database is based on MS SQL Server 2000. The system can be accessed over the Internet connecting all the Internet of Ministry of Labour & Employment nodes. Clients equipped with web-browsers can access the system from any of the Intranet Nodes.
58
4.7
Installation
The Applic Applicatio ation n install installatio ation n script scriptss have have to be genera generated ted from from the curren currentt server server where the application source code is saved and installed in the main server from wher wheree the the appl applic icati ation on is to be run. run. This This was was done done usin using g a speci special al code code,, whic which h generates all SQL-Statements to insert preliminary data (like menu entries, code in code directories etc) at server and the operational modules of the application made available to the end users successfully.
4.8
Implementation
The system is still under construction few reports are yet to me made after that this system will be implanted at client side. Users will be given a training to use the packa package ge and special special worksh workshops ops are conduc conducted ted by the NIC for the purpos purpose. e. And according to their feedback the changes are implanted in the software.
59
CHAPTER 5 RESULT AND CONCLUSION This section discuses the result of the work done in this project And also mentions the future scope for improvement.
Conclusion Today we are at the cross roads of innovation. The right direction to take will only evolve evolve with time, time, but effort effort has to be taken taken seriou seriously sly by everyo everyone ne involv involved ed in education; the school/University, administration, faulty, students and parents. By designing the “Directorate General of Labour Welfare” through ASP server side technology, we are able to provide the basic functionality related to the submission activities with great ease. The use of ASP technology has made it easier to design and develop the n-tired architecture of this application. We were using the Microsoft Software Development Platform for the development of this project, which had given a complete, tight and integrated approach for the process of design and development of this project. Hence we may conclude that the application system being developed helps a great deal in modifying the computerized DGLW.
Future Scope of Improvement The “Employee Management System for DGLW” is a big and ambitious project. I am than thankf kful ul for for bein being g prov provid ided ed this this grea greatt oppo opport rtun unit ity y to work work on it. it. As alre alread ady y mentioned, this project has gone through extensive research work. On the basis of the rese resear arch ch work work,, we have have succ succes essf sful ully ly desi design gned ed and and impl implem emen ente ted d Empl Employ oyee ee Management System. This system is based upon 3-tier client server architecture. The tools used for development were as follows.
Afte Afterr log login in this this form form will will be show shown n fro from m whe where re we will will have have to choo choose se
from the menu.
62
Fig: Fig: 5.3 5.3
Afte Afterr log login in this this form form will will be show shown n fro from m whe where re we will will have have to choo choose se
from the menu.
63
Fig: Fig: 5.4 5.4
On cli click ckin ing g on Em Emplo ployee yee form form th these ese desi desig gnati natio on will will be be list listed ed and and on on
choosing a particular designation all the employees at that designation on the region through which a person has entered will be listed
64
Fig: Fig: 5.5 5.5
On choo choosi sing ng a des desig igna nati tion on a emp emplo loye yeee rec recor ord d at at the the desi design gnat atio ion n wil willl be be
listed like this also mentioning the total number of person at that designtion
65
Fig: Fig: 5.6 5.6
On clic clicki king ng the the “Ne “New w Inf Infor orma mati tion on”” on on the the top top and and bott bottom om of the the “St “Stat atee
Wise Employee Employee Information” Information” “Employee form” will will be loaded
66
Fig: Fig: 5.7 5.7
Whil Whilee on cli click ckin ing g on th the info inform rmat atio ion n in the the Sta Stati tio on Wis Wise Empl Emplo oyee yee
Information list then the “Employee form” will be loaded taking all the information from the Table “Employee”
67
Fig: 5.8
On cli clicking on the the Posting Button thi this list of Postings at var various
station will appear if it already have, also on clicking on the “New Information” link on the left side of for posting to the New Region can be assigned to the employee through whose record we have entered
68
Fig: Fig: 5.9 5.9
This This will will make make one one sel selec ectt the the part partic icul ular ar Regi Region on for for the the Post Postin ing g
69
Fig: 5.10
On selecti cting the Region the above form will be loaded, ed, now the
station, designation, and duration of the position will be chosen through this form
70
Fig: Fig: 5.11 5.11
Now Now when when the the new new pos posti ting ng has has bee been n assi assign gned ed to to the the pers person on tha thatt data data
will be inserted and form will be closed
71
Fig: Fig: 5.12 5.12
The The reco record rd inse insert rted ed abov abovee is is lis liste ted d here here in the the pos posti ting ng info inform rmati ation on form form
72
Fig: Fig: 5.13 5.13
On clic clicki kin ng on the the Tran ransfer sfer Butt Butto on in the Emp Emplo loy yee form form this this pag pagee
will be loaded giving information about his previous station and allowing the user to assign him new Region and Station and the date for the Transfer
73
Fig: Fig: 5.14 5.14
Afte Afterr inse insert rtin ing g the Regi Regio on for for the the Tran Transsfer fer this this form form will will be load loaded ed
listing Employee’s previous Region, Station and Region selected through previous form, form, then then throug through h this this form form Statio Station n for the Employ Employee ee for the Transf Transfer er will will be selected
74
Fig: Fig: 5.15 5.15
On cli click ckin ing g the the Leav Leave Butto utton n on Emp Employ loyee form form this this for form m will will be be
loaded listing all the leaves taken by Employee their type and duration
75
Fig: Fig: 5.16 5.16
On cli click ckin ing g on New New Inf Infor orma mati tion on on on the the left left of of the the Leav Leavee Info Inform rmat atio ion n
form this form will be loaded where leave record can be entered
76
Fig: Fig: 5.17 5.17
On cli click ckin ing g on the the Vacan Vacancy cy Po Positi sitio on form form this this form form will will be be load loaded ed
listing particular station for the Region through which user has login
77
Fig: Fig: 5.18 5.18
Now Now allo allowi wing ng user user to sele select ct the the par parti ticu cula larr sta stati tion on
78
Fig: Fig: 5.19 5.19
On sele select ctio ion n the the Stati Station on all all the the des desig igna nati tion on on on tha thatt stat statio ion n wil willl be list listed ed
from the table Vacancy Position
79
Fig: 5.19
Each designation has a link containing information about the
Employee at that designation
80
Fig: Fig: 5.20 5.20
On click clickin ing g the the part particu icula larr desi design gnat atio ion n thi thiss form form will will be be load loaded ed brin bringi ging ng
all the information regarding Vacancy Position about the Employee at designation
81
Fig: Fig: 5.21 5.21
On clic clicki king ng on the the New New Butt Button on this this form form will will be load loaded ed
82
Fig: 5.22
83
Fig: Fig: 5.23 5.23
On cli click ckin ing g the the “New “New Inf Infor orma mati tion on”” link link thi thiss page page wil willl be loa loade ded d with with
Region and Station fixed
84
Fig: Fig: 5.24 5.24
New New form form allo allow w user user to ins inser ertt a new info inform rmat atio ion n on the the part partic icu ular lar
Region and station
85
Fig: Fig: 5.25 5.25
On ins inser erti ting ng the the abo above ve inf infor orma mati tion on thi thiss form form wil willl be load loaded ed lik likee this this
i.e., the designation inserted will be printed now and editing on the other field can be performed
86
Fig: 5.26
This is a login form, rm, if user is no not from rom regi egional area but is fro from
Administration he will have User ID and Password other than that of user from Regional areas
87
Fig: Fig: 5.27 5.27
Afte Afterr this this log login in thi thiss page page wil willl be loa loade ded d here here the the use userr will will hav havee both both
Region and Station to select, user can access any region and station
88
Fig: Fig: 5.28 5.28
Now Now again again afte afterr enter enterin ing g the Regi Region on and and Stati Station on this this form form will will be
loaded
89
Fig: Fig: 5.2 5.29 9
User User can can acc acces esss othe otherr Regi Region on and and Sta Stati tion on as as well well
90
Fig: Fig: 5.30 5.30
After After selec selecti ting ng the the Reg Regio ion n and and Stat Statio ion n this this pag pagee will will be be load loaded ed lis listi ting ng
all the designation at that station
91
Fig: Fig: 5.31 5.31
On cli click ckin ing g the the Emloy loyeeC eeCR form form fro from the the menu menu th this for form m will will be be
loaded listing all the station of the Region through which User has login
92
Fig: Fig: 5.32 5.32
On sel selec ecti ting ng the the Sta Stati tion on thi thiss page page wil willl be loa loade ded d brin bringi ging ng nam namee and
designation of all the Employees at the station
93
Fig: Fig: 5.33 5.33
On clic clicki kin ng the the Empl Emplo oyee’ yee’ss Nam Name this this pag page will will be load loaded ed list listin ing g
information about his CR year and whether it is received or not
94
Fig: Fig: 5.34 5.34
On clic clicki king ng the the “Ne “New w Info Inform rmat atio ion” n” on on the the left left thi thiss for form m wil willl be be loa loade ded d
with the Employee’s name
95
Fig: Fig: 5.35 5.35
On cli click ckin ing g the the Emp Employ loyee’s ee’s nam namee in the the list list abov above this this fo form will will be be
loaded with the information about Employee’s CR year this info can be edited and saved
96
Fig: Fig: 5.35 5.35
On cli click ckin ing g on the the Leav Leavee on the the Men Menu u this this for form m will will be be load loaded ed let letti ting ng
to choose the designation, for the designation entered here the leave information will be listed
97
Fig: Fig: 5.36 5.36
On sele select ctin ing g desig esign natio ation n thro throu ugh prev revious ious form form this this form form will will be
loaded listing Balance leaves of the employee
98
Annexure B: Reports
Fig: Fig: 5.37 5.37
On cli click ckin ing g on th the List List Reg Regio ion n Rep Repots ots in the the men menu this this pag pagee will will be be
loaded, select the region through this list
99
Fig: 5.37
For the Region entere ered above report lis listing all the data in table
“VacancyPosition” will listed regarding sanctioned strength for various designation at various Region and Station
100
Fig: Fig: 5.38 5.38
On sel selec ecti ting ng lis listt Desi Design gnat atio ion n from from the the Men Menu u this this pag pagee will will be be load loaded ed,,
select the Designation through this list
101
Fig: Fig: 5.39 5.39
All All the the info inform rmat atio ion n as ente entere red d in the the tab table Vaca Vacan ncy Posi Positi tio on for for the the
selected designation will be listed
102
Fig: Fig: 5.40 5.40
On sel selec ecti ting ng lis listt vaca vacan ncy Reg Regio ion n from from the the menu enu this this pag pagee will will be
loaded
103
Fig: Fig: 5.41 5.41
Then Then for for the the sel selec ecte ted d Regi Region on,, list list of of all all the the vaca vacanc ncy y posi positi tion on for for the the
various designation at the various station of the selected Region will be listed
104
Fig: Fig: 5.42 5.42
On sele selecti cting ng vaca vacanc ncy y Reg Regio ion n fro from m the the menu menu this this page page will will be load loaded ed
105
Fig: Fig: 5.43 5.43
This This page page will will lis listt vaca vacanc ncy y pos posit itio ion n for for the the var vario ious us desi design gnat atio ion n at each each
Region and Station
106
Fig: Fig: 5.44 5.44
On sele selecti cting ng list list Vacan Vacancy cyRe Regi gion onDe Desi sign gn this this page page will will be load loaded ed
107
Fig: Fig: 5.45 5.45
This This page page asks asks the the use userr to to sel selec ectt the the Regi Region on from from the the lis listt
108
Fig: Fig: 5.46 5.46
For For the the sel select ected ed Regi Region on,, Des Desig igna nati tion on recor record d at at the the regi region on will will be list listed ed
109
Fig: Fig: 5.47 5.47
On choo choosi sin ng parti articu cula larr Desi Desig gnatio ation n all all the the info inform rmat atio ion n reg regard arding ing
vacancy position for that designation at selected Region will be listed
110
Annexure C- Sample code: frmEmployee.asp
<--#include File="../Library/FunctionLibrary.asp"--> <% Dim rsFrm, TableName, RedirectURL, frmMode Dim cID, cName, cSex, cDOB, cDesignation, cPerFileNo, cCategory, cDtGovt, cDtGovt, cDtService, cPlacePosting Dim cQualification, cQualDesc, cDtLeaving, cTypeLeaving, cRemarks, cRegion, cStation, cSeniority Dim cBasicPay, cPostType, cDtPost, cUPSCDt, cUPSCNo1, UPSCNo2, cEntryMode, cPresentStatus, cPost, cDtPostHeld, cHomeTown Dim cIncrMonth, cIncrYear TableName = "Employee"
select case cstr(Request.Form("SubmitAction")) case "Posting" cId=Request.Form("ID") frmPosting() case "Transfer" cId=Request.Form("ID") cRegion=Request.Form("Region") cStation=Request.Form("Station") frmTransfer() case "Leave" cId=Request.Form("ID") cRegion=Request.Form("Region") cStation=Request.Form("Station") frmLeave() case "New" frmMode="New" GetValuesFrom "Default"
111
Response.Write "New Form" cRegion=Request.Form("Region") case "Insert" GetValuesFrom "Form" frmInsert() Case "Save" GetValuesFrom "Form" frmUpdate() case "Delete" GetValuesFrom "Form" frmDelete() case "Search" GetValuesFrom "Form" frmSearch() case "Refresh" GetValuesFrom "Form" frmFind() case "Close" frmClose() case else select case cstr(Request.QueryString("frmAction")) case "Find" cID = Request("ID") frmFind() case else frmMode="New" GetValuesFrom "Default" Response.Write "New Form" cRegion=Request.QueryString("Region") cDesignation=Request.QueryString("Designation") end select end select
sub frmInsert() insert=True
112
if (Not checkdate(cDOB)) then insert=False
Response.Write "
Wrong Date of Birth
" frmMode="New" cDOB="" else
strSql = "Insert into Employee (Name, "
if (len(trim(cSeniority))>0) then strSql = strSql & " Seniority, " end if
strSql = strSql & " Region, "
if (len(trim(cStation))>0) then strSql = strSql & "Station, " end if
strSql=strSql & " Sex, DOB, Designation, "
if (isNumeric(cBasicPay)) then strSql= strSql & " BasicPay, " end if
strSql= strSql & " PerFileNo, Category, "
if (len(trim(cDtGovt))>0) then strSql= strSql & "DtGovt," end if
if (len(trim(cDtService))>0) then strSql = strSql & " DtService,"
113
end if
if (len(trim(cDtPost))>0) then strSql= strSql & " DtPost," end if
if (len(trim(cIncrYear))>0) then strSql = strSql & " IncrYear, " end if
if (len(trim(cIncrMonth))>0) then strSql = strSql & " IncrMonth, " end if
sub frmDelete() strSql = "Delete from Employee where ID =" & cID set rsFrm = Server.CreateObject("ADODB.Recordset") rsFrm.open strSql, EmployeeConn 'Response.Redirect "frmEmployee.asp?frmAction=New" & "&Region=" & cRegion Response.Redirect "Region=" & cRegion & "&Designation=" & cDesignation end sub
sub frmClose() Response.Redirect RedirectURL & "?userName=" & session("gUserId") end sub
119
sub frmTransfer() Response.Redirect "frmRegion.asp?ID=" & cID & "&Region=" & cRegion & "&Station=" & cStation & "&Designation=" & cDesignation end sub
sub frmPosting() Response.Redirect "../List/lstPosting.asp?ID=" & cID & "&Region=" & cRegion & "&Station=" & cStation end sub
sub frmLeave() Response.Redirect "../List/lstLeave.asp?ID=" & cID & "&Region=" & cRegion & "&Station=" & cStation end sub
sub frmFind() set rsFrm = Server.CreateObject("ADODB.Recordset") strSql = "Select * from Employee where ID=" & cID rsFrm.Open strsql, EmployeeConn GetValuesFrom "Table" rsFrm.close end sub
cQualification = "" cQualDesc = "" cHomeTown = "" cDtLeaving = "" cTypeLeaving = "" cRemarks = "" cRegion=Request.QueryString("Region") cIncrMonth="" cIncrYear="" end select end sub %>
Employee Details <SCRIPT language="JavaScript">
function checkDtService() { if (document.frmName.DtService.value == "") {
123
alert("Blank Date!, Date format is 'DD/MM/YYYY'"); //document.frmName.CGITReceivedDate.focus(); } else { if(!DateValid(document.frmName.DtService.value)) { //document.frmName.CGITReceivedDate.focus(); } } } function checkDtGovt() { if (document.frmName.DtGovt.value == "") { alert("Blank Date!, Date format is 'DD/MM/YYYY'"); //document.frmName.CGITReceivedDate.focus(); } else { if(!DateValid(document.frmName.DtGovt.value)) { //document.frmName.CGITReceivedDate.focus(); } } } function checkDtPost() { if (document.frmName.DtPost.value == "") { alert("Blank Date!, Date format is 'DD/MM/YYYY'"); //document.frmName.CGITReceivedDate.focus(); } else { if(!DateValid(document.frmName.DtPost.value)) { //document.frmName.CGITReceivedDate.focus(); } } } function checkDtPostHeld() {
124
if (document.frmName.DtPostHeld.value == "") { alert("Blank Date!, Date format is 'DD/MM/YYYY'"); //document.frmName.CGITReceivedDate.focus(); } else { if(!DateValid(document.frmName.DtPostHeld.value)) { //document.frmName.CGITReceivedDate.focus(); } } } function checkUPSCDt() { if (document.frmName.UPSCDt.value == "") { alert("Blank Date!, Date format is 'DD/MM/YYYY'"); //document.frmName.CGITReceivedDate.focus(); } else { if(!DateValid(document.frmName.UPSCDt.value)) { //document.frmName.CGITReceivedDate.focus(); } } } function checkDtLeaving() { if (document.frmName.DtLeaving.value == "") { alert("Blank Date!, Date format is 'DD/MM/YYYY'"); //document.frmName.CGITReceivedDate.focus(); } else { if(!DateValid(document.frmName.DtLeaving.value)) { //document.frmName.CGITReceivedDate.focus(); } } }
125
function checkBP() { if (document.frmName.BasicPay.value == "") { alert("Blank Basic Pay!"); } else { if(!is_int(document.frmName.BasicPay)) { alert("'" + document.frmName.BasicPay.value + "' is not a valid Basic Pay!"); //alert(document.frmName.BasicPay.value); document.frmName.BasicPay.value="" } } } //-->
