public List <Courses> EECourse()
 {
     try
     {
         List <Courses> ct = null;
         try
         {
             string             sql       = "select * from dbo.Table_Courses where DepartmentID = @DepartmentID";
             List <DbParameter> ParamList = new List <DbParameter>();
             SqlParameter       p1        = new SqlParameter("@DepartmentID", SqlDbType.VarChar);
             p1.Value = 1003;
             ParamList.Add(p1);
             DataTable dt = _idac.GetManyRowsandColumns(sql, ParamList);
             ct = DBList.ToList <Courses>(dt);
         }
         catch (Exception)
         {
             throw;
         }
         return(ct);
     }
     catch (Exception)
     {
         throw;
     }
 }
 public List <Student> GetStudentsByCourse(string courseNum)
 {
     try
     {
         List <Student> SList = null;
         try
         {
             string sql = "select * from Students" +
                          " join StudentCourses sc on s.StudentId = sc.StudentId" +
                          " where sc.CourseNum = @CourseNum ";
             List <DbParameter> paramList = new List <DbParameter>();
             SqlParameter       p1        = new SqlParameter("@CategoryId", SqlDbType.VarChar);
             p1.Value = courseNum;
             paramList.Add(p1);
             DataTable dt = _idac.GetManyRowsCols(sql, paramList);
             SList = DBList.ToList <Student>(dt);
         }
         catch (Exception)
         {
             throw; //NO STUDENT WHATEVER
         }
         return(SList);
     }
     catch (Exception)
     {
         throw; //no such class exist
     }
 }
        public List <Course> GetAllCourse()
        {
            List <Course> CourseList = null;

            try
            {
                string    sql = "select * from Courses";
                DataTable dt  = _idac.GetManyRowsCols(sql, null);
                CourseList = DBList.ToList <Course>(dt);
            }
            catch (Exception)
            { throw; }
            return(CourseList);
        }
 public List <Course> GetCoursesBySemester(string semester)
 {
     try
     {
         List <Course> courseList = new List <Course>();
         Console.WriteLine("Semester: " + semester);
         string sql = "select * from Courses c "
                      + " join CoursesOffered co on c.CourseNum = co.CourseNum"
                      + " where co.Semester = @semester";
         List <DbParameter> paramList = new List <DbParameter>();
         SqlParameter       p1        = new SqlParameter("@semester", SqlDbType.VarChar);
         p1.Value = semester;
         paramList.Add(p1);
         DataTable dt = _idac.GetManyRowsCols(sql, paramList);
         courseList = DBList.ToList <Course>(dt);
         return(courseList);
     }
     catch (Exception)
     {
         throw; //semester not found
     }
 }