Shopping Cart
Shopping Cart
Shopping Cart
INTRODUCTION
1.1 ABOUT THE PROJECT
Microsoft .NET is a set of Microsoft software technologies for rapidly
building and
code safety verification, compilation, and other system services these are all
run on CLR.
Security.
Robustness.
Productivity.
Performance.
Security
The runtime enforces code access security. The security features of the runtime
thus enable legitimate Internet-deployed software to be exceptionally featuring rich. With
regards to security, managed components are awarded varying degrees of trust, depending
on a number of factors that include their origin to perform file-access operations, registryaccess operations, or other sensitive functions.
Robustness
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 managed environment of the runtime
eliminates many common software issues.
Productivity
The runtime also accelerates developer productivity. For example, programmers
can write applications in their development language of choice, yet take full advantage of
the runtime, the class library, and components written in other languages by other
developers
Performance
The runtime is designed to enhance performance. Although the common language
runtime provides many standard runtime services, managed code is never interpreted. A
feature called just-in-time (JIT) compiling enables all managed code to run in the native
machine language of the system on which it is executing. Finally, the runtime can be
hosted by high-performance, server-side applications, such as Microsoft SQL Server
and Internet Information Services (IIS).
Managed Code
The code that targets .NET, and which contains certain extra Information metadata - to describe itself. Both managed and unmanaged code can run in the
runtime, only managed code contains the information that allows the CLR to guarantee,
for instance, safe execution and interoperability
Interoperability
ADO.NET applications can take advantage of the flexibility and broad acceptance
of XML. Because XML is the format for transmitting datasets across the network, any
component that can read the XML format can process data. The receiving component
need not be an ADO.NET component.
The transmitting component can simply transmit the dataset to its destination
without regard to how the receiving component is implemented. The destination
component might be a Visual Studio application or any other application implemented
with any tool whatsoever.
Maintainability
In the life of a deployed system, modest changes are possible, but substantial,
Architectural changes are rarely attempted because they are so difficult.
As the performance load on a deployed application server grows, system resources
can become scarce and response time or throughput can suffer. Faced with this problem,
software architects can choose to divide the server's business-logic process architects can
choose to divide the server's business-logic processing and user-interface processing onto
separate tiers on separate machines.
In effect, the application server tier is replaced with two tiers, alleviating the
shortage of system resources. If the original application is implemented in ADO.NET
using datasets, this transformation is made easier.
ADO.NET data components in Visual Studio encapsulate data access functionality in
various ways that help the program more quickly and with fewer mistake
Scalability
ADO.NET accommodates scalability by encouraging programmers to conserve
limited resources. Any ADO.NET application employs disconnected access to data; it
does not retain database locks or active database connections for long durations.
Visual Studio
Visual Studio is a complete set of development tools for building ASP Web
applications, XML Web services, desktop applications, and mobile applications. In
addition to building high-performing desktop applications, Visual Studio's powerful
component-based development tools.
Visual Basic .NET, Visual C++ .NET, and Visual C# .NET all use the same
integrated development environment (IDE), which allows them to share tools and
facilitates in the creation of mixed-language solutions. In addition, these languages
leverage the functionality of the .NET Framework and simplify the development of ASP
Web applications and XML Web services
XML Support
Extensible Markup Language (XML) provides a method for describing
structured data. XML is a subset of SGML that is optimized for delivery over the Web.
The World Wide Web Consortium (W3C) defines XML standards so that structured data
will be uniform and independent of applications.
Visual Basic .NET
Visual Basic .NET, the latest version of visual basic, includes many new features.
The Visual Basic supports interfaces but not implementation inheritance.
RAM
: 42GB
: Visual Basic.Net
Back end
: SQL Server
2. SYSTEM STUDY
8
2.1EXISTING SYSTEM
In existing system all the data of products and the prices are entered
manually, so is takes more time to retrieve details like product details, customer
details and the total amount paid. Furthermore, it is time consuming to retrieve
one specific customer information and the complaints or suggestions provided by
them.
2.1.1 DRAWBACKS
Retrieval of information takes more time
Redundancy will be more
While entering the data manually, some data might miss out
2.2PROPOSED SYSTEM
Proposed system is an automated Shopping cart. Through our software
user can add product details, customer details and update information and edit
information within short time. All the manual difficulties in managing a shopping
cart have been removed by implementing computerization.
2.2.1 FEATURES
input data into the system and to retrieve data from the system. The login screen is
loaded and verifies the user authentication. If user Id and password are valid then the
users enter into the project.
The input forms involved in this project are:
1) Buyer Registration form
This form is used to enter the customer details such as customer id,
customer name, address and phone number.
2) Product form
This form is used to enter the product details such as product id, product
name, quantity and price.
3) Stock form
This form is used to enter the new stock updated date.
4) Selection form
This form is used to enter the products selected by the customer. The
number of quantity is also entered.
5) Acknowledgement form
10
treated and
organizational resource and as an integrated whole. The primary objectives are fast
response time to inquire more information at low cost, control redundancy, clarity and
ease or use accuracy and fast recovery.
11
12
13
information is provided to the user like you must enter use rid and password. Here the
inputs given by the user are validated.
Acceptance Testing
Accepting test is performed on a collection of business functions in a production
environment and after the completion of functional testing. This is the final stage in the
testing process before the system is accepted for operational use. This testing is should be
done with original data and with the presence of the users. This test confirms the system
ready for production.
Code Testing
It describes the degree to which source code of the program has been tested. The
target software is built with special options or libraries and run under a special
environment such that every function is exercised in the program are mapped back to the
function points in the source code.
14
15
5. CONCLUSION
We understand the importance of planning and designing as a part of shopping
cart. The concept of peer-reviews helped to rectify the problems as and when they
occurred and also helped us to get some valuable suggestions that were incorporated by
us. Developing the project has helped us to gain some experienced on real time
development procedures.
All the objectives that had been charted out in the initial phases were achieved
successfully. System satisfies all the requirements for which the company developed the
system. System has strong security.
System is fully GUI based. It is easy operate and user friendly. Platform includes
the inbuilt backup and recovery facility. Working on the project was a good experience.
Working together in teams helped us to communicate better.
16
BIBLIOGRAPHY
BOOK REFERENCES
1. Roger S. Pressman, Software Engineering: A Practioners Approach, McGraw-Hill
International Edition, Fifth edition, 2001.
2. Designing Microsoft VB.NET Applications TataMcGrawHill Edtion, 2001.
3. Chris Goodge, John Kauffman,Microsoft Visual Basic.NET Programmers Cookbook
TataMcGrawHill Edtions, 2002.
4.http://www.nytimes.com/2010/04/11/books/review/Schuessler-t.html?pagewanted=all
WEB REFERENCES
1.
2.
3.
4.
5.
6.
https://elsevise/default.asp
http://www.aptaracorp.com/publishing-services
http://www.infinitypublishing.com/
http://www.lulu.com/
http://www.authorsonline.co.uk/
http://www.samhainpublishing.com/
APPENDIX
A.DATA FLOW DIAGRAM
17
Provides
Acknowledgement
Customer
Register
Admin
View
Customer details
Purchase
Product
Billing
Update
Stock
B.TABLE STRUCTURE
1)Table Name: Buyer Registration
Primary Key: CID
18
Field Name
Data Type
Size
Description
PID
Field Name
Pname
CID
Qty
Cname
Price
Addr
Nvarchar
Data Type
Nvarchar
Nvarchar
Float
Nvarchar
Float
Nvarchar
10
Size
20
10
20
20
20
30
Phno
Bigint
10
Phone number
Rdate
Date
__
Date of Registration
19
Field Name
Data Type
Size
Description
PID
Nvarchar
10
Pname
Nvarchar
20
Name of Product
Uqty
Float
20
Price
Float
20
Udate
Date
____
Updated date
20
Field
Field Name
Name
Data
DataType
Type
Size
Size
Description
Description
CID
CID
nvarchar
Nvarchar
10
10
Customer
CustomerIdentification
IdentificationNumber
Number
PID
Cname
nvarchar
Nvarchar
10
20
Product
Name ofIdentification
the CustomerNumber
Pname
PID
nvarchar
Nvarchar
10
10
Name
of Identification
Product
Product
Number
qty
Pname
float
Nvarchar
20
10
Quantity
the Product
Name ofof
Product
Price
Comp
float
Nvarchar
20
100
Price
of the Product
Suggestions/
Complaints
Tot
float
20
Total
Bdate
date
____
Billing date
21
C.SAMPLE CODING
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.IO
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Public Class frmBilling
Dim available As Boolean
Public selRow As New DataGridViewRow
22
Dim a As Integer = 0
Dim con As New SqlConnection("Data Source=.\SQLEXPRESS;Initial
Catalog=Geeva;Integrated Security=True")
'Dim cmd As New SqlCommand
Dim qry, qry1 As String
Dim da As New SqlDataAdapter
Dim ds As DataSet
Dim dbind As New BindingSource
Dim i As Integer
Dim reader As SqlDataReader
Dim com As SqlCommand
Dim adp As SqlDataAdapter
23
End Sub
Private Sub frmBilling_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
'If
ComboBox1.Items.Clear()
qry = "select Productname from tblInventoryDetails1"
com = New SqlCommand(qry, con)
adp = New SqlDataAdapter(com)
ds = New DataSet
adp.Fill(ds, "tblInventoryDetails1")
i = ds.Tables("tblInventoryDetails1").Rows.Count
Dim j As Integer
For j = 0 To i - 1
ComboBox1.Items.Add(ds.Tables("tblInventoryDetails1").Rows(j)(0))
Next
'DropDownList1.Text = ""
'TextBox2.Text = "0"
TextBox5.Text = ""
TextBox3.Text = ""
'TextBox4.Text = "0"
'End If
LoadGridViewHeaders()
available = True
24
End Subs
D.SAMPLE INPUT
25
26
27
28
29
30
E. SAMPLE OUTPUT
31
32
33
34
35
36
37