public Hobby AddHobby(Hobby hobby)
{
HobbyDBContext dbContext = new HobbyDBContext();
dbContext.Hobbies.Add(hobby);
dbContext.SaveChanges();
return(hobby);
}
public List <Hobby> GetHobbiesForPerson(int personID)
{
HobbyDBContext dbContext = new HobbyDBContext();
var hobbies = dbContext.Persons.Include("Hobbies").Where(p => p.PersonID == personID).Select(p => p.Hobbies).FirstOrDefault();
;
return(hobbies.ToList());
}
public Hobby GetHobby(int hobbyID)
{
HobbyDBContext dbContext = new HobbyDBContext();
return(dbContext.Hobbies.Where(x => x.HobbyID == hobbyID).FirstOrDefault());
}
public Person GetPerson(int personID)
{
HobbyDBContext dbContext = new HobbyDBContext();
return(dbContext.Persons.Where(x => x.PersonID == personID).FirstOrDefault());
}
public int GetCountOfPeopleInterestedInHobby(int hobbyID)
{
HobbyDBContext dbContext = new HobbyDBContext();
return(dbContext.Hobbies.Include("Hobbies").Where(h => h.HobbyID == hobbyID).Select(h => h.People).FirstOrDefault().Count());
}