private static seriesCatalogType createSeriesCatalog(seriesCatalogDataSet ds, VariablesDataset vds, ControlledVocabularyDataset vocabularyDataset) { 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, vocabularyDataset); seriesRecords.Add(aRecord); } catalog.series = seriesRecords.ToArray(); return catalog; } else { seriesCatalogType catalog = CuahsiBuilder.CreateSeriesCatalog(0, null, // menu name (aka OD name "http://locahost/" // web service location ); return catalog; } }
public static ControlledVocabularyDataset GetVocabularyDataset() { ControlledVocabularyDataset ds = new ControlledVocabularyDataset(); adapters.QualityControlLevelsTableAdapter qcApapter = new adapters.QualityControlLevelsTableAdapter(); qcApapter.Connection.ConnectionString = Config.ODDB(); qcApapter.Fill(ds.QualityControlLevels); return(ds); }
public static seriesCatalogType[] dataSet2SeriesCatalog(seriesCatalogDataSet ds, VariablesDataset vds, ControlledVocabularyDataset vocabularyDataset) { /* logic * for each sourceID that is associated with the site * * */ List<seriesCatalogType> catalogs = new List<seriesCatalogType>(); seriesCatalogType catalog = createSeriesCatalog(ds, vds, vocabularyDataset); if (catalog != null) catalogs.Add(catalog); return catalogs.ToArray(); }
public static seriesCatalogTypeSeries row2SeriesCatalogElement(seriesCatalogDataSet.SeriesCatalogRow row, seriesCatalogDataSet ds, VariablesDataset vds, ControlledVocabularyDataset vocabularyDataset) { int variableID = row.VariableID; VariableInfoType variable = ODvariables.GetVariableByID(variableID, vds); Nullable<W3CDateTime> beginDateTime = null; if (!row.IsBeginDateTimeNull()) { TimeSpan timeSpan = row.BeginDateTime.Subtract(row.BeginDateTimeUTC); beginDateTime = new W3CDateTime(row.BeginDateTime, timeSpan); } Nullable<W3CDateTime> endDateTime = null; if (!row.IsEndDateTimeNull()) { TimeSpan timeSpan = row.EndDateTime.Subtract(row.EndDateTimeUTC); endDateTime = new W3CDateTime(row.EndDateTime, timeSpan); } Nullable<int> valueCount = null; if (!row.IsValueCountNull()) valueCount = row.ValueCount; string qualityControlLevelTerm = null; int? QualityControlLevelid = null; if (!row.IsQualityControlLevelIDNull()) { QualityControlLevelid = row.QualityControlLevelID; ControlledVocabularyDataset.QualityControlLevelsRow qcRow = vocabularyDataset.QualityControlLevels.FindByQualityControlLevelID(QualityControlLevelid.Value); if (qcRow != null ) { qualityControlLevelTerm = qcRow.Definition; } } int? MethodID = null; if (!row.IsMethodIDNull()) MethodID = row.MethodID; int? SourceID = null; if (!row.IsSourceIDNull()) SourceID = row.SourceID; Nullable<Boolean> valueCountIsEstimated = false; /* public static seriesCatalogTypeSeries createSeriesCatalogRecord( VariableInfoType variable, string sampleMedium, Nullable<W3CDateTime> beginDateTime, Nullable<W3CDateTime> endDateTime, Nullable<int> valueCount, Nullable<Boolean> valueCountIsEstimated, string dataType, string valueType, string generalCategory ) */ seriesCatalogTypeSeries record = CuahsiBuilder.CreateSeriesRecord( variable, variable.sampleMedium.ToString(), beginDateTime, endDateTime, valueCount, valueCountIsEstimated, null, null, null, false, // real time null, // string if real time row.QualityControlLevelCode, QualityControlLevelid, row.MethodDescription, MethodID, row.Organization, row.SourceDescription, SourceID, row.Citation, true, // include UTC Time qualityControlLevelTerm ); return record; }
public GetSiteInfoOD() { variablesDs = ODvariables.GetVariableDataSet(); vocabulariesDs = ODvocabularies.GetVocabularyDataset(); }
private static seriesCatalogType createSeriesCatalog(seriesCatalogDataSet ds, VariablesDataset vds, ControlledVocabularyDataset vocabularyDataset) { 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, vocabularyDataset); seriesRecords.Add(aRecord); } catalog.series = seriesRecords.ToArray(); return(catalog); } else { seriesCatalogType catalog = CuahsiBuilder.CreateSeriesCatalog(0, null, // menu name (aka OD name "http://locahost/" // web service location ); return(catalog); } }
public static seriesCatalogType[] dataSet2SeriesCatalog(seriesCatalogDataSet ds, VariablesDataset vds, ControlledVocabularyDataset vocabularyDataset) { /* logic * for each sourceID that is associated with the site * * */ List <seriesCatalogType> catalogs = new List <seriesCatalogType>(); seriesCatalogType catalog = createSeriesCatalog(ds, vds, vocabularyDataset); if (catalog != null) { catalogs.Add(catalog); } return(catalogs.ToArray()); }
public static seriesCatalogTypeSeries row2SeriesCatalogElement(seriesCatalogDataSet.SeriesCatalogRow row, seriesCatalogDataSet ds, VariablesDataset vds, ControlledVocabularyDataset vocabularyDataset) { int variableID = row.VariableID; VariableInfoType variable = ODvariables.GetVariableByID(variableID, vds); Nullable <W3CDateTime> beginDateTime = null; if (!row.IsBeginDateTimeNull()) { TimeSpan timeSpan = row.BeginDateTime.Subtract(row.BeginDateTimeUTC); beginDateTime = new W3CDateTime(row.BeginDateTime, timeSpan); } Nullable <W3CDateTime> endDateTime = null; if (!row.IsEndDateTimeNull()) { TimeSpan timeSpan = row.EndDateTime.Subtract(row.EndDateTimeUTC); endDateTime = new W3CDateTime(row.EndDateTime, timeSpan); } Nullable <int> valueCount = null; if (!row.IsValueCountNull()) { valueCount = row.ValueCount; } string qualityControlLevelTerm = null; int? QualityControlLevelid = null; if (!row.IsQualityControlLevelIDNull()) { QualityControlLevelid = row.QualityControlLevelID; ControlledVocabularyDataset.QualityControlLevelsRow qcRow = vocabularyDataset.QualityControlLevels.FindByQualityControlLevelID(QualityControlLevelid.Value); if (qcRow != null) { qualityControlLevelTerm = qcRow.Definition; } } int?MethodID = null; if (!row.IsMethodIDNull()) { MethodID = row.MethodID; } int?SourceID = null; if (!row.IsSourceIDNull()) { SourceID = row.SourceID; } Nullable <Boolean> valueCountIsEstimated = false; /* public static seriesCatalogTypeSeries createSeriesCatalogRecord( * VariableInfoType variable, * string sampleMedium, * Nullable<W3CDateTime> beginDateTime, * Nullable<W3CDateTime> endDateTime, * Nullable<int> valueCount, * Nullable<Boolean> valueCountIsEstimated, * string dataType, * string valueType, * string generalCategory * ) */ seriesCatalogTypeSeries record = CuahsiBuilder.CreateSeriesRecord( variable, variable.sampleMedium.ToString(), beginDateTime, endDateTime, valueCount, valueCountIsEstimated, null, null, null, false, // real time null, // string if real time row.QualityControlLevelCode, QualityControlLevelid, row.MethodDescription, MethodID, row.Organization, row.SourceDescription, SourceID, row.Citation, true, // include UTC Time qualityControlLevelTerm ); return(record); }
public virtual int Update(ControlledVocabularyDataset dataSet) { return this.Adapter.Update(dataSet, "QualityControlLevels"); }
public virtual int Update(ControlledVocabularyDataset.QualityControlLevelsDataTable dataTable) { return this.Adapter.Update(dataTable); }
public virtual int Fill(ControlledVocabularyDataset.QualityControlLevelsDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) { global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); ControlledVocabularyDataset ds = new ControlledVocabularyDataset(); global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "QualityControlLevelsDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { ControlledVocabularyDataset ds = new ControlledVocabularyDataset(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; }
public GetSiteInfoOD() { variablesDs = ODvariables.GetVariableDataSet(); vocabulariesDs = ODvocabularies.GetVocabularyDataset(); }