$1.$ Make sure that your Vet Office database from Lab $4$ has been created on SQL Server.

a$.$ If you had trouble with Lab $4$ you can download the posted solution and run the

database script provided.

$2.$ Create a Class Library project for the middle tier of your $3-$Tier application.

a$.$ Add models for Pet and the Species Lookup values.

$$ Your Pet model should be based on the View created in Lab $4$ so it can work

with your Select stored procedures.

b$.$ Add Interfaces and Repositories for both Models:

$$ For Species, you just need to return a collection suitable as the data

source for a combo box.

$$ For Pet, you need methods for:

$1.$ The $5$ Standard Stored Procedures for the PET table. Don$$t forget about

concurrency on Update.

$2.$ The $$SelectByX$$ stored procedure.

$3.$ Create a UWP Project for the User Interface of your application. You can create it in a

separate project or add the UI project to the same solution as your Class Library.

a$.$ Main Page $$ You MUST display your name on the Main Page!

$$ On the Main Page, provide a title at the top and a grouping of input controls

to match the filters needed for SelectByX except for DOB. That is an optional

bonus.

$1.$ BONUS: Allow filtering for DOB between two selected dates. This is a

not required for the project but can give you bonus marks to

compensate in case you have lost marks somewhere else.

a$.$ If you are going to filter for DOB you should also make sure that

you display the DOB for each Pet shown on the main page.

$2.$ Have Filter and Clear buttons to apply the filter or clear out all filter

options and display all the records again.

$$ Use a GridView to display the data for all of the Pets.

$1.$ For each Pet, display the Name, Species, DOB and the number of

owners.

$2.$ Allow the User to click on a Pet to select it for Update or Delete on a

separate Details page.

$$ Have a button on the Main page for adding a new Pet on the Details page.

b$.$ Details Page

$$ Add the Details page and make sure it has input controls to match each of the

properties of the Pet that a user might need to enter or update. It should also

have buttons for Save, Cancel and Delete

$$ The Save button must save the Pet. If you are adding a new Pet, it should call

the Insert method of your repository. If you are Updating a Pet in the system,

then if should call the Update method.

$1.$ Before saving, always validate the data entered by the user and give

feedback to them about any problems that you find.

$$ The Delete button must call the Delete method of your repository:

$1.$ The Delete button should be disabled if you are adding a new Pet.

$2.$ You must ask the User to confirm that they really want to Delete the Pet

before carrying out the Delete operation.

$$ The Cancel button should just return to the Main Page.