public List <AppCourse> getCourseList(String programId)
{
DBUtils dbUtils1 = new DBUtils();
SqlDataReader attributeListReader1 = dbUtils1.readOperation("SELECT * FROM App_Course where App_Program_program_id = " + programId);
List <AppCourse> courseList = new List <AppCourse>();
while (attributeListReader1.Read())
{
AppCourse att2 = new AppCourse();
att2.courseId = (int)attributeListReader1["course_id"];
att2.courseName = attributeListReader1["course_name"].ToString();
courseList.Add(att2);
}
dbUtils1.closeDBConnection();
return(courseList);
}
public List <AppCourse> getCourseList()
{
DBUtils dbUtils1 = new DBUtils();
SqlDataReader attributeListReader1 = dbUtils1.readOperation("SELECT * FROM App_Course");
List <AppCourse> courseList = new List <AppCourse>();
while (attributeListReader1.Read())
{
AppCourse att2 = new AppCourse();
att2.courseId = (int)attributeListReader1["course_id"];
att2.courseName = attributeListReader1["course_name"].ToString();
String courseNumber = attributeListReader1["COURSE_NUMBER"].ToString();
att2.courseName = att2.courseName + " (" + courseNumber + ")";
courseList.Add(att2);
}
dbUtils1.closeDBConnection();
return(courseList);
}
