- •About the Authors
- •Contents at a Glance
- •Contents
- •Introduction
- •Goal of the Book
- •How to Use this Book
- •Introduction to the .NET Framework
- •Common Language Runtime (CLR)
- •Class Library
- •Assembly
- •Versioning
- •Exceptions
- •Threads
- •Delegates
- •Summary
- •Introduction to C#
- •Variables
- •Initializing Variables
- •Variable Modifiers
- •Variable Data Types
- •Types of Variables
- •Variable Scope
- •Types of Data Type Casting
- •Arrays
- •Strings
- •Initializing Strings
- •Working with Strings
- •Statements and Expressions
- •Types of Statements
- •Expressions
- •Summary
- •Classes
- •Declaring Classes
- •Inheritance
- •Constructors
- •Destructors
- •Methods
- •Declaring a Method
- •Calling a Method
- •Passing Parameters to Methods
- •Method Modifiers
- •Overloading a Method
- •Namespaces
- •Declaring Namespaces
- •Aliases
- •Structs
- •Enumerations
- •Interfaces
- •Writing, Compiling, and Executing
- •Writing a C# Program
- •Compiling a C# Program
- •Executing a C# Program
- •Summary
- •Arrays
- •Single-Dimensional Arrays
- •Multidimensional Arrays
- •Methods in Arrays
- •Collections
- •Creating Collections
- •Working with Collections
- •Indexers
- •Boxing and Unboxing
- •Preprocessor Directives
- •Summary
- •Attributes
- •Declaring Attributes
- •Attribute Class
- •Attribute Parameters
- •Default Attributes
- •Properties
- •Declaring Properties
- •Accessors
- •Types of Properties
- •Summary
- •Introduction to Threads
- •Creating Threads
- •Aborting Threads
- •Joining Threads
- •Suspending Threads
- •Making Threads Sleep
- •Thread States
- •Thread Priorities
- •Synchronization
- •Summary
- •Case Study
- •Project Life Cycle
- •Analyzing Requirements
- •High-Level Design
- •Primary and Foreign Keys
- •Referential Integrity
- •Normalization
- •Designing a Database
- •Low-Level Design
- •Construction
- •Integration and Testing
- •User Acceptance Testing
- •Implementation
- •Operations and Maintenance
- •Summary
- •Creating a New Project
- •Console Application
- •Windows Applications
- •Creating a Windows Application for the Customer Maintenance Project
- •Creating an Interface for Form1
- •Creating an Interface for WorkerForm
- •Creating an Interface for CustomerForm
- •Creating an Interface for ReportsForm
- •Creating an Interface for JobDetailsForm
- •Summary
- •Performing Validations
- •Identifying the Validation Mechanism
- •Using the ErrorProvider Control
- •Handling Exceptions
- •Using the try and catch Statements
- •Using the Debug and Trace Classes
- •Using the Debugging Features of Visual Studio .NET
- •Using the Task List
- •Summary
- •Creating Form1
- •Connecting WorkerForm to the Workers Table
- •Connecting CustomerForm to the tblCustomer Table
- •Connecting the JobDetails Form
- •to the tblJobDetails Table
- •Summary
- •Introduction to the Crystal Reports Designer Tool
- •Creating the Reports Form
- •Creating Crystal Reports
- •Creating the Windows Forms Viewer Control
- •Creating the Monthly Worker Report
- •Summary
- •Introduction to Deploying a Windows Application
- •Deployment Projects Available in Visual Studio .NET
- •Deployment Project Editors
- •Summary
- •Case Study
- •Project Life Cycle
- •Analyzing Requirements
- •High-Level Design
- •Low-Level Design
- •Summary
- •Populating the TreeView Control
- •Displaying Employee Codes in the TreeView Control
- •Event Handling
- •Displaying Employee Details in the ListView Control
- •Summary
- •Case Study
- •Project Life Cycle
- •Analyzing Requirements
- •High-Level Design
- •Low-Level Design
- •Summary
- •Adding the Programming Logic to the Application
- •Adding Code to the Form Load() Method
- •Adding Code to the OK Button
- •Adding Code to the Exit Button
- •Summary
- •The Created Event
- •Adding Code to the Created Event
- •Overview of XML
- •The XmlReader Class
- •The XmlWriter Class
- •Displaying Data in an XML Document
- •Displaying an Error Message in the Event Log
- •Displaying Event Entries from Event Viewer
- •Displaying Data from the Summary.xml Document in a Message Box
- •Summary
- •Airline Profile
- •Role of a Business Manager
- •Role of a Network Administrator
- •Role of a Line-of-Business Executive
- •Project Requirements
- •Creation and Deletion of User Accounts
- •Addition of Flight Details
- •Reservations
- •Cancellations
- •Query of Status
- •Confirmation of Tickets
- •Creation of Reports
- •Launch of Frequent Flier Programs
- •Summarizing the Tasks
- •Project Design
- •Database Design
- •Web Forms Design
- •Enabling Security with the Directory Structure
- •Summary
- •Getting Started with ASP.NET
- •Prerequisites for ASP.NET Applications
- •New Features in ASP.NET
- •Types of ASP.NET Applications
- •Exploring ASP.NET Web Applications
- •Introducing Web Forms
- •Web Form Server Controls
- •Configuring ASP.NET Applications
- •Configuring Security for ASP.NET Applications
- •Deploying ASP.NET Applications
- •Creating a Sample ASP.NET Application
- •Creating a New Project
- •Adding Controls to the Project
- •Coding the Application
- •Summary
- •Creating the Database Schema
- •Creating Database Tables
- •Managing Primary Keys and Relationships
- •Viewing the Database Schema
- •Designing Application Forms
- •Standardizing the Interface of the Application
- •Common Forms in the Application
- •Forms for Network Administrators
- •Forms for Business Managers
- •Forms for Line-of-Business Executives
- •Summary
- •The Default.aspx Form
- •The Logoff.aspx Form
- •The ManageUsers.aspx Form
- •The ManageDatabases.aspx Form
- •The ChangePassword.aspx Form
- •Restricting Access to Web Forms
- •The AddFl.aspx Form
- •The RequestID.aspx Form
- •The Reports.aspx Form
- •The FreqFl.aspx Form
- •Coding the Forms for LOB Executives
- •The CreateRes.aspx Form
- •The CancelRes.aspx Form
- •The QueryStat.aspx Form
- •The ConfirmRes.aspx Form
- •Summary
- •Designing the Form
- •The View New Flights Option
- •The View Ticket Status Option
- •The View Flight Status Option
- •The Confirm Reservation Option
- •Testing the Application
- •Summary
- •Locating Errors in Programs
- •Watch Window
- •Locals Window
- •Call Stack Window
- •Autos Window
- •Command Window
- •Testing the Application
- •Summary
- •Managing the Databases
- •Backing Up the SkyShark Airlines Databases
- •Exporting Data from Databases
- •Examining Database Logs
- •Scheduling Database Maintenance Tasks
- •Managing Internet Information Server
- •Configuring IIS Error Pages
- •Managing Web Server Log Files
- •Summary
- •Authentication Mechanisms
- •Securing a Web Site with IIS and ASP.NET
- •Configuring IIS Authentication
- •Configuring Authentication in ASP.NET
- •Securing SQL Server
- •Summary
- •Deployment Scenarios
- •Deployment Editors
- •Creating a Deployment Project
- •Adding the Output of SkySharkDeploy to the Deployment Project
- •Deploying the Project to a Web Server on Another Computer
- •Summary
- •Organization Profile
- •Project Requirements
- •Querying for Information about All Books
- •Querying for Information about Books Based on Criteria
- •Ordering a Book on the Web Site
- •Project Design
- •Database Design
- •Database Schema
- •Web Forms Design
- •Flowcharts for the Web Forms Modules
- •Summary
- •Introduction to ASP.NET Web Services
- •Web Service Architecture
- •Working of a Web Service
- •Technologies Used in Web Services
- •XML in a Web Service
- •WSDL in a Web Service
- •SOAP in a Web Service
- •UDDI in a Web Service
- •Web Services in the .NET Framework
- •The Default Code Generated for a Web Service
- •Testing the SampleWebService Web Service
- •Summary
- •Creating the SearchAll() Web Method
- •Creating the SrchISBN() Web Method
- •Creating the AcceptDetails() Web Method
- •Creating the GenerateOrder() Web Method
- •Testing the Web Service
- •Securing a Web Service
- •Summary
- •Creating the Web Forms for the Bookers Paradise Web Site
- •Adding Code to the Web Forms
- •Summary
- •Case Study
- •Project Life Cycle
- •Analyzing Requirements
- •High-Level Design
- •Low-Level Design
- •Summary
- •Overview of Mobile Applications
- •The Microsoft Mobile Internet Toolkit
- •Overview of WAP
- •The WAP Architecture
- •Overview of WML
- •The Mobile Web Form
- •The Design of the MobileTimeRetriever Application
- •Creating the Interface for the Mobile Web Forms
- •Adding Code to the MobileTimeRetriever Application
- •Summary
- •Creating the Forms Required for the MobileCallStatus Application
- •Creating the frmLogon Form
- •Creating the frmSelectOption Form
- •Creating the frmPending Form
- •Creating the frmUnattended Form
- •Adding Code to the Submit Button in the frmLogon Form
- •Adding Code to the Query Button in the frmSelectOption Form
- •Adding Code to the Mark checked as complete Button in the frmPending Form
- •Adding Code to the Back Button in the frmPending Form
- •Adding Code to the Accept checked call(s) Button in the frmUnattended Form
- •Adding Code to the Back Button in the frmUnattended Form
- •Summary
- •What Is COM?
- •Windows DNA
- •Microsoft Transaction Server (MTS)
- •.NET Interoperability
- •COM Interoperability
- •Messaging
- •Benefits of Message Queues
- •Limitations
- •Key Messaging Terms
- •Summary
- •Pointers
- •Declaring Pointers
- •Types of Code
- •Implementing Pointers
- •Using Pointers with Managed Code
- •Working with Pointers
- •Compiling Unsafe Code
- •Summary
- •Introduction to the Languages of Visual Studio .NET
- •Visual C# .NET
- •Visual Basic .NET
- •Visual C++ .NET
- •Overview of Visual Basic .NET
- •Abstraction
- •Encapsulation
- •Inheritance
- •Polymorphism
- •Components of Visual Basic .NET
- •Variables
- •Constants
- •Operators
- •Arrays
- •Collections
- •Procedures
- •Arguments
- •Functions
- •Adding Code to the Submit Button
- •Adding Code to the Exit Button
- •Summary
- •Introduction to Visual Studio .NET IDE
- •Menu Bar
- •Toolbars
- •Visual Studio .NET IDE Windows
- •Toolbox
- •The Task List Window
- •Managing Windows
- •Customizing Visual Studio .NET IDE
- •The Options Dialog Box
- •The Customize Dialog Box
- •Summary
- •Index
608 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE
Table 27-6 Structure of the BWOrders Table
Column Name |
Data Type |
|
|
Length |
Allow Nulls |
|
ISBNNo |
char |
|
|
|
10 |
0 |
OrderNo |
char |
|
|
|
5 |
0 |
DateOfOrder |
datetime |
|
|
|
8 |
0 |
CustomerName |
varchar |
|
|
Y |
0 |
|
|
|
|
50 |
|||
CustomerAddress1 |
varchar |
|
L |
0 |
||
CustomerAddress2 |
varchar |
F |
50 |
0 |
||
|
|
|
||||
CustomerCity |
varchar |
|
|
|
20 |
0 |
CustomerState |
A |
|
|
20 |
0 |
|
varchar |
|
|
|
|||
RequestedBy |
E |
|
|
|
20 |
0 |
varchar |
|
|
|
|||
Status |
T |
|
|
|
20 |
0 |
varcharM |
|
|||||
CreditCardType |
char |
|
|
|
10 |
0 |
CreditCardNumber |
varchar |
|
|
|
20 |
0 |
|
|
|
|
|
|
|
Similar to the Status and OrderedBy fields of the DTOrders table, the Status and RequestedBy fields of the BWOrders table store the status of delivery of the book and the details of the retailer who ordered for the book, respectively.
In addition, the BWOrders table contains the credit card information of the customer who orders for a book on the Web site of Bookers Paradise.
Database Schema
Having created the design of the tables of Bookers Paradise, Deepthoughts Publications and Black and White Publications, you need to establish relationships between the tables of the organizations. Based on these relationships, a detailed database schema is created. I will first discuss the relationships between the tables of Bookers Paradise.
Team-Fly®
PROJECT CASE STUDY AND DESIGN |
Chapter 27 |
609 |
|
|
|
|
|
The Relationships between the Tables of Bookers Paradise
The relationships between the tables of Bookers Paradise are shown in Figure 27-1.
FIGURE 27-1 Database schema for Bookers Paradise
Table 27-7 explains the relationships between the tables of Bookers Paradise shown in Figure 27-1.
Table 27-7 Relationships in the Tables of Bookers Paradise Database
Table1 |
Table2 |
Type |
Description |
BookerCustDetails |
BookersOrders |
One-to-many |
One customer can place one or |
|
|
|
more orders. However, one |
|
|
|
order can contain orders from |
|
|
|
only one customer. |
|
|
|
|
610 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE
The Relationships between the Tables of Deepthoughts Publications
The relationships between the tables of Deepthoughts Publications are explained in Table 27-8.
Table 27-8 Relationships in the Tables of Deepthoughts Publications Database
Table1 |
Table2 |
Type |
Description |
DTCatalog |
DTOrders |
Many-to-many |
One order can be placed for one |
|
|
|
book. However, one order can |
|
|
|
contain one or more books. |
|
|
|
|
This relationship is shown in Figure 27-2.
FIGURE 27-2 Database schema for Deepthoughts Publications
The Relationships between the Tables of Black and White Publications
The relationships between the tables of Black and White Publications are similar to those of Deepthoughts Publications. Figure 27-3 shows the relationships of Black and White Publications.
PROJECT CASE STUDY AND DESIGN |
Chapter 27 |
611 |
|
|
|
|
|
FIGURE 27-3 Database schema for Black and White Publications
The relationships shown in Figure 27-3 are explained in Table 27-9.
Table 27-9 Relationships in the Tables of Black and White Publications Database
Table1 |
Table2 |
Type |
Description |
BWCatalog |
BWOrders |
One-to-many |
One order can be placed for one |
|
|
|
book. However, one order can |
|
|
|
contain one or more books. |
|
|
|
|
After you finalize the database schema, you can finalize the interface of your application. Finalizing the interface of the application includes deciding on the Web forms to be included in the application.This will help the development team to have a framework to work on.
Web Forms Design
The Web site for Bookers Paradise includes five forms, the Main form, the Results form, the Orders form, the Search form, and the Construction form.The following section discusses these forms in detail.
612 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE
TIP
In this chapter, I will only detail the layout of these forms. You will learn to create these forms in Chapter 30, “Developing Web Service Clients.”
The Main Form
The Main form is the first form displayed when a user visits the site of Bookers Paradise. This form is the home page of the site of Booker’s Paradise. The Main form consists of one button control, five hyperlink controls, one list control, one text box control, and two table controls. After adding these controls to the form, you need to change the properties of these controls. You will learn to change the properties of the controls in Chapter 30.
Once the controls are added to the form, the Main form looks as shown in Figure 27-4.
FIGURE 27-4 The layout of the Main form
The Main form allows you to search for information about all the books or only books based on criteria. When the user selects the criteria and clicks on the Go button in the Main form, the Results page is displayed.
PROJECT CASE STUDY AND DESIGN |
Chapter 27 |
|
613 |
|
|
||||
|
|
|
|
|
The Results Form
The Results form shows the result of the search performed by the user. In addition, the Results page allows the user to order a book. The Results page includes a data grid, a label, and a hyperlink control.
To add these controls to the form, drag the controls from the Web Forms toolbox. When the controls are added, the Results form looks as shown in Figure 27-5.
FIGURE 27-5 The layout of the Results form
In the Results page, the user can choose a book to order. To order a book, a user needs to click on the Order button.This takes the user to the Orders page.
The Orders Form
The Orders form accepts details of the user who wishes to order a book on the Web site of Booker’s Paradise. Figure 27-6 shows the layout of the Orders form.
614 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE
FIGURE 27-6 The layout of the Orders form
As you can see in Figure 27-6, the Orders form includes 1 button control, 2 hyperlink controls, 12 label controls, 1 list control, 5 RequiredFieldValidator controls, and 10 text box controls.
The Search Form
The Main form in the site of Booker’s Paradise allows a user to select criteria to search for a book. When a user selects criteria in the list box, the user needs to specify a value for the criteria. In case the user forgets to specify a value, the user is taken to the Search page.
The Search page prompts the user to specify the criteria and a value for the criteria. To do this, the Search page includes a label control, two button controls, four radio buttons, and four text box controls.
Figure 27-7 shows the layout of the Search form.
PROJECT CASE STUDY AND DESIGN |
Chapter 27 |
615 |
|
|
|
|
|
FIGURE 27-7 The layout of the Search form
The Construction Form
The Main form, as you saw in Figure 27-4, includes hyperlink controls. When a user clicks on any of the hyperlink controls, the user is taken to the Construction page. Figure 27-8 shows the Construction page.
FIGURE 27-8 The layout of the Construction form