private void UpdateAssignedItems()
{
//if Competency Area is being deactivated, deactivate all items assigned to the Competency Area
BPCompetencies bpCompetencies = new BPCompetencies();
BECompetencies ds = bpCompetencies.SelectByCompetencyAreaID(CompetencyAreaID);
foreach (BECompetencies.tbl_CompetenciesRow competency in ds.tbl_Competencies)
{
competency.CompetencyActive = false;
}
bpCompetencies.Update(ds);
}
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 btnMove_Click(object sender, EventArgs e)
{
bool found1 = false, found2 = false;
int Position = Convert.ToInt32(ddlPosition.SelectedValue);
int ItemToMove = Convert.ToInt32(ddlItemToMove.SelectedValue);
BPCompetencies bp = new BPCompetencies();
BECompetencies ds = bp.SelectByCompetencyAreaID(Convert.ToInt32(FilterCompAreaID));
BECompetencies.tbl_CompetenciesRow[] competencyrows =
(BECompetencies.tbl_CompetenciesRow[])ds.tbl_Competencies.Select("", "CompetencyOrder");
BECompetencies.tbl_CompetenciesRow movecompetency = ds.tbl_Competencies.FindByCompetencyID(ItemToMove);
foreach (BECompetencies.tbl_CompetenciesRow competency in competencyrows)
{
if (found1 && found2)
break;
if (competency.CompetencyID == movecompetency.CompetencyID)
{
found1 = true;
if (competency.CompetencyID == Position)
found2 = true;
}
else if (competency.CompetencyID == Position)
{
found2 = true;
if (rblBeforeAfter.SelectedValue == "0")
{
movecompetency.CompetencyOrder = competency.CompetencyOrder;
competency.CompetencyOrder++;
}
else
{
if (found1)
competency.CompetencyOrder--;
movecompetency.CompetencyOrder = competency.CompetencyOrder + 1;
}
}
else if (found1 && !found2)
competency.CompetencyOrder--;
else if (found2 && !found1)
competency.CompetencyOrder++;
}
bp.Update(ds);
dgCompetencies.DataSource = GetData();
dgCompetencies.DataBind();
}