public Event[] GetAllFutureEvents()
 {
     return(GetSession().CreateQuery(
                "from Event e where e.EndDate >= :datetime order by e.StartDate")
            .SetDateTime("datetime", SystemClockFactory.Default().Now().Midnight())
            .List <Event>().ToArray());
 }
 public Event[] GetFutureForUserGroup(UserGroup usergroup)
 {
     return(GetSession().CreateQuery(
                "from Event e where e.UserGroup = :usergroup and e.EndDate >= :datetime order by e.StartDate")
            .SetEntity("usergroup", usergroup)
            .SetDateTime("datetime", SystemClockFactory.Default().Now().Midnight())
            .List <Event>().ToArray());
 }