SmartEMP – Employee Management System using ASP.NET Core, ADO.NET & SQL Server (Login Page, Session Implemented, Auto Employee Code Generation, Dropdown, Image Attachment, Validation Implemented).

 

✅FEATURES IMPLEMENTED IN THE PROJECT 

1️⃣ Employee Registration (Insert)

• Add a new employee with:

  • First Name, Last Name

  • DOB, Email, Mobile

  • Department, Designation

  • Salary

  • Employee Image Upload

• Employee Code auto-generated (EMP001, EMP002…)

---

2️⃣ Employee Update (Edit)

• Load employee data by ID

• Display in the form for editing

• Update stored record via stored procedure

---

3️⃣ Employee Delete

• Delete employee record by ID

• Removed from database using SQL query

---

4️⃣ Employee Listing / Report

• Show all employees in a table:

  • Code, Name, Email, Mobile

  • Department, Designation

  • Salary

  • Employee Image

• Edit / Delete options for each row

---

5️⃣ Pagination (PagedList)

• Employee report supports page navigation

• Displays limited records per page

---

6️⃣ Employee Image Upload

• Upload image through <input type="file">

• Save image to folder /SaveImage/

• Save path in database

• Show image in report table

---

7️⃣ Dropdown Binding

• Department dropdown

• Designation dropdown

• Loaded dynamically from SQL tables

---

8️⃣ Login System (Authentication)

• Login page using email & password

• Validate login from SQL database

• Store user session values

• FormsAuthentication cookie added

• Redirect to Employee page on successful login

---

9️⃣ Session Management

• IsSessionnValid() checks:
  ✔ Session ID
  ✔ Session username

• Without session → redirect to Login

---

🔟 AJAX Form Submission

• jQuery AJAX used to save employee data

• Uses FormData() so file upload works

• Shows alert after success

• Reloads page without redirect

---

1️⃣1️⃣ Basic Front-end Validation

• jQuery validation for:

  • First Name

  • Last Name

  • Email

  • Mobile No

• Shows error text dynamically

---

1️⃣2️⃣ Code Behind SQL Logic (ADO.NET)

• Custom connection class Connect.cs

• FillQuery() returns DataTable

• Executes stored procedure SpEmployeeCrud

• Uses SqlCommand, SqlConnection, SqlDataAdapter

---

1️⃣3️⃣ Auto Employee Code Generator

• Reads max Employee_Id

• Generates next code in EMP001 format

Coding Section:
Sql Code:

Store Procedure:

CREATE PROCEDURE SpEmployeeCrud

    @Employee_Id      INT = NULL,

    @Employee_Code    NVARCHAR(50),

    @First_Name       NVARCHAR(100),

    @Last_Name        NVARCHAR(100),

    @DOB              DATE,

    @Email            NVARCHAR(150),

    @Mobile_No        NVARCHAR(20),

    @Department_Id    INT,

    @Designation_Id   INT,

    @Salary           DECIMAL(18,2),

    @EmployeeImage    NVARCHAR(255),

    @flag             CHAR(1)

AS

BEGIN

    SET NOCOUNT ON;

    -- Insert

    IF @flag = 'I'

    BEGIN

        INSERT INTO Employee_Info (

            Employee_Code,

            First_Name,

            Last_Name,

            DOB,

            Email,

            Mobile_No,

            Department_Id,

            Designation_Id,

            Salary,

            EmployeeImage

        )

        VALUES (

            @Employee_Code,

            @First_Name,

            @Last_Name,

            @DOB,

            @Email,

            @Mobile_No,

            @Department_Id,

            @Designation_Id,

            @Salary,

            @EmployeeImage

        );

    END

    -- Update

    ELSE IF @flag = 'U'

    BEGIN

        UPDATE Employee_Info

        SET

            Employee_Code  = @Employee_Code,

            First_Name     = @First_Name,

            Last_Name      = @Last_Name,

            DOB            = @DOB,

            Email          = @Email,

            Mobile_No      = @Mobile_No,

            Department_Id  = @Department_Id,

            Designation_Id = @Designation_Id,

            Salary         = @Salary,

            EmployeeImage  = @EmployeeImage

        WHERE Employee_Id = @Employee_Id;

    END

END;

Files Names:

Sql Connection Code:

Model Code:

Controller Code:

Login Controller:

Employee Controller:

View Code:

Employee View:

 

Get Data View:

Get Details View:

Index View Code:

Login Index View Code:

User Interface:

Link: https://tinyurl.com/2mntkwj7