Exemple #1
0
        // never implemented or used. Now implemented as a filter using a passed variable parameter
        //public static ValuesDataSet GetValueDataSet(int? siteID, int? VariableID, int? MethodID, int? SourceID, int? QualityControlLevelID, W3CDateTime BeginDateTime, W3CDateTime EndDateTime)
        //{
        //    ValuesDataSet ds = basicValuesDataSet();
        //    if (!siteID.HasValue || !VariableID.HasValue) return ds;
        //    ValuesDataSetTableAdapters.DataValuesTableAdapter valuesTableAdapter = new DataValuesTableAdapter();
        //    valuesTableAdapter.Connection.ConnectionString = Config.ODDB();

        //    valuesTableAdapter.FillBySiteIdVariableIDBetweenDates(ds.DataValues, siteID.Value, VariableID.Value, BeginDateTime.DateTime, EndDateTime.DateTime);

        //    return ds;
        //}
        #endregion



        // fills dataset with basic tables
        private static ValuesDataSet basicValuesDataSet()
        {
            ValuesDataSet ds = new ValuesDataSet();

            ValuesDataSetTableAdapters.UnitsTableAdapter unitsTableAdapter =
                new UnitsTableAdapter();
            unitsTableAdapter.Connection.ConnectionString = Config.ODDB();

            ValuesDataSetTableAdapters.OffsetTypesTableAdapter offsetTypesTableAdapter =
                new ValuesDataSetTableAdapters.OffsetTypesTableAdapter();
            offsetTypesTableAdapter.Connection.ConnectionString = Config.ODDB();

            ValuesDataSetTableAdapters.QualityControlLevelsTableAdapter qualityControlLevelsTableAdapter =
                new ValuesDataSetTableAdapters.QualityControlLevelsTableAdapter();
            qualityControlLevelsTableAdapter.Connection.ConnectionString = Config.ODDB();

            ValuesDataSetTableAdapters.MethodsTableAdapter methodsTableAdapter =
                new ValuesDataSetTableAdapters.MethodsTableAdapter();
            methodsTableAdapter.Connection.ConnectionString = Config.ODDB();

            ValuesDataSetTableAdapters.SamplesTableAdapter samplesTableAdapter =
                new ValuesDataSetTableAdapters.SamplesTableAdapter();
            samplesTableAdapter.Connection.ConnectionString = Config.ODDB();

            ValuesDataSetTableAdapters.SourcesTableAdapter sourcesTableAdapter =
                new ValuesDataSetTableAdapters.SourcesTableAdapter();
            sourcesTableAdapter.Connection.ConnectionString = Config.ODDB();

            QualifiersTableAdapter qualifiersTableAdapter =
                new QualifiersTableAdapter();

            qualifiersTableAdapter.Connection.ConnectionString = 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);



            return(ds);
        }
Exemple #2
0
        // 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;
            }