From 35e94c2e94c32ff1731acb8d02b20e4accc3ca4a Mon Sep 17 00:00:00 2001
From: Michael <Michael@some.where>
Date: Sat, 25 Mar 2017 19:39:42 -0400
Subject: Database backup creation :smiley:

---
 Project-Unite/Controllers/AdminController.cs | 59 ++++++++++++++++++++++++++++
 1 file changed, 59 insertions(+)

(limited to 'Project-Unite/Controllers/AdminController.cs')

diff --git a/Project-Unite/Controllers/AdminController.cs b/Project-Unite/Controllers/AdminController.cs
index a865ba7..a487dd3 100644
--- a/Project-Unite/Controllers/AdminController.cs
+++ b/Project-Unite/Controllers/AdminController.cs
@@ -110,6 +110,65 @@ Unlike previous ShiftOS site revamps, your account got migrated over. However, t
             return RedirectToAction("Users");
         }
 
+        public ActionResult BackupDatabase()
+        {
+            var db = new ApplicationDbContext();
+            string backupDir = "~/Backups/Database";
+            string backupServerDir = Server.MapPath(backupDir);
+            if (!System.IO.Directory.Exists(backupServerDir))
+                System.IO.Directory.CreateDirectory(backupServerDir);
+
+            string backupUrl = backupDir.Remove(0, 1) + "/ShiftOS-" + DateTime.Now.ToString() + ".zip";
+            string backupname = backupServerDir + "\\ShiftOS-" + DateTime.Now.ToString() + ".zip";
+
+            System.IO.Compression.ZipFile.CreateFromDirectory(Server.MapPath("~/Uploads", backupname));
+
+            var backupData = new DatabaseBackup();
+            backupData.Id = Guid.NewGuid().ToString();
+            backupData.UserId = User.Identity.GetUserId();
+            backupData.DownloadUrl = backupUrl;
+            backupData.Timestamp = DateTime.Now;
+            db.AssetBackups.Add(backupData);
+            db.SaveChanges();
+            return RedirectToAction("Backups");
+        }
+
+        public ActionResult BackupAssets()
+        {
+            var db = new ApplicationDbContext();
+            string backupDir = "~/Backups/Assets";
+            string backupServerDir = Server.MapPath(backupDir);
+            if (!System.IO.Directory.Exists(backupServerDir))
+                System.IO.Directory.CreateDirectory(backupServerDir);
+
+            string backupUrl = backupDir.Remove(0, 1) + "/ShiftOS-" + DateTime.Now.ToString() + ".sql";
+            string backupname = backupServerDir + "\\ShiftOS-" + DateTime.Now.ToString() + ".sql";
+            const string sqlCommand = @"BACKUP DATABASE [{0}] TO  DISK = N'{1}' WITH NOFORMAT, NOINIT,  NAME = N'ShiftOS Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10";
+            int path = db.Database.ExecuteSqlCommand(System.Data.Entity.TransactionalBehavior.DoNotEnsureTransaction, string.Format(sqlCommand, db.Database.Connection.Database, backupname));
+            var backupData = new DatabaseBackup();
+            backupData.Id = Guid.NewGuid().ToString();
+            backupData.UserId = User.Identity.GetUserId();
+            backupData.DownloadUrl = backupUrl;
+            backupData.Timestamp = DateTime.Now;
+            db.Backups.Add(backupData);
+            db.SaveChanges();
+            return RedirectToAction("Backups");
+        }
+
+
+
+
+        public ActionResult Backups()
+        {
+            ViewBag.Admin = true;
+            var backups = new BackupViewModel();
+            var db = new ApplicationDbContext();
+            backups.Databases = db.Backups.OrderByDescending(x => x.Timestamp);
+            backups.AssetFolders = db.AssetBackups.OrderByDescending(x => x.Timestamp);
+
+            return View(backups);
+        }
+
         public void DeleteTopic(ForumTopic topic)
         {
             foreach(var post in topic.Posts.ToArray())
-- 
cgit v1.2.3