public static List <Member> GetEtudiantAlcool()
{
using (var context = new ProjectFinalEntities())
{
return(context.Member.Where(m => m.Participation.Any(p => p.Drink.Any(d => d.DrinkType.AlcoholContent > 0))).ToList());
}
}
public static List <Member> GetEtudiantNoDepense()
{
using (var context = new ProjectFinalEntities())
{
return(context.Member.Where(m => m.Participation.Any(p => p.Drink.Count() == 0)).ToList());
}
}
public static List <Member> GetEtudiantSerieux()
{
using (var context = new ProjectFinalEntities())
{
return(context.Member.Where(m => m.Participation.Count() == 0).ToList());
}
}
public static List <DrinkType> Get()
{
using (var context = new ProjectFinalEntities())
{
return(context.DrinkType.ToList());
}
}
public static List <Participation> GetParticipant(int id)
{
using (var context = new ProjectFinalEntities())
{
return(context.Participation.Include("Member").Where(p => p.EventId == id).ToList());
}
}
public static List <Event> Get()
{
using (var context = new ProjectFinalEntities())
{
return(context.Event.Include("Association").ToList());
}
}
public static int Create(Drink drink)
{
using (var context = new ProjectFinalEntities())
{
drink.Participation = context.Participation.FirstOrDefault(p => p.MemberId == drink.MemberId && p.EventId == drink.EventId);
drink.DrinkType = context.DrinkType.FirstOrDefault(d => d.Id == drink.DrinkTypeId);
context.Drink.Attach(drink);
context.Drink.Add(drink);
return(context.SaveChanges());
}
}
