public static void DropDatabase(string connectionName)
{
using (
var sqlConnection =
new SqlConnection(
ConfigurationManager.ConnectionStrings[connectionName]
.ConnectionString))
{
var serverConnection = new ServerConnection(sqlConnection);
var server = new Microsoft.SqlServer.Management.Smo.Server(
serverConnection);
if (server.Databases[sqlConnection.Database] != null)
{
server.KillDatabase(sqlConnection.Database);
}
}
}
public bool DropDatabase(string connectionName)
{
try
{
using (var sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings[connectionName].ConnectionString))
{
var serverConnection = new ServerConnection(sqlConnection);
var server = new Microsoft.SqlServer.Management.Smo.Server(serverConnection);
server.KillDatabase(sqlConnection.Database);
return(true);
}
}
catch (Exception)
{
return(false);
}
}
private void BtRestauracao_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog d = new OpenFileDialog();
d.Filter = "Backup Files|*.bak";
d.ShowDialog();
if (d.FileName != "")
{
String nomeBanco = DadosDaConexao.banco;
String localBackup = d.FileName;
String conexao = @"Data Source=" + DadosDaConexao.servidor + ";Initial Catalog=master;User="******";Password="******"Backup restaurado com sucesso!!!!!");
}
}
catch (Exception erro)
{
MessageBox.Show(erro.Message);
}
}
private void BtRestauracao_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog d = new OpenFileDialog();
d.Filter = "Backup Files|*.bak";
d.ShowDialog();
if (d.FileName != "")
{
String nomeBanco = DadosDaConexao.banco;
String localBackup = d.FileName;
String conexao = @"Data Source=" + DadosDaConexao.servidor + ";Initial Catalog=master;User="******";Password="******"Backup restaurado com sucesso!!!!!");
}
}
catch (Exception erro)
{
MessageBox.Show(erro.Message);
}
}
protected override void DoWork(object state)
{
var mainCancellationTokenSource = new CancellationToken();
try
{
var tasks = new List <Task>();
var deploymentJobs = _deploymentJobService.Get(p => p.Server.Code == ServerId &&
(p.MarkToRemove ?? false) &&
!(p.IsRemoveDone ?? false)).Take(3).ToList();
if (!deploymentJobs.Any())
{
return;
}
var listJobUpdated = new List <DeploymentJob>();
foreach (var job in deploymentJobs)
{
var localJob = job;
var t = Task.Factory.StartNew(() =>
{
//path
var serviceDest = localJob.Configuration.DestinationWindowServicePath;
var webDest = localJob.Configuration.DestinationWebPath;
var webDestApi = localJob.Configuration.DestinationWebApiPath;
//uninstall servie
if (localJob.JobType == (int)JobType.WindowService && Directory.Exists(serviceDest))
{
try
{
StopService(localJob.Configuration.ServiceName, serviceDest + @"\" + localJob.Configuration.ServiceFileName);
if (Directory.Exists(serviceDest))
{
Directory.Delete(serviceDest, true);
}
}
catch (Exception exception)
{
_diagnosticService.Error(exception);
}
}
//unstall host
if (localJob.JobType == (int)JobType.WebApp)
{
if (!localJob.Configuration.WebDomainName.Contains("http"))
{
localJob.Configuration.WebDomainName = "http://" + localJob.Configuration.WebDomainName + "/";
}
var uri = new Uri(localJob.Configuration.WebDomainName);
_iisHostingHelper.RemoveHost(uri.Host);
if (Directory.Exists(webDest))
{
Directory.Delete(webDest, true);
}
}
if (localJob.JobType == (int)JobType.WebApi)
{
if (!localJob.Configuration.WebApiDomainName.Contains("http"))
{
localJob.Configuration.WebApiDomainName = "http://" + localJob.Configuration.WebApiDomainName + "/";
}
var uri = new Uri(localJob.Configuration.WebApiDomainName);
_iisHostingHelper.RemoveHost(uri.Host);
if (Directory.Exists(webDestApi))
{
Directory.Delete(webDestApi, true);
}
}
//delete database
if (localJob.JobType == (int)JobType.Database)
{
var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MainDb"].ConnectionString);
var server = new Server(new ServerConnection(conn));
var db = server.Databases[localJob.Configuration.DatabaseName];
if (db != null)
{
server.KillAllProcesses(localJob.Configuration.DatabaseName);
server.KillDatabase(localJob.Configuration.DatabaseName);
db.Drop();
}
var login = server.Logins[localJob.Configuration.DatabaseUsername];
if (login != null)
{
login.Drop();
}
}
localJob.IsCopySourceDone = false;
localJob.IsRemoveDone = true;
listJobUpdated.Add(localJob);
}, mainCancellationTokenSource);
tasks.Add(t);
}
Task.WaitAll(tasks.ToArray(), mainCancellationTokenSource);
_deploymentJobService.UpdateListJobs(listJobUpdated);
}
catch (Exception ex)
{
_diagnosticService.Error(ex);
}
}