//Event to Add/Edit Lists protected void AddEditButton_Click(object sender, EventArgs e) { try { UserMultiView.ActiveViewIndex = 1; TodoListBusinessObject obj_TodoListBO = new TodoListBusinessObject(); obj_TodoListBO.EmailID = (string)Session["EmailID"]; TodoListBusinessLogicFactory obj_UserTodoListBLF = new TodoListBusinessLogicFactory(); DataSet coll = obj_UserTodoListBLF.CreateTodoListBLF().GetUserListsBL(obj_TodoListBO); if (coll != null) { EditGridView.DataSource = coll.Tables["TodoList_UserLists"]; EditGridView.DataBind(); } else { DataTable dt = new DataTable(); EditGridView.DataSource = dt; EditGridView.DataBind(); } EditTable.Visible = false; AddTable.Visible = false; } catch { ErrorLabel.Text = "Unable to Load button"; } }
/// <summary> /// DBからデータを取得しなおしてデータをバインドします。 /// </summary> private void UpdateEditGridViewBindData() { logger.Debug(LOG_START); EditPanel.Visible = true; //ボタンの活性とCSSの設定 RunButton.Enabled = false; RunButton.CssClass = disableButtonCSS; EditButton.CssClass = selectedButtonCSS; // データバインド EditGridView.DataSource = GetEditList(); EditGridView.DataBind(); for (int rowIndex = 0; rowIndex < EditGridView.Rows.Count; rowIndex++) { GridViewRow row = EditGridView.Rows[rowIndex]; //勤務予定未認証の場合のCSS適用 if (!((List <KinmuGridViewEditRow>)EditGridView.DataSource)[rowIndex].IsAccepted) { row.CssClass = "kinmuDataRow mishoninRow odd"; } //日付のCSS適用 SetGridViewRowCommonCss(ref row); } }
//Event to submit Edited List protected void EditSubmitButton_Click(object sender, EventArgs e) { if (EditTitleTextBox.Text != null && EditDescriptionTextBox.Text != null) { TodoListBusinessObject obj_TodolistBO = new TodoListBusinessObject(); obj_TodolistBO.TitleNew = EditTitleTextBox.Text; obj_TodolistBO.EmailID = (string)Session["EmailID"]; obj_TodolistBO.Description = EditDescriptionTextBox.Text; foreach (GridViewRow gvslkrow in EditGridView.Rows) { CheckBox chk = (CheckBox)gvslkrow.FindControl("SelectCheckBox"); if (chk != null && chk.Checked) { obj_TodolistBO.TitleOld = gvslkrow.Cells[1].Text; } } obj_TodolistBO.CreatedDate = (System.DateTime.Now.Date.ToShortDateString()); TodoListBusinessLogicFactory obj_UserDetailsBLF = new TodoListBusinessLogicFactory(); ErrorSelectionLabel.Text = obj_UserDetailsBLF.CreateTodoListBLF().UpdateUserListBL(obj_TodolistBO); TodoListBusinessObject obj_TodoListBO = new TodoListBusinessObject(); obj_TodoListBO.EmailID = (string)Session["EmailID"]; TodoListBusinessLogicFactory obj_UserTodoListBLF = new TodoListBusinessLogicFactory(); DataSet coll = obj_UserTodoListBLF.CreateTodoListBLF().GetUserListsBL(obj_TodoListBO); if (coll != null) { EditGridView.DataSource = coll.Tables["TodoList_UserLists"]; EditGridView.DataBind(); EditTitleTextBox.Text = ""; AddTitleTextBox.Text = ""; } else { DataTable dt = new DataTable(); EditGridView.DataSource = dt; EditGridView.DataBind(); } } else { if (EditTitleTextBox.Text == null || EditTitleTextBox.Text == "") { TitleErrorLabel.Text = "Please Enter Title"; } else if (EditDescriptionTextBox.Text == null || EditDescriptionTextBox.Text == "") { DescriptionErrorLabel.Text = "Please Enter Description"; } } }
//Event to send selected list to completed List protected void ArchiveButton_Click(object sender, EventArgs e) { TodoListBusinessObject obj_SendArchiveListBO = new TodoListBusinessObject(); obj_SendArchiveListBO.EmailID = (String)Session["EmailID"]; obj_SendArchiveListBO.IsArchive = false; foreach (GridViewRow gvslkrow in EditGridView.Rows) { CheckBox chk = (CheckBox)gvslkrow.FindControl("SelectCheckBox"); if (chk != null && chk.Checked) { obj_SendArchiveListBO.Title = gvslkrow.Cells[1].Text; obj_SendArchiveListBO.Description = gvslkrow.Cells[2].Text; ErrorSelectionLabel.Visible = false; } else { ErrorSelectionLabel.Text = "Please Select a List"; } } if (ErrorSelectionLabel.Text == null || ErrorSelectionLabel.Text == "") { ErrorSelectionLabel.Visible = false; } TodoListBusinessLogicFactory obj_SendArchiveBLF = new TodoListBusinessLogicFactory(); obj_SendArchiveBLF.CreateTodoListBLF().SendToArchiveUserListBL(obj_SendArchiveListBO); TodoListBusinessObject obj_TodoListBO = new TodoListBusinessObject(); obj_TodoListBO.EmailID = (string)Session["EmailID"]; TodoListBusinessLogicFactory obj_UserTodoListBLF = new TodoListBusinessLogicFactory(); DataSet coll = obj_UserTodoListBLF.CreateTodoListBLF().GetUserListsBL(obj_TodoListBO); if (coll != null) { EditGridView.DataSource = coll.Tables["TodoList_UserLists"]; EditGridView.DataBind(); } else { DataTable dt = new DataTable(); EditGridView.DataSource = dt; EditGridView.DataBind(); } }
/// <summary> /// Importeer data uit de DB in MainGridView. /// </summary> private void ImportData() { // Regenereer MainGridView MainGridView.DataSource = null; MainGridView.DataBind(); GenerateMainGridView(); // Haal DB data op if ((bool)Session["Database_FirstTime"] || (bool)Session["User_Changed"] || (bool)Session["Database_Changed"]) { RetrieveData(); Session["User_Changed"] = false; Session["Database_Changed"] = false; } // Vul dynamische lijsten GenerateDynamicLists(); // Plaats DB data in MainGridView List <Models.BU.Lecture> lectureList = (List <Models.BU.Lecture>)Session["Database_Lectures_" + UserDropdownList.SelectedValue]; if (lectureList != null) { foreach (Models.BU.Lecture lecture in (List <Models.BU.Lecture>)Session["Database_Lectures_" + UserDropdownList.SelectedValue]) { if (UserDropdownList.SelectedValue == lecture.teacher.UserID.ToString() && PeriodDropdownList.SelectedValue == lecture.period.ToString() && WeekDropdownList.SelectedValue == lecture.week.ToString()) { int[] cell = DetermineCell(lecture); string newEntry = ConstructScheduleString(lecture); MainGridView.Rows[cell[0]].Cells[cell[1]].Text = newEntry; } } } // Plaats DB data in EditGridView en LectureIdDropdownList EditGridView.DataSource = null; EditGridView.DataBind(); GenerateEditGridView(); FillEditElements(); // Plaats DB data in WishGridView WishGridView.DataSource = null; WishGridView.DataBind(); GenerateWishGridView(); // Bereken ingezette uren van docent. CalculateDeployedHours(); }
//Event to submit and add list protected void AddSubmitButton_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(AddTitleTextBox.Text) && (!string.IsNullOrEmpty(AddDescriptionTextBox.Text))) { TodoListBusinessObject obj_InsertListBO = new TodoListBusinessObject(); obj_InsertListBO.EmailID = (string)Session["EmailID"]; obj_InsertListBO.CreatedDate = (DateTime.Today.Date.ToShortDateString()); obj_InsertListBO.Title = AddTitleTextBox.Text; obj_InsertListBO.Description = AddDescriptionTextBox.Text; obj_InsertListBO.IsActive = true; obj_InsertListBO.IsArchive = false; TodoListBusinessLogicFactory obj_InsertListBLF = new TodoListBusinessLogicFactory(); DataSet coll = obj_InsertListBLF.CreateTodoListBLF().InsertUserListsBL(obj_InsertListBO); TodoListBusinessObject obj_TodoListBO = new TodoListBusinessObject(); obj_TodoListBO.EmailID = (string)Session["EmailID"]; TodoListBusinessLogicFactory obj_UserTodoListBLF = new TodoListBusinessLogicFactory(); obj_UserTodoListBLF.CreateTodoListBLF().GetUserArchiveBL(obj_TodoListBO); if (coll != null) { EditGridView.DataSource = coll.Tables["TodoList_UserLists"]; EditGridView.DataBind(); EditTitleTextBox.Text = ""; AddTitleTextBox.Text = ""; } else { DataTable dt = new DataTable(); EditGridView.DataSource = dt; EditGridView.DataBind(); } } else { if (AddTitleTextBox.Text == null) { TitleErrorLabel.Text = "Please Enter Title"; } else { DescriptionErrorLabel.Text = "Please Enter Description"; } } }
/// <summary> /// Genereer Columns en Rows voor EditGridView. /// </summary> private void GenerateEditGridView() { // DataTable voor tijdelijke opslag Columns en Rows DataTable dataTable = new DataTable(); // Maak Columns als deze er niet zijn if (EditGridView.Columns.Count == 0) { dataTable.Columns.Add("LesId", typeof(int)); dataTable.Columns.Add("DocentId", typeof(int)); dataTable.Columns.Add("Module", typeof(string)); dataTable.Columns.Add("Lokaal", typeof(string)); dataTable.Columns.Add("Groep", typeof(string)); dataTable.Columns.Add("Blok", typeof(int)); dataTable.Columns.Add("Week", typeof(int)); dataTable.Columns.Add("Dag", typeof(int)); dataTable.Columns.Add("Start [H]", typeof(int)); dataTable.Columns.Add("Start [M]", typeof(int)); dataTable.Columns.Add("Eind [H]", typeof(int)); dataTable.Columns.Add("Eind [M]", typeof(int)); } // Maak Rows als deze er niet zijn if (EditGridView.Rows.Count == 0) { LectureIdDropdownList.Items.Clear(); int lectureId = 1; //FEEDBACK RB-> Hier ga je direct van GUI naar BU, terwijl jullie in 5 lagen werken. //Hiermee sla je dus een laag over! //Daarnaast bevat de GUI op deze manier erg veel logica, wat niet gewenst is. List <Models.BU.Lecture> lectureList = (List <Models.BU.Lecture>)Session["Database_Lectures_" + UserDropdownList.SelectedValue]; if (lectureList != null || lectureList.Count == 0) { LectureLabel.Text = "Lectures gevonden voor docent " + UserDropdownList.SelectedValue; foreach (Models.BU.Lecture lecture in (List <Models.BU.Lecture>)Session["Database_Lectures_" + UserDropdownList.SelectedValue]) { if (UserDropdownList.SelectedValue == lecture.teacher.UserID.ToString() && PeriodDropdownList.SelectedValue == lecture.period.ToString() && WeekDropdownList.SelectedValue == lecture.week.ToString()) { LectureIdDropdownList.Items.Add(lectureId.ToString()); DataRow dataRow = dataTable.NewRow(); dataRow["LesId"] = lectureId; dataRow["DocentId"] = lecture.teacher.UserID; dataRow["Module"] = lecture.module.moduleCode; dataRow["Lokaal"] = lecture.classroom; dataRow["Groep"] = lecture.studentGroup; dataRow["Blok"] = lecture.period; dataRow["Week"] = lecture.week; dataRow["Dag"] = lecture.day; dataRow["Start [H]"] = lecture.startHour; dataRow["Start [M]"] = lecture.startMinute; dataRow["Eind [H]"] = lecture.endHour; dataRow["Eind [M]"] = lecture.endMinute; dataTable.Rows.Add(dataRow); lectureId++; } } } } // Voeg Columns en Rows toe aan de MainGridView EditGridView.DataSource = dataTable; EditGridView.DataBind(); // Reset positie van LectureDropdownList LectureIdDropdownList.SelectedIndex = -1; }
//Event to Delete Selected TodoList protected void DeleteButton_Click(object sender, EventArgs e) { try { int count = 0; foreach (GridViewRow gridvrow in EditGridView.Rows) { CheckBox editdetailscheck = (CheckBox)gridvrow.FindControl("SelectCheckBox"); if (editdetailscheck != null && editdetailscheck.Checked) { count++; TodoListBusinessObject obj_DeleteListBO = new TodoListBusinessObject(); obj_DeleteListBO.EmailID = (String)Session["EmailID"]; obj_DeleteListBO.IsArchive = true; foreach (GridViewRow gvslkrow in EditGridView.Rows) { CheckBox chk = (CheckBox)gvslkrow.FindControl("SelectCheckBox"); if (chk != null && chk.Checked) { obj_DeleteListBO.Title = gvslkrow.Cells[1].Text; obj_DeleteListBO.Description = gvslkrow.Cells[2].Text; foreach (GridViewRow grid in EditGridView.Rows) { CheckBox uncheck = (CheckBox)grid.FindControl("SelectCheckBox"); uncheck.Enabled = false; } } } TodoListBusinessLogicFactory objDeleteBLLFactRow = new TodoListBusinessLogicFactory(); objDeleteBLLFactRow.CreateTodoListBLF().DeleteUserListBL(obj_DeleteListBO); TodoListBusinessObject obj_TodoListBO = new TodoListBusinessObject(); obj_TodoListBO.EmailID = (string)Session["EmailID"]; TodoListBusinessLogicFactory obj_UserTodoListBLF = new TodoListBusinessLogicFactory(); DataSet coll = obj_UserTodoListBLF.CreateTodoListBLF().GetUserListsBL(obj_TodoListBO); ErrorSelectionLabel.Visible = false; if (coll != null) { EditGridView.DataSource = coll.Tables["TodoList_UserLists"]; EditGridView.DataBind(); } else { DataTable dt = new DataTable(); EditGridView.DataSource = dt; EditGridView.DataBind(); } } else { if (count == 0) { ErrorSelectionLabel.Visible = true; ErrorSelectionLabel.Text = "Please select a row and then click Delete"; } } } } catch { ErrorSelectionLabel.Visible = true; ErrorSelectionLabel.Text = "Unable to load button"; } }