Assignment Task
A web application containing the necessary database and MVC Views has already been created for you. This can be downloaded from the assessments tab on the course website. Your task is to complete several pages:
Views/Owners/Index.cshtml
Views/Owners/Details.cshtml
Views/Courses/Index.cshtml
Views/Courses/Details.cshtml
Views/Enrolments/Index.cshtml
with the necessary layout using the WebMatrix data library, HTML, bootstrap v5.x and @Razor code.
Start by working on the Courses/Index page that allows a person to search the database for courses by keyword in either the title or description. You will need to determine the best layout to present the data to our users and ensure you implement HTML Validation to reduce errors. Once this is working, start implementing the other pages in the order above.
Owner List
This page should display all the Owners listed in the VetCMS database.
Firstly, make sure it displays the name of the owners, their contact and address details in a professional and pleasing manner.
The page should be able to be searched by owner name and/or address and contact information.
For full marks (i.e. HD), owners should also be searchable by animal type and/or if they have had any pets attend training. This search should be presented as an select/dropdown list based on the species available in the database whilst training could be a select/dropdown or checkbox. In addition, the page should show aggregate information such as how many pets of type cat and dog the owner has etc.
Clicking on a single Owner record should navigate to the Owners detail page
Owner Details
This page will be linked to Task 1. As with before, the page needs to include several core components:
The page needs to show the name, contact and address details of the owner selected.
The page also needs to show all the details of the various animals associated with the owner. This includes the species of animal (cat/dog and subtype), age etc.
For full marks (i.e. HD), you need to show all the available detail relating to each animal including things as how many training sessions it’s been to (if it’s a puppy), along with the details of the courses it has enrolled in (trainer, date, outcome If known etc – check the available information)
Course List
This page should list the Courses available in chronological order based on free text search of the course name or description in addition, the ability to choose a course by trainer. An option should toggle between current courses (the default) and past courses. The first item in the list should be the newest course. If no courses are returned by the search then some text stating “no matches” should be shown :
Don’t display the courses in a table. Instead use something that is visually pleasing like bootstrap cards or columns with a background color border and padding. The description should not be shown in its entirety, instead show at most the first
You need to find some sort of image to accompany your courses. An “photo” field has been provided in the database for this purpose – update this with your image URL.
For full marks, consider what aggregate queries you could include (e.g, current enrolments etc)
Course Detail
This page will be linked to Task 3 and display the selected course in detail. The page must show the title, image, description as well as full details of the trainer running the course. Aggregate information could include how many courses the trainer has previously run
Clearly show the course and trainer selected using some sort of bootstrap styled panel or card layout An example could be an Alert box, card or just a typical column/card using the background colors available etc. You could make use of the borders and padding etc. It needs to look good!
No HTML tables should be used.
The page itself, also needs a button/link to return back to the Course list
Enrolments List
This page will be linked to Task 4 via an enrolments button and needs to list the name, dob and details of other dogs involved (gender, age in years etc). Aggregate information could include the number of courses the trainer has run, how many times this type of course has run etc.
The page needs to show the name, image, description of the Course, including the details of the trainer
A button needs to be provided to take the user back to the previous task.
