Capt. Horatio T.P. Webb |
Parks -- Fall 2019 Version 1 -- Last Updated 4:05 PM 8/15/2019 |
|
NOTICES:
|
||
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 7
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: | 1-2:30 MON and WED, 280E Melcher Hall or by appointment 713-743-4729 |
|
GRADING: |
|
|
Exam 1 (in class WED OCT 23) | 40% | |
Exam 2 (provided on MON NOV 11, due back MON NOV 25 at 5:30PM) | 60% | |
See the programming assignments necessary for the final here | ||
|
|
|
MON AUG 19 | Introduction to the Transaction Processing in the Client/Server Environment
Traditional ASP and SQL -- Part I The great ideas were done by these people |
In-class scripting examples: |
WED AUG 21 | Traditional ASP and SQL -- Part II | |
MON AUG 26 |
Server Processes: How your server accounts and SQLServer DSNs are created
(word doc)
Request Variables servar.asp (see asp code servvar.htm) Getting client data into the server-side program |
|
WED AUG 28 |
Browser and screen resolution detection
Object Models Overview (reference) Traditional state maintenance asp template example ( source code) | |
MON SEP 2 | Labor Day Holiday | |
WED SEP 4 | Database History, Nuances and Scale SQL Server and ADO Fundamentals (CRUD (Create, Read, Update, Delete) SQL reference) Your Exam Databases: Execute glrestor.asp Get Source Code for glrestor.asp |
|
MON SEP 9 | Traditional ASP Scripting Examples -- Column #1 only | |
WED SEP 11 | Connections and Recordsets for ASP here
ODBC vbs OLEDB connections timings here Command Parameters (source) Error Collection (source) Creating pages on-the-fly |
|
MON SEP 16 |
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 18 | Sample assignments
Javascript Frameworks Comparisons |
|
MON SEP 23 |
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 25 |
Walking the XML tree
Example AJAX for GL Account Query RSS Examples Family Cookbook (AJAX based) |
|
MON SEP 30 | Control breaks | |
WED OCT 2 | Regular Expressions
A Simple Encrypt/Decrypt VBScript Security (same in javascript) |
|
MON OCT 7 | .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) Inline code, Code-Behind (or this), Model-View-Controller .NET Languages at MSDN VB.NET Language C# Language ASP.NET Pages |
|
WED OCT 9 | 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 14 |
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 16 |
.NET Collections
Server Controls Web Services ADO/XML in .NET Data Binding SQL Injections -- Part I (here) |
|
MON OCT 21 | Midterm Exam Review | |
WED OCT 23 | MIDTERM EXAM (scripting topics) Sample Midterm Exams: 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 OCT 28 | Post Midterm Exam Review Injections and other Nasties-- Part II (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 OCT 30 |
Email |
|
MON NOV 4 | Web Crawling (here) | |
WED NOV 6 |
.net graphics |
|
MON NOV 11 | HTML 5: Canvas (Basics, Graphs, Dashboards, Slide Shows, range (sliders); new input types | |
WED NOV 13 |
HTML 5:
video; borders;
progress and meter.
DUE MON APR 29 5:30 PM |
|
MON NOV 18 |
Cloud Responsive Design Web Services and Dashboards II |
|
WED NOV 20 | 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 |
|
MON NOV 25 |
EXAM 2 Due in class 5:30 PM MON NOV 25 Sample Exams: 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 |
|
MON AUG 26 | Last Day to Add a Class | |
WED SEP 4 | Last Day to Drop or Withdraw without receiving a grade | |
WED OCT 23 | Exam 1 in class | |
THU OCT 31 | Last Day to Drop a Class | |
MON NOV 25 | Take Home Exam 2 due 5:30 PM. Last Day of Class | |
|