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