public List <Espece> GetAll()
{
using (JeuDontOnEstLeHerosEntities context = new JeuDontOnEstLeHerosEntities())
{
return((from e in context.Espece select e).ToList());
}
}
public List <Paragraphe> GetAll()
{
using (JeuDontOnEstLeHerosEntities context = new JeuDontOnEstLeHerosEntities())
{
return((from para in context.Paragraphe
select para).ToList());
}
}
public void Save(Avatar avatar)
{
using (JeuDontOnEstLeHerosEntities context = new JeuDontOnEstLeHerosEntities())
{
context.Avatar.Add(avatar);
context.SaveChanges();
}
}
public List <Question> GetAll()
{
using (JeuDontOnEstLeHerosEntities context = new JeuDontOnEstLeHerosEntities())
{
return((from q in context.Question
select q).ToList());
}
}
public Question GetQuestion(Paragraphe p)
{
using (JeuDontOnEstLeHerosEntities context = new JeuDontOnEstLeHerosEntities())
{
return((from q in context.Question
where p.Id == q.ParagrapheId
select q).Single());
}
}
public Paragraphe GetOne(int id)
{
using (JeuDontOnEstLeHerosEntities context = new JeuDontOnEstLeHerosEntities())
{
return((from para in context.Paragraphe
where para.Id == id
select para).Single());
}
}
public Avatar GetOne(int id)
{
using (JeuDontOnEstLeHerosEntities context = new JeuDontOnEstLeHerosEntities())
{
return((from a in context.Avatar
where a.Id == id
select a).Single());
}
}
public List <Reponse> GetReponses(Question question)
{
using (JeuDontOnEstLeHerosEntities context = new JeuDontOnEstLeHerosEntities())
{
return((from r in context.Reponse
where question.Id == r.QuestionId
select r).ToList());
}
}
public Question GetOne(int id)
{
using (JeuDontOnEstLeHerosEntities context = new JeuDontOnEstLeHerosEntities())
{
return((from q in context.Question
where q.Id == id
select q).Single());
}
}
