protected void btnMove_Click(object sender, EventArgs e)
{
bool found1 = false, found2 = false;
int Position = Convert.ToInt32(ddlPosition.SelectedValue);
int ItemToMove = Convert.ToInt32(ddlItemToMove.SelectedValue);
BPCompetencyAreas bp = new BPCompetencyAreas();
BECompetencies ds = bp.SelectByDisciplineLevelID(Convert.ToInt32(FilterCatID));
BECompetencies.tbl_CompetencyAreasRow[] competencyArearows =
(BECompetencies.tbl_CompetencyAreasRow[])ds.tbl_CompetencyAreas.Select("", "CompetencyAreaOrder");
BECompetencies.tbl_CompetencyAreasRow movecompetencyArea = ds.tbl_CompetencyAreas.FindByCompetencyAreaID(ItemToMove);
foreach (BECompetencies.tbl_CompetencyAreasRow competencyArea in competencyArearows)
{
if (found1 && found2)
break;
if (competencyArea.CompetencyAreaID == movecompetencyArea.CompetencyAreaID)
{
found1 = true;
if (competencyArea.CompetencyAreaID == Position)
found2 = true;
}
else if (competencyArea.CompetencyAreaID == Position)
{
found2 = true;
if (rblBeforeAfter.SelectedValue == "0")
{
movecompetencyArea.CompetencyAreaOrder = competencyArea.CompetencyAreaOrder;
competencyArea.CompetencyAreaOrder++;
}
else
{
if (found1)
competencyArea.CompetencyAreaOrder--;
movecompetencyArea.CompetencyAreaOrder = competencyArea.CompetencyAreaOrder + 1;
}
}
else if (found1 && !found2)
competencyArea.CompetencyAreaOrder--;
else if (found2 && !found1)
competencyArea.CompetencyAreaOrder++;
}
bp.Update(ds);
dgCompetencyAreas.DataSource = GetData();
dgCompetencyAreas.DataBind();
}
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();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
BPDisciplineLevels bpDisciplineLevels = new BPDisciplineLevels();
BECompetencies ds = bpDisciplineLevels.SelectByID(DisciplineLevelID);
BECompetencies.tbl_DisciplineLevelsRow discipline = ds.tbl_DisciplineLevels.FindByDisciplineLevelID(DisciplineLevelID);
if (discipline != null)
{
BPCompetencyAreas bpCompAreas = new BPCompetencyAreas();
BPCompetencies bpCompetencies = new BPCompetencies();
ds.Merge(bpCompAreas.SelectByDisciplineLevelID(discipline.DisciplineLevelID));
ds.Merge(bpCompetencies.SelectByDisciplineLevelID(discipline.DisciplineLevelID));
foreach (BECompetencies.tbl_CompetenciesRow competency in ds.tbl_Competencies)
{
competency.Delete();
}
foreach (BECompetencies.tbl_CompetencyAreasRow compArea in ds.tbl_CompetencyAreas)
{
compArea.Delete();
}
discipline.Delete();
bpCompetencies.Update(ds);
bpCompAreas.Update(ds);
bpDisciplineLevels.Update(ds);
bpDisciplineLevels.ReOrderDisciplineLevels();
}
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);
}
private void UpdateAssignedItems()
{
//if discipline is being deactivated, deactivate all items assigned to the discipline
BPCompetencyAreas bpCompAreas = new BPCompetencyAreas();
BPCompetencies bpCompetencies = new BPCompetencies();
BECompetencies ds = bpCompAreas.SelectByDisciplineLevelID(DisciplineLevelID);
ds.Merge(bpCompetencies.SelectByDisciplineLevelID(DisciplineLevelID));
foreach (BECompetencies.tbl_CompetenciesRow competency in ds.tbl_Competencies)
{
competency.CompetencyActive = false;
}
foreach (BECompetencies.tbl_CompetencyAreasRow compArea in ds.tbl_CompetencyAreas)
{
compArea.CompetencyAreaActive = false;
}
bpCompetencies.Update(ds);
bpCompAreas.Update(ds);
}
