1.Problem Statement

Ex.No:1

PAYROLL SYSTEM

Date:

1.Problem statement:

· Automated Payroll Processing is a web application based on Client

Server and Electronic payment technology, which is aimed at developing a System that manages the payment of monthly wages of employees in an organization.

· This application is supported by a database consisting of employee’s

salary details and their leave allowances. Based on these details at the end of every month the application automatically credits the employee’s bank account with their salary. The amount of salary credited into employees account is a variant of their leave allowances.

· This Payroll Processing application also considers employee’s income

tax regulations and loan payment details. Based on these considerations the salary of each employee is deducted at the source. Taking into account all these aspects the appropriate accounts of each employee are credited. This application also includes generation of salary slips to every employee.

· Finally our project facilitates the activity of crediting the employee’s

account with their salaries integrated with deductions based on leave allowances, loan payments and updating of income tax regulations giving a holistic solution to the Organization.

2.Problem Analysis and Project Planning:

2.1: Objective/aim:

To design a model for payroll system using UML diagram and

generate code using VB.

2.2 :ACTORS identified and its role:

Employee: Employee plays its role on viewing the salary details and viewing employee details.

Controller: controller plays its role by entering employee details, maintaining employee details,maintaining salary details, report generation and viewing employee details.

2.3 : CLASSES identified and its role:

Employee: Employee plays its role on viewing the salary details and viewing employee details.

Payroll system: Its role is to verify password , viewing the salary details,entering employee details, maintaining the employee details viewing the employee details, viewing the salary details,calculate net pay and reort generation

Controller: controller plays its role by entering employee details, maintaining employee details,maintaining salary details, report generation and viewing employee details.

.3. Software requirement Analysis:

A) Hardware Requirements:

Processor : Pentium Core2Duo

Main Memory (RAM) : 1GB

Secondary Memory : 160GB

Monitor : SVGA 15” Color

Key Board : Multimedia and Internet Keyboard

Mouse : Optical Scroll Mouse

DVD Drive : 52x

B) Software Requirements:

Operating System : Windows XP

Technology : Microsoft Technology/Sun Technology

Package/Language : Visual Basic 6.0 or JAVA

Database : MS-Access

CASE Tool : Rational Rose Enterprise Edition

C)Modules of the project:

1. Administrator

2. Employee.

4.Data Modeling:

a) Use case diagram

b) Class diagram

c) Activity diagram

d) Sequence diagram

e) Collaboration diagram

5.Software development and debugging:

1.Coding

Private Sub Command1_Click()

Data1.Recordset.MoveFirst

While (Not Data1.Recordset.EOF)

If (Text1.Text = Data1.Recordset.Fields(5)) Then

If (Text2.Text = Data1.Recordset.Fields(4)) Then

Me.Hide

Form2.Show

GoTo endsub

Else

MsgBox ("Invalid Password")

End If

Data1.Recordset.MoveNext

Wend

MsgBox ("Invalid Username")

endsub:

End Sub

Private Sub Command2_Click()

Me.Hide

Form3.Show

End Sub

Admin Form

Private Sub Command1_Click()

Me.Hide

Form3.Show

End Sub

Private Sub Command2_Click()

amt = InputBox("enter the A/C.No to be edit")

Data1.Recordset.MoveFirst

If (amt = Data1.Recordset.Fields(5)) Then

Me.Hide

Form4.Show

Else

Data1.Recordset.MoveNext

End If

End Sub

Private Sub Command3_Click()

Data2.Recordset.MoveFirst

acno = InputBox("enter the A/C.No")

While Not (Data2.Recordset.EOF)

If (acno = Data2.Recordset.Fields(0)) Then

Data2.Recordset.Edit

amt = InputBox("Enter the amount")

Data2.Recordset.Fields(1) = amt

Data2.Recordset.Update

MsgBox ("salary updated")

GoTo end1:

End If

Data2.Recordset.MoveNext

Wend

MsgBox ("Account no invalid")

end1:

End Sub

Private Sub Command4_Click()

Me.Hide

Form5.Show

End Sub

Private Sub Command5_Click()

Me.Hide

Form1.Show

End Sub

New Employee Details

Private Sub Command1_Click()

Data1.Recordset.MoveFirst

Data1.Recordset.AddNew

Data2.Recordset.MoveFirst

Data2.Recordset.AddNew

Data1.Recordset.Fields(0) = Text1.Text

Data1.Recordset.Fields(1) = Text2.Text

Data1.Recordset.Fields(2) = Text3.Text

Data1.Recordset.Fields(3) = Text4.Text

Data1.Recordset.Fields(4) = Text5.Text

Data1.Recordset.Fields(5) = Text6.Text

Data2.Recordset.Fields(0) = Text6.Text

Data1.Recordset.Update

Data2.Recordset.Update

Me.Hide

Form2.Show

End Sub

Update Employee Details

Private Sub Command1_Click()

Data1.Recordset.MoveFirst

Data1.Recordset.Edit

Data1.Recordset.Fields(0) = Text1.Text

Data1.Recordset.Fields(1) = Text2.Text

Data1.Recordset.Fields(2) = Text3.Text

Data1.Recordset.Fields(3) = Text4.Text

Data1.Recordset.Fields(4) = Text5.Text

Data1.Recordset.Fields(5) = Text6.Text

Data1.Recordset.Update

Me.Hide

Form2.Show

End Sub

View Salary Details

Private Sub Command1_Click()

Data2.Recordset.MoveFirst

While Not (Data2.Recordset.EOF)

Text1.Text = Data2.Recordset.Fields(0)

Text2.Text = Data2.Recordset.Fields(1)

Data2.Recordset.MoveNext

Wend

MsgBox "last record"

End Sub

Private Sub Command2_Click()

Data2.Recordset.MovePrevious

Text1.Text = Data2.Recordset.Fields(0)

Text2.Text = Data2.Recordset.Fields(1)

End Sub

2.Output

Admin Form

Employee Details

Update Employee Details

Update Salary

View Salary

6.Software Testing

1.Test plan

· Testing is a process of executing a program with the intent of finding an error.

· A good test case is the one that has a high probability of finding an as-yet

undiscovered error.

· A successful test is one that uncovers an as-yet undiscovered error.

2.Test case

In order to make sure that the system does not have errors, the different levels of

testing strategies that are applied at different stages of software development are:

Unit Testing.

System Testing.

Unit Testing:

Unit testing is done on individual modules as they are completed and become

executable. Unit testing treats each component as stand-alone entity which does not need other components during the testing process.

System Testing:

This involves in-house testing of the entire system before delivery to the user. Its

aim is to satisfy the user. The system meets all the requirements of the client’s

specification.

Performance / 25
Record / 15
Viva Voice / 10
Total / 50

7. RESULT:

Thus the model for payroll using UML diagram and generated code using VB, verified successfully.