HotelCRM

Architecture

This is a simple CRM application with the following stack:

• Database: PostgreSQL
• UI Framework: WPF (.NET)
• ORM: EF Core
• Architecture: 3-layer (Presentation, Business Logic, Data Access)

Layers

• PL (Presentation Layer) – WPF UI (Views, ViewModels). Handles user interaction.
• BLL (Business Logic Layer) – Services and domain models. Contains core business rules.
• DAL (Data Access Layer) – EF Core + Repository pattern. Manages database operations.

Functions

• CRUD operations for all database tables
• Business functions:
  • Search for available rooms by entered parameters (date, capacity, price, etc.)
  • Book a room
  • Check room availability in real time
  • Cancel or modify existing bookings

Database schema

Deployment diagram

Packages diagram

Example

Main Window (Главное окно)

Client addition form (Форма добавления клиента)

Rooms tab. List of rooms (Вкладка номера. Список номеров)

Search available rooms (Поиск свободных номеров)

Booking creating form (Бронирование номера)

Payment, Booking, View Receipt (Оплата, бронирование, просмотр чека)

Payment Tab(Окно платежей)

Additional services tab (Окно дополнительных платежей)

Report for period (Отчет за период)