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