PR Management — Property Rental Management Web App

A full ASP.NET MVC web application for managing a property rental business — buildings, apartments, tenants, managers, owners, appointments, and messages. Built solo as an individual final project for a course on Web Server Application Development (course 420-DW4-AS, Fall 2023).

Note: Database connection strings in Web.config have been redacted — replace YOUR_SERVER, YOUR_USERNAME, and YOUR_PASSWORD with your own SQL Server instance details to run it locally.

What It Does

• Authentication — users sign up and log in via ASP.NET Forms Authentication, with role-based redirects depending on whether the logged-in user is a Manager, Tenant, or Owner
• Full CRUD across all core entities: Buildings, Apartments, Managers, Tenants, Owners, Appointments, and Messages
• Apartments are linked to Buildings via a foreign key relationship, with a dropdown selector populated from the database
• CSRF protection on all state-changing actions via [ValidateAntiForgeryToken]

Architecture

Standard ASP.NET MVC structure:

Controllers/   → One controller per entity (AccountController, ApartmentsController, BuildingsController, ManagersController, TenantsController, MessagesController, AppointmentsController)
Models/        → Entity Framework Database-First models (Model1.edmx) generating C# classes per table
Views/         → Razor views (.cshtml) — Index/Create/Edit/Details/Delete per entity
Content/       → Bootstrap CSS
Scripts/       → jQuery, Bootstrap JS, jQuery Validation

Key Concepts Demonstrated

• ASP.NET MVC architecture (Controllers, Models, Razor Views)
• Entity Framework (Database-First) with a relational SQL Server schema
• Forms Authentication and session-based login state
• CSRF protection via anti-forgery tokens
• Client-side validation with jQuery Validate (unobtrusive validation)
• Bootstrap-based responsive UI

Database

Database_Schema.sql contains the full SQL Server schema and seed data for the PRManagementDB database — including the Buildings, Apartments, Managers, Tenants, Owners, Appointments, Messages, and User tables.

Tech Stack

• C# / ASP.NET MVC (.NET Framework)
• Entity Framework 6
• SQL Server
• Bootstrap, jQuery

How to Run

1. Run Database_Schema.sql against a SQL Server instance to create the PRManagementDB database
2. Open PRManagementProject.sln in Visual Studio
3. Update the connection string in PRManagementProject/Web.config with your SQL Server instance details
4. Build and run the solution

Author

Built solo by Riyaz Badhan as a fifth-semester individual academic project.