private void BindCompetencyAreaInfo()
{
BPCompetencyAreas bp = new BPCompetencyAreas();
BECompetencies ds = bp.SelectFRByIDWithROColumns(CompetencyAreaID);
if (ds.tbl_CompetencyAreas.Count > 0)
{
BECompetencies.tbl_CompetencyAreasRow row = ds.tbl_CompetencyAreas[0];
if (!row.CompetencyAreaActive || row.IsCompetencyAreaTitleFRNull())
Redirect();
else
{
if (!row.IsDisciplineLevelTitleFRNull())
{
lnkParentCrumb.NavigateUrl = "DisciplineLevel.aspx?DisciplineLevelID=" + row.DisciplineLevelID;
lnkParentCrumb.Text = row.DisciplineLevelTitleFR;
}
PageName = row.CompetencyAreaTitleFR + " :: " + PageName;
lblTitleCrumb.Text = row.CompetencyAreaTitleFR;
lblTitle.Text = row.CompetencyAreaTitleFR;
lblName.Text = row.CompetencyAreaTitleFR;
if (!row.IsCompetencyAreaDescriptionFRNull())
{
lblCompetencyAreaDescription.Text = row.CompetencyAreaDescriptionFR;
plcCompetencyAreaDescription.Visible = true;
}
}
}
else
Redirect();
}
private void BindListingsInfo()
{
BPCompetencyAreas bp = new BPCompetencyAreas();
BECompetencies ds = null;
ds = bp.SelectActiveFRByDisciplineLevelID(DisciplineLevelID);
ds.tbl_CompetencyAreas.DefaultView.Sort = ds.tbl_CompetencyAreas.CompetencyAreaOrderColumn.ColumnName;
rptCompetencyAreas.DataSource = ds.tbl_CompetencyAreas.DefaultView;
rptCompetencyAreas.DataBind();
plcCompetencyAreas.Visible = (rptCompetencyAreas.Items.Count > 0);
}
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;
}
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();
}
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);
}
private void LoadDataSet()
{
BPDisciplineLevels bpDisciplineLevels = new BPDisciplineLevels();
BPCompetencyAreas bpCompetencyAreas = new BPCompetencyAreas();
BPCompetencies bpCompetencies = new BPCompetencies();
dsCompetencies = bpDisciplineLevels.SelectAllActive();
dsCompetencies.Merge(bpCompetencyAreas.SelectAllActive());
dsCompetencies.Merge(bpCompetencies.SelectAllActive());
}
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;
}
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 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);
}
