- •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
IMPLEMENTING THE BUSINESS LOGIC |
Chapter 33 |
779 |
|
|
|
|
|
The preceding code matches the value entered by the user to all the attributes in the Users.xml file If the value of the variable found is false, an error message is displayed. Finally, the reader object is closed using the Close() method of the
XmlTextReader class.
Adding Code to the Query Button in the frmSelectOption Form
When a user selects an option, View Pending Calls or Show Unattended Calls, and clicks on the Query button, the frmPending form or the frmUnattended form is displayed, respectively. Therefore, you first need to track the option selected by the user and display the corresponding form. To do this, add the following code to the Click event of the cmdLoad button.
if (lstOptions.Selection.Value==”viewPending”)
{
ActiveForm=frmPending;
}
else
{
ActiveForm=frmUnattended;
}
The preceding code uses the Value property of the MobileListItem class to find the option selected by the user and then to display the appropriate form. However, displaying the form requires reading data from the Calls.xml file. To display data from the Calls.xml file, you need to add the following code to the Click event of the cmdLoad button.
string lstItem;
XmlTextReader reader = new XmlTextReader(“C:\\Electronix\\Calls.xml”);
reader.MoveToContent();
while (reader.Read())
{
lstItem=””;
if (reader.HasAttributes)
780 Project 6 CREATING A MOBILE APPLICATION
{
reader.MoveToNextAttribute(); reader.MoveToNextAttribute(); if (reader.Value==”Unattended”)
{
reader.MoveToFirstAttribute(); lstItem=reader.Value + “: “; reader.MoveToElement(); lstItem=lstItem+ reader.ReadInnerXml(); lstUnattended.Items.Add(lstItem);
}
if (reader.Value==”Pending”)
{
reader.MoveToFirstAttribute(); lstItem=reader.Value + “: “; reader.MoveToElement(); lstItem=lstItem+ reader.ReadInnerXml(); lstPending.Items.Add(lstItem);
}
}
}
The preceding code creates a variable of the type string, lstItem, and initializes it to a null value. In addition, the code creates an instance, reader, of the XmlTextReader class and initializes it to the Calls.xml file. Next, the MoveToContent() method of the XmlReader class is used to move to the content node in the XML document.
The code uses the Read() method to read the data in the while loop. Inside the while loop, an if loop is used to check whether the current node has any attributes associated with it. If the current node has attributes associated with it, the reader object is moved to read the second attribute, status, in the Calls.xml file. Figure 33-9 displays the content of the Calls.xml file.
IMPLEMENTING THE BUSINESS LOGIC |
Chapter 33 |
781 |
|
|
|
|
|
FIGURE 33-9 The content of the Calls.xml file
If the value of the status node is Unattended, the reader object is moved back to the first attribute of the content node, id. To move to the id attribute, the
MoveToFirstAttribute() method of the XmlTextReader class is used. Then, the
value in the id attribute is retrieved using the Value property and stored in the lstItem variable.
Next, the reader object is moved to the Call element that contains the id attribute. This would enable the reader object to read the entire content of the Call element with the value of the status node as Unattended. To read the entire content of the Call element as a string, you can use the ReadInnerXml() method of the XmlTextReader class. Then, the content of the Call element is stored in the lstItem variable and added to the lstUnattended SelectionList control by using
the Add() method of the MobileListItemCollection() class.
Similarly, if the user has selected the View Pending Calls option, the content of the Call element with the value of the status property as Pending is added to the lstPending SelectionList control and displayed in the frmPending form. Figure 33-10 shows the frmSelectOption form with the View Pending Calls option selected.
782 Project 6 CREATING A MOBILE APPLICATION
FIGURE 33-10 The frmSelectOption form with the View Pending Calls option selected
Adding Code to the Mark checked as complete Button in the frmPending Form
When a user checks the pending calls check box and clicks on the Mark checked as complete button, the status of the selected call is changed to Complete in the Calls.xml file. In addition, the entry of the call is removed from the lstPending SelectionList control in the frmPending form. To do this, you need to add the following code to the Click event of the cmdUpdate button.
private void cmdUpdate_Click(object sender, System.EventArgs e)
{
StreamReader strRead; string content, strText;
int index;
strRead= new StreamReader(“C:\\Electronix\\Calls.xml”); content=strRead.ReadToEnd();
strRead.Close();
for (int i=0; i<lstPending.Items.Count; i++)
{
if (lstPending.Items[i].Selected==true)
{
strText=lstPending.Items[i].Text;
IMPLEMENTING THE BUSINESS LOGIC |
Chapter 33 |
|
783 |
|
|
||||
|
|
|
|
|
strText=strText.Substring(0,4); index=content.IndexOf(strText); content=content.Remove(index+14,7); content=content.Insert(index+14, “Complete”);
}
}
StreamWriter strWrite;
strWrite = new StreamWriter(“C:\\Electronix\\Calls.xml”); strWrite.Write(content);
strWrite.Close(); lstPending.Items.Clear(); string lstItem; XmlTextReader reader;
reader = new XmlTextReader(“C:\\Electronix\\Calls.xml”); reader.MoveToContent();
while (reader.Read())
{
lstItem=””;
if (reader.HasAttributes)
{
reader.MoveToNextAttribute(); reader.MoveToNextAttribute(); if (reader.Value==”Pending”)
{
reader.MoveToFirstAttribute(); lstItem=reader.Value + “: “; reader.MoveToElement(); lstItem=lstItem+ reader.ReadInnerXml(); lstPending.Items.Add(lstItem);
}
}
}
reader.Close();
}
The preceding code creates an instance, strRead, of the StreamReader class and initializes it to the Calls.xml file in the Electronix folder. Next, a string type variable, content, is declared and initialized to the data in the strRead object.
784 Project 6 CREATING A MOBILE APPLICATION
However, to do this, you first need to use the ReadToEnd() method of the StreamReader class to read the entire content stored in the strRead object. Once the data in the strRead object is stored in the content variable, you can close the strRead object by using the Close() method. Next, a for loop is used to add the data in the content variable as list items to the lstPending SelectionList control.This data is then displayed as a list of calls in the frmPending form. Figure 33-11 shows the list of pending calls at run time.
FIGURE 33-11 The list of pending calls at run time
As you can see in Figure 33-11, the user has selected the C002 pending list check box. After selecting the check box, if the user clicks on the Mark checked as complete button, the status of the C002 call is changed to Complete. You have already added the code to do this in the Click event of the cmdAcceptCall button. I will now discuss the code.
To write the changes to the Calls.xml file, you would need an object of the StreamWriter class. Therefore, the code declares and initializes an object, strWrite, to the Calls.xml file. The strWrite object uses the Write() method of the StreamWriter class to write the changes to the Calls.xml file.The data to be written is passed as a parameter to the Write() method.After doing this, you can close