public List <Member> GetAlcoolicStudents()
{
using (Db2019EventsStudentEntities context = new Db2019EventsStudentEntities())
{
return(context.Participations.Include("Drinks.DrinkType").Include("Member").Where(p => p.Drinks.All(d => d.DrinkType.AlcoholContent != 0)).Select(p => p.Member).ToList());
}
}
public static List <DrinkType> Get()
{
using (Db2019EventsStudentEntities context = new Db2019EventsStudentEntities())
{
return(context.DrinkTypes.ToList());
}
}
public List <Member> GetStudentsNoDepense()
{
using (Db2019EventsStudentEntities context = new Db2019EventsStudentEntities())
{
return(context.Participations.Include("Drinks").Include("Member").Where(p => p.Drinks.Count == 0).Select(p => p.Member).ToList());
}
}
public List <Member> GetSeriousMember()
{
using (Db2019EventsStudentEntities context = new Db2019EventsStudentEntities())
{
return(context.Members.Include("Participations").Where(m => m.Participations.Count == 0).ToList());
}
}
public static List <Participation> Get(int id)
{
using (Db2019EventsStudentEntities context = new Db2019EventsStudentEntities())
{
return(context.Events.Include("Participations.Member").FirstOrDefault(e => e.Id == id).Participations.ToList());
}
}
public static List <Event> Get()
{
using (Db2019EventsStudentEntities context = new Db2019EventsStudentEntities())
{
return(context.Events.Include("Association").ToList());
}
}
public static int AddDrink(Drink drink)
{
using (Db2019EventsStudentEntities context = new Db2019EventsStudentEntities())
{
context.DrinkTypes.Attach(drink.DrinkType);
context.Drinks.Add(drink);
return(context.SaveChanges());
}
}