Software Solutions Sydney | Ecommerce Developers – CoSource

Contact Us on 020 4577 3640

The TESL application allows doctors to request study leave to attend both domestic and international conferences. The system references ATO travel allowances, as well as a number of 3rd party internal systems to determine whether or not the doctor is authorised to attend the conference.



case nsw

In Summary


South Eastern Sydney Illawarra NSW Health


Training, Education Study Leave for Doctors

Business Problem




The old TESL application was built by a contractor using a mix of web technologies (Cold Fusion, Classic ASP, and JavaScript), which overtime made the support and extensibility of the system a challenging exercise, that eventually lead to the system becoming unmanageable.

As the area was starting to adopt SharePoint to automate workflows and forms, CoSource through Data#3 was commissioned to assist in building a new TESL application.


Microsoft SharePoint was used as the foundation to build the application upon. By using SharePoint the customer was able to manage the application’s work flow and configuration data through.

The solution needed to integrate into a number of third party systems:

  • An ERP system named CatDog (Built with VB6 and SQL Server 2000)
  • Oracle (The financial database)
  • SharePoint 2007


The application forms, business logic, and data logic were built with 4.0 and the entity framework over a three tier architecture. Web services were used to enable the systems to easily exchange information while maintaining security and performance.


  • The application’s approval process exists of a series of approvals from each of the doctor’s managers, by building a custom workflow within Sharepoint the customer could control the work flow process, where previously this had to be maintained by a developer.
  • By using SharePoint security model, the customer could easily control access to the system, and when given access what a user could do
  • SharePoint lists had enabled the customer to manage configuration information in a uniform consistent process.

Technologies Used

** Microsoft SharePoint ** Microsoft .net 4.0 ** Entity Framework ** SQL Server ** jQuery **

× Talk to an expert