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