WebSpaceFactory Content Management System has evolved from a ASP.NET 1.1/SQL 2000 application into a full blown custom ASP.NET 2.0/SQL 2005 simple, high performance web site management system.
This product targets small business owners that need a simple, professional, and self maintainable web presence.

This is a help desk service ticket application in which the help desk tech logs the work they perform (via phone, email, or office visit) and categorizes the work based attributes that the help desk administrator(s) can define. Help desk techs can view there tickets by status and search all tickets by customer (name, fhsuid, email and/or phone), date range and/or ticket (status, duration, category, assigned tech, and/or service type). Techs have a "quick view" of all of their open tickets and can quickly browse other techs ticket queue. Help desk administrators can create/edit/delete/inactivate users and create/edit/delete/inactivate all ticket attributes. Also, help desk administrator(s) can view ticket status on any or all customer and/or ticket attributes as well as by date range.
This application is based on the ASP.NET 1.1 framework and was moved from SQL Server 2000 to Sql Server 2005. It is planned to be upgraded to the ASP.NET 2.0 framework. This application was completed in a 2 month timeframe with only a single developer doing the .NET and Sql Server coding.

This application helps integrates into the FHSU Single Sign On intiative. Users can login to this web site and setup their userid and password for systems that utilize the Single Sign On creditials such as email, portal, Blackboard, samba, etc.
Once the user authenticates via information in the student information system, they can set their password, set password recovery questions,receive a list of systems in which their credentials work, and perform a password recovery (real time).
In addition, Single Sign On administrators can login to this site and search for users based on name and/or FHSU ID. Single Sign On administrators can assign access to different user roles to determine how much information the authenticated user can access from the system.
This system is built on ASP.NET 2.0 from the ground up using an enterprise directory server (based on LDAP) and SQL Server 2005 for the data stores. This application was built and put into production in 2 weeks (with Sql Server backend) and live with a newly installed LDAP directory server 2 weeks later... there was only one developer on this project (and I was the only LDAP administrator bringing up a brand new LDAP directory server during that time frame :)

The Ebilling Email Notification program was needing for taking a billing data extract from the Oracle based JDEdwards based billing system and import the into a separate SQL Server db with the purpose of generating e-mails to notify telecommunications customers that their online bill was ready. The system was needed to keep a history of all emails sent as well as generate marketing messages to target customers in different areas and/or with different telecomm services.
The

IT user would import the data and create the billing cycle run. Marketing user would then select billing cycle run and assign subject, header, and footer information that shows on every email. Then, the Marketing user could add custom messages based on any combination of location and services of the customer. After the Marketing user is done, the IT user could preview the messages before sending, then send the messages if all is good.

The system easily handles sending as many as 10,000 emails in one session.

The county appraiser’s Office use the CAMA system for recording the assessed and appraised property values. Approx 6 counties have contracted with us to extract and host their data on an AS/400 in our data center. We needed to move the data store from the AS/400 DB/400 to SQL Server 2000. This required a rewrite of the current data transfer program that was COBOL/CL solution to a Java/.NET Web service solution.

This project solution required writing a 4 piece solution:

1. AS/400 Java and CL Client to Generate XML and Consume a Web Service
2. Web Service to Archive export files
3. WinForms application to do a bulk insert into SQL Server data base
4. Rewrite existing ASP 3.0 web interface to use new SQL Server data source

The Ellis county Treasury department wanted to have the ability to search and display county real estate taxes online. The requirements were to build a search engine for real estate taxes and display the tax and property details for the web. The site was developed in ASP.NET and used their existing AS/400 (DB2/400) tables for the backend.

Wrote a Visual Basic 6 program that would let our team view programs and work files and create save files on the AS/400 host. The deployment data was kept in an access 2000 database keeping track of source, programs, and files sent to which clients and when they were sent.

Wrote the AS/400 client software (written in COBOL and Control Language) that would check an ftp site for updates that were posted on a weekly basis. The updates were downloaded, restored, and then deleted from the site. The client would send the restore job log back to the ftp site where the log was collected, parsed and put into an Access 2000 database. Crystal Reports was then used to generate custom reports of the status of updates and which programs were installed by date. The Crystal Reports were integrated in to the VB application.

Sunflower Mfg Inc is an implement manufacturer that needed to ‘web-enable’ their notifications to their parts suppliers of outstanding orders placed and forecasted orders for parts. The solution involved taking their inventory data from their Iseries(AS/400) and importing that data into an existing Sql Server database that was already being used in their current web site. The web interface was extended for the parts vendors to login and view ordered and forecasted parts invoices.

Nex-Tech - Rural Telephone was in need of a custom content management solution for their website(s). Working on the second release of the content management engine, we were able to achieve the flexibility they required for their very dynamic content. The content management engine was extented to roll out to some of their partner communities in Kansas.
This solution is an ASP.NET 1.1 / SQL Server 2000 application that was designed in n-tier fashion - UI - Business Logic Layer - Data Access Layer. Many custom web UI controls were authored for this project.