Timesync Timesheet

Descriptions

Overview

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.

What's Included: Full Source Code, SQL Database Script & Backup, Setup Documentation, Free Lifetime Updates, 6 Months Author Support

Features

Leave of Absence (LOA) with multi-level approval workflow
Timesheet generation, submission, and tracking
Excel-based accrual import from Paylocity
Email approval system with secure tokens
Schedule management
Report generation in Excel and PDF formats
Role-based access control
Clean UI built with Bootstrap and jQuery
Daily log generation
Automated reminder system
Flexible configuration settings

Built With

.NET 9 Razor Pages with C#
SQL Server database
Bootstrap and jQuery frontend

Requirements

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

Setup Instructions

Prerequisites & Tools Installation

Step 1: Visual Studio 2022 (Latest)

Download Visual Studio 2022 Community and select these workloads:

- ASP.NET and web development

- .NET desktop development

Under Individual Components, ensure: .NET 9 SDK, .NET Runtime, .NET Core cross-platform development

Step 2: .NET 9 SDK

If you have Visual Studio but not the SDK, download .NET 9 SDK separately.

Step 3: SQL Server

Use SQL Server 2022 or newer. SSMS is recommended for database management.

Setting Up TimeSync

Step 1: Unzip the Project Folder

Extract contents to your preferred directory.

Step 2: Open the Solution in Visual Studio

Open Visual Studio 2022+ → File → Open → Project/Solution → Select TimeSync.sln

Step 3: Configure appsettings.json

Connection Strings:

"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"

Path Settings:

"Folder": "C:/WaiziStack/TimeSync"

"ImagePath": "ApplicationData/Images"

"LogPath": "Logs/logfile.txt"

General Settings:

"BaseURL": "https://localhost:7170"

"NumberOrItemsInAutoComplete": "10"

"ReceptionEmail": "admin@timesync.com"

"Environment": "Development"

"DevEnvEmail": "dev@timesync.com"

Paylocity Settings:

"LeaveTypes": "FLEX,SICK,VAC,EEADM,EEFLX,EESIC,EEVAC"

Email Settings:

"Server": "smtp.gmail.com"

"Port": 587

"Username": "your-email@gmail.com"

"Password": "YourPassword"

Step 4: Apply Database Migrations

Tools → NuGet Package Manager → Package Manager Console

Run: update-database -context ApplicationDbContext

Run: update-database -context HangfireDbContext

Step 5: Run the Project

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

Support: For questions, contact support@timesync.com

Documentation: View online documentation for complete setup and usage instructions.

Change Log - Second Release (08/27/2025):

- Implemented WebOptimizer for bundling and minification

- Updated NuGet packages to the 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

Change Log - Initial Release (07/01/2025):

- 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 functionality

- PDF export of timesheets and reports

- Responsive UI with Bootstrap 5

- Email notifications for approvals

- Clean and modular folder structure

Hex Information (For Shop Owner): 56617