This course will be retired on July 14, 2025.
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
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
ComicBooksnavigation property eagerly loaded. Use the action method'sidparameter 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
Detailaction 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
DetailandEditGET 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
Titleproperty value as the passed entity.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
[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 upYou need to sign up for Treehouse in order to set up Workspace
Sign up