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:

<b>v1.0.0</b> – 07/10/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
    

• 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

• 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

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

   <code>{
     "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"
     }
   }
   </code>
   
   
   
   

2. Path Settings

   <code>{
     "PathSettings": {
       "Folder": "C:/WaiziStack/TimeSync",
       "ImagePath": "ApplicationData/Images",
       "LogPath": "Logs/logfile.txt"
     }
   }
   </code>
   
   
   
   

3. General Settings

   <code>{
     "GeneralSettings": {
       "BaseURL": "https://localhost:7170",
       "NumberOrItemsInAutoComplete": "10",
       "ReceptionEmail": "[email protected]",
       "Environment": "Development",
       "DevEnvEmail": "[email protected]"
     }
   }
   </code>
   
   
   
   

4. Paylocity Settings

   <code>{
     "PaylocitySettings": {
       "LeaveTypes": "FLEX,SICK,VAC,EEADM,EEFLX,EESIC,EEVAC"
     }
   }
   </code>
   
   
   
   

5. Email Settings

   <code>{
     "EmailSettings": {
       "Server": "smtp.gmail.com",
       "Port": 587,
       "Username": "[email protected]",
       "Password": "YourPassword"
     }
   }
   </code>
   
   
   
   

Step 4: Apply Database Migrations

1. Tools > NuGet Package Manager > Package Manager Console
2. Run the command:

   <code>update-database</code>
   
   
   
   

Step 5: Run the Project

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