SimpleCRUD

Sample implementation of CRUD functioanltiy keeping angular 8.0 as front end and API built with .Net core 3.1 as Back end. I have used SQL Server for database management.

Front end Part.

I have used material theme for front end, to make it visually more better. I am still working on it so, I will keep updating this part..

To Start with on front end side, find folder named FrontEnd inside repository. open that in vs code. install all the packages and serve/run it in browser. but before that make sure your API is running well otherwise you will not be able to see any data.

Requirements for Back end.

• I have used VS Code for front end part.
• Install latest node.js.

Back End API and Basic Ideas about it.

API Contains best practise with Repository Pattern with onion architecture.

A Repository mediates between the data. model abd project mapping layers Mapping code is encapsulated behind the Repository. Clean separation and on-way dependency between the domain and data mapping layers. Implementation Details

Entity

In this sample the following two types of entities are used.

User: Represents a sample entity of user Both of entities inherit from abstract class called FullAuditedEntity.

FullAuditedEntity - base class used for most of the entities and which regulates entities identifier, logs, dates etc.

Repository layer

Service layer

Uow layer

Model, Dto and Automap profiler

In this project, I have used Dto to pass data to client side. Model to Dto level conversion will be handled by AutoMapperProfile

Migrations and Seeders

As project follows code first technique, it also contains migrations. right now it has one single migration whilh will create a database and all the entities at given configuration string. I have also added seeders so that at initialization level of project, we have some data to work with.

Testing of controller end points with xUnit and moq tools

Solution file also contains a project for testing of API end points. here I have used currently best practise that we have around the glob using moq and xUnit. follow ProductControllerTests class.

Swagger UI

Swagger UI is a collection of HTML, Javascript, and CSS assets that dynamically generate beautiful documentation from a Swagger-compliant API. http://swagger.io I have added this in project to review all the end points and test it from browser it self.

How to Start?

• Update Connection string of local in appsettings.Development.json file.
• run migration, use command update-database
• run api, keeping SimpleCRUD as start up project.
• you will have a swagger UI in browser where you will be able to see all endpoints of User controller. you can check get call, as we have added some initial values for users.

Requirements for Back end.

• Visual studio 2019 with .Net core 3.1 installed. one can use VS Code too.
• SQL server and management studio, latest.

Happy coding...