search for books and compare prices
Tables of Contents for Beginning Asp.Net E-Commerce
Chapter/Section Title
Page #
Page Count
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