Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.

Preview

Start a free Basic 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.
  • 0:00

    [MUSIC]

  • 0:04

    We've made great progress on the Comic Book Library Manager web app, but

  • 0:08

    we're still not done yet.

  • 0:10

    We still need to finish the series and artists sections in this.

  • 0:14

    The last section of this course, you'll do exactly that by completing two exercises.

  • 0:19

    One exercise for each section of the web app that needs to be completed.

  • 0:23

    First up, completing the series section.

  • 0:25

    Let's start with a quick review of the finished pages.

  • 0:29

    Here's the completed version of the web app.

  • 0:31

    To browse to the series section, just click on series in the menu.

  • 0:37

    We only have three series.

  • 0:40

    Bone, The Amazing Spinder-Man and The Invisible Iron-Man.

  • 0:44

    To view the detail for the series, click on one of the detail buttons

  • 0:48

    displayed to the right of the series titles.

  • 0:50

    In addition to the series' title and description,

  • 0:52

    the series detail page displays the comic books that are associated with the series.

  • 0:58

    And we have buttons that allow us to edit or delete the series.

  • 1:02

    The edit Series page allows us to change the series title or description.

  • 1:07

    And the Delete Series page allows us to confirm the deletion of a series.

  • 1:14

    Clicking the back button returns us to the Series list page.

  • 1:17

    To add a series, click on the Add Series button.

  • 1:22

    Add a series title, and click the Save button.

  • 1:29

    Once the series has been added, we're redirected to the detail page for

  • 1:33

    the new series.

  • 1:34

    All of the actions for

  • 1:35

    the series related pages are defined in the Series Controller Class.

  • 1:42

    Let's review the to do comments in this class.

  • 1:45

    Our first to do comment is in the index action method.

  • 1:48

    We need to write a query that retrieves a list of series.

  • 1:52

    Our next to do comment is in the detail action method.

  • 1:55

    We need a query to retrieve a single series.

  • 1:59

    Use the action methods ID parameter to determine which series to retrieve.

  • 2:04

    No changes are needed in the add get action method.

  • 2:09

    But in the add post action method, after we validate a series and

  • 2:13

    check if the model state is valid, we need to add the series.

  • 2:18

    Notice that the action methods parameter is an instance of the series entity class,

  • 2:23

    instead of a view model.

  • 2:25

    Why bind directly to an entity class, instead of a view model?

  • 2:28

    Well, the form to add or edit a series is relatively simple.

  • 2:33

    It's just two text fields.

  • 2:35

    One for the series title and another for the description.

  • 2:38

    While you technically could use a view model in this case

  • 2:41

    it certainly isn't necessary.

  • 2:43

    As the view doesn't require any additional data items in order to be rendered.

  • 2:48

    In the edit get action method we just need a query to retrieve a series.

  • 2:53

    You should be able to reuse the query from the detail action method.

  • 2:57

    In the edit post action method, afer we validate the series, and

  • 3:02

    check if the model's data's valid, we need to update the series.

  • 3:06

    And just like the add post action method, the action method's parameter

  • 3:10

    is an instance of the series in the class, instead of a view model.

  • 3:15

    Now, lets look at the delete action methods.

  • 3:17

    In the get action method,

  • 3:19

    we need a query to retrieve the series that the user is wanting to delete.

  • 3:24

    Again, you should be able to reuse the query from the detail or

  • 3:27

    edit get action methods.

  • 3:29

    In the post action method, we need to do the actual deletion of the series

  • 3:37

    And lastly the validate series method, which checks if the series title that is

  • 3:42

    being added isn't already in use by another series.

  • 3:46

    To do that you'll need to check for

  • 3:48

    the existence of a series that has the same title property value.

  • 3:52

    And that's all of the to dos.

  • 3:55

    Now it's your turn.

  • 3:56

    You can use repositories, or query command classes.

  • 4:00

    You could even just use the context directly in the controller action methods.

  • 4:04

    The choice is yours.

  • 4:07

    I'll be using a repository for my solution.

  • 4:09

    Just in case you want to use the same approach as I do.

  • 4:12

    The important thing is to try to do the work.

  • 4:16

    Even if you don't complete all of the tasks,

  • 4:18

    just trying will help you to retain what you learned in this course.

  • 4:22

    If you get stuck, be sure to review the ComicBooks controller class,

  • 4:26

    as it contains action methods and

  • 4:28

    ef queries that are similar to what needs to be done for the series controller.

  • 4:32

    In the next video, I'll walk you through my solution.

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

Sign up