public Page1()
{
var date = DateTime.Now;
hour = date.Hour;
hour_s = DateTime.Now.ToString("dddd, MMMM d, yyyy HH:mm:ss tt");
InitializeComponent();
this.DataContext = this;
var Data = DatabaseAnalysis.getDailyData("Temperature", "Node2");
var arr = DatabaseAnalysis.getGraphData(Data);
var myClient = MQTT.CreateConnection();
MQTT.subscribeToSensors(myClient, "N2");
for (int i = 0; i < 24; i += 1)
{
/*
* if (hour - i > 0)
* {
* temp += "\nTime: " + hour_s + " Temperature: " + arr[i];
* }
* else
* {
* temp += "\nTime: " + (24 - i) + " Temperature: " + arr[i];
* }
*/
temp += "\nTime: " + hour_s + " Temperature: " + arr[i];
}
}
DatabaseGeneratorUpdateDatabase(
IList <DatabaseObject> oldConceptApplications,
IList <DatabaseObject> newConceptApplications)
{
// Update mock database (based on difference between old and new concept applications):
var conceptApplicationRepository = new MockConceptApplicationRepository(ConceptApplication.FromDatabaseObjects(oldConceptApplications));
var databaseModel = new DatabaseModel {
DatabaseObjects = newConceptApplications.ToList()
};
var options = new SqlTransactionBatchesOptions {
MaxJoinedScriptCount = 1
};
var sqlExecuter = new MockSqlExecuter();
var sqlTransactionBatches = new SqlTransactionBatches(sqlExecuter, options, new ConsoleLogProvider(), new DelayedLogProvider(new LoggingOptions {
DelayedLogTimout = 0
}, null));
var databaseAnalysis = new DatabaseAnalysis(
conceptApplicationRepository,
new ConsoleLogProvider(),
databaseModel);
IDatabaseGenerator databaseGenerator = new DatabaseGenerator(
sqlTransactionBatches,
conceptApplicationRepository,
new ConsoleLogProvider(),
new DbUpdateOptions {
ShortTransactions = false
},
databaseAnalysis);
databaseGenerator.UpdateDatabaseStructure();
// Report changes in mock database:
TestUtility.Dump(
sqlExecuter.ExecutedScriptsWithTransaction,
script => (script.Item2 ? "tran" : "notran")
+ string.Concat(script.Item1.Select(sql => "\r\n - " + sql.Replace('\r', ' ').Replace('\n', ' '))));
return
(Report : string.Join(", ", sqlExecuter.ExecutedScriptsWithTransaction.SelectMany(script => script.Item1)),
SqlExecuter : sqlExecuter,
RemovedConcepts : conceptApplicationRepository.DeletedLog,
InsertedConcepts : conceptApplicationRepository.InsertedLog.ToList());
}
