/// <summary>
/// Update een Lecture in de DB.
/// </summary>
private void UpdateLecture()
{
Models.CC.Scheduler_GetData get = new Models.CC.Scheduler_GetData();
// Maak een object om te vullen.
Models.BU.Lecture updatedLecture = new Models.BU.Lecture(
get.GetSingleTeacher(Convert.ToInt32(UserDropdownList.SelectedValue)), // Teacher
get.GetSingleModule(Convert.ToInt32(ModuleDropdownList_E.SelectedValue)), // Module
ClassroomTextBox_E.Text, // Classroom
StudentGroupTextBox_E.Text, // StudentGroup
Convert.ToInt32(PeriodDropdownList.SelectedValue), // Period
Convert.ToInt32(WeekDropdownList.SelectedValue), // Week
DayInt(DayDropdownList_E.SelectedValue), // Day
Convert.ToInt32(TimeStartHourTextBox_E.Text), // StartHour
Convert.ToInt32(TimeStartMinuteTextBox_E.Text), // StartMinute
Convert.ToInt32(TimeEndHourTextBox_E.Text), // EndHour
Convert.ToInt32(TimeEndMinuteTextBox_E.Text)); // EndMinute
// Opslaan
EditData(updatedLecture);
}
/// <summary>
/// Vul de edit textboxes e.d. met data uit EditGridView.
/// </summary>
private void FillEditElements()
{
// Leeg eerst alles
ModuleDropdownList_E.SelectedValue = null;
ClassroomTextBox_E.Text = "";
StudentGroupTextBox_E.Text = "";
DayDropdownList_E.SelectedValue = null;
TimeStartHourTextBox_E.Text = "";
TimeStartMinuteTextBox_E.Text = "";
TimeEndHourTextBox_E.Text = "";
TimeEndMinuteTextBox_E.Text = "";
if (LectureIdDropdownList != null)
{
if (EditGridView != null)
{
foreach (GridViewRow row in EditGridView.Rows)
{
// Check of de LectureId overeenkomt
if (row.Cells[0].Text == LectureIdDropdownList.SelectedValue.ToString())
{
Models.CC.Scheduler_GetData get = new Models.CC.Scheduler_GetData();
int selectedModuleId = get.GetModuleByModuleCode(row.Cells[2].Text).moduleId;
ModuleDropdownList_E.SelectedValue = selectedModuleId.ToString();
ClassroomTextBox_E.Text = row.Cells[3].Text;
StudentGroupTextBox_E.Text = row.Cells[4].Text;
DayDropdownList_E.SelectedValue = DayString(Convert.ToInt32(row.Cells[7].Text));
TimeStartHourTextBox_E.Text = row.Cells[8].Text;
TimeStartMinuteTextBox_E.Text = row.Cells[9].Text;
TimeEndHourTextBox_E.Text = row.Cells[10].Text;
TimeEndMinuteTextBox_E.Text = row.Cells[11].Text;
// Sla de oude data op naar oldLecture
Session["Database_SelectedLectureData"] = new Models.BU.Lecture(get.GetSingleTeacher(Convert.ToInt32(UserDropdownList.SelectedValue)), get.GetSingleModule(Convert.ToInt32(ModuleDropdownList_E.SelectedValue)), ClassroomTextBox_E.Text, StudentGroupTextBox_E.Text, Convert.ToInt32(PeriodDropdownList.SelectedValue), Convert.ToInt32(WeekDropdownList.SelectedValue), DayInt(DayDropdownList_E.SelectedValue), Convert.ToInt32(TimeStartHourTextBox_E.Text), Convert.ToInt32(TimeStartMinuteTextBox_E.Text), Convert.ToInt32(TimeEndHourTextBox_E.Text), Convert.ToInt32(TimeEndMinuteTextBox_E.Text));
}
}
}
}
}