private static seriesCatalogTypeSeries row2Series(UsgsDbDailyValues.seriesCatalogRow aRow) { if (aRow.IsVariableCodeNull()) { return(null); } string VariableCode = aRow.VariableCode; string VariableName = null; string VariableUnitName = null; string VariableUnitAbrreviation = null; string VariableUnitCode = null; string sampleMedium = null; string dataType = null; string valueType = null; string generalCategory = null; W3CDateTime?beginDateTime = null, endDateTime = null; int? valueCount = null; bool? valueCountIsEstimated = null; int? TimeInterval = null; string TimeIntervalUnits = null; bool isRealTime = false; string QualityControlLevelTerm = null; string methodName = null; string organization = null; string sourceDescription = null; if (!aRow.IsVariableNameNull()) { VariableName = aRow.VariableName; } if (!aRow.IsVariableUnitsAbbreviationNull()) { VariableUnitAbrreviation = aRow.VariableUnitsAbbreviation; } if (!aRow.IsVariableUnitsNameNull()) { VariableUnitName = aRow.VariableUnitsName; } if (!aRow.IsDataTypeNull()) { dataType = aRow.DataType; } if (!aRow.IsValueTypeNull()) { valueType = aRow.ValueType; } if (!aRow.IsGeneralCategoryNull()) { generalCategory = aRow.GeneralCategory; } if (!aRow.IsSampleMediumNull()) { sampleMedium = aRow.SampleMedium; } if (!aRow.IsMethodNameNull()) { methodName = aRow.MethodName; } if (!aRow.IsSourceDescriptionNull()) { sourceDescription = aRow.SourceDescription; } if (!aRow.IsOrganizationNull()) { organization = aRow.Organization; } if (!aRow.IsValueCountNull()) { int v; if (Int32.TryParse(aRow.ValueCount, out v)) { valueCount = v; } } if (!aRow.IsBeginDateTimeNull()) { beginDateTime = new W3CDateTime(aRow.BeginDateTime); } if (!aRow.IsEndDateTimeNull()) { endDateTime = new W3CDateTime(aRow.EndDateTime); } if (!aRow.IsTimeSupportNull()) { TimeInterval = aRow.TimeSupport; if (!aRow.IsTimeUnitsNameNull()) { TimeIntervalUnits = aRow.TimeUnitsName; } } // public static seriesCatalogTypeSeries CreateSeriesRecord( // string VariableCode, // string VariableName, // string VariableUnitName, // string VariableUnitAbrreviation, // string VariableUnitCode, // string sampleMedium, // string dataType, // string valueType, // string generalCategory, // W3CDateTime? beginDateTime, W3CDateTime? endDateTime, // int? valueCount, bool? valueCountIsEstimated, // string TimeInterval, // string TimeIntervalUnits, // bool isRealTime, // string QualityControlLevelTerm, // string methodName, // string organization, string sourceDescription //) seriesCatalogTypeSeries aSeries = CoreBuilder.CreateSeriesRecord( VariableCode, VariableName, VariableUnitName, VariableUnitAbrreviation, VariableUnitCode, sampleMedium, dataType, valueType, generalCategory, beginDateTime, endDateTime, valueCount, valueCountIsEstimated, TimeInterval, TimeIntervalUnits, isRealTime, QualityControlLevelTerm, methodName, organization, sourceDescription, "NWIS"); // add usgs statistic code options if (!aRow.Isusgs_stat_cdNull()) { List <option> opts = new List <option>(1); option opt = new option(); opt.name = "statistic"; opt.optionCode = aRow.usgs_stat_cd; opts.Add(opt); aSeries.variable.options = opts.ToArray(); } return(aSeries); }