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)
{
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 BindCompetencyAreas()
{
BPCompetencyAreas bpCompAreas = new BPCompetencyAreas();
BECompetencies ds = new BECompetencies();
if (FilterDisciplineID == "-1")
ds = bpCompAreas.SelectAllWithROColumns();
else
ds = bpCompAreas.SelectByDisciplineLevelID(Convert.ToInt32(FilterDisciplineID));
ddlCompetencyAreas.DataSource = ds.tbl_CompetencyAreas.DefaultView;
ddlCompetencyAreas.DataTextField = "CompetencyAreaTitle";
ddlCompetencyAreas.DataValueField = "CompetencyAreaID";
ddlCompetencyAreas.DataBind();
ddlCompetencyAreas.Items.Insert(0, new ListItem("(All Competency Areas)", "-1"));
if (FilterCompAreaID != "-1")
if (ddlCompetencyAreas.Items.FindByValue(FilterCompAreaID) != null)
ddlCompetencyAreas.SelectedValue = FilterCompAreaID;
}
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);
}
