public void AddDeviceToDB(IoTDevice device)
{
try
{
var dic = new Dictionary <string, object>();
dic.Add(DBConstant.DEVICE_NAME, device.DeviceName);
dic.Add(DBConstant.BLUETOOTH_NAME, device.BTName);
dic.Add(DBConstant.BLUEZ_PATH, device.Path);
dic.Add(DBConstant.MAC_ADDRESS, device.MACAddress);
dic.Add(DBConstant.SENSOR_TYPE, (int)device.SensorType);
dic.Add(DBConstant.STATUS_ARG, string.Empty);
dic.Add(DBConstant.DEVICE_STATUS, (int)device.Status);
dic.Add(DBConstant.BT_SERVICE_UUID, device.ServiceUUID);
dic.Add(DBConstant.BT_GATT_RX_UUID, device.RXUUID);
dic.Add(DBConstant.BT_GATT_TX_UUID, device.TXUUID);
SmallDBService.AddRow(dic);
//SmallDBService.SaveDB();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
private void TestDB()
{
if (!File.Exists(SmallDBService.DeviceDBFile))
{
SmallDBService.CreateDB();
}
SmallDBService.AddColumn("TestString", string.Empty);
SmallDBService.AddColumn("TestBoolean", false);
SmallDBService.AddColumn("TestInt", 0);
var dic = new Dictionary <string, object>();
dic.Add("TestString", "String");
dic.Add("TestBoolean", true);
dic.Add("TestInt", TestType.Type4);
SmallDBService.AddRow(dic);
}