Enterprise IT Asset Management System built with ASP.NET Core MVC, MSSQL, Dapper, Bootstrap, and Chart.js.
AssetGuard is an enterprise-style IT asset management platform for tracking corporate devices across their full lifecycle — inventory, employee assignments, maintenance, warranties, operational reporting, audit compliance, and admin user management.
| Layer | Technology |
|---|---|
| Framework | ASP.NET Core 9 MVC |
| Data Access | Dapper + Microsoft.Data.SqlClient |
| Database | SQL Server / LocalDB |
| Authentication | Custom cookie auth, BCrypt password hashing |
| Export | ClosedXML (Excel), QuestPDF (PDF) |
| QR Codes | QRCoder |
| Charts | Chart.js 4 |
| UI | Bootstrap 5, Bootstrap Icons |
| Module | Description |
|---|---|
| Dashboard | KPI cards and six analytics charts (status, type, department, maintenance costs, assignment trends, warranty forecast) |
| Devices | CRUD, filters, detail page with QR code, activity timeline, and audit feed |
| Employees | CRUD, soft deactivate, assignment history, activity timeline |
| Assignments | Assign and return workflow with full history |
| Maintenance | Cost tracking, upcoming alerts, device status integration |
| Warranties | Active, expiring, and expired warranty tracking |
| Reports | Five filterable reports with Excel and PDF export |
| Audit Logs | Full activity trail with filters and export |
| User Management | Admin-only: create users, deactivate users, roles (Admin, ITStaff, Viewer) |
| UI | Enterprise layout, dark mode toggle, responsive design |
AssetGuard.Web → Controllers, Views, ViewModels, export services
AssetGuard.Application → Business services (Device, User, Dashboard, Timeline…)
AssetGuard.Infrastructure → Dapper repositories, SqlConnectionFactory
AssetGuard.Core → Models, interfaces, DTOs, enums
↓
SQL Server / LocalDB
Patterns: Layered architecture, repository pattern, service orchestration, audit logging on mutations, role-based authorization for admin features.
Secure sign-in page with demo credential notice for local portfolio review.
Operations dashboard with KPI cards and analytics charts for asset health and trends.
Device inventory list with filters, status badges, and links to detail pages.
Employee directory with department info, active status, and assignment history access.
Assignment workflow for assigning devices to employees and recording returns.
Maintenance records with cost tracking and upcoming service alerts.
Warranty tracker showing active, expiring, and expired coverage by device.
Reports hub with five operational reports and Excel/PDF export options.
Audit log viewer with filters for user, entity, and action type.
- .NET 9 SDK
- SQL Server LocalDB (included with Visual Studio) or SQL Server Express
sqlcmd(SQL Server command-line tools)
git clone https://github.com/tolga-ileri/AssetGuard.git
cd AssetGuard
dotnet restoreCopy the example configuration file (this file is gitignored):
copy src\AssetGuard.Web\appsettings.Development.example.json src\AssetGuard.Web\appsettings.Development.jsonsqllocaldb start MSSQLLocalDB
sqllocaldb info MSSQLLocalDBOption A — setup script (recommended):
sqlcmd -S "(localdb)\MSSQLLocalDB" -I -i Database\Scripts\DatabaseSetup.sqlOption B — automated PowerShell script:
.\Database\Setup-LocalDb.ps1Option C — full script directly:
sqlcmd -S "(localdb)\MSSQLLocalDB" -I -i Database\Scripts\AssetGuard_Complete.sqldotnet run --project src/AssetGuard.Web| Username | Password | Role |
|---|---|---|
admin |
Admin@123 |
Admin |
Security warning: The database seed script creates a default admin account with a known password (
Admin@123) for local demo and portfolio review only. This is intentional demo seed data — never use these credentials in production. Create new admin users via User Management and remove or change the seed account before deploying.
There is no public self-registration. Additional users are created by an Admin through Users → Create User.
| Role | Access |
|---|---|
| Admin | Full access including User Management |
| ITStaff | Standard operational modules |
| Viewer | Read-oriented access (portfolio demo) |
| Script | Purpose |
|---|---|
Database/Scripts/DatabaseSetup.sql |
Entry point — runs full setup via :r include |
Database/Scripts/AssetGuard_Complete.sql |
Full schema + seed data |
Database/Scripts/001_CreateDatabase.sql |
Create database only |
Database/Scripts/002_CreateTables.sql |
Tables and indexes |
Database/Scripts/003_SeedData.sql |
Demo seed data |
Database/Setup-LocalDb.ps1 |
Automated LocalDB setup |
Production connection string template in appsettings.json:
"DefaultConnection": "Server=YOUR_SERVER;Database=AssetGuardDb;User Id=YOUR_USER;Password=YOUR_PASSWORD;TrustServerCertificate=True;MultipleActiveResultSets=True;"Replace all placeholders — never commit real passwords.
- Passwords stored as BCrypt hashes; plain text never persisted
appsettings.Development.jsonexcluded from git via.gitignoreappsettings.jsonships with placeholder credentials only- Cookie authentication with 8-hour sliding expiration
- All pages require authentication except login
- User Management restricted to Admin role
- Audit logging on create, update, delete, assign, return, login, logout, and deactivate
- No self-registration endpoint exposed
- Role-based page-level permissions (ITStaff vs Viewer granularity)
- Email notifications for warranty expiry and maintenance due dates
- Azure AD / OpenID Connect integration
- Docker Compose deployment profile
- Automated integration tests
- REST API layer for mobile asset scanning
AssetGuard.sln
Database/Scripts/ SQL schema and seed scripts
docs/screenshots/ Portfolio screenshots
src/
AssetGuard.Core/ Models, DTOs, interfaces, enums
AssetGuard.Application/ Business services
AssetGuard.Infrastructure/ Dapper repositories
AssetGuard.Web/ MVC application
LICENSE MIT License
This project is licensed under the MIT License.
Portfolio project demonstrating enterprise ASP.NET Core development with clean architecture, Dapper, and operational IT asset management workflows.