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