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