Implemented PPC rollback procedures.

2 files changed, 29 insertions, 0 deletions

diff --git a/Software/Visual_Studio/Tango.Core/DB/DbManager.cs b/Software/Visual_Studio/Tango.Core/DB/DbManager.cs
index 10a4e26db..1d415fdb1 100644
--- a/Software/Visual_Studio/Tango.Core/DB/DbManager.cs
+++ b/Software/Visual_Studio/Tango.Core/DB/DbManager.cs
@@ -142,6 +142,24 @@ namespace Tango.Core.DB
             File.Delete(backupPath);
         }
 
+        public void Backup(String name, String file)
+        {
+            String command = $"BACKUP DATABASE {name} TO DISK = '{file}'";
+            SqlCommand cmd = new SqlCommand(command, _connection);
+            cmd.ExecuteNonQuery();
+        }
+
+        public void Restore(String name, String file)
+        {
+            SetOffline(name);
+
+            String command = $"RESTORE DATABASE {name} FROM DISK = '{file}'";
+            SqlCommand cmd = new SqlCommand(command, _connection);
+            cmd.ExecuteNonQuery();
+
+            SetOnline(name);
+        }
+
         public void ClearDb()
         {
             if (!_connection.ConnectionString.ToLower().Contains("initial catalog"))
diff --git a/Software/Visual_Studio/Tango.Core/IO/TemporaryManager.cs b/Software/Visual_Studio/Tango.Core/IO/TemporaryManager.cs
index 3a02325e6..25ace7dc1 100644
--- a/Software/Visual_Studio/Tango.Core/IO/TemporaryManager.cs
+++ b/Software/Visual_Studio/Tango.Core/IO/TemporaryManager.cs
@@ -124,6 +124,17 @@ namespace Tango.Core.IO
         }
 
         /// <summary>
+        /// Creates a new temporary file but does not create it.
+        /// </summary>
+        /// <returns></returns>
+        public virtual TemporaryFile CreateImaginaryFile(String extension = null)
+        {
+            TemporaryFile file = new TemporaryFile(Path.Combine(RootPath, Path.GetRandomFileName() + extension), false);
+            AddItem(file);
+            return file;
+        }
+
+        /// <summary>
         /// Deletes all items.
         /// </summary>
         public virtual void Clean()