Web app

Casa Aurelia — hotel booking and property management

A direct-booking website and back office for a small hotel (fictional demo property): live availability and dynamic pricing, room allocation that the database protects against double booking, online payments and refunds, guest self-service, front desk, housekeeping, maintenance, iCal sync with booking channels, PDF vouchers and reports.

In development2026Hospitality
Casa Aurelia — hotel booking and property management

Overview

Overview

Casa Aurelia shows how a small hotel can take bookings on its own website instead of depending only on booking portals. The public site (Romanian and English) lets guests check availability, compare rate options and book; the back office covers what the team does every day — reservations, calendar, rooms and housekeeping, rates, maintenance and reports. The property, prices, policies and photos are fictional.

What it does

  • Availability and pricing: rates per room type with weekend, extra-adult and child prices, minimum stay, seasonal rules and promotional codes; flexible and non-refundable options side by side.
  • No double booking: each reservation is allocated to a physical room, and the database itself rejects overlapping stays. Concurrency tests recorded zero double bookings.
  • Payments and refunds through a payment interface with a built-in sandbox; a Stripe adapter is implemented and waiting for keys.
  • Guest self-service by booking reference, PDF vouchers and transactional e-mails sent through an outbox.
  • Operations: today's arrivals and departures, room calendar, housekeeping statuses, maintenance blocks, iCal import from booking channels, reports with CSV export and an audit log.

Quality

272 automated and manual checks were executed (271 passed, 1 failure fixed, 0 open defects), including a 1,500-case pricing check, accessibility scans with no violations and SEO checks.

Status

A complete demo, not in use by a real hotel. Before launch it needs a real payment account, monitoring, hosting and the owner's own property data and legal texts.

Screenshots

Case study

Challenge

Small hotels pay commission on most bookings and juggle spreadsheets, booking channels and paper for housekeeping. The goal was a direct-booking site plus a back office that a small team can run, where two guests can never end up with the same room.

Solution

A Next.js application on PostgreSQL. Availability, pricing and the reservation state machine run on the server; room allocation is protected by database constraints, so overlapping stays are rejected even under simultaneous requests. Payments sit behind a provider interface (sandbox and Stripe), e-mails and refunds go through an outbox and a worker, and iCal feeds are imported on a schedule.

Results

The full guest and staff journey works end to end on demo data: search, booking, sandbox payment, voucher, cancellation and refund, plus the daily back-office work. 271 of 272 executed checks passed (the one failure was fixed), with zero double bookings in concurrency tests. Real payments, monitoring and the owner’s data are the remaining steps before launch.

Our role

Product design, booking and pricing engine, database design, payments and refunds, back office, accessibility, SEO, testing and documentation.

Related projects

Slipstream — bar platform with QR ordering, loyalty and browser games
Web appCase study

Slipstream — bar platform with QR ordering, loyalty and browser games

A complete digital platform for a motorsport-themed bar (demo with a fictional brand): QR table ordering with a live bar dashboard, reservations, events, loyalty points and rewards, race-weekend predictions, a pub quiz, community features and eight browser games.

  • HTML5
  • CSS
  • JavaScript
  • PostgreSQL
  • +4
Raftul — e-commerce marketplace platform
Web appCase study

Raftul — e-commerce marketplace platform

A production-oriented online store for the Romanian and EU market (shown under a fictional brand): storefront with typo-tolerant search, promotions, multi-warehouse stock, checkout with card, cash on delivery and bank transfer, returns, SEO built in, a REST API for mobile apps and a role-based admin panel.

  • Prisma
  • TypeScript
  • React
  • Next.js
  • +4
Clinica Meridian — medical clinic platform
Web appCase study

Clinica Meridian — medical clinic platform

A public medical portal, online appointment booking, a multi-role staff application and a mini-EMR for a multi-location private clinic (fictional demo): live free slots, booking with SMS confirmation, protection against double booking for doctors and rooms, mandatory two-factor sign-in for staff, encrypted clinical data and a tamper-evident audit log.

  • Prisma
  • TypeScript
  • React
  • Next.js
  • +4

Need something similar?

We can build a project like this around your goals, content and budget.

Esc