To Develop a Employee Payroll System Using Visual Basic

EX.NO:1

DATE:

EMPLOYEE PAYROLL SYSTEM

AIM:

To develop a Employee Payroll System using visual Basic.

PROCEDURE:

1. Problem statement

Software is to be designed for supporting a computerized employee payroll system. All the process involved in a employee payroll is computerized. The salary details have to be recorded and employee must be able to review it. The software which contains all data includes the details such as name, employee department and employee ID.It is access to employee given by the server. The system to be designed such that is automatically checks the data after data stored. The proposal system must satisfy user requirements, designed aesthetic and derive usability and quality assurance

2. Project planning

·  Algorithm

·  Start the process

·  The administrator asks for the employee details.

·  Then the administrator asks for the salary details

·  The employee enters the salary details and the pay salary of employee

3. Problem requirement analysis

Basic requirement

·  Validity of the employee

·  Enter the salary details of the employee

·  Ensure the result analysis

Functional requirement

·  The employee must store the data to database

·  Each time salary has to be recorded and the employee must be able to review all salary

·  All data includes the following details: name, employee id, dept etc..

·  Access to the employee is given by the server

·  The system to be designed such that it automatically checks the data after stored

Non functional requirement

·  System should be simple to operate without any formal training

·  System must be reused and protest from library member and other unauthorized users

·  Handle network and power failure

·  Efficient and quick recover from the fault

SYSTEM REQUIREMENTS:

FRONT END: VISUAL BASIC

BACK END: MS ACCESS

USE CASE DIAGRAM

SEQUENTIAL DIAGRAM

COLLOBORATION DIAGRAM

CLASS DIAGRAM

SOURCE CODE AND DESIGN FORM:

FRONT – END (VB 6.0)

START à PROGRAMS à MICROSOFT VISUAL STUDIO 6.0 à MICROSOFT VISUAL BASIC 6.0 à OPEN STANDARD EXE

DESIGN:

FORM 1:

FORM 2:

FORM 3:

CODING:

FORM1:

Private Sub cmdEmployee_Click()

Form2.Show

End Sub

Private Sub cmdSalary_Click()

Form3.Show

End Sub

FORM 2:

Private Sub cmdAdd_Click()

Data1.Recordset.AddNew

End Sub

Private Sub cmdDelete_Click()

Data1.Recordset.Delete

If Data1.Recordset.EOF Then

Data1.Recordset.MoveLast

ElseIf Data1.Recordset.BOF Then

Data1.Recordset.MoveFirst

Else

Data1.Recordset.MoveNext

End If

MsgBox "Record Deleted Successfully", vbInformation

End Sub

Private Sub cmdFirst_Click()

Data1.Recordset.MoveFirst

If Data1.Recordset.BOF Then

MsgBox "Beginning Of File", vbCritical

End If

End Sub

Private Sub cmdLast_Click()

Data1.Recordset.MoveLast

If Data1.Recordset.EOF Then

MsgBox "End Of File", vbCritical

End If

End Sub

Private Sub cmdNext_Click()

Data1.Recordset.MoveNext

If Data1.Recordset.EOF Then

Data1.Recordset.MoveLast

MsgBox "End Of File", vbCritical

End If

End Sub

Private Sub cmdPrev_Click()

Data1.Recordset.MovePrevious

If Data1.Recordset.BOF Then

Data1.Recordset.MoveFirst

MsgBox "Beginning Of File", vbCritical

End If

End Sub

Private Sub cmdUpdate_Click()

Data1.Recordset.Edit

Data1.Recordset.Update

End Sub

Private Sub lableback_Click()

Form1.show

Me.hide

End Sub

Private Sub Form_Load()

Form1.Hide

End Sub

Private Sub Form_Unload(Cancel As Integer)

Form1.Show

End Sub

FORM 3:

Private Sub cmdCalc_Click()

da.Text = sal.Text * 0.1

ta.Text = sal.Text * 0.2

hra.Text = sal.Text * 0.3

pf.Text = sal.Text * 0.2

gross.Text = Val(da.Text) + Val(ta.Text) + Val(hra.Text) - Val(pf.Text)

netsal.Text = Val(sal.Text) - Val(gross.Text)

End Sub

Private Sub lableback_Click()

Form1.show

Me.hide

End Sub

BACK – END (MS – ACCESS 7.0)

STEPS:

·  Goto Add-Ins and click visual data manager.

·  Goto FileàSelect Newà Select MS-AccessàSelect Version 7.0 MDBà Give database name and table name save.

·  Create the database fields.

·  Insert few records.

·  Save the file.

·  Close the database.

·  Run the VB Program.

Software testing

·  Test cases

·  Verification and validation test cases

·  Faults encounters during entry

·  System response for irrelevant questions

·  Mistakes done by user when entering details

·  Incomplete application submission

·  Action taken by the system when eligible and unavailability of seats

·  Time delay in fees remittance

·  Cancellation registration

·  User interface test cases

·  Is it easy to operate?

·  Understandable

·  Is it visually pleasing

·  Is it efficient use

·  Is there fast recovery from errors

Result:

Thus the system is developed using object oriented programming approach with the help of CASE tools

EX.NO:2

DATE:

ONLINE SHOPPING

AIM:

To develop a web-based shopping using visual basic.

PROCEDURE:

1. Problem statement

Software is to be designed for supporting a computerized Online Shopping. All the process involved in a Online Shopping is computerized. The price details have to be recorded and customer must be able to review it. The software which contains all data includes the details such as Dress name and Dress price. It is access to customer given by the server. The system to be designed such that is automatically checks the data after data stored. The proposal system must satisfy user requirements, designed aesthetic and derive usability and quality assurance

2. Project planning

·  Algorithm

·  Start the process

·  The server asks for the customer details.

·  Then the server asks for the type of costume.

·  The customer enters the personal details and the type of costumes they wanted.

3. Problem requirement analysis

Basic requirement

·  Validity of the credit card number.

·  Enter the price details of the costumes

·  Ensure the result analysis

Functional requirement

·  The customer must store the data about their details to database

·  All data includes the following details: name, place, card number etc..

·  Access to the customer is given by the server

·  The system to be designed such that it automatically checks the data after stored

Non functional requirement

·  System should be simple to operate without any formal training

·  System must be reused and protest from unauthorized users.

·  Handle network and power failure

·  Efficient and quick recover from the fault

SYSTEM REQUIREMENTS:

SOURCE CODE AND DESIGN FORM:

FRONT END : VISUAL BASIC

BACK END: MS ACCESS

START->PROGRAMS->MICROSOFT VISUAL STUDIO 6.0 -> MICROSOFT VISUAL BASIC 6.0 -> OPEN STANDARD EXE.

USECASE DIAGRAM:

SEQUENTIAL DIAGRAM:

COLLABRATION DIAGRAM:

STATE DIAGRAM

DESIGNS:

FORM 1:

FORM 2:

FORM 3:

FORM 4:

FORM 5:

CODINGS:

FORM 1:

Private Sub Command1_Click()

Form2.Show

Main.Hide

End Sub

FORM 2:

Private Sub Command1_Click()

Form3.Show

End Sub

Private Sub Command2_Click()

Form4.Show

End Sub

Private Sub Command3_Click()

Form2.Hide

Main.Show

End Sub

FORM 3:

Private Sub Command1_Click()

Form5.Show

Form5.Text5.Text = "saree"

Form3.Hide

End Sub

Private Sub Command2_Click()

Form5.Show

Form5.Text5.Text = "silk saree"

Form3.Hide

End Sub

FORM 4:

Private Sub Command1_Click()

Form5.Show

Form5.Text5.Text = "shirt"

Form4.Hide

End Sub

Private Sub Command2_Click()

Form5.Show

Form5.Text5.Text = "pant"

Form4.Hide

End Sub

FORM 5:

Private Sub Command1_Click()

Data1.Recordset.AddNew

Data1.Recordset!cname = Text1.Text

Data1.Recordset!cardno = Val(Text2.Text)

Data1.Recordset!pwd = Text3.Text

Data1.Recordset!cost = Val(Text4.Text)

Data1.Recordset.Update

MsgBox "data is saved", vbExclamation

Text1.Text = ""

Text2.Text = ""

Text3.Text = ""

Text4.Text = ""

Text5.Text = ""

Form2.Show

Me.Hide

End Sub

Private Sub Form_Load()

Data1.Visible = False

End Sub

Software testing

·  Test cases

·  Verification and validation test cases

·  Faults encounters during entry

·  System response for irrelevant questions

·  Mistakes done by user when entering details

·  Incomplete application submission

·  Action taken by the system when eligible and unavailability of seats

·  Time delay in fees remittance

·  Cancellation registration

·  User interface test cases

·  Is it easy to operate?

·  Understandable

·  Is it visually pleasing

·  Is it efficient use

·  Is there fast recovery from errors

CONCLUSION:

Thus the web-based online shopping are implemented and executed.

EX.NO:3

DATE:

ONLINE VOTING SYSTEM

AIM:

To develop a online Voting system using visual basic.

PROCEDURE:

1. Problem statement

Software is to be designed for supporting a computerized Online Voting. All the process involved in a Online Voting is computerized. The party details have to be recorded and voter must be able to view it. The software which contains all data includes the details such as Elector name and Party name. It is access to party name given by the server. The system to be designed such that is automatically checks the data after data stored. The proposal system must satisfy user requirements, designed aesthetic and derive usability and quality assurance

2. Project planning

·  Algorithm

·  Start the process

·  The server asks for the voter details.

·  Then the server show the party list.

·  The person enter the party name as they want.

3. Problem requirement analysis

Basic requirement

·  Collect the parties.

·  Enter the Elector name and the parties.

·  Ensure the result analysis.

Functional requirement

·  The voter must store the data about their details to database

·  All data includes the following details: name and party name.

·  Access to the elector is given by the server

·  The system to be designed such that it automatically checks the data after stored

Non functional requirement

·  System should be simple to operate without any formal training

·  System must be reused and protest from unauthorized users.

·  Handle network and power failure

·  Efficient and quick recover from the fault

SYSTEM REQUIREMENTS:

SOURCE CODE AND DESIGN FORM:

FRONT END : VISUAL BASIC

BACK END: MS ACCESS

START->PROGRAMS->MICROSOFT VISUAL STUDIO 6.0 -> MICROSOFT VISUAL BASIC 6.0 -> OPEN STANDARD EXE.

DESIGNS:

FORM 1:

FORM 2:

CODINGS:

Code for form1

Dim a, b As String

Dim c, i As Integer

Private Sub Command1_Click()

Frame1.Visible = True

Data1.Recordset.MoveFirst

a = Text1.Text

Do While Data1.Recordset.EOF = False

b = Data1.Recordset!eid

If c = StrComp(a, b) Then

Text2.Text = Data1.Recordset!ename

Text3.Text = Data1.Recordset!fmhname

Text4.Text = Data1.Recordset!sex

Text5.Text = Data1.Recordset!place

Text6.Text = Data1.Recordset!eid

Exit Do

Else

End If

Data1.Recordset.MoveNext

Loop

End Sub

Private Sub Command2_Click()

Form2.Text1.Text = Val(Form1.Text6.Text)

Form2.Text2.Text = Form1.Text2.Text

Form2.Show

Form1.Hide

End Sub

Private Sub Form_Load()

ELECTOR

End Sub

Code for form2

Dim str As String

Private Sub Command1_Click()

If (Option1.Value = True Or Option2.Value = True Or Option3.Value = True Or Option4.Value = True Or Option5.Value = True) Then

Data1.Recordset.AddNew

Data1.Recordset!eid = Val(Text1.Text)

Data1.Recordset!ename = Text2.Text

Data1.Recordset!pname = str

Data1.Recordset.Update

MsgBox "Your vote is registered ", vbOKOnly

Command1.Enabled = False

Else

MsgBox "select one party"

End If

End Sub

Private Sub Command2_Click()

Form2.Hide

End Sub

Private Sub Form_Load()

Option1.Value = False

Option2.Value = False

Option3.Value = False

Option4.Value = False

Option5.Value = False

End Sub

Private Sub Option1_Click()

str = Option1.Caption

If Option1.Value = True Then

Option2.Enabled = False

Option3.Enabled = False

Option4.Enabled = False

Option5.Enabled = False

End If

End Sub

Private Sub Option2_Click()

str = Option2.Caption

If Option2.Value = True Then

Option1.Enabled = False

Option3.Enabled = False

Option4.Enabled = False

Option5.Enabled = False

End If

End Sub

Private Sub Option3_Click()

str = Option3.Caption

If Option3.Value = True Then

Option1.Enabled = False

Option2.Enabled = False

Option4.Enabled = False

Option5.Enabled = False

End If

End Sub

Private Sub Option4_Click()

str = Option4.Caption

If Option4.Value = True Then

Option1.Enabled = False

Option2.Enabled = False

Option3.Enabled = False

Option5.Enabled = False

End If

End Sub

Private Sub Option5_Click()

str = Option5.Caption

If Option5.Value = True Then

Option1.Enabled = False

Option2.Enabled = False

Option3.Enabled = False

Option4.Enabled = False

End If

End Sub

Software testing:

·  Test cases

·  Verification and validation test cases

·  Faults encounters during entry

·  System response for irrelevant questions

·  Mistakes done by user when entering details

·  Incomplete application submission

·  Action taken by the system when eligible and unavailability of seats

·  Time delay in fees remittance

·  Cancellation registration

·  User interface test cases

·  Is it easy to operate?

·  Understandable

·  Is it visually pleasing

·  Is it efficient use

·  Is there fast recovery from errors

CONCLUSION:

Thus the online voting system is implemented and executed successfully.

EX.NO:4

DATE:

BANKING SYSTEM

AIM:

To create a Banking system with debit and credit ledger report creation by using Visual Basic.

PROCEDURE:

1. Problem statement

Software is to be designed for supporting a computerized Online Voting. All the process involved in a Online Voting is computerized. The party details have to be recorded and voter must be able to view it. The software which contains all data includes the details such as Elector name and Party name. It is access to party name given by the server. The system to be designed such that is automatically checks the data after data stored. The proposal system must satisfy user requirements, designed aesthetic and derive usability and quality assurance

2. Project planning

·  Algorithm

·  Start the process

·  The server asks for the voter details.

·  Then the server show the party list.

·  The person enter the party name as they want.

3. Problem requirement analysis

Basic requirement

·  Collect the parties.

·  Enter the Elector name and the parties.

·  Ensure the result analysis.

Functional requirement

·  The voter must store the data about their details to database

·  All data includes the following details: name and party name.

·  Access to the elector is given by the server

·  The system to be designed such that it automatically checks the data after stored

Non functional requirement

·  System should be simple to operate without any formal training

·  System must be reused and protest from unauthorized users.

·  Handle network and power failure

·  Efficient and quick recover from the fault

SYSTEM REQUIREMENTS:

SOURCE CODE AND DESIGN FORM:

FRONT END : VISUAL BASIC

BACK END: MS ACCESS

START->PROGRAMS->MICROSOFT VISUAL STUDIO 6.0 -> MICROSOFT VISUAL BASIC 6.0 -> OPEN STANDARD EXE.

DIAGRAMS:

USE CASE DIAGRAM:

SEQUENCE DIAGRAM:

COLLABORATION DIAGRAM:

ACTIVITY DIAGRAM: