Cassy Lake
Devonport Royal Dockyard
"Iron Speed Designer saved me months of development time!"

The Container Tracking System

Devonport Royal Dockyard
Devon, UK


The Container Tracking System was commissioned by the Logistics department at the Devonport facility. Devonport Royal Dockyard was put under commercial management in response to the challenges facing this strategic facility during the late 1980's. The yard was sold and fully privatised 10 years later in 1997. Today it offers a complete range of design, build and support solutions across both defense and commercial sectors as part of Babcock Marine, itself part of Babcock International Group Plc.


The Survey table shows the most recent Surveys carried out on Containers.

The Container Tracking System tracks the movements and the condition of containers. It details surveys and work carried out on surveys. A survey checks whether a container is in full working order and assigns it a grade, for example: A1 - In Service. BER - Beyond Economical Repair. R3 - Repairable. It displays detailed reports about containers for top-level management to review. Some reports include details of containers whose surveys are within a set time frame. Others report for how many containers are in service or out of service, and where containers are currently located.

It is used internally and with two outside dockyards, Devonport Royal Dockyard and it's associated facility at Appledore Shipyard. There are currently 11 user groups for this application ranging from top-level management to data entry clerks. Users log in to create a new transaction (movement) of a container before saving the transaction. Users may also enter a new Survey for a container. The application allows users to print reports to ensure we have enough stock to repair out-of-service containers.

Application Size and Scope
Two Microsoft SQL Server 2005 databases comprise 12 tables, three database views, and approximately 38 web pages. The largest table contains approximately 13,500 records. There are over 17 users processing over 100 transactions each month.
The Project
I developed and implemented the application in about four weeks.
Code Extensions and Customizations
Code customizations have been used extensively to enable views on tables and filters to be specific to each user group. The application architecture generated by Iron Speed Designer made it very easy to incorporate Crystal Reports into the application.


The Start page of application displays data details of the latest movements on containers. Display is specific to User role accessing it.

I spent three weeks implementing these code customizations.

Layout Customizations
I used the standard Sierra design theme in Iron Speed Designer.
Iron Speed Designer Impact
Iron Speed Designer saved me months of development time! I am new to .NET development therefore this tool is ideal for me.
Next Steps
There are no future plans to extend the Container Tracking System going forward.
About the Developer
Cassy holds a degree in Math and Computing from the University of Manchester in the United Kingdom. She has been developing .NET web applications for Devonport Royal Dockyard for the past three months and is only just getting started.

www.devonport.co.uk

Your Turn
Got database applications you need developed efficiently, yet still require full customization? Try Iron Speed Designer. Download your free evaluation now.


  Privacy Statement