TimeSync – Timesheet LOA Management .NET v1.0.0

TimeSync is a robust, enterprise-ready timesheet and leave of absence (LOA) management system built on .NET 9 (Razor Pages) and SQL Server , following modern best practices including the repository pattern, clean architecture, and modular design.

Features:​

• Leave of Absence (LOA) with multi-level approval
• Timesheet generation, submission and tracking
• Excel-based accrual import from Paylocity
• Email approval with secure tokens
• Schedule management
• Report generation (Excel & PDF)
• Role-based access control
• Clean UI with Bootstrap & jQuery
• Daily Log Generation
• Auto-Reminders
• Flexible Settings

Built With:​

• .NET 9 Razor Pages - C#
• SQL Server
• Bootstrap & jQuery

What’s Included:​

• Full Source Code
• SQL Database Script & Backup
• Setup Documentation
• Free Lifetime Updates
• 6 Months Author Support

Live Demo​

URL: Click Here
Email: [email protected]
Password: Abc_123

Screenshots:​

Documentation​

You can view the full setup guide and usage instructions here:

View Online Documentation

Support:​

If you have any questions, contact us at: [email protected]

Change Log:​

====================
----- 08/27/2025 ---
====================
Second Release:
- Implemented WebOptimizer for bundling and minification
- Updated NuGet packages to latest stable versions
- Fixed LOA split to maintain 0.25 increment logic
- Applied various UI improvements for better usability
- Addressed miscellaneous bug fixes
- Improved overall performance and security

====================
----- 07/01/2025 ---
====================
Initial Release:
- Built using .NET 9 (Razor Pages), C#, and SQL Server
- User authentication and role-based access (Admin, Employee, Manager and more)
- Employee timesheet submission with daily/weekly/hourly tracking
- Manager approval workflow with status tracking
- Calendar
- PDF export of timesheets and reports
- Responsive UI with Bootstrap 5
- Email notifications for approvals
- Clean and modular folder structure

Features​

• Leave of Absence (LOA) with multi-level approval
• Timesheet generation, submission and tracking
• Excel-based accrual import from Paylocity
• Email approval with secure tokens
• Schedule management
• Report generation (Excel & PDF)
• Role-based access control
• Clean UI with Bootstrap & jQuery
• Daily Log Generation
• Auto-Reminders
• Flexible Settings

Requirements​

• OS: Windows 10/11 or macOS/Linux
• IDE: Visual Studio 2022+ or VS Code
• NET SDK: .NET 9 SDK
• DB: SQL Server Express/Developer and SSMS

Instructions​

Setup Instructions​

This page has all the information you will need to set up your project. Make sure you don't miss a single step.

Prerequisites & Tools Installation​

Step 1: Visual Studio 2022 (Latest)​

1. Download: Visual Studio 2022 Community
2. Select Workloads:
   • ASP.NET and web development
   • .NET desktop development
3. Under Individual Components, ensure:
   • .NET 9 SDK
   • .NET Runtime
   • .NET Core cross-platform development

Step 2: .NET 9 SDK​

If you already have Visual Studio but not the SDK:
Download .NET 9 SDK

Step 3: SQL Server​

1. Use SQL Server 2022 or newer
2. SSMS recommended for database management
3. Downloads:
   • SQL Server 2022 Developer
   • SQL Server Management Studio V21

Setting Up TimeSync​

Step 1: Unzip the Project Folder​

Extract the contents to your preferred directory.

Step 2: Open the Solution in Visual Studio​

1. Open Visual Studio 2022+
2. File > Open > Project/Solution
3. Select TimeSync.sln

Step 3: Configure appsettings.json​

1. Connection Strings
   "ConnectionStrings": {
   "DefaultConnection": "trustServerCertificate=true;Initial Catalog=TimeSyncDB;Data Source=.;User ID=sa;password=Your_Password",
   "HangfireConnection": "trustServerCertificate=true;Initial Catalog=HangfireCoreDB;Data Source=.;User ID=sa;password=Your_Password"
   }
2. Path Settings
   "PathSettings": {
   "Folder": "C:/WaiziStack/TimeSync",
   "ImagePath": "ApplicationData/Images",
   "LogPath": "Logs/logfile.txt"
   }
3. General Settings
   "GeneralSettings": {
   "BaseURL": "https://localhost:7170",
   "NumberOrItemsInAutoComplete": "10",
   "ReceptionEmail": "[email protected]",
   "Environment": "Development",
   "DevEnvEmail": "[email protected]"
   }
4. Paylocity Settings
   "PaylocitySettings": {
   "LeaveTypes": "FLEX,SICK,VAC,EEADM,EEFLX,EESIC,EEVAC"
   }
5. Email Settings
   "EmailSettings": {
   "Server": "smtp.gmail.com",
   "Port": 587,
   "Username": "[email protected]",
   "Password": "YourPassword"
   }

Step 4: Apply Database Migrations​

1. Tools > NuGet Package Manager > Package Manager Console
2. Run the following command for ApplicationDbContext:
   update-database -context ApplicationDbContext
3. Run the following command for HangfireDbContext:
   update-database -context HangfireDbContext

Step 5: Run the Project​

Press F5 to run. Open https://localhost:7170 in your browser.