private void StudentsListButton_Click(object sender, RoutedEventArgs e)
{
ClassroomDisplay classroomDisplay = (ClassroomDisplay)((FrameworkElement)sender).DataContext;
MainWindow window = GlobalFunction.GetMainWindow();
window._mainFrame.Navigate(new studentsPage(classroomDisplay.ID));
}
private void ClassroomOptionsButton_Click(object sender, RoutedEventArgs e)
{
ClassroomDisplay classroomDisplay = (ClassroomDisplay)((FrameworkElement)sender).DataContext;
MainWindow window = GlobalFunction.GetMainWindow();
window._mainFrame.Navigate(new ClassroomsOptions(classroomDisplay.ID));
window._addFrame.Navigate(new AddHomeworkClassroom(classroomDisplay.ID));
}
public ClassroomsPage()
{
classroomCollection = new ObservableCollection <ClassroomDisplay>();
InitializeComponent();
classroomList.ItemsSource = classroomCollection;
using SQLiteCommand cmd = GlobalFunction.OpenDbConnection();
cmd.CommandText = "SELECT * FROM classrooms";
using SQLiteDataReader rdr = cmd.ExecuteReader();
//TODO: Rework this to work with nextDate
while (rdr.Read())
{
int classroomId = rdr.GetInt32(0);
List <ScheduleInfo> scheduleClassroomList = ClassroomsShared.GetSchedulesFromClassroomId(classroomId);
string scheduleTime;
int dayToSessionTemp = 14;
ScheduleInfo selectedSchedule = new ScheduleInfo();
if (scheduleClassroomList.Count != 0)
{
for (int i = 0; i < scheduleClassroomList.Count; i++)
{
int daysToNextSession = ClassroomsShared.GetNumberOfDaysToNextSession(scheduleClassroomList[i]);
if (daysToNextSession < dayToSessionTemp)
{
selectedSchedule = scheduleClassroomList[i];
dayToSessionTemp = daysToNextSession;
}
}
int nextSessionTimestamp = (int)selectedSchedule.nextDate;
DateTime nextSessionDateTime = DateTimeOffset.FromUnixTimeSeconds(nextSessionTimestamp).LocalDateTime;
scheduleTime = nextSessionDateTime.ToString("g", GlobalVariable.culture);
}
else
{
scheduleTime = "Aucun horaire défini";
}
int studentNumber = GetStudentNumber(classroomId);
string studentNumberString = studentNumber.ToString() + " étudiant(e)s";
ClassroomDisplay classroomDisplay = new ClassroomDisplay()
{
ID = classroomId,
ClassroomName = rdr.GetString(1),
StudentsNumber = studentNumberString,
NextSession = scheduleTime,
};
classroomCollection.Add(classroomDisplay);
}
}
