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