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