public IEnumerable <round> GetAdHocRoundSet()
        {
            semester adHocSemester = GetAdHocSemester();

            IEnumerable <round> roundSet =
                from rnds in _db.rounds
                where rnds.semesterID == adHocSemester.id
                select rnds;

            return(roundSet);
        }
        public semester GetAdHocSemester()
        {
            round adHocRound = GetAdHocRound();

            semester adHocSemester = null;

            if (adHocRound != null)
            {
                adHocSemester =
                    (from sem in _db.semesters
                     where sem.id == adHocRound.semesterID
                     select sem).FirstOrDefault();
            }

            return(adHocSemester);
        }
        public semester GetLiveSemester()
        {
            round liveRound = GetLiveRound();

            semester liveSemester = null;

            if (liveRound != null)
            {
                liveSemester =
                    (from sem  in _db.semesters
                     where sem.id == liveRound.semesterID
                     select sem).FirstOrDefault();
            }

            return(liveSemester);
        }