public static DataSet SearchPositionDescription(int userID,
int searchType,
long?positionDescriptionID, char?isStandardPD, int?PositionDescriptionTypeID, int?jobSeries,
int?workflowStatusID, int?proposedGrade,
string opmPositionTitle, string agencyPositionTitle,
int?organizationCodeID, string pdCreator,
int?pdNumberType, string fppsPDID
, string keyword, int?regionID
)
{
object[] parameters = new object[]
{
userID,
searchType,
positionDescriptionID,
isStandardPD,
PositionDescriptionTypeID,
jobSeries,
workflowStatusID,
proposedGrade,
opmPositionTitle,
agencyPositionTitle,
organizationCodeID,
pdCreator,
pdNumberType,
fppsPDID,
keyword,
regionID
};
DataSet dsPositionDescription = BusinessBase.ExecuteDataSet("[dbo].[spr_SearchPositionDescription]", parameters);
return(dsPositionDescription);
}
/// <summary>
/// NOTE: DataSet contains extra information comparing to JNPWorkflowNote object
/// </summary>
/// <param name="jnpID">JNP ID</param>
/// <returns>DataSet</returns>
public static DataSet GetByJNPID(long jnpID)
{
DataSet dataSet = new DataSet();
try
{
object[] parameters = new object[]
{
jnpID
};
dataSet = BusinessBase.ExecuteDataSet("spr_GetJNPWorkflowNoteByJNPID", parameters);
}
catch (Exception ex)
{
HandleException(ex);
}
return(dataSet);
}
/// <summary>
/// NOTE: DataSet contains extra information comparing to WorkflowNote object
/// </summary>
/// <param name="positionDescriptionID">Position Description ID</param>
/// <returns>DataSet</returns>
public static DataSet GetByPositionDescriptionID(long positionDescriptionID)
{
DataSet dataSet = new DataSet();
try
{
object[] parameters = new object[]
{
positionDescriptionID
};
dataSet = BusinessBase.ExecuteDataSet("dbo.spr_GetWorkflowNoteByPositionDescriptionID", parameters);
}
catch (Exception ex)
{
HandleException(ex);
}
return(dataSet);
}
public IList <JNPSearchResult> GetJNP(int userID, object[] parameterValues)
{
IList <JNPSearchResult> collection = new List <JNPSearchResult>();
try
{
DataSet ds = BusinessBase.ExecuteDataSet("spr_SearchJNP", parameterValues);
DataTable table = ds.Tables[0];
foreach (DataRow row in table.Rows)
{
collection.Add(Mapper(row));
}
}
catch (Exception ex)
{
//string message = ex.Message;
HandleException(ex);
}
return(collection);
}