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"); } }
public string AddPet(Pet pet) { var db = new s19562Context(); var rasa = pet.IdBreedType; var exist = db.BreedType.Any(i => i.IdBreedType == rasa); if (!exist) { var maxId = db.BreedType.Max(a => a.IdBreedType); var BreedType = new BreedType { IdBreedType = maxId + 1 }; db.BreedType.Add(BreedType); } db.Pet.Add(pet); db.SaveChanges(); return("zwierze dodane --> sprawdz"); }
public EfAnimalDbService(s19562Context context) { _context = context; }