Web Application for CRUD Employee Management
Desarrollador
Hablar con el vendedor
Detalles del producto
This application aims to simplify administrative duties, improve data accuracy, and foster better employees management, designed to perform CRUD (Create, Read, Update, Delete) operations for managing employee data. Built with ASP.NET Core, it offers a dynamic and efficient way to handle employee records through a user-friendly web interface.
Features:
Create:
- Add New Employees: Form-based interface for entering new employee details, including name, position, department, and contact information.
Read:
- View Employee List: Display a searchable and sortable list of all employees.
- Employee Details: View detailed profiles of individual employees, including their personal and professional information.
Update:
- Edit Employee Records: Modify employee information directly from the web interface, such as updating contact details or changing job roles.
Delete:
- Remove Employees: Delete employee records from the system, with confirmation prompts to prevent accidental deletions.
Key Technologies:
- Front-end: ASP.Net Razor Page MVC (Model - View - Controller)
- Back-end: 3 Layers Web API
- Database: MSSQL Entities (Microsoft SQL Server)
User Interface:
- Responsive Design: Ensures accessibility across desktops.
- CRUD Operations: Intuitive forms and data tables for seamless management of employee records.
- View Employee List: Display a searchable and sortable list of all employees. Employee Details: View detailed profiles of individual employees, including their personal and professional information.
- Edit Employee Records: Modify employee information directly from the web interface, such as updating contact details or changing job roles.
- Remove Employees: Delete employee records from the system, with confirmation prompts to prevent accidental deletions.
File Tree
-
📁 Web Application for CRUD Employee Management
Instrucciones de instalación
.NET SDK: Install the .NET SDK (preferably .NET 6 or later) from Microsoft's .NET download page.
IDE: Download and install Visual Studio (2022 or later) with the ASP.NET and web development workload.
Download Zip: Alternatively, download and extract the application’s zip file.
2. Open the Project:
Launch Visual Studio: Open Visual Studio.
Open Solution: Select File > Open > Project/Solution and navigate to the project directory to open the .sln file.
3. Restore Dependencies:
Package Manager Console: In Visual Studio, open the Package Manager Console from Tools > NuGet Package Manager > Package Manager Console.
Run Restore Command: Execute the command: dotnet restore
4. Configure the Database:
Connection String: Edit the appsettings.json file to include your database connection string:
Run Migrations: If using Entity Framework, apply migrations with: dotnet ef database update
5. Build and Run the Application:
Build Project: In Visual Studio, click Build > Build Solution or use: dotnet build
Run Application: Start the application with: dotnet run Or press F5 in Visual Studio to run with debugging.
6. Access the Application:
Navigate to URL: Open a web browser and go to https://localhost:44358 (or the specified port in your launch settings) to access API.
Navigate to URL: Open a web browser and go to https://localhost:7067 (or the specified port in your launch settings) to access Application.
7. Verify Functionality:
CRUD Operations: Test creating, reading, updating, and deleting employee records through the web interface.
If you encounter any issues, check the application’s documentation or logs for troubleshooting.
Instrucciones de cambio y adaptación
1. Customize the Data Model
Update the Employee Model:
Modify Fields: Adjust the Employee class in the Models directory to include or remove properties as needed.
public class Employee
{
public int Id { get; set; }
public string Name { get; set; }
public string Position { get; set; }
public string Department { get; set; }
public string Email { get; set; }
public DateTime DateOfBirth { get; set; } // Example of additional field
}
Modify Database Context:
Update ApplicationDbContext in the Data directory if you have changed the model.
public class ApplicationDbContext : DbContext
{
public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options): base(options)
{}
public DbSet<Employee> Employees { get; set; }
}
2. Update the User Interface
Modify Views:
Edit Razor Pages or Views: Change Index.cshtml, Create.cshtml, Edit.cshtml, and Details.cshtml in the Views/Employee folder to match the updated model.
<!-- Example of adding a new field in Create.cshtml -->
<div class="form-group">
<label asp-for="DateOfBirth" class="control-label"></label>
<input asp-for="DateOfBirth" class="form-control" />
<span asp-validation-for="DateOfBirth" class="text-danger"></span>
</div>
Update Controllers:
Modify Actions: Adjust methods in EmployeeController.cs to handle new or removed fields.
public async Task<IActionResult> Create([Bind("Id,Name,Position,Department,Email,DateOfBirth")] Employee employee)
{
if (ModelState.IsValid)
{
_context.Add(employee);
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
return View(employee);
}
3. Adapt Application Settings
Configure Connection Strings:
Update appsettings.json with the correct connection string for your database:
"ConnectionStrings":