VFB Load Browse allows the user to access detail drilldown capabilities without leaving the browse form. AJAX enabled pages update content as the user steps back to the previous form.

The VFB application manages the movement of freight from origin (shipper) to destination (consignee). For example, a broker can use VFB to enter and track the details of a load that needs to be moved across the country. The broker can also use the custom tools built into the application to identify a carrier to haul the load.

VFB maintains information about customers, shippers, consignees, carriers, equipment, services, messages, and various other entities. Users enter new and recurring freight loads into VFB early in the morning. Next, dispatchers begin matching customer loads with carriers using various tools within VFB. Dispatchers negotiate specific rates with each individual carrier in order to make a profit on the load. Loads have various characteristics that can be used to manage them through the entire transportation cycle. Application users can set these in VFB or VFB will do this automatically. After loads are completed, they still have value; this trait allows VFB to recompile load details in order to help the users match loads with carriers.

It is very important for each freight broker to navigate and query the data within VFB. Profitability is determined by the team’s ability to handle a large number of loads in a short period of time.

The VFB application was ported from a legacy Windows desktop application, and our customers expect the same ease-of-use. Incorporating newer technology such as Iron Speed Designer and compatible third-party tools allowed me to create a new VFB application that meets and exceeds the flexibility of the original desktop app. With the openness of Iron Speed Designer’s framework, I was able to implement these new technologies with little effort.

The standard Iron Speed Designer generated forms were used without any modifications throughout the application.

The size of the database, number of web pages, users per application month, and transactions per month vary greatly depending on the particular customer using VFB. Supporting tables such as carriers has as many as ten thousand records however the primary load table could maintain one hundred thousand records and more depending on the amount of activity over a period of years.

Generally, the application accesses one Microsoft SQL Server database per customer. There are situations where this could be more than one. The application uses 35+ database tables and approximately 200+ web pages. Both of these entities continue to grow each month as additional functionality is added to the application.

In the Carrier Add/Edit forms data and data tables were grouped into related tabs.

With an implementation team of three (one Developer and two Testers), the VFB application took a total of eight months to get to pre-production stage. I spent a majority of my development time going through the application and trying different things, implementing custom code extensions, deciding which third-party tools to integrate, and learning the best ways to implement different functionality.

Filtering forms allow compound filtering of load detail. Since the load browse form is AJAX enabled the form is updated without the usual post back form flash.

I created various overrides to implement custom code within specific table and record controls. I also write a lot of custom JavaScript on the client-side, making the application work for them. Integrating third-party tools, including Infragistics, ActiveReports, and AJAX was straight forward once an understanding of the framework is achieved.

The time saved in automatically generating SQL statements in one click alone is immeasurable. If I had to sit down and write every line of code it would be tremendous. While this project would have been feasible without Iron Speed Designer there is no way that I could have come up to speed as quickly as I did. Once I understood the capabilities and the framework of the tool I was really able to ramp-up quickly!

This tool is incredibly cost effective! It is especially important for small shops like mine to consider the total costs of a development tool including both short term (purchase price) and long term (development time, subscription renewals, and support). The price of Iron Speed Designer is worth the framework that is constructed in the generated application alone. I would have spent more time building my framework within ASP.NET than I have spent on all the other items to-date.

In addition to VFB, I have built a series of simple applications, including labor tracking systems and work order systems; however none of these applications were nearly as extensive as VFB, and I was able to complete them in under a week.

Another step is to incorporate EDI capabilities and content collection from related sites to augment standard data entry.