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); }