예제 #1
0
        //--- QUERIES INTO DATABASE ---
        // These are not finished - there are a -lot- of queries that need to be made. For the sake of not losing my mind,
        // I decided to end here with just these few - I need to be able to test it, first.
        //Query to add a sensor reading record
        public void InsertSensorRecord(WATRSensorRecord record)
        {
            string query = "INSERT INTO SensorReadings_T VALUES (" +  record.XBeeSerialNumber.ToString() + ", '" + record.TimeStamp.ToString() +
                "'," + record.HumidityLevel.ToString() + "," + record.TemperatureLevel.ToString() + "," + record.MoistureLevel + "," + record.BatteryLevel.ToString() + ");";

            executeRawSQL(query);
        }
예제 #2
0
 public void PlaceCurrentRecord(WATRSensorRecord record)
 {
     this.currentHumidityLvl = record.HumidityLevel;
     this.currentBatteryLvl = record.BatteryLevel;
     this.currentTemperature = record.TemperatureLevel;
     this.currentMoistureLvl = record.MoistureLevel;
     this.dateTimeInfoSSLabel.Text = record.TimeStamp.ToString("MM/dd/yy hh:mm");
     updateUI();
 }