Portfolio// Logic Certification

What cFront do for Logic Certification

Logic Certification provide certification services for gas engineers. This was managed in the office within a Microsoft Access application.

The business had grown too large to keep using Access - too many users accessing the system meant database corruptions were frequent, and data was having to be re-keyed into backups.

We migrated all of the existing data into a SQL Server database and built a new interface using an intranet / web browser based system.

The system allows complete management of the certification process, from when marked exam papers are received through to printing the certificates and ID cards if all the paperwork is in order.

We also provide a barcoded cover page to pass on to a document management company who archive the exam papers.

A key requirement of the brief was to eliminate a lot of bottlenecks; many processes were based on smaller business and required a lot of manual repetition. We went through the existing system with staff to identify these and built the new interface to automate as much as possible, and to provide very quick and simple entry of large amounts of data, whilst following the strict validation requirements.

Extensive management reporting is included.

The process is fully audit logged at each stage.

Technology

The application is an intranet application installed on Logic Certification's own servers.

It is built entirely in ASP.NET, and to provide advanced interface functionality and responsiveness makes extensive use of AJAX techniques. These are used both for an enhanced user experience, and for example, to provide the interface with access to the sophisticated validation and other business logic required.

Because the application is a local install, we wrote a custom reporting engine that can print directly to office printers in order to easily batch produce both the certificates and the ID cards - both of which require exact control of the print layout.

In addition, the ID card printer had a driver not compatible with later versions of Windows Server platforms, so we wrote a desktop application in .NET to retrieve the card layouts as XML and send the rendered layout directly to the printer on request.

The database is a SQL Server install, providing scalability of the business for the forseeable future.

We also provide integration with the Gas Safe Register, formerly CORGI Registration.

About Logic Certification

Logic Certification is one of the UK Building Services Industries foremost certification bodies, offering training and assessment packages through our network of over 160 approved assessment centres throughout the UK.

http://www.logiccertification.com/

More Clients