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