Stuffy Librarian

Stuffy Librarian is my final capstone project I completed for the Nashville Software School. Its original name, Mixed Media Inventory Tracker, was much more descriptive of what the application does, but the name was a tad "boring".

What It Does

Stuffy Librarian is an application to help you log and keep track of your personal media items, including books, movies, and music. Here are some of the main features:

• View on the homepage your most recently added media items.
• View all of the media items currently in your inventory.
• Add a new item
  • Your choices are Vinyl, Cassette, CD, VHS, DVD, Blu-ray, 4K, Digital Copy, Book, and eBook.
  • When adding a new item, you can search for the media's title to find the cover art. Other metadata includes Condition, Date Purchased (optional), and any notes you would like to make on that item.
• Edit an item
• Delete an item
• Lend an item.
  • This feature allows the user the keep track of items that they lent to friends. You are able to log when it was lent out, the condition it was in, who you lent it to, and any other notes the user would like to make.
  • View lent out items
• Sell an item.
  • This feature allows the user to keep track of the items they've sold. This provides a similar "peace of mind" that the lend items feature affords, where if you cannot find something at your house, you can check to make sure you didn't sell it, or lend it out.
  • View sold items. A user can see when the item was sold, who it was sold to, and how much money you made from it (optional).

Technologies Used

I used a vast assortment of full-stack tools to build Stuffy Librarian. I used Visual Studio for the entire project. For the back-end, I used ASP.NET (.NET Framework), SQL Server Management Studio, and Dapper. For the front-end, I used AngularJS as a JS framework, Bootstrap 4, and several other helpful tools such as Toastr and ChartJS.

Want to try it out?

Please feel free to clone down my repo, and give the app a whirl!

Things you'll need:

• A PC, or a Mac with a PC virtual machine.
• Visual Studio
• SQL Server Management Studio
• The DB table script. You can find this in the folder SQL Scripts > DatabaseScript.sql.

Install Dependencies

There shouldn't be any necessary dependencies or packages to install. If you run the solution and get unexpected errors, please feel free to contact me at davidtdassau@gmail.com.