Implemented SQL Server To SQLite Conversion Utility!!!

Added missing synchronization tables to remote synchronization.

Updated DAL.Local.

1 files changed, 32 insertions, 0 deletions

diff --git a/Software/Visual_Studio/Tango.Synchronization/Remote/RemoteDBComparer.cs b/Software/Visual_Studio/Tango.Synchronization/Remote/RemoteDBComparer.cs
index af10f9637..59ac980ba 100644
--- a/Software/Visual_Studio/Tango.Synchronization/Remote/RemoteDBComparer.cs
+++ b/Software/Visual_Studio/Tango.Synchronization/Remote/RemoteDBComparer.cs
@@ -68,6 +68,14 @@ namespace Tango.Synchronization.Remote
             var local_users = _localDB.USERS.ToList();
             LogManager.Log("Querying all local users roles...");
             var local_users_roles = _localDB.USERS_ROLES.ToList();
+            LogManager.Log("Querying all local jobs...");
+            var local_jobs = _localDB.JOBS.ToList();
+            LogManager.Log("Querying all local job runs...");
+            var local_job_runs = _localDB.JOB_RUNS.ToList();
+            LogManager.Log("Querying all local segments...");
+            var local_segments = _localDB.SEGMENTS.ToList();
+            LogManager.Log("Querying all local brush stops...");
+            var local_brush_stops = _localDB.BRUSH_STOPS.ToList();
             //LogManager.Log("Querying all CATS...");
             //var local_cats = _localDB.CATS.ToList();
 
@@ -125,6 +133,18 @@ namespace Tango.Synchronization.Remote
             guids = remote_ids_packs.Select(x => x.CARTRIDGE_TYPE_GUID).ToList();
             var remote_cartridges_types = _remoteDB.CARTRIDGE_TYPES.Where(x => guids.Contains(x.GUID)).ToList();
 
+            LogManager.Log("Querying all remote jobs...");
+            var remote_jobs = remote_machines.SelectMany(x => x.JOBS).ToList();
+
+            LogManager.Log("Querying all remote job runs...");
+            var remote_jobs_runs = remote_jobs.SelectMany(x => x.JOB_RUNS).ToList();
+
+            LogManager.Log("Querying all remote segments...");
+            var remote_segments = remote_jobs.SelectMany(x => x.SEGMENTS).ToList();
+
+            LogManager.Log("Querying all remote brush stops...");
+            var remote_brush_stops = remote_segments.SelectMany(x => x.BRUSH_STOPS).ToList();
+
             //LogManager.Log("Querying all remote CATS...");
             //guids = remote_machines.Select(x => x.GUID).ToList();
             //var remote_cats = _remoteDB.CATS.Where(x => guids.Contains(x.MACHINE_GUID)).ToList();
@@ -166,6 +186,18 @@ namespace Tango.Synchronization.Remote
             LogManager.Log("Comparing users roles");
             CompareCollections(remote_users_roles, local_users_roles, _remoteDB.USERS_ROLES, _localDB.USERS_ROLES);
 
+            LogManager.Log("Comparing jobs");
+            CompareCollections(remote_jobs, local_jobs, _remoteDB.JOBS, _localDB.JOBS);
+
+            LogManager.Log("Comparing job runs");
+            CompareCollections(remote_jobs_runs, local_job_runs, _remoteDB.JOB_RUNS, _localDB.JOB_RUNS);
+
+            LogManager.Log("Comparing segments");
+            CompareCollections(remote_segments, local_segments, _remoteDB.SEGMENTS, _localDB.SEGMENTS);
+
+            LogManager.Log("Comparing brush stops");
+            CompareCollections(remote_brush_stops, local_brush_stops, _remoteDB.BRUSH_STOPS, _localDB.BRUSH_STOPS);
+
             //LogManager.Log("Comparing cats");
             //CompareCollections(remote_cats, local_cats, _remoteDB.CATS, _localDB.CATS);