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
CATEGORY
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
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.
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.
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
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.
Darren Thorley
Head of I.T.
Gallowglass