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);
}