public List<SchoolSemester> FindAllSchoolSemester()
{
String query = "SELECT * FROM school_semester;";
List<SchoolSemester> semesters = new List<SchoolSemester>();
try
{
SQLiteCommand command = new SQLiteCommand(query, conn);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
SchoolSemester semester = new SchoolSemester();
semester.Id = System.DBNull.Value != reader["id"] ? Convert.ToInt32(reader["id"]) : 0;
semester.Name = System.DBNull.Value != reader["name"] ? (String)reader["name"] : null;
semester.StartDate = System.DBNull.Value != reader["start_date"] ? (DateTime?)reader["start_date"] : (DateTime?)null;
semester.EndDate = System.DBNull.Value != reader["end_date"] ? (DateTime?)reader["end_date"] : (DateTime?)null;
semesters.Add(semester);
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
return semesters;
}
internal void SetStudentModel(StudentModel studentModel)
{
_studentModel = studentModel;
ShowStudentTabControl = "Hidden";
_lastNameList = _studentModel.FindAllStudentLastName();
_firstNameList = _studentModel.FindAllStudentFirstName();
_semesterList = _studentModel.FindAllSemesterList();
_curSemester = _studentModel.FindCurrentSchoolSemester();
if (null != _curSemester)
CurrentSemester = _curSemester;
NotifyPropertyChanged("");
}
