protected DataView GetData()
{
BPCompetencyAreas bp = new BPCompetencyAreas();
if (FilterCatID == "-1")
DSCompetencies = bp.SelectAllWithROColumns();
else
DSCompetencies = bp.SelectByDisciplineLevelIDWithROColumns(Convert.ToInt32(ddlDisciplineLevels.SelectedValue));
BindMoveControl(DSCompetencies.tbl_CompetencyAreas.DefaultView);
DSCompetencies.tbl_CompetencyAreas.DefaultView.RowFilter = RowFilter("CompetencyAreaTitle", ((LinkButton)rptLetters.Items[0].FindControl("lnkLetter")).CommandName, "CompetencyAreaActive", lstActive.SelectedValue);
return DSCompetencies.tbl_CompetencyAreas.DefaultView;
}
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;
}
