// fills dataset with basic tables private static ValuesDataSet basicValuesDataSet() { ValuesDataSet ds = new ValuesDataSet(); UnitsTableAdapter unitsTableAdapter = new UnitsTableAdapter(); unitsTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); OffsetTypesTableAdapter offsetTypesTableAdapter = new OffsetTypesTableAdapter(); offsetTypesTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); QualityControlLevelsTableAdapter qualityControlLevelsTableAdapter = new QualityControlLevelsTableAdapter(); qualityControlLevelsTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); MethodsTableAdapter methodsTableAdapter = new MethodsTableAdapter(); methodsTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); SamplesTableAdapter samplesTableAdapter = new SamplesTableAdapter(); samplesTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); SourcesTableAdapter sourcesTableAdapter = new SourcesTableAdapter(); sourcesTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); QualifiersTableAdapter qualifiersTableAdapter = new QualifiersTableAdapter(); qualifiersTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); CensorCodeCVTableAdapter censorCodeCvTableAdapter = new CensorCodeCVTableAdapter(); censorCodeCvTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); ISOMetadataTableAdapter IsoMetadataTableAdapter = new ISOMetadataTableAdapter(); IsoMetadataTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); unitsTableAdapter.Fill(ds.Units); offsetTypesTableAdapter.Fill(ds.OffsetTypes); qualityControlLevelsTableAdapter.Fill(ds.QualityControlLevels); methodsTableAdapter.Fill(ds.Methods); samplesTableAdapter.Fill(ds.Samples); sourcesTableAdapter.Fill(ds.Sources); qualifiersTableAdapter.Fill(ds.Qualifiers); censorCodeCvTableAdapter.Fill(ds.CensorCodeCV); IsoMetadataTableAdapter.Fill(ds.ISOMetadata); return(ds); }
//public static ValuesDataSet GetValueDataSet(int? siteID, int? VariableID, int? MethodID, int? SourceID, int? QualityControlLevelID) //{ // ValuesDataSet ds = basicValuesDataSet(); // if (!siteID.HasValue || !VariableID.HasValue) return ds; // ValuesDataSetTableAdapters.DataValuesTableAdapter valuesTableAdapter = new DataValuesTableAdapter(); // valuesTableAdapter.FillBySiteIdVariableIDBetweenDates(ds.DataValues, siteID.Value, VariableID.Value, BeginDateTime.DateTime, EndDateTime.DateTime); // return ds; //} #endregion odm 1 series based // fills dataset with basic tables private static ValuesDataSet basicValuesDataSet() { ValuesDataSet ds = new ValuesDataSet(); UnitsTableAdapter unitsTableAdapter = new UnitsTableAdapter(); unitsTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); OffsetTypesTableAdapter offsetTypesTableAdapter = new OffsetTypesTableAdapter(); offsetTypesTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); QualityControlLevelsTableAdapter qualityControlLevelsTableAdapter = new QualityControlLevelsTableAdapter(); qualityControlLevelsTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); MethodsTableAdapter methodsTableAdapter = new MethodsTableAdapter(); methodsTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); SamplesTableAdapter samplesTableAdapter = new SamplesTableAdapter(); samplesTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); SourcesTableAdapter sourcesTableAdapter = new SourcesTableAdapter(); sourcesTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); QualifiersTableAdapter qualifiersTableAdapter = new QualifiersTableAdapter(); qualifiersTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); CensorCodeCVTableAdapter censorCodeCvTableAdapter = new CensorCodeCVTableAdapter(); censorCodeCvTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); ISOMetadataTableAdapter IsoMetadataTableAdapter = new ISOMetadataTableAdapter(); IsoMetadataTableAdapter.Connection.ConnectionString = odws.Config.ODDB(); unitsTableAdapter.Fill(ds.Units); offsetTypesTableAdapter.Fill(ds.OffsetTypes); qualityControlLevelsTableAdapter.Fill(ds.QualityControlLevels); methodsTableAdapter.Fill(ds.Methods); samplesTableAdapter.Fill(ds.Samples); sourcesTableAdapter.Fill(ds.Sources); qualifiersTableAdapter.Fill(ds.Qualifiers); censorCodeCvTableAdapter.Fill(ds.CensorCodeCV); IsoMetadataTableAdapter.Fill(ds.ISOMetadata); return ds; }