1. Problem 1 Execute
   Problem 1 Code

2. Problem 2 Execute
   Problem 2 Code

3. Rebuild database tables for Problem 1 Execute
   Code for database tables rebuild

Assume, there is a table structure as shown below.

Table name: tsales

salesperson_id int IDENTITY (1,1), lname varchar(30) NOT NULL, fname varchar(30) NOT NULL, sales_region char(1) NOT NULL, [this field always contains 1,2,3 or 4 ONLY] ytd_sales_p1 int, [these are the product sales for each of the companies 7 products] ytd_sales_p2 int, ytd_sales_p3 int, ytd_sales_p4 int, ytd_sales_p5 int, ytd_sales_p6 int, ytd_sales_p7 int This table holds the current product sales (products 1 thru 7) for each salesperson. You should NOT allow the user to modify: the salesperson_id, fname (first name), lname (last name) or sales_region

The table tsales is in a database named "gl001". For a recordset, the credential string is: rs.open some_sql_string,"DSN=gl001;UID=gl001;PWD=11111;" For a connection, the credential string is: cn.open "gl001","gl001","11111" On all passes use:<form name="f1" action="http://auckland.bauer.uh.edu/sales_update.asp" method="post">

1. (50 points) Write the 1st and 2nd and 3rd passes for an salesperson update. Specifically:

1. The first pass provides a textbox for specifying the salesperson_id
   • This is a simple HTML page allows the user to enter a salesperson ID into a textbox.(Do not attempt edit the data)
   • provide a hidden variable named token with a value of "2"
   • provide a submit button
2. The second pass provides the current information in the tsales table for the specified salesperson_id and allows the user to update the salesperson's product sales for each of the seven products. Provide:
   • label and display: the salesperson_id; lname; fname and sales_region.
   • label and provide a textbox for the seven products with the current amounts stored in the database as values.
   • provide a submit button
   • provide a hidden variable named token with a value of "3"
   • provide a hidden variable named sid with a value of salesperson_id
3. the third pass will update only the salesperson's data for the sales of the seven products
   • Do NOT use transaction control
   • Show "Success" or "Failure" for the transaction outcome
   • Show the number of records modifed.

2. (50 points)

Create an asp program that shows product sales for all salespersons. Include all the columns in the database table tsales in the order shown at the top of the page (i.e., in the order they appear in the CREATE statement).

Order the report in ASCENDING sales_region order. Use the salesperson_id as the secondary sort parameter in ASCENDING order.

Additionally at the end of the report:

• show the seven product sales totals for each sales_region. There are only four sales_region values: 1;2;3 and 4.
• show the seven product sales grand totals by summing across all sales_region values

some_array_name = Array(value,value, ... ,value)

or without initial values either of these:

some_array_name = Array()

or

some_array_name = Array(number_of_array_elements)

Two dimensional arrays can be define with:

DIM name_of_the_array ( number_of_rows , number_of_columns )