1 / 39

Experience

Experience. Coding Reporting Utilities. Coding. Desktop C# 5 years Web-based ASP.NET (C#) 5 years ASP.Classic (VB) 2+ years PHP 3+ years HTML5 1 year. Examples. Desktop A utility for converting Unix Time (seconds from 1 Jan 1970) to a standard time format

lexiss
Download Presentation

Experience

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Experience Coding Reporting Utilities

  2. Coding • Desktop • C# • 5 years • Web-based • ASP.NET (C#) • 5 years • ASP.Classic (VB) • 2+ years • PHP • 3+ years • HTML5 • 1 year

  3. Examples • Desktop • A utility for converting Unix Time (seconds from 1 Jan 1970) to a standard time format • Reason: To display data accessing a MySQL database where the timestamps were in Unix time, to a more user-friendly format

  4. Examples • Web-Based • A utility for uploading documents for student reference and which accompany courseware presentations • Reason: To enable management to efficiently add/edit courseware reference in database and to upload documentation

  5. Reporting • PHP w/ MySQL • Our Learning Management System (LMS) uses PHP w/ MySQL, housed on an IIS7 server • C#.NET (.NET 4.0) w/ SQL and MySQL • C# uses MySQLDriverCS.dll to communicate with MySQL databases on the LMS • In-house apps/pages are developed in C#.NET (Older apps were done in ASP.Classic w/ MS Access.)

  6. Reporting • PHP/MySQL • Class Performance • Tracks average time spent on courseware and the average grade for each test/exam per class • Filtering • Per Class • Technologies • PHP5 • MySQL5.1 • Software • MySQL Workbench • PHPMyAdmin • Notepad++

  7. Class Performance

  8. Class Performance

  9. Class Performance • Code Sample • SQL String and form display (excerpt)

  10. Reporting • Inventory Activity • Tracks download of courseware from LMS site • To ensure that only validated users have access to those courses • Filters • Every column • Can filter out or filter for • Can have multiple filters • Technologies • C#.NET • MS SQL

  11. Inventory Activity • Software • MS Visual Studio 2010 • SQL Server 2008

  12. Inventory Activity

  13. Inventory Activity • Code Samples • From AJAX, for filtering (excerpt)

  14. Inventory Activity • Code Samples • Filters for SQL query (excerpt)

  15. Inventory Activity • Code Samples • SQL query

  16. Inventory Activity • Code Samples • Table builder (excerpt)

  17. Student Performance • Tracks time spent on each lesson per student • Filters • Student name • Course • Technologies • C#.NET • MySQL • MySQL instead of MS SQL because LMS uses MySQL • Software • MS Visual Studio 2010 • MySQLDriverCS.dll

  18. Student Performance

  19. Student Performance • Code Samples • MySQL query

  20. Student Performance • Code Samples • Filters from AJAX (excerpt)

  21. Reporting • Section of AJAX code used by various reports

  22. Reporting • SQL stored procedures (SProcs) • Used for our in-house CBT authoring application • Database integrity, preventing SQL Injection • Organization of SQL statements into one area (as opposed to have query statements all throughout)

  23. SQL SProcs • Get Page Object by Object Location • Returns recordsets from multiple tables to display which pages are using a particular media file (narration, video, Flash). • This is used in conjunction with other SProcs for the purpose of page deletion

  24. Get Page Object by Object Location • SELECT statement (excerpt)

  25. Get Page Object by Object Location • If/Else statement (excerpt)

  26. SQL Sprocs • Search Replace text • Searches for and (if chosen in interface) replaces text found anywhere in the entire course • Search also in narration script, image alt tags, as well as instructor notes (notes used by instructor if lesson is a classroom presentation)

  27. Search Replace text • Search portion

  28. Search Replace text • Replace portion

  29. SQL Sprocs • Copy SCO • “SCO” is an e-learning term (based on the SCORM model) which denotes a chapter or section • Copies every recordset from a particular SCO, within several tables (including task notes and objectives) ..\copySCO.txt

  30. Utilities • Web-based, data-driven utilities used for in-house tasks • C#.NET and MS SQL • GUI • Console

  31. Utilities • TimeOff Tracker • Used by both employees and management to record and track employees’ approved time off • Technologies • C#.NET • MS SQL • Software • Visual Studio 2010 • MS SQL Management Server

  32. TimeOff Tracker • Time off input

  33. TimeOff Tracker • Report

  34. TimeOff Tracker • Code Samples • Parameterized Statements (excerpt)

  35. Utilities • Graphics Renamer • Console App • Renames all graphics’ names in a course with current course number • As the USAF syllabi change, so do course numbers

  36. Graphics Renamer • Code Samples • SQL String

  37. Graphics Renamer • Code Samples • Console input/output (excerpt)

  38. Epilogue • Crystal Reports Have downloaded trial of Crystal Reports and am currently learning the interface.

More Related