Add Attendance Tracking to ASP.NET

I have an in-house Employee Management System built during my .NET internship with ASP.NET MVC, C#, SQL Server, and ADO.NET as the core stack. The next milestone is a fully integrated attendance-tracking feature.

Here is the current landscape:
• MVC architecture with razor views already handling employee CRUD
• SQL Server schema for employees, departments, roles, etc.
• Pure ADO.NET data access layer (no Entity Framework)

What I need now is an attendance module that plugs seamlessly into this codebase. Core expectations:
1. Database design and migration scripts for daily check-in / check-out records.
2. MVC controller actions and razor views for employees to record their time and for admins to view, filter, and export logs.
3. Business logic in C# that prevents duplicate punches, allows edits with proper auditing, and exposes summary totals (hours, late arrivals, absences).
4. Clean ADO.NET implementation consistent with the existing repository pattern.

I will provide the full solution, connection strings, and a sample dataset. Your deliverable is the updated solution—with commented code, updated SQL scripts, and a concise README describing setup steps—ready to build and run in Visual Studio.

If you have solid ASP.NET MVC experience and are comfortable working directly with ADO.NET rather than ORMs, let’s talk.