public WATRXBeeDevice(string name, UInt32 serialNumberLow) { this.Name = name; this.SerialNumber = new WATRXbeeSerialNumber(serialNumberLow); sensorForm = new WATRSensorForm(); sensorForm.Text = "WATR Sensor; Device: " + this.SerialNumber.FullSerialNumber.ToString(); }
public WATRSensorRecord(WATRXbeeSerialNumber XBeeSN, DateTime timestamp, int humidityLevel, double temperatureLevel, int moistureLevel, int batteryLevel) { this.XBeeSerialNumber = XBeeSN; this.TimeStamp = timestamp; this.HumidityLevel = humidityLevel; this.TemperatureLevel = temperatureLevel; this.MoistureLevel = moistureLevel; this.BatteryLevel = batteryLevel; }
//Query the table to get a DataTable of a single devices entire record history ordered by date public DataTable RetrieveRecordsFromSingleDevice(WATRXbeeSerialNumber XBeeSN) { string sqlQuery = "SELECT * FROM SensorReadings_T WHERE deviceSN = " + XBeeSN.FullSerialNumber.ToString() + " ORDER BY readingDate;"; return executeRawRetrieveSQL(sqlQuery); }