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