680 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE

Having created the form, look at the form as shown in Figure 30-6.

FIGURE 30-6 The ConstructionForm form

Adding Code to the Web Forms

After creating the forms, add the code to the forms to make them functional.The following section discusses writing code for the Web forms that you have created.

Adding Code to the Main Form

To begin with, write the code for the Main form. Adding functionality to the Main form includes writing code for the button control in the Main form. To add the functionality to the button control, add the following code in the Click event of the button control.

private void btnGo_Click(object sender, System.EventArgs e)

string strList; string strText;

strList = lstType.SelectedItem.Text ; if(String.Compare(strList, “ALL”)==0)

{

strText=”Search ALL”;

}

else

{

strText = txtSearch.Text;

}

if(strText.Length != 0)

{

Response.Redirect (“DispResultForm.aspx?Cat=” + strList + “& str=” + strText);

}

else

{

Response.Redirect (“SearchForm.aspx”);

}

}

The preceding code for the Click event of the Go button declares two string type variables, strList and strText. The strList variable is used to store the value selected by the user in the list box control. To do this, you use the Text property of the ListItem class.The Text property is used to specify or retrieve values in the list box that is created. To retrieve the selected item, use the SelectedItem property of the ListControl class.

Next,the Compare() method of the String class is used to compare the value stored in the strList variable to zero. If the value stored in the variable is zero, then the text Search ALL is stored in the variable strText. However, if the value stored in the variable strList is not equal to zero, the value entered by the user in the txtSearch text box is assigned to the variable strText. Doing this helps you to store the value entered by the user for the selected criteria.

However, there may be cases where the user forgets to specify a value in the txtSearch text box. In this case, the user is taken to the SearchForm form. Otherwise, the user is taken to the DispResultForm where the records matching a given criteria are displayed. To do this, you use an if statement that checks whether the length of the value stored in the strText variable is zero or not.The length of the variable is found out by using the Length property of the String class.

682 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE

To display the form based on the result of the if statement, you can use the Redirect() method. The Redirect() method redirects the user to a new page. The URL of the resultant page is passed as a parameter to the Redirect() method.

After writing the code for the Click event of the Go button, you can see the code for the MainForm form. The code for the MainForm form is as shown:

using System;

using System.Collections; using System.ComponentModel; using System.Data;

using System.Drawing; using System.Web;

using System.Web.SessionState; using System.Web.UI;

using System.Web.UI.WebControls; using System.Web.UI.HtmlControls;

namespace BookersClient

{

public class WebForm1 : System.Web.UI.Page

{

protected System.Web.UI.WebControls.TextBox txtSearch; protected System.Web.UI.WebControls.Button btnGo; protected System.Web.UI.WebControls.DropDownList lstType; protected System.Web.UI.WebControls.Table Table2; protected System.Web.UI.WebControls.Label Label1; protected System.Web.UI.WebControls.HyperLink HyperLink1; protected System.Web.UI.WebControls.HyperLink HyperLink2; protected System.Web.UI.WebControls.HyperLink HyperLink3; protected System.Web.UI.WebControls.HyperLink HyperLink5; protected System.Web.UI.WebControls.HyperLink HyperLink4; protected System.Web.UI.WebControls.Label Label2; protected System.Web.UI.WebControls.Label Label3; protected System.Web.UI.WebControls.Label Label4; protected System.Web.UI.WebControls.Table Table1;

private void Page_Load(object sender, System.EventArgs e)

{

}

private void btnGo_Click(object sender, System.EventArgs e)

{

string strList; string strText;

strList = lstType.SelectedItem.Text ; if(String.Compare(strList, “ALL”)==0)

{

strText=”Search ALL”;

}

else

{

strText = txtSearch.Text;

}

if(strText.Length != 0)

{

Response.Redirect (“DispResultForm.aspx?Cat=” + strList + “& str=” + strText);

}

else

{

Response.Redirect (“SearchForm.aspx”);

}

}

}

}

Adding Code to the DispResultForm Form

When the user is taken to the DispResultForm form, the records matching the criteria specified in the MainForm page are displayed.Therefore, you need to add code to the Page_Load() method as shown:

private void Page_Load(object sender, System.EventArgs e)

{

DTService.Service1 srv1 = new DTService.Service1();

684 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE

DataSet ds1; string strCategory; string strParam;

strCategory = Request.QueryString.Get(0).ToString(); strParam = Request.QueryString.Get(1).ToString();

switch(strCategory)

{

case “ALL”:

ds1 = srv1.SearchALL(); if(ds1.Tables[“Details”].Rows.Count != 0)

{

DataView source= new DataView(ds1.Tables[“Details”]);

DataGrid1.DataSource=source;

DataGrid1.DataBind();

lblInfo.Text = “Your search produced following results”;

}

else

{

DataGrid1.Visible = false;

lblInfo.Text = “No matching records found!!”;

}

break;

case “Title”:

ds1=srv1.SrchTitle (strParam); if(ds1.Tables[“Details”].Rows.Count !=0)

{

DataView source= new DataView(ds1.Tables[“Details”]);

DataGrid1.DataSource=source;

DataGrid1.DataBind();

lblInfo.Text = “Your search produced following results...”;

}

else

{

DataGrid1.Visible = false;

lblInfo.Text = “No matching records found!!”;

}

break;

case “ISBN Number”: ds1=srv1.SrchISBN (strParam);

if(ds1.Tables[“Details”].Rows.Count !=0)

{

DataView source= new DataView(ds1.Tables[“Details”]);

DataGrid1.DataSource=source;

DataGrid1.DataBind();

lblInfo.Text = “Your search produced following results...”;

}

else

{

DataGrid1.Visible = false;

lblInfo.Text = “No matching records found!!”;

}

break;

case “Author”:

ds1=srv1.SrchAuthor (strParam); if(ds1.Tables[“Details”].Rows.Count !=0)

{

DataView source= new DataView(ds1.Tables[“Details”]);

DataGrid1.DataSource=source;

DataGrid1.DataBind();

lblInfo.Text = “Your search produced following results”;

}

else

{

DataGrid1.Visible = false;

lblInfo.Text = “No matching records found!!”;

}

break;

686 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE

case “Category”: ds1=srv1.SrchCategory(strParam);

if(ds1.Tables[“Details”].Rows.Count !=0)

{

DataView source= new DataView(ds1.Tables[“Details”]);

DataGrid1.DataSource=source;

DataGrid1.DataBind();

lblInfo.Text = “Your search produced following results...”;

}

else

{

DataGrid1.Visible = false;

lblInfo.Text = “No matching records found!!”;

}

break;

default: break;

}

}

The preceding code is used to declare an instance, srv1, of the DTService.Service1 class. In addition, the code declares a dataset object with the name ds1 and two

string type variables, strCategory and strParam. Next, the strCategory variable is

initialized to the QueryString value stored at the index value 0. Similarly, the strParam variable is initialized to the QueryString value stored at the index value 1.

Then, the switch case statements are used to find out the value selected by the user in the list box on the Main page. Based on this value, the records are displayed in the DispResultForm form.

First consider the case in which a user selects the All option. In this case, the object, ds1, of the dataset is used to call the SearchALL() Web method in the Web service that you created in Chapter 29. This will store all the records returned by the SearchALL() Web method in the ds1 dataset object.

However, there may be a case where there are no records to be displayed. In this case, you can display an error message to the user. To do this, you first need to

check whether the records in the Details data table object are equal to null or not. To find this, you can use the Count property of the InternalDataCollectionBase class. The Count property returns the total number of elements in the data table object. The value that is retuned is then equated to null. If the collection object contains records, then an object, source, of the DataView class is created and initialized to the records in the Details data table object.

Then, the DataSource property of the DataGrid object is used to specify a source for the records in the DataGrid control. In this case, the source for the records is the source object. Finally, the DataBind() method is used to bind the DataGrid control to the source object. Once the records are stored and displayed in the DataGrid control, you can display a message in the lblInfo label control. To display the text in the label control, the Text property of the control is used. Figure 30-7 shows the records displayed in the DataGrid control.

FIGURE 30-7 The records displayed in the DataGrid control

However, in the case where the Details data table object does not contain any records, the DataGrid control is made invisible and an error message is displayed in the lblInfo label control. Figure 30-8 shows an error message in the lblInfo label control.

Response.Redirect (“OrdersForm.aspx?ISBN=” + strISBN + “ & Title=” + strTitle

+ “ & Author=” + strAuthor);

}

}

The preceding code uses the CommandName property in an if loop to check whether the CommandName specified for the button controls in the DataGrid control is Ord. I have discussed the CommandName property earlier in this chapter.

Inside the if loop, three string variables are declared with the names strISBN, strTitle, and strAuthor. These variables store the text in the cells of the DataGrid control. These variables are then passed as parameters to the Redirect() method of the HTTPResponse class. The page to be displayed using the Redirect() method is also passed as a parameter to the Redirect() method. In this case, the page to be displayed is the Orders form.

After adding the previously mentioned code to DispResultForm form,have a look at the complete code for the DispResultForm form. The complete code for the DispResultForm form is as shown:

using System;

using System.Collections; using System.ComponentModel; using System.Data;

using System.Drawing; using System.Web;

using System.Web.SessionState; using System.Web.UI;

using System.Web.UI.WebControls; using System.Web.UI.HtmlControls;

namespace BookersClient

{

public class WebForm3 : System.Web.UI.Page

{

protected System.Web.UI.WebControls.Label lblInfo; protected System.Web.UI.WebControls.HyperLink HyperLink1; protected System.Web.UI.WebControls.DataGrid DataGrid1;

if(ds1.Tables[“Details”].Rows.Count != 0)

{

DataView source= new DataView(ds1.Tables[“Details”]);

DataGrid1.DataSource=source;

DataGrid1.DataBind();

lblInfo.Text = “Your search produced following results...”;

}

else

{

DataGrid1.Visible = false;

lblInfo.Text = “No matching records found!!”;

}

break;

case “Title”: ds1=srv1.SrchTitle (strParam);

if(ds1.Tables[“Details”].Rows.Count !=0)

{

DataView source= new DataView(ds1.Tables[“Details”]);

DataGrid1.DataSource=source;

DataGrid1.DataBind();

lblInfo.Text = “Your search produced following results...”;

}

else

{

DataGrid1.Visible = false;

lblInfo.Text = “No matching records found!!”;

}

break;

case “ISBN Number”: ds1=srv1.SrchISBN (strParam);

if(ds1.Tables[“Details”].Rows.Count !=0)

{

DataView source= new DataView(ds1.Tables[“Details”]);

DataGrid1.DataSource=source;

DataGrid1.DataBind();

lblInfo.Text = “Your search produced following results...”;

}

else

{

DataGrid1.Visible = false;

lblInfo.Text = “No matching records found!!”;

}

break;

case “Author”: ds1=srv1.SrchAuthor (strParam);

if(ds1.Tables[“Details”].Rows.Count !=0)

{

DataView source= new DataView(ds1.Tables[“Details”]);

DataGrid1.DataSource=source;

DataGrid1.DataBind();

lblInfo.Text = “Your search produced following results...”;

}

else

{

DataGrid1.Visible = false;

lblInfo.Text = “No matching records found!!”;

}

692 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE

break;

case “Category”: ds1=srv1.SrchCategory(strParam); if(ds1.Tables[“Details”].Rows.Count !=0)

{

DataView source= new DataView(ds1.Tables[“Details”]);

DataGrid1.DataSource=source;

DataGrid1.DataBind();

lblInfo.Text = “Your search produced following results...”;

}

else

{

DataGrid1.Visible = false;

lblInfo.Text = “No matching records found!!”;

}

break; default: break;

}

}

private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls

.DataGridCommandEventArgs e)

{

if(e.CommandName == “Ord”)

{

string strISBN; string strTitle; string strAuthor;

strISBN = e.Item.Cells[1].Text ; strTitle = e.Item.Cells[2].Text ; strAuthor = e.Item.Cells[3].Text;

Response.Redirect (“OrdersForm.aspx?ISBN=” + strISBN + “ & Title=” + strTitle + “ & Author=” + strAuthor);

}

}

}

}

Adding Code to the Search Form

The Search form prompts the user to specify criteria and the value for the criteria. After specifying the criteria and the value, the user needs to click on the Search Now button. Clicking on the Search Now button will display the matching records in the DispResultForm form. In addition, the user can select the Home button to visit the Home page for the Web site of Bookers Paradise.

In order for the Web service to return the required records, you need to track the radio button selected by the user. In addition, you need to track the value specified for the criteria. To do this, you need to add the following code to the Click event of the btnSearch button:

private void btnSearch_Click(object sender, System.EventArgs e)

{

string strText, strCriteria; strText=””;

strCriteria=””;

if(txtISBN.Text.Trim() == “” & txtAuthor.Text.Trim() ==”” & txtCategory

.Text.Trim() ==”” & txtTitle.Text.Trim() ==””)

{

lblInfo.Text =”Please enter a value!!”; return;

}

if(radISBN.Checked == true)

{

strText = txtISBN.Text; strCriteria = “ISBN Number”;

}

else if(radAuthor.Checked == true)

{

strText = txtAuthor.Text; strCriteria = “Author”;

}

else if(radCategory.Checked == true)

When a user selects any of the radio buttons, you need to track the radio button clicked. To do this, the Checked property of the CheckBox class is used.The Checked property returns a Boolean value. If the radio button is clicked, the value returned by the Checked property is True. Otherwise, the Checked property returns a value

False.

For the radio button that is selected, the code uses the strText variable to store the text in the corresponding text box. In addition, the criteria specified by the user is stored in the strCriteria variable. Finally, the Redirect() method is used to display the DispResultForm form. The values in the strText and strCriteria variables are passed to the Redirect() method as a parameter.

As already discussed, the Search page contains a Home button. When the Home button is clicked,the Home page of the Web site of Bookers Paradise is displayed. To add this functionality, write the following code for the Click event of the Home button:

private void btnHome_Click(object sender, System.EventArgs e)

{

Response.Redirect (“MainForm.aspx”);

}

The preceding code uses the Redirect() method to redirect the user to the MainForm form, which is the Home page in this case.

After adding the preceding code to the SearchForm page, look at the complete code for the SearchForm page.

using System;

using System.Collections; using System.ComponentModel; using System.Data;

using System.Drawing; using System.Web;

using System.Web.SessionState; using System.Web.UI;

using System.Web.UI.WebControls; using System.Web.UI.HtmlControls;

696 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE

namespace BookersClient

{

public class SearchForm : System.Web.UI.Page

{

protected System.Web.UI.WebControls.RadioButton radISBN; protected System.Web.UI.WebControls.RadioButton radAuthor; protected System.Web.UI.WebControls.RadioButton radTitle; protected System.Web.UI.WebControls.RadioButton radCategory; protected System.Web.UI.WebControls.TextBox txtISBN; protected System.Web.UI.WebControls.TextBox txtAuthor; protected System.Web.UI.WebControls.TextBox txtTitle; protected System.Web.UI.WebControls.Button btnSearch; protected System.Web.UI.WebControls.Label lblInfo; protected System.Web.UI.WebControls.Button btnHome; protected System.Web.UI.WebControls.TextBox txtCategory;

private void Page_Load(object sender, System.EventArgs e)

{

}

private void btnSearch_Click(object sender, System.EventArgs e)

{

string strText, strCriteria; strText=””;

strCriteria=””;

if(txtISBN.Text.Trim() == “” & txtAuthor.Text.Trim() ==”” & txtCategory.Text.Trim() ==”” & txtTitle.Text.Trim() ==””)

{

lblInfo.Text =”Please enter a value!!”; return;

}

if(radISBN.Checked == true)

{

strText = txtISBN.Text; strCriteria = “ISBN Number”;

}

else if(radAuthor.Checked == true)

{

strText = txtAuthor.Text; strCriteria = “Author”;

}

else if(radCategory.Checked == true)

{

strText = txtCategory.Text; strCriteria = “Category”;

}

else if(radTitle.Checked == true)

{

strText = txtTitle.Text; strCriteria = “Title”;

}

Response.Redirect (“DispResultForm.aspx?Cat=”

+ strCriteria + “& str=” + strText);

}

private void btnHome_Click(object sender, System.EventArgs e)

{

Response.Redirect (“MainForm.aspx”);

}

}

}

Adding Code to the Orders Form

The Orders form accepts the information about the customer who orders a book on the Web site.This information, along with the information about the book, is added to the database of the publishing house.

When the Orders page is displayed, it contains the information about the book to be ordered. To do this, add the following code to the Page_Load() method. The Page_Load() method is executed when the page is loaded at run time.

private void Page_Load(object sender, System.EventArgs e)

{

txtISBN.Text = Request.QueryString.Get(0).ToString();

TextBox1.Text = “Dear “ + txtName.Text + “!! \n” + “Thanks for visiting Bookers Paradise. \n” +

“Your Customer ID is “ + custid + “.\n” +

“Your order (Number “ + orderno + “) will be shipped by “ + DateTime.Today.AddDays(15).Date + “.”;

}

else

{

TextBox1.Text = “Dear “ + txtName.Text + “!! \n” + “Thanks for visiting Bookers Paradise \n” +

“Your request could not be processed due to some internal error. \n”+ “Please visit later.”;

}

}

The preceding code creates an instance of the DTService.Service1 class. In addition, the code declares three string type variables, strDate, strStatus, and strOrderBy. The strDate variable is initialized to the current date, which is retrieved by the Today property of the System.DateTime struct. However, to store the date in a string type variable, you first need to convert the date type value to a string type value by using the Convert() method. Next, the strStatus variable is initialized to the value Pending and the strOrderBy variable to the value Bookers

Paradise.

Then, a string type variable, result, is declared and initialized to the value returned by the AcceptDetails() Web method.This Web method is used to store the details of the customer and the book, passed as parameters to the Web method, in the DTDetails table. You have learned to write the code for the AcceptDetails() Web method in Chapter 29 in the section “Creating the AcceptDetails() Web Method.”

Next,the code declares and initializes another string type variable, orderno, to the value returned by the GenerateOrder() Web method.This method is used to automatically generate an order number for each order that is placed.

Next, a if construct is used to check whether records are added to the database. If the records are added, a string type variable, custid, is declared. This variable is initialized to a value returned by the InsertBookersDB() method that is used to automatically create the customer ID for all orders that are placed. You will learn to write a code for the InsertBookersDB() method later in this chapter.

700 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE

Then, a message is displayed in a text box confirming that the order for a book is successfully placed. Figure 30-10 shows a message displayed to the customer.

FIGURE 30-10 The message displayed to the customer

However, if the AcceptDetails() Web method fails to add the records to the underlying database, an error message is displayed to the customer.

Adding Code to the InsertBookersDB() Method

The InsertBookersDB() method is used to automatically generate the customer ID value for all orders that are placed on the Web site. The order number for the order is passed as the parameter to this method. To create the InsertBookersDB() method, write the following code:

public string InsertBookersDB(string order)

{

string SelStr;

SelStr = “Select Count(*) From BookerCustDetails”;

SqlCommand SelCom;

SelCom = new SqlCommand(SelStr, sqlConnection1); sqlConnection1.Open(); sqlDataAdapter1.SelectCommand = SelCom; sqlDataAdapter1.Fill(dsCustomers1,”Customer”);

sqlConnection1.Close(); string str;

str = dsCustomers1.Tables[“Customer”].Rows[0][0].ToString (); int val;

val = Convert.ToInt32(str); val= val+1;

if(val>0 & val<=9)

{

str = “C000” + Convert.ToString(val);

}

else if(val>9 & val<=99)

{

str =”C00” + Convert.ToString (val);

}

else if(val>99 & val <=999)

{

str = “C0” + Convert.ToString (val);

}

else

{

str = “C” + Convert.ToString (val);

}

}

In the preceding code, a string type variable SelStr is declared and initialized to a SQL statement that is used to count the records in the BookersCustDetails table. Next, an instance, SelCom, of the SqlCommand class is declared. In the constructor of the SqlCommand class, the variable SelStr is passed as a parameter. In addition, an object of the sqlConnection component is added as a parameter to the constructor of the SqlCommand class.

Once you have assigned the SQL statement to the SelStr variable, the connection to the BookerCustDetails table is opened by using the Open() method. Then, the Fill() method is used to fill the sqlDataAdapter component with the data in the dataset. After the records are added to the sqlDataAdapter component, the connection to the BookerCustDetails table is closed using the Close() method.

The code then declares a string type variable str and initializes it to a collection of rows in the table. To do this, the Rows property of the DataRowCollection class

702 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE

is used. The value returned by the Rows property is converted to a string value by using the ToString() method and stored in the str variable. Next, an integer type variable, val, is declared and initialized to the 32-bit signed integer equivalent of the value stored in the str variable. To convert the string type variable to the 32bit signed integer variable, you use the ToInt property of the System.Convert class.

Because the value stored in the variable val is the number of records in the BookerCustDetails table, to generate the next customer ID, you need to add 1 to the value in the variable val. Then, an if construct is used to find the range of the value in the variable val. If this value lies in the range 0 to 9, the string C000 is added to this value. However, to do this, you again need to convert the value in the variable val to a string type value.

Similarly, if the value in the variable val lies in the range 9 to 99, the string C00 is added to the value. Therefore, the range of the value is found out and C followed by zeros is added to make the customer ID a four-digit number. This value stored in the variable str is returned by the method.

Adding Code to Store the Customers’ Details in the Database

As already discussed, the values entered by the user in the Orders form are stored in the database of Deepthoughts Publications. You can write the code that stores the details about the customers in the underlying database. To do this, add the following code to the Orders page:

string InsStr;

InsStr = “Insert Into BookerCustDetails Values(@CID, @CN, @BA1, @BA2, @BC, @BS)”; SqlCommand InsCom;

InsCom = new SqlCommand(InsStr, sqlConnection1); sqlDataAdapter1.InsertCommand = InsCom;

sqlDataAdapter1.InsertCommand.Parameters.Add(“@CID”, SqlDbType.Char,6).Value = str; sqlDataAdapter1.InsertCommand.Parameters.Add(“@CN”, SqlDbType.VarChar,50)

.Value = txtName.Text; sqlDataAdapter1.InsertCommand.Parameters.Add(“@BA1”, SqlDbType.VarChar ,50)

.Value= txtAddr1.Text ; sqlDataAdapter1.InsertCommand.Parameters.Add(“@BA2”, SqlDbType.VarChar,50)

.Value= txtAddr2.Text ; sqlDataAdapter1.InsertCommand.Parameters.Add(“@BC”,SqlDbType.VarChar,20)

.Value = txtCity.Text ;

sqlDataAdapter1.InsertCommand.Parameters.Add(“@BS”, SqlDbType.VarChar ,10)

.Value = txtState.Text ; if(sqlConnection1.State== ConnectionState.Closed )

{

sqlConnection1.Open ();

}

sqlDataAdapter1.InsertCommand.ExecuteNonQuery(); sqlConnection1.Close();

The preceding code declares a string type variable InsStr and stores an SQL query used to insert values to the BookerCustDetails table.The values to be stored are passed to the SQL query. Next, an instance of the SqlCommand class is created to connect to the sqlDataAdapter component. Next, the Add() method is used to add values in the text box controls to the SqlParameterCollection object. To retrieve the value in the text box, the Text property is used.

Next, an if loop is used to check whether the SQL connection is opened or closed. If the connection is closed, you use the Open() method to open the connection. Finally, the ExecuteNonQuery() method of the SqlCommand class is executed to return the records that are affected by the SQL command stored in the SelStr variable. After adding the records, the connection is closed.

Similarly, you can add the code that adds the details of the book for which the user has placed an order in the database of Deepthoughts Publications. You will see the code later in this chapter.

In addition to the Order button, the Orders form contains a Clear button. The following section discusses adding code to the Clear button.

Adding Code to the Clear Button

The Clear button is used to clear all the values entered by the user in the Orders page. To add this functionality, write the following code in the Click event of the

btnClear button:

private void btnClear_Click(object sender, System.EventArgs e)

{

txtISBN.Text=””;

txtTitle.Text =””;

txtAuthor.Text =””;

txtName.Text=””;

704 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE

txtAddr1.Text=””;

txtAddr2.Text=””;

txtCity.Text=””;

txtState.Text=””;

TextBox1.Text =””;

txtCardNumber.Text =””;

lstCardType.SelectedIndex =0;

}

The preceding code writes a null value in all the text box controls.

After adding the previously described code snippets to the Orders page, look at the complete code for the OrdersForm form.

using System;

using System.Collections; using System.ComponentModel; using System.Data;

using System.Drawing; using System.Web;

using System.Web.SessionState; using System.Web.UI;

using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Data.SqlClient ;

namespace BookersClient

{

public class OrdersForm : System.Web.UI.Page

{

protected System.Web.UI.WebControls.Label Label1; protected System.Web.UI.WebControls.Label Label4; protected System.Web.UI.WebControls.Label Label5; protected System.Web.UI.WebControls.Label Label6; protected System.Web.UI.WebControls.Label Label7; protected System.Web.UI.WebControls.Label Label8; protected System.Web.UI.WebControls.TextBox txtISBN; protected System.Web.UI.WebControls.TextBox txtName;

protected System.Web.UI.WebControls.TextBox txtAddr1; protected System.Web.UI.WebControls.TextBox txtAddr2; protected System.Web.UI.WebControls.TextBox txtCity; protected System.Web.UI.WebControls.RequiredFieldValidator

RequiredFieldValidator3;

protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;

protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;

protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator6;

protected System.Web.UI.WebControls.Button btnOrder; protected System.Web.UI.WebControls.Button btnClear; protected System.Web.UI.WebControls.Label Label2; protected System.Web.UI.WebControls.Label Label3; protected System.Web.UI.WebControls.Label Label9; protected System.Web.UI.WebControls.Label Label10; protected System.Web.UI.WebControls.Label Label11; protected System.Web.UI.WebControls.Label Label12;

protected System.Web.UI.WebControls.DropDownList lstCardType; protected System.Web.UI.WebControls.TextBox txtCardNumber; protected System.Web.UI.WebControls.TextBox txtTitle; protected System.Web.UI.WebControls.TextBox txtAuthor; protected System.Web.UI.WebControls.RequiredFieldValidator

RequiredFieldValidator1;

protected System.Web.UI.WebControls.TextBox TextBox1; protected System.Web.UI.WebControls.HyperLink HyperLink1; protected System.Data.SqlClient.SqlCommand sqlSelectCommand1; protected System.Data.SqlClient.SqlCommand sqlInsertCommand1; protected System.Data.SqlClient.SqlCommand sqlUpdateCommand1; protected System.Data.SqlClient.SqlCommand sqlDeleteCommand1; protected System.Data.SqlClient.SqlConnection sqlConnection1; protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1; protected BookersClient.dsCustomers dsCustomers1;

protected System.Web.UI.WebControls.TextBox txtState;

706 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE

private void Page_Load(object sender, System.EventArgs e)

{

// Put user code to initialize the page here txtISBN.Text = Request.QueryString.Get(0).ToString(); txtTitle.Text = Request.QueryString.Get(1).ToString(); txtAuthor.Text = Request.QueryString.Get(2).ToString();

}

private void btnOrder_Click(object sender, System.EventArgs e)

{

DTService.Service1 srv = new DTService.Service1(); string strDate, strStatus, strOrderBy;

strDate = Convert.ToString(DateTime.Today); strStatus=”Pending”;

strOrderBy=”Bookers Paradise”; string result;

result = srv.AcceptDetails(txtISBN.Text, strDate,

txtName.Text, txtAddr1.Text, txtAddr2.Text, txtCity.Text, txtState.Text, strOrderBy, strStatus,

lstCardType.SelectedItem.Text, txtCardNumber.Text );

string orderno;

orderno = srv.GenerateOrder();

if (result == “Record Inserted!!”)

{

string custid;

custid = InsertBookersDB(orderno);

TextBox1.Text = “Dear “ + txtName.Text + “!! \n” + “Thanks for visiting Bookers Paradise. \n” +

“Your Customer ID is “ + custid + “.\n” +

“Your order (Number “ + orderno + “) will be shipped by “ + DateTime.Today.AddDays(15).Date + “.”;

}

else

{

TextBox1.Text = “Dear “ + txtName.Text + “!! \n” + “Thanks for visiting Bookers Paradise \n” +

“Your request could not be processed due to some internal error. \n”+ “Please visit later.”;

}

}

public string InsertBookersDB(string order)

{

//Code To Generate Customer ID string SelStr;

SelStr = “Select Count(*) From BookerCustDetails”;

SqlCommand SelCom;

SelCom = new SqlCommand(SelStr, sqlConnection1); sqlConnection1.Open(); sqlDataAdapter1.SelectCommand = SelCom; sqlDataAdapter1.Fill(dsCustomers1,”Customer”); sqlConnection1.Close();

string str;

str = dsCustomers1.Tables[“Customer”].Rows[0][0].ToString (); int val;

val = Convert.ToInt32(str); val= val+1;

if(val>0 & val<=9)

{

str = “C000” + Convert.ToString(val);

}

private void btnClear_Click(object sender, System.EventArgs e)

{

txtISBN.Text=””; txtTitle.Text =””; txtAuthor.Text =””; txtName.Text=””; txtAddr1.Text=””; txtAddr2.Text=””; txtCity.Text=””; txtState.Text=””; TextBox1.Text =””; txtCardNumber.Text =””; lstCardType.SelectedIndex =0;

}

710 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE

private void btnHome_Click(object sender, System.EventArgs e)

{

Response.Redirect (“Mainform.aspx”);

}

}

}

Adding Code to the Construction Form

The Main form in the Bookers Paradise Web site contains some hyperlinks. On clicking the hyperlinks, the user is taken to the ConstructionForm form. However, the Construction form displays a message that the page to which the user wants to connect is under construction.

The Construction form includes a hyperlink control that takes you to the Home page. The code for the Construction form includes the declarations for the controls added to the form. The code for the Construction form is as shown as follows:

using System;

using System.Collections; using System.ComponentModel; using System.Data;

using System.Drawing; using System.Web;

using System.Web.SessionState; using System.Web.UI;

using System.Web.UI.WebControls; using System.Web.UI.HtmlControls;

namespace BookersClient

{

public class ConstructionForm : System.Web.UI.Page

{

protected System.Web.UI.WebControls.Label Label2; protected System.Web.UI.WebControls.HyperLink HyperLink1; protected System.Web.UI.WebControls.Label Label1;