public getOriginalAgency(string[] siteTypes)
{
db = new ClsSummaryDB();
// pull all users into memory, not recommended for large tables.
aggregatelist = db.getOriginalList(siteTypes);
downloadOriginal();
}
public ClsDBAccessor(L1HarvestList series, ClsSummaryDB summDB)
{
this.summaryDB = summDB;
if (series.DBInitialCatalog != null && series.DBInitialCatalog != string.Empty)
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = series.DBDataSource; // drought.usu.edu
builder.InitialCatalog = series.DBInitialCatalog; // Summary
builder.PersistSecurityInfo = true;
builder.UserID = series.DBUsername;
builder.Password = series.DBPassword;
builder.MultipleActiveResultSets = true;
//// builder.IntegratedSecurity = true;
string providerString = builder.ToString();
EntityConnectionStringBuilder tooConnection = new EntityConnectionStringBuilder();
tooConnection.Metadata = "res://*/SummaryModel.csdl|res://*/SummaryModel.ssdl|res://*/SummaryModel.msl";//"res://*/ODMModel.csdl|res://*/ODMModel.ssdl|res://*/ODMModel.msl";//"res://*/SummaryModel.csdl|res://*/SummaryModel.ssdl|res://*/SummaryModel.msl";
tooConnection.Provider = "System.Data.SqlClient";
tooConnection.ProviderConnectionString = providerString;
this.tooDB = new ClsTooDB(tooConnection.ConnectionString);
}
else
{
this.tooDB = new ClsTooDB();
}
}
public IndexValues()
{
db = new ClsSummaryDB();
DBLogging.WriteLog(Properties.Settings.Default.projectName, "Log", "IndexValues" + "." + (new StackTrace(true)).GetFrame(0).GetMethod().Name + "()", "Level 4 Calculations Has Begun Running");
L4xreflist = db.getL4List();
CalcIndexValues();
DBLogging.WriteLog(Properties.Settings.Default.projectName, "Log", "IndexValues" + "." + (new StackTrace(true)).GetFrame(0).GetMethod().Name + "()", "Level 4 Calculations Has Completed Running");
}
public IndexVariables(string[] siteTypes)
{
db = new ClsSummaryDB();
DBLogging.WriteLog(Properties.Settings.Default.projectName, "Log", "IndexVariables" + "." + (new StackTrace(true)).GetFrame(0).GetMethod().Name + "()", "Level 3 Spatial Aggregation Has Begun Running");
xreflist = db.getL3List(siteTypes);
wxreflist = db.getL3wList(siteTypes);
CalcIndexVariables();
CalcIndexVariablesWatershed();
DBLogging.WriteLog(Properties.Settings.Default.projectName, "Log", "IndexVariables" + "." + (new StackTrace(true)).GetFrame(0).GetMethod().Name + "()", "Level 3 Spatial Aggregation Has Completed Running");
}
public TimeAggregated()
{
db = new ClsSummaryDB();
aggregatelist = db.getAggregateList();
CalculatesAggregates();
}
public TimeAggregated(string[] siteTypes)
{
db = new ClsSummaryDB();
aggregatelist = db.getAggregateList(siteTypes);
CalculatesAggregates();
}
public getOriginalAgency()
{
db = new ClsSummaryDB();
aggregatelist = db.getOriginalList();
downloadOriginal();
}
public ClsDBAccessor()
{
this.summaryDB = new ClsSummaryDB();
this.fromDB = new ClsFromDB();
this.tooDB = new ClsTooDB();
}