TECHNOLOGY

.NET, C#, Microsoft SQL Server, MVC, WebForms, Bootstrap 3, JQuery, JS plugins, Google ReCaptcha V2, Google Maps & Google Geolocation APIs, Azure, Microsoft Dynamics Nav

OUR CLIENT:

Gallowglass has over two decades’ experience in providing high quality, cost effective local crews for events, from helping to create the world’s biggest stage to enhancing the smooth running of a local garden party.

Each year, their teams work on between 7,500 - 10,000 events at more than 2,600 venues.

Their local crew bases have covered events like the 2002 Commonwealth Games in Manchester, the 2012 Olympics in London and the Rugby World Cup in 2015, the Glastonbury Festival, the Cirque du Soleil show at the Royal Albert Hall and Sports Personality of The Year shows.

They provide skilled and certified crews, crew chiefs, aerial platform, plant, telehandler and forklift operators, drivers & banksmen, set builders & electricians, and technical crew.

CLIENT’S NEED

The client had an initial Crew App which informed each crew member of his fellow crew members, crew chiefs and client contact information for all upcoming events. Their initial request was maintenance for this initial app, based on .NET, C# and WebForms. After a year, they asked us to develop a new Crew App for them, with new features, which we built with .NET, C# and MVC.


As our client’s business needs evolved, they also asked us to develop a Client App, to enable their clients to see event crew details, photographs and contact numbers together with timings, meeting places and venue information for all upcoming events.

Technology
technology_section
Gallowglass Client & Gallowglass Crew Apps

Both apps needed to link directly and confidentially through individual passwords to our client’s back office systems. At first, only their Crew App was synchronized and they would export CSV files and import them in the database over http. However, this process sometimes incurred timeouts that would cause delays in their business. To solve this problem, we decided to develop a service that reads the data directly from the Microsoft Dynamics Nav and sends it directly to the database, through an SQL connection string. This way, we were able to improve syncing time and eliminate bugs and connection time-outs, which has enabled our client to run their operations seamlessly at any time and from anywhere that they need to.

schem
phones

After developing the Client App and implementing the new features on the Crew App, we also came up with an improved software architecture in order to increase performance.


Additionally, we also built a website clone for their office in Barcelona, which can be seamlessly accessed from the main website, with the same URL and same functionalities.

screen-section
APP FEATURES & FUNCTIONALITIES

Client App

It’s designed for the companies contracting our client’s teams. They can:

 

view tasks and their status

 

view the team members assigned to each task

 

rate the crew

 

add information about the location

 

correct the map pin, if necessary view crew ratings submitted by their peers

 

view crew ratings submitted by their peers

Crew App

It’s designed for our client’s employees, teams made up of crew staff and a crew chief. Each team member can:

 

view their tasks for the day

 

rate the crew

 

view the location where they’re assigned and directions

 

view subway map and parking spots near the location

 

manage their availability to work (make new time off requests, review existing time off requests and cancel or change existing time off requests)

 

add information about the location

CLIENT'S BENEFITS

The most important features that we added or improved

 

We synchronized their private database with their public one, in the Crew App, through the dedicated service that we built for them. It’s installed on their private server, takes the data from their CRM and sends it to the public database, hosted on Azure. This is a secure and reliable solution to the interruptions that had been impacting their business

 

The apps that we developed are mobile first, which is crucial for their team members, who are constantly on the go and always need to use the applications on their smartphones

 

Increased security for their website

 

Proactiveness in identifying pain points and coming up with solutions, and a thorough understanding of their business needs

bitmap

I know I have said it before, but I just wanted to reiterate how happy we are with the service that Alin and all the team at Roweb are giving us.

Too often in I.T., people take the time to complain and raise issues but not to pass on praise and gratitude where it has been well deserved.

The projects you guys (and Alin in particular) have helped us with over the past couple of years have significantly enhanced our business and we look forward to continue building excellent solutions that add real value for our crew and our clients.

client-image

Darren Thorley

Head of I.T.
Gallowglass