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