This is an ASP .Net web API used to manage the inventory for the armory I work at. It uses entity framework to implement the SQLite database.
- This creates the database for you. There is no existing database and all tables will need to be populated by each individual user (currently)
- Update the migrations.
- Run the App in Debug mode and wait for the swagger page to open.
- Click on Post Radio.
- Click on Try it out.
- Add the following items, one at a time.
- We're not adding Id because one is made autimatically for us.
- Click Execute to add.
{
"name": "Radio",
"serialNumber": 1234,
"inInventory": true,
"hasBattery": false
},
{
"name": "Radio",
"serialNumber": 3395,
"inInventory": true,
"hasBattery": false
},
{
"name": "Radio",
"serialNumber": 4545,
"inInventory": true,
"hasBattery": false
}
-
Click on Post Antenna for Items.
-
Add the following items.
{ "name": "Antenna", "serialNumber": 9999, "inInventory": true, "hasAllParts": true, "type": "OE-254" } { "name": "Antenna", "serialNumber": 9910, "inInventory": true, "hasAllParts": true, "type": "OE-254" }
- Click on Get for Items.
- View Items by Id.
- Click Get Items{id} and use an Items Id to retrieve it.
-
Click on Post for Checkout.
{ "itemId": {item id you just copied}, "dateCheckedout": this will populate itself for now, "dateReturned": this will populate itself for now, "checkedoutTo": "Hill" } { "itemId": {Item id you just copied}, "dateCheckedout": this will populate itself for now, "dateReturned": this will populate itself for now, "checkedoutTo": "ALOC" }
-
Click on GetItemHistory for Items.
- Use the same Item Id you used to create the previous Checkouts and execute to see Items Checkouts.
I am currently in the process of shifting this project into a .net maui project. I plan to either connect the .net maui app to this api or (most likely) will recreate this database using Azure. Check back soon for more updates.