/// <summary>
/// Vul UserDropdownList, PeriodDropdownList en WeekDropdownList.
/// </summary>
private void GenerateStaticLists()
{
Models.CC.Scheduler_GetData get = new Models.CC.Scheduler_GetData();
// Vul UserDropdownList
Session["Database_Teachers"] = get.GetTeacherList();
UserDropdownList.DataSource = Session["Database_Teachers"];
UserDropdownList.DataValueField = "userId";
UserDropdownList.DataTextField = "username";
UserDropdownList.DataBind();
// Vul PeriodDropdownList
for (int p = 1; p <= 4; p++)
{
PeriodDropdownList.Items.Add(p.ToString());
}
// Vul WeekDropdownList
for (int w = 1; w <= 10; w++)
{
WeekDropdownList.Items.Add(w.ToString());
}
// Stel default waarden in
Session["User_Current"] = UserDropdownList.Items[0];
Session["Period_Current"] = PeriodDropdownList.Items[0];
Session["Week_Current"] = WeekDropdownList.Items[0];
}
/// <summary>
/// Sla gewijzigde data op in de DB en refresh alle data.
/// </summary>
private void EditData(Models.BU.Lecture lecture)
{
Models.CC.Scheduler_GetData get = new Models.CC.Scheduler_GetData();
int existingLectureId = get.CheckIfLectureAlreadyExists((Models.BU.Lecture)Session["Database_SelectedLectureData"]);
if (existingLectureId != -1)
{
Models.CC.Scheduler_UpdateEntry update = new Models.CC.Scheduler_UpdateEntry();
update.UpdateEntry(lecture, existingLectureId);
}
// Refresh
Session["Database_Changed"] = true;
ImportData();
}
/// <summary>
/// Verwijder een Lecture uit de DB.
/// </summary>
private void DeleteLecture()
{
Models.CC.Scheduler_GetData get = new Models.CC.Scheduler_GetData();
bool confirmed = true; // maak default false!
int existingLectureId = get.CheckIfLectureAlreadyExists((Models.BU.Lecture)Session["Database_SelectedLectureData"]);
if (existingLectureId != -1)
{
// confirmation dialog
if (confirmed)
{
Models.CC.Scheduler_DeleteEntry delete = new Models.CC.Scheduler_DeleteEntry();
delete.DeleteEntry(existingLectureId);
}
}
// Refresh
Session["Database_Changed"] = true;
ImportData();
}
/// <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>
/// Sla nieuwe data op in de DB en refresh alle data.
/// </summary>
private void SaveData(Models.BU.Lecture lecture)
{
Models.CC.Scheduler_GetData get = new Models.CC.Scheduler_GetData();
int existingLectureId = get.CheckIfLectureAlreadyExists(lecture);
if (existingLectureId == -1)
{
Models.CC.Scheduler_CreateEntry create = new Models.CC.Scheduler_CreateEntry();
create.CreateEntry(lecture);
}
else
{
Models.CC.Scheduler_UpdateEntry update = new Models.CC.Scheduler_UpdateEntry();
update.UpdateEntry(lecture, existingLectureId);
}
// Refresh
Session["Database_Changed"] = true;
ImportData();
}
/// <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));
}
}
}
}
}
/// <summary>
/// Haal data uit de DB op en plaats deze in een Sessions.
/// </summary>
private void RetrieveData()
{
Models.CC.Scheduler_GetData get = new Models.CC.Scheduler_GetData();
// LECTURES
// Maak / get Session
if (Session["Database_Lectures_" + UserDropdownList.SelectedValue] == null || (bool)Session["Database_Changed"])
{
Session["Database_Lectures_" + UserDropdownList.SelectedValue] = new List <Models.BU.Lecture>();
}
List <Models.BU.Lecture> sessionLectureList = (List <Models.BU.Lecture>)Session["Database_Lectures_" + UserDropdownList.SelectedValue];
// Haal data op - voer alleen uit wanneer sessionList leeg is of als er wijzigingen zijn.
if (sessionLectureList.Count == 0 || (bool)Session["Database_Changed"])
{
List <Models.BU.Lecture> lectureList = get.GetLecturesOfTeacher(Convert.ToInt32(UserDropdownList.SelectedValue));
if (lectureList != null)
{
foreach (Models.BU.Lecture lecture in lectureList)
{
if (!sessionLectureList.Contains(lecture))
{
sessionLectureList.Add(lecture);
}
}
}
}
Session["Database_Lectures_" + UserDropdownList.SelectedValue] = sessionLectureList;
// WISHES
// Maak / get Session
if (Session["Database_Wishes_" + UserDropdownList.SelectedValue] == null)
{
Session["Database_Wishes_" + UserDropdownList.SelectedValue] = new List <Models.BU.Wish>();
}
List <Models.BU.Wish> sessionWishList = (List <Models.BU.Wish>)Session["Database_Wishes_" + UserDropdownList.SelectedValue];
// Haal data op - voer alleen uit wanneer sessionList leeg is of als er wijzigingen zijn.
if (sessionWishList.Count == 0 || (bool)Session["Database_Changed"])
{
List <Models.BU.Wish> wishList = get.GetTeacherWishes(Convert.ToInt32(UserDropdownList.SelectedValue));
if (wishList != null)
{
foreach (Models.BU.Wish wish in wishList)
{
if (!sessionWishList.Contains(wish))
{
sessionWishList.Add(wish);
}
}
}
}
Session["Database_Wishes_" + UserDropdownList.SelectedValue] = sessionWishList;
// Modules
// Maak / get Session
if (Session["Database_Modules_" + UserDropdownList.SelectedValue] == null || (bool)Session["Database_Changed"])
{
Session["Database_Modules_" + UserDropdownList.SelectedValue] = new List <Models.BU.Module>();
}
List <Models.BU.Module> sessionModuleList = (List <Models.BU.Module>)Session["Database_Modules_" + UserDropdownList.SelectedValue];
// Haal data op - voer alleen uit wanneer sessionList leeg is of als er wijzigingen zijn.
if (sessionModuleList.Count == 0 || (bool)Session["Database_Changed"])
{
List <Models.BU.Module> moduleList = get.GetModuleListOfTeacher(Convert.ToInt32(UserDropdownList.SelectedValue));
if (moduleList != null)
{
foreach (Models.BU.Module module in moduleList)
{
if (!sessionModuleList.Contains(module))
{
sessionModuleList.Add(module);
}
}
}
}
Session["Database_Modules_" + UserDropdownList.SelectedValue] = sessionModuleList;
}
