Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Preview

Start a free Courses trial
to watch this video

Sign up for Treehouse

Exercise: Finishing the "Series" Section

4:35 with James Churchill

Let's take a look at your next exercise: finishing the "Series" section of the web app.

Follow Along

To follow along committing your changes to this course, you'll need to fork the dotnet-comic-book-library-manager repo. Then you can clone, commit, and push your changes to your fork like this:

git clone <your-fork>
cd dotnet-comic-book-library-manager
git checkout tags/v4.1 -b exercise-finishing-the-series-section

Exercise

To finish the exercise, complete the following tasks:

ComicBookLibraryManagerWebApp/Controllers/SeriesController.cs File
  • Update the controller class to inherit from the BaseController class.

Index Action Method

  • Write a query that retrieves a list of series.

Detail Action Method

  • Write a query that retrieves a single series with the ComicBooks navigation property eagerly loaded. Use the action method's id parameter to determine which series to retrieve.

Add POST Action Method

  • Handle adding the series entity to the database.

Edit GET Action Method

  • Write a query to retrieve a single series (same as the query for the Detail action method).

Edit POST Action Method

  • Handle updating the series entity in the database.

Delete GET Action Method

  • Write a query to retrieve a single series (same as the query for the Detail and Edit GET action methods).

Delete POST Action Method

  • Handle deleting the series entity from the database.

ValidateSeries Method

  • Write a query that checks for the existence of a series entity that has the same Title property value as the passed entity.

[MUSIC] 0:00 We've made great progress on the Comic Book Library Manager web app, but 0:04 we're still not done yet. 0:08 We still need to finish the series and artists sections in this. 0:10 The last section of this course, you'll do exactly that by completing two exercises. 0:14 One exercise for each section of the web app that needs to be completed. 0:19 First up, completing the series section. 0:23 Let's start with a quick review of the finished pages. 0:25 Here's the completed version of the web app. 0:29 To browse to the series section, just click on series in the menu. 0:31 We only have three series. 0:37 Bone, The Amazing Spinder-Man and The Invisible Iron-Man. 0:40 To view the detail for the series, click on one of the detail buttons 0:44 displayed to the right of the series titles. 0:48 In addition to the series' title and description, 0:50 the series detail page displays the comic books that are associated with the series. 0:52 And we have buttons that allow us to edit or delete the series. 0:58 The edit Series page allows us to change the series title or description. 1:02 And the Delete Series page allows us to confirm the deletion of a series. 1:07 Clicking the back button returns us to the Series list page. 1:14 To add a series, click on the Add Series button. 1:17 Add a series title, and click the Save button. 1:22 Once the series has been added, we're redirected to the detail page for 1:29 the new series. 1:33 All of the actions for 1:34 the series related pages are defined in the Series Controller Class. 1:35 Let's review the to do comments in this class. 1:42 Our first to do comment is in the index action method. 1:45 We need to write a query that retrieves a list of series. 1:48 Our next to do comment is in the detail action method. 1:52 We need a query to retrieve a single series. 1:55 Use the action methods ID parameter to determine which series to retrieve. 1:59 No changes are needed in the add get action method. 2:04 But in the add post action method, after we validate a series and 2:09 check if the model state is valid, we need to add the series. 2:13 Notice that the action methods parameter is an instance of the series entity class, 2:18 instead of a view model. 2:23 Why bind directly to an entity class, instead of a view model? 2:25 Well, the form to add or edit a series is relatively simple. 2:28 It's just two text fields. 2:33 One for the series title and another for the description. 2:35 While you technically could use a view model in this case 2:38 it certainly isn't necessary. 2:41 As the view doesn't require any additional data items in order to be rendered. 2:43 In the edit get action method we just need a query to retrieve a series. 2:48 You should be able to reuse the query from the detail action method. 2:53 In the edit post action method, afer we validate the series, and 2:57 check if the model's data's valid, we need to update the series. 3:02 And just like the add post action method, the action method's parameter 3:06 is an instance of the series in the class, instead of a view model. 3:10 Now, lets look at the delete action methods. 3:15 In the get action method, 3:17 we need a query to retrieve the series that the user is wanting to delete. 3:19 Again, you should be able to reuse the query from the detail or 3:24 edit get action methods. 3:27 In the post action method, we need to do the actual deletion of the series 3:29 And lastly the validate series method, which checks if the series title that is 3:37 being added isn't already in use by another series. 3:42 To do that you'll need to check for 3:46 the existence of a series that has the same title property value. 3:48 And that's all of the to dos. 3:52 Now it's your turn. 3:55 You can use repositories, or query command classes. 3:56 You could even just use the context directly in the controller action methods. 4:00 The choice is yours. 4:04 I'll be using a repository for my solution. 4:07 Just in case you want to use the same approach as I do. 4:09 The important thing is to try to do the work. 4:12 Even if you don't complete all of the tasks, 4:16 just trying will help you to retain what you learned in this course. 4:18 If you get stuck, be sure to review the ComicBooks controller class, 4:22 as it contains action methods and 4:26 ef queries that are similar to what needs to be done for the series controller. 4:28 In the next video, I'll walk you through my solution. 4:32

You need to sign up for Treehouse in order to download course files.

Sign up