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()); } }