Purpose: Develop tool for staff to use to prepare solicitation letters to prospects who have received traffic tickets. Data arrives in CSV format and is uploaded to existing db.
Already Completed: Head attorney for firm is a former ASP programmer and has written a basic VB6 app to upload the data to the MSSQLExpress server. DB triggers have already been written to put the data in the correct tables. An intranet site has been setup (on the same machine as the SQLServer), templates developed etc in Dreamweaver MX.
Scope of Work: Develop ASP or ASP.NET web front end for data entry and data retrieval for staff use (ie. user friendly). It should integrate with MS Word 2000's mailmerge feature so that the user can select the letter to be used for a particular criminal charge. Additionally we will need to print envelopes from the same mailmerge. Each day's campaign will be a new marketing campaign. The SQL query for the various mailmerges will only pull traffic tickets which are 21 days prior to trial date AND do not already have a marketing campaign associated with the record. When a prospect has been sent a letter, we will give the prospect a marketing campaign id. This will be fairly evident when you see the data structure.
Once letters have been snail-mailed, prospects will hopefully call us. We need a way to find that prospect in the db, see the criminal charges and contact info for the prospect, and the ability to mark in the campaign table if the prospect has hired us. Additionally, we need to convert prospect to client in our [url removed, login to view] table (a lookup table).
Finally, we need to some basic reports for management purposes so that I can send my attorneys to the correct court (by county) to handle the tickets on a particular day. Phase 2 would have a way for the attorney or staff to enter the disposition of the ticket into the db. Phase 3 would be an export of new client to Quickbooks via their API.
Here are the list items on the website for application tasks.
Upload File from [url removed, login to view]
Create Form Letters for all traffic tickets except DWI
Create Form Letters for DWI
Create Marketing Campaign
Mark Tickets as Processed
Code Requirements: Code needs to be written in ASP (preferred) or ASP.NET 2.0. Code MUST Be documented in English and block formatted. Code should be as efficient as possible and have proper error handling. Include files or the ASP.Net equivalent should be used when possible to minimize code changes and web design changes. I would like the files to be readily transferable from web server to web server without having to load COM objects or special DLLs or having custom web server configuration files.
Data Structure: To be shared upon request.
Security: This is an internal application. Ideally, it uses MS Domain security (ie. Integrated Windows Security). In connection setup, I would like advice on a secure way to hide db connection passwords as I never understood that very well.
This application will eventually be integrated with a contact management tool which uses the same db tables etc. Data structure is already in place.
I am paying a monthly fee for the data stream of traffic violations so I would like to get letters out very soon to start recouping my costs.
The developer will be working on a development server set in the DMZ of my network. If developer is using ASP.Net, then developer will need to configure web server for .Net. Latest .Net service packs are already installed.
Access will be via remote desktop connection.
Payment: I got burned by the previous service provider whom I paid half the money and he did nothing for 2 months (even though he was a toprated provider). Therefore, payment will not be released until work is done.