public List <Elective> FindSSElectives(string tableName) { String query; List <Elective> result = new List <Elective>(); DataTable Computer_Engineering_Courses; List <Course> nonhist = new List <Course>(); Elective history = new Elective("History", 9); Elective ss = new Elective("Humanities", 9); query = "SELECT * FROM " + tableName + "_SSElectives"; Computer_Engineering_Courses = GraduationPlanningSystem.db.queryDB(query); foreach (DataRow req_course in Computer_Engineering_Courses.Select()) { // this should give you the uid of each course in the Computer_Engineering_Req table String course_uid = (String)req_course[0]; Course course = new Course(course_uid, Course.AcademicStatus.NotYetTaken); if (course.Name != "" && course.Name != null) { if (course.Department == "History") { history.Courses.Add(course); } else { ss.Courses.Add(course); } } } result.Add(history); result.Add(ss); return(result); }
public List <Course> FindElectives(string tableName) { String query; DataTable Computer_Engineering_Courses; List <Course> result = new List <Course>(); query = "SELECT * FROM " + tableName + "_Electives"; Computer_Engineering_Courses = GraduationPlanningSystem.db.queryDB(query); foreach (DataRow req_course in Computer_Engineering_Courses.Select()) { // this should give you the uid of each course in the Computer_Engineering_Req table String course_uid = (String)req_course[0]; Course course = new Course(course_uid, Course.AcademicStatus.NotYetTaken); if (course.Name != "" && course.Name != null) { result.Add(course); } } return(result); }