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 "Artists" 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.2 -b exercise-finishing-the-artists-section
Exercise
To finish the exercise, complete the following tasks:
ComicBookLibraryManagerWebApp/Controllers/ArtistsController.cs File
- Update the controller class to inherit from the BaseController class.
Index Action Method
- Write a query that retrieves a list of artists.
Detail Action Method
- Write a query that retrieves a single artist with the
ComicBooks,ComicBooks.ComicBook,ComicBooks.ComicBook.Series, andComicBooks.Rolenavigation properties eagerly loaded. Use the action method'sidparameter to determine which artist to retrieve.
Add POST Action Method
- Handle adding the artist entity to the database.
Edit GET Action Method
- Write a query to retrieve a single artist (same as the query for the
Detailaction method).
Edit POST Action Method
- Handle updating the artist entity in the database.
Delete GET Action Method
- Write a query to retrieve a single artist (same as the query for the
DetailandEditGET action methods).
Delete POST Action Method
- Handle deleting the artist entity from the database.
ValidateArtist Method
- Write a query that checks for the existence of an artist entity that has the same
Nameproperty 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
Just one more section to complete,
the artist section.
0:00
Let's start with reviewing
the finished pages.
0:03
Here, again,
is the completed version of the web app.
0:07
Click on the artist menu to
browse to the artist section.
0:10
We currently have a total of six artists.
0:13
Just like with the comic books or
series lists,
0:16
you can click on one of the detail buttons
to view the detail for the artist.
0:19
In addition to the artist's name,
the artist detail page displays a list of
0:23
comic books that the artist
is associated with,
0:27
along with each comic book's published
on date and the artist's role.
0:30
And we have buttons that allow
us to edit or delete an artist.
0:37
The edit artist page allows us
to change an artist's name.
0:41
And the delete artist page allows us
to confirm the deletion of an artist.
0:48
Clicking the back button returns
us to the artists list page.
0:54
To add an artist,
click on the Add Artist button.
0:58
After the artist is added to the database,
we're redirected to the detail page for
1:09
the new artist.
1:14
As you might expect,
all of the actions for
1:15
the artists related pages are defined
in the artist controller class.
1:17
Completing the artist section
will be a very similar process
1:22
to completing the series section.
1:26
If you're comfortable with
what needs to be done,
1:28
feel free to skip the rest of this video.
1:30
Otherwise, continue watching, and we'll
review the to do comments in this class.
1:33
Our first to do comment is
in the index action method
1:38
where we need to write a query
that retrieves a list of artists.
1:41
The next to do comment is in
the detail action method.
1:45
We need a query to
retrieve a single artist.
1:48
You'll need to use the action
methods ID parameter
1:51
to determine which artist to retrieve.
1:54
Just as it was when implementing
the series section,
1:57
no changes are needed in
the AddGetAction method.
2:00
But in the AddPostAction method we need
to add the artist after we validate
2:06
the artist and
check to see if the model state is valid.
2:11
And again the ActionsMethodParameter is
an instance of the artist in the class,
2:15
instead of a view model.
2:20
In the EditGetAction method we need
a query to retrieve an artist.
2:22
Just like the query that you'll write for
the DetailedAction method.
2:26
In the EditPostAction method,
after validating the artist and
2:31
checking to see if the model state is
valid, we need to update the artist.
2:35
And just like the AddPostAction method,
we're using an instance of artist
2:40
entity class instead of a view model for
the action methods parameter type.
2:44
Next, the DeleteAction methods.
2:50
In the GetAction method, we need a query
to retrieve the artist that the user
2:53
is wanting to delete, which again should
be the same query that you'll write for
2:57
the detail or edit GetAction methods.
3:01
And in the PostAction method, we need to
do the actual deletion of the artist.
3:04
And finally, in the ValidateArtist method,
which checks if the artist name that is
3:10
being added,
isn't already in use by another artist.
3:15
You'll need to check with
the existence of an artist,
3:19
that has the same name property.
3:21
And that's all of the to do's.
3:23
Just like with the series section
exercise, you can use repositories or
3:26
query command classes, or
3:31
you could use the context directly
in the controller action methods.
3:33
You can use the same approach for
consistency's sakes, or
3:37
try something new, whichever you prefer.
3:41
If you get stuck, be sure to review
the series controller class and
3:44
the series repository class
if it used a repository.
3:48
As it contains action methods and
EF queries
3:52
that are very similar to what needs to
be done with the artist controller.
3:54
In the next video I'll walk
you through my solution.
3:58
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