User Data Management

Introduction

Simple web-based application for user data accounting. Realization of technical assignment for Ukrposhta company.

Technologies

• Using the MVC pattern to organize code.
• Using direct database queries (without ef).
• Implementation of AJAX requests to improve the reactivity of the interface.

Functions

• View personnel with search filters
• Ability to create/edit/delete an employee
• Salary reporting with filters
• Uploading salary reports to a txt file

How to start

1. Create DB (/SQL_Scripts/):
   • open and execute CreateTables.sql;
   • open and execute InsertData.sql;
   • open and execute all procedure;
     
2. In appsettings.json, paste the name of your server and db in the connection string

    "ConnectionStrings": {
    "DefaultConnection": "Server=your_name; Database=db_name; Trusted_Connection=True; trustServerCertificate=true;"
  },

Screenshots

Start page

Staff page

Filtered staff

Person card page

Salary report page

Filtered salary report

Downloaded file example