capt webb pc
TRANSACTION PROCESSING II
Parks          Archive 2022

MIS 4372

NOTICES:
  • Midterm Exam Answers here
  • Previous Lectures:
    1. Follow the directions at the following link on how to login to your Office 365 account:
        http://uh.edu/infotech/services/office365/how-to-login/
       This will lead you to the homepage of Office 365.
    2. Once you are logged in, follow the following link:
        H_20213_MIS_4372_10224 - Videos | Microsoft Stream
  • Get the web.config file onto your account. See the first row of this code documentation page for instructions.
  • To download Visual Studio 2019 Community Version → http://www.visualstudio.com/downloads/
          Click the blue "Free Download" button in the left hand side gray panel,
          in the window that appears at the bottom of your page, click the "Run" button to execute the installer
             "vs_community__... .exe". This will take a while to download.
          Uninstall any older or other versions of Visual Studio
  • Your Resume needs to 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 -- Click here for setup instructions
  • Assignments will only be evaluated on the final exam.
  • Career Planning and Interviewing:
             30 Second Elevator Speech
             Behavioral Interview Questions
             Star (Situation, Task, Action, Result) (aka PAR (Problem, Action, Result) )
  • Writing Letters
Music & Videos - click ↓ 
COURSE SUMMARY: This course is the second part of a two course sequence on transaction processing in the client-server environment. This second course concentrates on server-side processes involving submission and processing transaction information across the Internet. The primary technologies employed are: HTML5, XML, XSL, WSH, Microsoft's Visual Studio and ASP.NET 4.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 4.5 and Visual Studio technologies.
TEXTS: We will not start using this textbook until MON OCT 11
Beginning ASP.NET 4.5.1: In C# and VB (or later edition) by Imar Spaanjaars
Wrox (Wiley)
ISBN-13: 978-1118846773 ISBN-10: 111884677X
2014
OFFICE HOURS: by appointment email: parks@uh.edu
GRADING:
  1. There is one in-class exam (WED OCT 27).
  2. There is a take-home Exam 2 that will be distributed in class on MON NOV 22 and be due WED DEC 1 at 5:30 PM.
All grading issues are handled in-person on video by appointment. Grades assigned for drops after WED SEP 8 (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.
Midterm Exam (scheduled online during regular class time WED OCT 27 40%
Exam 2 (provided on MON NOV 22, due back WED DEC 1 at 5:30 PM) 60%
See the programming assignments necessary for the final here
DATE
TOPIC
MON AUG 23 . Introduction to the Transaction Processing in the Client/Server Environment
.  Traditional ASP and SQL -- Part I
. The Client-Server Model
.  The great ideas were done by these people		 In-class scripting examples:
WED AUG 25 . Traditional ASP and SQL -- Part II
MON AUG 30 . Server Processes: How your server accounts and SQLServer DSNs are created (MS Word document)
. Request Variables servar.asp (see asp code servvar.htm)
. Getting client data into the server-side program
. Browser and screen resolution detection
 
MON AUG 30 Last Day To Add A Class
WED SEP 1 . Object Models Overview (reference)
. Traditional state maintenance asp template example ( source code)
. Database History, Nuances and Scale
. SQL Server and ADO Fundamentals
    (CRUD (Create, Read, Update, Delete) SQL reference)
MON SEP 6
LABOR DAY Holiday
NO ONLINE CLASS
WED SEP 8 . Your Exam Databases:
    . Execute glrestor.asp
    . Get Source Code for glrestor.asp

.  CODE PAGE -- ASP / VB.NET / c# / PHP EXAMPLES

WED SEP 8 -- Last Day to Drop without receiving a grade
MON SEP 13. Connections and Recordsets for ASP here
. ODBC vbs OLEDB connections timings here
WED SEP 15 . Command Parameters (source)
. Error Collection (source)
. Creating pages on-the-fly
MON SEP 20 . 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)
WED SEP 22 . Sample assignments
.  Javascript Frameworks Comparisons
MON SEP 27 . 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
WED SEP 29 . Walking the XML tree
. Example AJAX for GL Account Query
. RSS Examples
. Family Cookbook (AJAX based)
MON OCT 4 . Control breaks
WED OCT 6 . Regular Expressions
. A Simple Encrypt/Decrypt VBScript Security (same in javascript) 		 
MON OCT 11 . .NET Framework
. Visual Studio Introduction (here)
.  Execute A Simple ASPX Example (source code here)
.  Examples (see the C# and VB.NET columns)
.  Inline code, Code-Behind (or this), Model-View-Controller
. .NET Languages at MSDN
. VB.NET Language
. C# Language 		 
WED OCT 13 . Server Controls
. Web Forms I
.  Client-to-server object references (postback) (here)
. Web Forms II
. Simple Data Controls (mis4372_ex1.aspx, source)
.  Data Binding to Controls (also IsPostBack) (mis4372_ex3.aspx), source)
.  Connecting Events to Server-Side Code 		 
MON OCT 18  .  Web Services:
     . Gauge Maker Version 2.1
     . Separation Anxiety Puzzle Game Version 1.7
     . Button Maker Version 2
     . Consuming a Web Service: Weather Station Version 2 		 
WED OCT 20 . .NET Collections
. Server Controls
. Web Services
. ADO/XML in .NET
. Data Binding
MON OCT 25 . Midterm Exam Review  
WED OCT 27 MIDTERM EXAM
Previous Midterm Exams:
Fall 2021 and answers, Spring 2021 and answers, Spring 2019 and answers, Fall 2018 and Answers, Spring 2018 and answers, Fall 2017 and answers, Spring 2017 and answers, Fall 2016 and answers, Spring 2016 (later s1672mb.htm) and answers, Spring 2016 (early s1672ma.htm) and answers, Fall 2015 and answers, Spring 2015 Midterm and Answers, Fall 2014 Midterm and Answers, Spring 2014 Midterm and answers, Fall 2013 Midterm and answers, Spring 2013 Midterm and answers, Fall 2012 Midterm (answers), Summer 2012 Midterm, Spring 2012 Midterm, 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 NOV 1 POST MIDTERM EXAM REVIEW  
WED NOV 3 . SQL Injections -- Part I (here)
THU NOV 4 is the Last Day to Drop
  
MON NOV 8 . Injections and other Nasties-- Part II (here)
.  email
. ASP-PHP Comparison (here)
. XML with MS Server
.  FOR XML RAW
.  FOR XML AUTO ELEMENTS
. Tamino by softwareAG
. Portals, Frames, Ajax, Dashboards and Sharepoint
. Dashboard Navigation Template
. ASP-PHP Comparison (here)

 
WED NOV 10 .  .net graphics
. Web Crawling (here) 		 
MON NOV 15 . HTML 5:
. Canvas (Basics, Graphs, Dashboards, Slide Shows)
.  range (sliders);
.  new input types
. video
. borders
. progress and meter 		 
WED NOV 17 . Cloud
. Responsive Design
.  Web Services and Dashboards II 		 
MON NOV 22 .  Audit Controls
. COBIT (see MIS 4373)
. COSO/ERM and ITIL (see MIS 4373)
. Server-Side Bots and Spiders (here and here)
. Creating Excel on the server
. JSON
. Bauer IP

TAKE HOME EXAM 2 DISTRIBUTED to you by email
DUE WED DEC 1 5:30 PM
  
WED NOV 24
THANKSGIVING HOLIDAY WED NOV 24 thru SAT NOV 27
MON NOV 29 . Exam 2 Live Debugging Session
WED DEC 1 .  Take Home Exam 2 Due via email by 5:30 PM WED DEC 1
.  Sample Exams:
Spring 2020, Fall 2019, Spring 2019, Fall 2018, Spring 2018, Fall 2017, Spring 2017, Fall 2016, Spring 2016, Fall 2015, Spring 2015, Fall 2014, Spring 2014, Fall 2013, Spring 2013, Fall 2012, Summer 2012, 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 		 
IMPORTANT DATES
MON AUG 30 Last Day to Add a Class
MON SEP 6LABOR DAY HOLIDAY
WED SEP 8 Last Day to Drop a Class without receiving a grade
WED OCT 13 Exam 1 (during regularly scheduled class time)
THU NOV 4 Last Day to Drop a Class
WED NOV 24 - SAT NOV 27 THANKSGIVING HOLIDAY
WED DEC 1 Exam 2 due in class 4:00 PM (during regularly scheduled class time)
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 seen here. Students are expected to be familiar with this policy. Pay particular attention to the list of behaviors that are considered academic dishonesty in Section 3.02 Academic Dishonesty Prohibited. Items (a) and (h) say:
    • (a) 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 JOINT WORK]
    • (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) 713-743-5400, and present approved accommodation documentation to their instructors in a timely manner.

COVID-19 SYLLABUS SUPPLEMENT