Internal Desktop System

HMB Security Database

An offline security and staff management system built in C# WinForms for airport and facility security operations, designed around real operational constraints, Arabic/RTL workflows, and paperwork-heavy processes.

Offline-first C# WinForms Arabic/RTL Internal DSL

HMB Security Database dashboard showing Arabic security operations counters and navigation

Project Overview

Built for controlled environments where reliability, local data, and compatibility with existing infrastructure matter more than cloud connectivity.

Operational Scope

The system manages employee and contractor security records, temporary and permanent pass operations, security clearance tracking, image handling, document generation, grouping, renewals, and settlement-related workflows.

Design Priorities

The application was intentionally designed as an offline-first desktop system for limited or no internet access, legacy deployment constraints, operational security requirements, and stable daily use on controlled machines.

Core Features

A dense operational toolset for security administration teams.

Staff Record Management

Centralized Arabic and English staff records with job titles, departments, national ID information, pass data, employment status, phone numbers, and operational tracking fields.

Security Clearance and Passes

Temporary passes, permanent pass issuance and renewals, lost pass handling, airside workflows, first-time issuance, suspension, cancellation, and renewal batches grouped by JobNumber.

Image and ID Handling

Staff photos, national ID front/back images, permanent pass images, staged image workflows, placeholder handling, PDF slicing, image extraction, and print preparation support.

Document Automation

Word template generation for addition requests, cover sheets, background checks, ID layouts, renewal reports, financial reports, settlement reports, and signature sheets.

Operational Management

Ongoing renewal tracking, settlement workflow support, data update tracking, job title change tracking, unsaved changes protection, configurable settings, and dynamic path configuration.

Deployment Reliability

MSI installer deployment, offline installation support, x86/x64 compatibility handling, ACE provider management, Syncfusion startup registration, and target-machine troubleshooting.

HMBQL Query DSL

A custom domain-specific language built into the system for readable, controlled internal querying without exposing the database directly.

Language Architecture

HMBQL is implemented as a separate class library with a tokenizer, parser, abstract syntax tree, SQL compiler, QueryEngineV01, and CatalogStoreV01.

GET FullName, Department
FROM Staff
WHERE Department = "Security"

Query Console

The in-app console includes a query editor, suggestion list, CLI-style interaction, keyboard-friendly execution, result grid, export support, and a HELP command concept.

Queries compile into parameterized OleDb SQL with positional parameters, date parsing, automatic lookup joins, department translation, alias mapping, and controlled execution.

Engineering Value

Production-focused engineering for a real operational environment.

Offline Reliability

Local Access database storage, file-based image and document organization, dynamic OLE DB provider handling, and centralized file/path management.

Workflow Automation

Reusable document generation helpers for bookmark replacement, table population, image insertion, Arabic/RTL formatting, safe saving, and batch generation.

Enterprise Usability

Dense DataGridView workflows, modular UserControls, single host form architecture, custom dialogs, DPI-aware layouts, keyboard-friendly operation, and older hardware support.

Technologies Used

The stack reflects the needs of an offline Windows desktop environment.

C# WinForms .NET Framework 4.6.2 / 4.8 Microsoft Access ACE OLE DB Syncfusion DocIO Syncfusion PDF OleDb Word Templates PDF Image Extraction Custom DSL Arabic/RTL UI MSI Deployment Visual Studio Setup Projects

My Role

I designed and developed the system architecture, WinForms workflows, database integration, document automation, image and PDF handling, file management infrastructure, installer process, UI/UX workflows, Arabic/RTL support, and the HMBQL language.

Impact

The system centralizes security and pass-management workflows, reduces manual paperwork, improves operational consistency, standardizes file organization, automates document generation, and adds structured querying through HMBQL.