private List <SimpleType <int> > GetAllIds()
{
var fillIds = Fillables.CreateFillSimpleType <int>("EventId");
IEnumerable <SimpleType <int> > allIds =
DataBases.Access <SimpleType <int> >(BaseNames.SikonDatabase, "Event").Get(fillIds);
return(new List <SimpleType <int> >(allIds));
}
public List <int> Get(int EventID)
{
var fillInts = Fillables.CreateFillSimpleType <int>("UserId");
List <SimpleType <int> > containedUserIds = bookedEventsManager.GetCustomQuery(fillInts,
"Select BookedEvents.UserId from BookedEvents Inner Join BookingSettings on BookingSettings.UserId = BookedEvents.UserId where BookingSettings.ReceiveMessages = 1 and BookedEvents.EventId = " + EventID);
List <int> userIds = new List <int>(containedUserIds.Count);
foreach (SimpleType <int> containedUserId in containedUserIds)
{
userIds.Add(containedUserId.Variable);
}
return(userIds);
}