Implemented temporary DB user login for machine service machine setup.

Implemented Tango updater!
Implemented support for software update on machine setup.

1 files changed, 26 insertions, 7 deletions

diff --git a/Software/Visual_Studio/Web/Tango.MachineService/Controllers/SynchronizationController.cs b/Software/Visual_Studio/Web/Tango.MachineService/Controllers/SynchronizationController.cs
index c377afb97..46308fa6f 100644
--- a/Software/Visual_Studio/Web/Tango.MachineService/Controllers/SynchronizationController.cs
+++ b/Software/Visual_Studio/Web/Tango.MachineService/Controllers/SynchronizationController.cs
@@ -10,6 +10,7 @@ using System.Threading.Tasks;
 using System.Web.Hosting;
 using System.Web.Http;
 using Tango.BL;
+using Tango.Core.DB;
 using Tango.Core.Helpers;
 using Tango.Core.IO;
 using Tango.PMR.Stubs;
@@ -90,12 +91,30 @@ namespace Tango.MachineService.Controllers
                     var latest_machine_version = db.TangoVersions.Where(x => x.MachineVersionGuid == machine_version.Guid).ToList().OrderByDescending(x => Version.Parse(x.Version)).FirstOrDefault();
 
                     response.Version = latest_machine_version.Version;
-                    response.FilePath = latest_machine_version.FtpFilePath;
 
-                    response.DbAddress = GetRemoteServerAddress();
                     response.FtpAddress = GetFtpAddress();
-                    response.UserName = GetFtpUserName();
-                    response.Password = GetFtpPassword();
+                    response.FtpFilePath = latest_machine_version.FtpFilePath;
+                    response.FtpUserName = GetFtpUserName();
+                    response.FtpPassword = GetFtpPassword();
+
+                    DbCredentials credentials = new DbCredentials();
+
+                    using (DbManager manager = DbManager.FromAddressAndName(GetDbAddress(), "Tango"))
+                    {
+                        credentials = manager.CreateRandomLoginAndUser("Tango");
+
+                        Task.Delay(TimeSpan.FromMinutes(1)).ContinueWith((x) =>
+                        {
+                            using (DbManager m = DbManager.FromAddressAndName(GetDbAddress(), "Tango"))
+                            {
+                                m.DeleteLoginAndUser(credentials.UserName, "Tango");
+                            }
+                        });
+                    }
+
+                    response.DbAddress = GetDbAddress();
+                    response.DbUserName = credentials.UserName;
+                    response.DbPassword = credentials.Password;
                 }
             }
             catch (Exception ex)
@@ -118,9 +137,9 @@ namespace Tango.MachineService.Controllers
             return ConfigurationManager.AppSettings["LocalServerAddress"].ToString();
         }
 
-        private String GetRemoteServerAddress()
+        private String GetDbAddress()
         {
-            return ConfigurationManager.AppSettings["RemoteServerAddress"].ToString();
+            return ConfigurationManager.AppSettings["DbAddress"].ToString();
         }
 
         private String GetFtpAddress()
@@ -136,7 +155,7 @@ namespace Tango.MachineService.Controllers
         private String GetFtpPassword()
         {
             return ConfigurationManager.AppSettings["FtpPassword"].ToString();
-        } 
+        }
 
         #endregion
     }