/// <summary>
/// Updates Alarm entity in DB.
/// </summary>
/// <param name="entity"></param>
public void UpdateAlarmEntity(AlarmEntities entity)
{
lock(DbLock)
{
using (var db = new SQLiteConnection(DatabaseHelper.GetDBPath()))
{
AlarmEntities existingAlarmEntity = db.Query<AlarmEntities>("select * from AlarmEntities where AlarmLabel =" + entity.AlarmLabel).FirstOrDefault();
if(existingAlarmEntity != null)
{
existingAlarmEntity.AlarmLabel = entity.AlarmLabel;
existingAlarmEntity.AlarmRepeat = entity.AlarmRepeat;
existingAlarmEntity.AlarmSound = entity.AlarmSound;
existingAlarmEntity.AlarmTime = entity.AlarmTime;
existingAlarmEntity.SnoozeTime = entity.SnoozeTime;
existingAlarmEntity.IsWalkUpAlarmEnabled = entity.IsWalkUpAlarmEnabled;
existingAlarmEntity.NoOfSteps = entity.NoOfSteps;
db.RunInTransaction(() =>
{
db.Update(existingAlarmEntity);
});
}
}
}
}
/// <summary>
/// Deletes Alarm entity from DB.
/// </summary>
/// <param name="entity"></param>
public void DeleteAlarmEntity(AlarmEntities entity)
{
lock(DbLock)
{
using (var db = new SQLiteConnection(DatabaseHelper.GetDBPath()))
{
AlarmEntities existingAlarmEntity = db.Query<AlarmEntities>("select * from AlarmEntities where AlarmLabel =" + entity.AlarmLabel).FirstOrDefault();
if(existingAlarmEntity != null)
{
db.RunInTransaction(() =>
{
db.Delete(existingAlarmEntity);
});
}
}
}
}
/// <summary>
/// Inserts new Alarm entity in DB.
/// </summary>
/// <param name="entity"></param>
public void InsertAlarmEntity(AlarmEntities entity)
{
lock(DbLock)
{
using (var db = new SQLiteConnection(DatabaseHelper.GetDBPath()))
{
db.RunInTransaction(() =>
{
db.Insert(entity);
});
}
}
}
