Capt. Horatio T.P. Webb
MIS 4372 Transaction Processing II
Parks -- Spring 2012
Version 3 -- Last Updated 6:00 PM 3/21/2012
NOTICES:
  • Final Exam here Due Fri May 4, 5:30PM 280E MH
  • Coding issue on bmodv.aspx (the VB.NET modify program)

    There is a problem that causes the regular expression validator for acctdesc
    to throw an error that states there is a problem with the quote
    when you didn't enter one. In the program bmodv.aspx, read this caution
    starting on line 131 of the code. 

        *************************CAUTION *******************************
    The following line has an oddity in it. In order prevent the user
    from entering a single or double quote the regular expression validator uses the pattern: [^\'\"]+
    BUT the validator pattern is enclosed in double quote marks itself.
    So, to prevent the double quote from terminating the ValidationExpression string
    we have to force the double quote to be inserted at execution time.
    So in the line below, replace the double quote with the string: AMPERSANDCHARACTERquote;
    that is, the single ampersand character followed by the string  "quot;"
    The following line is done this way. But you can't see it when you view this page,
    because the ampersandquot; has been rendered by your browser as ". But it is there nonetheless.
	See this discussed: http://forums.asp.net/t/1220701.aspx/1
    ******************************************************************
    <asp:RegularExpressionValidator id="adquotecheck" ControlToValidate="adtextbox" ValidationExpression="[^\'\"]+"
    Display="Dynamic" runat="server">
  • Midterm:
  • To download Visual Studio 2010 Professional
    • Uninstall any older or other versions of Visual Studio
    • Go to www.dreamspark.com website
    • Choose "Visual Studio 2010 Professional"
    • Register as a student
    • Select "University of Houston"
    • Use your UH email for validation (NOT your gmail, hotmail, etc -- but your UH email address)
    • Then download the package
  • Your Resume needs top be posted on the new Bauer Career Gateway. Go to the Bauer Career Center web site (here). We hope to use this system as the Bauer College's primary resume depository.  If you plan to graduate spring, summer or fall, be sure you are registered with the University Career Center. Most of the firms use the University Career Center (here) to setup interviews for both internships and full time employment.  So, get registered at BOTH of the locations ASAP.
  • FTP software, download here. Click here for setup instructions
  • Assignments will only be evaluated on the final exam.
    • COURSE SUMMARY: This course is the second part of a two course sequence on transaction processing in the clent-server environment. This second course concentrates on server-side processes involving submission and processing transaction information across the Internet. The primary technologies employed are: HTML, XML, XSL, WSH, Microsoft's Visual Studio and ASP.NET 3.5 (VB.NET and C#), Microsoft SQL Server emphasizing XML. We will also examine the LINUX and PHP alternatives.
    The course will discuss two major technologies. In the first half the course will present server side scripting options and the second half will discuss Microsoft's server-side ASP.NET 3.5 and Visual Studio technologies.
    TEXTS: We will not start using this textbook until FEB 22.
    Beginning ASP.NET 3.5: In C# and VB by Imar Spaanjaars
    Wrox (Wiley)
    ISBN: 978-0-470-18759-3
    March 2008
    OFFICE HOURS: MW 1-2:30 MW 280E Melcher Hall
    or
    by appointment 713-743-4729
    GRADING: There is one in-class exam (WED MAR 21). There will also be a take-home exam 2 that will be distributed in class on MON APR 30 and be due FRI MAY 4 at 5:30 PM. All grading issues are handled in-person during office hours. Do not send e-mail to the instructor regarding any grading issue. Grades assigned for drops after WED FEB 1 (last day to drop without receiving a grade) will be based on your current class grade. If you have a failing grade at the time of the drop, you will receive an F otherwise a W.
    Exam 1 (in class WED MARCH 21) 40%
    Exam 2 (provided on the last data of class MON APR 30, due back FRI MAY 4 5:30PM) 60%
    See the assignments necessary for the final here
    DATE
    TOPIC
    WED JAN 18 Introduction to the Transaction Processing in the Client/Server Environment
    MON JAN 23 Traditional ASP and SQL -- Part I
    WED JAN 25 Traditional ASP and SQL -- Part II
    MON JAN 30 Server Processes: How your server accounts and SQLServer DSNs are created (word doc)
    Request Variables servar.asp (see asp code servvar.htm)
    Browser and screen resolution detection
    Object Models Overview (reference)
    Traditional asp template example ( source code)
    SQL Server and ADO Fundamentals ( reference)
    WED FEB 1
    WED FEB 1 Last Day to Drop without receiving a grade
    MON FEB 6 Traditional ASP Examples -- Column #1 only
    Connections and Recordsets for ASP here
    ODBC vbs OLEDB connections timings here
    WED FEB 8 Command Parameters (source) and Error Collection (source)
    Audit Controls
    MON FEB 13 Text File Processing (ASP example  --   source code here)
    Dave Whalen's Cookie FAQ
    Client-Side Cookie examples (write,read,kill in both VBScript and Javascript)
    Sample assignments
    WED FEB 15 XML in traditional ASP:
    The XML DTD
    Receiving and Displaying XML on the Client
    Creating XML on the Client (this is AJAX see here)
     . IE Example AJAX for GL Account Query
     . Cross Browser Example AJAX for GL Account Query
    Receiving and Creating XML on the Server
    Sending XML from the Server to the Client
    Boatwright & Higdon's Complete XML example
    Walking the XML tree
    Example AJAX for GL Account Query
    RSS Examples
    Family Cookbook (AJAX based)
    MON FEB 20 Execute glrestor.asp
    Get Source Code for glrestor.asp
    WED FEB 22 .NET Framework
    Visual Studio Introduction
    Simple ASPX Examples (see the C# and VB.NET columns)
    Installing IIS on XP Professional (here)
    Installing IIS on Vista (here)
    MON FEB 27 .NET Languages at MSDN
    VB.NET Language
    C# Language
    ASP.NET Pages
    WED FEB 29 Server Controls
    MON MAR 5 Web Forms I
    Client-to-server object references (postback) (here)
    WED MAR 7 Web Forms II
    Simple Data Controls (mis4372_ex1.aspx, source)
    Data Binding to Controls (also IsPostBack) (mis4372_ex3.aspx), source)
    MON - SAT MAR 12-17
    Spring Holidays
    MON MAR 19 Exam Review
    WED MAR 21 Exam 1 in class (scripting) Sample midterm exams:
    Fall 2011 Midterm, Spring 2011 Midterm, Fall 2010 Midterm, Fall 2009 Midterm, Spring 2009 Midterm, Fall 2008 Midterm, Spring 2008 Midterm, Fall 2007 Midterm, Fall 2000 Midterm, Fall 2001 Midterm, Fall 2002 Midterm, Fall 1999 Midterm, Spring 2001 Midterm, Spring 2002 Midterm
    MON MAR 26 Post Exam Review
    ADO/XML in .NET
    Data Binding
    WED MAR 28 Updating SQL in .NET
    XML in .NET
    Web Applications
    MON APR 2 Security Issues
    SQL Injections -- Part I (here)
    TUE APR 3 Last Day to Drop or Withdraw
    WED APR 4 Injections and other Nasties-- Part II (here)
    Regular Expressions
    A Simple Encrypt/Decrypt VBScript Security
    .NET Collections
    Server Controls
    Web Services
    MON APR 9 XML with MS Server 2000 Introduction
    FOR XML RAW
    FOR XML AUTO ELEMENTS
    WED APR 11 Portals, Frames, Ajax, Dashboards and Sharepoint
    MON APR 16 ASP PHP Comparison (here)
    Email using CDO (here)
    WED APR 18 Web Crawling (here)
    MON APR 23 OpenXML
    .net graphics
    COBIT (see MIS 4373)
    COSO/ERM and ITIL (see MIS 4373)
    WED APR 25 Exam Review
    MON APR 30 FINAL EXAM -- distributed in class
    Due back to Room 280E MH 5:30 PM FRI MAY 4

    Sample Exams:
    Spring 2012, Fall 2011, Spring 2011, Fall 2010, Spring 2010, Fall 2009, Spring 2009, Fall 2008, Spring 2008, Fall 2007, Spring 2007, Fall 2006, Spring 2006, Fall 2005 Final, Spring 2005, Fall 2004 Final -- Part 1, Fall 2004 Final -- Part 2, Fall 2003 Final -- Part 1, Fall 2003 Final -- Part 2, Spring 2003 Final -- Part 1, Fall 2002 Final -- Part 1, Fall 2002 Final -- Part 2, Spring 2002 Final -- Part 1, Spring 2002 Final -- Part 1 answer, Spring 2002 Final -- Part 2, Fall 2000 Final -- Part 1, Fall 2000 Final -- Part 2, Spring 1999 version 1, Spring 1999 version 2, Fall 1999 version 1, Fall 1999 version 2, Fall 1998, Spring 1998 version 1, Spring 1998 version 2, Spring 1998 version 3 Spring 1998 version 4

    		All assignments should be complete and ready for take-home exam

    Take-home Exam due back to the instructor's office (280E MH) by 5:30 PM FRI MAY 4

    IMPORTANT DATES
    WED FEB 1 Last Day to Drop a Class
    MON-SAT MAR 12-17 Spring Holiday
    WED MAR 28 Exam 1 (in class)
    TUE APR 3 Last Day to Drop without Receiving a grade
    MON APR 30 Exam 2 (handed out in class, returen by 5:30PM MAY 4)
    ADMINISTRATIVE NOTES
    • Course Evaluations
      The C.T. Bauer College of Business requires all its instructors to be evaluated by their students. The results of these evaluations are important to provide feedback to instructors on how their performance can be improved. We encourage students to provide feedback to instructors through the evaluation process.
    • Academic Honesty
      The University of Houston Academic Honesty Policy is strictly enforced by the C.T. Bauer College of Business. No violations of this policy will be tolerated in this course. A discussion of the policy is included in the University of Houston Student Handbook which can be downloaded here. Students are expected to be familiar with this policy. Specifically see pages 9-14. Pay particular attention to the list of behaviors that are considered academic dishonesty in Section 3.02 Academic Dishonesty Prohibited. Items (d) and (h) say:
      • (d) Representing as one’s own work the work of another without acknowledging the source (plagiarism). This would include submitting substantially identical laboratory reports or other materials in fulfillment of an assignment by two or more individuals, whether or not these used common data or other information, unless this has been specifically permitted by the instructor; [NOTE: I DO NOT PERMIT THIS]
      • (h) Using another’s laboratory results as one’s own, whether with or without the permission of the owner;
    • Accommodations for Students with Disabilities
      The C. T. Bauer College of Business would like to help students who have disabilities achieve their highest potential. To this end, in order to receive academic accommodations, students must register with the Center for Students with Disabilities (CSD) (telephone 713-743-5400), and present approved accommodation documentation to their instructors in a timely manner.