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