//Update existing conatct
public void UpdateAccelData(AccelData accelData)
{
using (var dbConn = new SQLiteConnection(App.DB_PATH))
{
var existing = dbConn.Query<AccelData>("select * from AccelData where Id =" + accelData.Id).FirstOrDefault();
if (existing != null)
{
existing.X = accelData.X;
existing.Y = accelData.Y;
existing.Z = accelData.Z;
dbConn.RunInTransaction(() =>
{
dbConn.Update(existing);
});
}
}
}
// Insert the new contact in the Contacts table.
public void Insert(AccelData newAccelData)
{
using (var dbConn = new SQLiteConnection(App.DB_PATH))
{
dbConn.RunInTransaction(() =>
{
dbConn.Insert(newAccelData);
});
}
}