Software Solutions Sydney | Ecommerce Developers – CoSource

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.

 

tesl

case nsw

In Summary

Customer

NSW Health

Industry

Medical 

Business Problem

Outdated system that was difficult to support and add new features.

Solution

Custom Microsoft SharePoint Application that integrated into their ERP & Financial systems.

Outcome

An extensible system that allowed the staff members in charge of TESL to manage the approval process and add custom rules, resulting in less support calls to the Technical team.

Background

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.

Solution

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 asp.net 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.

Benefits

  • 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