/// <summary> /// Get a series catalog for a site. /// /// </summary> /// <param name="siteID"></param> /// <returns></returns> public static seriesCatalogDataSet GetSeriesCatalogDataSet(int siteID) { seriesCatalogDataSet sDS = new seriesCatalogDataSet(); SeriesCatalogTableAdapter seriesTableAdapter = new SeriesCatalogTableAdapter(); seriesTableAdapter.Connection.ConnectionString = Config.ODDB(); try { seriesTableAdapter.FillBySiteID(sDS.SeriesCatalog, siteID); } catch (Exception e) { log.Fatal("Cannot retrieve information from database: " + e.Message); //+ seriesTableAdapter.Connection.DataSource } return sDS; }
public static seriesCatalogType[] dataSet2SeriesCatalog( seriesCatalogDataSet ds, VariablesDataset vds) { /* logic * for each sourceID that is associated with the site * * */ List<seriesCatalogType> catalogs = new List<seriesCatalogType>(); seriesCatalogType catalog = createSeriesCatalog(ds, vds); if (catalog != null) { catalogs.Add(catalog); } return catalogs.ToArray(); }
public static seriesCatalogTypeSeries row2SeriesCatalogElement( seriesCatalogDataSet.SeriesCatalogRow row, seriesCatalogDataSet ds, VariablesDataset vds) { int variableID = row.VariableID; VariableInfoType variable = ODvariables.GetVariableByID(variableID, vds); Nullable<W3CDateTime> beginDateTime = null; if (!row.IsBeginDateTimeNull()) beginDateTime = new W3CDateTime(row.BeginDateTime); Nullable<W3CDateTime> endDateTime = null; if (!row.IsEndDateTimeNull()) endDateTime = new W3CDateTime(row.EndDateTime); Nullable<int> valueCount = null; if (!row.IsValueCountNull()) valueCount = row.ValueCount; int? QualityControlLevelid = null; if (!row.IsQualityControlLevelIDNull()) QualityControlLevelid = row.QualityControlLevelID; int? MethodID = null; if (!row.IsMethodIDNull()) MethodID = row.MethodID; int? SourceID = null; if (!row.IsSourceIDNull()) SourceID = row.SourceID; Nullable<Boolean> valueCountIsEstimated = false; seriesCatalogTypeSeries record = CuahsiBuilder.CreateSeriesRecord( variable, variable.sampleMedium.ToString(), beginDateTime, endDateTime, valueCount, valueCountIsEstimated, null, null, null, false, // real time null, // string if real time null, QualityControlLevelid, row.MethodDescription, MethodID, row.Organization, row.SourceDescription, SourceID, row.Citation); return record; }
private static seriesCatalogType createSeriesCatalog( seriesCatalogDataSet ds, VariablesDataset vds) { if (ds.SeriesCatalog.Count > 0) { Boolean useOD; String siteServiceURL; String siteServiceName; try { useOD = Boolean.Parse(ConfigurationManager.AppSettings["UseODForValues"]); if (!useOD) { siteServiceURL = ConfigurationManager.AppSettings["externalGetValuesService"]; siteServiceName = ConfigurationManager.AppSettings["externalGetValuesName"]; } else { siteServiceURL = "http://localhost/"; siteServiceName = "OD Web Services"; } } catch { useOD = true; // should be caught earlier siteServiceURL = "http://locahost/"; siteServiceName = "Fix UseODForValues, externalGetValuesService, externalGetValuesName"; } seriesCatalogType catalog = CuahsiBuilder.CreateSeriesCatalog( ds.SeriesCatalog.Count, siteServiceName, // menu name (aka OD name siteServiceURL// web service location ); List<seriesCatalogTypeSeries> seriesRecords = new List<seriesCatalogTypeSeries>(); foreach (seriesCatalogDataSet.SeriesCatalogRow row in ds.SeriesCatalog.Rows) { seriesCatalogTypeSeries aRecord = row2SeriesCatalogElement( row, ds, vds); seriesRecords.Add(aRecord); } catalog.series = seriesRecords.ToArray(); return catalog; } else { seriesCatalogType catalog = CuahsiBuilder.CreateSeriesCatalog(0, null, // menu name (aka OD name String.Empty // web service location ); return catalog; } }