Exym, Inc.'s Activity Tracking System
Exym's mental health clinical management software is a hosted application built on ASP.NET 1.1 and MS SQL Server 2000. I work in a small team that's distributed across the continent - from California, to Idaho, and, of course, the Yukon. My role is to make changes and improvements in both the application code as well as the database structure and code.
www.itstraightup.com
IT conference site developed for Aasman Interactive in ASP.NET 2.0. The site's since been moved to another agency, but it had a delegate registration database with registration notifications conveyed to the conference adminstrators via an RSS feed, a secured admin app for sending out bulk notification e-mails to registrants, and a second secured section for speakers- and exhibitors-only content.
www.freequitpack.ca
Little one-page ASP.NET 2.0 registration database with e-mail notification that I programmed from Aasman Interactive's design.
Web Services Provisioning Tool - Northwestel Intranet
When Northwestel got into the web hosting business, they needed an easy-to-use, custom tool for provisioning those services on two separate vendors' systems. The web provisioning tool is an ASP.NET app utilizing SOAP and XML-over-HTTP-POST web services, and includes auditing support to help reconcile vendor bills with the actual provisioning performed via the app. Very kewl, very fun app to build (despite a flaky web services API).
Northwestel's Corporate Web Site
I had the pleasure of working with Aasman Interactive in building a previous version of this site. They supplied the information architecture and XHTML/CSS design, then I took care of implementing it in JSP and Oracle, and integrating it with Contribute content-management support.
Some of the more interesting features of that site included:
  • Order forms - Customer orders for services were accepted and stored in a database. Service representatives could then access those orders via an ASP.NET app on the company intranet. A vast improvement over the old, e-mail based system (some orders were being marked as spam and being thrown out! Yikes!)
  • Scholarship application - Students could create and manage their scholarship application across sessions. Applications were stored in the database until they were explicitly submitted, at which time they were accessible to the appropriate employee(s) via an ASP.NET intranet app.
  • Corporate news releases - Kind of the inverse of the above two examples. Employee(s) posted news release via an intranet app, which were then displayed on the external site, and were searchable as well.
  • Service availability tool - Customers could select their community and see what services were available to them.
  • DSL usage tool - Customers logged in using their account number and a PIN number and could then view how much bandwidth they'd used on their DSL account.
CLLI Administration Application - Northwestel Intranet
COMMON LANGUAGE Location Codes (CLLI Codes - pronounced 'silly' - and yes, i've heard much silliness about CLLI codes) are a major part of most applications at any telecom company, as they're used to identify network locations and the equipment within them, from transmission towers to network switches.
It didn't take long to realize that the web apps we were building would need a central, authoritative source for CLLI data, and the CLLI Admin app fills this role. Whereas the CLLI code manager used to keep a very large spreadsheet of data and e-mail updated versions on a monthly basis, he can now employ an easy-to-use web app to maintain the data, and consumers of the CLLI data can simply access the site and search/lookup the info they need. On top of that, future web apps can leverage the existing data, instead of creating and maintaining their own, specific subset.
Controlled Maintenance Plan and Repair & Return - Northwestel Intranet
A couple fairly complex applications for the Network Operations team. CMP is used for managing and monitoring maintenance procedures at network locations, and R & R is for generating and tracking repair service orders and their associated spares inventory. These two apps use the CLLI data described above, and, like all the applications I helped build for Northwestel's intranet, they authenticate via the user's Windows network login, so there's no need to re-log-in, nor maintain login data for each individual app. CMP uses local groups on the web server for authorization, and R & R uses role-based authorization, the user-role mappings being stored in it's database.
www.ckrw.com
My very first ASP.NET site! (Unfortunately, parts of the site have fallen into disuse and disrepair over the years.) There's still a 'registered users only' section that uses forms-based authentication and an Access database. Users gain access to premium pages when they register themselves with a valid email address. The polls, coming events, business listings and Trader Time sections have database-based administrative web applications that let station staff maintain the content for those sections. A similar admin app is used to enter ads for the site. I custom-built an ad management system that can use either impressions, clicks or a date range to determine when ads expire.
www.hougenGroup.com
This site uses an XML file for it's side menu. The menu is dynamically generated and specific links are highlighted and disabled depending on the current page being viewed. Maintenance is much easier since an XML record just needs to be added/changed and the code takes care of the rest. (In retrospect, it's a lot like the site map XML file in ASP.NET 2.0....hmmmm...) Another neat feature is the search function. The standard search examples that come with the Indexing Service/IIS just weren't cutting the mustard, so I created my own search and results display functionality. It uses ADO.NET to interface with the search catalog and a 'standard' SQL query to find and display results.
www.yukonHonda.com
Yukon Honda staff have full control of the 4 Specials sections as well as the Used For Sale section in the Sales area. The nice thing about this admin app is that the user can upload photos directly from digital camera to the web site without having to do any resizing, cropping or FTPing. Thumbnails and 'blow-ups' are generated in the proper size, on the fly!