You will need Microsoft Visual Studio to run this solution project or you can use any editor of your choice if you have NET 5 (.net core 5, .net core 3.1 for the console app) installed in your Windows/MAC/Linux machine. The API uses SQL Lite Database which will be built automatically upon running the application for the first time and some data will be seeded automatically.
This API has full CRUD functionalities with 3 endpoints:
- api/customers : Shows list of Customers
- api/customers/id : Shows customer by Customer's Id
- api/customers/report : Shows a breakdown of average customer ages by customers' Genders
- To run the app, use - dotnet run - command in the CLI
- Get List of Customers http://localhost:5000/api/customers/
- View Customer by Customer http://localhost:5000/api/customers/5
- To delete a Customer by Customer Id, send HttpDelete request to http://localhost:5000/api/customers/5
- To add new Customer, copy following JSON structure and make HttpPost request to http://localhost:5000/api/customers/
{
"First_name" : "First Name",
"Last_name" : "Last Name",
"DOB" : "2000-06-12",
"Gender" : "Male"
}- To update Customers list, take above sturcture and make HttpPut call to http://localhost:5000/api/customers/
- The list shows AGE of each customer which is dynamically calculated from the Customer's Date of Birth
- To see the average age breakdown by Customers' gender, head towards http://localhost:5000/api/customers/report
Made a Console App version of this API. A method driven and simple implemenation approach was followed. Here is a screenshot from the Console output window:
