Online Shopping

A Project Report

Submitted to the Manonmaniam Sundaranar University in partial

fulfillment of the requirements for the Degree of Master of Computer
Applications.

Done by,
Monolisha (Reg No: 3902881)

Under the guidance of

[Link] Raja Singh, [Link]., [Link], [Link]
(Lecturer in Computer Science)

DEPARTMENT OF MASTER OF COMPUTER APPLICATIONS

ANNAI VELANKANNI COLLEGE
THOLAYAVATTAM-629157
Ph: 04651-235270
Website: [Link]
2012-2013.
 ANNAI VELANKANNI COLLEGE
THOLAYAVATTAM
DEPARTMENT OF COMPUTER APPLICATIONS

CERTIFICATE

This is to certify that the project entitled “Online Shopping”

is the work done by, [Link](Reg No: 3902881),[Link](Reg No:
3902868) in partial fulfillment of the requirements for the award of the
degree of Bachelor of Computer Application of Manonmaniam Sundaranar
University during the academic year 2012-2013.

Head of the Department Project Guide

Submitted for the project viva-voce Examination held at Annai

Velankanni College, Tholayavattam on ………………

External Examiner
1.
2.
 DECLARATION

I declare that this project work entitled “Online Shopping” done in is

Annai Velankanni College, Tholayavattam submitted to Manonmaniam
Sundaranar University in partial fulfillment of the requirements for the
award of the degree of Master of Computer Application is the original work
done by me during the period of 2012-2013 under the guidance of
[Link] Antony Jeyaraj [Link]., [Link].

Done By,
[Link]
[Link] Mary
 ACKNOWLEDGEMENT

First of all, I thank the almighty Lord who showered the blessings
upon us and made finish our project successfully.
I own my thanks to our correspondent [Link] Benedict,
DCL. For providing us all the supports.
I express my gratitude towards [Link] [Link]., Ph.D., our
Principal, for her kind words of encouragement
I also express my sincere thanks to [Link] Raja Singh,
[Link]., [Link], [Link], Head of the department of Computer Applications,
who was a constant source of inspiration to me throughout the preparation of
this dissertation.
I express my gratitude towards [Link] Raja Singh, [Link].,
[Link], [Link], for his guidance, help and advice throughout our project
work.
I also graceful to our classmates and friends for their assistance and
help provided by them during this project.
Last but not the least; I give my special thanks to my family members
for their support and prayers.
 CONTENTS

1. SYNOPSIS
2. INTRODUCTION

2.1 FEASIBILITY STUDY

3. PROBLEM DEFINITION
3.1 EXISTING SYSTEM

3.2 PROPOSED SYSTEM

4. SYSTEM REQUIREMENT
4.1 SOFTWARE REQUIREMENT

4.2 HARDWARE REQUIREMENT

5. PROGRAM ENVIRONMENT

5.1 LANGUAGE DESCRIPTION

5.2 OPERATING SYSTEM

6. PROJECT DESCRIPTION

7. SOURCE CODE

8. SYSTEM DESIGN

8.1 SYSTEM FLOW DESIGN

8.2 DATA BASE DESIGN

8.3 INPUT DESIGN

8.4 OUTPUT DESIGN

9. SYSTEM TESTING
[Link] IMPLEMENTATION

[Link] MAINTENANCE

[Link]

13. FUTURE ENHANCEMENT

14. BIBLIOGRAPHY
 1. SYNOPSIS

Online shopping is a web-based application Software developed using [Link]

as front end. The main aim of online shopping is to improve the services of customers
and vendors. It maintains the details of customer payments, addition of new products and
also updating, deleting for the same. It also stores the details of payments made by
customers with all payment details like Credit and Debit card. The primary feature of
online shopping is high accuracy, design flexibility and easy availability.
 2. INTRODUCTION

This project is aimed at developing a web application that depicts Online

Shopping and purchasing using Payment Gateway. Using this software, companies can
improve the efficiency of their services. Online Shopping is one of the applications to
improve the marketing of the company’s products. This web application involves all the
features of the online shopping. . The software will help in easy maintaining and updating
products in the website for the administrator. This system will reduce the manual
operation required to maintain all the records of booking information. And also generates
the various reports for analysis. Main concept of the project is to enter transaction reports
and to maintain customer records.
 2.1 FEASIBILITY STUDY

A feasibility study is a preliminary study undertaken to determine and document a

project's viability. Also known as feasibility analysis .The term feasibility study is also

used to refer to the resulting document. The results of this study are used to make a

decision whether or not to proceed with the project. If it indeed leads to a project being

approved, before the real work of the proposed project starts be used to ascertain the

likelihood of the project's success. It is an analysis of possible alternative solutions to a

problem and a recommendation on the best alternative. It, for example, can decide

whether an order processing be carried out by a new system more efficiently than the

previous one.

A feasibility study is an important part of creating a business plan for a new

enterprise, since it has been estimated that only one idea in fifty is commercially viable.

If a project is seen to be feasible from the results of the study, the next logical step is to

proceed with it. The research and information uncovered in the feasibility study will

support the detailed planning and reduce the research time.

Components of Feasibility

This involves questions such as whether the technology needed for the system exists, how

difficult it will be to build, and whether the firm has enough experience using that

technology. The assessment is based on an outline design of system requirements in

terms of Input, Processes, Output, Fields, Programs, and Procedures. This can be
quantified in terms of volumes of data, trends, frequency of updating, etc in order to

estimate if the new system will perform adequately or not. Three considerations are

involved in the feasibility analysis. They are Technical Feasibility, Operational

Feasibility and Economical Feasibility.

1. Technical feasibility:

The technical issues usually raised during the feasibility stage of the investigation

include these:

a. Does the necessary technology exist to do what is suggested!

b. Does the proposed equipment have the technical capacity to hold the data required

to use the new system!

c. Will the proposed system provide adequate responses to inquiries, regardless of

the number or location of users!

d. Can be system be expanded if developed!

e. Are the technical guarantees of accuracy, reliability, ease of access, and data

security!

Yes, by using the current technology this software can be developed and also the

Visual [Link] framework is made to be installed.

2. Economic Feasibility:

The financial and economic questions raised by analysts during the preliminary

investigation are for the purpose of estimating the following:

a. The cost to conduct a full system investigation

b. The cost of hardware and software for the class of application being considered.

c. The benefits in the form of reduced costs or fewer costly errors .

d. The cost if nothing changes(i.e., the proposed system is not developed).

As this is a simple project, there is no such cost is required. Except the cost that is

needed for the Local Cable wire that has to be connected. From one system to another

the LAN wire is made to be connected and from that only the Internet Protocol is

made to be called. Whereas, the information is made to be transferred and also

[Link] cost to hardware is the cable wire and the cost towards software side is

Visual .NET Framework.

3. Operational Feasibility:

Proposed projects are beneficial projects only if they can be turned into

information systems that will meet the organization’s operating requirements. Simply

stated, this test of feasibility asks if the system will work when it is developed and

installed.

Will the system be used if it is developed and implemented? Will there be resistance

from users that will undermine the possible application benefits?

Issues that appear to be relatively minor in the beginning have ways of growing into

major problems after implementation. Therefore all operational aspects must be

considered carefully. Operational feasibility is looked at the view of proposed

solution fitting with the current operations. This test of feasibility asks,

1 How long the system will work when it is developed and installed.

2 How will the solution affect the end-users work environment?

 3. PROBLEM DEFINITION

3.1 Existing System:

In the existing system the ONLINE SHOPPING, when the user buys a
product if he needs to know other accessories of the same amount or with different
colors, the shopping is difficult. Further the applications have to be processed manually.
This was a tedious process, which requires lot of time and it has various drawback ad
follows:

 Lack of security.

3.2 Proposed System:

In order to overcome the drawback of the existing system, the current system is
developed to provide accurate in a fraction of seconds. Advantages of the proposed
system are as follows:

 Every person who comes to the website of online shopping has to create an
account where the shopping is highly secured.
 The logged people are secured with a password, which when gets into the website
signs in using the username and password.
.
 4. SYSTEM REQUIREMENT

4.1 HARDWARE CONFIGURATION

Processor : Pentium IV 2.4GHZ MHz

Mother Board : Intel 845 GVSR
RAM : 256 MB
Hard Disk : 80 GB
Key board : Samsung keyboard
Monitor : LG 17” Monitor 1024*768 pixels
Mouse : Samsung Optical Mouse

4.2 SOFTWARE CONFIGURATION

Operating system : Windows XP Sp2

Web Server : IIS 5.0
Server Side Script : [Link]
Client Side Script : C#
Front End : [Link]
Back End : MS-SQL Server 2005
IDE : [Link] Framework 2005
 [Link] ENVIRONMENT

WINDOWS XP

Windows XP is a full-fledged operating system. Windows XP Professional, you

have faster access to information, and you are able to accomplish tasks more quickly and
easily. You and your network administrations can work more efficiently now, because
many of the most common computer-management tasks are automated and streamlined.
It is possible to use another operating system on your computer along with Windows XP.

Windows XP supports a feature called dual-boot or multiple-boot. Using this,

Windows XP will ask you which operating system you want to use. But to install another
operating system, you will need a separate partition, which will look a separate drive in
My Computer.

Windows 2003 Server

It is a good for small sized to medium sized application deployment, Web

Servers, workgroups, and branch offices. Windows 2003 Server supports uni-processor
systems and 4-way Symmetric Multi Processing (SMP) systems with up to 4 Giga Bytes
(GB) of physical memory.

Windows 2003 Advanced Server

More powerful server operating system, providing a comprehensive clustering

infrastructure for high availability and scalability, supporting memory up to 8 GB. It is
designed for demanding enterprise applications. Advanced server supports new systems
with up to 8-way SMP. A more advanced department and applications server ideal for
large, database-intensive applications.

Windows 2003 Data Center Server

A specialized high-end version of Windows 2000 server, supporting up to 32-

way SMP and up to 64 GB of physical memory. This server product is targeted at large
data warehouses, econometric analysis, large-scale simulations in science and
engineering, On-Line Transaction Processing (OLTP) and server consolidation projects.

Hardware Requirement for Windows XP Professional

To use Windows XP Professional you should have:

1 A Pentium II Processor

2 500 MB of free hard disk space.

3 64 MB of RAM.

If your computer doesn’t meet the minimum requirements then you have to beef-
up your system before you switch to Windows XP.

What’s new in Windows XP Professional?

1 Easier to use

2 Easier to manage

3 Latest Hardware Support

4 More Reliable

5 More Secure

[Link] FRAMEWORK

The .NET Framework is a new computing platform that simplifies application

development in the highly distributed environment of the Internet. The .NET Framework

is designed to fulfill the following objectives:

 To provide a consistent object-oriented programming environment whether object

code is stored and executed locally, executed locally but Internet-distributed, or

executed remotely.

 To provide a code-execution environment that minimizes software deployment

and versioning conflicts.

  To provide a code-execution environment that guarantees safe execution of code,

including code created by an unknown or semi-trusted third party.

 To provide a code-execution environment that eliminates the performance

problems of scripted or interpreted environments.

 To make the developer experience consistent across widely varying types of

applications, such as Windows-based applications and Web-based applications.

 To build all communication on industry standards to ensure that code based on the

.NET Framework can integrate with any other code.

Features of the Common Language Runtime

The common language runtime manages memory, thread execution, code

execution, code safety verification, compilation, and other system services. These

features are intrinsic to the managed code that runs on the common language runtime.

The runtime enforces code access security. For example, users can trust that an

executable embedded in a Web page can play an animation on screen or sing a song, but

cannot access their personal data, file system, or network. The security features of the

runtime thus enable legitimate Internet-deployed software to be exceptionally feature

rich.

The runtime also enforces code robustness by implementing a strict type- and

code-verification infrastructure called the common type system (CTS). The CTS ensures

that all managed code is self-describing. The various Microsoft and third-party language

compilers
 Generate managed code that conforms to the CTS. This means that managed

code can consume other managed types and instances, while strictly enforcing type

fidelity and type safety.

.NET Framework Class Library:

The .NET Framework class library is a collection of reusable types that tightly

integrate with the common language runtime. The class library is object oriented,

providing types from which your own managed code can derive functionality. This not

only makes the .NET Framework types easy to use, but also reduces the time associated

with learning new

features of the .NET Framework. In addition, third-party components can integrate

seamlessly with classes in the .NET Framework. As you would expect from an object-

oriented class library, the .NET Framework types enable you to accomplish a range of

common programming tasks, including tasks such as string management, data collection,

database connectivity, and file access. In addition to these common tasks, the class library

includes types that support a variety of specialized development scenarios. For example,

you can use the .NET Framework to develop the following types of applications and

services:

 Console applications.

 Scripted or hosted applications.

 Windows GUI applications (Windows Forms).

 [Link] applications.

 XML Web services.

  Windows services.

C#.NET

C# is very much a programming language – a pure object oriented language from

Microsoft, especially designed from the scratch for the upcoming .NET revolution. C# is

one of the most important components of the .NET revolution in addition to the new

Visual [Link] and C++.NET. It has been designed to provide all the good features of

the popular programming language as it adopts its simplicity and productivity from

Visual Basic, power of C++ and elegance of Java. By definition, C# is a simple, modern,

object oriented, and type-safe programming language derived from C and C++.

The following sections will introduce you to some objects that have evolved, and some

that are new. These objects are:

 Connections. For connection to and managing transactions against a database.

 Commands. For issuing SQL commands against a database.

 DataReaders. For reading a forward-only stream of data records from a SQL

Server data source.

 DataSets. For storing, remoting and programming against flat data, XML data

and relational data.

 DataAdapters. For pushing data into a DataSet, and reconciling data against a

database.
 [Link]

[Link] is the hosting environment that enables developers to use the .NET Framework

to target Web-based applications. However, [Link] is more than just a runtime host; it

is a complete architecture for developing Web sites and Internet-distributed objects using

managed code.

Active Server [Link]

[Link] is a programming framework built on the common language runtime that

can be used on a server to build powerful Web applications. [Link] offers several

important advantages over previous Web development models:

 Enhanced Performance

 World-Class Tool Support.

 Power and Flexibility.

VISUAL BASIC .NET

Visual Basic .NET provides the easiest, most productive language and tool for

rapidly building Windows and Web applications. Visual Basic .NET comes with

enhanced visual designers, increased application performance, and a powerful integrated

development environment (IDE). It also supports creation of applications for wireless,

Internet-enabled hand-held devices. The following are the features of Visual Basic .NET
with .NET Framework 1.0 and Visual Basic .NET 2003 with .NET Framework 1.1. This

also answers why should I use Visual Basic .NET, what can I do with it?

Powerful Windows-based Applications

Visual Basic .NET comes with features such as a powerful new forms

designer, an in-place menu editor, and automatic control anchoring and docking.

Visual Basic .NET delivers new productivity features for building more robust

applications easily and quickly. With an improved integrated development

environment (IDE) and a significantly reduced startup time, Visual Basic .NET

offers fast, automatic formatting of code as you type, improved IntelliSense, an

enhanced object browser and XML designer, and much more.

Building Web-based Applications

With Visual Basic .NET we can create Web applications using the shared Web

Forms Designer and the familiar "drag and drop" feature. You can double-click and write

code to respond to events. Visual Basic .NET 2003 comes with an enhanced HTML

Editor for working with complex Web pages. We can also use IntelliSense technology

and tag completion, or choose the WYSIWYG editor for visual authoring of interactive

Web applications.
Simplified Deployment

With Visual Basic .NET we can build applications more rapidly and deploy and

maintain them with efficiency. Visual Basic .NET 2003 and .NET Framework 1.1 makes

"DLL Hell" a thing of the past. Side-by-side versioning enables multiple versions of the

same component to live safely on the same machine so that applications can use a

specific version of a component. XCOPY-deployment and Web auto-download of

Windows-based applications combine the simplicity of Web page deployment and

maintenance with the power of rich, responsive Windows-based applications.

Powerful, Flexible, Simplified Data Access

You can tackle any data access scenario easily with [Link] and ADO data

access. The flexibility of [Link] enables data binding to any database, as well as

classes, collections, and arrays, and provides true XML representation of data. Seamless

access to ADO enables simple data access for connected data binding scenarios. Using

[Link], Visual Basic .NET can gain high-speed access to MS SQL Server, Oracle,

DB2, Microsoft Access, and more.

Improved Coding

You can code faster and more effectively. A multitude of enhancements to the

code editor, including enhanced IntelliSense, smart listing of code for greater readability

and a background compiler for real-time notification of syntax errors transforms into a

rapid application development (RAD) coding machine.

Direct Access to the Platform

Visual Basic developers can have full access to the capabilities available in .NET

Framework 1.1. Developers can easily program system services including the event log,

performance counters and file system. The new Windows Service project template

enables to build real Microsoft Windows NT Services. Programming against Windows

Services and creating new Windows Services is not available in Visual Basic .NET

Standard, it requires Visual Studio 2003 Professional, or higher.

Full Object-Oriented Constructs

You can create reusable, enterprise-class code using full object-oriented

constructs. Language features include full implementation inheritance, encapsulation, and

polymorphism. Structured exception handling provides a global error handler and

eliminates spaghetti code.

XML Web Services

XML Web services enable you to call components running on any platform using

open Internet protocols. Working with XML Web services is easier where enhancements

simplify the discovery and consumption of XML Web services that are located within

any firewall. XML Web services can be built as easily as you would build any class in
Visual Basic 6.0. The XML Web service project template builds all underlying Web

service infrastructure.

Mobile Applications

Visual Basic .NET 2003 and the .NET Framework 1.1 offer integrated support for

developing mobile Web applications for more than 200 Internet-enabled mobile devices.

These new features give developers a single, mobile Web interface and programming

model to support a broad range of Web devices, including WML 1.1 for WAP—enabled

cellular phones, compact HTML (cHTML) for i-Mode phones, and HTML for Pocket

PC, handheld devices, and pagers. Please note, Pocket PC programming is not available

in Visual Basic .NET Standard, it requires Visual Studio 2003 Professional, or higher.

COM Interoperability

You can maintain your existing code without the need to recode. COM

interoperability enables you to leverage your existing code assets and offers seamless bi-

directional communication between Visual Basic 6.0 and Visual Basic .NET applications.

Reuse Existing Investments

You can reuse all your existing ActiveX Controls. Windows Forms in Visual

Basic .NET 2003 provide a robust container for existing ActiveX controls. In addition,

full support for existing ADO code and data binding enable a smooth transition to Visual

Basic .NET 2003.

Upgrade Wizard

You upgrade your code to receive all of the benefits of Visual Basic .NET 2003.

The Visual Basic .NET Upgrade Wizard, available in Visual Basic .NET 2003 Standard

Edition, and higher, upgrades up to 95 percent of existing Visual Basic code and forms to

Visual Basic .NET with new support for Web classes and User Controls.
 6. PROJECT DESCRIPTION

Online shopping is a web-based application Software developed using [Link]

as front end. The main aim of online shopping is to improve the services of customers
and vendors. It maintains the details of customer payments, addition of new products and
also updating, deleting for the same. It also stores the details of payments made by
customers with all payment details like Credit and Debit card. The primary feature of
online shopping is high accuracy, design flexibility and easy availability.

Login: This module has a textbox and password box in which you have to give registered
username and password. If the username and password are correct then the user is
directed to next page.

ADMIN: If the admin wants to login then he/she should give the username and password
as [Link] ADMIN has all the rights in the software including updating the status of
his site.

New user: This module is for the users who do not have their account. Here user is
allowed to create an account to login. The account creation is done by filling the
registration form with user details such as name, password, security question etc.

Product: This module has information regarding the products such as its name, brand,
type, price information; its features [Link] ADMIN has the authority to Add, Delete,
and Update etc. The USER can only view the product, add for payment. User can select
and buy only one product at a time

Payment: This module describes the payment done by the customer. The payment
information can include information like the product purchased, mode of payment etc.
 Terms and conditions

 Since it is an online project, customers need internet connection to buy

products.

 People who are not familiar with computers can’t use this software.

 Customer must have debit card or credit card to purchase products.

 Customer can buy only one product at a time

 Customer can only buy available products.

 Customer should proceed to transaction if he/she is able to pay the full

amount purchased through card.
 7. SOURCE CODE

Add New [Link]

Imports [Link]
Imports [Link]
Partial Class AddNewProduct
Inherits [Link]
Dim con As OleDbConnection
Dim com As OleDbCommand
Dim da As OleDbDataAdapter
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As
[Link]) Handles [Link]
Try
[Link](5000)
If [Link] = True Then
Dim str As String
str =
[Link]("connect").ConnectionString
con = New OleDbConnection(str)
[Link]()
com = New OleDbCommand("insert into NewProduct values('"
& [Link] & "','" & [Link] & "','" &
[Link] & "','" & [Link] &
"','" & [Link] & "','~\\Product\\" & [Link] & "','"
& [Link] & "')", con)
[Link]()
[Link] = "Product Added Successfully"
[Link] = ""
[Link] = ""
[Link] = ""
[Link] = -1
[Link] = -1
[Link] = -1
[Link]("E:\Shopping\Product\" +
[Link])
[Link]()
CusID()
End If
Catch ex As Exception
[Link] = [Link]
End Try
End Sub
Public Sub CusID()
Dim code_id As String = ""
 Dim temp As Integer
Dim str As String
str =
[Link]("connect").ConnectionString
con = New OleDbConnection(str)
[Link]()
da = New OleDbDataAdapter("select count (ProductID) from
NewProduct", con)
Dim dt As New DataTable
[Link](dt)
If [Link](0)(0).ToString() = "" Then
code_id = "PRO-0001"
Else
temp = [Link]([Link](0)(0).ToString())
temp += 1
Dim len As Integer = [Link]().Length
If len = 1 Then
code_id = "PRO-000" & temp
ElseIf len = 2 Then
code_id = "PRO-00" & temp
ElseIf len = 3 Then
code_id = "PRO-0" & temp
Else
code_id = "PRO-" & temp
End If
End If
[Link] = code_id
End Sub

Protected Sub Page_Load(ByVal sender As Object, ByVal e As

[Link]) Handles [Link]
Try
If Not IsPostBack Then
CusID()
End If
Catch ex As Exception
[Link] = [Link]
End Try
End Sub
End Class

Display [Link]

Imports [Link]
Imports [Link]
Partial Class DisplayProduct
Inherits [Link]
Dim con As OleDbConnection
Dim da As OleDbDataAdapter
Dim str
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
[Link]) Handles [Link]
 str =
[Link]("Connect").ConnectionString
con = New OleDbConnection(Str)
[Link]()
da = New OleDbDataAdapter("Select * from NewProduct", con)
Dim ds As New DataSet()
[Link](ds)
[Link] = ds
[Link]()
End Sub
End Class

Booking [Link]

Imports [Link]
Imports [Link]
Partial Class BookingCustomerList
Inherits [Link]
Dim _oledbcon As OleDbConnection
Dim _oledbda As OleDbDataAdapter, _oledbda1 As OleDbDataAdapter,
_oledbda2 As OleDbDataAdapter
Dim str As String
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
[Link]) Handles [Link]
Str =
[Link]("Connect").ConnectionString
_oledbcon = New OleDbConnection(Str)
_oledbcon.Open()
_oledbda = New OleDbDataAdapter("Select * from Address",
_oledbcon)
Dim ds As New DataSet()
_oledbda.Fill(ds)
[Link] = ds
[Link]()
End Sub
End Class

[Link]

Imports [Link]
Imports [Link]
Partial Class BuyProduct
Inherits [Link]
Dim _oledbcon As OleDbConnection
Dim _oledbcom As OleDbCommand
Dim _oledbdr As OleDbDataReader
Dim str As String
Protected Sub txtid_TextChanged(ByVal sender As Object, ByVal e As
[Link]) Handles [Link]
Try
Str =
[Link]("Connect").ConnectionString
_oledbcon = New OleDbConnection(Str)
_oledbcon.Open()
 _oledbcom = New OleDbCommand("Select * from NewProduct where
ProductID='" + [Link] & "' ", _oledbcon)
_oledbdr = _oledbcom.ExecuteReader()
_oledbdr.Read()
[Link] = _oledbdr.GetString(1)
[Link] = _oledbdr.GetString(2)
[Link] = _oledbdr.GetString(3)
[Link] = _oledbdr.GetString(4)
[Link] = _oledbdr.GetString(5)
Session("PID") = [Link]
Session("PNAME") = [Link]
Session("CNAME") = [Link]
'Session["Cname"] = [Link];
'Session["Mname"] = [Link];
Session("MNAME") = [Link]
Catch ex As Exception
[Link] = [Link]
End Try
End Sub

Protected Sub Button6_Click(ByVal sender As Object, ByVal e As

[Link]) Handles [Link]
[Link]("[Link]")
End Sub
End Class

Contact [Link]

Imports [Link]
Imports [Link]
Partial Class ContactDetails
Inherits [Link]
Dim con As OleDbConnection
Dim com As OleDbCommand
Dim da As OleDbDataAdapter
Public Sub CusID()
Dim code_id As String = ""
Dim temp As Integer
Dim str As String
str =
[Link]("connect").ConnectionString
con = New OleDbConnection(str)
[Link]()
da = New OleDbDataAdapter("select count (Pid) from Address",
con)
Dim dt As New DataTable
[Link](dt)
If [Link](0)(0).ToString() = "" Then
code_id = "CUS-0001"
Else
temp = [Link]([Link](0)(0).ToString())
temp += 1
Dim len As Integer = [Link]().Length
If len = 1 Then
code_id = "CUS-000" & temp
ElseIf len = 2 Then
 code_id = "CUS-00" & temp
ElseIf len = 3 Then
code_id = "CUS-0" & temp
Else
code_id = "CUS-" & temp
End If
End If
[Link] = code_id
End Sub
Dim str As String
Protected Sub Button6_Click(ByVal sender As Object, ByVal e As
[Link]) Handles [Link]
Try
Str =
[Link]("connect").ConnectionString
con = New OleDbConnection(Str)
[Link]()
com = New OleDbCommand("insert into Address values('" &
[Link] & "','" & [Link] & "','" & [Link] & "','" &
[Link] & "','" & [Link] & "','" & [Link] &
"','" & [Link] & "','" & [Link] & "')", con)
[Link]()
Session("cid") = [Link]
Session("PID") = [Link]
[Link]("[Link]")
Catch ex As Exception
[Link] = [Link]
End Try
End Sub

Protected Sub Page_Load(ByVal sender As Object, ByVal e As

[Link]) Handles [Link]
[Link] = Session("PID").ToString()
[Link] = Session("PNAME").ToString()
[Link] = Session("CNAME").ToString()
[Link] = Session("MNAME").ToString()
[Link]()
CusID()
End Sub
End Class

[Link]

Imports [Link]
Imports [Link]
Partial Class Paypal
Inherits [Link]
Dim _oledbcon As OleDbConnection
Dim _oledbcom As OleDbCommand
Dim _oledbdr As OleDbDataReader
Dim sql As String
Protected Sub Button6_Click(ByVal sender As Object, ByVal e As
[Link]) Handles [Link]
Try
Dim str As String
 str =
[Link]("connect").ConnectionString
_oledbcon = New OleDbConnection(str)
_oledbcon.Open()
_oledbcom = New OleDbCommand("insert into Paypal values('" &
[Link] & "','" & [Link] & "','" & [Link] &
"','" & [Link] & "','" & [Link] & "','" &
[Link] & "','" & [Link] & "','" & [Link] & "','" &
[Link] & "')", _oledbcon)
_oledbcom.ExecuteNonQuery()
[Link] = "Payment Transaction Completed Successfully"

Catch ex As Exception
[Link] = [Link]
End Try
End Sub

Protected Sub Page_Load(ByVal sender As Object, ByVal e As

[Link]) Handles [Link]
[Link] = Session("cid").ToString()
[Link] = Session("pid").ToString()
'[Link] = Session["Cname"].ToString();
' [Link] = Session["Mname"].ToString();
[Link] = [Link]()
[Link] = [Link]()
Dim str As String
str =
[Link]("connect").ConnectionString
_oledbcon = New OleDbConnection(str)
_oledbcon.Open()
_oledbcom = New OleDbCommand("select * from NewProduct where
ProductID='" & Session("Pid").ToString() & "'", _oledbcon)
_oledbdr = _oledbcom.ExecuteReader()
_oledbdr.Read()
[Link] = _oledbdr.GetValue(4)
End Sub
End Class

[Link]

Imports [Link]
Imports [Link]
Partial Class ViewCat
Inherits [Link]
Dim con As OleDbConnection
Dim da As OleDbDataAdapter
Dim str
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
[Link]) Handles [Link]
Str =
[Link]("Connect").ConnectionString
con = New OleDbConnection(Str)
[Link]()
da = New OleDbDataAdapter("Select * from NewProduct where
ProductCode='" & [Link]("id") & "'", con)
Dim ds As New DataSet()
 [Link](ds)
[Link] = ds
[Link]()
End Sub
End Class

[Link]

Imports [Link]
Imports [Link]
Partial Class ViewCat1
Inherits [Link]
Dim con As OleDbConnection
Dim da As OleDbDataAdapter
Dim str
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
[Link]) Handles [Link]
Str =
[Link]("Connect").ConnectionString
con = New OleDbConnection(Str)
[Link]()
da = New OleDbDataAdapter("Select * from NewProduct where
ProductCode='" & [Link]("id") & "'", con)
Dim ds As New DataSet()
[Link](ds)
[Link] = ds
[Link]()
End Sub
End Class
8. SYSTEM DESIGN

8.1 System Flow Diagram

ONLINE
USER SHOPPING PURCHASER
8.2 Data Flow Diagram

A Data Flow Diagram (DFD) is a graphical representation of the "flow" of data

through an [Link] System. A data
flow diagram can also be used for the visualization of Data Processing. It is common
practice for a designer to draw a context-level DFD first which shows the interaction
between the system and outside entities. This context-level DFD is then "exploded" to
show more detail of the system being modeled.
A DFD represents flow of data through a system. Data flow diagrams are
commonly used during problem analysis. It views a system as a function that transforms
the input into desired output. A DFD shows movement of data through the different
transformations or processes in the system.
Dataflow diagrams can be used to provide the end user with a physical idea of
where the data they input ultimately has an effect upon the structure of the whole system
from order to dispatch to restock how any system is developed can be determined through
a dataflow diagram. The appropriate register saved in database and maintained by
appropriate authorities.
Data Flow Diagram Notation
.
Function

File/Database

Input/output

Flow
 LEVEL 0

Input Output
Admin/User
Lev Database
System
 LEVEL 1
Enter the site

Authenticate
User

Check whether Display errors

Admin or customer

Customer Admin

View
View product Buy product Add ,delete,
view &update
product
 Transaction Customer details
details
 8.3 INPUT DESIGN

HOME PAGE :

LOGIN PAGE:
REGISTER PAGE:
CUSTOMER VIEW

PRODUCTS:
 HANDBAGS

BUY PRODUCT:

PAYPAL DETAILS:
TRANSACTION PAGE:
BLOG:
ADMIN VIEW:

ADD PRODUCT:
DELETE PRODUCT:

UPDATE PRODUCT:
PAYMENT DETAILS:

BOOKING CUSTOMER DETAILS:

 9. SYSTEM TESTING

Objective of Testing

Testing, which consumes a considerable amount of the development time, is

essential in improving the reliability of the system and in identifying further refinements

to the system. Testing allows detection of design faults, if any, which can be rectified.

The first test of a system is to see whether it produces the correct output. Proper choice of

test data is as important as the test itself in this phase of testing. If the test data given as

input are not valid are representative of the data to be provided then the user suspects the

reliability of the output.

Test data may be artificial (created solely for test purpose) or live (representing

actual data that the user will provide). Properly created data should provide all

combination of values and formats and make it possible to test all logical paths that the

system can take. These data should take care of all analysis like worst-case analysis, best-

case analysis, etc. unlike live data, which are biased toward typical values artificial data

provide extreme values for testing the limits of the system.

 TESTING PLAN

Code testing and specification testing

Code testing and specification testing are the two general strategies used for

testing software. In code testing, the logic of the program is examined i.e., every

instruction in the program is executed using test cases. Although code testing seems ideal

for testing software, it fails to uncover all the software errors. Moreover this test does not

check whether the code meets all its specifications. For this reason the specification test

is carried out.

In specification testing, the specifications stating what the program should do and

how it should perform under various conditions are examined. To carry out this test, test

cases are developed for each condition or combination of conditions and submitted for

processing. The result of the processing is analyzed to determine whether the program

performs according to its specified requirements.

Levels of Testing

Whichever testing strategy is followed, both unit and system testing needs to be

performed.

Unit Testing:

In unit testing, each module of the software is tested independently to locate

errors in them. This ensures that the module functions properly as a unit. This enables the

tester to look out for errors in the coding and logic of that particular alone. The following
steps are carried out to ensure the validity of each module. The module interface is tested

to ensure that information flows properly into and out of the program under test.

The local data structures are examined to ensure that the data stored temporarily

or permanently maintain their integrity. Boundary conditions are tested to ensure that the

module operates properly at the boundaries. All the independent logical paths that the

program takes are exercised to ensure that all statements in a module have been tested.

All error-handing paths are also tested.

Unit testing focuses on verification and validations effort on the smallest unit of

software design (i.e.) the module.

Integrated Testing

The objective of the integrated testing is to take all the unit tested modules and

combine them into a single, integrated whole and test this resultant product. This testing

enables the tester to ensure that the main model has been designed as dictated by the

software specifications. In this project all unit tested modules are combined and tested

whether perfectly integrated or not using the concept of test driver and stubs concept in a

top down integration.

System Testing

Implementing software testing in a structured manner involves the preparation of

well-designed test plans and test cases for checking the functionality of the software.

Though mechanisms like automation of test cases for increasing the efficiency of testing

are available that critical success or success factors of an effective testing lies the test

plan and test case design to meet the objective of testing.

Recovery testing:

The recovery testing is a system testing that forces the software to fail in a variety

of ways and verifies that recovery is properly performed. (While running the software, if

there is no proper connection to the back end, error message will be fired and on

debugging this error could be detected and rectified).

 10. SYSTEM IMPLEMENTATION

IIS (Internet Information Server)

IIS is a group of Internet server (web or HTTP, FTP and Gopher) and other
capabilities for Microsoft Windows NT server operating system. IIS is Microsoft bid to
dominate the Internet server market that is also addressed by Netscape, Sun
Microsystems and other. With IIS, Microsoft includes a set of programs for building and
administrating web site, a search engine and support for writing web based applications
that access database. Microsoft points out that IIS is a tightly integrated with the
Windows NT server with a number of ways, resulting in faster web page services.
A typical company that buys IIS can create pages for web sites using Microsoft
Front Page product (with its WYSIWYG user interface). Web developers can use
Microsoft Active server pages (ASP) technology, which means that applications
including Active X control can be embedded web pages that modify the content sent back
to users. Developers can also write programs that filter request and get the correct web
pages for different users by using Microsoft ISAPI interface. ASP’s and ISAPI programs
run more efficiently that common gateway interface (CGI) and server side interface (SSI)
programs, for current technologies.
Microsoft includes special capabilities for server administrators designed to
appeal to Internet service providers (ISP’S). It includes a single window (or “console”)
from which all services and users can be administrated. It’s designed to be easy to add
components as “snap-ins” that you didn’t initially install. Individual customers can
customizes the administrative windows for access,
IIS includes security features and promises that is easy to install. It works closely
with the Microsoft Transaction server to access databases and provides control at the
transaction level. It also work with Microsoft‘s NET show in the delivery of streaming
audio and video, delayed or live. Internet Information Server 4.0 and windows NT server
4.0 provides the best platform for developing your website.
Microsoft Internet Information server (IIS) is the only World Wide Web server
that is tightly integrated with the Microsoft Windows NT server operating system and is
designed to deliver the wide range of internet and intranet server capabilities. By
optimizing around the Windows NT server platform, internet information server delivers
high performance excellent security ease of management and is up and running in
minutes. It serves as best platform for both integrating with existing solutions and for
delivering a new generation of web applications.
Microsoft Internet Information server has established a reputation for speed, ease
of operation, and unparallel integration with Windows NT server. IIS 4.0 makes I even
easier to create rich and dynamic content and to build server based web applications and,
because it is integrated with windows NT server, you can have a website up and running
in minutes. IIS 4.0 is an upgrade to IIS 3.0 and includes the following functionalities:
Active server page (ASP) is an open, compile free application environment that
allows organization to combine HTML, scripts and Active X sever components to easily
build powerful web based applications. Active server pages include native support for
VB script and J script. Active server page will enable many more people to create server
side web application for the first time.
Microsoft Index Server is an integrated search engine that provides full text
indexing and querying of documents in any format. It includes built in support for
HTML, text, and Microsoft office documents. Index Server enables users to quickly
locate specific information on their Intranet or Internet sites.
Microsoft Transaction Server is a component-based transaction processing system
for developing deploying and managing high performance, scalable, and robust
enterprise, Internet, and intranet server application- programming model for developing
distributed component-based applications. Microsoft News Server for IIS 4.0 uses
Network News Transport Protocol (NNTP) command to define the communication
between hosts.
 11. SYSTEM MAINTENANCE

The objectives of this maintenance work are to make sure that the system gets
into work all time without any bug. Provision must be for environmental changes which
may affect the computer or software system. This is called the maintenance of the system.
Nowadays there is the rapid change in the software world. Due to this rapid change, the
system should be capable of adapting these changes. In our project the process can be
added without affecting other parts of the system.

Maintenance plays a vital role. The system liable to accept any modification
after its implementation. This system has been designed to favor all new changes. Doing
this will not affect the system’s performance or its accuracy.

[Link]
 The central concept of the application is to allow the customer to shop virtually using
the Internet and allow customers to buy the items and articles of their desire from the store.
Although there are numerous advantages of shopping online, to the society as well as
individuals, such as 24-hr access and absence of vendors, some negative concerns of online
shopping can be reduced by efforts of web makers. In order to attract more online customers,
Web vendors need to gain trust from consumers by signaling privacy and security of their sites,
such as by using third-party seal approval, and must allow consumers to use interactive tools
such as 3D technology, RA and CM that will facilitate users in making their purchase
decisions.

Online shopping is a different experience and you can make the shopping creative over
the internet as you get used to it. There can be lot of apprehensions about online shopping
when you get into it for the first time. Remember that if you stick to the basics, online shopping
become more enjoyable and easier than real-world shopping.

In future we suggest to add some animations in our system in order to make our
system to be more attractive.
1. E-buy will require more secure encryption to provide more secure transaction.

2. Customer should be given with reward point for frequent purchase.

3. Live support should be enabled.

[Link] Enhancement
 This system is very flexible and changes can be made without affecting the existing
system according to the future requirements. The system is designed in such a way that
any changes can be made to the existing module or we can add any new module to the
system in future, without affecting the present one.

The System design is in such a way so that any new development can make any
changes in the future according to the requirements in future. The system can be
upgraded easily to the newer version of the software.

This project can be further developed by

 Adding separate Roles and Authentication.

 This project can also be done in online through [Link]

 We can also add separate module for Visitors

 We can also add Online voting regarding call center query

 News and Events updates

 We can also add online call center training.

 Forums can also be implemented

 Online Exam schedule information

 Career
 [Link]

Books:

 COMPUTER NETWORKS (Third Edition) by Andrew S Tanenbaum.

 SOFTWARE ENGINEERING By Roger.S. Pressman, 2nd Edition

 SQL FOR PROFESSIONALS By Jain, First Eition

 VISUAL [Link] Black Book By Evangeleous Petereous, First Edition

 [Link] Professional By Wrox Publications , 2nd Edition

 MSDN 2002 By Microsoft, First Edition

Website References:

 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 World Wide Web Consortium WWW site , ([Link]
 [Link]