.NET II Final Project: WhereToWatch v3.0

WhereToWatch v3.0 is a media search tool that I made for my .NET II Final Project in Jim Glasgow's class at Kirkwood Community College. v3.0 includes a desktop app that integrates with a website through ASP.NET. Results are pulled from TheMovieDB's API, then stored in the Microsoft SQL Server Database. User Favorites are also stored in the local database.

During this semester we learned more C#, more visual studio, using a database with our program, and integrating ASP.NET into our project so our desktop program has and integrates with our website. When it came to ASP.NET we learned a code first approach for websites, we learned and used Views, and learned and used Controllers.

IMPORTANT STEPS FOR TESTING

1. Add your API Key to MediaLogicLayer/MediaAPI.cs
2. Add the name of your SQL Server Instance to each sqlcmd command in create_db.bat (the default is sqlexpress)
3. Add the name of your SQL Server Instance to the _connectionString in MediaDataAccess/DBConnection.cs
4. Switch the current startup project between WpfPresentation(DESKTOP APP) and WebPresentation(WEBSITE), or set both of them to start in Multiple startup projects.

Usage/Features

1. First we run the create_db.bat file, this file will run all our SQL scripts and create our stored procedures and test data.
2. We open the landing page.
3. We search for any movie or tv show.
4. The result page of an item.
5. We login or register for an account if we don't have one.
6. We have successfully registered, and have been given a default password of "newuser", which the system will require us to change upon first login.
7. We can now add an item to our favorites list, which is now stored in the database.
8. We can now display our favorites list within the program, the results being loaded from the database.
9. Switching over to the web portion, we are presented with the landing page.
10. We can view all movies and tv-shows in the database.
11. For all movies in the DB, we can view their details, edit their details, and delete them from the DB.
12. Trending Movies and Trending TV Shows
13. We register for an account or login if we already have one.
14. We can now view our favorites, which has our tv-show that we favorited on the desktop app. Here we can delete it, or add more items to our favorites, either through the desktop app or through the web portion.