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