public List <JNPSearchResult> SearchJNPAdmin(long?jnpID = null, int?orgCodeID = null, int?userID = null)
{
List <JNPSearchResult> listCollection = new List <JNPSearchResult>();
DataTable dataItems = ExecuteDataTable("spr_SearchJNPAdmin", jnpID, orgCodeID, userID);
if (dataItems != null)
{
for (int i = 0; i < dataItems.Rows.Count; i++)
{
JNPSearchResult item = new JNPSearchResult();
item.JNPID = dataItems.Rows[i].Field <long>("JNPID");
item.JNPTitle = dataItems.Rows[i].Field <string>("JNPTitle");
item.SeriesID = dataItems.Rows[i].Field <int>("SeriesID");
item.SeriesName = dataItems.Rows[i].Field <string>("SeriesName");
item.RegionID = dataItems.Rows[i].Field <int>("RegionID");
item.RegionName = dataItems.Rows[i].Field <string>("RegionName");
item.OrganizationCodeID = dataItems.Rows[i].Field <int>("OrganizationCodeID");
item.OrganizationCode = dataItems.Rows[i].Field <string>("OrganizationCode");
item.OrganizationName = dataItems.Rows[i].Field <string>("OrganizationName");
item.JNPWorkflowStatusID = dataItems.Rows[i].Field <int>("JNPWorkflowStatusID");
item.JNPWorkflowStatus = dataItems.Rows[i].Field <string>("JNPWorkflowStatus");
listCollection.Add(item);
}
}
else
{
throw new Exception("You cannot create a JNPSearchResult collection from a null data table.");
}
return(listCollection);
}
public List <JNPSearchResult> GetNonPublishedJNPsByUserID(int userID)
{
List <JNPSearchResult> listCollection = new List <JNPSearchResult>();
DataTable dataItems = ExecuteDataTable("spr_GetNonPublishedJNPsByUserID", userID);
if (dataItems != null)
{
for (int i = 0; i < dataItems.Rows.Count; i++)
{
JNPSearchResult item = new JNPSearchResult();
jnpid = dataItems.Rows[i].Field <long>("JNPID");
item.JNPID = dataItems.Rows[i].Field <long>("JNPID");
item.SeriesID = dataItems.Rows[i].Field <int>("SeriesID");
item.SeriesName = dataItems.Rows[i].Field <string>("SeriesName");
item.RegionID = dataItems.Rows[i].Field <int>("RegionID");
item.RegionName = dataItems.Rows[i].Field <string>("RegionName");
item.OrganizationCodeID = dataItems.Rows[i].Field <int>("OrganizationCodeID");
item.OldOrganizationCode = dataItems.Rows[i].Field <int>("OldOrganizationCode");
item.OrganizationCode = dataItems.Rows[i].Field <string>("OrganizationCode");
item.OrganizationName = dataItems.Rows[i].Field <string>("OrganizationName");
item.JNPWorkflowStatusID = dataItems.Rows[i].Field <int>("JNPWorkflowStatusID");
item.JNPWorkflowStatus = dataItems.Rows[i].Field <string>("JNPWorkflowStatus");
listCollection.Add(item);
}
}
else
{
throw new Exception("You cannot create a JNPSearchResult collection from a null data table.");
}
return(listCollection);
}
private JNPSearchResult Mapper(DataRow row)
{
JNPSearchResult searchresult = new JNPSearchResult();
searchresult.JNPID = long.Parse(row["JNPID"].ToString());
searchresult.JNPTypeID = int.Parse(row["JNPTypeID"].ToString());
searchresult.JNPOptionTypeID = int.Parse(row["JNPOptionTypeID"].ToString());
searchresult.IsStandardJNP = bool.Parse(row["IsStandardJNP"].ToString());
searchresult.IsDEU = bool.Parse(row["IsDEU"].ToString());
searchresult.IsMP = ((row["IsMP"] != DBNull.Value) ? (bool)row["IsMP"] : false);
searchresult.IsExceptedService = ((row["IsExceptedService"] != DBNull.Value) ? (bool)row["IsExceptedService"] : false);
searchresult.PayPlanID = int.Parse(row["PayPlanID"].ToString());
searchresult.SeriesID = int.Parse(row["SeriesID"].ToString());
searchresult.IsInterdisciplinary = ((row["IsInterdisciplinary"] != DBNull.Value) ? Convert.ToBoolean(row["IsInterdisciplinary"]) : false);
searchresult.AdditionalSeriesID = ((row["AdditionalSeriesID"] != DBNull.Value) ? (int)row["AdditionalSeriesID"] : -1);
searchresult.LowestAdvertisedGrade = int.Parse(row["LowestAdvertisedGrade"].ToString());
searchresult.HighestAdvertisedGrade = int.Parse(row["HighestAdvertisedGrade"].ToString());
searchresult.RegionID = int.Parse(row["RegionID"].ToString());
searchresult.OrganizationCodeID = int.Parse(row["OrganizationCodeID"].ToString());
searchresult.OrganizationCode = ((row["OrganizationCode"] != DBNull.Value) ? row["OrganizationCode"].ToString() : string.Empty);
searchresult.OrganizationName = ((row["OrganizationName"] != DBNull.Value) ? row["OrganizationName"].ToString() : string.Empty);
searchresult.OldOrganizationCode = int.Parse(row["OldOrganizationCode"].ToString());
searchresult.JNPTitle = ((row["JNPTitle"] != DBNull.Value) ? row["JNPTitle"].ToString() : string.Empty);
searchresult.FullPDID = long.Parse(row["PositionDescriptionID"].ToString());
searchresult.AdditionalPDID = ((row["AdditionalPDID"] != DBNull.Value) ? (long)row["AdditionalPDID"] : -1);
searchresult.JobAnalysisID = ((row["JAID"] != DBNull.Value) ? (long)row["JAID"] : -1);
searchresult.CategoryRatingID = ((row["CRID"] != DBNull.Value) ? (long)row["CRID"] : -1);
searchresult.JobQuestionnaireID = ((row["JQID"] != DBNull.Value) ? (long)row["JQID"] : -1);
searchresult.CreatedByID = int.Parse(row["CreatedByID"].ToString());
searchresult.UpdateDate = ((row["UpdateDate"] != DBNull.Value) ? DateTime.Parse(row["UpdateDate"].ToString()) : new DateTime?());
searchresult.ResultedInSuccessfulHiring = ((row["ResultedInSuccessfulHiring"] != DBNull.Value) ? (bool)row["ResultedInSuccessfulHiring"] : false);
searchresult.VacancyID = ((row["VacancyID"] != DBNull.Value) ? row["VacancyID"].ToString() : string.Empty);
searchresult.JNPWorkflowStatusID = int.Parse(row["JNPWorkflowStatusID"].ToString());
searchresult.AuthorFullName = row["AuthorFullName"].ToString();
searchresult.JNPWorkflowStatus = row["JNPWorkflowStatus"].ToString();
searchresult.JNPWorkflowStatusDescription = ((row["JNPWorkflowStatusDescription"] != DBNull.Value) ? row["WorkflowStatusDescription"].ToString() : string.Empty);
searchresult.CheckedByID = ((row["CheckedByID"] != DBNull.Value) ? (int)row["CheckedByID"] : -1);
searchresult.CheckedActionTypeID = ((row["CheckedActionTypeID"] != DBNull.Value) ? (int)row["CheckedActionTypeID"] : -1);
searchresult.CheckedByFullName = ((row["CheckedByFullName"] != DBNull.Value) ? row["CheckedByFullName"].ToString() : string.Empty);
searchresult.CheckedDate = ((row["CheckedDate"] != DBNull.Value) ? DateTime.Parse(row["CheckedDate"].ToString()) : new DateTime?());
searchresult.CanView = ((row["CanViewJNP"] != DBNull.Value) ? (bool)row["CanViewJNP"] : false);
searchresult.CanEdit = ((row["CanEditJNP"] != DBNull.Value) ? (bool)row["CanEditJNP"] : false);
searchresult.CanContinueEdit = ((row["CanContinueEditJNP"] != DBNull.Value) ? (bool)row["CanContinueEditJNP"] : false);
searchresult.CanFinishEdit = ((row["CanFinishEditJNP"] != DBNull.Value) ? (bool)row["CanFinishEditJNP"] : false);
searchresult.CanCopyStartNew = ((row["CanCopyStartNewJNP"] != DBNull.Value) ? (bool)row["CanCopyStartNewJNP"] : false);
return(searchresult);
}
