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());
}
}
public void UpdateDB(string arg)
{
var dr = SmallDBService.FindDataRow(DBConstant.MAC_ADDRESS, device.MACAddress);
if (dr != null)
{
SmallDBService.EditRowCell(dr, DBConstant.STATUS_ARG, arg);
}
}
private void SaveInfo()
{
try
{
SmallDBService.SaveDB();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public List <IoTDevice> Get()
{
var list = new List <IoTDevice>();
SmallDBService.LoadDB();
foreach (DataRow dr in SmallDBService.DBTable.Rows)
{
list.Add(new IoTDevice(dr));
}
return(list);
}
private void CreateDBSchemas()
{
SmallDBService.AddColumn(DBConstant.DEVICE_NAME, string.Empty);
SmallDBService.AddColumn(DBConstant.BLUETOOTH_NAME, string.Empty);
SmallDBService.AddColumn(DBConstant.BLUEZ_PATH, string.Empty);
SmallDBService.AddColumn(DBConstant.MAC_ADDRESS, string.Empty);
SmallDBService.AddColumn(DBConstant.SENSOR_TYPE, 0);
SmallDBService.AddColumn(DBConstant.DEVICE_STATUS, 0);
SmallDBService.AddColumn(DBConstant.STATUS_ARG, string.Empty);
SmallDBService.AddColumn(DBConstant.BT_SERVICE_UUID, string.Empty);
SmallDBService.AddColumn(DBConstant.BT_GATT_RX_UUID, string.Empty);
SmallDBService.AddColumn(DBConstant.BT_GATT_TX_UUID, string.Empty);
}
private void CheckDB()
{
if (!File.Exists(SmallDBService.DeviceDBFile))
{
SmallDBService.CreateDB();
CreateDBSchemas();
SmallDBService.SaveDB();
}
else
{
SmallDBService.LoadDB();
}
}
public void LoadPairedDevices()
{
try
{
SmallDBService.LoadDB();
foreach (DataRow dr in SmallDBService.DBTable.Rows)
{
AppEnvironment.deviceManager.PairedList.Add(new IoTDevice(dr));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public string Get(string mac)
{
// if (!mac.Equals("00:00:00:00:00:00"))
// {
// return "-1;-1";
// }
// return CreateRandomArg();
SmallDBService.LoadDB();
var device = from DataRow dr in SmallDBService.DBTable.Rows
where (dr[DBConstant.MAC_ADDRESS] as string).Equals(mac)
select new IoTDevice(dr);
return(device.FirstOrDefault().StatusArgument);
}
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);
}
