public static List <CourseProgrammePart> readCourseProgrammePart(Programme programme) { List <CourseProgrammePart> courseProgrammePartList = new List <CourseProgrammePart>(); String readCSECoursesStatement = "SELECT * FROM CourseProgrammePart WHERE PROGRAMMEID = '" + programme.id + "'"; try { dbConnection.Open(); sqlCommand = new SQLiteCommand(readCSECoursesStatement, dbConnection); dataReader = sqlCommand.ExecuteReader(); while (dataReader.Read()) { CourseProgrammePart courseProgrammePart = new CourseProgrammePart(dataReader["COURSEID"].ToString(), dataReader["PART"].ToString(), dataReader["PROGRAMMEID"].ToString()); courseProgrammePartList.Add(courseProgrammePart); } dbConnection.Close(); } catch (Exception e) { Logger.Error("DatabaseConnection::readCourseProgrammePart() " + e.Message); } return(courseProgrammePartList); }
public static List<CourseProgrammePart> readCourseProgrammePart(Programme programme) { List<CourseProgrammePart> courseProgrammePartList = new List<CourseProgrammePart>(); String readCSECoursesStatement = "SELECT * FROM CourseProgrammePart WHERE PROGRAMMEID = '" + programme.id + "'"; try { dbConnection.Open(); sqlCommand = new SQLiteCommand(readCSECoursesStatement, dbConnection); dataReader = sqlCommand.ExecuteReader(); while (dataReader.Read()) { CourseProgrammePart courseProgrammePart = new CourseProgrammePart(dataReader["COURSEID"].ToString(), dataReader["PART"].ToString(), dataReader["PROGRAMMEID"].ToString()); courseProgrammePartList.Add(courseProgrammePart); } dbConnection.Close(); } catch (Exception e) { Logger.Error("DatabaseConnection::readCourseProgrammePart() " + e.Message); } return courseProgrammePartList; }