internal List <ProfilesRNSDLL.BO.ORCID.PersonAffiliation> GetAffiliations(int profileDataPersonID) { System.Data.Common.DbCommand cmd = GetCommand("[ORCID.].[AffiliationsForORCID.GetList]"); cmd.CommandType = System.Data.CommandType.StoredProcedure; AddParam(ref cmd, "@ProfileDataPersonID", profileDataPersonID); System.Data.DataTable dt = FillTable(cmd); List <ProfilesRNSDLL.BO.ORCID.PersonAffiliation> personAffiliations = new List <BO.ORCID.PersonAffiliation>(); foreach (System.Data.DataRow dr in dt.Rows) { ProfilesRNSDLL.BO.ORCID.PersonAffiliation personAffiliation = new ProfilesRNSDLL.BO.ORCID.PersonAffiliation(); if (dr.IsNull("PersonAffiliationID")) { personAffiliation.PersonAffiliationIDIsNull = true; } else { personAffiliation.PersonAffiliationID = int.Parse(dr["PersonAffiliationID"].ToString()); } if (dr.IsNull("ProfilesID")) { personAffiliation.ProfilesIDIsNull = true; } else { personAffiliation.ProfilesID = int.Parse(dr["ProfilesID"].ToString()); } personAffiliation.AffiliationTypeID = int.Parse(dr["AffiliationTypeID"].ToString()); if (dr.IsNull("PersonID")) { personAffiliation.PersonIDIsNull = true; } else { personAffiliation.PersonID = int.Parse(dr["PersonID"].ToString()); } if (dr.IsNull("PersonMessageID")) { personAffiliation.PersonMessageIDIsNull = true; } else { personAffiliation.PersonMessageID = int.Parse(dr["PersonMessageID"].ToString()); } if (dr.IsNull("DecisionID")) { personAffiliation.DecisionID = (int)BO.ORCID.REFDecision.REFDecisions.Public; } else { personAffiliation.DecisionID = int.Parse(dr["DecisionID"].ToString()); } if (!dr.IsNull("DepartmentName") && !dr["DepartmentName"].ToString().Equals(string.Empty)) { personAffiliation.DepartmentName = dr["DepartmentName"].ToString(); } else { personAffiliation.DepartmentNameIsNull = true; } if (!dr.IsNull("RoleTitle") && !dr["RoleTitle"].ToString().Equals(string.Empty)) { personAffiliation.RoleTitle = dr["RoleTitle"].ToString(); } else { personAffiliation.RoleTitleIsNull = true; } if (!dr.IsNull("StartDate")) { personAffiliation.StartDate = DateTime.Parse(dr["StartDate"].ToString()); } else { personAffiliation.StartDateIsNull = true; } if (!dr.IsNull("EndDate")) { personAffiliation.EndDate = DateTime.Parse(dr["EndDate"].ToString()); } else { personAffiliation.EndDateIsNull = true; } if (!dr.IsNull("OrganizationName") && !dr["OrganizationName"].ToString().Equals(string.Empty)) { personAffiliation.OrganizationName = dr["OrganizationName"].ToString(); } else { personAffiliation.OrganizationNameIsNull = true; } if (!dr.IsNull("City") && !dr["City"].ToString().Equals(string.Empty)) { personAffiliation.OrganizationCity = dr["City"].ToString(); } else { personAffiliation.OrganizationCityIsNull = true; } if (!dr.IsNull("State") && !dr["State"].ToString().Equals(string.Empty)) { personAffiliation.OrganizationRegion = dr["State"].ToString(); } else { personAffiliation.OrganizationRegionIsNull = true; } if (!dr.IsNull("Country") && !dr["Country"].ToString().Equals(string.Empty)) { personAffiliation.OrganizationCountry = dr["Country"].ToString(); } else { personAffiliation.OrganizationCountryIsNull = true; } if (!dr.IsNull("DisambiguationID") && !dr["DisambiguationID"].ToString().Equals(string.Empty)) { personAffiliation.DisambiguationID = dr["DisambiguationID"].ToString(); personAffiliation.DisambiguationSource = dr["DisambiguationSource"].ToString(); } else { personAffiliation.DisambiguationIDIsNull = true; personAffiliation.DisambiguationSourceIsNull = true; } personAffiliations.Add(personAffiliation); } return(personAffiliations); }
internal List<ProfilesRNSDLL.BO.ORCID.PersonAffiliation> GetAffiliations(int profileDataPersonID) { System.Data.Common.DbCommand cmd = GetCommand("[ORCID.].[AffiliationsForORCID.GetList]"); cmd.CommandType = System.Data.CommandType.StoredProcedure; AddParam(ref cmd, "@ProfileDataPersonID", profileDataPersonID); System.Data.DataTable dt = FillTable(cmd); List<ProfilesRNSDLL.BO.ORCID.PersonAffiliation> personAffiliations = new List<BO.ORCID.PersonAffiliation>(); foreach(System.Data.DataRow dr in dt.Rows) { ProfilesRNSDLL.BO.ORCID.PersonAffiliation personAffiliation = new ProfilesRNSDLL.BO.ORCID.PersonAffiliation(); if (dr.IsNull("PersonAffiliationID")) { personAffiliation.PersonAffiliationIDIsNull = true; } else { personAffiliation.PersonAffiliationID = int.Parse(dr["PersonAffiliationID"].ToString()); } if (dr.IsNull("ProfilesID")) { personAffiliation.ProfilesIDIsNull = true; } else { personAffiliation.ProfilesID = int.Parse(dr["ProfilesID"].ToString()); } personAffiliation.AffiliationTypeID = int.Parse(dr["AffiliationTypeID"].ToString()); if (dr.IsNull("PersonID")) { personAffiliation.PersonIDIsNull = true; } else { personAffiliation.PersonID = int.Parse(dr["PersonID"].ToString()); } if (dr.IsNull("PersonMessageID")) { personAffiliation.PersonMessageIDIsNull = true; } else { personAffiliation.PersonMessageID = int.Parse(dr["PersonMessageID"].ToString()); } if (dr.IsNull("DecisionID")) { personAffiliation.DecisionID = (int)BO.ORCID.REFDecision.REFDecisions.Public; } else { personAffiliation.DecisionID = int.Parse(dr["DecisionID"].ToString()); } if (!dr.IsNull("DepartmentName") && !dr["DepartmentName"].ToString().Equals(string.Empty)) { personAffiliation.DepartmentName = dr["DepartmentName"].ToString(); } else { personAffiliation.DepartmentNameIsNull = true; } if (!dr.IsNull("RoleTitle") && !dr["RoleTitle"].ToString().Equals(string.Empty)) { personAffiliation.RoleTitle = dr["RoleTitle"].ToString(); } else { personAffiliation.RoleTitleIsNull = true; } if (!dr.IsNull("StartDate")) { personAffiliation.StartDate = DateTime.Parse(dr["StartDate"].ToString()); } else { personAffiliation.StartDateIsNull = true; } if (!dr.IsNull("EndDate")) { personAffiliation.EndDate = DateTime.Parse(dr["EndDate"].ToString()); } else { personAffiliation.EndDateIsNull = true; } if (!dr.IsNull("OrganizationName") && !dr["OrganizationName"].ToString().Equals(string.Empty)) { personAffiliation.OrganizationName = dr["OrganizationName"].ToString(); } else { personAffiliation.OrganizationNameIsNull = true; } if (!dr.IsNull("City") && !dr["City"].ToString().Equals(string.Empty)) { personAffiliation.OrganizationCity = dr["City"].ToString(); } else { personAffiliation.OrganizationCityIsNull = true; } if (!dr.IsNull("State") && !dr["State"].ToString().Equals(string.Empty)) { personAffiliation.OrganizationRegion = dr["State"].ToString(); } else { personAffiliation.OrganizationRegionIsNull = true; } if (!dr.IsNull("Country") && !dr["Country"].ToString().Equals(string.Empty)) { personAffiliation.OrganizationCountry = dr["Country"].ToString(); } else { personAffiliation.OrganizationCountryIsNull = true; } if (!dr.IsNull("DisambiguationID") && !dr["DisambiguationID"].ToString().Equals(string.Empty)) { personAffiliation.DisambiguationID = dr["DisambiguationID"].ToString(); personAffiliation.DisambiguationSource = dr["DisambiguationSource"].ToString(); } else { personAffiliation.DisambiguationIDIsNull = true; personAffiliation.DisambiguationSourceIsNull = true; } personAffiliations.Add(personAffiliation); } return personAffiliations; }