Implemented fast database update detection of RMLL, Hardware Versions & Color Catalogs.

Related Work Items: #1622

1 files changed, 28 insertions, 0 deletions

diff --git a/Software/Visual_Studio/Web/Tango.MachineService/Controllers/PPCController.cs b/Software/Visual_Studio/Web/Tango.MachineService/Controllers/PPCController.cs
index f0239978f..2dee09e69 100644
--- a/Software/Visual_Studio/Web/Tango.MachineService/Controllers/PPCController.cs
+++ b/Software/Visual_Studio/Web/Tango.MachineService/Controllers/PPCController.cs
@@ -314,6 +314,34 @@ namespace Tango.MachineService.Controllers
 
                     response.Version = latest_machine_version.Version;
 
+                    //Compare database
+
+                    var rmls = db.Rmls.Select(x => new { x.Guid, x.LastUpdated }).ToList();
+                    var hardwareVersions = db.HardwareVersions.Select(x => new { x.Guid, x.LastUpdated }).ToList();
+                    var catalogs = db.ColorCatalogs.Select(x => new { x.Guid, x.LastUpdated }).ToList();
+
+                    bool hasDatabaseUpdates = false;
+
+                    hasDatabaseUpdates = rmls.Exists(x => request.Rmls.Exists(y => x.Guid == y.Guid && x.LastUpdated > y.LastUpdated) || !request.Rmls.Exists(y => x.Guid == y.Guid));
+
+                    if (!hasDatabaseUpdates)
+                    {
+                        hasDatabaseUpdates = hardwareVersions.Exists(x => request.HardwareVersions.Exists(y => x.Guid == y.Guid && x.LastUpdated > y.LastUpdated) || !request.HardwareVersions.Exists(y => x.Guid == y.Guid));
+                    }
+
+                    if (!hasDatabaseUpdates)
+                    {
+                        hasDatabaseUpdates = catalogs.Exists(x => request.Catalogs.Exists(y => x.Guid == y.Guid && x.LastUpdated > y.LastUpdated) || !request.Catalogs.Exists(y => x.Guid == y.Guid));
+                    }
+
+                    if (hasDatabaseUpdates)
+                    {
+                        response.IsDatabaseUpdateAvailable = true;
+                        response.UpdateDBResponse = UpdateDB(new UpdateDBRequest() { SerialNumber = request.SerialNumber });
+                    }
+
+                    //Compare database
+
                     if (machine.ForceVersionUpdate)
                     {
                         response.IsUpdateAvailable = true;