• Download Project files
• Download Home Work 3 files

Note

IE caches files by default which can prevent opening of a later version. The effect is particularly noticeable during repeated tests of HTML forms referencing ASP files that have been changed but are not opened because of a cached version of the HTML.

The solution is to require IE to check for new versions on every visit to a page. In IE: Tools | Internet Options | Temporary Internet Files | Settings | Every Visit to Page

Overview 

The stock trading site has two main functions: managing access to the site and managing site functions.

Managing access - Home Work 2 completed the logic for registration (Registration.asp) and logging in (Login.asp) of stock traders and logging out the current trader out (Logout.asp). The user view to manage access appears at right.

Managing function - This home work will complete the bulk of logic for the site function. The user view to manage site function appears at right. The new left menu provides access to the functions after user login, the center provides display of function results.

However, our concern will not be the user interface but managing the data and maintaining system integrity. In the following, we will develop methods that allow testing each module without a user interface.

There are three main site functions.

1. Account - Displays current account information such as name, address and balance.
2. Portfolio - Displays the stocks owned, the value and total worth at current price.
3. Shopping cart - The shopping cart metaphor describes much of the fundamental site operation.
   • Buy - Selects stocks from a list to buy and places in the cart.
   • Sell - Selects stocks from the portfolio to sell and places in the cart.
   • Cart - Displays the cart contents. Stocks can be removed from the cart.
   • Commit - The cart is emptied of stocks and are bought or sold.

The major logic of the site functionality is implemented in the following scripts:

1. List current stock holdings and value (Portfolio.asp) - Final version will be completed in class.
2. List the trader summary (TraderSummary.asp) - Mostly completed in class.
3. List shopping cart contents (CartSummary.asp).
4. List available stocks to buy (BuyList.asp).
5. Buy stocks from those available (BuyStock.asp) and place in shopping cart.
6. List stocks owned to sell (SellList.asp).
7. Sell stocks from those owned (SellStock.asp) and place in shopping cart.

Review of Portfolio.asp

The portfolio is the list of an individual's stock symbol, stock name, shares owned, price, stock value and total worth. The script:

1. JOINs Portfolio and Stock tables on SYMBOL and SELECTs records where ID='TraderID' to produce the necessary fields in a record set,
2. generates the XML from the record set,
3. transforms the XML into HTML using the XSL file PortfolioContent.htm.

Portfolio.ASP

<%@ Language=JScript%>
<%	
   if(Session("trader") == undefined)
      Response.Redirect("Login.xml");

   conn = Server.CreateObject("ADODB.Connection"); 
   conn.Mode = 3;
   conn.Open ("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" + 
                      Server.MapPath("Project.mdb"));
   rs = conn.Execute(
     "SELECT PORTFOLIO.SYMBOL, PRICE, SHARES, " +
     "SHARES*PRICE as STOCKVALUE " +
     "FROM STOCK INNER JOIN PORTFOLIO ON " +
     "STOCK.SYMBOL = PORTFOLIO.SYMBOL " +
     "WHERE ID='TraderID';");

   var xmlDoc = Server.CreateObject("Msxml2.DOMDocument");
   xmlDoc.async = false;
   rs.Save (xmlDoc, 1) ;        // Convert recordset to XML
                                           // Save as XML
   xmlDoc.save(Server.MapPath("Portfolio.xml"));

   var xsl = Server.CreateObject("Msxml2.DOMDocument");
   xsl.async = false;              // Convert XML tree using XSL   
   xsl.load(Server.MapPath("PortfolioContent.htm"));
                                            // Write tree as HTML
   Response.Write(xmlDoc.transformNode(xsl)); 
   conn.Close();
%>

PortfolioContent.htm

<xsl:stylesheet version="2.0" 
 xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
 xmlns="http://www.w3.org/1999/xhtml" 
 xmlns:rs="urn:schemas-microsoft-com:rowset" 
 xmlns:z="#RowsetSchema">

   <xsl:output method="html" />

   <xsl:template name="PortfolioContent">
      <h1>Portfolio Summary</h1>
      <xsl:for-each select="xml/rs:data/z:row">
         <xsl:value-of select="@SYMBOL" />
         -
         <xsl:value-of select="@SHARES" />
         -
         <xsl:value-of select="@PRICE" />
         -
         <xsl:value-of select="@STOCKVALUE" />
         <br />
      </xsl:for-each>
   </xsl:template>

   <xsl:template match="/">
      <xsl:call-template name="PortfolioContent" />
   </xsl:template>
</xsl:stylesheet>

Session("trader")

Each trader session is tracked after logging in by the Session("trader") variable which should be the trader's ID. When David is logged in Session("trader") is 'David'. Each script has access to the Session("trader") variable.

In the Portfolio.asp script SELECT, rather using a fixed ID, we need to use instead Session("trader"). We also need an easy, sure way to initialize Session("trader") to a known value without going through the log in process each time.

SELECTing and Displaying

The portfolio should also include the NAME of the stock. We need to:

1. SELECT the NAME field in Portfolio.asp
2. Display @NAME in PortfolioContent.htm

TraderSummary.asp

The script is similar to Portfolio.asp script but without the JOIN as only the Trader table is consulted.

1. SELECT * FROM Trader WHERE ID=Session("trader")
   • Selects all fields for records matching ID=Session("trader").
2. Convert the record set to XML.

   var xmlDoc = Server.CreateObject("Msxml2.DOMDocument");
   xmlDoc.async = false;
   rs.Save (xmlDoc, 1) ;

        

3. Save a copy of the XML in case needed for testing.

   xmlDoc.save(Server.MapPath("TraderSummary.xml"));

    

4. Transform the XML using an XSL file.

   var xsl = Server.CreateObject("Msxml2.DOMDocument");
   xsl.async = false;             
   xsl.load(Server.MapPath("TraderSummaryContent.htm"))

    

5. Write the transformation to the browser.

   Response.Write(xmlDoc.transformNode(xsl));

TraderSummaryContent.htm

The transformation of XML to HTML uses this style sheet. For testing purposes, it can be very basic, patterned after the PortfolioContent.htm style sheet.  

Errors

BuyList.asp and BuyListContent.htm

List all the stocks in the Stock table. The script is very similar to TraderSummary.asp and the testing style sheet BuyListContent.htm can be very similar to TraderSummaryContent.htm file.

To write the BuyListContent.htm style sheet, modify the TraderSummaryContent.htm file with the names of the Stock table fields, SYMBOL, NAME, and PRICE.

Add records if necessary to the Stock table using Access. Be sure to save the table before running scripts.

CartSummary.asp and CartSummaryContent.htm

The shopping cart metaphor holds the stocks that are to be bought or sold. The Cart table holds all carts for all traders, each distinguished by the unique trader ID field.

List all the entries in the shopping cart for the current trader ID (i.e. select on trader ID). The script is very similar to TraderSummary.asp and testing style sheet can be very similar to TraderSummaryContent.htm file.

To write the CartSummaryContent.htm style sheet, modify the TraderSummaryContent.htm file with the names of the Cart table fields, TRADEID, ID, SYMBOL, SHARES, PRICE, and BUY.

If necessary, add records with the ID that matches Session("trader") to the Cart table using Access. Be sure to save the table before running scripts. Note that TRADEID is automatically generated.

Hints

• Database tables can be examined and hand edited using Access. Access can also be used to execute the SQL that will be used by the ASP script.
• Scripts check that the trader is logged in, making it difficult to test your script independent of the login, etc. The login check can be temporarily disabled by commenting out the check and setting the Session("trader") = "trader" where "trader" is a trader from the Trader table.

  // if(Session("trader") == undefined)
  //      Response.Redirect("Login.xml");

      Session("trader") = "trader";

   

• All traders can be logged out and session variables deleted by executing Reset.asp script.

  http://www.ius.edu/username/N342/Project/Reset.asp

Assignment

Complete:

1. List current stock holdings and value (Portfolio.asp and PortfolioContent.htm).
2. List the trader summary (TraderSummary.asp and TraderSummaryContent.htm).
3. List available stocks to buy (BuyList.asp and BuyListContent.htm).
4. List shopping cart contents (CartSummary.asp and CartSummaryContent.htm).

Turn in - Due before class on the date listed in the syllabus.

1. OnCourse Drop Box
   1. Compress the Project folder containing the homework files.
      • In Windows Explorer, right-click on the Project folder.
      • Click Send to then click Compressed (zipped) Folder.
      • Project.zip will be created.
   2. Upload Project.zip to your CSCI N342 OnCourse Drop Box using the Display Name of HW3.
2. IUS server
   1. Copy to W: drive or FTP to webftp.ius.edu
      • In browser address enter: ftp://webftp.ius.edu
      • Login using your IUS ADS\username and password.
      • Copy the contents of the Project directory onto ftp page.
   2. Test in IE. The Welcome.xml is a default page.
      • In browser address enter: http://www.ius.edu/username/N342/Project/Welcome.xml
3. Email notification to rwisman@ius.edu with subject: YOUR NAME - N342 HW3 - username