private void BindDisciplineLevelInfo()
{
BPDisciplineLevels bp = new BPDisciplineLevels();
BECompetencies ds = bp.SelectByID(DisciplineLevelID);
if (ds.tbl_DisciplineLevels.Count > 0)
{
BECompetencies.tbl_DisciplineLevelsRow row = ds.tbl_DisciplineLevels[0];
if (!row.DisciplineLevelActive || row.IsDisciplineLevelTitleFRNull())
Redirect();
else
{
PageName = row.DisciplineLevelTitleFR + " :: " + PageName;
lblTitleCrumb.Text = row.DisciplineLevelTitleFR;
lblTitle.Text = row.DisciplineLevelTitleFR;
lblName.Text = row.DisciplineLevelTitleFR;
if (!row.IsDisciplineLevelDescriptionFRNull())
{
lblDisciplineLevelDescription.Text = row.DisciplineLevelDescriptionFR;
plcDisciplineLevelDescription.Visible = true;
}
}
}
else
Redirect();
}
private void BindDisciplineLevelInfo()
{
if (DisciplineLevelID != 0)
{
BPDisciplineLevels bp = new BPDisciplineLevels();
BECompetencies dsDisciplines = bp.SelectByID(DisciplineLevelID);
BECompetencies.tbl_DisciplineLevelsRow discipline = dsDisciplines.tbl_DisciplineLevels.FindByDisciplineLevelID(DisciplineLevelID);
if (discipline != null)
{
txtTitle.Text = discipline.DisciplineLevelTitle;
txtTitleFR.Text = discipline.IsDisciplineLevelTitleFRNull() ? "" : discipline.DisciplineLevelTitleFR;
txtDescription.Text = discipline.IsDisciplineLevelDescriptionNull() ? "" : discipline.DisciplineLevelDescription;
txtDescriptionFR.Text = discipline.IsDisciplineLevelDescriptionFRNull() ? "" : discipline.DisciplineLevelDescriptionFR;
chkDisciplineLevelActive.Checked = discipline.DisciplineLevelActive;
lblTitle.Text = "Edit Discipline Level - " + discipline.DisciplineLevelTitle;
}
}
else
{
btnDelete.Visible = false;
lblTitle.Text = "Add Discipline Level";
}
}
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);
BPDisciplineLevels bp = new BPDisciplineLevels();
BECompetencies ds = bp.SelectAll();
BECompetencies.tbl_DisciplineLevelsRow[] disciplinerows =
(BECompetencies.tbl_DisciplineLevelsRow[])ds.tbl_DisciplineLevels.Select("", "DisciplineLevelOrder");
BECompetencies.tbl_DisciplineLevelsRow movediscipline = ds.tbl_DisciplineLevels.FindByDisciplineLevelID(ItemToMove);
foreach (BECompetencies.tbl_DisciplineLevelsRow discipline in disciplinerows)
{
if (found1 && found2)
break;
if (discipline.DisciplineLevelID == movediscipline.DisciplineLevelID)
{
found1 = true;
if (discipline.DisciplineLevelID == Position)
found2 = true;
}
else if (discipline.DisciplineLevelID == Position)
{
found2 = true;
if (rblBeforeAfter.SelectedValue == "0")
{
movediscipline.DisciplineLevelOrder = discipline.DisciplineLevelOrder;
discipline.DisciplineLevelOrder++;
}
else
{
if (found1)
discipline.DisciplineLevelOrder--;
movediscipline.DisciplineLevelOrder = discipline.DisciplineLevelOrder + 1;
}
}
else if (found1 && !found2)
discipline.DisciplineLevelOrder--;
else if (found2 && !found1)
discipline.DisciplineLevelOrder++;
}
bp.Update(ds);
dgDisciplineLevels.DataSource = GetData();
dgDisciplineLevels.DataBind();
}
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);
}
private void BindDisciplineLevels()
{
BPDisciplineLevels bp = new BPDisciplineLevels();
BECompetencies dsDisciplineLevels = bp.SelectAllActive();
dsDisciplineLevels.tbl_DisciplineLevels.DefaultView.Sort = "DisciplineLevelOrder";
ddlDisciplineLevels.DataSource = dsDisciplineLevels.tbl_DisciplineLevels;
ddlDisciplineLevels.DataTextField = "DisciplineLevelTitle";
ddlDisciplineLevels.DataValueField = "DisciplineLevelID";
ddlDisciplineLevels.DataBind();
ddlDisciplineLevels.Items.Insert(0, new ListItem("(Select Discipline Level)", "-1"));
}
private void BindListingsInfo()
{
BPDisciplineLevels bp = new BPDisciplineLevels();
BECompetencies ds = null;
ds = bp.SelectAllActiveFR();
ds.tbl_DisciplineLevels.DefaultView.Sort = ds.tbl_DisciplineLevels.DisciplineLevelOrderColumn.ColumnName;
rptDisciplineLevels.DataSource = ds.tbl_DisciplineLevels.DefaultView;
rptDisciplineLevels.DataBind();
}
protected void BindDisciplineLevels()
{
BPDisciplineLevels bp = new BPDisciplineLevels();
BECompetencies ds = bp.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 (FilterCatID != "-1")
if (ddlDisciplineLevels.Items.FindByValue(FilterCatID) != null)
ddlDisciplineLevels.SelectedValue = FilterCatID;
}
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());
}
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();
}
