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