Payroll System API

**.NET 10 Web API built with Dapper and SQL Server.

🛠 Tech

• Backend: C# | .NET 10 | Dapper
• Database: SQL Server | Stored Procedures
• Frontend: Vanilla JavaScript | Bootstrap 5 | CORS Integration

🚀 Key Features

• Generates unique identifiers by combining name prefixes and 5-digit random number, and formatted dates of birth (e.g. TAN-12345-06JUNE2000).
• Applies a 2x Daily Rate multiplier for actual days worked.
• Logic handles specific MWF/TTHS work schedules.
• 100% Daily rate payout on the employee's birthday regardless of their work schedule.
• RESTful API using the following HTTP Methods:

📡 HTTP Methods Overview

• [HttpGet]: Retrieves a list of all employees.
• [HttpGet("{employeeNumber}")]: Fetches details for a single employee by their unique employee number.
• [HttpPost]: Creates a new employee record.
• [HttpPut("{employeeNumber}")]: Updates an existing employee's information.
• [HttpDelete("{employeeNumber}")]: Removes an employee record from the system.
• [HttpGet("{employeeNumber}/compute")]: Computes the take-home pay for a specific employee within a given date range.

• User-friendly UI

• LINK: https://jinji-tan.github.io/Dotnet-PayrollSystemAPI/

• Demo Note: The GitHub Pages link demonstrates the Frontend UI.**

• Backend is a .NET API connected to a local SQL Server, the data operations (CRUD and Computation) require the API to be running locally.