zita94/vetenarypracticeadminsystem

Console app using Entity Framework and LINQ

Veterinary Practice Admin System using Entity Framework and LINQ

For this assignment, I was tasked with designing, building and deploying an enterprise-style console application to manage a veterinary practice.

I first designed a normalised DB model and used the model-first approach in Entity Framework to generate the schema from the model.

The entity relationship diagram:

I then had to develop a console application to be used as an admin system for the veterinary practice and used LINQ to query the data to provide the following functionality:

List the Names and contact details of all pet owners (customers), sorted by surname.

List the pet name, type and breed of all pets registered with the practice.

Given the registration number, display the name and address of the practice and list the names of all vets working in the practice.

Given a PetId, list the name, type and breed of the pet followed (in chronological order) by the date and reason for all visits by that pet to the practice.

Given a VetId and a specified date, for all pet appointments with that vet on that date, first list the vet's name followed by the list of pets treated (i.e. the pet name) and also the pet owner’s name.

Given a PetNum calculate the cost of the most recent visit to the vet if the charge for an appointment is £40 and two or more medications (which are each an additional cost) have been given to the pet. The output should show the name of the pet and an itemised invoice.

Final Grade: 100
COM580 Enterprise Computing