Пример #1
0
 public getOriginalAgency(string[] siteTypes)
 {
     db = new ClsSummaryDB();
     // pull all users into memory, not recommended for large tables.
     aggregatelist = db.getOriginalList(siteTypes);
     downloadOriginal();
 }
Пример #2
0
        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();
            }
        }
Пример #3
0
        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");
        }
Пример #4
0
        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");
        }
Пример #5
0
 public TimeAggregated()
 {
     db            = new ClsSummaryDB();
     aggregatelist = db.getAggregateList();
     CalculatesAggregates();
 }
Пример #6
0
 public TimeAggregated(string[] siteTypes)
 {
     db            = new ClsSummaryDB();
     aggregatelist = db.getAggregateList(siteTypes);
     CalculatesAggregates();
 }
Пример #7
0
 public getOriginalAgency()
 {
     db            = new ClsSummaryDB();
     aggregatelist = db.getOriginalList();
     downloadOriginal();
 }
Пример #8
0
 public ClsDBAccessor()
 {
     this.summaryDB = new ClsSummaryDB();
     this.fromDB    = new ClsFromDB();
     this.tooDB     = new ClsTooDB();
 }