Mobile Shop Management System Documentation

(1)

A

PROJECT REPORT ON

Nokia Mobile Shop Management System

Submitted to

University of Mumbai

2011-2012

BY

Miss.

AARTI DEEPAK SHINDE

(2)

INDEX

Sr.No. Title Page

No.

1 Preliminary Investigation 6

Organizational Overview 7 Description Of System 8 Limitations Of Present System 9 Proposed System & its Advantage 10

Feasibility Study 12 Stakeholders 15 Gantt Chart 16 2 System Analysis 17 Fact Findings 18 Event Table 19

Use Case Diagram 20

Entity Relationship Diagram 21

Activity Diagram 22 Class Diagram 23 Object Diagram 24 Sequence Diagram 25 Collaboration Diagram 26 State Diagram 27 3 System Design 28

Converting ERD to Tables 29 Relationship Diagram 30

Component Diagram 31

Package Diagram 32

Deployment Diagram 33

System Flow Chart 34

Structure Chart 35

4 System Coding 36

Menu Tree 37

List of Tables with Attributes & Constraints 38 Program Description with naming Conventions

Program Listing Validations

Test Cases, Test Data, Test Results Screen Layouts & Report Layouts

41

5 System Implementation & Uploading 114

6 Future Enhancement 116

(3)

Chapter 1 Preliminary Investigation

(4)

Organizational Overview

Organizational Chart

Mobile Store

Management

System

Supplier

Customer

Employee

(5)

Description of System

In Nokia Mobile Store Management System use to maintain their sales

detail in files and folders. They use to keep the record of product sold,

Customers, Suppliers, etc in a register. A daily register is maintained to keep

track of complaints.

Preparing report is very time consuming and tedious task. For searching

of single record, whole register is to be searched which is very time consuming

task.

(6)

Limitations Of Present System



As mentioned above most of details are

maintained manually. Due to this the data

retrieved is time consuming. Due to human

calculation errors occur.



Even when the data is maintained on spreadsheet

inconsistency occurs as an order might be missed

or wrongly entered or twice.



Data are stride an excel sheet which takes lot of

time and data may be corrupted.



As storage and exchange of data is achieved only

by use of excel sheets which lack validation

capabilities, there is always risk of invalid,

inaccurate or incomplete data being fed in

computer.



Difficulty in managing multiple forms.



Lack of security.

(7)

Proposed System

The proposed system is computerized and has

been developed using advance language therefore it gives

more facilities than present system. It provides quick access to

any data. In this system user have to enter the data only once

and then it get linked with all files. This reduces the workload of

user and it is also a time saving process.

The information about any Subscriber can be

easily retrieved. The system maintains all records easy.

(8)

Advantages of Proposed System:



All the information about sale, purchase will be maintain properly in

this system.



All manual calculation of sale or all the money management will be

performed by the computer automatically.



This system will provide timely report information.



It will produce report for sale, bill information.



The computer can hold amount of data in its storage device.



The operation and speed of the computer is very high.



We can calculate result and print any report within seconds.



Any difficulties we can solve easily.



A database application can be stored in computer effectively.



It is very user friendly and easy to handle.

(9)

Feasibility Of Study

1. Software

Software requirements for this system are as listed follows:



FRONTEND

:

Microsoft Visual Basic 8.0



BACKEND

:

MS Access-2007



OPERATING SYSTEM

:

Windows XP



FOR DOCUMENTATION :

Microsoft Office

2

.

Hardware Specifications

Minimum hardware requirements for this System are listed below:



Processor

:

Pentium-4



RAM

:

256MB.



HARD DISK

:

80GB.



CD-Rom Driver

:

Any.

(10)

FRONTEND: - MICROSOFT VISUAL STUDIO 2008

1. First of all, VB.NET provides managed code execution that runs under

the Common Language Runtime (CLR), resulting in robust, stable and

secure applications. All features of the .NET framework are readily

available in VB.NET.

2. VB.NET is totally object oriented. This is a major addition that VB6 and

other earlier releases didn't have.

3. The .NET framework comes with ADO.NET, which follows the

disconnected paradigm, i.e. once the required records are fetched the

connection no longer exists. It also retrieves the records that are expected

to be accessed in the immediate future. This enhances Scalability of the

application to a great extent.

4. VB.NET uses XML to transfer data between the various layers in the

DNA Architecture i.e. data are passed as simple text strings.

5. Error handling has changed in VB.NET. A new Try-Catch-Finally block

has been introduced to handle errors and exceptions as a unit, allowing

appropriate action to be taken at the place the error occurred thus

discouraging the use of ON ERROR GOTO statement. This again credits

to the maintainability of the code.

6. Another great feature added to VB.NET is free threading against the VB

single-threaded apartment feature. In many situations developers need

spawning of a new thread to run as a background process and increase the

usability of the application. VB.NET allows developers to spawn threads

wherever they feel like, hence giving freedom and better control on the

application.

7. Security has become more robust in VB.NET. In addition to the

role-based security in VB6, VB.NET comes with a new security model, Code

Access security. This security controls on what the code can access. For

example you can set the security to a component such that the component

cannot access the database. This type of security is important because it

allows building components that can be trusted to various degrees.

8. The CLR takes care of garbage collection i.e. the CLR releases resources

as soon as an object is no more in use. This relieves the developer from

thinking of ways to manage memory. CLR does this for them.

(11)

BACKEND: MS-ACCESS 2007

Microsoft Office Access, previously known as Microsoft Access, is a

database management system from Microsoft that combines the relational

Microsoft Jet Database Engine with a graphical user interface and

software-development tools.

MS Access stores data in its own format based on the Access Jet

Database Engine. It can also import or link directly to data stored in other

applications and databases

Microsoft Access applications can adopt split-database architecture. The

database can be divided into a front-end database that contains the application

objects (queries, forms, reports, macros, and modules), and is linked to tables

stored in a back-end shared database containing the data. The "back-end"

database can be stored in a location shared by many users, such as a file server.

The "front-end" database is distributed to each user's desktop and linked to the

shared database.

Access includes an Upsizing Wizard that allows users to upsize their

databases to Microsoft SQL Server, an ODBC client–server database. An

additional solution, the SQL Server Migration Assistant for Access (SSMA), is

also available for download from

(12)

Stakeholders

Stakeholders are anyone who has an interest in the project. Project

stakeholders are individuals and organizations that are actively involved in the

project, or whose interests may be affected as a result of project execution or

project completion. They may also exert influence over the project’s objectives

and outcomes. The project management team must identify the stakeholders,

determine their requirements and expectations, and, to the extent possible,

manage their influence in relation to the requirements to ensure a successful

project.

The following are examples of project stakeholders:

1.

Project Developers

:-Project Developers is one who develops software for customer. In

my project I am the first stakeholder i.e. Project Developer.

2. Project customer

:-Project Customer is one who pays for the developed software.

3.

Project user Group

:-Project User group are those people who use the

software on daily basis for the Project Customer.

(13)

4. Project Testers

Project Testers are those who test the software.

(14)

Gantt Chart

Phase Start date Compl etion date Prelimina ry investiga tion Project Finalizati on 10/06/2 011 17/06/2011 Investiga tion of system requirem ent 18/06/2 011 25/06/2011 System Analysis 27/06/2 011 14/8/2011 System Design 15/8/20₁₁ 28/9/201₁ Coding Interface Coding 29/09/2 011 15/10/2011 Database Connecti vity 16/10/2 011 30/10/2011 Validatio n Coding 31/10/2₀₁₁ 15/11/20₁₁ Report Coding 17/11/2 011 31/12/2011 Impleme ntation Develope r Testing 5/12/20₁₁ 12/12/20₁₁ Client Testing 13/12/2 011 22/12/2011 User Testing 25/12/2₀₁₁ 29/12/20₁₁ Project Delivery 30/12/2 011 05/1/2012 Project Report Submissi on Project Report Hard Copy 8/1/201 2 12/1/2012 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 WEEK

(15)

Chapter 2 System Analysis

(16)

Fact Findings

Introduction

The Current System is the manual one, hence is not speedy, accurate,

efficient as well as time consuming. An essential part of the system analysis,

which enables the developer to understand & the system correctly. It is

undertaken to obtain details of the system. To understand the physical flow of

the information through the current system. Collect various information through

various fact finding techniques. Identify the procedural difficulties experienced

by the user. Study the bottlenecks find out the redundant work being performed

in the system.

Fact Finding Techniques Employed

1. Interviews

Information was obtained from the employees at the organization by

interviewing them at the location and time convention both.

2. Document Searching

An extensive study of existing document an official correspondence

was done to understand the present working status of organization.

(17)

Event Table

17 SR

NO EVENT TRIGGER SOURCE ACTIVITY RESPONSE DESTINATION

1 Enter new

customer Add Admin Create new record New record created System

2 Customer change in personal

details

Update Customer Update customer details Details updated Admin 3 Gives an Order

New order Customer Create new Order

New order created

Employee

4 Enter new

supplier supplierAdd Admin Add new supplier record New record created System 5 Supplier change in details

Update Supplier Update supplier details Details updated Admin 6 Owner needs supplier details

Search Admin Search supplier details Display supplier details System 7 Enter new employee

Add Admin Create new employee

record

New record created

System

8 Stock entry Add Admin Generating

(18)

9 Paying Bill Order fulfillment

Customer Paying bill Get payment Admin

10 Generating reports

New report Admin Generating receipt

Get receipt System

11 Updating records Check previous records Admin Updating records Record is update System

12 Delete record Delete admin Check

(19)

Use Case Diagram

Supplier Admin

Admin 19 Delete supplier details Display supplier details Search supplier Update supplier details Create a new supplier Lookup for supplier Delete product details Display product details Update product details Create a new product Lookup for product details

(20)

Admin

Customer Admin Delete customer details Display customer details Search customer Update customer details Create a new customer details Lookup for customer details Delete stock details Display stock details Update stock details Create new stock details Lookup for stock details

(21)

C

ustomer Admin

C

ustomer Admin 21 Lookup for order details Update order record Delete order record Create a new order Places an Order Display Bill Delete Bill Create a new Bill Places new Bill

(22)

Entity-Relationship Diagram

Nokia Mobile

Shop System

Customer

Purchas Order

Salary

Employee

Product

Supplier

Bill

(23)

Activity Diagram

Customer

No

Yes

23 Nokia Mobile Shop System

Enter Customer information

Enter product information

Product Supplier Place purchase order Check availability

Give payment Add product

Request product for purchase

Create new order

Calculate total Generate Bill

Enter order Place Order

Initiate maintain customer information

Display Customer information Verify Customer information

(24)

Class Diagram

1..* 1..*

1 1..* 1 1..* 1..* 1 1..* 1..*

Customer

+Cust_id:Number +Cust_name:Text +Cust_add:Text +Cust_ph:Number +Cust_email:Text +Insert () +Update () +Delete () +New ()

Employee

+Emp_id:Number +Emp_name:Text +Emp_add:Text +Emp_ph:Number +Insert () +Update () +Delete () +New ()

Order

+Order_no:Number +Date:Date/Time +Cust_name:Text +Prod_name:Text +Total:Number +Insert () +Update () +Delete () +New ()

Product

+Prod_no:Number +Prod_name:Text +Prod_info:Text +MRP:Number +Insert () +Update () +Delete () +New ()

Bill

+Bill_no:Number +Order_no:Number +Cust_no:Number +Prod_name:Text +Total:Number +Insert () +Update () +Delete () +New ()

Supplier

+Supp_no:Number +Supp_name:Text +Supp_add:Text +Suppt_ph:Number +Insert () +Update () +Delete () +New ()

Stock

+Prod_id:Number +Prod_name:Text +Prod_qty:Number +Insert() +Update() +Delete() +New()

(25)

Object Diagram

1..* 1..*

1 1..* 1 1..* 1..* 1 1..* 1..* 25

:Employee

:Order

:Product

:Bill

:Stock

: Customer

+Cust_id:Number +Cust_name:Text +Cust_add:Text +Cust_ph:Number +Cust_email:Text +Insert () +Update () +Delete () +New ()

: Employee

: Order

: Product

: Bill

: Supplier

+Supp_no:Number +Supp_name:Text +Supp_add:Text +Suppt_ph:Number +Insert () +Update () +Delete () +New ()

: Stock

(26)

(27)

Sequence Diagram

Create Supplier:

Create new supplier information New supplier created

Admin

Update Supplier:

Display supplier details Update supplier details

Supplier

Admin

Delete Supplier:

Display supplier details Delete supplier

Admin

27

System

(28)

Create Product:

Create new product details New product created

Admin

Update Product:

Display product details Update product details

Admin

Delete Product:

Display product details Delete selected product

Admin

System

(29)

Create Stock:

Create new stock information New stock created

Admin

Update Stock:

Display stock details Update stock details

Admin

Delete Stock:

Display stock details Delete stock

Admin

29

System

(30)

Create Customer:

Create new Customer information

New Customer created

Customer Admin

Update Customer:

Display Customer details Update Customer details

Customer Admin

Delete Customer:

Display Customer details Delete Customer

Admin

System

(31)

Create Order:

Create new Order information

New Order created

Customer Admin

Update Order:

Display Order details Update Order details

Customer Admin

Delete Order:

Display Order details Delete Order

Admin

31

System

(32)

Create Bill:

Create new Bill information New Bill created

Admin

Delete Delete:

Display Bill details Delete Bill

Admin

System

(33)

Create Employee:

Create new Employee information New Employee created

Admin

Update Employee:

Display Employee details Update Employee details

Employee Admin

Delete Employee:

Display Employee details Delete Employee

Admin

33

End

Mobile provide to customer

Pay bill

Generate receipt

Idle

System

(34)

Collaboration Diagram

1. Customer enquiry

2. Get information

5. Place order

6. Get order

8. Pay bill

7. Order fulfillment

9. Generate receipt

10 .

Check availability

3. Customer

Of mobile

Registration

14. Update records

4. Check details

11. Order

13. Payment 12. Placed order

34

Customer

Supplier

Employee

End

Mobile provide to customer

Pay bill

Idle

(35)

State Diagram

Login

Customer enter

Order for mobile

Mobile not available

Mobile available Check details Order fulfillment Paying bill Generating receipt 35

Customer enquiry

Check availability of

mobile

Order for mobile

End

Check mobile details

Mobile provide to customer

Pay bill

Generate receipt

Idle

(36)

Chapter 3

(37)

Converting ERD to Tables

Sr.No

_{TABLE NAME}

_PURPOSE

1 Cust_info

This table is use to store, retrieve and information about the

customer.

the fields are c_no,cname,cadd,gender,contactno,email

2 Employee

This table is use to store ,retrieve and information about the

employee. The fields is :

e_id,e_fname,e_mname,e_lname,e_add,e_city,e_contact.

3 Supplier

This table is use to store ,retrieve and information about the

supplier.The field are o_no,s_name,o_model,o_qty,o_prize,

o_totprize,o_tax,o_tot.

4 Order

This table is use to purchase , store , retrieve

& the information like p_no,p_name.

The field in the table are c_no,c_name,cadd,email,contactno,

o_no,p_no,p_name,p_qty,p_mrp,p_tot.

5 Salary

This table is use store ,retrieve and information about the

employee salary.

The field are e_id, e_fname,e_mname,e_lname, e_add,

e_contact, msalary, advance.

(38)

Component Diagram

Bill.vb

Nokia Mobile

Shop

System

Order.vb

Supplier.vb

Stock.vb

Emp.vb

Salary.vb

Customer.vb

Order.vb

(39)

Package Diagram

39

Mobile bill

Nokia Mobile shop system

Supplier, Order, Stock, Emp Form Availability Cancel Connection Admin Other Form Emp form Supplier form Product form Order form Bill form Cancel Processing And Printing

(40)

Deployment Diagram

40

Order.vb

Database

Server

<<device>>

Printer

Cust.vb

Mobdetails.vb

Transaction.vb

Emp.vb

Bill.vb

Emp.vb

XP

PC <<device>>

(41)

41

Nokia

Mobile store

management

Price Mobile Purchase order Customer Supplier Mobile bill Employee Paid Maintain customer details Mobile details Transaction of mobile Maintain employee details Paid details Generate mobile bill Purchase order details Customer bill report Supplier bill report

System flow

(42)

Nokia Mobile Store System

Maintain customer details Creation of order Bill generation Giving purchase order Get Customer details Save customer details Checking of product Customer details Product details Get mobile details Report generation Order fulfillment Retrieve mobile details Bill details

Structure chart

(43)

Chapter 4

System Coding

(44)

Menu Tree

MDI Form

Main

Customer information Mobile Details

Customer Purchase order

Reports Utility Calculator About Us Help Exit Employee Customer information Mobile Details Mobile Bill Supplier Report Transaction

_Transaction

(45)

Table List

1.Table name:-Cust_info

Sr.N

o.

Field Name

Datatype

Constraints

Size

Description

1 c_no

Integer

Primary key

Stores the customer code

2 cname

Varchar

10 Stores the customer name

3

4 cadd

gender

Varchar

10

10 Stores the customer address

Store the customer gender

4 contactno

Bigint

Stores the customer contact.

5 email

Varchar

25 Stores the customer email id

2.Table name:-Employee

Sr.

No.

Field Name

Datatype Constraints

Size Description

1 E_id

Integer

Primary key

Stores the employee code

2

3

4 E_fname

E_mname

E_lname

Varchar

varchar

15

15 Stores the employee name

Stores the employee middle

name

Stores the employee last name

5 E_add

Varchar

20 Stores the employee address

6 Ph_no

Bigint

Stores the employee ph.no.

(46)

3.Table name:-Supplier

Sr.

No.

Field Name

Datatype Constraints

Size Description

1 o_no

Integer

Primary key

Stores the company code

2 S_name

Varchar

20 Stores the company name

3

4 o_model

o_qty

Varchar

Integer

20 Stores the mobile model name

Stores the mobile qty

5 o_color

varchar

20 Stores the mobile color

6

7

8

9 o_prize

o_totprize

o_tax

o_tot

Bigint

bigint

Stores the mobile prize

Stores the total prize

Stores the tax value

Stores the total amount

included tax

4. Table name:-Order

Sr.

No.

Field Name

Datatype Constraints

Size

Description

1 c_no

Integer

Foreign key

Stores the customer code

2 c_name

Varchar

15 Stores the customer name

3 c_add

Varchar

15 Stores the customer address

4 contactno

Bigint

Stores the customer contact

no

5 email

varchar

20 Stores the customer email

6 o_no

Integer

Stores the order no

7 p_no

integer

Stores the product no

8 P_name

Varchar

15 Stores the product name

9 P_q ty

Integer

Stores the product quantity

10 P_mrp

integer

Stores the product prize

11 P_tot

bigint

Stores the product total prize

(47)

8. Table name:-Salary

Sr.

No.

Field Name

Datatype Constraints

Size Description

1 E_id

Integer

primary

Stores the employee id

2

3 E_fname

e_mname

Varchar

varchar

15

15 Stores the employee name

Stores the employee middle

name

4 e_lname

Varchar

15 Stores the employee last name

5 e_add

varchar

20 Stores the employee address

6 e_contact

Bigint

Stores the employee contact no

7 msalary

Bigint

Stores the emp monthly salary

8 advance

Bigint

Stores the emp advance salary

(48)

Program List

NO

FORM

NAME

PURPOSE

1 Loding.frm

This form display the title of system name

of organization & copyright of the system

2 Loginform.frm

This form is used for security with the help of

password

3 MdIForm.frm

This is the multiple document interface for the all

of the form in the project

4 Cust_info.frm

This form is use for store the customer information

5 Emp.frm

This form is use for store the employee

information

6 Supplier.frm

This form is use for store the Supplier information

7 Salary.frm

This form use for store employee salary

(49)

R

eport List

NO.

REPORT NAME

PURPOSE

1 Crystalreport1.rpt

This report is use for to

print and show the

customer bill

2 Crystalreport2.rpt

This report is use for to

print & show the

supplier bill

(50)

P

rogram Description

Program Name:

Loding.vb

Program Function:

This is form is used to Load

the system

.

Code:-Public Class Loading

Dim i As Integer

Private Sub Timer1_Tick(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles Timer1.Tick

ProgressBar1.PerformStep() i = i + 1 Label2.Text = i If ProgressBar1.Value = 100 Then Me.Hide() LoginForm1.Show() Timer1.Enabled = False End If End Sub

(51)

Program Name:

Login Form1.vb

Program Function:

This is form is used to Login

in the system

.

Public Class LoginForm1

Private Sub OK_Click_1(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles OK.Click

If UsernameTextBox.Text = "arti" And

PasswordTextBox.Text = "123" Then Me.Hide() MDI.Show() Else MsgBox("error") End If End Sub 51

(52)

Program Name:

MDI.vb

Program Function:

This is form contains menus

i.e. path for other forms.

Code:-Public Class MDI

Private Sub CustomerInfoToolStripMenuItem_Click(ByVal

sender As System.Object, ByVal e As System.EventArgs) Handles

CustomerInfoToolStripMenuItem.Click Cust_info.Show()

End Sub

Private Sub MobileDetailsToolStripMenuItem_Click(ByVal

MobileDetailsToolStripMenuItem.Click MobiAdd.Show()

End Sub

Private Sub MobileBillToolStripMenuItem_Click(ByVal sender

As System.Object, ByVal e As System.EventArgs) Mobile_Bill.Show()

End Sub

Private Sub OrderToolStripMenuItem_Click(ByVal sender As

(53)

End Sub

Private Sub AboutToolStripMenuItem_Click(ByVal sender As

System.Object, ByVal e As System.EventArgs) Handles

AboutToolStripMenuItem.Click about.Show()

End Sub

Private Sub EmployeeDetailsToolStripMenuItem_Click(ByVal

EmployeeDetailsToolStripMenuItem.Click emp.Show()

End Sub

Private Sub ExitToolStripMenuItem_Click(ByVal sender As

ExitToolStripMenuItem.Click Me.Close()

End Sub

Private Sub MobileBillToolStripMenuItem1_Click(ByVal

MobileBillToolStripMenuItem1.Click Report_bill.Show()

End Sub

Private Sub CalculatorToolStripMenuItem_Click(ByVal sender

As System.Object, ByVal e As System.EventArgs) Handles

CalculatorToolStripMenuItem.Click

Process.Start("C:\WINDOWS\system32\calc.exe") End Sub

Private Sub SalaryToolStripMenuItem_Click(ByVal sender As

SalaryToolStripMenuItem.Click salary.Show()

End Sub

Private Sub ReceivedMobileToolStripMenuItem_Click(ByVal

ReceivedMobileToolStripMenuItem.Click supplier.Show()

End Sub

Private Sub ToolStripMenuItem1_Click(ByVal sender As

ToolStripMenuItem1.Click

supplier_report.Show() End Sub

(54)

Program Name:

Cust_info.vb

Program Function:

This is form is used to add

new customer and its details

Data entry form:

Code:-Imports System.Data.OleDb

Public Class Cust_Info

Dim cmd As OleDbCommand

Dim cn As New OleDbConnection Dim ad As New OleDbDataAdapter

Dim SlotAdapter As New OleDb.OleDbDataAdapter Dim ds As New DataSet

Dim dr As String

Dim dt As String

Dim i, f, a As Integer

Private Sub Cust_Info_Load(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles MyBase.Load

'TODO: This line of code loads data into the

'_Database1_mdbDataSet14.Cust_info' table. You can move, or remove it, as needed.

Me.Cust_infoTableAdapter1.Fill(Me._Database1_mdbDataSe t14.Cust_info)

cn = New

OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Database1.mdb.accdb")

(55)

ad = New OleDbDataAdapter("select * from Cust_info", cn)

ds = New DataSet() ad.Fill(ds)

End Sub

Private Sub exitbtn_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles exitbtn.Click

Dim a As Integer

Dim OleDbYesNo As Integer

Dim OleDbQuestion As Integer

Dim OleDbYes As Integer

If a = OleDbYes Then

a = MsgBox(" you want to exit the Form?", OleDbYesNo + OleDbQuestion, "confirm exit")

Me.Close() End If

End Sub

Private Sub TextBox5_LostFocus(ByVal sender As Object, ByVal e

As System.EventArgs) Handles TextBox5.LostFocus Dim bool As Boolean

Dim email As String = TextBox5.Text.Trim

bool = ((email.Contains("@") And email.Contains("."))

And (email.IndexOf("@") < email.IndexOf(".")) _

And (email.IndexOf("@") <> email.IndexOf(".") - 1))

If bool = False Then

MsgBox("Enter Valid Email Address.", MsgBoxStyle.Exclamation, "Invalid Email Address") TextBox5.Text = ""

End If

End Sub

Private Sub TextBox2_KeyPress(ByVal sender As Object, ByVal e

As System.Windows.Forms.KeyPressEventArgs) Handles

TextBox2.KeyPress Dim c As Char

c = e.KeyChar

If Not (Char.IsLetter(c) Or Char.IsControl(c)) Then

e.Handled = True

MsgBox("enter only character") End If

End Sub

(56)

Private Sub firstbtn_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles firstbtn.Click

i = 0

Call add(i)

MsgBox("This is first Record") End Sub

Private Sub previousbtn_Click(ByVal sender As

previousbtn.Click i = i - 1

If (i >= 0) Then

Call add(i) Else

MsgBox("this is previous record") End If

End Sub

Private Sub lastbtn_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles lastbtn.Click

i = ds.Tables(0).Rows.Count - 1 Call add(i)

MsgBox("This is last Record") End Sub

Private Sub nextbtn_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles nextbtn.Click

i = i + 1

If (i < ds.Tables(0).Rows.Count) Then

Call add(i) Else

MsgBox("this is next record") End If

End Sub

Private Sub Button4_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles Button4.Click

TextBox1.Text = "" TextBox2.Text = "" TextBox3.Text = "" ComboBox1.SelectedIndex = -1 TextBox4.Text = "" TextBox5.Text = ""

(57)

cn.Close() cn.Open() ds.Clear()

If TextBox1.Text = "" Then

MsgBox("Please Enter Cust_No") ElseIf TextBox1.Text = "" Then

Else

ad = New OleDbDataAdapter("select * from Cust_info where Cust_No=" & TextBox1.Text & "", cn)

ad.Fill(ds)

DataGridView1.DataSource = ds.Tables(0) cn.Close()

End If

Dim cmd1 As New OleDbCommand cn.Close()

cn.Open()

cmd1.Connection = cn

cmd1.CommandText = "select count(*) from Cust_info"

Dim m As Integer

m = cmd1.ExecuteScalar a = Val(TextBox1.Text) If a > m Then

MsgBox("No Record") End If

End Sub

cn.Close() cn.Open()

If (f = 0) Then

' dt = TextBox1.Text

' MsgBox(dt)

cmd = New OleDbCommand("Delete From Cust_info where Cust_No=" & TextBox1.Text & "", cn)

cmd.ExecuteNonQuery() End If

MsgBox("Record Deleted Successfully.") 57

(58)

End Sub

If (f = 0) Then

ElseIf TextBox2.Text = "" Then

ElseIf ComboBox1.Text = "" Then

MsgBox("Please Enter Record") Else

a = MsgBox("Are you want to save new Customer?", vbYesNo + vbQuestion, "SAVE")

If a = vbYes Then

cmd = New OleDbCommand("insert into

Cust_info values('" & TextBox1.Text & "','" & TextBox2.Text &

"','" & TextBox3.Text & "','" & ComboBox1.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "')", cn)

cmd.ExecuteNonQuery()

MsgBox("Record Save Successfully") End If

End If

End Sub

Sub add(ByVal i As Integer)

TextBox1.Text = ds.Tables(0).Rows(i).Item(0).ToString TextBox2.Text = ds.Tables(0).Rows(i).Item(1).ToString TextBox3.Text = ds.Tables(0).Rows(i).Item(2).ToString ComboBox1.Text = ds.Tables(0).Rows(i).Item(3).ToString TextBox4.Text = ds.Tables(0).Rows(i).Item(4).ToString TextBox5.Text = ds.Tables(0).Rows(i).Item(5).ToString End Sub

(59)

' dt = TextBox1.Text

' MsgBox(dt)

cmd = New OleDbCommand("Update Cust_info set Cust No= ' " & TextBox1.Text & " ',Name= ' " & TextBox2.Text & " ' ,Address= ' " & TextBox3.Text & " ',Gender= ' " &

ComboBox1.Text & " ',Contact No=' " & TextBox5.Text & " ',E-mail='" & TextBox6.Text & " 'where Cust_No=" & TextBox1.Text &

"", cn)

cmd.ExecuteNonQuery() End If

MsgBox("Record Updated Successfully.") End Sub

End Class

(60)

Program Name:

emp.vb

Program Function:

This is form is used to add

new employee and its details.

Test

Data:-

Public Class emp

Dim cn As New OleDbConnection Dim ad As New OleDbDataAdapter Dim ds As New DataSet

Dim dr As String

Dim dt As String

Private Sub emp_Load(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles MyBase.Load

(61)

Me.Emp_detailsTableAdapter1.Fill(Me._Database1_mdbData Set4.emp_details)

cn = New

ad = New OleDbDataAdapter("select * from emp_details", cn)

End Sub

TextBox1.Text = ds.Tables(0).Rows(i).Item(0).ToString TextBox2.Text = ds.Tables(0).Rows(i).Item(1).ToString TextBox3.Text = ds.Tables(0).Rows(i).Item(2).ToString TextBox4.Text = ds.Tables(0).Rows(i).Item(3).ToString TextBox5.Text = ds.Tables(0).Rows(i).Item(4).ToString ComboBox1.Text = ds.Tables(0).Rows(i).Item(5).ToString TextBox6.Text = ds.Tables(0).Rows(i).Item(6).ToString TextBox7.Text = ds.Tables(0).Rows(i).Item(7).ToString End Sub

c = e.KeyChar

e.Handled = True

End Sub

c = e.KeyChar

e.Handled = True

End Sub

(62)

Private Sub Btn_e_Save_Click(ByVal sender As

Btn_e_Save.Click cn.Close() cn.Open()

If (f = 0) Then

ElseIf ComboBox1.Text = "" Then

a = MsgBox("Are you want to save new Employee?", vbYesNo + vbQuestion, "SAVE")

If a = vbYes Then

cmd = New OleDbCommand("insert into

emp_details values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" &

TextBox5.Text & "','" & ComboBox1.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "' )", cn)

End If

End Sub

Private Sub Btn_e_Add_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles Btn_e_Add.Click

TextBox1.Text = "" TextBox2.Text = "" TextBox3.Text = "" TextBox4.Text = "" ComboBox1.SelectedIndex = -1 TextBox5.Text = "" TextBox6.Text = "" TextBox7.Text = "" End Sub

(63)

Private Sub Btn_e_Delete_Click(ByVal sender As

Btn_e_Delete.Click cn.Close() cn.Open()

If (f = 0) Then

MsgBox("Please Enter Cust_No") ElseIf TextBox1.Text = "" Then

Else

a = MsgBox("Are you want to Delete Employee?", vbYesNo + vbQuestion, "Delete")

If a = vbYes Then

cmd = New OleDbCommand("Delete From emp_details where Emp_ID=" & TextBox1.Text & "", cn) cmd.ExecuteNonQuery()

MsgBox("Record Deleted Successfully.") End If

End If

End Sub

Private Sub Btn_e_Update_Click(ByVal sender As

Btn_e_Update.Click cn.Close() cn.Open()

a = "select * from emp_details where emp_ID = '" & TextBox1.Text & "'"

cmd = New OleDbCommand("Update emp_details set Name= ' " & TextBox2.Text & " ',Address= ' " & TextBox3.Text & "

',Contact_No= ' " & TextBox4.Text & " ',Age=' " &

TextBox5.Text & " ', Gender= ' " & ComboBox1.Text & " ' ,J_Date= ' " & TextBox6.Text & " ' ,Total_Sal= ' " &

TextBox7.Text & "' where emp_ID='" & TextBox1.Text & "')", cn) cmd.ExecuteNonQuery()

MsgBox("Record Updated Successfully.") End Sub

Private Sub Btn_e_First_Click(ByVal sender As

Btn_e_First.Click

(64)

i = 0

Call add(i)

Private Sub Btn_e_Pre_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles Btn_e_Pre.Click

i = i - 1

If (i >= 0) Then

Call add(i) Else

End Sub

Private Sub Btn_e_Last_Click(ByVal sender As

Btn_e_Last.Click

Private Sub Btn_e_Next_Click(ByVal sender As

Btn_e_Next.Click i = i + 1

Call add(i) Else

End Sub

Private Sub Btn_e_Exit_Click(ByVal sender As

Btn_e_Exit.Click

Dim a As Integer

(65)

Me.Close() End If

End Sub

Private Sub Btn_e_Search_Click(ByVal sender As

Btn_e_Search.Click cn.Close() cn.Open() ds.Clear()

MsgBox("Please Enter emp_details") ElseIf TextBox1.Text = "" Then

Else

ad = New OleDbDataAdapter("select * from emp_details where emp_ID=" & TextBox1.Text & "", cn) ad.Fill(ds)

DataGridView1.DataSource = ds.Tables(0) cn.Close()

End If

Dim cmd1 As New OleDbCommand cn.Close()

cn.Open()

cmd1.Connection = cn

cmd1.CommandText = "select count(*) from emp_details"

Dim m As Integer

m = cmd1.ExecuteScalar a = Val(TextBox1.Text) If a > m Then

MsgBox("No Record") End If

End Sub

End Class

(66)

Program Name:

Supplier.vb

Program Function:

This is form is used to add

new supplier and its details.

Test

Data:-

Public Class supplier

Dim cn As New OleDbConnection Dim ad As New OleDbDataAdapter

Dim SlotAdapter As New OleDb.OleDbDataAdapter Dim ds As New DataSet

Dim dr As String

Dim dt As String

Private Sub supplier_Load(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles MyBase.Load

'_Database1_mdbDataSet12.supplier' table. You can move, or remove it, as needed.

Me.SupplierTableAdapter1.Fill(Me._Database1_mdbDataSet 12.supplier)

(67)

cn = New

ad = New OleDbDataAdapter("select * from Supplier", cn)

End Sub

Sub add(ByVal i As Integer) Txt_bo_Ono.Text = ds.Tables(0).Rows(i).Item(0).ToString cmb_cm_sname.Text = ds.Tables(0).Rows(i).Item(1).ToString cmb_cm_model.Text = ds.Tables(0).Rows(i).Item(2).ToString Txt_bo_Qty.Text = ds.Tables(0).Rows(i).Item(3).ToString cmb_cm_color.Text = ds.Tables(0).Rows(i).Item(4).ToString Txt_bo_prize.Text = ds.Tables(0).Rows(i).Item(5).ToString txt_bo_total.Text = ds.Tables(0).Rows(i).Item(6).ToString Txt_bo_tax.Text = ds.Tables(0).Rows(i).Item(7).ToString txt_bo_totalprize.Text = ds.Tables(0).Rows(i).Item(8).ToString End Sub

Private Sub cal_btn_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles cal_btn.Click

txt_bo_total.Text = Txt_bo_prize.Text * Txt_bo_Qty.Text Txt_bo_tax.Text = txt_bo_total.Text / 100 txt_bo_totalprize.Text = Val(txt_bo_total.Text) + Val(Txt_bo_tax.Text) End Sub

supplier_bill.Show() End Sub

(68)

Private Sub Txt_bo_Qty_TextChanged(ByVal sender As

Txt_bo_Qty.TextChanged End Sub

Private Sub Btn_e_Save_Click(ByVal sender As

Btn_e_Save.Click cn.Close() cn.Open()

If (f = 0) Then

If Txt_bo_Ono.Text = "" Then

ElseIf cmb_cm_sname.Text = "" Then

ElseIf cmb_cm_model.Text = "" Then

ElseIf Txt_bo_Qty.Text = "" Then

ElseIf cmb_cm_color.Text = "" Then

ElseIf Txt_bo_prize.Text = "" Then

ElseIf txt_bo_total.Text = "" Then

ElseIf Txt_bo_tax.Text = "" Then

ElseIf txt_bo_totalprize.Text = "" Then

a = MsgBox("Are you want to save new Supplier?", vbYesNo + vbQuestion, "SAVE")

If a = vbYes Then

cmd = New OleDbCommand("insert into Supplier values('" & Txt_bo_Ono.Text & "','" &

cmb_cm_sname.Text & "','" & cmb_cm_model.Text & "','" & Txt_bo_Qty.Text & "','" & cmb_cm_color.Text & "','" & Txt_bo_prize.Text & "','" & txt_bo_total.Text & "','" & Txt_bo_tax.Text & "','" & txt_bo_totalprize.Text & "')", cn) cmd.ExecuteNonQuery()

End If

End Sub

(69)

Private Sub cmb_cm_model_SelectedIndexChanged(ByVal sender

As System.Object, ByVal e As System.EventArgs) Handles

cmb_cm_model.SelectedIndexChanged

If cmb_cm_model.SelectedIndex = "0" Then

Txt_bo_prize.Text = 25000

ElseIf cmb_cm_model.SelectedIndex = "1" Then

Txt_bo_prize.Text = 30000

ElseIf cmb_cm_model.SelectedIndex = "2" Then

Txt_bo_prize.Text = 27000 End If

End Sub

Private Sub Btn_e_Add_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles Btn_e_Add.Click

Txt_bo_Ono.Text = "" cmb_cm_sname.Text = "" cmb_cm_model.Text = "" Txt_bo_Qty.Text = "" cmb_cm_color.Text = "" Txt_bo_prize.Text = "" txt_bo_total.Text = "" Txt_bo_tax.Text = "" txt_bo_totalprize.Text = "" End Sub

Private Sub Btn_e_Delete_Click(ByVal sender As

Btn_e_Delete.Click cn.Close() cn.Open()

If (f = 0) Then

If Txt_bo_Ono.Text = "" Then

MsgBox("Please Enter Order no") ElseIf Txt_bo_Ono.Text = "" Then

Else

a = MsgBox("Are you want to Delete Supplier?", vbYesNo + vbQuestion, "Delete")

If a = vbYes Then

cmd = New OleDbCommand("Delete From Supplier where O_no=" & Txt_bo_Ono.Text & "", cn)

MsgBox("Record Deleted Successfully.") 69

(70)

End If

End Sub

Private Sub Btn_e_Update_Click(ByVal sender As

Btn_e_Update.Click End Sub

Private Sub Btn_e_First_Click(ByVal sender As

Btn_e_First.Click i = 0

Call add(i)

Private Sub Btn_e_Pre_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles Btn_e_Pre.Click

i = i - 1

If (i >= 0) Then

Call add(i) Else

End Sub

Private Sub Btn_e_Last_Click(ByVal sender As

Btn_e_Last.Click

Private Sub Btn_e_Next_Click(ByVal sender As

Btn_e_Next.Click i = i + 1

(71)

End Sub

Private Sub Btn_e_Exit_Click(ByVal sender As

Btn_e_Exit.Click

Dim a As Integer

a = MsgBox(" you want to exit the Form?", OleDbYesNo + OleDbQuestion, "confirm exit")

Me.Close() End If

End Sub

Private Sub DataGridView1_CellContentClick(ByVal sender As

System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick End Sub End Class 71

(72)

Program Name:

order.vb

Program Function:

This is form is used to

purchase mobile.

Test

Data:-

Public Class Order

Dim cn As New OleDbConnection Dim ad As New OleDbDataAdapter Dim ds As New DataSet

Dim dr As String

Dim dt As String

Private Sub purchase_order_Load(ByVal sender As

MyBase.Load

'_Database1_mdbDataSet15.Order' table. You can move, or remove it, as needed. Me.OrderTableAdapter.Fill(Me._Database1_mdbDataSet15.O rder) cn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Database1.mdb.accdb")

(73)

End Sub

TextBox1.Text = ds.Tables(0).Rows(i).Item(0).ToString TextBox2.Text = ds.Tables(0).Rows(i).Item(1).ToString TextBox3.Text = ds.Tables(0).Rows(i).Item(2).ToString TextBox4.Text = ds.Tables(0).Rows(i).Item(3).ToString TextBox5.Text = ds.Tables(0).Rows(i).Item(4).ToString cmb_pr_id.Text = ds.Tables(0).Rows(i).Item(6).ToString txt_pr_name.Text = ds.Tables(0).Rows(i).Item(7).ToString TextBox6.Text = ds.Tables(0).Rows(i).Item(8).ToString txt_mrp.Text = ds.Tables(0).Rows(i).Item(9).ToString TextBox7.Text = ds.Tables(0).Rows(i).Item(10).ToString End Sub

Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal

e As System.Windows.Forms.KeyPressEventArgs) Handles

c = e.KeyChar

e.Handled = True

End Sub

Private Sub TextBox2_KeyPress(ByVal sender As Object, ByVal

e As System.Windows.Forms.KeyPressEventArgs) Handles

c = e.KeyChar

e.Handled = True

End Sub

Private Sub TextBox4_LostFocus(ByVal sender As Object, ByVal e

As System.EventArgs) Handles TextBox4.LostFocus Dim bool As Boolean

Dim email As String = TextBox4.Text.Trim

bool = ((email.Contains("@") And email.Contains("."))

And (email.IndexOf("@") < email.IndexOf(".")) _

And (email.IndexOf("@") <> email.IndexOf(".") - 1))

If bool = False Then

(74)

MsgBox("Enter Valid Email Address.", MsgBoxStyle.Exclamation, "Invalid Email Address") TextBox4.Text = ""

End If

End Sub

Private Sub cmb_pr_id_SelectedIndexChanged(ByVal sender As

cmb_pr_id.SelectedIndexChanged

If cmb_pr_id.SelectedIndex = 0 Then

txt_pr_name.Text = "N8"

txt_mrp.Text = 25000

ElseIf cmb_pr_id.SelectedIndex = 1 Then

txt_pr_name.Text = "N900"

txt_pr_name.Text = "nokia 5233"

txt_mrp.Text = 6500

txt_pr_name.Text = "nokia E5"

txt_pr_name.Text = "nokia X5-01"

txt_mrp.Text = 9153

txt_pr_name.Text = "nokia X6"

txt_pr_name.Text = "nokia N97"

txt_pr_name.Text = "nokia N79"

(75)

txt_pr_name.Text = "nokia 5800"

txt_mrp.Text = 13518 End If

End Sub

Mobile_Bill.Show() End Sub

Private Sub TextBox1_TextChanged(ByVal sender As

TextBox10.TextChanged End Sub

Private Sub totalbtn_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles totalbtn.Click

TextBox7.Text = TextBox6.Text * txt_mrp.Text End Sub

Private Sub savebtn_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles savebtn.Click

If (f = 0) Then

ElseIf cmb_pr_id.Text = "" Then

ElseIf txt_pr_name.Text = "" Then

ElseIf txt_mrp.Text = "" Then

Else

a = MsgBox("Are you want to save new Order?", vbYesNo + vbQuestion, "SAVE")

If a = vbYes Then

cmd = New OleDbCommand("insert into Order values('" & TextBox1.Text & "','" & TextBox2.Text & "' ,'" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & cmb_pr_id.Text & "','" & txt_pr_name.Text & "','" & TextBox6.Text & "','" & txt_mrp.Text & "','" & TextBox7.Text &

"')", cn)