public AddHomeworkClassroom(int?classroomId = null) { InitializeComponent(); List <ClassroomInfo> classroomList = Database.Get.Classroom.All("new"); foreach (ClassroomInfo classroom in classroomList) { ClassroomEntry classroomEntry = new ClassroomEntry() { ID = classroom.ClassroomId, Name = classroom.Name }; classroomEntries.Add(classroomEntry); } _classroomComboBox.ItemsSource = classroomEntries; if (classroomId != null) { _classroomComboBox.SelectedIndex = (int)classroomId - 1; } else { _classroomComboBox.SelectedIndex = 0; } }
private void ConfirmButton_Click(object sender, RoutedEventArgs e) { error.Content = ""; ClassroomEntry selectedClassroom = (ClassroomEntry)_classroomComboBox.SelectedItem; RoomEntry selectedRoom = (RoomEntry)_roomNameComboBox.SelectedItem; int repetitivity = _regularityComboBox.SelectedIndex; WindowsXamlHost windowsHost = _timePicker; TimePicker timePickerHour = (TimePicker)windowsHost.Child; WindowsXamlHost windowsHost2 = _durationTimePicker; TimePicker durationTimePicker = (TimePicker)windowsHost2.Child; TimeSpan? durationTimeSelected = durationTimePicker.SelectedTime; if (durationTimeSelected == null) { error.Foreground = new SolidColorBrush(Colors.Red); error.Content = "Spécifier une durée"; return; } TimeSpan?hourTimeSelected = timePickerHour.SelectedTime; if (hourTimeSelected == null) { error.Foreground = new SolidColorBrush(Colors.Red); error.Content = "Spécifier une heure."; return; } DateTime?dateSelected = _firstDatePciker.SelectedDate; if (dateSelected == null) { error.Foreground = new SolidColorBrush(Colors.Red); error.Content = "Spécifier une date de première séance"; return; } DateTime dateSelectedNotNull = (DateTime)dateSelected; dateSelectedNotNull = dateSelectedNotNull.AddHours((double)hourTimeSelected?.Hours).AddMinutes((double)hourTimeSelected?.Minutes); int scheduleId = Database.Insert.Schedule.One(selectedClassroom.ID, selectedRoom.ID, repetitivity, dateSelectedNotNull, (TimeSpan)hourTimeSelected); ScheduleOption.ScheduleOptionDisplay scheduleDisplay = new ScheduleOption.ScheduleOptionDisplay() { ID = scheduleId, ClassroomId = selectedClassroom.ID, NextDate = dateSelectedNotNull.ToString("g", GlobalVariable.culture), Duration = durationTimeSelected?.ToString(@"hh\:mm"), Repetitivity = repetitivity == 0 ? "Une fois par semaine" : "Une semaine sur deux", Room = Database.Get.Room.NameFromID(selectedRoom.ID) }; //TODO: Make this work but not mendatory for now //ScheduleOption.scheduleDisplayCollection.Add(scheduleDisplay); error.Foreground = new SolidColorBrush(Colors.Green); error.Content = "Horaire ajouté avec succès"; }
private void AddAllStudentsToDbFromCSV(List <RowStudent> rowStudents) { foreach (RowStudent student in rowStudents) { student.Gender = student.Gender.ToLower(); student.Name = student.Name.ToLower(); student.Name = char.ToUpper(student.Name[0]) + student.Name.Substring(1); bool trueGender = student.Gender == "h"; string[] classrooms = student.Classrooms.Split(","); List <ClassroomEntry> classroomEntryList = new List <ClassroomEntry>(); foreach (string classroomName in classrooms) { int? classroomId = Database.Get.Classroom.IDFromName(classroomName); ClassroomEntry classroomEntry = new ClassroomEntry() { Name = classroomName, ID = classroomId }; classroomEntryList.Add(classroomEntry); } foreach (ClassroomEntry classroom in classroomEntryList) { if (classroom.ID == null) { classroom.ID = Database.Insert.Classroom.One(classroom.Name); } } int studentId = Database.Insert.Student.One((int)classroomEntryList[0].ID, student.Name, student.Surname, trueGender); if (classroomEntryList.Count > 1) { for (int i = 0; i < classroomEntryList.Count; i++) { if (i == 0) { continue; } Database.Insert.LinkStudentToClassroom.One(studentId, (int)classroomEntryList[i].ID); } } } error.Foreground = new SolidColorBrush(Colors.Green); error.Content = $"{rowStudents.Count} étudiant(e)s ajouté(e)s avec succès"; }
public AddSchedules() { InitializeComponent(); //Handle classrooms List <ClassroomInfo> allClassroomsList = Database.Get.Classroom.All("new"); foreach (ClassroomInfo classroom in allClassroomsList) { ClassroomEntry classroomEntry = new ClassroomEntry() { ID = classroom.ClassroomId, Name = classroom.Name }; classromsList.Add(classroomEntry); } _classroomComboBox.ItemsSource = classromsList; _classroomComboBox.SelectedIndex = 0; //Handle Rooms List <RoomInfo> allRoomsList = Database.Get.Room.All("new"); foreach (RoomInfo room in allRoomsList) { RoomEntry roomEntry = new RoomEntry() { ID = room.RoomId, Name = room.Name }; roomsList.Add(roomEntry); } _roomNameComboBox.ItemsSource = roomsList; _roomNameComboBox.SelectedIndex = 0; //Handle Repetitivity List <string> allRepetitivity = new List <string>() { "Une fois par semaine", "Une semaine sur deux" }; _regularityComboBox.ItemsSource = allRepetitivity; _regularityComboBox.SelectedIndex = 0; }