KPS — Komunalinių Paslaugų Sistema

A desktop application for managing communal service pricing within residential communities. Built with C# and Windows Forms.

---

Features

Role	Capabilities
Admin	Create/delete user accounts, assign users to buildings and services, manage service catalogue and pricing
Manager	Edit service prices for their assigned building
Occupant	View the service list and current prices for their assigned building

---

Tech Stack

• Language: C# (.NET 8)
• UI: Windows Forms
• Database: MySQL 8
• IDE: Visual Studio 2022

---

Getting Started

Prerequisites

• Visual Studio 2022 with .NET 8 desktop workload
• MySQL Server 8

Setup

1. Import the database

   Run DB/kps.sql against your MySQL instance:

   mysql -u root -p < DB/kps.sql

2. Configure the connection string

   Open KPS/DB.cs and update the default connection string in the constructor with your MySQL credentials:

   public DB(string connectionString = "server=localhost;user=root;database=kps;password=YOUR_PASSWORD")

3. Build and run

   Open KPS.sln in Visual Studio and press F5.

Default Accounts

Username	Password	Role
admin	admin	Administrator
Du	du	Manager
Vienas	vienas	Occupant

---

Project Structure

KPS/
├── Program.cs          # Entry point
├── DB.cs               # Database access layer
├── Login.cs            # Authentication form
├── Admin.cs            # Admin dashboard
├── Manager.cs          # Manager dashboard
├── Occupant.cs         # Occupant dashboard
└── Properties/

DB/
└── kps.sql             # Database schema and seed data

---

Database Schema

Table	Description
user	User accounts and roles
home	Buildings and their assigned manager
service	Service catalogue
price	Service prices per building
occupant	Building–occupant assignments