Employee Management System

Simple website created with Visual Studio 2019 and Microsoft SQL Server

Table of Contents

• Installation
• Features
• Database

Installation

1. After cloning this project, go to Visual Studio

2. Select the project solution, clean and build the project

3. Proceed to Tools > NuGet Package Manager > Package Manager Console

4. Type update-database in the console

5. You may start this project right away with the existing data provided below.

   Employee Username	Password
   employee1	testing123
   employee2	testing123
   employee3	testing123
   employee4	testing123
   employee5	testing123

Database

ERD

Update Database Schema

1. enable-migrations

2. add-migration [name]

3. update-database

Features

Login

• Restrict the user login failure attempts (10 times) and add into Block IP Address

• User is not allowed to login simultaneously, system will detect and redirect the current user to logout

• Display loading screen and display error message if no records found

Employee

• Add / Edit employee and display error message if found invalid format and duplicate existing information

• Delete Employee Display successful message using Notify.js

Features Prerequisites

NuGet Packages

jQuery.UI.Combined

References

1. Font Awesome Icons

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">

2. Modal Window

<link href="~/Content/themes/base/jquery-ui.min.css" rel="stylesheet" />

<script src="~/Scripts/jquery-ui-1.12.1.min.js"></script>

3. Validator JS For ModelState Error

<script src="~/Scripts/jquery.validate.min.js"></script>

<script src="~/Scripts/jquery.validate.unobtrusive.js"></script>