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