Form Design and CodingForm Design and Coding

Form Design and Coding

The proposed system is an application developed in Visual Basic 6.0, making it an event The proposed system is an application developed in Visual Basic 6.0, making it an event driven or menu driven system. Visual basic is an object based programming language. The driven or menu driven system. Visual basic is an object based programming language. The programming does not execute itself in any predetermined sequence but different lines of programming does not execute itself in any predetermined sequence but different lines of code in response to events.

code in response to events.

Visual Basic specifically follows procedural approach of coding wherein the problem is Visual Basic specifically follows procedural approach of coding wherein the problem is decomposed into independent procedures or modules (coded and tested), which are later decomposed into independent procedures or modules (coded and tested), which are later combined and finally a system is ready to be executed.

combined and finally a system is ready to be executed.

It allows us to adopt a parallel approach, with independent sections of code for each option It allows us to adopt a parallel approach, with independent sections of code for each option that the user might select.

that the user might select.

Coding for the proposed system was not a very tedious task since forms were distributed Coding for the proposed system was not a very tedious task since forms were distributed amongst the team of developers, who individually coded their parts, tested them and then amongst the team of developers, who individually coded their parts, tested them and then combined them to form

combined them to form „car dealership information system‟.„car dealership information system‟.

Car Dealership Information System Car Dealership Information System

FORMS AND CODING FORMS AND CODING

Home Home

Coding Coding

Private Sub Command1_Click () Private Sub Command1_Click () Form2gi.Show

Form2gi.Show End Sub

End Sub

Private Sub Command2_Click() Private Sub Command2_Click() Form3ENG.Show

Form3ENG.Show End Sub

End Sub

Private Sub Command3_Click() Private Sub Command3_Click()

Car Dealership Information System Car Dealership Information System

Form4DIM.Show Form4DIM.Show End Sub

End Sub

Private Sub Command4_Click() Private Sub Command4_Click() Form5TEC.Show

Form5TEC.Show End Sub

End Sub

Private Sub Command5_Click() Private Sub Command5_Click() Form6FIN.Show

Form6FIN.Show End Sub

End Sub

Private Sub Command6_Click() Private Sub Command6_Click() Form7FEAT.Show

Form7FEAT.Show End Sub

End Sub

Private Sub Command7_Click() Private Sub Command7_Click() Form8ACC.Show

Form8ACC.Show End Sub

End Sub

Car Dealership Information System Car Dealership Information System

General Information General Information

Car Dealership Information System Car Dealership Information System

Coding Coding

Private Sub cmdfirst_Click() Private Sub cmdfirst_Click() Adodc1.Recordset.MoveFirst Adodc1.Recordset.MoveFirst End Sub

End Sub

Private Sub cmdlast_Click() Private Sub cmdlast_Click() Adodc1.Recordset.MoveLast Adodc1.Recordset.MoveLast End Sub

End Sub

Private Sub cmdnext_Click() Private Sub cmdnext_Click()

If Adodc1.Recordset.EOF = True Then If Adodc1.Recordset.EOF = True Then Adodc1.Recordset.MoveFirst

Adodc1.Recordset.MoveFirst End If

End If

Adodc1.Recordset.MoveNext Adodc1.Recordset.MoveNext End Sub

End Sub

Private Sub cmdprevious_Click() Private Sub cmdprevious_Click()

Car Dealership Information System Car Dealership Information System

If Adodc1.Recordset.BOF = True Then If Adodc1.Recordset.BOF = True Then Adodc1.Recordset.MoveLast

If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then Adodc1.Recordset.Update

If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then Adodc1.Recordset.Delete Dim a As Variant

Dim a As Variant

a = InputBox("Please Enter Password") a = InputBox("Please Enter Password") If a = "suparn" Then

If a = "suparn" Then Frame1.Visible = True

MsgBox "You do not have authorization to edit.", vbCritical MsgBox "You do not have authorization to edit.", vbCritical End If

End If End Sub End Sub

Car Dealership Information System Car Dealership Information System

Private Sub Command5_Click () Private Sub Command5_Click () Frame1.Visible = False

Frame1.Visible = False Command5.Visible = False Command5.Visible = False Text1.Locked = True

Text1.Locked = True Text2.Locked = True Text2.Locked = True Text3.Locked = True Text3.Locked = True Text4.Locked = True Text4.Locked = True Text5.Locked = True Text5.Locked = True Text6.Locked = True Text6.Locked = True End Sub

End Sub

Car Dealership Information System Car Dealership Information System

Engine

Engine SpecificatiSpecificationsons

Coding Coding

Private Sub cmdfirst_Click() Private Sub cmdfirst_Click() Adodc1.Recordset.MoveFirst Adodc1.Recordset.MoveFirst End Sub

End Sub

Private Sub cmdlast_Click() Private Sub cmdlast_Click() Adodc1.Recordset.MoveLast Adodc1.Recordset.MoveLast End Sub

End Sub

Private Sub cmdnext_Click() Private Sub cmdnext_Click()

If Adodc1.Recordset.EOF = True Then If Adodc1.Recordset.EOF = True Then Adodc1.Recordset.MoveFirst

Adodc1.Recordset.MoveFirst End If

End If

Car Dealership Information System Car Dealership Information System

Adodc1.Recordset.MoveNext

If Adodc1.Recordset.BOF = True Then If Adodc1.Recordset.BOF = True Then Adodc1.Recordset.MoveLast

If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then Adodc1.Recordset.Update

If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then Adodc1.Recordset.Delete Dim a As Variant

Dim a As Variant

a = InputBox("Please Enter Password") a = InputBox("Please Enter Password") If a = "suparn" Then

If a = "suparn" Then Frame1.Visible = True

Car Dealership Information System Car Dealership Information System

Else Else

MsgBox "You do not have authorization to edit.", vbCritical MsgBox "You do not have authorization to edit.", vbCritical End If

End If End Sub End Sub

Private Sub Command5_Click() Private Sub Command5_Click() Frame1.Visible = False

Frame1.Visible = False Command5.Visible = False Command5.Visible = False Text1.Locked = True

End Sub

Car Dealership Information System Car Dealership Information System

Dimensions Dimensions

Coding Coding

Private Sub cmdfirst_Click() Private Sub cmdfirst_Click() Adodc1.Recordset.MoveFirst Adodc1.Recordset.MoveFirst End Sub

End Sub

Private Sub cmdlast_Click() Private Sub cmdlast_Click() Adodc1.Recordset.MoveLast Adodc1.Recordset.MoveLast End Sub

End Sub

Private Sub cmdnext_Click() Private Sub cmdnext_Click()

If Adodc1.Recordset.EOF = True Then If Adodc1.Recordset.EOF = True Then Adodc1.Recordset.MoveFirst

Adodc1.Recordset.MoveFirst

Car Dealership Information System Car Dealership Information System

End If

If Adodc1.Recordset.BOF = True Then If Adodc1.Recordset.BOF = True Then Adodc1.Recordset.MoveLast

If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then Adodc1.Recordset.Update

If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then Adodc1.Recordset.Delete Dim a As Variant

Dim a As Variant

a = InputBox("Please Enter Password") a = InputBox("Please Enter Password") If a = "suparn" Then

If a = "suparn" Then Frame1.Visible = True

Car Dealership Information System Car Dealership Information System

Text8.Locked = False Text8.Locked = False Else

Else

MsgBox "You do not have authorization to edit.", vbCritical MsgBox "You do not have authorization to edit.", vbCritical End If

End If End Sub End Sub

Private Sub Command5_Click() Private Sub Command5_Click() Frame1.Visible = False

Frame1.Visible = False Command5.Visible = False Command5.Visible = False Text1.Locked = True

End Sub

Car Dealership Information System Car Dealership Information System

Technical Information Technical Information

Coding Coding

Private Sub cmdfirst_Click() Private Sub cmdfirst_Click() Adodc1.Recordset.MoveFirst Adodc1.Recordset.MoveFirst End Sub

End Sub

Private Sub cmdlast_Click() Private Sub cmdlast_Click() Adodc1.Recordset.MoveLast Adodc1.Recordset.MoveLast End Sub

End Sub

Private Sub cmdnext_Click() Private Sub cmdnext_Click()

If Adodc1.Recordset.EOF = True Then If Adodc1.Recordset.EOF = True Then

Car Dealership Information System Car Dealership Information System

Adodc1.Recordset.MoveFirst

If Adodc1.Recordset.BOF = True Then If Adodc1.Recordset.BOF = True Then Adodc1.Recordset.MoveLast

If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then Adodc1.Recordset.Update

If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then Adodc1.Recordset.Delete Dim a As Variant

Dim a As Variant

a = InputBox("Please Enter Password") a = InputBox("Please Enter Password") If a = "suparn" Then

If a = "suparn" Then Frame1.Visible = True

Car Dealership Information System Car Dealership Information System

Else Else

MsgBox "You do not have authorization to edit.", vbCritical MsgBox "You do not have authorization to edit.", vbCritical End If

End If End Sub End Sub

Private Sub Command5_Click() Private Sub Command5_Click() Frame1.Visible = False

Frame1.Visible = False Command5.Visible = False Command5.Visible = False Text1.Locked = True

End Sub

Car Dealership Information System Car Dealership Information System

Financials Financials

Coding Coding

Private Sub cmdfirst_Click() Private Sub cmdfirst_Click() Adodc1.Recordset.MoveFirst Adodc1.Recordset.MoveFirst End Sub

End Sub

Private Sub cmdlast_Click() Private Sub cmdlast_Click() Adodc1.Recordset.MoveLast Adodc1.Recordset.MoveLast End Sub

End Sub

Private Sub cmdnext_Click() Private Sub cmdnext_Click()

If Adodc1.Recordset.EOF = True Then If Adodc1.Recordset.EOF = True Then Adodc1.Recordset.MoveFirst

Adodc1.Recordset.MoveFirst End If

End If

Car Dealership Information System Car Dealership Information System

Adodc1.Recordset.MoveNext

If Adodc1.Recordset.BOF = True Then If Adodc1.Recordset.BOF = True Then Adodc1.Recordset.MoveLast

If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then Adodc1.Recordset.Update

If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then Adodc1.Recordset.Delete Dim a As Variant

Dim a As Variant

a = InputBox("Please Enter Password") a = InputBox("Please Enter Password") If a = "suparn" Then

If a = "suparn" Then Frame1.Visible = True

MsgBox "You do not have authorization to edit.", vbCritical MsgBox "You do not have authorization to edit.", vbCritical

Car Dealership Information System Car Dealership Information System

End If End If End Sub End Sub

Private Sub Command5_Click() Private Sub Command5_Click() Frame1.Visible = False

Frame1.Visible = False Command5.Visible = False Command5.Visible = False Text1.Locked = True

Text1.Locked = True Text2.Locked = True Text2.Locked = True Text3.Locked = True Text3.Locked = True Text4.Locked = True Text4.Locked = True Text5.Locked = True Text5.Locked = True End Sub

End Sub

Car Dealership Information System Car Dealership Information System

Features Features

Coding Coding

Private Sub cmdfirst_Click() Private Sub cmdfirst_Click() Adodc1.Recordset.MoveFirst Adodc1.Recordset.MoveFirst End Sub

End Sub

Private Sub cmdlast_Click() Private Sub cmdlast_Click() Adodc1.Recordset.MoveLast Adodc1.Recordset.MoveLast End Sub

End Sub

Private Sub cmdnext_Click() Private Sub cmdnext_Click()

If Adodc1.Recordset.EOF = True Then If Adodc1.Recordset.EOF = True Then Adodc1.Recordset.MoveFirst

Adodc1.Recordset.MoveFirst End If

End If

Car Dealership Information System Car Dealership Information System

Adodc1.Recordset.MoveNext

If Adodc1.Recordset.BOF = True Then If Adodc1.Recordset.BOF = True Then Adodc1.Recordset.MoveLast

If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then Adodc1.Recordset.Update

If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then Adodc1.Recordset.Delete Dim a As Variant

Dim a As Variant

a = InputBox("Please Enter Password") a = InputBox("Please Enter Password") If a = "suparn" Then

If a = "suparn" Then Frame1.Visible = True

Car Dealership Information System Car Dealership Information System

MsgBox "You do not have authorization to edit.", vbCritical MsgBox "You do not have authorization to edit.", vbCritical End If

End If End Sub End Sub

Private Sub Command5_Click() Private Sub Command5_Click() Frame1.Visible = False

Frame1.Visible = False Command5.Visible = False Command5.Visible = False Text1.Locked = True

End Sub

Car Dealership Information System Car Dealership Information System

Accessories Accessories

Coding Coding

Private Sub cmdfirst_Click() Private Sub cmdfirst_Click() Adodc1.Recordset.MoveFirst Adodc1.Recordset.MoveFirst End Sub

End Sub

Private Sub cmdlast_Click() Private Sub cmdlast_Click() Adodc1.Recordset.MoveLast Adodc1.Recordset.MoveLast End Sub

End Sub

Private Sub cmdnext_Click() Private Sub cmdnext_Click()

If Adodc1.Recordset.EOF = True Then If Adodc1.Recordset.EOF = True Then Adodc1.Recordset.MoveFirst

Adodc1.Recordset.MoveFirst End If

End If

Car Dealership Information System Car Dealership Information System

Adodc1.Recordset.MoveNext

If Adodc1.Recordset.BOF = True Then If Adodc1.Recordset.BOF = True Then Adodc1.Recordset.MoveLast

If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then If MsgBox("Save this record?", vbYesNo, "Save") = vbYes Then Adodc1.Recordset.Update

If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then If MsgBox("Are you sure?", vbYesNo, "Delete") = vbYes Then Adodc1.Recordset.Delete Dim a As Variant

Dim a As Variant

a = InputBox("Please Enter Password") a = InputBox("Please Enter Password") If a = "suparn" Then

If a = "suparn" Then Frame1.Visible = True

MsgBox "You do not have authorization to edit.", vbCritical MsgBox "You do not have authorization to edit.", vbCritical End If

End If End Sub End Sub

Car Dealership Information System Car Dealership Information System

Private Sub Command5_Click() Private Sub Command5_Click() Frame1.Visible = False

Frame1.Visible = False Command5.Visible = False Command5.Visible = False Text1.Locked = True

End Sub

Car Dealership Information System Car Dealership Information System

Chapter 6 Chapter 6

TESTING TESTING

Software testing is the process used to measure the quality of developed software product.

Effective software testing will contribute to the delivery of higher quality software Effective software testing will contribute to the delivery of higher quality software products, more satisfied users, lower maintenance costs, more accurate, and reliable results.

products, more satisfied users, lower maintenance costs, more accurate, and reliable results.

Usually, quality is constrained to such topics as

Usually, quality is constrained to such topics as correctness, comcorrectness, completeness, security, but canpleteness, security, but can also include more technical requirements as described under the ISO standard ISO 9126, also include more technical requirements as described under the ISO standard ISO 9126, such as capability, reliability, efficiency, portability, maintainability, compatibility, and such as capability, reliability, efficiency, portability, maintainability, compatibility, and usability. Testing is a process of technical investigation, performed on behalf of usability. Testing is a process of technical investigation, performed on behalf of stakeholders, that is intended to reveal quality-related information about the product with stakeholders, that is intended to reveal quality-related information about the product with respect to the context in which it is intended to operate. This includes, but is not limited to, respect to the context in which it is intended to operate. This includes, but is not limited to, the process of executing a program or application with the intent of finding errors. Hence the process of executing a program or application with the intent of finding errors. Hence software testing is necessary and

software testing is necessary and important activity of software development process. It is aimportant activity of software development process. It is a very expensive process and consumes one-third to one-half of the cost of a typical very expensive process and consumes one-third to one-half of the cost of a typical development project. It is partly intuitive but largely systematic. Good testing involves development project. It is partly intuitive but largely systematic. Good testing involves much more than just running the program a few times to see whether it works. Thorough much more than just running the program a few times to see whether it works. Thorough analysis of a

analysis of a program helps us to test program helps us to test more systematically and more effectively.more systematically and more effectively.

6.1 Objectives of testing 6.1 Objectives of testing



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



 A good test case is one that has a high probability of finding as yet undiscoveredA good test case is one that has a high probability of finding as yet undiscovered error.

error.



 A successful test is one that uncovers an asA successful test is one that uncovers an as-yet-undiscover-yet-undiscovered errored error

Car Dealership Information System Car Dealership Information System

6.2 Testing Principles 6.2 Testing Principles



 All tests should be All tests should be traceable to customer requirements.traceable to customer requirements.



 Tests should be planned long before testing begins.Tests should be planned long before testing begins.



 Testing should begin “in the small”Testing should begin “in the small” and prand progress toward testing “testing in large”ogress toward testing “testing in large”..



 Exhaustive testing is not possible.Exhaustive testing is not possible.



 To be most effective, testing should be conducted by an independent third party.To be most effective, testing should be conducted by an independent third party.

6.3 Verification and validation 6.3 Verification and validation

Software testing is used

Software testing is used in association with verification and validation (V&V). in association with verification and validation (V&V). VerificationVerification is the checking of or testing of items, including software, for conformance and consistency is the checking of or testing of items, including software, for conformance and consistency with an associated specification. Software testing is just one

with an associated specification. Software testing is just one kind of kind of verification, which alsoverification, which also uses techniques such as reviews, inspections, and walkthroughs. Validation is

uses techniques such as reviews, inspections, and walkthroughs. Validation is the process of the process of checking what has been specified is

checking what has been specified is what the user actually wanted.what the user actually wanted.

6.4 Types of testing 6.4 Types of testing



 Unit Testing-Unit Testing- In unit testing, different modules are tested against the specificationIn unit testing, different modules are tested against the specification produced during design for the modules. The main goal of unit testing is to test the produced during design for the modules. The main goal of unit testing is to test the internal log

internal logic of the ic of the modules. A modules. A module is module is considered fconsidered for integrator integration and useion and used byd by others only after it has

others only after it has been unit tested satisfactorily.been unit tested satisfactorily.



 Integration Testing-- The main emphasis is on testing interfaces between modules.Integration Testing The main emphasis is on testing interfaces between modules.



 System Testing-System Testing- In system testing, the entire software is tested. The referenceIn system testing, the entire software is tested. The reference

In document Car Dealership Information System (Page 33-62)