public Class1()
{
db2019EventsStudentEntities = new Db2019EventsStudentEntities();
//student only alcool
db2019EventsStudentEntities.Drink.Where(d => d.DrinkType.AlcoholContent != 0).Select(d => d.MemberId).Distinct().ToList();
//student event free
db2019EventsStudentEntities.Participation.Where(p => p.Credit == 0).Select(p => p.MemberId).Distinct().ToList();
}
public static List <DrinkTypeModel> Get()
{
using (var context = new Db2019EventsStudentEntities())
{
return(context.DrinkType.Select(d => new DrinkTypeModel()
{
Decription = d.Description, Id = d.Id, AlcoholContent = (double)d.AlcoholContent
}).ToList());
}
}
public EventService()
{
context = new Db2019EventsStudentEntities();
}
