public Resultado Backup(tbBackup pBackup)
{
SqlConnection conn;
try
{
using (dbWebEventoEntities dbContext = new dbWebEventoEntities())
{
string stConnectionString = string.Format(@"Data Source={0};Initial Catalog={1};Trusted_Connection=False;User Id=teste;Password=1234", pBackup.tbBackup_Servidor, pBackup.tbBackup_Database);
conn = new SqlConnection(stConnectionString);
var nomeArquivo = string.Format("{0}_{1}.{2}", "DbWebEvento_", DateTime.Now.ToString("ddMMyyyy"), ".bak");
var query = string.Format("Backup database {0} to disk={1}\\{2}", pBackup.tbBackup_Database, pBackup.tbBackup_Diretorio, nomeArquivo);
conn.Open();
var cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();
conn.Close();
resultado = new Resultado()
{
PageName = "Backup",
ClassName = "BackupProcess",
MethodName = "Backup",
ExceptionMsg = "Arquivo de backup criado com sucesso",
ResultAction = true,
DateAction = DateTime.Now,
IdUserAction = 1
};
}
}
catch (Exception ex)
{
resultado = new Resultado()
{
PageName = "Backup",
ClassName = "BackupProcess",
MethodName = "Backup",
ExceptionMsg = ex.Message,
ResultAction = false,
DateAction = DateTime.Now,
IdUserAction = 1
};
}
return(resultado);
}
public ActionResult Backup(tbBackup backup)
{
try
{
if (userId > 0 && blUserAuth == true)
{
resultado = new ArquivoFacade().Backup(backup);
ViewBag.Msgtype = resultado.ResultAction == true ? 10 : 0;
}
else if (userId > 0 && blUserAuth == false)
{
return(RedirectToAction("Denied", "Account"));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex.InnerException);
}
return(View());
}
public Resultado Backup(tbBackup pBackup)
{
return(new ArquivoProcess().Backup(pBackup));
}
