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