Dematic QQT Administration

This is the first .Net project I worked on, using C#.Net and MS SQL Server 2000. The Quick Quote Tool (QQT) is used by Dematic’s sales team for producing on-site project quotes, uploading those quotes to a central server, and managing those project quotes through a web-based application hosted on their intranet. This project comprised three parts: the web administration (written by me), a desktop application and web service (written by my coworker). The web administration consists of six interfaces: Projects, Input Properties, Products, Technicians, Zipcodes, and Report Definition. The Report Definition interface was written by a coworker to create the reports used by the desktop application.

The Projects interface lists all the active projects that have been uploaded onto the central server. From here an administrator can view individual project reports, print those reports, and reprint the documentation for a given project.

The Products and Technicians interfaces make heavy use of the Gridview and Detail View controls. The upper table shows an overview of all products currently in the system. The lower-left Detail View shows the details for the selected product. Each product is made up of components, the component overview is shown by the Gridview in the lower-middle; while the lower-right Detail View shows the details for the selected component.

The Technician page is similar with a summary of all technicians in the upper Gridview, details shown by the Details View in the lower-left. Each Technician has training on certain products, which are listed in the lower-middle Gridview. The lower-right list shows all the products not currently assigned to the selected technician. As a product is assigned or unassigned the list adjusts to reflect appropriately.

Dematic uses zipcodes to calculate travel distances, with the zipcode lists periodically updated. This simple upload page takes an uploaded CSV file containing all the zipcodes and updates the zipcode table in the database.