public List <string> GetPreRequisiteCourses(string courseNum)
{
List <string> CList = new List <string>();
try
{
string sql = "select PreReqCourseNum from CoursePreRequisites where CourseNum=@CourseNum";
List <SqlParameter> PList = new List <SqlParameter>();
DBHelper.AddSqlParam(PList, "@CourseNum", SqlDbType.VarChar, courseNum, 50);
DataTable dt = DataLayer.DataAccess.GetManyRowsCols(sql, PList);
CList = DBList.GetListValueType <string>(dt, "PreReqCourseNum");
}
catch (Exception)
{
throw;
}
return(CList);
}
public List <string> GetCoursesOfferedForASemester(string semester)
{
List <string> CList = new List <string>();
try
{
string sql = "select CourseNum from CoursesOffered where SemesterId=@SemesterId";
List <SqlParameter> PList = new List <SqlParameter>();
DBHelper.AddSqlParam(PList, "@SemesterId", SqlDbType.VarChar, semester, 20);
DataTable dt = DataAccess.GetManyRowsCols(sql, PList);
// convert dt to List<string>
//foreach (DataRow dr in dt.Rows)
// CList.Add(dr["CourseNum"].ToString());
CList = DBList.GetListValueType <string>(dt, "CourseNum");
}
catch (Exception)
{
throw;
}
return(CList);
}
public List <CourseEnrollmentVM> GetCourseEnrollment(string semester, string courseNum)
{
List <CourseEnrollmentVM> CList = new List <CourseEnrollmentVM>();
try
{
string sql = "select s.StudentId, s.FirstName, s.LastName, s.Email, c.Credits," +
"d.DepartmentName as Major from Students s " +
"inner join CourseEnrollments ce on s.StudentId=ce.StudentId " +
"inner join Courses c on ce.CourseNum=c.CourseNum " +
"inner join StudentDepartments sd on s.StudentId=sd.StudentId " +
"inner join Departments d on sd.DepartmentId=d.DepartmentId " +
"where ce.SemesterId=@SemesterId and ce.CourseNum=@CourseNum";
List <SqlParameter> PList = new List <SqlParameter>();
DBHelper.AddSqlParam(PList, "@SemesterId", SqlDbType.VarChar, semester, 20);
DBHelper.AddSqlParam(PList, "@CourseNum", SqlDbType.VarChar, courseNum, 50);
DataTable dt = DataAccess.GetManyRowsCols(sql, PList);
// convert datatable to List<CurseEnrollmentVM>
CList = DBList.GetList <CourseEnrollmentVM>(dt);
//foreach (DataRow dr in dt.Rows)
//{
// CourseEnrollmentVM cevm = new CourseEnrollmentVM();
// cevm.StudentId = (long)dr["StudentId"];
// cevm.FirstName = (string)dr["FirstName"];
// cevm.LastName = (string)dr["LastName"];
// cevm.Email = (string)dr["Email"];
// cevm.Major = (string)dr["Major"];
// cevm.Credits = (int)dr["Credits"];
// CList.Add(cevm);
//}
}
catch (Exception)
{
throw;
}
return(CList);
}
