Beginning Asp. Net E-Commerce With Visual Basic .Net and Visual Studio .Net

by Darie, Cristian/Watson, Karli

• ISBN13: 9781861007506
• ISBN10: 1861007507
• Format: Trade Paper
• Copyright: 2002-12-17
• Publisher: Springer-Verlag New York Inc

Summary

Beginning ASP.NET E-Commerce shows you how to build a full e-commerce web site. Guiding you through every step of the design and build process, this book will have you building high quality, extendable e-commerce web sites quickly and easily. To get the site up and running quickly, we build in phases. The first puts your site live on the web, using an online service to handle the shopping cart, checkout, and payment. The second adds an ASP.NET shopping basket and checkout. Finally we'll add our own order processing system - complete with credit card processing, data storage, and order tracking. Book jacket.

Table of Contents

Introduction	1	(1)
What Does This Book Cover?	2	(3)
Phase One:	2	(1)
Starting an E-Commerce site	2	(1)
Laying Out the Foundations	2	(1)
The Product Catalog: Part I	2	(1)
The Product Catalog: Adding Content	3	(1)
Searching the Catalog	3	(1)
Receiving Payments using PayPal	3	(1)
Catalog Administration	3	(1)
Phase Two:	3	(1)
The Shopping Basket	3	(1)
Dealing with Customer Orders	4	(1)
Phase Three:	4	(1)
Customer Details	4	(1)
Order Pipeline	4	(1)
Implementing the Pipeline	4	(1)
Credit Card Transactions	4	(1)
The End	5	(1)
Who Is This Book For?	5	(1)
What You Need to Use This Book	5	(1)
Style Conventions	5	(1)
Customer Support and Feedback	6	(5)
Source Code and Updates	6	(1)
Errata	7	(1)
Technical Support	7	(1)
p2p.wrox.com	8	(3)
Starting an E-Commerce Site	11	(10)
Why Go E-Commerce?	11	(2)
Get More Customers	12	(1)
Make Customers Spend More	12	(1)
Convincing Them to Come Back	13	(1)
Reduce the Costs of Fulfilling Orders	13	(1)
Let's Make Money	13	(1)
Risks and Threats	14	(1)
Designing for Business	15	(3)
Phase I - Getting a Site Up	16	(1)
Phase II - Our Own Shopping Cart	16	(1)
Phase III - Processing Orders	17	(1)
The Wrox Joke Shop	18	(1)
Summary	18	(3)
Laying Out the Foundations	21	(34)
Designing for Growth	22	(6)
So What Do We Want?	22	(1)
The Magic of Three-Layered Architecture	23	(1)
A Simple Scenario	24	(2)
What's in a Number?	26	(1)
The Right Logic for the Right Tier	26	(1)
A Three-Tier Architecture for WroxJokeShop	27	(1)
Why Not Use More Tiers?	28	(1)
Technologies and Tools	28	(5)
ASP.NET	29	(1)
The Code Behind the Page	29	(1)
Web Forms and Web User Controls	30	(1)
ASP.NET and the Three-Tier Architecture	31	(1)
VB.NET	31	(1)
Visual Studio .NET	32	(1)
SQL Server	32	(1)
SQL Server and the Three-Tier Architecture	33	(1)
Coding Standards	33	(1)
Creating the Visual Studio .NET Project	34	(5)
Implementing the Site Skeleton	39	(12)
Building the First Page	41	(6)
Adding the Header to the Main Page	47	(4)
Creating the SQL Server Database	51	(2)
Code Download	53	(1)
Summary	53	(2)
Creating the Product Catalog	55	(42)
Showing the Visitor What we Have	55	(6)
What Does a Product Catalog Look Like?	56	(1)
Previewing the Product Catalog	57	(2)
What we'll Do in This Chapter	59	(2)
A Place to Store the Data	61	(10)
The Theory: What Makes up a Data Table	61	(1)
Previewing the Department Table	62	(1)
Primary Keys	63	(1)
Unique Columns	64	(1)
Columns and Data Types	64	(2)
Nullable Columns and Default Values	66	(1)
Identity Columns	67	(1)
Indexes	67	(1)
Creating the Table	68	(3)
The Data Tier	71	(5)
The Theory: Speaking with the Database	71	(3)
Creating the Stored Procedure	74	(1)
How to Ask for a List of Department Names	74	(1)
Saving the Query as a Stored Procedure	75	(1)
The Business Tier	76	(9)
The Theory: How to Access SQL Server from VB.NET	77	(1)
Opening a Database Connection	77	(2)
Issuing Commands Using the Connection	79	(2)
Closing the Connection	81	(1)
Implementing the Business-Tier Functionality	81	(1)
Adding the Catalog Class to the Solution	81	(1)
Storing the Connection String in a Central Location	82	(1)
Adding the GetDepartments() method to the Catalog Class	83	(2)
The Presentation Tier	85	(10)
Preparing the Field: Setting the Styles	86	(2)
Creating the DepartmentsList Web User Control	88	(7)
Code Download	95	(1)
Summary	95	(2)
The Product Catalog: Adding Content	97	(62)
What is the New Functionality?	97	(5)
A New Place to Store the Data	102	(15)
The Theory: What Makes a Relational Database?	102	(1)
Relational Data and Table Relationships	103	(2)
The Foreign Key Constraint	105	(1)
Implementing Table Relationships	106	(1)
Departments, Categories, and the One-to-Many Relationship	106	(4)
Adding Categories Linked to Existing Departments	110	(1)
Categories, Products, and the Many-to-Many Relationship	110	(5)
Database Diagrams	115	(2)
The Data Tier	117	(8)
The Theory: Where to Join?	117	(1)
Where to Use Where	118	(1)
Where to Use Join	118	(1)
How to Use Join	119	(2)
The Stored Procedures	121	(1)
Input and Output Stored Procedure Parameters	121	(1)
Implementing the Stored Procedures	122	(3)
The Business Tier	125	(8)
The Theory: Working with Stored Procedure Parameters	125	(3)
Completing the Catalog Class	128	(5)
The Presentation Tier	133	(20)
Displaying Data about the Selected Department	133	(5)
Displaying the List of Categories	138	(7)
Displaying the Products	145	(5)
Displaying Contents on the Main Web Page	150	(3)
Custom Error Page	153	(2)
Summary	155	(4)
Searching the Catalog	159	(20)
What Kind of Search do we Want?	159	(2)
The Data Tier	161	(5)
The Theory: Teaching the Database to Search Itself	161	(1)
Dynamically Creating the Query in the Business Tier	162	(1)
Dynamically Creating the Query in the Data Tier	163	(1)
Not Using Dynamically Generated Queries	164	(1)
Implementing the SearchCatalog Stored Procedure	165	(1)
The Business Tier	166	(3)
The Presentation Tier	169	(7)
The SearchBox User Control	170	(2)
The SearchResults User Control	172	(4)
Summary	176	(3)
Receiving Payments using PayPal	179	(14)
Internet Payment Service Providers	180	(1)
Learning how to Use PayPal	181	(9)
Creating a New PayPal Account	181	(2)
Integrating PayPal into our Web Site	183	(5)
Letting PayPal Calculate Shipping Costs	188	(1)
The PayPal Single Item Purchases	189	(1)
Summary	190	(3)
Catalog Administration	193	(70)
So Where Do We Start?	194	(1)
Authenticating Administrators	195	(8)
Setting up the Catalog Administration Page	203	(5)
Administering Departments	208	(16)
The DepartmentsAdmin User Control	209	(10)
Middle-Tier Methods for Departments Administration	219	(3)
Stored Procedures for Departments Administration	222	(1)
Testing the DepartmentsAdmin Web User Control	223	(1)
Administering Categories	224	(13)
The CategoriesAdmin Web User Control	225	(8)
Middle-Tier Methods for Categories Administration	233	(2)
Stored Procedures for Categories Administration	235	(1)
Testing the CategoriesAdmin Web User Control	236	(1)
Administering Products	237	(17)
The ProductsAdmin Web User Control	238	(10)
Middle-Tier Methods for Products Administration	248	(3)
Stored Procedures for Products Administration	251	(3)
Testing the ProductsAdmin Web User Control	254	(1)
Viewing Product Details and Deleting Products	254	(7)
The ProductDetailsAdmin Web User Control	255	(4)
Middle-Tier Methods for Product Details Admin	259	(1)
Stored Procedures for Product Details Admin	260	(1)
Testing the ProductDetailsAdmin Web User Control	260	(1)
Summary	261	(2)
The Shopping Basket	263	(32)
Designing the Shopping Cart	264	(1)
The Database	265	(1)
A Place to Store Shopping Cart Items	265	(5)
The ShoppingCart Table	265	(1)
The Stored Procedures	266	(1)
AddProductToCart	267	(1)
UpdateCartItem	268	(1)
RemoveProductFromCart	269	(1)
GetShoppingCartProducts	269	(1)
GetTotalAmount	269	(1)
The Business Layer	270	(6)
Generating Shopping Cart IDs	270	(3)
Implementing the Methods	273	(3)
The User Interface	276	(16)
The Add to Cart Buttons	277	(2)
The View Cart Button	279	(1)
Modifying default.aspx to Load ShoppingCart	280	(1)
Creating the ShoppingCart Web User Control	281	(4)
Adding `Continue Shopping' Functionality	285	(3)
Allowing the Visitor to Change the Quantity	288	(1)
EditCommand	289	(1)
CancelCommand	289	(1)
UpdateCommand	290	(1)
DeleteCommand	290	(1)
Testing the Shopping Cart	291	(1)
The Next Steps	291	(1)
Summary	292	(3)
Dealing with Customer Orders	295	(50)
Implementing an Order Placing System	295	(10)
Storing Orders in the Database	296	(1)
The Tables	297	(3)
The Stored Procedures	300	(2)
Updating the Business Layer	302	(1)
Implementing the User Interface	302	(1)
The Place Order Button	302	(3)
Administering Orders	305	(38)
The OrdersAdminPage Web Form	305	(1)
Creating the Form	306	(3)
Implementing Security	309	(1)
Having a Link to OrdersAdminPage on the First Page	309	(1)
The OrdersAdmin Web User Control	310	(1)
The Database Stored Procedures	311	(2)
The Busines Layer Methods	313	(2)
The Presentation Tier: OrdersAdmin.ascx	315	(10)
The OrderDetailsAdmin Web User Control	325	(1)
The Database Stored Procedures	326	(2)
The Business Layer	328	(5)
The Presentation Tier: OrderDetailsAdmin.ascx	333	(10)
Summary	343	(2)
Customer Details	345	(50)
Customer Accounts	346	(41)
WroxJokeShop Customer Account Scheme	346	(1)
The Customer Table	347	(1)
The SecurityLib Class Library	348	(1)
Hashing	348	(3)
Encryption	351	(16)
The Customer Login Page	367	(6)
The Customer Registration Page	373	(5)
Customer Detail Modification Pages	378	(1)
The Checkout Page	379	(8)
Secure Connections	387	(4)
Obtaining a SSL Certificate from VeriSign	388	(1)
Enforcing SSL Connections	388	(2)
Modifying Redirections to Use SSL Connections	390	(1)
Summary	391	(4)
Order Pipeline	395	(34)
What is an Order Pipeline?	396	(1)
The WroxJokeShop Order Pipeline	396	(31)
Building the Pipeline	397	(3)
Groundwork	400	(1)
The Audit Table	400	(1)
The Orders Table	400	(1)
The CreateCustomerOrder Stored Procedure	401	(1)
WroxJokeShop Modification	402	(1)
Utility Classes	403	(7)
The OrderProcesor Class	410	(13)
Adding More Functionality to OrderProcessor	423	(4)
Summary	427	(2)
Implementing the Pipeline	429	(40)
The Pipeline Sections	429	(1)
PSinitialNotification	430	(2)
PSCheckFunds	432	(1)
PSCheckStock	433	(1)
PSStockOK	434	(1)
PSTakePayment	435	(1)
PSShipGoods	436	(1)
PSShipOK	437	(1)
PSFinalNotification	438	(6)
WroxJokeShop Modifications	444	(22)
The Checkout.aspx Web Page	445	(1)
Modifications to OrdersAdminPage.aspx	446	(1)
The Status Table	447	(1)
Stored Procedures	447	(3)
OrderManager Modifications	450	(4)
OrdersAdmin.ascx Modifications	454	(4)
OrderDetailsAdmin.ascx Modifications	458	(5)
Testing the Order Administration Page	463	(3)
Summary	466	(3)
Credit Card Transactions	469	(26)
Credit Card Transaction Fundamentals	469	(3)
Credit Card Payment Gateways	470	(1)
DataCash	471	(1)
Credit Card Transactions	471	(1)
Implementing Credit Card Processing	472	(20)
The DtaCash XML API	472	(1)
Pre Request	472	(1)
Pre Response	473	(1)
Fulfil Request	474	(1)
Fulfil Response	475	(1)
Exchanging XML Data	475	(12)
Integration with WroxJokeShop	487	(1)
OrderProcessor Configuration Modification	487	(2)
Pipeline Modification	489	(3)
Testing	492	(1)
Going Live	492	(1)
Summary	492	(3)
The End	495	(4)
Join Our Community	495	(1)
Stake Out IBuySpy	495	(1)
Read More	496	(1)
Server Controls	496	(1)
Databases	496	(1)
ASP.NET	496	(1)
Security	496	(1)
Building Web Sites	496	(3)
Appendix A: Installing IIS, MSDE, OSQL, and Creating Class Libraries	499
Installing the IIS 5.x Web Server	499	(6)
Working with IIS	503	(1)
The Microsoft Management Console (MMC)	503	(1)
Testing your Installation	504	(1)
Identifying your Web Server's Name	504	(1)
MSDE: Introduction	505	(4)
Obtaining and Installing MSDE	506	(1)
Using MSDE	507	(2)
Running Scripts with osql	509	(1)
Creating Class Libraries	509
Indexes	1	(1)
General Index	1	(520)
Wrox Joke Shop Index	521