This is a web application to manage the employees of your company. You can register employees with their personal information, read, save, edit, and delete records, ensuring complete and secure management of the database in a persistent manner.
- Add new employees with personal details.
- Edit existing employee records.
- Delete employee records.
- Alerts for record creation, deletion, and other important actions.
- Secure and persistent database management.
- Visual Studio (any version) installed on your computer.
- Microsoft SQL Server Management to create and manage the database and access your local server.
- Download or fork the repository to your computer.
- Place the project in a folder of your preference. ✅
- Open Visual Studio, select "Open Project" and navigate to the folder where you saved the project. 📁
- Verify that the solution opens correctly in Visual Studio. 🧐
- Run the project by clicking the green 'Run' button (▶️) or the 'http' button, and wait for Visual Studio to start the local server. You can now use the project in your browser. 📉
Now you're ready to see the application and start using it.
On the home page, you'll see a table with the existing employee records, or none if no records have been added yet. To add a new employee:
- Click the "New Employee" button.
- A modal window will appear, where you can enter the employee’s information.
- After filling in the details, click the "Save" button to register the employee.
Once an employee is registered, action buttons appear to the right of each record, allowing you to edit or delete the employee. The application will show alerts confirming that actions like creation or deletion have been successful. Tools, Libraries, and Technologies 📚
- C# ASP.NET (ADO.NET 7.0)
- Microsoft SQL Server Management
- Stored Procedures
- MVC Design Pattern
- RESTful APIs
- JavaScript, jQuery
- SweetAlert
- Bootstrap 5.1
- HTML, CSS
This project was developed as part of a technical test for SERFINSA El Salvador for a Junior Developer position. The objective was to implement full CRUD operations (Create, Read, Update, Delete) on the database using C# .NET and MVC. The choice of libraries, style, and interface design was left to my discretion, and I successfully completed the project within the required time frame. 💻 License
MIT License