Melvern Lake Marina Storage

A secure storage management platform that digitized marina workflows including spot configuration, assignments, and payments with Lightspeed POS sync and a public availability widget for the main website.

Melvern, KS Completed: Oct 2025 Audience: Staff + Customers
Melvern Lake Marina Storage preview
Microsoft Identity auth
Versioned + auditable data
Time to Complete
~105 Hours
Discovery → Launch
Stack
ASP.NET 8
EF Core + SQL Server + Bootstrap
Key Win
Operational Clarity
Assignments + History + Payments
Integrations
2+
Lightspeed POS + Website Widget

The Problem

The marina needed a reliable way to manage wet/dry storage inventory, track assignments over time, and log payments without relying on scattered spreadsheets, manual notes, and “tribal knowledge.” They also needed a safe way to expose storage availability on the public website without giving away admin access.

Manual workflows
Spot changes, assignments, and payment logging required multiple steps and re-entry.
Low visibility and weak history
It was difficult to answer “who had this spot, when, and why did it change?”
Integration pain
Customer/account data lived in Lightspeed POS and needed to stay in sync.

The Solution

I built a custom ASP.NET Core application that centralizes inventory, configuration, assignments, and payments. The platform includes modern authentication, role-based security, auditable history tables, and API-based integrations— including a public embeddable widget that displays availability on the marina’s WordPress site.

Single source of truth
Inventory, spot configs, and assignments live in one consistent workflow.
History-first design
Assignments and configuration changes are logged with timestamps and attribution.
Integration + public widget
Lightspeed sync for operational data and a safe availability widget for the website.
Features

What the Application Includes

Focused features that directly improved daily operations for marina staff and reduced friction for customers.

Secure Login + Roles
Secure

Microsoft Identity authentication with role-based authorization for staff workflows.

Inventory + Spot Management
Operational

Manage wet/dry spots, status, and availability with fast, staff-friendly screens.

Versioned Configuration
Controlled

Spot configuration changes are versioned, so updates are trackable and reversible.

Assignments + History
Auditable

Assignment changes are tracked with timestamps and history for accountability and reporting.

Payments Logging
Finance

Log payments by method (cash, check, POS, etc.) with clear visibility for staff.

Website Availability Widget
Embed

A safe, embeddable widget for WordPress/FareHarbor pages via iframe and API key protection.

Tech Stack

Languages
C# SQL JavaScript HTML/CSS
Frameworks
ASP.NET Core MVC (.NET 8) Entity Framework Core Bootstrap 5
Data
SQL Server History Tables Identity Tables
Hosting
Internet Information Services (IIS)
Integrations
Client POS API REST API Endpoints Embeddable Widget (iframe)

Project Details

Build Type
Custom Operations Platform
Estimated Timeline
6–10 weeks
Team Size
1 developer
Deployment
IIS
Support
Ongoing enhancements available
Built with “ops reality” in mind: auditability, minimal clicks for staff, and reliable integrations with token refresh and scheduled sync jobs.
Timeline

How the Project Was Delivered

A practical delivery process designed for business owners: fast clarity, tight scope control, and predictable progress.

Discovery

Mapped the marina’s real workflow: storage types, spots, assignments, and payment handling.

Design

Designed a clean admin UI plus a public “availability widget” experience for the website.

Build

MVC app + database schema, history tables, Lightspeed integration, and payment workflows.

Launch

Deployed to production, validated key flows, and delivered a stable handoff for daily use.

Security and Reliability

  • Microsoft Identity authentication and role-based access control
  • Rate limiting + API key pattern for public widget endpoints
  • History tables for assignments and configuration changes
  • Defensive error handling for embeddable experiences

Performance and Maintainability

  • Entity Framework Core with clean service boundaries
  • Optimized admin UX: fewer clicks and faster lookup
  • Structured schema that supports reporting and audits
  • Scheduled sync jobs for integrations and token refresh stability
FAQ

Common Questions

These are the questions business owners ask before they commit.

Yes. This project is a strong example of a “custom operations platform” inventory, assignments, payments, reporting, and integrations. We’d start by mapping your workflow and defining the minimum scope that delivers real value quickly.

A walkthrough of your current process (even if it’s spreadsheets), who uses the system, and any third-party tools you rely on. If you have an existing POS/CRM, we’ll confirm what the API can provide and design around it.

Yes. We can provide hosting options (cloud or on-prem), monitoring, backups, and ongoing improvements. Most clients choose a simple managed plan so the application stays reliable as the business evolves.

Want a build like this?

If you need a clean, secure web application that centralizes your workflow and integrates with the systems you already use, let’s talk. We will ask a few questions and send a simple plan.

Contact Pfann.Tech
Typical response time: same day or next business day.