public static ProjectDetailsDataType MapProjectDetails(NamedNullMappingDataReader readerEx) { ProjectDetailsDataType projectDetails = new ProjectDetailsDataType(); projectDetails.ProjectIdentifier = readerEx.GetString("PROJECT_IDENTIFIER"); projectDetails.ProjectName = readerEx.GetString("PROJECT_NAME"); projectDetails.ProjectDescription = readerEx.GetNullString("PROJECT_DESCRIPTION"); projectDetails.ScopeAreaTextSpecified = !readerEx.IsDBNull("SCOPE_AREA_TEXT"); if (projectDetails.ScopeAreaTextSpecified) { projectDetails.ScopeAreaText = EnumUtils.ParseEnum <ScopeAreaTextDataType>(readerEx.GetString("SCOPE_AREA_TEXT")); } projectDetails.ProjectStartDate = readerEx.GetDateTime("PROJECT_START_DATE"); projectDetails.ProjectEndDateSpecified = !readerEx.IsDBNull("PROJECT_END_DATE"); if (projectDetails.ProjectEndDateSpecified) { projectDetails.ProjectEndDate = readerEx.GetDateTime("PROJECT_END_DATE"); } projectDetails.ProjectInputPerson = readerEx.GetNullString("PROJECT_INPUT_PERSON"); projectDetails.ProjectDateEnteredSpecified = !readerEx.IsDBNull("PROJECT_DATE_ENTERED"); if (projectDetails.ProjectDateEnteredSpecified) { projectDetails.ProjectDateEntered = readerEx.GetDateTime("PROJECT_DATE_ENTERED"); } return(projectDetails); }
public static ProjectMonitoringLocationWeightingDataType MapProjectMonitoringLocationWeighting(NamedNullMappingDataReader readerEx) { ProjectMonitoringLocationWeightingDataType weighting = new ProjectMonitoringLocationWeightingDataType(); weighting.MonitoringLocationIdentifier = readerEx.GetString("MONLOCID"); weighting.LocationWeightingFactorMeasure = GetNullMeasureCompactData(readerEx, "LOCWEIGHTINGFACMEASURE", "LOCWEIGHTINGFACMEASUREUNIT"); weighting.StatisticalStratumText = readerEx.GetNullString("STATISTICALSTRATUM"); weighting.LocationCategoryName = readerEx.GetNullString("LOCATIONCATERY"); weighting.LocationStatusName = readerEx.GetNullString("LOCATIONSTATUS"); weighting.ReferenceLocationTypeCode = readerEx.GetNullString("REFLOCATIONTYPECODE"); weighting.ReferenceLocationStartDateSpecified = !readerEx.IsDBNull("REFLOCATIONSTARTDATE"); if (weighting.ReferenceLocationStartDateSpecified) { weighting.ReferenceLocationStartDate = readerEx.GetDateTime("REFLOCATIONSTARTDATE"); } weighting.ReferenceLocationEndDateSpecified = !readerEx.IsDBNull("REFLOCATIONENDDATE"); if (weighting.ReferenceLocationEndDateSpecified) { weighting.ReferenceLocationEndDate = readerEx.GetDateTime("REFLOCATIONENDDATE"); } if (!readerEx.IsDBNull("RESOURCETITLE") || !readerEx.IsDBNull("RESOURCEID")) { weighting.ReferenceLocationCitation = new BibliographicReferenceDataType(); weighting.ReferenceLocationCitation.ResourceTitleName = readerEx.GetString("RESOURCETITLE"); weighting.ReferenceLocationCitation.ResourceCreatorName = readerEx.GetNullString("RESOURCECREATOR"); weighting.ReferenceLocationCitation.ResourceSubjectText = readerEx.GetNullString("RESOURCESUBJECT"); weighting.ReferenceLocationCitation.ResourcePublisherName = readerEx.GetNullString("RESOURCEPUBLISHER"); weighting.ReferenceLocationCitation.ResourceDate = readerEx.GetDateTime("RESOURCEDATE"); weighting.ReferenceLocationCitation.ResourceIdentifier = readerEx.GetString("RESOURCEID"); } weighting.CommentText = readerEx.GetNullString("PROJMONLOCCOMMENT"); return(weighting); }
public static LabSamplePreparationDataType MapLabSamplePreparation(NamedNullMappingDataReader readerEx) { LabSamplePreparationDataType labSamplePreparation = new LabSamplePreparationDataType(); if (!readerEx.IsDBNull("METHODID") || !readerEx.IsDBNull("METHODIDCONTEXT") || !readerEx.IsDBNull("METHODNAME")) { labSamplePreparation.LabSamplePreparationMethod = new ReferenceMethodDataType(); labSamplePreparation.LabSamplePreparationMethod.MethodIdentifier = readerEx.GetString("METHODID"); labSamplePreparation.LabSamplePreparationMethod.MethodIdentifierContext = readerEx.GetString("METHODIDCONTEXT"); labSamplePreparation.LabSamplePreparationMethod.MethodName = readerEx.GetString("METHODNAME"); labSamplePreparation.LabSamplePreparationMethod.MethodQualifierTypeName = readerEx.GetNullString("METHODQUALIFIERTYPE"); labSamplePreparation.LabSamplePreparationMethod.MethodDescriptionText = readerEx.GetNullString("METHODDESC"); } labSamplePreparation.PreparationStartDateSpecified = !readerEx.IsDBNull("PREPSTARTDATE"); if (labSamplePreparation.PreparationStartDateSpecified) { labSamplePreparation.PreparationStartDate = readerEx.GetDateTime("PREPSTARTDATE"); } labSamplePreparation.PreparationStartTime = GetNullTimeData(readerEx, "PREPSTARTTIME", "PREPSTARTTIMEZONECODE"); labSamplePreparation.PreparationEndDateSpecified = !readerEx.IsDBNull("PREPENDDATE"); if (labSamplePreparation.PreparationEndDateSpecified) { labSamplePreparation.PreparationEndDate = readerEx.GetDateTime("PREPENDDATE"); } labSamplePreparation.PreparationEndTime = GetNullTimeData(readerEx, "PREPENDTIME", "PREPENDTIMEZONECODE"); labSamplePreparation.SubstanceDilutionFactorNumeric = readerEx.GetNullString("SUBSTANCEDILUTIONFACTOR"); return(labSamplePreparation); }
public static ActivityDataType MapActivity(NamedNullMappingDataReader readerEx) { ActivityDataType activity = new ActivityDataType(); activity.ActivityDescription = new ActivityDescriptionDataType(); activity.ActivityDescription.ActivityIdentifier = readerEx.GetString("ACTIVITYID"); activity.ActivityDescription.ActivityTypeCode = readerEx.GetString("ACTIVITYTYPECODE"); activity.ActivityDescription.ActivityMediaName = readerEx.GetString("ACTIVITYMEDIA"); activity.ActivityDescription.ActivityMediaSubdivisionName = readerEx.GetNullString("ACTIVITYMEDIASUBDIVISION"); activity.ActivityDescription.ActivityStartDate = readerEx.GetDateTime("ACTIVITYSTARTDATE"); activity.ActivityDescription.ActivityStartTime = GetNullTimeData(readerEx, "STARTTIME", "STARTTIMEZONE"); activity.ActivityDescription.ActivityEndDateSpecified = !readerEx.IsDBNull("ACTIVITYENDDATE"); if (activity.ActivityDescription.ActivityEndDateSpecified) { activity.ActivityDescription.ActivityEndDate = readerEx.GetDateTime("ACTIVITYENDDATE"); } activity.ActivityDescription.ActivityEndTime = GetNullTimeData(readerEx, "ENDTIME", "ENDTIMEZONE"); activity.ActivityDescription.ActivityRelativeDepthName = readerEx.GetNullString("RELATIVEDEPTH"); activity.ActivityDescription.ActivityDepthHeightMeasure = GetNullMeasureCompactData(readerEx, "DEPTHHEIGHTMEASURE", "DEPTHHEIGHTMEASUREUNIT"); activity.ActivityDescription.ActivityTopDepthHeightMeasure = GetNullMeasureCompactData(readerEx, "TOPDEPTHHEIGHTMEASURE", "TOPDEPTHHEIGHTMEASUREUNIT"); activity.ActivityDescription.ActivityBottomDepthHeightMeasure = GetNullMeasureCompactData(readerEx, "BOTTOMDEPTHHEIGHTMEASURE", "BOTTOMDEPTHHEIGHTMEASUREUNIT"); activity.ActivityDescription.ActivityDepthAltitudeReferencePointText = readerEx.GetNullString("DEPTHALTITUDEREFPOINT"); activity.ActivityDescription.MonitoringLocationIdentifier = readerEx.GetNullString("MONLOCID"); activity.ActivityDescription.ActivityCommentText = readerEx.GetNullString("ACTIVITYCOMMENT"); if (!readerEx.IsDBNull("LATITUDEMEASURE") || !readerEx.IsDBNull("LONGITUDEMEASURE") || !readerEx.IsDBNull("HORIZCOLLMETHOD") || !readerEx.IsDBNull("HORIZCOORDREFSYSDATUM")) { activity.ActivityLocation = new ActivityLocationDataType(); activity.ActivityLocation.LatitudeMeasure = ToDecimal(readerEx.GetString("LATITUDEMEASURE")); activity.ActivityLocation.LongitudeMeasure = ToDecimal(readerEx.GetString("LONGITUDEMEASURE")); activity.ActivityLocation.SourceMapScaleNumeric = readerEx.GetNullString("SOURCEMAPSCALE"); activity.ActivityLocation.HorizontalAccuracyMeasure = GetNullMeasureCompactData(readerEx, "HORIZACCURACYMEASURE", "HORIZACCURACYMEASUREUNIT"); activity.ActivityLocation.HorizontalCollectionMethodName = readerEx.GetString("HORIZCOLLMETHOD"); activity.ActivityLocation.HorizontalCoordinateReferenceSystemDatumName = readerEx.GetString("HORIZCOORDREFSYSDATUM"); } activity.BiologicalActivityDescription = new BiologicalActivityDescriptionDataType(); activity.BiologicalActivityDescription.AssemblageSampledName = readerEx.GetNullString("BIOACTIVITYASSEMBLAGESAMPD"); activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation = new BiologicalHabitatCollectionInformationDataType(); activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.CollectionDuration = GetNullMeasureCompactData(readerEx, "BIOHABCOLLDURATIONMEASURE", "BIOHABCOLLDURATIONMEASUREUNIT"); activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.SamplingComponentName = readerEx.GetNullString("BIOHABSAMPCOMP"); activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.SamplingComponentPlaceInSeriesNumeric = readerEx.GetNullString("BIOHABSAMPCOMPPLACEINSERIES"); activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.ReachWidthMeasure = GetNullMeasureCompactData(readerEx, "BIOHABREACHLENGTHMEASURE", "BIOHABREACHLENGTHMEASUREUNIT"); activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.ReachLengthMeasure = GetNullMeasureCompactData(readerEx, "BIOHABREACHWIDTHMEASURE", "BIOHABREACHWIDTHMEASUREUNIT"); activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.PassCount = readerEx.GetNullString("BIOHABPASSCOUNT"); if (!readerEx.IsDBNull("BIOHABNETTYPE") || !readerEx.IsDBNull("BIOHABNETSURFACEAREAMEASURE") || !readerEx.IsDBNull("BIOHABNETSURFACEMEASUREUNIT") || !readerEx.IsDBNull("BIOHABNETMESHSIZEMEASURE") || !readerEx.IsDBNull("BIOHABNETMESHMEASUREUNIT")) { activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.NetInformation = new NetInformationDataType(); activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.NetInformation.NetTypeName = readerEx.GetString("BIOHABNETTYPE"); activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.NetInformation.NetSurfaceAreaMeasure = GetNullMeasureCompactData(readerEx, "BIOHABNETSURFACEAREAMEASURE", "BIOHABNETSURFACEMEASUREUNIT"); activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.NetInformation.NetMeshSizeMeasure = GetNullMeasureCompactData(readerEx, "BIOHABNETMESHSIZEMEASURE", "BIOHABNETMESHMEASUREUNIT"); activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.NetInformation.BoatSpeedMeasure = GetNullMeasureCompactData(readerEx, "BIOHABNETBOATSPEEDMEASURE", "BIOHABNETBOATSPEEDMEASUREUNIT"); activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.NetInformation.CurrentSpeedMeasure = GetNullMeasureCompactData(readerEx, "BIOHABNETCURRSPEEDMEASURE", "BIOHABNETCURRSPEEDMEASUREUNIT"); } if ((activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.CollectionDuration == null) && string.IsNullOrEmpty(activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.SamplingComponentName) && string.IsNullOrEmpty(activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.SamplingComponentPlaceInSeriesNumeric) && (activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.ReachWidthMeasure == null) && (activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.ReachLengthMeasure == null) && string.IsNullOrEmpty(activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.PassCount) && (activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation.NetInformation == null)) { activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation = null; } activity.BiologicalActivityDescription.ToxicityTestType = readerEx.GetNullString("BIOACTIVITYTOXICITYTESTTYPE"); if (string.IsNullOrEmpty(activity.BiologicalActivityDescription.AssemblageSampledName) && string.IsNullOrEmpty(activity.BiologicalActivityDescription.ToxicityTestType) && (activity.BiologicalActivityDescription.BiologicalHabitatCollectionInformation == null)) { activity.BiologicalActivityDescription = null; } activity.SampleDescription = new SampleDescriptionDataType(); if (!readerEx.IsDBNull("SAMPCOLLMETHODID") || !readerEx.IsDBNull("SAMPCOLLMETHODIDCONTEXT") || !readerEx.IsDBNull("SAMPCOLLMETHOD")) { activity.SampleDescription.SampleCollectionMethod = new ReferenceMethodDataType(); activity.SampleDescription.SampleCollectionMethod.MethodIdentifier = readerEx.GetString("SAMPCOLLMETHODID"); activity.SampleDescription.SampleCollectionMethod.MethodIdentifierContext = readerEx.GetString("SAMPCOLLMETHODIDCONTEXT"); activity.SampleDescription.SampleCollectionMethod.MethodName = readerEx.GetString("SAMPCOLLMETHOD"); activity.SampleDescription.SampleCollectionMethod.MethodQualifierTypeName = readerEx.GetNullString("SAMPCOLLMETHODQUALIFIER"); activity.SampleDescription.SampleCollectionMethod.MethodDescriptionText = readerEx.GetNullString("SAMPCOLLMETHODDESC"); } activity.SampleDescription.SampleCollectionEquipmentName = readerEx.GetString("SAMPCOLLEQUIPMENT"); activity.SampleDescription.SampleCollectionEquipmentCommentText = readerEx.GetNullString("SAMPCOLLEQUIPMENTCOMMENT"); if (!readerEx.IsDBNull("SAMPPREPCONTTYPE") || !readerEx.IsDBNull("SAMPPREPCONTCOLOR") || !readerEx.IsDBNull("SAMPPREPCONTSAMPTRANSSTORDESC") || !readerEx.IsDBNull("SAMPPREPID") || !readerEx.IsDBNull("SAMPPREPIDCONTEXT") || !readerEx.IsDBNull("SAMPPREP")) { activity.SampleDescription.SamplePreparation = new SamplePreparationDataType(); if (!readerEx.IsDBNull("SAMPPREPID") || !readerEx.IsDBNull("SAMPPREPIDCONTEXT") || !readerEx.IsDBNull("SAMPPREP")) { activity.SampleDescription.SamplePreparation.SamplePreparationMethod = new ReferenceMethodDataType(); activity.SampleDescription.SamplePreparation.SamplePreparationMethod.MethodIdentifier = readerEx.GetString("SAMPPREPID"); activity.SampleDescription.SamplePreparation.SamplePreparationMethod.MethodIdentifierContext = readerEx.GetString("SAMPPREPIDCONTEXT"); activity.SampleDescription.SamplePreparation.SamplePreparationMethod.MethodName = readerEx.GetString("SAMPPREP"); activity.SampleDescription.SamplePreparation.SamplePreparationMethod.MethodQualifierTypeName = readerEx.GetNullString("SAMPPREPQUALIFIERTYPE"); activity.SampleDescription.SamplePreparation.SamplePreparationMethod.MethodDescriptionText = readerEx.GetNullString("SAMPPREPDESC"); } activity.SampleDescription.SamplePreparation.SampleContainerTypeName = readerEx.GetString("SAMPPREPCONTTYPE"); activity.SampleDescription.SamplePreparation.SampleContainerColorName = readerEx.GetString("SAMPPREPCONTCOLOR"); activity.SampleDescription.SamplePreparation.ChemicalPreservativeUsedName = readerEx.GetNullString("SAMPPREPCONTCHEMPRESERVUSED"); activity.SampleDescription.SamplePreparation.ThermalPreservativeUsedName = readerEx.GetNullString("SAMPPREPCONTTHERMALPRESERVUSED"); activity.SampleDescription.SamplePreparation.SampleTransportStorageDescription = readerEx.GetString("SAMPPREPCONTSAMPTRANSSTORDESC"); } if (activity.SampleDescription.SampleCollectionMethod == null) { DebugUtils.AssertDebuggerBreak(string.IsNullOrEmpty(activity.SampleDescription.SampleCollectionEquipmentName)); // SampleCollectionMethod is required activity.SampleDescription = null; } activity.ResultCount = readerEx.GetNullString("RESULTCOUNT"); // TODO: TMPACTIVITYTYPE and TMPPROJECTID not used return(activity); }
public static ResultDataType MapResult(NamedNullMappingDataReader readerEx) { ResultDataType result = new ResultDataType(); result.RecordId = readerEx.GetString("RECORDID"); result.ResultDescription = new ResultDescriptionDataType(); result.ResultDescription.DataLoggerLineName = readerEx.GetNullString("DATALOGGERLINENAME"); result.ResultDescription.ResultDetectionConditionText = readerEx.GetNullString("RESULTDETECTIONCONDITION"); result.ResultDescription.CharacteristicName = readerEx.GetNullString("CHARACTERISTICNAME"); result.ResultDescription.MethodSpeciationName = readerEx.GetNullString("METHODSPECIATIONNAME"); result.ResultDescription.ResultSampleFractionText = readerEx.GetNullString("RESULTSAMPFRACTION"); result.ResultDescription.ResultMeasure = new MeasureDataType(); result.ResultDescription.ResultMeasure.ResultMeasureValue = readerEx.GetNullString("RESULTMEASURE"); result.ResultDescription.ResultMeasure.MeasureUnitCode = readerEx.GetNullString("RESULTMEASUREUNIT"); result.ResultDescription.ResultMeasure.MeasureQualifierCode = readerEx.GetNullString("RESULTMEASUREQUALIFIERCODE"); result.ResultDescription.ResultStatusIdentifier = readerEx.GetNullString("STATUSID"); result.ResultDescription.StatisticalBaseCode = readerEx.GetNullString("STATISTICALBASECODE"); result.ResultDescription.ResultValueTypeName = readerEx.GetNullString("VALUETYPE"); result.ResultDescription.ResultWeightBasisText = readerEx.GetNullString("WEIGHTBASIS"); result.ResultDescription.ResultTimeBasisText = readerEx.GetNullString("TIMEBASIS"); result.ResultDescription.ResultTemperatureBasisText = readerEx.GetNullString("TEMPERATUREBASIS"); result.ResultDescription.ResultParticleSizeBasisText = readerEx.GetNullString("PARTICLESIZEBASIS"); result.ResultDescription.DataQuality = new DataQualityDataType(); result.ResultDescription.DataQuality.PrecisionValue = readerEx.GetNullString("PRECISIONVALUE"); result.ResultDescription.DataQuality.BiasValue = readerEx.GetNullString("BIASVALUE"); result.ResultDescription.DataQuality.ConfidenceIntervalValue = readerEx.GetNullString("CONFIDENCEINTERVALVALUE"); result.ResultDescription.DataQuality.UpperConfidenceLimitValue = readerEx.GetNullString("UPPERCONFIDENCELIMITVALUE"); result.ResultDescription.DataQuality.LowerConfidenceLimitValue = readerEx.GetNullString("LOWERCONFIDENCELIMITVALUE"); result.ResultDescription.ResultCommentText = readerEx.GetNullString("RESULTCOMMENT"); result.ResultDescription.ResultDepthHeightMeasure = GetNullMeasureCompactData(readerEx, "DEPTHHEIGHTMEASURE", "DEPTHHEIGHTMEASUREUNIT"); result.ResultDescription.ResultDepthAltitudeReferencePointText = readerEx.GetNullString("DEPTHALTITUDEREFPOINT"); result.ResultDescription.ResultSamplingPointName = readerEx.GetNullString("RESULTSAMPPOINT"); if (!readerEx.IsDBNull("BIORESULTINTENT") || !readerEx.IsDBNull("BIORESULTSUBJECTTAXONOMIC")) { result.BiologicalResultDescription = new BiologicalResultDescriptionDataType(); result.BiologicalResultDescription.BiologicalIntentName = readerEx.GetString("BIORESULTINTENT"); result.BiologicalResultDescription.BiologicalIndividualIdentifier = readerEx.GetNullString("BIORESULTINDIVIDUALID"); result.BiologicalResultDescription.SubjectTaxonomicName = readerEx.GetString("BIORESULTSUBJECTTAXONOMIC"); result.BiologicalResultDescription.UnidentifiedSpeciesIdentifier = readerEx.GetNullString("BIORESULTUNIDENTIFIEDSPECIESID"); result.BiologicalResultDescription.SampleTissueAnatomyName = readerEx.GetNullString("BIORESULTSAMPTISSUEANATOMY"); result.BiologicalResultDescription.GroupSummaryCountWeight = GetNullMeasureCompactData(readerEx, "GRPSUMMCOUNTWEIGHTMEASURE", "GRPSUMMCOUNTWEIGHTMEASUREUNIT"); result.BiologicalResultDescription.TaxonomicDetails = new TaxonomicDetailsDataType(); result.BiologicalResultDescription.TaxonomicDetails.CellFormName = readerEx.GetNullString("TAXDETAILSCELLFORM"); result.BiologicalResultDescription.TaxonomicDetails.CellShapeName = readerEx.GetNullString("TAXDETAILSCELLSHAPE"); if (!readerEx.IsDBNull("TAXDETAILSHABITNAME")) { result.BiologicalResultDescription.TaxonomicDetails.HabitName = WQXDataHelper.PipedStringToStrings(readerEx.GetString("TAXDETAILSHABITNAME")); } result.BiologicalResultDescription.TaxonomicDetails.VoltinismName = readerEx.GetNullString("TAXDETAILSVOLTINISM"); result.BiologicalResultDescription.TaxonomicDetails.TaxonomicPollutionTolerance = readerEx.GetNullString("TAXDETAILSPOLLTOLERANCE"); result.BiologicalResultDescription.TaxonomicDetails.TaxonomicPollutionToleranceScaleText = readerEx.GetNullString("TAXDETAILSPOLLTOLERANCESCALE"); result.BiologicalResultDescription.TaxonomicDetails.TrophicLevelName = readerEx.GetNullString("TAXDETAILSTROPHICLEVEL"); if (!readerEx.IsDBNull("TAXDETAILSFUNCFEEDINGGROUP")) { result.BiologicalResultDescription.TaxonomicDetails.FunctionalFeedingGroupName = WQXDataHelper.PipedStringToStrings(readerEx.GetString("TAXDETAILSFUNCFEEDINGGROUP")); } if (!readerEx.IsDBNull("CITATIONRESOURCETITLE") || !readerEx.IsDBNull("CITATIONRESOURCEID")) { result.BiologicalResultDescription.TaxonomicDetails.TaxonomicDetailsCitation = new BibliographicReferenceDataType(); result.BiologicalResultDescription.TaxonomicDetails.TaxonomicDetailsCitation.ResourceTitleName = readerEx.GetString("CITATIONRESOURCETITLE"); result.BiologicalResultDescription.TaxonomicDetails.TaxonomicDetailsCitation.ResourceCreatorName = readerEx.GetNullString("CITATIONRESOURCECREATOR"); result.BiologicalResultDescription.TaxonomicDetails.TaxonomicDetailsCitation.ResourceSubjectText = readerEx.GetNullString("CITATIONRESOURCESUBJECT"); result.BiologicalResultDescription.TaxonomicDetails.TaxonomicDetailsCitation.ResourcePublisherName = readerEx.GetNullString("CITATIONRESOURCEPUBLISHER"); result.BiologicalResultDescription.TaxonomicDetails.TaxonomicDetailsCitation.ResourceDate = readerEx.GetDateTime("CITATIONRESOURCEDATE"); result.BiologicalResultDescription.TaxonomicDetails.TaxonomicDetailsCitation.ResourceIdentifier = readerEx.GetString("CITATIONRESOURCEID"); } if (!readerEx.IsDBNull("FREQCLASSDESCCODE")) { result.BiologicalResultDescription.FrequencyClassInformation = new FrequencyClassInformationDataType(); result.BiologicalResultDescription.FrequencyClassInformation.FrequencyClassDescriptorCode = readerEx.GetString("FREQCLASSDESCCODE"); result.BiologicalResultDescription.FrequencyClassInformation.FrequencyClassDescriptorUnitCode = readerEx.GetNullString("FREQCLASSDESCUNITCODE"); result.BiologicalResultDescription.FrequencyClassInformation.LowerClassBoundValue = readerEx.GetNullString("FREQCLASSLOWERBOUNDVALUE"); result.BiologicalResultDescription.FrequencyClassInformation.UpperClassBoundValue = readerEx.GetNullString("FREQCLASSUPPERBOUNDVALUE"); } } if (!readerEx.IsDBNull("ANALYTICALMETHODID") || !readerEx.IsDBNull("ANALYTICALMETHODIDCONTEXT")) { result.ResultAnalyticalMethod = new ResultAnalyticalMethodDataType(); result.ResultAnalyticalMethod.MethodIdentifier = readerEx.GetString("ANALYTICALMETHODID"); result.ResultAnalyticalMethod.MethodIdentifierContext = readerEx.GetString("ANALYTICALMETHODIDCONTEXT"); result.ResultAnalyticalMethod.MethodName = readerEx.GetNullString("ANALYTICALMETHODNAME"); result.ResultAnalyticalMethod.MethodQualifierTypeName = readerEx.GetNullString("ANALYTICALMETHODQUALIFIERTYPE"); result.ResultAnalyticalMethod.MethodDescriptionText = readerEx.GetNullString("ANALYTICALMETHODDESC"); } result.ResultLabInformation = new ResultLabInformationDataType(); result.ResultLabInformation.LaboratoryName = readerEx.GetNullString("LABNAME"); result.ResultLabInformation.AnalysisStartDateSpecified = !readerEx.IsDBNull("LABANALYSISSTARTDATE"); if (result.ResultLabInformation.AnalysisStartDateSpecified) { result.ResultLabInformation.AnalysisStartDate = readerEx.GetDateTime("LABANALYSISSTARTDATE"); } result.ResultLabInformation.AnalysisStartTime = GetNullTimeData(readerEx, "LABANALYSISSTARTTIME", "LABANALYSISSTARTTIMEZONECODE"); result.ResultLabInformation.AnalysisEndDateSpecified = !readerEx.IsDBNull("LABANALYSISENDDATE"); if (result.ResultLabInformation.AnalysisEndDateSpecified) { result.ResultLabInformation.AnalysisEndDate = readerEx.GetDateTime("LABANALYSISENDDATE"); } result.ResultLabInformation.AnalysisEndTime = GetNullTimeData(readerEx, "LABANALYSISENDTIME", "LABANALYSISENDTIMEZONECODE"); result.ResultLabInformation.ResultLaboratoryCommentCode = readerEx.GetNullString("RESULTLABCOMMENTCODE"); result.ResultLabInformation.LaboratoryAccreditationIndicatorSpecified = !readerEx.IsDBNull("LABACCIND"); if (result.ResultLabInformation.LaboratoryAccreditationIndicatorSpecified) { result.ResultLabInformation.LaboratoryAccreditationIndicator = ToBool(readerEx.GetString("LABACCIND")); } result.ResultLabInformation.LaboratoryAccreditationAuthorityName = readerEx.GetNullString("LABACCAUTHORITYNAME"); result.ResultLabInformation.TaxonomistAccreditationIndicatorSpecified = !readerEx.IsDBNull("LABTAXACCIND"); if (result.ResultLabInformation.TaxonomistAccreditationIndicatorSpecified) { result.ResultLabInformation.TaxonomistAccreditationIndicator = ToBool(readerEx.GetString("LABTAXACCIND")); } result.ResultLabInformation.TaxonomistAccreditationAuthorityName = readerEx.GetNullString("LABTAXACCAUTHORITYNAME"); #if NO // TODO result.BiologicalResultDescription.FrequencyClassInformation result.LabSamplePreparation #endif return(result); }
public static ActivityMetricDataType MapActivityMetric(NamedNullMappingDataReader readerEx) { ActivityMetricDataType activityMetric = new ActivityMetricDataType(); activityMetric.ActivityMetricType = new ActivityMetricTypeDataType(); activityMetric.ActivityMetricType.MetricTypeIdentifier = readerEx.GetString("METRICTYPEID"); activityMetric.ActivityMetricType.MetricTypeIdentifierContext = readerEx.GetString("METRICTYPEIDCONTEXT"); activityMetric.ActivityMetricType.MetricTypeName = readerEx.GetNullString("METRICTYPENAME"); if (!readerEx.IsDBNull("CITATIONRESOURCETITLE") || !readerEx.IsDBNull("CITATIONRESOURCEID")) { activityMetric.ActivityMetricType.MetricTypeCitation = new BibliographicReferenceDataType(); activityMetric.ActivityMetricType.MetricTypeCitation.ResourceTitleName = readerEx.GetString("CITATIONRESOURCETITLE"); activityMetric.ActivityMetricType.MetricTypeCitation.ResourceCreatorName = readerEx.GetNullString("CITATIONRESOURCECREATOR"); activityMetric.ActivityMetricType.MetricTypeCitation.ResourceSubjectText = readerEx.GetNullString("CITATIONRESOURCESUBJECT"); activityMetric.ActivityMetricType.MetricTypeCitation.ResourcePublisherName = readerEx.GetNullString("CITATIONRESOURCEPUBLISHER"); activityMetric.ActivityMetricType.MetricTypeCitation.ResourceDate = readerEx.GetDateTime("CITATIONRESOURCEDATE"); activityMetric.ActivityMetricType.MetricTypeCitation.ResourceIdentifier = readerEx.GetString("CITATIONRESOURCEID"); } activityMetric.ActivityMetricType.MetricTypeScaleText = readerEx.GetNullString("METRICTYPESCALE"); activityMetric.ActivityMetricType.FormulaDescriptionText = readerEx.GetNullString("METRICTYPEFORMULADESC"); activityMetric.MetricValueMeasure = GetNullMeasureCompactData(readerEx, "METRICVALUEMEASURE", "METRICVALUEMEASUREUNIT"); activityMetric.MetricScoreNumeric = readerEx.GetString("METRICSCORE"); activityMetric.MetricCommentText = readerEx.GetNullString("METRICCOMMENT"); if (!readerEx.IsDBNull("METRICINDEXID")) { activityMetric.IndexIdentifier = readerEx.GetString("METRICINDEXID"); } return(activityMetric); }