public ActionResult Show(string id)
{
//find data about the individual owner
string main_query = "select * from Owners where OwnerID = @id";
var pk_parameter = new SqlParameter("@id", id);
Owner Owner = db.Owners.SqlQuery(main_query, pk_parameter).FirstOrDefault();
//find data about all pets that owner has (through id)
//remember to check the generated column names! (SQL Server Object Explorer)
string aside_query = "select * from Pets inner join PetOwners on Pets.PetID = PetOwners.Pet_PetID where PetOwners.Owner_OwnerID=@id";
var fk_parameter = new SqlParameter("@id", id);
List <Pet> OwnedPets = db.Pets.SqlQuery(aside_query, fk_parameter).ToList();
//find data about GroomBookings billed to this owner
string booking_query = "select * from GroomBookings where GroomBookings.OwnerID=@id";
var booking_parameter = new SqlParameter("@id", id);
List <GroomBooking> BilledGrooms = db.GroomBookings.SqlQuery(booking_query, booking_parameter).ToList();
string all_pets_query = "select * from Pets";
List <Pet> AllPets = db.Pets.SqlQuery(all_pets_query).ToList();
//ViewModel is a hybrid of three classifications of information
//(1) showing the classic owner data
//(2) showing all pets that owner has
//(3) showing all pets in general (for ADD)
ShowOwner viewmodel = new ShowOwner();
viewmodel.owner = Owner;
viewmodel.pets = OwnedPets;
viewmodel.all_pets = AllPets;
viewmodel.billedgrooms = BilledGrooms;
return(View(viewmodel));
}
private void BtnShow_Click(object sender, RoutedEventArgs e)
{
ShowOwner showOwnerWindow = new ShowOwner(owner);
showOwnerWindow.Show();
}
