private void buildSinglePositionDescriptionList(RadComboBox dropdown, int seriesID, int gradeID, int organizationCode, string topOptionEmpty, string topOptionFull, bool isFullPD) { PositionDescriptionCollection pdList = PositionDescriptionSearcher.Search(seriesID, gradeID, organizationCode, PublishTypes.PublishedOnly); if (seriesID == -1 || gradeID == -1 || organizationCode == -1) { printTopOptionOnly(dropdown, topOptionEmpty); // clear JNP fields that are loaded from Full PD if (isFullPD) { clearJNPDataFromFullPD(); } } else { if (pdList.Count == 0) { printTopOptionOnly(dropdown, "[-- No Matching Position Descriptions were found --]"); // clear JNP fields that are loaded from Full PD if (isFullPD) { clearJNPDataFromFullPD(); } } else { ControlUtility.BindRadComboBoxControl(dropdown, pdList, null, "OPMJobTitle", "PositionDescriptionID", topOptionFull); } } }
public PositionDescriptionCollection GetNonPublishedPositionDescriptions() { PositionDescriptionCollection childDataCollection = null; if (base.ValidateKeyField(this._userID)) { try { DataTable dt = ExecuteDataTable("spr_GetNonPublishedPositionDescriptionsByUserID", this._userID); // fill collection list childDataCollection = PositionDescription.GetCollection(dt); } catch (Exception ex) { HandleException(ex); } } return(childDataCollection); }
public static PositionDescriptionCollection Search(int?seriesID = null, int?gradeID = null, int?organizationCodeID = null, PublishTypes selectedPublishType = PublishTypes.All) { DbCommand commandWrapper = GetDbCommand("spr_SearchPositionDescriptionsByCriteria"); PositionDescriptionCollection searchResults = new PositionDescriptionCollection(); try { const int defaultValue = -1; SetParameter <int>(commandWrapper, "@SeriesID", seriesID, defaultValue); SetParameter <int>(commandWrapper, "@GradeID", gradeID, defaultValue); SetParameter <int>(commandWrapper, "@OrganizationCodeID", organizationCodeID, defaultValue); SetParameter <int>(commandWrapper, "@IsPublished", (short)selectedPublishType, (short)PublishTypes.All); searchResults = new PositionDescriptionCollection(ExecuteDataTable(commandWrapper)); } catch (Exception ex) { HandleException(ex); } return(searchResults); }