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