Models.Event.GetNextEvent C# (CSharp) Method

        public static Event GetNextEvent()
        {
            var data = new ICCData();
            var nextevent = data.Events.Where(e => e.StartOn.Date >= DateTime.Today)
                .OrderBy(e=>e.StartOn).FirstOrDefault();

            return nextevent;
        }

        public static List <Session> GetAllSessions()
        {
            var ctx = new ICCData();


            int eId = Event.GetNextEvent().Id;



            var sessions = from s in ctx.Sessions
                           where s.EventId == eId && s.IsApproved
                           select s;

            var sessions1 = ctx.Sessions.Where(sess => sess.EventId == eId);

            return(sessions.ToList());
        }