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