aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/Tango.Synchronization/Remote/RemoteDBSynchronizer.cs
blob: 2cd9e2d41118b185bfe319f30cd86738f67b0c1c (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
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;

namespace Tango.Synchronization.Remote
{
    public class RemoteDBSynchronizer
    {
        public static void Synchronize(String sqliteDbFile, String serialNumber)
        {
            using (var remoteDB = new remote.RemoteDB("LOCALHOST\\SQLEXPRESS", 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();
                }
            }
        }

        public static Task SynchronizeAsync(String sqliteDBFile, String serialNumber)
        {
            return Task.Factory.StartNew(() =>
            {
                Synchronize(sqliteDBFile, serialNumber);
            });
        }
    }
}