This project is an Web API Open-Source Template that includes ASP.NET Core MVC 6, Web API 6, clean n-tier architecture, Unit Testing, Integration Testing, Mssql, databases with a lot of best practices.
In order to run Staff Management you will need to following local development configurations and Database.
Local Development Configurations
- IDE: Visual Studio 2022 17
- ASP.NET Core: SDK 6.0.421
- Mssql version: 2014+ installed with a database created
- Required Visual Studio extensions: Microsoft RDLC Report Designer 2022 Download from Visual Studio Marketplace
- Change the Default Connection and Test Connection.
StaffManagementApp -> appsettings.json
- Migrate Database
Run the following commands on Package Manager Console in the Project's Directory
update-database
- Run
You can view endpoints with swagger
You can navicate pages
- Home page
- Staff information page
- Advanced search page
- Export as Excel file
- Export as PDF file
You can perform Unit Testing with In Memory Database and pre-defined data seed.
You can perform Integration Testing with Testing Database and pre-defined data seed.
- ASP.NET Core 6 Web Api
- ASP.NET Core MVC 6
- xUnit Test - Unit Test
- xUnit Test - Integration Test
- MSSQL
- AutoMapper
- Swagger Open Api
- Microsoft RDLC Report Designer 2022
- Net Core Web API 6
- Net Core MVC 6
- N-Tier Architecture
- Restful
- Entity Framework Core - Code First
- Repository Pattern - Generic
- UnitOfWork
- Response Wrappers
- Database Seeding
- Custom Exception Handling Middlewares
- Automapper
- Swagger UI
- Complete staff Management Module (Create / Edit / Delete Display / Search / Export as File)
- Unit Test
- Integration Test
- .Net 6 migration
- Mssql Operations
This template project has been developed to ensure that I can pass the testing for senior position 😁.
If you found this Implementation helpful or used it in your Projects, do give it a star. Thanks!
- Github github.com/SinSarak
- Linkedin - Sin Sarak