🚀 DRMS

Deployment Request Management System

A structured, role-based deployment approval platform built for engineering teams.

---

📖 Overview

DRMS is an ASP.NET Core MVC application for managing deployment requests through a structured, role-based approval workflow. It helps developers submit deployment requests, routes them through Tech Lead → QA → DevOps approvals, and gives administrators a consolidated view of request status and deployment history.

---

✨ Features

Feature	Description
🔐 Authentication	Cookie-based auth with role-aware redirects and BCrypt password hashing
📝 Request Creation	Submit deployments with project, environment, type, rollback plan & target date
🔄 Approval Workflow	Multi-step approvals: Tech Lead → QA → DevOps
📊 Developer Dashboard	Track your requests and see deployment summaries at a glance
🛡️ Admin Panel	Filter and review all requests by status or project
📜 Audit History	Full deployment history tracking for every request
👤 Self-Service Signup	New users can register directly through the signup screen

---

🛠️ Tech Stack

Layer	Technology
Framework
Language
Database
ORM
Security
Frontend
Templating
Container

---

🏗️ Solution Structure

DRMS/
├── 📦 DRMS.Domain/          # Entities and repository contracts
├── ⚙️  DRMS.Application/     # DTOs and application service logic
├── 🗄️  DRMS.Infrastructure/  # Dapper context and repository implementations
├── 🌐 DRMS.Web/             # MVC controllers, Razor views, static assets
├── 🗃️  database/             # Schema, seed data, stored procedures, SQL tests
├── 📚 docs/                 # Workflow and supporting documentation
└── 🔧 DRMS.slnx             # Solution file

Architecture

The project follows a clean layered architecture:

DRMS.Web  ──►  DRMS.Application  ──►  DRMS.Domain
                      │                    ▲
                      ▼                    │
              DRMS.Infrastructure  ────────┘

• DRMS.Domain — Core entities and repository interfaces (no dependencies)
• DRMS.Application — DTOs and service-level business logic
• DRMS.Infrastructure — Dapper + SQL Server stored procedure implementations
• DRMS.Web — Controllers, Razor views, auth, authorization policies, DI setup

---

👥 User Roles & Workflow

Developer  ──submits──►  [ Submitted ]
                               │
                     Tech Lead reviews
                               │
                          [ Approved L1 ]
                               │
                           QA reviews
                               │
                          [ Approved L2 ]
                               │
                         DevOps reviews
                               │
                           [ Deployed ] ✅

Role	Permissions
👨‍💻 Developer	Create & track own deployment requests
🧑‍💼 Tech Lead	First approval step
🧪 QA	Quality approval step
⚙️ DevOps	Final deployment approval
🛡️ Admin	View all requests and full history

---

🚀 Getting Started

Prerequisites

• .NET 10 SDK
• Docker Desktop (recommended for SQL Server)
• A SQL client: SSMS, Azure Data Studio, or sqlcmd

1. Start SQL Server via Docker

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=YourStrong@Password" \
  -p 1433:1433 --name drms-sqlserver \
  -d mcr.microsoft.com/mssql/server:2022-latest

2. Set Up the Database

Run the SQL scripts in order:

database/01_schema_and_seed.sql       ← Schema, master data & seed
database/02_stored_procedures.sql     ← All stored procedures
database/03_test_stored_procedures.sql ← Optional: validate

3. Configure the Connection String

cp DRMS.Web/appsettings.Development.example.json DRMS.Web/appsettings.Development.json

Edit the file:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost,1433;Database=DRMS;User Id=sa;Password=YOUR_PASSWORD;TrustServerCertificate=True;"
  }
}

Or use .NET user secrets:

dotnet user-secrets set "ConnectionStrings:DefaultConnection" \
  "Server=localhost,1433;Database=DRMS;User Id=sa;Password=YOUR_PASSWORD;TrustServerCertificate=True;" \
  --project DRMS.Web

4. Run the App

dotnet restore DRMS.slnx
dotnet build DRMS.slnx
dotnet run --project DRMS.Web

Open the URL printed in the terminal — it lands on the Login page. Create your first user via the Sign Up screen.

---

🐳 Useful Docker Commands

# Check if SQL Server is running
docker ps

# View SQL Server logs
docker logs -f drms-sqlserver

# Open an interactive SQL shell inside the container
docker exec -it drms-sqlserver /opt/mssql-tools18/bin/sqlcmd \
  -S localhost -U sa -P 'YourPassword' -C

# Stop / Start the container
docker stop drms-sqlserver
docker start drms-sqlserver

---

🔧 Useful Dev Commands

dotnet restore DRMS.slnx       # Restore NuGet packages
dotnet build DRMS.slnx         # Build the solution
dotnet run --project DRMS.Web  # Run the web app

---

🔒 Security Notes

• Passwords are hashed using BCrypt — no plaintext passwords stored anywhere
• Only @lnt.com email addresses are accepted at signup
• Do not commit appsettings.Development.json — it is .gitignored
• The bin/ and obj/ build folders are also excluded from version control

---

📁 Repository Hygiene

Generated build folders (bin/, obj/) and local config files (appsettings.Development.json) are excluded via .gitignore so credentials never reach the repository.

---

Built as a capstone internship project — DRMS © 2026