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