public bool Update(string cuspid, ProgramScheduled e)
        {
            if (e.ScheduledProgramID.Length > 6)
            {
                throw new UniversityException("Characters are Exceeded in ID Field");
            }
            if (e.ProgramName.Length > 20)
            {
                throw new UniversityException("Characters are Exceeded in Program Name Field");
            }
            if (e.ProgramName.Length > 20)
            {
                throw new UniversityException("Characters are Exceeded in Location Field");
            }
            if (e.SessionsPerWeek > 6)
            {
                throw new UniversityException("Sessions Per Week Cannot be more than 6");
            }
            bool updt = false;
            ProgramsScheduledDAL dal = new ProgramsScheduledDAL();

            dal.Update(e.ScheduledProgramID, e.ProgramName, e.Location, e.StartDate, e.EndDate, e.SessionsPerWeek, cuspid);
            updt = true;
            if (updt == false)
            {
                throw new UniversityException("Updation Failed");
            }

            return(updt);
        }
        public bool Add(ProgramScheduled e)
        {
            bool add = false;

            if (e.ScheduledProgramID.Length > 6)
            {
                throw new UniversityException("Characters are Exceeded in ID Field");
            }
            if (e.ProgramName.Length > 20)
            {
                throw new UniversityException("Characters are Exceeded in Program Name Field");
            }
            if (e.ProgramName.Length > 20)
            {
                throw new UniversityException("Characters are Exceeded in Location Field");
            }
            if (e.SessionsPerWeek > 6)
            {
                throw new UniversityException("Sessions Per Week Cannot be more than 6");
            }
            //  DAL object will take programoffered
            ProgramsScheduledDAL dal = new ProgramsScheduledDAL();

            dal.Add(e.ScheduledProgramID, e.ProgramName, e.Location, e.StartDate, e.EndDate, e.SessionsPerWeek);
            add = true;
            if (add == false)
            {
                throw new UniversityException("addtion Failed ");
            }

            return(add);
        }
        public bool Delete(string spid)
        {
            bool dlt = false;
            ProgramsScheduledDAL dal = new ProgramsScheduledDAL();

            dal.Delete(spid);
            dlt = true;
            if (dlt == false)
            {
                throw new UniversityException("Program Deletion failed");
            }
            return(dlt);
        }
        public List <ProgramScheduled> GetAll()
        {
            List <ProgramScheduled> l   = new List <ProgramScheduled>();
            ProgramsScheduledDAL    dal = new ProgramsScheduledDAL();

            if (dal.GetAll().Count > 0)
            {
                l = dal.GetAll();
            }

            else
            {
                throw new UniversityException("Table is Empty");
            }

            return(l);
        }