public int biMonthlyAggregate(AggregateSeries series)
{
SqlConnection con = new SqlConnection(this.conn);
SqlCommand cmd = new SqlCommand("BiMonthlyAggregator", con);
cmd.CommandType = CommandType.StoredProcedure;
// Add the parameters.
cmd.CommandTimeout = 90000;
cmd.Parameters.AddWithValue("@origVariableID", series.OriginalVariableID);
cmd.Parameters.AddWithValue("@siteType", series.SiteType);
if (series.DBInitialCatalog != null)
{
cmd.Parameters.AddWithValue("@tooConnectionstring", createConnString(series.DBDataSource, series.DBInitialCatalog, series.DBUsername, series.DBPassword));
cmd.Parameters.AddWithValue("@tooDBName", "[" + series.DBInitialCatalog + "]");
}
else
{
cmd.Parameters.AddWithValue("@tooConnectionstring", this.conn);
cmd.Parameters.AddWithValue("@tooDBName", "[" + this.conn.Substring(this.conn.IndexOf("Catalog=") + 8, this.conn.IndexOf(";User") - this.conn.IndexOf("Catalog=") - 8) + "]");
}
if (series.L1DBInitialCatalog != null)
{
cmd.Parameters.AddWithValue("@fromConnectionstring", createConnString(series.L1DBDataSource, series.L1DBInitialCatalog, series.L1DBUsername, series.L1DBPassword));
cmd.Parameters.AddWithValue("@fromDBName", "[" + series.L1DBInitialCatalog + "]");
}
else
{
cmd.Parameters.AddWithValue("@fromConnectionstring", this.conn);
cmd.Parameters.AddWithValue("@fromDBName", "[" + this.conn.Substring(this.conn.IndexOf("Catalog=") + 8, this.conn.IndexOf(";User") - this.conn.IndexOf("Catalog=") - 8) + "]");
}
// cmd.Parameters.Add("@returnVal");
cmd.Parameters.Add(new SqlParameter("@returnVal", SqlDbType.Int, 6));
//Set the direction for the parameter. This parameter returns the Rows that are returned.
cmd.Parameters["@returnVal"].Direction = ParameterDirection.Output;
// Try to open the database and execute the update.
int added = 0;
try
{
con.Open();
cmd.ExecuteNonQuery();
added = (int)cmd.Parameters["@returnVal"].Value;
return(added);
}
catch (Exception err)
{
throw err;
}
finally
{
con.Close();
}
}
public DataValue GetPreviousDataValue(AggregateSeries variable, int siteID, DateTime start)
{
try
{
return((from DV in this.DataValues where DV.Site.SiteID == siteID && DV.Variable.VariableID == variable.VariableID && DV.Method.MethodID == variable.MethodID && DV.LocalDateTime < start orderby DV.LocalDateTime descending select DV).First());
}
catch (Exception ex)
{
throw new Exception("clsFromDB.GetPreviousDataValue(" + variable + ", " + siteID + ", " + start + ")", ex);
}
}
public ClsDBAccessor(AggregateSeries series, ClsSummaryDB summDB)
{
this.summaryDB = summDB;
if (series.L1DBInitialCatalog != null && series.L1DBInitialCatalog != string.Empty)
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = series.L1DBDataSource; // drought.usu.edu
builder.InitialCatalog = series.L1DBInitialCatalog; // Summary
builder.PersistSecurityInfo = true;
builder.UserID = series.L1DBUsername;
builder.Password = series.L1DBPassword;
builder.MultipleActiveResultSets = true;
//// builder.IntegratedSecurity = true;
string providerString = builder.ToString();
EntityConnectionStringBuilder fromConnection = new EntityConnectionStringBuilder();
fromConnection.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";
fromConnection.Provider = "System.Data.SqlClient";
fromConnection.ProviderConnectionString = providerString;
this.fromDB = new ClsFromDB(fromConnection.ConnectionString);
}
else
{
this.fromDB = new ClsFromDB();
}
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";//
tooConnection.Provider = "System.Data.SqlClient";
tooConnection.ProviderConnectionString = providerString;
this.tooDB = new ClsTooDB(tooConnection.ConnectionString);
}
else
{
this.tooDB = new ClsTooDB();
}
}
