public void Update_Sync_Device(SyncDevice objSync) { using (SQLiteConnection db = new SQLiteConnection(App.DB_PATH)) { var exist = db.Query <SyncDevice>("select * from Sync_Device where SongID =" + objSync.SongID + " and DeviceId = " + objSync.DeviceID).FirstOrDefault(); if (exist != null) { db.RunInTransaction(() => { db.Update(objSync); }); } } }
public void Insert_Sync_Device(SyncDevice objSync) { using (SQLiteConnection db = new SQLiteConnection(App.DB_PATH)) { var song_format = db.Find <Song>(c => c.SongID == objSync.SongID); var exist_format = db.Find <DeviceFormat>(c => c.DeviceID == objSync.DeviceID && c.MusicFormatID == song_format.FormatId); if (exist_format == null) { objSync.FormatToFormat = true; } // Изначально всегда синхронизировать objSync.Synchronization = true; db.RunInTransaction(() => { db.Insert(objSync); }); } }