/// <summary>
/// Aggiorna il database, aggiungi/rimuovi elementi in base alle modifiche fatte
/// </summary>
/// <returns></returns>
bool UpdateDatabase()
{
var fetch = Keys.Get(DeviceId);
var grid = ParseGrid();
foreach (var key in grid.Keys)
{
if (fetch.Keys.ToList().Contains(key) == false)
{
string query = "Insert into keys (id, deviceId, name, key) VALUES ( NULL, '" +
DeviceId + "', '" + key + "', '" + grid[key] + "')";
var result = Keys.Insert(query);
if (result == false)
{
return(false);
}
}
}
foreach (var key in fetch.Keys)
{
if (grid.Keys.ToList().Contains(key) == false)
{
var result = Keys.Insert("delete from keys where deviceId = '" + DeviceId + "' AND name = '" + fetch[key] + "'");
if (!result)
{
return(false);
}
}
}
return(true);
}
