public BECompetencies SelectAllActiveFR() { BECompetencies ds = new BECompetencies(); DADisciplineLevels da = new DADisciplineLevels(); da.SelectAllActiveFR(ds.tbl_DisciplineLevels); return ds; }
public BECompetencies SelectActiveWithROColumns() { BECompetencies ds = new BECompetencies(); DACompetencyAreas da = new DACompetencyAreas(); da.SelectActiveWithROColumns(ds.tbl_CompetencyAreas); return ds; }
public BECompetencies SelectAllInactive() { BECompetencies ds = new BECompetencies(); DACompetencyAreas da = new DACompetencyAreas(); da.SelectAllInactive(ds.tbl_CompetencyAreas); return ds; }
public BECompetencies SelectAll() { BECompetencies ds = new BECompetencies(); DACompetencies da = new DACompetencies(); da.SelectAll(ds.tbl_Competencies); return ds; }
public BECompetencies SelectActiveFRByCompetencyAreaID(int competencyAreaID) { BECompetencies ds = new BECompetencies(); DACompetencies da = new DACompetencies(); da.SelectActiveFRByCompetencyAreaID(competencyAreaID, ds.tbl_Competencies); return ds; }
public BECompetencies SelectActiveFRByDisciplineLevelID(int disciplineLevelID) { BECompetencies ds = new BECompetencies(); DACompetencyAreas da = new DACompetencyAreas(); da.SelectActiveFRByDisciplineLevelID(disciplineLevelID, ds.tbl_CompetencyAreas); return ds; }
public BECompetencies SelectByIDWithRODisciplineLevelID(int competencyID) { BECompetencies ds = new BECompetencies(); DACompetencies da = new DACompetencies(); da.SelectByIDWithRODisciplineLevelID(competencyID, ds.tbl_Competencies); return ds; }
public BECompetencies SelectByID(int competencyAreaID) { BECompetencies ds = new BECompetencies(); DACompetencyAreas da = new DACompetencyAreas(); da.SelectByID(competencyAreaID.ToString(), ds.tbl_CompetencyAreas); return ds; }
public BECompetencies SelectByID(int disciplineLevelID) { BECompetencies ds = new BECompetencies(); DADisciplineLevels da = new DADisciplineLevels(); da.SelectByID(disciplineLevelID.ToString(), ds.tbl_DisciplineLevels); return ds; }
protected DataView GetData() { BPDisciplineLevels bp = new BPDisciplineLevels(); DSCompetencies = bp.SelectAll(); DSCompetencies.tbl_DisciplineLevels.DefaultView.Sort = "DisciplineLevelOrder"; BindMoveControl(DSCompetencies.tbl_DisciplineLevels.DefaultView); DSCompetencies.tbl_DisciplineLevels.DefaultView.RowFilter = RowFilter("DisciplineLevelTitle", ((LinkButton)rptLetters.Items[0].FindControl("lnkLetter")).CommandName, "DisciplineLevelActive", lstActive.SelectedValue); return DSCompetencies.tbl_DisciplineLevels.DefaultView; }
private void SaveDisciplineLevelInfo() { bool isNew = false; BPDisciplineLevels bp = new BPDisciplineLevels(); BECompetencies dsDisciplines = new BECompetencies(); BECompetencies.tbl_DisciplineLevelsRow discipline = null; if (DisciplineLevelID > 0) { dsDisciplines = bp.SelectByID(DisciplineLevelID); discipline = dsDisciplines.tbl_DisciplineLevels.FindByDisciplineLevelID(DisciplineLevelID); if (discipline.DisciplineLevelActive && (!chkDisciplineLevelActive.Checked)) UpdateAssignedItems(); } if (discipline == null) { discipline = dsDisciplines.tbl_DisciplineLevels.Newtbl_DisciplineLevelsRow(); isNew = true; } discipline.DisciplineLevelTitle = txtTitle.Text.Trim(); if (txtTitleFR.Text.Trim() != "") discipline.DisciplineLevelTitleFR = txtTitleFR.Text.Trim(); else discipline.SetDisciplineLevelTitleFRNull(); if (txtDescription.Text.Trim() != "") discipline.DisciplineLevelDescription = txtDescription.Text.Trim(); else discipline.SetDisciplineLevelDescriptionNull(); if (txtDescriptionFR.Text.Trim() != "") discipline.DisciplineLevelDescriptionFR = txtDescriptionFR.Text.Trim(); else discipline.SetDisciplineLevelDescriptionFRNull(); discipline.DisciplineLevelActive = chkDisciplineLevelActive.Checked; discipline.DateModified = DateTime.Now; discipline.ModifiedByAdminID = PageUserID; if (isNew) { discipline.DisciplineLevelOrder = bp.GetDisciplineLevelMaxOrder(); discipline.DateCreated = DateTime.Now; dsDisciplines.tbl_DisciplineLevels.Addtbl_DisciplineLevelsRow(discipline); } bp.Update(dsDisciplines); }
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 BindDisciplineLevels() { BPDisciplineLevels bpDisciplineLevels = new BPDisciplineLevels(); BECompetencies ds = new BECompetencies(); ds = bpDisciplineLevels.SelectAll(); ds.tbl_DisciplineLevels.DefaultView.Sort = "DisciplineLevelOrder"; ddlDisciplineLevels.DataSource = ds.tbl_DisciplineLevels.DefaultView; ddlDisciplineLevels.DataTextField = "DisciplineLevelTitle"; ddlDisciplineLevels.DataValueField = "DisciplineLevelID"; ddlDisciplineLevels.DataBind(); ddlDisciplineLevels.Items.Insert(0, new ListItem("(All Discipline Levels)", "-1")); if (FilterDisciplineID != "-1") if (ddlDisciplineLevels.Items.FindByValue(FilterDisciplineID) != null) ddlDisciplineLevels.SelectedValue = FilterDisciplineID; }
public BECompetencies SelectByIDWithROColumns(int competencyAreaID) { BECompetencies ds = new BECompetencies(); DACompetencyAreas da = new DACompetencyAreas(); da.SelectByIDWithROColumns(competencyAreaID, ds.tbl_CompetencyAreas); return ds; }
public BECompetencies SelectByDisciplineLevelIDWithROColumns(int disciplineLevelID) { BECompetencies ds = new BECompetencies(); DACompetencyAreas da = new DACompetencyAreas(); da.SelectByDisciplineLevelIDWithROColumns(disciplineLevelID, ds.tbl_CompetencyAreas); return ds; }
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 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 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); }
public void Update(BECompetencies ds) { DACompetencyAreas da = new DACompetencyAreas(); da.Update(ds.tbl_CompetencyAreas); }
public void Update(BECompetencies ds) { DADisciplineLevels da = new DADisciplineLevels(); da.Update(ds.tbl_DisciplineLevels); }