Now that we have new API skills, we want to create an API to help our favorite store keep track of their inventory. This API will be able to let users add, update, delete, and search for items.
Objectives
Create an API that can CRUD against a Database
practice creating ASP.NET Web API endpoints
practice EF Core.
Requirements
Create a simple API that has a handful of endpoints to manage data
The API should be using Web API Controllers, Ef Core, and Postgres database
Explorer Mode
[ ] Create a new sdg-api project using the dotnet CLI, have fun with the name and what items the shop sells.
[ ] Create a Model of for an item in the shop. This will be your database table structure.
[ ] The Item should have at least
[ ] Id
[ ] SKU
[ ] Name
[ ] Short description
[ ] NumberInStock
[ ] Price
[ ] DateOrdered
[ ] Create a GET endpoint for all items in your inventory
[ ] Create a GET endpoint for each item
[ ] Create a POST endpoint that allows a user/client to add an item to the inventory
[ ] Create a PUT endpoint that allows a user/client to update an item
[ ] Create a DELETE endpoint that allows a user/client to delete an item
[ ] Create a GET endpoint to get all items that are out of stock
[ ] Create a GET endpoint that allows the user to search for an item based on SKU
Adventure Mode
[ ] Ensure your instructor has seen and approved your wireframes for your capstone.
wmurch
commented
5 years ago 
mdewey
commented
5 years ago 
Don't lose track!
Now that we have new API skills, we want to create an API to help our favorite store keep track of their inventory. This API will be able to let users add, update, delete, and search for items.
Objectives
Requirements
Explorer Mode
[ ] Create a new
sdg-apiproject using the dotnet CLI, have fun with the name and what items the shop sells.[ ] Create a Model of for an item in the shop. This will be your database table structure.
[ ] The Item should have at least
[ ] Create a GET endpoint for all items in your inventory
[ ] Create a GET endpoint for each item
[ ] Create a POST endpoint that allows a user/client to add an item to the inventory
[ ] Create a PUT endpoint that allows a user/client to update an item
[ ] Create a DELETE endpoint that allows a user/client to delete an item
[ ] Create a GET endpoint to get all items that are out of stock
[ ] Create a GET endpoint that allows the user to search for an item based on SKU
Adventure Mode