Channels ▼
RSS

.NET

Automating Applications On-the-Fly

Source Code Accompanies This Article. Download It Now.


Drew is Chief Technology Officer for Selection.com. He can be contacted at drew@ctd.com.


I run the IT department for a preemployment screening company. Like most other developers, I am always trying to get the most work out of a limited amount of resources, whether that involves time, budget, or development staff. How many times have you been faced with a project whose requirements can be accomplished using a third-party tool, but you just don't know whether the cost of the tool justifies the time savings? If you're like me, this situation is very common. And also like me, I'm sure you've had both positive and negative experiences with either option. We recently had a business problem that warranted using a third-party component and, I'm happy to say, it was able to meet and exceed our expectations.

The Problem

We offer clients a database screening (background check) that is made up of various federal, state, and county criminal record repositories. We purchase this information from our vendor by using their web service to make a request on behalf of our clients. The vendor maintains over 300 million records belonging to several hundred repositories. These repositories are constantly changing as new states/counties are added and others are removed or their content restricted or expanded. When a customer executes a search, they typically want to know if a particular repository was included in that search. For example, if your applicant's address is in, say, Fresno, California, and he has lived there for many years, you would probably like to know whether the Fresno County Court was included in your database search. We maintain a PDF document that contains the record sources and make it available online. Until recently, the maintenance of this document was handled by one of our operations personnel who verified the sources we claimed versus the sources the vendor claimed. If there were differences, they were fixed in our document, then redeployed back to the web site; see Figure 1.

[Click image to view at full size]

Figure 1: Manual workflow.

If a client had questions about which sources were being searched when a request was made, they could go to a Sources.aspx page that would load and display the PDF document. This workflow was fine when there were only a few changes a month, but as more sources became available from our vendor, maintaining this document became an hourly job and the employee started to fall behind on other work. Customers were getting upset because they felt the report they requested wasn't searching all available jurisdictions when, even though it was searching everything available, the source list didn't reference them. Additionally, by not listing the most current sources for our information, clients were beginning to think our product wasn't competitive.


Related Reading


More Insights






Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

 
Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.
 

Video