Simple Payroll

Live Demo

Docker Image: nyendluri/simple-payroll:latest

---

Environment

The application is written using ASP.NET Core, Entity Framework Core, AngularJS

---

Features

• User Authentication
• Employee Listing
• Create New Employee
• Edit Employee Details
• Record Pay
• Pay History Listing

---

Database

• The application uses Entity Framework Core In-Memory database.

Tables

• Authentication
  • Id (long)
  • AuthKey (Guid)
  • UserId (long)
  • CreateDateTime (DateTime)
• User
  • Id (long)
  • Username (string)
  • FirstName (string)
  • LastName (string)
  • Password (string)
  • CreateDateTime (DateTime)
• Employee
  • Id (long)
  • FirstName (string)
  • LastName (string)
  • State (string)
  • W4Allowances (int)
  • SSN (string)
  • Insurance (decimal)
  • Reitirement401KPercent(decimal)
  • Reitirement401KPreTax (bool)
  • CreateDateTime (DateTime)
• Payment
  • Id (long)
  • EmplId (long)
  • GrossPay(decimal)
  • PaymentPeriodFrom (DateTime)
  • PaymentPeriodTo (DateTime)
  • FedTax (decimal)
  • StateTax (decimal)
  • SocialSecurityTax (decimal)
  • MedicareTax (decimal)
  • Insurance (decimal)
  • Reitirement401K(decimal)
  • NetPay (decimal)
  • CreateDateTime (DateTime)
• TaxPercentage
  • Id (decimal)
  • TaxCode (string)
  • Percent (decimal)

---

Steps to run locally

Intall dotnet core

Run either of the following commands from project root

• $ sh run-web.sh
• $ dotnet restore && cd ./web && dotnet run

Steps to run using docker

Install Docker

Run the following commands from project root

• $ docker run --rm -p 5000:5000 nyendluri/simple-payroll:latest

Note: If port 5000 is not available please map to any other available port

---