ONLINE MANAGER

A project report submitted to Mahatma Gandhi University, Kottayam in

partial fulfillment of the requirements of the award of degree of

BACHELOR OF COMPUTER APPLICATION

Done by

JITHIN JOSE
(Reg.no:11157293)

Under the guidance of

Mrs. AMRUTHA K.G.

DEPARTMENT OF COMPUTER SCIENCE

ST.THOMAS ARTS & SCIENCE COLLEGE

(Affiliated to Mahatma Gandhi University, Kottayam)

Puthencruz-682308

March 2014
 ST.THOMAS ARTS & SCIENCE COLLEGE
PUTHENCRUZ
(Affiliated to Mahatma Gandhi University, Kottayam)

C E R T I F I C A CT E

It is hereby certified that this is a bona fide project work done by Jithin Jose
(Reg.No: 11157293) in partial fulfillment of the requirements for the award of the sixth
semester of Bachelor of Computer Application of St. Thomas Arts And Science College
Puthencruz of Mahatma Gandhi University, Kottayam.

Mrs. AMRUTHA K.G. Prof. V.K. YOYAKKI Mrs. RIBY KURIAKOSE

(Project Guide) (Principal) (Head of the Department)

Submitted for the viva-voce examination held on …………………

INTERNAL EXAMINER EXTERNAL EXAMINER

 DECLARATION

I hereby declare that the project entitled ‘Online manager’ is a bona fide
work done by me under the guidance of Mrs. Amrutha K.G, Lecturer, Dept.
of Computer Science, St. Thomas Arts & Science College, Puthencruz, in
partial fulfillment of the requirements for the award of the degree Bachelor of
Computer Applications of St. Thomas Arts And Science College, Puthencruz
of Mahatma Gandhi University, Kottayam.

Jithin Jose

Place: Puthencruz
Date:
 ACKNOWLEDGEMENT

I record my sincere gratitude to Prof. V.K.Yoyakki, our respected

Principal, for providing all necessary facilities for successfully carrying out this
project.

I express my sincere thanks to Mrs. Amrutha K.G, my guide and

motivator throughout the work of my project.

I profusely thank other Lecturers in the department and all other members
of the staff of St. Thomas Arts & Science College, Puthencruz, for their guidance
and inspiration throughout my course of study.

I owe my thanks to my friends and all others who have directly or

indirectly helped me in the successful completion of this project. No words can
express my humble gratitude to my beloved parents and relatives who have
been guiding me in all walks of my journey.

Jithin Jose
 SYNOPSIS

The Online Manager is a web based office software which can be accessed by any
person from anywhere in the World. The Admin is the overall control of the system and
also the users can update their status in this system.

Modules in this project:

1. Employee Registration

This module involves registering the new employees.

2. Adding Departments
This module involves adding of new departments to the office.

3. Set punching time

This module helps to enter the punching time of each employee and employees can
punch-in and punch-out at right timings.

4. Salary Calculation
This module involves entering basic payment and its details and calculation of salary
and employee can view it

5. Adding Notices
Admin can add notices and employees can view it.

6. Adding Holidays
Admin can add holidays in the office calendar and employee can view it.
 7. Leave Requests
Employee can sent leave requests and admin can either sanction or reject the leave
requests.

Login form: This form will only connect to the Admin or employee home if and
only if the username and password entered is correct. When the user enters the wrong
username or password login is failed.
The front end of this project is ASP.NET and the back end of this project is MS SQL
Server 2008 .This project is implies to make the process in office in computerized form
CONTENTS
 CONTENTS
PAGE NO

1. INTRODUCTION 1
1.1. About the organization 3
1.2. About the project 4
2. SYSTEM ANALYSIS AND DESIGN
2.1. System study 6
2.1.1. Existing system 6
2.1.2. Proposed system 8
2.1.3. Feasibility study 9
3. SOFTWARE AND HARDWARE SPECIFICATION
3.1. Operating system 12
3.2. Front end 14
3.3. Back end 16
4. SYSTEM DESIGN 19
4.1. Output design 19
4.2. Input design 20
4.3. Process design 21
4.3.1. Data flow diagram 22
4.4. Table design 29
5. SYSTEM TESTING AND IMPLEMENTATION
5.1. System testing 37
5.2. System Implementation 39
5.3. Maintenance 40
6. FUTURE ENHANCEMEN 42

7. CONCLUSION 44

8. BIBLIOGRAPHY 46

9. APPENDIX
9.1. Screen shots 48
9.2. Source code 72
Bachelor of Computer Application Online manager

INTRODUCTION

St. Thomas Arts And Science College, Puthencruz 1

Bachelor of Computer Application Online manager

1. INTRODUCTION

Online Manager is a web based office software which can be accessed by any

person from anywhere in the World. The objective of this software is to establish an

employee-employer relationship easy by systematic digital communication

procedures.

Online Manager is web based office software to maintain add new employee, add

new department, add salary details, salary calculation, add punch in and punch out

details and add complaint details.

The product could be implemented in an average sized organization, which will

not be very keen on spending loads of money on ledgers. Whereas our product will

greatly reduce the running by using common and cheap office items like database and

desktop application. And also there is no requirement to store books or accounts. The

data is directly stored in the database in the hard disk of the PC.

St. Thomas Arts And Science College, Puthencruz 2

Bachelor of Computer Application Online manager

1.1 ABOUT THE ORGANIZATION

CuteSys Technologies Pvt. Ltd. is a frontline software company in Cochin, India. It has
a team of experienced Software experts who are dedicated to deliver high quality Projects. It
has clients across the globe and there are many software Products in various domains.
The company is so popular that the clients feed the company with repeat orders, having faith
in the capabilities. The staff includes management and engineering personnel, programmers,
web developers, graphic designers, business analysts, Technical writers etc, apart from the
regular commercial and administrative hands.
They are committed to provide what they have promised. They strive for the
satisfaction of their clients and dedicate themselves for the better services to their customers.
They are famous in providing high quality, cost cutting, requirement oriented and value
added web and software solutions with remarkable cyber services. They are specialist in
developing ever rewarding internet existence for ambitious companies which are in the
hangover of swift moving internet facilities. Their aim is to grow with such organizations n a
very fruitful manner.
Their main concentration is to collect business oriented technological know-how and
utilize them for the wellbeing of business concerns. Their experts in various technologies are
committed to deliver effective and creative service to customers.

Specializations

 Web portals

 E-Commerce

 Web application products.

 Desktop applications, Websites

 Custom solutions and ERP solutions

St. Thomas Arts And Science College, Puthencruz 3

Bachelor of Computer Application Online manager

1.2 ABOUT THE PROJECT

Online Manager is a web based office software which can be accessed by any
person from anywhere in the World. The objective of this software is to establish an
employee-employer relationship easy by systematic digital communication procedures.
There are mainly 2 end users to this application, (1) Employees (also called Users), (2)
Employers (also called Admin). Users can make upward-communications of their official
routine processes to their employer and the employer can make downward-communications
through this software. Reports are generated based on various criteria. Employees can login
to view their attendance and salary. Thus all manual process that is to be done in an office is
reduced to a considerable extent.

OBJECTIVES OF THE SYSTEM

The main objectives of the proposed system are

Online Manager is a web based office software which can be accessed by any person from
anywhere in the World. The objective of this software is to establish an employee-
employer relationship easy by systematic digital communication procedures.

There are two users in this project:

Administrator: Administrator has the full authority over the website. He can add, edit or
delete all users (employees), set punch times, holidays, sent notices, sanction leave requests,
view complaints and sent their solutions.

Users: Employees of the office are the users of this system. They can punch-in and punch-
out in right timings and also can upload their works very easily. They can view notices,
holidays. They can also sent complaints and view its solutions.

St. Thomas Arts And Science College, Puthencruz 4

Bachelor of Computer Application Online manager

SYSTEM ANALYSIS
AND DESIGN

St. Thomas Arts And Science College, Puthencruz 5

Bachelor of Computer Application Online manager

2. SYSTEM ANALYSIS AND DESIGN

2.1 SYSTEM STUDY

Analysis is a detailed study of the various operations performed by a system and their
relationships within and outside the system. One aspect of analysis defining the boundaries of
the system and determining whether or not a candidate should consider other related systems.
During analysis, data is collected from the available files, decision points, and transactions
handled by the present system

2.1.1 Existing System

In the current scenario the overall management in an office is done by the help of excel
workbooks and mails. Considering an office with large number of employees and operations
it is difficult to understand the sequential flow of the mails and the worksheets, this may lead
to conflicts. Also the work status updating procedures consume time of personnel’s thus
decrease the productivity of the organization.

Drawbacks of Existing system:

 Productivity:
Productivity is usually lower, particularly in routine or operational situations such as
transaction processing.
 Slower:
Processing is slower where large volumes of data need to be dealt with. Slower
processing means that some information that could be provided if computerized
systems were used will not be provided at all, because there is no time.

 Risk of Errors:
The risk of errors is greater, especially in repetitive work like payroll calculation.

St. Thomas Arts And Science College, Puthencruz 6

Bachelor of Computer Application Online manager

 Less accessible:
Information is generally less accessible. Access to information is often is restricted to
one user at a time, paper files can easily be mislead in trays, in which case the
information they contain is not available to all.
 Bulk:
Paper based systems are generally very bulky both to handle to store and shop space
are expensive.

 Alterations:
It is difficult to make corrections. If a manual documents contains errors or need
updating it is often necessary to recreate the whole document from scratch, rather than
just a new version with the relevant details changed.
 Quality of output:
Quality of output is less consistent and often not well designed. At worst, hand written
records may be illegible and so completely useless. Poorly presented information may
fail to communicate key points.
 Time and manpower:
Report generation various area is done manually using great amount of manpower and
time. Erroneous records may lead to misleading information, which is more likely in
manual system.
 Less User-friendly:
The existing system involves readability of the records; Maintenance of billing details,
sales information etc. The technique is used in existing system is more complicated
and there is lack of technical background towards the system and also it’s less user-
friendly.

St. Thomas Arts And Science College, Puthencruz 7

Bachelor of Computer Application Online manager

2.1.2 Proposed system

The Online Manager is a web based office software which can be accessed by any
person from anywhere in the World. The Admin is the overall control of the system and also
the users can update their status in this proposed system.

In order to overcome the drawbacks in the existing system, database is created which
is integrated, reliable, consistent, flexible and secure. The features of the proposed database
are:

 Help in fast information access and retrieval.

 Offers options of online updating and in maintaining data information.
 Allows extracting information from tables using menus.
 It helps to save our time and money.
 The superior speed with which data can be accessed
 Data redundancy
 The reduction in space needed to store information.
 Confidentiality - locks and keys to control access
 Less man power usage

St. Thomas Arts And Science College, Puthencruz 8

Bachelor of Computer Application Online manager

2.1.3 Feasibility Study

After the problem is clearly understood and the solutions are proposed, the next
step is to conduct the feasibility study, which is a part of system analyses well as system
design process. The main objective of the study is to determine whether the proposed system
is feasible or not. Manley there are three types of feasibility study to which the proposed
system subjected as described below. Three key considerations are involved in the feasibility.
I. Economic feasibility
II. Technical feasibility
III. Behavioral feasibility

The proposed system must be evaluated from a technical view point first and of technical
feasibility, their impact on the organization must be accessed. If compatible, behavioral
system can be devised. Then they must be tested for economical feasibility.

Economic feasibility:
Justification of any capital outlay is that it will reduce expenditure, improve the quality
of service of goods, which in turn may be expected to provide increased profits. The
technique of cost benefit analysis is often used as a basis for accessing economic feasibility.
The project Online Manager, after implementation will result in minimum cost. It was seen
that the cost of proposed system could be handled by the organization. And when compared
with the cost, benefits on the implementation of the system are more, and so it is very much
feasible.

Technical feasibility:
The assessment of technical feasibility must be based on an outline design of systems
requirements in terms of inputs, output, files, programs and procedures this can be qualified
in terms of volumes of data, trends, frequency of update, cycles of activity etc, in order to
give an introduction of technical system.

St. Thomas Arts And Science College, Puthencruz 9

Bachelor of Computer Application Online manager

Technical feasibility was done to analyze whether the organization have requirements that is
needed for the system implementation. The system is a web application that uses ASP.net for
development. It uses C# as the front end and SQL server management 2008 as the back end.
The system works well in the organization, since it satisfies the minimal requirements for the
working of the system

Behavioral feasibility:
People are inherently resisted to change and computers have been known to facilitate
change. Since the new proposed system is nothing to do with the ordinary customers, the
worker resistance to the system is very much less. The users might be scared of job losses
and other problems when a new system is introduced.

St. Thomas Arts And Science College, Puthencruz 10

Bachelor of Computer Application Online manager

SOFTWARE
AND
HARDWARE SPECIFICATION

St. Thomas Arts And Science College, Puthencruz 11

Bachelor of Computer Application Online manager

3.1 ABOUT THE OPERATING SYSTEM

Operating System (Windows 7)

Windows 7 is a personal computer operating system developed by Microsoft as part

of Windows NT family of operating systems. Development of 7 occurred as early as 2006
under the codename "Blackcomb". Windows 7 was released to manufacturing on July 22,
2009, and became generally available on October 22, 2009, less than three years after the
release of its predecessor, Windows Vista. Windows 7's server counterpart, Windows Server
2008 R2, was released at the same time.

Windows 7 provides reliability and scalability. Lower your cost of computing with
powerful, flexible management services, and provides the best foundation for running
business applications. The system information is broken into several main categories and
subcategories.

The components category contains information about the Windows 7 system

configuration including multimedia, display, infrared, input, modems, network, ports,
storage, printing, problem devices, drivers, running tasks and software environment.
These options can be used to troubleshoot display, printing, speed and storage issues and
other Windows related issues such as running out of memory or running tasks that are
causing system problems.

The software environment category is used to display the software that is loaded in
your computer’s memory. This includes any drivers, print jobs, running tasks, loaded
modules, program groups and startup programs. This information is useful for determine
what is being loaded into, and possibly using too much, memory.

St. Thomas Arts And Science College, Puthencruz 12

Bachelor of Computer Application Online manager

Software specification

 Operating System : Windows 7

 Front End : ASP.NET

 Back End : MS SQL Server 2008

Hardware specification

 Microprocessor : Pentium 4

 RAM : 128 MB

 Speed : 1.6 GHz

 Hard Disk : 40 GB

 Monitor : 15” Color

 Key Board : 114 Keys

 CD Drive : 52

 Mouse : Logitech Scroll Mouse

St. Thomas Arts And Science College, Puthencruz 13

Bachelor of Computer Application Online manager

3.2 FRONT END

ASP.NET

ASP.NET is a server-side Web application framework designed for Web development to

produce dynamic Web pages. It was developed by Microsoft to allow programmers to build
dynamic web sites, web applications and web services. It was first released in January 2002
with version 1.0 of the .NET Framework, and is the successor to Microsoft's Active Server
Pages (ASP) technology. ASP.NET is built on the Common Language Runtime (CLR),
allowing programmers to write ASP.NET code using any supported .NET language. The
ASP.NET SOAP extension framework allows ASP.NET components to process SOAP
messages.

ASP.NET Web pages, known officially as Web Forms, are the main building blocks for
application development. Web forms are contained in files with an ".aspx" extension; these
files typically contain static (X) HTML markup, as well as markup defining server-side Web
Controls and User Controls where the developers place all the rc content for the Web page.
Additionally, dynamic code which runs on the server can be placed in a page within a
block <% -- dynamic code -- %>, which is similar to other Web development technologies
such as PHP, JSP, and ASP. With ASP.NET Framework 2.0, Microsoft introduced a
new code-behind model which allows static text to remain on the .aspx page, while dynamic
code remains in an aspx.vb or .aspx.cs or .aspx.fs file (depending on the programming
language used).

ASP.NET aims for performance benefits over other script-based technologies (including
classic ASP) by compiling the server-side code to one or more DLL files on the Web server.
This compilation happens automatically the first time a page is requested (which means the
developer need not perform a separate compilation step for pages). This feature provides the
ease of development offered by scripting languages with the performance benefits of a
compiled binary. However, the compilation might cause a noticeable but short delay to the
Web user when the newly edited page is first requested from the Web server, but will not
again unless the page requested is updated further.

St. Thomas Arts And Science College, Puthencruz 14

Bachelor of Computer Application Online manager

The ASPX and other resource files are placed in a virtual host on an Internet Information
Services server (or other compatible ASP.NET servers; see Other implementations, below).
The first time a client requests a page, the .NET Framework parses and compiles the file(s)
into a .NET assembly and sends the response; subsequent requests are served from the DLL
files. By default ASP.NET will compile the entire site in batches of 1000 files upon first
request. If the compilation delay is causing problems, the batch size or the compilation
strategy may be tweaked.

Developers can also choose to pre-compile their "code behind" files before deployment,
using Microsoft Visual Studio, eliminating the need for just-in-time compilation in a
production environment.[citation needed] This also eliminates the need of having the source
code on the Web server. It also supports pre-compile text.

St. Thomas Arts And Science College, Puthencruz 15

Bachelor of Computer Application Online manager

3.3 BACK END

The system has been developed in Microsoft SQL Server 2008 as back end.

MS SQL Server 2008:

SQL Server 2008 was released on August 6, 2008 and aims to make data management
self-tuning, self organizing, and self maintaining with the development of SQL Server
Always On technologies, to provide near-zero downtime. SQL Server 2008 also includes
support for structured and semi-structured data, including digital media formats for pictures,
audio, video and other multimedia data. In current versions, such multimedia data can be
stored as BLOBs (binary large objects), but they are generic bit streams.Intrinsic awareness
of multimedia data will allow specialized functions to be performed on them. According to
Paul Flessner, senior Vice President, Server Applications, Microsoft Corp., SQL Server 2008
can be a data storage backend for different varieties of data: XML, email, time/calendar, file,
document, spatial, etc as well as perform search, query, analysis, sharing, and
synchronization across all data types.

Relational database systems are the most important database used in the software
industry today. One of the most outstanding systems is Microsoft SQL Server. SQL Server is
a database management system developed and marked by Microsoft. It runs exclusively
under Windows NT and Windows 95/98.

The most important aspects of SQL Server are:

 SQL Server is easy to use

 SQL Server scales from a mobile laptop to symmetric multiprocessor systems

.
 SQL Server provides data warehousing features that until now have only been
available in Oracle and other more expensive DBMS.

A database system is an overall collection of different database software components and

database containing the part viz. Database application programs, front-end components,
Database management systems and Database.

St. Thomas Arts And Science College, Puthencruz 16

Bachelor of Computer Application Online manager

A database system must provide the following features:

 A variety of user interfaces

 Physical data independence

 Logical data independence

 Query optimization

 Data integrity

 Concurrency control

 Backup and recovery

 Security and authentication

When creating a database, the main concept is to know how the database is structured in
SQL.
SQL stands for Structured Query Language. It is a language that enables us to create and
operate on relational database, which are sets of related information stored in tables. Because
of its elegance and independence from machine specific, as well as its supports by the
industry leaders in relational database technology, SQL has become the standard language
and will remains as it is for the foreseeable future.

There are two types of SQLs-interactive and embedded. Interactive SQL is used to operate
directly on a database to produce output for human consumption. Embedded SQL consists of
SQL commands put inside of programs that are mostly written in some other languages such
as COBOL, Pascal, and C etc. This can make programs more powerful and efficient. The
functional categories of SQL commands consist of DDL and DML.

St. Thomas Arts And Science College, Puthencruz 17

Bachelor of Computer Application Online manager

SYSTEM DESIGN

St. Thomas Arts And Science College, Puthencruz 18

Bachelor of Computer Application Online manager

4. SYSTEM DESIGN

System design’s main aim is to identify the modules that should be in the
system, and the specifications of these modules and how they interact with each
other to produce the desired results. At the end of the system design all the major
data structures, file formats and the major modules in the system and their
specification are decided.

4.1 OUTPUT DESIGN

Efficient and transport output design improves the system relationship with the user
and help him to understand faster. A complicated output design contributes nothing to the
system but leave the user confused. For a successful system it is a must that it maintains a
clear output design. The users of the output its purpose and sequence of details to be printed
are all considered. The output form is system is the justification for its existence. If the
outputs are inadequate in any way the system itself is inadequate. The basic requirements of
content medium and layout for its intended purpose. Hence it is necessary to design output so
that the objectives of system are met in the best possible manner. The output is in the form of
reports.

Output design is a process that in valves designing necessary output in the form of reports
that should be given to the users according to the requirements. While designing the output,
the following steps are to be considered:

 Determine what information to be presented to the user.

 Arrange the presentation of information in an acceptable format.
 Decide how to distribute the output to the intended recipients.

St. Thomas Arts And Science College, Puthencruz 19

Bachelor of Computer Application Online manager

4.2 INPUT DESIGN

In accurate input data is the most cause of errors in data processing. Errors by data
entry operators can be controlled by input validation. Input design is the process of
converting user-oriented inputs to a computer-based format. Input design is a part of an
overall system design, which makes the system user friendly. The input design is the link
between the information system and users. It comprises developing specifications and those
steps that are necessary to put transaction data into a usable form for processing data entry.
The activity of putting data into the computer for processing can be achieved by instructing
the computer to read data from a written or printed document or it can occur by having
people key data directly in to the system. The design of input focuses on controlling the
amount of inputs required , controlling errors, avoiding delay, avoiding extra steps and
keeping the process simple.

System analyst decides the following input design details:

 What data to input.

 What medium to use.

 How the data should be arranged or coded.

 The dialogue to guide the users in providing input.

Methods for performing input validations and steps to follow when error occur. The input
screens are displayed in a way that the user can understand entries very easily. Proper
validation and controlling of input data will reduce the chance of errors. All major operations
are done only after checking the results of confirmation messages. This makes the system
more reliable and user friendly

St. Thomas Arts And Science College, Puthencruz 20

Bachelor of Computer Application Online manager

4.3 PROCESS DESIGN

Database Management System

Database Management system consists of a collection of interrelated data and a set

of programs to access that data is referred to as database. The database management system
has different goals.

Goals of Database Management System

The Primary goal of data base management system is to provide an environment that
is both conventional and efficient to use in retrieving information from and storing
information into database.

Data Model

A model is an abstraction process that hides superfluous details while highlighting

details pertinent to application at hand. A data models is a mechanism that provides this
abstraction for the storage of this data. There are many data models that are available for the
storage of data.
Most models provide mechanisms to structure data for the entities being modeled and allows
asset of operations to be defined on them. The models can also enforce a set of constraints to
maintain the high integrity of data. Some models are mentioned below.

Entity Relationship Models

The entity relationship models (E-R model) is based on perception of real world, which
consists of a set of basic objects called entities and relationships among these objects . It was
developed in order to facilitate database design by allowing then specification of an
enterprise scheme. Such a scheme represents the overall logical structure of database.

St. Thomas Arts And Science College, Puthencruz 21

Bachelor of Computer Application Online manager

4.3.1 Data Flow Diagram

A Data Flow Diagram (DFD) or a bubble chart is a graphical tool for structured
analysis. It was De Macro in 1978 and Gene and Carson in 1979 who introducedDFD.DFD
models a system transforms the data and creates, output data-flows which go by suing
external entities from which data flows to a process which to other processes or external
entities or files. Data in files many also flow to processes as inputs.

There are various symbols used in DFD. Bubbles represent the process. Named arrows
indicate the dataflow. External entities are represented by rectangles and are outside the
system such as venders or customers with whom the system interacts. They either supply or
consume data. Entities supplying data are known as sources and those that consume data are
called sinks. Data are stored in a data store by a process in the system. Each component in a
DFD is labeled in with a descriptive name. Process names are further identified with a
number.

DFD can be hierarchically organized, which help in partitioning and analyzing large
systems. As a first step, one Data Flow Diagram can depict an entire system. Which gives the
system overview? It is called Context Diagram of level 0 DFD. The context diagram can be
further expanded. The successive expansion of DFD from the context diagram that giving
more details is known as leveling of DFD. Thus of top down approach is used, starting with
an overview and then working out the details.

The main merit of DFD is that it can provide an overview of what data a system would
process, what transformation of data are done, what files are used, and where the result flow.
The data flow diagram of online manager has been represented as a hierarchical DFD context
level DFD was drawn first.

Then the processes were decomposed into several elementary levels and are represented
in the order of importance.

St. Thomas Arts And Science College, Puthencruz 22

Bachelor of Computer Application Online manager

Basic DFD Symbols

Square:

A source or sink is a person or part of an organization, which enters or receives information

from the system, but is considered to be outside the context of data flow model

Arrow:

A data flow is a route, which enables packets of data to travel from one point to another. Data
may flow from a source to a processor and from data store or process. An arrow lines depicts
the flow, with arrowhead pointing in the direction of flow

Circle:

St. Thomas Arts And Science College, Puthencruz 23

Bachelor of Computer Application Online manager

A Process represents transformation where incoming data flows are changed into outgoing
data flows.

Open rectangle:

A data is a repository of data that is to be stored for use by one or more process may be as
simple as buffer or queue or sophisticated as relational database. They should have clear
names. If a process merely uses the content of store and doesn’t alter it, the arrowhead goes
only from the store to the process. If process alters the details in the store then a double-
headed arrow is used.

St. Thomas Arts And Science College, Puthencruz 24

Bachelor of Computer Application Online manager

Data flow diagram

Level 0: Context Level

St. Thomas Arts And Science College, Puthencruz 25

Bachelor of Computer Application Online manager

Level 1

St. Thomas Arts And Science College, Puthencruz 26

Bachelor of Computer Application Online manager

St. Thomas Arts And Science College, Puthencruz 27

Bachelor of Computer Application Online manager

Level 2

St. Thomas Arts And Science College, Puthencruz 28

Bachelor of Computer Application Online manager

4.4 TABLE DESIGN

The general theme behind a database is to handle information as an integrated

whole. A database is a collection if inter related data stored with minimum redundancy to

serve many quickly and effectively. It is a collection of stored data organized in such a way

that all the data requirements are satisfied by the database.

The aim of database design is to improve the existing system situation. A

number of database files were designed to hold the data requirements for running their

systems.

The following tables are used:

1. Table Name : LOGIN

Description: it is used to login details.

Field Data type Description

User name nvarchar(50) User name

Password nvarchar(50) password

User Type nvarchar(50) Type of User

St. Thomas Arts And Science College, Puthencruz 29

Bachelor of Computer Application Online manager

2. Table Name : emp

Primary key : Username
Description: it is used to employee details.

Field Data Type Description

Username nvarchar(50) Usermame
Name nvarchar(50) Name
Address nvarchar(50) Address
age Int age
Gender nvarchar(50) gender
Email nvarchar(50) Email
Phone nvarchar(11) Phone
dept nvarchar(50) Department
desig nvarchar(50) Designation
Yearofexp numeric(18, 0) Year of experience

3. Table Name : Department

Primary key : Dept-id
Description: it is used to department details.

Field Data Type Description

Dept-id Int Department Id
Dept-Name nvarchar(50) Name of department

St. Thomas Arts And Science College, Puthencruz 30

Bachelor of Computer Application Online manager

4. Table name : complaint

Primary key : Cid, Foreign key : Username
Description: it is used to complaint details

Field Data Type Description

Cid int Complaint id

Date date System date
Subject nvarchar(50) Subject
Complaint nvarchar(50) Complaint
Solution varchar(MAX) Solution
Username nvarchar(50) Username

5. Table name :emp_file

Primary key : Username
Description: it is used to store employee files.

Field Data Type Description

Username nvarchar(50) Username

Date date Date

File nvarchar(50) File

St. Thomas Arts And Science College, Puthencruz 31

Bachelor of Computer Application Online manager

6. Table name: emp_paidsal

Primary key : Username
Description: it is used to employee paid salary details.

Field Data Type Description

username nvarchar(50) Username

dateofsal date Date of salary

totsal numeric(18, 2) Total salary

leaveamt numeric(18, 2) Leave amount

actualamt numeric(18, 2) Actual amount

7. Table name: emp_punchin

Primary key : Username
Description: it is used to employee punchin details.

Field Data Type Description

username nvarchar(50) Username

Date date Date

Time nvarchar(50) Time

Status nvarchar(50) In or not

attendance varchar(50) Attendance

St. Thomas Arts And Science College, Puthencruz 32

Bachelor of Computer Application Online manager

8. Table name: holiday_calender

Primary key : Username
Description: it is used to holiday calendar details.

Field Data Type Description

Date date Date

Reason nvarchar(50) Reason

Year numeric(18, 0 Year

9. Table name: leaverequest

Primary key : Id , Foreign key : Username
Description: it is used to leave request details.

Field Data Type Description

Username nvarchar(50) Leave-request id

No-of-days int No,of days

Frm-date date From date

To-date date To date

Date date Date

Reason nvarchar(50) Reason

Status int Status

Id Int id

St. Thomas Arts And Science College, Puthencruz 33

Bachelor of Computer Application Online manager

10. Table name: notice

Primary key : Nid , Foreign key : Username
Description: it is used to notice details.

Field Data Type Description

Nid int Notice-id

Nsub varchar(50) System date

username nvarchar(50) Subject

date date date

Content varchar(MAX) Content

11. Table name: punchin_time

Primary key : Username
Description: it is used to store punchin_time.

Field Data Type Description

Username nvarchar(50) Username

Punchin varchar(50) Punchin

Punchout varchar(50) Punchout

St. Thomas Arts And Science College, Puthencruz 34

Bachelor of Computer Application Online manager

12. Table name: salarydetails

Primary key : Username
Description: it is used to store salary details

Field Data Type Description

Username nvarchar(50) Username

bp numeric(18, 2) Basic pay

da numeric(18, 2) Daily allowance

hra numeric(18, 2) Hra

ta numeric(18, 2) Ta

St. Thomas Arts And Science College, Puthencruz 35

Bachelor of Computer Application Online manager

SYSTEM TESTING
AND
IMPLEMENTATION

St. Thomas Arts And Science College, Puthencruz 36

Bachelor of Computer Application Online manager

5.1 SYSTEM TESTING

System testing is the stage of implementation, which is aimed at ensuring that the system
works accurately and efficiently before live operation commence. Testing is vital to the
success of the system. An elaborate testing of data is prepared and the system is tested using
this test data. While testing errors are noted and corrections are made. The users are trained
to operate the developed system. Both hardware and software securities are made to run the
developed system successfully in future.

Types of testing:

1. Unit Testing
2. Integration Testing
3. Validation Testing
4. Output Testing
5. User Acceptance Testing

Unit Testing

Unit testing focuses verification efforts on the smallest unit of software design, the
module. This is also known as “Module Testing”. The modules are separately. This testing is
carried out during programming stage itself. In this testing step each module is found to be
working satisfactorily as regard to the expected output from the module.

Integration Testing

Integration testing is a systematic technique for constructing tests to uncover errors

associated interface. In this project, all the modules combined. And then entire program is
tested as a whole, thus in the integration testing step, all the errors uncovered for the next
testing steps.

St. Thomas Arts And Science College, Puthencruz 37

Bachelor of Computer Application Online manager

Validation Testing

Validation testing is where requirements established as a part of software requirement

analysis is validated against the software that has been constructed. This test provides the
final assurance that the software meets all functional, behavioral and performance
requirements. The errors, which are uncovered during integration testing, are corrected
during this phase.

Output Testing

After performing the validation testing, the next step is output testing of the proposed
system since no system could be useful if it does not produce the required output in the
specific format. The output generated or displayed by the system under consideration is
tested asking the users about the format required by them. Here, the output is considered in
two ways: one is on the screen and the other is printed format.
The output format on the screen is found to be correct as the format designed according to
the user needs. For the hard copy also, the output comes out as specified by the user. Hence
output testing doesn’t result in any connection in the system.

User Acceptance Testing

User acceptance of a system is the key factor for the success of any system. The under
consideration is tested for user acceptance by constantly keeping in touch with the
prospective system users at a time of developing and making for ONLINE MANAGER
The testing of the software began along with coding. Since the design was fully object
oriented, first the interfaces were developed and tested. Then unit testing was done for every
module in the software for various inputs, such that each line of code is once executed.
After all modules were coded the integration test were carried out. Some minor errors were
found in the output at the earlier stage and each of them was corrected. In the
implementation of user interface part no major errors were found. After the software was
completely developed, the testing was done. The output of the software were correct and
accurate during the time of demonstration, after that no errors were reported

St. Thomas Arts And Science College, Puthencruz 38

Bachelor of Computer Application Online manager

5.2 SYSTEM IMPLEMENTATION

Implementation is the stage in the project where theoretical is design is turned into a
working system and is giving confidence on the new system for the users, which will work
efficiently and effectively. It involves careful planning, investigation of the current system
and its constraints on implementations, design of methods to achieve the change over, an
evaluation, of change over methods. Apart from planning major task of preparing the
implementation are education and training of users. The major complex system being
implemented the more evolved will be the system analysis and the design effort required just
for implementation. An implementation coordinating committee based on policies of
individual organization has been appointed. The implementation process begins with
preparing a plan for the implementation of the system. According to this plan, the activities
are to be carried out discussions made regarding the equipment and resources and the
additional equipment has to be acquired to implement the new system.

Implementation is the final and important phase. The most critical stage in achieving a
successful new system and in giving the users confidence that the new system will work and
be effective. The system can be implemented only after thorough testing is done and if it
found to working according to the specification. This method also offers the greatest security
since the old system can take over if the errors are found or inability to handle certain type of
transaction while using the new system.

St. Thomas Arts And Science College, Puthencruz 39

Bachelor of Computer Application Online manager

5.3 MAINTENANCE

Maintenance is the enigma of software development. It holds the software industry captive,
typing up programming resources. It is perceived as requiring neither skill nor experience.
Maintenance covers wide range of activities, including correcting, coding and design errors,
updating documentation and test data and upgrading user support.

St. Thomas Arts And Science College, Puthencruz 40

Bachelor of Computer Application Online manager

FUTURE ENHANCEMENT

St. Thomas Arts And Science College, Puthencruz 41

Bachelor of Computer Application Online manager

6. FUTURE ENHANCEMENT

The system is developed and designed such a way that further expansion or
modification can be made to permit the evaluation. The focus of the system is to inherit the
requirements and update the system as per the needs. This project is so perfectly designed
that it satisfies the requirements.

This involves provided new future such as

 More number item details can be inserted into the database.

 We can add Employee’s time card and a payroll management system in this
application.
 E-payment
 Upgrading the performance.

St. Thomas Arts And Science College, Puthencruz 42

Bachelor of Computer Application Online manager

CONCLUSION

St. Thomas Arts And Science College, Puthencruz 43

Bachelor of Computer Application Online manager

7. CONCLUSION

In this dissertation we have studied different management systems used during

evaluation and presented a low cost office management system application with the help of
that study. Online Manager is a web based office software which can be accessed by any
person from anywhere in the World. The objective of this software is to establish an
employee-employer relationship easy by systematic digital communication procedures.
There are mainly 2 end users to this application, (1) Employees (also called Users), (2)
Employers (also called Admin). Users are given manuals on how to make use of the Online
Manager. User should have knowledge in using computers and need to have knowledge of
English language. The system interfaces with the Administrator and employees of the
organization. Employees need to register to interact with the system. Administrator
controls the entire system.

To conclude this, I thank all people who help us to complete this project work successfully.

St. Thomas Arts And Science College, Puthencruz 44

Bachelor of Computer Application Online manager

BIBLIOGRAPHY

St. Thomas Arts And Science College, Puthencruz 45

Bachelor of Computer Application Online manager

8. BIBLIOGRAPHY

SOFTWARE ENGINEERING

Roger’s. Pressman

COMPLETE HTML

Steven Holzner

UNIFIED MODELING LANGUAGE

Grady Booch, Ranbaugh, Jacobson

SQL FOR PROFESSIONALS

Jain

C#.NET Black Book

Evangeleous Petersons

MANAGING PROJECTS

Gwen Lowery

St. Thomas Arts And Science College, Puthencruz 46

Bachelor of Computer Application Online manager

APPENDIX

St. Thomas Arts And Science College, Puthencruz 47

Bachelor of Computer Application Online manager

9.1 SCREEN SHOTS

ADMIN

Login

St. Thomas Arts And Science College, Puthencruz 48

Bachelor of Computer Application Online manager

Admin home

St. Thomas Arts And Science College, Puthencruz 49

Bachelor of Computer Application Online manager

Approve leave request

St. Thomas Arts And Science College, Puthencruz 50

Bachelor of Computer Application Online manager

Add calendar

St. Thomas Arts And Science College, Puthencruz 51

Bachelor of Computer Application Online manager

Add Department

St. Thomas Arts And Science College, Puthencruz 52

Bachelor of Computer Application Online manager

Employee Registration

St. Thomas Arts And Science College, Puthencruz 53

Bachelor of Computer Application Online manager

Add notice

St. Thomas Arts And Science College, Puthencruz 54

Bachelor of Computer Application Online manager

View Attendance

St. Thomas Arts And Science College, Puthencruz 55

Bachelor of Computer Application Online manager

Salary

St. Thomas Arts And Science College, Puthencruz 56

Bachelor of Computer Application Online manager

View complaint

St. Thomas Arts And Science College, Puthencruz 57

Bachelor of Computer Application Online manager

Add Salary details

St. Thomas Arts And Science College, Puthencruz 58

Bachelor of Computer Application Online manager

Employee List

St. Thomas Arts And Science College, Puthencruz 59

Bachelor of Computer Application Online manager

Punch in

St. Thomas Arts And Science College, Puthencruz 60

Bachelor of Computer Application Online manager

Punch out

St. Thomas Arts And Science College, Puthencruz 61

Bachelor of Computer Application Online manager

Employee
Login

St. Thomas Arts And Science College, Puthencruz 62

Bachelor of Computer Application Online manager

Home

St. Thomas Arts And Science College, Puthencruz 63

Bachelor of Computer Application Online manager

Apply leave

St. Thomas Arts And Science College, Puthencruz 64

Bachelor of Computer Application Online manager

View Salary

St. Thomas Arts And Science College, Puthencruz 65

Bachelor of Computer Application Online manager

View Notice

St. Thomas Arts And Science College, Puthencruz 66

Bachelor of Computer Application Online manager

Sent complaint

St. Thomas Arts And Science College, Puthencruz 67

Bachelor of Computer Application Online manager

View Complaint

St. Thomas Arts And Science College, Puthencruz 68

Bachelor of Computer Application Online manager

View leave

St. Thomas Arts And Science College, Puthencruz 69

Bachelor of Computer Application Online manager

Logout

St. Thomas Arts And Science College, Puthencruz 70

Bachelor of Computer Application Online manager

View calendar

St. Thomas Arts And Science College, Puthencruz 71

Bachelor of Computer Application Online manager

9.2 SOURCE CODE

Add department

using System;

usingSystem.Collections.Generic;

usingSystem.Linq;

usingSystem.Web;

usingSystem.Web.UI;

usingSystem.Web.UI.WebControls;

usingSystem.Data;

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

Class1 ob = new Class1();

DataSetdt = new DataSet();

protected void Page_Load(object sender, EventArgs e)

if (!IsPostBack)

string t = "select * from department";

dt = ob.fillData(t);

GridView1.DataSource = dt;

GridView1.DataBind();

St. Thomas Arts And Science College, Puthencruz 72

Bachelor of Computer Application Online manager

protected void Button1_Click(object sender, EventArgs e)

string sql2 = "insert into department values('" + txtDname.Text + "')";

ob.exeNonQuery(sql2);

Response.Write("<script> alert('Inserted Successfully')</script>");

txtDname.Text = "";

protected void Button3_Click(object sender, EventArgs e)

Response.Redirect("~//admin//adminhome.aspx");

protected void Button2_Click(object sender, EventArgs e)

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)

if (e.CommandName == "Del")

GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).NamingContainer;

Label lb = (Label)row.FindControl("depid");

ob.exeNonQuery("delete from department where deptid='"+lb.Text+"'");

St. Thomas Arts And Science College, Puthencruz 73

Bachelor of Computer Application Online manager

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

//int row = e.NewEditIndex;

GridView1.EditIndex = e.NewEditIndex;

//string id=GridView1.Rows[row].Cells[0].ToString();

//string text = GridView1.Rows[row].Cells[1].ToString();

//ob.exeNonQuery("update department set deptname='" + text + "' where deptid='"+id+"'");

string t = "select * from department";

dt = ob.fillData(t);

GridView1.DataSource = dt;

GridView1.DataBind();

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

//string s = GridView1.DataKeys[e.RowIndex].Value.ToString();

Label depid = (Label)GridView1.Rows[e.RowIndex].FindControl("depid");

TextBoxdepname = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1");

ob.exeNonQuery("update department set deptname='" + depname.Text + "' where deptid='" +

depid.Text + "'");

string t = "select * from department";

St. Thomas Arts And Science College, Puthencruz 74

Bachelor of Computer Application Online manager

dt = ob.fillData(t);

GridView1.DataSource = dt;

GridView1.DataBind();

GridView1.EditIndex = -1;

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

GridView1.EditIndex = -1;

string t = "select * from department";

dt = ob.fillData(t);

GridView1.DataSource = dt;

GridView1.DataBind();

St. Thomas Arts And Science College, Puthencruz 75

Bachelor of Computer Application Online manager

Employee registration

using System;

usingSystem.Collections.Generic;

usingSystem.Linq;

usingSystem.Web;

usingSystem.Web.UI;

usingSystem.Web.UI.WebControls;

usingSystem.Data.SqlClient;

usingSystem.Data;

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

Class1 obj = new Class1();

protected void Page_Load(object sender, EventArgs e)

if (!IsPostBack)

string s = "select * from department";

DataSet d1 = obj.fillData(s);

drpDepartmnt.DataTextField = "deptname";

drpDepartmnt.DataSource = d1;

drpDepartmnt.DataBind();

St. Thomas Arts And Science College, Puthencruz 76

Bachelor of Computer Application Online manager

drpYoe.Items.Add("select");

for (int i = 0; i <= 10; i++)

drpYoe.Items.Add(i.ToString());

protected void Button1_Click(object sender, EventArgs e)

string gender="";

if (RadioButton1.Checked==true)

gender=RadioButton1.Text;

else

gender=RadioButton2.Text;

string sql="insert into emp values('"+ txtName.Text +"','"+ txtUname.Text +"','"+ txtAddress.Text
+"','"+ txtAge.Text +"','"+ gender +"','"+ txtEmail.Text +"','"+ txtPhone.Text +"','"+
drpDepartmnt.SelectedItem +"','"+ txtDesigntn.Text +"','"+ drpYoe.SelectedItem +"')";

obj.exeNonQuery(sql);

string sql1 = "insert into login values('" + txtUname.Text + "','" + txtPwd.Text + "','user')";

obj.exeNonQuery(sql1);

Response.Write("<script> alert('Insert')</script>");

protected void Button2_Click(object sender, EventArgs e)

St. Thomas Arts And Science College, Puthencruz 77

Bachelor of Computer Application Online manager

txtName.Text = "";

txtUname.Text = "";

txtPwd.Text = "";

txtAddress.Text = "";

txtAge.Text= "";

RadioButton1.Checked = false;

txtEmail.Text= "";

txtPhone.Text= "";

drpDepartmnt.Text = "select";

txtDesigntn.Text = "";

drpYoe.Text="select";

protected void Button3_Click(object sender, EventArgs e)

Button1.Enabled = false;

String Q = "select count(*) from emp where username='" + txtUname.Text + "'";

int count = Convert.ToInt32(obj.exeScalar(Q));

if (count > 0)

Response.Write("<script> alert('User already exist')</script>");

txtUname.Text = "";

St. Thomas Arts And Science College, Puthencruz 78

Bachelor of Computer Application Online manager

txtUname.Focus();

else

Button1.Enabled = true;

Response.Write("<script> alert('Valid username')</script>");

protected void Button4_Click(object sender, EventArgs e)

Response.Redirect("~//admin//adminhome.aspx");

St. Thomas Arts And Science College, Puthencruz 79

Bachelor of Computer Application Online manager

Log in

using System;

usingSystem.Collections.Generic;

usingSystem.Linq;

usingSystem.Web;

usingSystem.Web.UI;

usingSystem.Data.SqlClient;

usingSystem.Data;

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

Class1 obj = new Class1();

protected void Page_Load(object sender, EventArgs e)

protected void Button2_Click(object sender, EventArgs e)

string sql1 = "select * from login where username='"+txtUname.Text +"' and

password='"+txtPwd.Text +"'";

obj.exeRead(sql1);

if (obj.dr.Read())

Response.Write("login sucess");

if (obj.dr["usertype"].ToString() == "admin")

St. Thomas Arts And Science College, Puthencruz 80

Bachelor of Computer Application Online manager

Response.Redirect("~//admin//adminhome.aspx");

else

Session.Add("emp", txtUname.Text);//session variable

Response.Redirect("~//employ//employhome.aspx");

else

Response.Write("<script language='javascript'>alert('Login Unsuccessfully')</script>");

txtUname.Text = "";

txtPwd.Text = "";

protected void Button3_Click(object sender, EventArgs e)

txtUname.Text = "";

txtPwd.Text = "";

St. Thomas Arts And Science College, Puthencruz 81

Bachelor of Computer Application Online manager

Punch in

using System;

usingSystem.Collections.Generic;

usingSystem.Linq;

usingSystem.Web;

usingSystem.Web.UI;

usingSystem.Web.UI.WebControls;

usingSystem.Data.SqlClient;

usingSystem.Data;

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

Class1 obj = new Class1();

static string att;

protected void Page_Load(object sender, EventArgs e)

if (!IsPostBack)

string s = "select * from emp ";

DataSet d1 = obj.fillData(s);

drpename.DataTextField = "username";

drpename.DataSource = d1;

drpename.DataBind();

St. Thomas Arts And Science College, Puthencruz 82

Bachelor of Computer Application Online manager

txtdate.Text = DateTime.Now.Date.ToString("dd/MM/yyyy");

txttime.Text = DateTime.Now.ToString("hh:mm");

if (DateTime.Now<= Convert.ToDateTime(txtdate.Text + "AM" + "10:00"))

att = "PRESENT";

else

att = "HF LEAVE";

protected void Button1_Click(object sender, EventArgs e)

string s2 = drpename.SelectedItem.Text ;

String s1="select * from emp_punchin where username='" +s2 + "' and

date='"+DateTime.Now.Date.ToString("dd/MM/yyyy")+"' and status='in'";

SqlDataReaderdr=obj.exeRead(s1);

if (dr.Read())

Response.Write("<script> alert('Already punched')</script>");

Else

St. Thomas Arts And Science College, Puthencruz 83

Bachelor of Computer Application Online manager

stringsql = "insert into emp_punchin values('" + s2 + "','" +

DateTime.Now.Date.ToString("dd/MM/yyyy") + "','" + DateTime.Now.ToString("hh:mm") +
"','in','"+att+"')";

obj.exeNonQuery(sql);

Response.Write("<script> alert('punched')</script>");

protected void Button2_Click(object sender, EventArgs e)

protected void Button3_Click(object sender, EventArgs e)

Response.Redirect("~//admin//adminhome.aspx");

St. Thomas Arts And Science College, Puthencruz 84

Bachelor of Computer Application Online manager

Punch out

using System;

usingSystem.Collections.Generic;

usingSystem.Linq;

usingSystem.Web;

usingSystem.Web.UI;

usingSystem.Web.UI.WebControls;

usingSystem.Data.SqlClient;

usingSystem.Data;

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

Class1 obj = new Class1();

static string att;

protected void Page_Load(object sender, EventArgs e)

if (!IsPostBack)

string s = "select * from emp";

DataSet d1 = obj.fillData(s);

drpename.DataTextField = "username";

drpename.DataSource = d1;

drpename.DataBind();

St. Thomas Arts And Science College, Puthencruz 85

Bachelor of Computer Application Online manager

txtout.Text = DateTime.Now.Date.ToString("dd/MM/yyyy");

txttime.Text = DateTime.Now.ToString("hh:mm");

if (DateTime.Now<= Convert.ToDateTime(txtout.Text + "AM" + "10:00"))

att = "PRESENT";

else

att = "HF LEAVE";

protected void Button1_Click(object sender, EventArgs e)

string s = drpename.SelectedItem.Text;

String s1="select * from emp_punchin where username='" +s +"' and

date='"+DateTime.Now.Date.ToString("dd/MM/yyyy")+"' and status='out'";

SqlDataReaderdr=obj.exeRead(s1);

if (dr.Read())

Response.Write("<script> alert('Already punchedout')</script>");

St. Thomas Arts And Science College, Puthencruz 86

Bachelor of Computer Application Online manager

else

string sql1 = "insert into emp_punchin values('" + s + "','" +

DateTime.Now.Date.ToString("dd/MM/yyyy") + "','" + DateTime.Now.ToString("hh:mm") +
"','out','"+att+"')";

obj.exeNonQuery(sql1);

string sql2 = "insert into emp_files values('" + s + "','" + DateTime.Now.Date.ToString("dd/MM/yyyy")

+ "','" + txtfile.Text + "')";

obj.exeNonQuery(sql2);

Response.Write("<script> alert('punchedout')</script>");

protected void Button2_Click(object sender, EventArgs e)

protected void Button3_Click(object sender, EventArgs e)

Response.Redirect("~//admin//adminhome.aspx");

St. Thomas Arts And Science College, Puthencruz 87

Bachelor of Computer Application Online manager

Employee leave

using System;

usingSystem.Collections.Generic;

usingSystem.Linq;

usingSystem.Web;

usingSystem.Web.UI;

usingSystem.Web.UI.WebControls;

usingSystem.Data.SqlClient;

usingSystem.Data;

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

Class1 obj = new Class1();

protected void Page_Load(object sender, EventArgs e)

// string sq1= "select name from emp where username='"+s+"'";//name is inserted into table(not
username)

// txtename.Text=obj.exeScalar(sq1).ToString();

txtdate.Text = DateTime.Now.Date.ToString("dd/MM/yyyy");

St. Thomas Arts And Science College, Puthencruz 88

Bachelor of Computer Application Online manager

protected void Button1_Click(object sender, EventArgs e)

string s = Session["emp"].ToString();

stringsql = "insert into leaverequest values('" + s+ "','" + txtnofdays.Text + "','" + txtfrmdate.Text + "','"
+ txttodate.Text + "','" + txtdate.Text + "','" + txtreason.Text + "',0)";

obj.exeNonQuery(sql);

Response.Write("<script language='javascript'>alert('Inserted Successfully')</script>");

St. Thomas Arts And Science College, Puthencruz 89

Bachelor of Computer Application Online manager

Add salary form

using System;

usingSystem.Collections.Generic;

usingSystem.Linq;

usingSystem.Web;

usingSystem.Web.UI;

usingSystem.Web.UI.WebControls;

usingSystem.Data.SqlClient;

usingSystem.Data;

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

Class1 ob=new Class1();

protected void Page_Load(object sender, EventArgs e)

if (!IsPostBack)

string s1 = "select * from department";

DataSet d1 = ob.fillData(s1);

drpdept.DataTextField = "deptname";

drpdept.DataSource = d1;

drpdept.DataBind();

St. Thomas Arts And Science College, Puthencruz 90

Bachelor of Computer Application Online manager

drpdept.Items.Insert(0, "Select");

protected void Button1_Click(object sender, EventArgs e)

string st = "select username from emp where name='" + drpename.SelectedItem + "'";

stringnam = ob.exeScalar(st).ToString();

int count = int.Parse(ob.exeScalar("select count(username) from salarydetails where username='" +

nam + "'"));

if (count == 0)

stringsql = "insert into salarydetails values('" + nam + "','" + txtbp.Text + "','" + txtda.Text + "','" +
txthra.Text + "','" + txtta.Text + "')";

ob.exeNonQuery(sql);

else

stringsql = "update salarydetails set bp='" + txtbp.Text + "'and da='" + txtda.Text + "'and hra='" +
txthra.Text + "'and ta='" + txtta.Text + "' where username='"+nam+"')";

ob.exeNonQuery(sql);

protected void drpdept_SelectedIndexChanged(object sender, EventArgs e)

St. Thomas Arts And Science College, Puthencruz 91

Bachelor of Computer Application Online manager

string s = "select name from emp where dept='"+drpdept.SelectedItem+"'";

DataSet d1 = ob.fillData(s);

drpename.DataTextField = "name";

drpename.DataSource = d1;

drpename.DataBind();

protected void Button3_Click(object sender, EventArgs e)

Response.Redirect("~//admin//adminhome.aspx");

St. Thomas Arts And Science College, Puthencruz 92

Bachelor of Computer Application Online manager

Add notice

using System;

usingSystem.Collections.Generic;

usingSystem.Linq;

usingSystem.Web;

usingSystem.Web.UI;

usingSystem.Web.UI.WebControls;

usingSystem.Data;

publicpartialclassadmin_Addnotice : System.Web.UI.Page

Class1obj = newClass1();

protectedvoidPage_Load(object sender, EventArgs e)

if (!IsPostBack)

DataSet ds = obj.fillData("select * from emp");

GridView1.DataSource = ds.Tables[0];

GridView1.DataBind();

protectedvoidrdselall_CheckedChanged(object sender, EventArgs e)

if (rdselall.Checked == true)

St. Thomas Arts And Science College, Puthencruz 93

Bachelor of Computer Application Online manager

foreach (GridViewRow row in GridView1.Rows)

CheckBoxck = (CheckBox)row.FindControl("CheckBox1");

ck.Checked = true;

protectedvoid GridView1_RowCommand(object sender, GridViewCommandEventArgs e)

//GridViewRow gr = (GridViewRow)((CheckBox)e.CommandSource).NamingContainer;

//CheckBoxchk = (CheckBox)gr.FindControl("CheckBox1");

//if (chk.Checked == true)

//{

// Label lb = (Label)gr.FindControl("Label5");

// Label lb1 = (Label)gr.FindControl("Label6");

// ViewState["unames"] = lb.Text;

// ViewState["dipid"] = lb1.Text;

//}

protectedvoidbtsend_Click(object sender, EventArgs e)

St. Thomas Arts And Science College, Puthencruz 94

Bachelor of Computer Application Online manager

foreach (GridViewRow row in GridView1.Rows)

CheckBoxchk = (CheckBox)row.FindControl("CheckBox1");

if (chk.Checked == true)

Labellb = (Label)row.FindControl("Label5");

obj.exeNonQuery("insert into notice values('" + txtsub.Text + "','" + lb.Text + "','" + txtdate.Text + "','"
+ txtnotice.Text + "')");

Response.Write("<script> alert('Notice added')</script>");

protectedvoid rdselall_CheckedChanged1(object sender, EventArgs e)

if (rdselall.Checked == true)

foreach (GridViewRow row in GridView1.Rows)

CheckBoxck = (CheckBox)row.FindControl("CheckBox1");

ck.Checked = true;

St. Thomas Arts And Science College, Puthencruz 95

Bachelor of Computer Application Online manager

else

foreach (GridViewRow row in GridView1.Rows)

CheckBoxck = (CheckBox)row.FindControl("CheckBox1");

ck.Checked = false;

protectedvoidbtback_Click(object sender, EventArgs e)

Response.Redirect("~//admin//adminhome.aspx");

St. Thomas Arts And Science College, Puthencruz 96

Bachelor of Computer Application Online manager

Add complaint

using System;

usingSystem.Collections.Generic;

usingSystem.Linq;

usingSystem.Web;

usingSystem.Web.UI;

usingSystem.Web.UI.WebControls;

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

Class1 obj = new Class1();

protected void Page_Load(object sender, EventArgs e)

protected void btsend_Click(object sender, EventArgs e)

obj.exeNonQuery("insert into complaint values('" + Session["emp"].ToString() + "','" +

DateTime.Now.ToShortDateString() + "','" + txtsub.Text + "','" + txtcontent.Text + "','')");

Response.Write("<script> alert('Complaint is sented')</script>");

St. Thomas Arts And Science College, Puthencruz 97

Bachelor of Computer Application Online manager

Log

using System;

usingSystem.Collections.Generic;

usingSystem.Linq;

usingSystem.Web;

usingSystem.Web.UI;

usingSystem.Web.UI.WebControls;

usingSystem.Data;

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

Class1 obj = new Class1();

protected void Page_Load(object sender, EventArgs e)

protected void Button2_Click(object sender, EventArgs e)

string sql1 = "select * from login where username='" + txtUname.Text + "' and password='" +
txtPwd.Text + "'";

obj.exeRead(sql1);

St. Thomas Arts And Science College, Puthencruz 98

Bachelor of Computer Application Online manager

if (obj.dr.Read()

Response.Write("login sucess");

if (obj.dr["usertype"].ToString() == "admin")

Response.Redirect("~//admin//adminhome.aspx");

else

Session.Add("emp", txtUname.Text);//session variable

Response.Redirect("~//employ//Emplhome.aspx");

else

//Response.Write("login unsucessfull");

Response.Write("<script language='javascript'>alert('Login Unsuccessfully')</script>");

txtUname.Text = "";

txtPwd.Text = "";

St. Thomas Arts And Science College, Puthencruz 99

Bachelor of Computer Application Online manager

protected void Button3_Click(object sender, EventArgs e)

txtUname.Text = "";

txtPwd.Text = "";

St. Thomas Arts And Science College, Puthencruz 100