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