Database and Innovative Software in the Community (DISC )

Database and Innovative Software in the Community (DISC) Design Review October 9th, 2011 ARMS 1098B 1

Agenda • The How & Why of the Project • Our Team’s Progress • A Live Demo • Plans for Future Teams 2

Our Project Partner • The Tippecanoe County Probation Office • Manages parolees in Tippecanoe county • Tracks parolees as they complete their sentence • Keeps records of current/past parolees 3

Their Needs • An accessible way to store probation records • A simple way to create/update records • An easy way to print standard reports • A system that is highly secure 4

Judicial Database Systems (JDS) 5

Project Background • Project commissioned by Tippecanoe County Probation Department • Previous system was delivered in 2002 based on Microsoft Access • New version requested in 2005 • Current design proposed in 2009 6

Design Requirements • Training requirements of parole officers require new system to be similar to the old system • Some requests made to improve business logic in specific ways • Must work with Probation Department’s software • Windows Server, ASP.NET, IIS, Microsoft SQL Server • Support Firefox 3 and up, as well as IE 7 and up 7

JDS’s Current Design Front End Middle Back End SSL SQL ADO .NET Microsoft Internet Information Server (IIS) MySQL C# Web Service JDS- C# GUI Client Port 443 ASP .NET 8

What was already done • Server backed mostly finished • Code already complete • 3 tabs mostly completed • Security • User authentication • SSL encryption 9

Project Progress • All Tabs are now Functional • Completed every tab • Tabs account for most major functionality • Reporting is now working • Several Bugs have been fixed 10

Drugscreen Tab • One of the most used tabs • One of the first we completed • Now Updates Correctly • Corrected the paging System 11

Receipts Tab • Updated to Meet New Standards • New GUI was created • Functionality implemented • Field are now formated • Receipts is Now Linked to Profile Tab 12

Probation & Terms Tab • Completely Redid the GUI • Functionality Completed 13

Reports Tab • 19 Different Reports Now Printable • Prints in PDF format • Minor GUI Changes 14

Mail Merge • Need to be Fixed at the Semester’s Start • One of the most commonly used/important features • Uses Database Fields to Create a Word Document 15

Delete • Project Originally Had No Way to Delete Records • Delete does a hard Delete of Database Records • Requires Multiple Confirmations • Avoids unintentional deletion • Has Error Reporting in Case of Failure 16

Minor Changes/Bug Fixes • Case Notes Changed to be More User Friendly • Search Now Checks All Fields • Power-User Privilege Removed 17

Project Demo

Discussion of future plans • Continue With Bug Fixes • Perform a test Delivery • Ensues smooth delivery process • Ensure the Project is Secure • Deliver to Project Partner • Maintain Project Through Beta 19

Project Timeline • Week 1- 3, Final Prep • Bug Testing • Implement Error Report Tab • Week 4- 8, Planning/Delivery • Purchase SSL Certificate • Practice/Perform Delivery • Week 9-15, Service • Debug using partner feedback 20

Questions? 21

Database and Innovative Software in the Community (DISC )