public List <ShowPet> GetPets()
{
var db = new s19562Context();
var listPets = db.Pet.ToList();
List <ShowPet> listShowPets = new List <ShowPet>();
foreach (Pet p in listPets)
{
var id = db.VolunteerPet.Where(id => id.PetIdPet == p.IdPet).Select(a => a.VolunteerIdVolunteer).FirstOrDefault();
var volunteerss = db.Volunteer.Where(v => v.IdVolunteer == id).ToList();
var show = new ShowPet
{
pet = p,
volunteers = volunteerss
};
listShowPets.Add(show);
}
var goodListShowPets = listShowPets.OrderBy(d => d.pet.DateRegistered).ToList();
return(goodListShowPets);
}
public List <ShowPet> GetPets(DateTime DateRegistered)
{
try
{
var db = new s19562Context();
var listPets = db.Pet.ToList();
List <ShowPet> listShowPets = new List <ShowPet>();
foreach (Pet p in listPets)
{
var id = db.VolunteerPet.Where(id => id.PetIdPet == p.IdPet).Select(a => a.VolunteerIdVolunteer).FirstOrDefault();
var volunteerss = db.Volunteer.Where(v => v.IdVolunteer == id).ToList();
var show = new ShowPet
{
pet = p,
volunteers = volunteerss
};
listShowPets.Add(show);
}
var showWithDatePets = listShowPets.Where(d => d.pet.DateRegistered.Year == DateRegistered.Year).OrderBy(d => d.pet.DateRegistered).ToList();
return(showWithDatePets);
}
catch
{
throw new Exception("zla data");
}
}
// GET: Pet/Details/5
public ActionResult Show(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
// Pet pet = db.Pets.Find(id); //EF 6 technique
Pet Pet = db.Pets.SqlQuery("select * from pets where petid=@PetID", new SqlParameter("@PetID", id)).FirstOrDefault();
if (Pet == null)
{
return(HttpNotFound());
}
//check to see if this pet is owned by the logged in user
Debug.WriteLine("User Owns pet? " + UserManager.IsUserPetOwner(Pet));
//the user does not own a pet
if (!UserManager.IsUserPetOwner(Pet))
{
return(new HttpStatusCodeResult(HttpStatusCode.Forbidden));
}
//need information about the list of owners associated with that pet
string query = "select * from owners inner join PetOwners on Owners.OwnerID = PetOwners.Owner_OwnerID where Pet_PetID = @id";
SqlParameter param = new SqlParameter("@id", id);
List <Owner> PetOwners = db.Owners.SqlQuery(query, param).ToList();
//need information about the grooms booked for this pet
//note: would do a standard join to get the owner of this booking
//however, cannot force this information into the model
//must use linq in this situation
List <GroomBooking> BookedGrooms = db.GroomBookings.Include(b => b.Owner).ToList();
ShowPet viewmodel = new ShowPet();
viewmodel.pet = Pet;
viewmodel.owners = PetOwners;
viewmodel.bookedgrooms = BookedGrooms;
return(View(viewmodel));
}
// GET: Pet/Details/2
public ActionResult Details(int id)
{
ShowPet ViewModel = new ShowPet();
string url = "petdata/findpet/" + id;
HttpResponseMessage response = client.GetAsync(url).Result;
//Can catch the status code (200 OK, 301 REDIRECT), etc.
if (response.IsSuccessStatusCode)
{
//Put data into pet data transfer object
PetDto SelectedPet = response.Content.ReadAsAsync <PetDto>().Result;
ViewModel.Pet = SelectedPet;
return(View(ViewModel));
}
else
{
return(RedirectToAction("Error"));
}
}
