// No one single data source provides enough data for Sources table,
// so try all resources to put them together.
public static void HandleSourceInfo(SqlConnection sqlConn,
SiteInfoType stinfo, seriesCatalogTypeSeries scts, TimeSeriesType tst)
{
string cond = "SourceID = " + scts.source.sourceID;
if (OD_Utils.Exists("Sources", cond, sqlConn))
{
return;
}
SourcesTableAdapter srcAdapter = new SourcesTableAdapter();
srcAdapter.Connection = sqlConn;
int metadataID = 0;
string title = "Unknown";
OD_1_1_1DataSet.SourcesDataTable tblSources = new OD_1_1_1DataSet.SourcesDataTable();
// We currently don't have any information about ISOMetaDataTable. Just create
// an unkown entry to resolve foreign key dependency.
if (scts.source.metadata != null)
{
title = scts.source.metadata.title;
}
cond = string.Format("Title = '{0}'", title);
metadataID = OD_Utils.GetPrimaryKey("ISOMetadata", "MetadataID", cond, sqlConn);
if (metadataID < 0)
{
InsertOneMetadata(scts.source.metadata, sqlConn);
metadataID = OD_Utils.GetPrimaryKey("ISOMetadata", "MetadataID", cond, sqlConn);
}
Console.WriteLine(">>>Parsing and inserting SOURCES");
InsertOneSource(tblSources, stinfo, scts, tst, metadataID, sqlConn);
//srcAdapter.Update(tblSources);
//PrintTable(srcAdapter, tblSites);
}
// 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;
}
