public JsonResult Restore(string file)
{
try
{
var result = new JsonOperationResponse();
try
{
var backupFile = string.Empty;
if (Settings.BackupPath.StartsWith("~"))
{
backupFile = Server.MapPath(Settings.BackupPath + file);
}
else
{
backupFile = Settings.BackupPath + file;
}
if (System.IO.File.Exists(backupFile))
{
var connectionString = ConfigurationManager.ConnectionStrings["KbVaultEntities"].ConnectionString;
var entityConnectionString = new EntityConnectionStringBuilder(connectionString);
var builder = new System.Data.SqlClient.SqlConnectionStringBuilder(entityConnectionString.ProviderConnectionString);
IVaultBackup backup = new VaultMsSqlBackup();
backup.Connect(entityConnectionString.ProviderConnectionString);
result.Successful = backup.Restore(builder.InitialCatalog, backupFile);
if (result.Successful)
{
result.ErrorMessage = UIResources.BackupRestoreSuccessfull;
}
}
else
{
throw new FileNotFoundException(file);
}
}
catch (Exception ex)
{
Log.Error(ex);
result.ErrorMessage = ex.Message;
}
return(Json(result, JsonRequestBehavior.DenyGet));
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
public JsonResult BackupNow()
{
try
{
var foundSettings = _context.Settings.FirstOrDefault(s => true);
var result = new JsonOperationResponse();
if (string.IsNullOrEmpty(foundSettings.BackupPath))
{
result.Successful = false;
//result.ErrorMessage = Resources.ErrorMessages.BackupPathIsNotSet;
result.ErrorMessage = "BackupPathIsNotSet";
}
else
{
//var connectionString = ConfigurationManager.ConnectionStrings["KbVaultContext"].ConnectionString;
var connectionString = ConfigurationManager.ConnectionStrings["KnowledgeBaseContextBackup"].ConnectionString;
var builder = new System.Data.SqlClient.SqlConnectionStringBuilder(connectionString);
IVaultBackup backup = new VaultMsSqlBackup();
backup.Connect(connectionString);
var backupFile = string.Format("{0:yyyyMddhhmm}.bak", DateTime.Now);
if (!string.IsNullOrEmpty(foundSettings.BackupPath) && foundSettings.BackupPath.StartsWith("~"))
{
//backupFile = Server.MapPath(Settings.BackupPath + backupFile);
var contentroot = _env.ContentRootPath;
backupFile = System.IO.Path.Combine(contentroot, foundSettings.BackupPath + backupFile);
}
else
{
backupFile = foundSettings.BackupPath + backupFile;
}
var backupSuccessful = backup.Backup(builder.InitialCatalog, backupFile);
if (backupSuccessful)
{
if (!string.IsNullOrEmpty(backupFile))
{
result.Data = backupFile;
result.Successful = true;
}
}
}
return(Json(result));
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
public JsonResult BackupNow()
{
try
{
var result = new JsonOperationResponse();
if (string.IsNullOrEmpty(Settings.BackupPath))
{
result.Successful = false;
result.ErrorMessage = ErrorMessages.BackupPathIsNotSet;
}
else
{
var connectionString = ConfigurationManager.ConnectionStrings["KbVaultContext"].ConnectionString;
var builder = new System.Data.SqlClient.SqlConnectionStringBuilder(connectionString);
IVaultBackup backup = new VaultMsSqlBackup();
backup.Connect(connectionString);
var backupFile = string.Format("{0:yyyyMddhhmm}.bak", DateTime.Now);
if (!string.IsNullOrEmpty(Settings.BackupPath) && Settings.BackupPath.StartsWith("~"))
{
backupFile = Server.MapPath(Settings.BackupPath + backupFile);
}
else
{
backupFile = Settings.BackupPath + backupFile;
}
var backupSuccessful = backup.Backup(builder.InitialCatalog, backupFile);
if (backupSuccessful)
{
if (!string.IsNullOrEmpty(backupFile))
{
result.Data = backupFile;
result.Successful = true;
}
}
}
return(Json(result, JsonRequestBehavior.DenyGet));
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
public JsonResult Restore(string file)
{
try
{
var foundSettings = _context.Settings.FirstOrDefault(s => true);
var result = new JsonOperationResponse();
try
{
var backupFile = string.Empty;
if (foundSettings.BackupPath.StartsWith("~"))
{
var webroot = _env.WebRootPath;
backupFile = System.IO.Path.Combine(webroot, foundSettings.BackupPath + file);
//backupFile = Server.MapPath(Settings.BackupPath + file);
}
else
{
backupFile = foundSettings.BackupPath + file;
}
if (System.IO.File.Exists(backupFile))
{
var connectionString = ConfigurationManager.ConnectionStrings["KnowledgeBaseContextBackup"].ConnectionString;
//https://docs.microsoft.com/en-us/dotnet/api/system.data.entity.core.entityclient?view=entity-framework-6.2.0
var entityConnectionString = ConfigurationManager.ConnectionStrings["KnowledgeBaseContextBackup"].ConnectionString;
var builder = new System.Data.SqlClient.SqlConnectionStringBuilder(entityConnectionString);
//var entityConnectionString = new EntityConnectionStringBuilder(connectionString);
//var entityConnectionString = new System.Data.Entity.Core.EntityClient.EntityConnectionStringBuilder(connectionString);
//var builder = new System.Data.SqlClient.SqlConnectionStringBuilder(entityConnectionString.ProviderConnectionString);
//var builder = new System.Data.Common.DbConnectionStringBuilder.SqlConnectionStringBuilder(entityConnectionString.ProviderConnectionString);
//System.Data.Entity.Core.EntityClient.
//System.Data.Common.DbConnectionStringBuilder.
IVaultBackup backup = new VaultMsSqlBackup();
//backup.Connect(entityConnectionString.ProviderConnectionString);
backup.Connect(entityConnectionString);
result.Successful = backup.Restore(builder.InitialCatalog, backupFile);
if (result.Successful)
{
result.ErrorMessage = "BackupRestoreSuccessfull"; // Resources.UIResources.BackupRestoreSuccessfull;
}
}
else
{
throw new FileNotFoundException(file);
}
}
catch (Exception ex)
{
Log.Error(ex);
result.ErrorMessage = ex.Message;
}
return(Json(result));
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
