Alpha Painting Holidays Booking Platform Port Case Study

Summary

SMXi ported a legacy .NET holiday booking application into a modern web booking journey, API/service layer and management platform backed by Microsoft SQL Server data.

The Problem

The existing application carried important booking rules and operational knowledge, but the client needed a more maintainable web platform with a clearer customer journey and better long-term support.

Customers needed a guided booking process for selecting holidays, adding guest details and choosing optional extras.
The office team needed to keep control of holidays, bookings, venues, costs, payments and support queries.
The data model needed to remain structured around Microsoft SQL Server rather than being reduced to loose spreadsheet-style workflows.
The platform needed payment and confirmation handling that supported the way customers actually book and pay.

Features

Port of an existing .NET booking application into a maintainable web platform.
Six-step online booking journey covering holiday selection, customer details, guest details, optional extras, review, payment and confirmation.
Microsoft SQL Server data model covering customers, guests, bookings, holidays, venues, costs and payments.
API and service layer for holiday, customer, register and payment workflows.
Operational manager tools for holidays, bookings, venues, costs, payments and support queries.
Payment workflow support including PayPal, Revolut, BACS and cheque confirmation paths.
Authentication, logging and support tooling using reusable SMXi platform components.

Time: Legacy port and ongoing booking-platform support

Platforms: Web | API | Windows Server | Windows Desktop | Microsoft SQL Server

Technologies

Description

Alpha Painting Holidays needed to move an established booking application away from its older .NET implementation while keeping the business rules, booking stages and operational detail that staff already depended on.

SMXi rebuilt the platform around a web booking journey supported by a service layer and Microsoft SQL Server data. The public flow guides customers through holiday selection, customer details, guest details, optional extras, review and payment, then handles confirmation and account access.

The port was not just a visual rebuild. The underlying booking model needed to represent real holiday operations: customers, guests, venues, hotels, booking states, costs, deposits, balances, payment records and confirmation messages. The result gives the client a clearer route for online bookings while preserving the operational data needed behind the scenes.

Alongside the public website, SMXi provided management tooling for holidays, bookings, venues, costs, payments, logs and support queries. This gives the office team practical control over the information that drives the booking journey.

The project demonstrates SMXi’s ability to modernise an existing application without throwing away the knowledge already embedded in it: a customer-facing web platform, a structured API/service layer, reliable SQL Server data and administrative tools that match the way the organisation works.