protected void btnDelete_Click(object sender, EventArgs e) { BPCompetencyAreas bpCompetencyAreas = new BPCompetencyAreas(); BECompetencies ds = bpCompetencyAreas.SelectByID(CompetencyAreaID); BECompetencies.tbl_CompetencyAreasRow competencyArea = ds.tbl_CompetencyAreas.FindByCompetencyAreaID(CompetencyAreaID); if (competencyArea != null) { int disciplineLevelID = competencyArea.DisciplineLevelID; BPCompetencies bpCompetencies = new BPCompetencies(); ds.Merge(bpCompetencies.SelectByCompetencyAreaID(competencyArea.CompetencyAreaID)); foreach (BECompetencies.tbl_CompetenciesRow competency in ds.tbl_Competencies) { competency.Delete(); } competencyArea.Delete(); bpCompetencies.Update(ds); bpCompetencyAreas.Update(ds); bpCompetencyAreas.ReOrderCompetencyAreas(disciplineLevelID); } BrowseRedirect(); }
private void BindCompetencyAreaInfo() { if (CompetencyAreaID != 0) { BPCompetencyAreas bp = new BPCompetencyAreas(); BECompetencies dsCompetencyAreas = bp.SelectByID(CompetencyAreaID); BECompetencies.tbl_CompetencyAreasRow competencyArea = dsCompetencyAreas.tbl_CompetencyAreas.FindByCompetencyAreaID(CompetencyAreaID); if (competencyArea != null) { txtTitle.Text = competencyArea.CompetencyAreaTitle; txtTitleFR.Text = competencyArea.IsCompetencyAreaTitleFRNull() ? "" : competencyArea.CompetencyAreaTitleFR; txtDescription.Text = (competencyArea.IsCompetencyAreaDescriptionNull()) ? "" : competencyArea.CompetencyAreaDescription; txtDescriptionFR.Text = (competencyArea.IsCompetencyAreaDescriptionFRNull()) ? "" : competencyArea.CompetencyAreaDescriptionFR; if (ddlDisciplineLevels.Items.FindByValue(competencyArea.DisciplineLevelID.ToString()) != null) ddlDisciplineLevels.SelectedValue = competencyArea.DisciplineLevelID.ToString(); chkCompetencyAreaActive.Checked = competencyArea.CompetencyAreaActive; lblTitle.Text = "Edit Competency Area - " + competencyArea.CompetencyAreaTitle; } } else { btnDelete.Visible = false; lblTitle.Text = "Add Competency Area"; if (ddlDisciplineLevels.Items.FindByValue(FilterCatID) != null) ddlDisciplineLevels.SelectedValue = FilterCatID; } }
private void SaveCompetencyAreaInfo() { bool isNew = false; bool disciplineLevelChanged = false; int originalDisciplineLevelID = -1; BPCompetencyAreas bp = new BPCompetencyAreas(); BECompetencies dsCompetencyAreas = new BECompetencies(); BECompetencies.tbl_CompetencyAreasRow competencyArea = null; if (CompetencyAreaID > 0) { dsCompetencyAreas = bp.SelectByID(CompetencyAreaID); competencyArea = dsCompetencyAreas.tbl_CompetencyAreas.FindByCompetencyAreaID(CompetencyAreaID); if (competencyArea.CompetencyAreaActive && (!chkCompetencyAreaActive.Checked)) UpdateAssignedItems(); } if (competencyArea == null) { competencyArea = dsCompetencyAreas.tbl_CompetencyAreas.Newtbl_CompetencyAreasRow(); isNew = true; } competencyArea.CompetencyAreaTitle = txtTitle.Text.Trim(); if (txtTitleFR.Text.Trim() != "") competencyArea.CompetencyAreaTitleFR = txtTitleFR.Text.Trim(); else competencyArea.SetCompetencyAreaTitleFRNull(); if (txtDescription.Text.Trim() != "") competencyArea.CompetencyAreaDescription = txtDescription.Text.Trim(); else competencyArea.SetCompetencyAreaDescriptionNull(); if (txtDescriptionFR.Text.Trim() != "") competencyArea.CompetencyAreaDescriptionFR = txtDescriptionFR.Text.Trim(); else competencyArea.SetCompetencyAreaDescriptionFRNull(); //if re-assigning to a different Discipline Level if (!isNew && competencyArea.DisciplineLevelID != Convert.ToInt32(ddlDisciplineLevels.SelectedValue)) { competencyArea.CompetencyAreaOrder = bp.GetCompetencyAreaMaxOrder(Convert.ToInt32(ddlDisciplineLevels.SelectedValue)); originalDisciplineLevelID = competencyArea.DisciplineLevelID; competencyArea.DisciplineLevelID = Convert.ToInt32(ddlDisciplineLevels.SelectedValue); disciplineLevelChanged = true; } competencyArea.CompetencyAreaActive = chkCompetencyAreaActive.Checked; competencyArea.DateModified = DateTime.Now; competencyArea.ModifiedByAdminID = PageUserID; if (isNew) { competencyArea.DisciplineLevelID = Convert.ToInt32(ddlDisciplineLevels.SelectedValue); competencyArea.CompetencyAreaOrder = bp.GetCompetencyAreaMaxOrder(Convert.ToInt32(ddlDisciplineLevels.SelectedValue)); competencyArea.DateCreated = DateTime.Now; dsCompetencyAreas.tbl_CompetencyAreas.Addtbl_CompetencyAreasRow(competencyArea); } bp.Update(dsCompetencyAreas); if (disciplineLevelChanged) bp.ReOrderCompetencyAreas(originalDisciplineLevelID); }