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()); }