internal void AddNewClass() { if (null == SelectedSchoolSemester) { ClassOpertionErrorMesage = "Please select Semester from Semester List"; NotifyPropertyChanged(""); return; } else if (null == SelectedClassType) { ClassOpertionErrorMesage = "Please select Class Type from Class Type List"; NotifyPropertyChanged(""); return; } ClassOpertionErrorMesage = ""; _currentSelectedClass = new SchoolClass(); _currentSelectedClass.Name = "New School Class"; _currentSelectedClass.ClassTypeId = SelectedClassType.Id; _currentSelectedClass.ClassTypeName = SelectedClassType.Name; _currentSelectedClass.SemesterId = SelectedSchoolSemester.Id; _currentSelectedClass.SemesterName = SelectedSchoolSemester.Name; SchoolClassSummary newClassSummary = new SchoolClassSummary(); newClassSummary.Id = _currentSelectedClass.Id; newClassSummary.Name = _currentSelectedClass.Name; newClassSummary.SemesterId = _currentSelectedClass.SemesterId; newClassSummary.ClassTypeId = _currentSelectedClass.ClassTypeId; SelectedSchoolClassSummary = newClassSummary; _schoolClassSummaryList.Add(newClassSummary); ClassOpertionErrorMesage = ""; ShowClassInformationPanel = "Visible"; ClassInformationEditButtonLabel = "Cancel"; CanEditClassIfnormation = true; CanClickClassInformationSave = true; NonClassDateListString = null; NonClassDateList = null; NotifyPropertyChanged(""); }
internal List<SchoolClassSummary> GetRegisteredClassSummariesByStudentIdAndSemesterId(int studentid, int semesterid) { String query = "SELECT * FROM school_class AS sc JOIN student_registered_class AS src ON sc.id = src.class_id " + " WHERE sc.is_active = 1 AND src.is_active = 1 AND src.student_id = " + studentid + " AND sc.semester_id = " + semesterid; List<SchoolClassSummary> rClassSummaries = null; try { SQLiteCommand command = new SQLiteCommand(query, lconn); SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (null == rClassSummaries) rClassSummaries = new List<SchoolClassSummary>(); SchoolClassSummary sClassSummary = new SchoolClassSummary(); sClassSummary.Id = System.DBNull.Value != reader["id"] ? Convert.ToInt32(reader["id"]) : 0; sClassSummary.Name = System.DBNull.Value != reader["name"] ? (String) reader["name"] : null; sClassSummary.SemesterId = System.DBNull.Value != reader["semester_id"] ? Convert.ToInt32(reader["semester_id"]) : 0; sClassSummary.ClassTypeId = System.DBNull.Value != reader["class_type_id"] ? Convert.ToInt32(reader["class_type_id"]) : 0; rClassSummaries.Add(sClassSummary); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return rClassSummaries; }
internal List<SchoolClassSummary> FindAllSchoolClassSummary() { List<SchoolClassSummary> summaries = null; List<SchoolClass> classes = FindAllSchoolClass(); if (null != classes && classes.Count > 0) { summaries = new List<SchoolClassSummary>(); foreach (SchoolClass schoolClass in classes) { SchoolClassSummary summary = new SchoolClassSummary(); summary.Id = schoolClass.Id; summary.Name = schoolClass.Name; summary.SemesterId = schoolClass.SemesterId; summary.ClassTypeId = schoolClass.ClassTypeId; summaries.Add(summary); } } return summaries; }