aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/Tango.Synchronization/Remote/RemoteDBSynchronizer.cs
blob: 7abd8ad7e7009114543004de0c62ab86a36034fe (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using remote = Tango.DAL.Remote.DB;
using local = Tango.DAL.Local.DB;
using Tango.Settings;
using Tango.Synchronization.Local;

namespace Tango.Synchronization.Remote
{
    public class RemoteDBSynchronizer
    {
        public static List<Diff> Synchronize(String sqliteDbFile, String serialNumber, bool overrideLocal = false)
        {
            if (overrideLocal)
            {
                SQLiteDataBase sqlite = new SQLiteDataBase(sqliteDbFile);
                sqlite.LoadTables();
                sqlite.ClearDataBase();
            }

            using (var remoteDB = new remote.RemoteDB(SettingsManager.Default.DataBase.SQLServerAddress, false))
            {
                using (var localDB = new local.LocalDB(sqliteDbFile))
                {
                    RemoteDBComparer comparer = new RemoteDBComparer(remoteDB, localDB, serialNumber);
                    var diffs = comparer.Compare();

                    foreach (var diff in diffs)
                    {
                        diff.Commit();
                    }

                    remoteDB.SaveChanges();
                    localDB.SaveChanges();

                    return diffs;
                }
            }
        }

        public static Task<List<Diff>> SynchronizeAsync(String sqliteDBFile, String serialNumber, bool overrideLocal = false)
        {
            return Task.Factory.StartNew<List<Diff>>(() =>
            {
                return Synchronize(sqliteDBFile, serialNumber, overrideLocal);
            });
        }
    }
}