/// <summary>
/// Gets an ODMDbDataContext from the specified ODM database, containin all Sites, Sources,
/// Variables, Time Series, Data Values, etc.
/// </summary>
/// <param name="odmDb">The odm db.</param>
/// <returns></returns>
public static ODMDbDataContext GetODMDbDataContext(ODMDatabase odmDb)
{
ConfigurationManager.AppSettings["OdmDbConnection"] = "server=" + odmDb.ServerAddress + ";Integrated Security=SSPI;database=" + odmDb.DatabaseName + ";user="******";password="******";Trusted_Connection=false;";
return(new ODMDbDataContext());
}
/// <summary>
/// Adds the sites, sources, and variables from an ODM database to the DataQueryModel.
/// </summary>
/// <param name="dataQueryModel">The data query model.</param>
/// <param name="db2">The DB2.</param>
/// <param name="odmDb">The odm db.</param>
/// <returns></returns>
//public static DataQueryModel AddSitesSourcesVars(DataQueryModel dataQueryModel, ODMDbDataContext db2, string odmDb)
public static DataQueryModel AddSitesSourcesVars(DataQueryModel dataQueryModel, ODMDbDataContext db2, ODMDatabase odmDb)
{
//RegionIDs;
foreach (var item in db2.Sites)
{
dataQueryModel.Sites.Add(new SiteModel()
{
Site = item, OdmDb = odmDb
});
}
foreach (var item in db2.Sources)
{
dataQueryModel.Sources.Add(new SourceModel()
{
Source = item, OdmDb = odmDb
});
}
var variableList = from vars in db2.Variables
orderby vars.VariableName
select vars;
foreach (var item in variableList)
{
dataQueryModel.Variables.Add(new VariableModel()
{
Variable = item, OdmDb = odmDb
});
}
return(dataQueryModel);
}
