private void btnGeraBKPCliente_Click(object sender, EventArgs e)
{
ParamsFile parametros = CarregaParametrosJSON();
// Atribuições...
parametros.GUID = txtGUIDCliente.Text;
parametros.DateTimeExecution = DateTime.Now.ToString("dd-MM-yy-HH.mm");
// Monta os argumentos
//parametros.TargetBacpacPath = @"educonnectDevdb-16-10-2017-09.08-TOTVSDEVBATISTA.bacpac";
//parametros.SqlDBName = string.Concat(parametros.SqlDBName, txtGUIDCliente.Text);
//string sqlPackageImportArgs = $@"/Action:{importAction} /tsn:tcp:{sqlServerName} /tdn:{_lastTargetBACPACPath} /tu:{sqlDBUser} /tp:{sqlDBPass} /sf:{_lastTargetBACPACPath} /p:DatabaseEdition=Premium /p:DatabaseServiceObjective=P4 /p:Storage=File";
string source = $"\"Data Source= {parametros.SqlServerName};Initial Catalog= {parametros.SqlDBName};User Id={parametros.SqlDBUser};Password={parametros.SqlDBPassword}\"";
string sqlPackageImportArgs = $@"/Action:{Constants.IMPORT_ACTION} /tcs:{source} /sf:{parametros.TargetBacpacPath}";
RunWithRedirect(parametros.SqlPackageEXELocation, sqlPackageImportArgs);
/*
* "\\10.31.0.212\C$\Program Files (x86)\Microsoft SQL Server\120\DAC\bin\SqlPackage.exe" /Action:Import /tcs:"Data Source=10.31.0.212;Initial Catalog=educonnectDevdb;User Id=rm;Password=rm" /sf:"educonnectDevdb-16-10-17-13.22.bacpac"
*
*/
// Executa os scripts na base restaurada...
string sqlDELETEPath = @"C:\users\breno.batista\script.sql";
RunWithRedirect("sqlcmd", $@"-S . -d teste -i {sqlDELETEPath}");
}
public void CreateContentDirectoryWork()
{
FileConfiguration fileConfiguration = new FileConfiguration();
fileConfiguration.configuration = files_configuration;
ParamsFile paramsFile = new ParamsFile();
paramsFile.directory_train = directory_train;
paramsFile.directory_work = directory_work;
paramsFile.file_database = file_database;
paramsFile.file_face = file_face;
paramsFile.file_video = file_video;
paramsFile.file_identify = file_identify;
fileConfiguration.Params = paramsFile;
try
{
string jsonOut = JsonConvert.SerializeObject(fileConfiguration);
string pathFile = directoryConfiguration + "/" + directory;
disk.WriteFile(pathFile, jsonOut);
}
catch (System.IO.IOException e)
{
Console.WriteLine(e.Message);
}
}
private void btnCarregar_Click(object sender, EventArgs e)
{
if (!File.Exists("donotdelete.json"))
{
File.Create("donotdelete.json");
MessageBox.Show("Não existem arquivos de configuração. Favor salvar uma configuração para criá-lo.");
}
ParamsFile file = JsonConvert.DeserializeObject <ParamsFile>(File.ReadAllText(@"donotdelete.json"));
}
private void btnSalvar_Click(object sender, EventArgs e)
{
var file = new ParamsFile()
{
//string _sqlPackageEXE = @"\\10.31.0.212\C$\Program Files (x86)\Microsoft SQL Server\120\DAC\bin\SqlPackage.exe";
SqlPackageEXELocation = @"C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\sqlpackage.exe",
// File args
TargetBacpacPath = @"C:\BatchsAzureBackup\",
// Client args
GUID = "TOTVSDEVBATISTA",
// Azure Database args
AzureServerName = @"tcp:educonnectdevdbserver.database.windows.net,1433",
AzureDBName = @"educonnectDevdb",
AzureDBUser = @"totvs",
AzureDBPassword = @"",
// Client Database args
SqlServerName = @"10.31.0.212",
SqlDBName = @"educonnectDevdb",
SqlDBUser = @"totvs",
SqlDBPassword = @"",
// Folder args
SqlClientBackup = @"C:\Temp\Azure\ClientBKP",
SqlFTPClientBackup = @"C:\Temp\Azure\FTP",
// SQLPackage args
ExportAction = @"Export",
ImportAction = @"Import",
DBFilename = "educonnectDevdbBKP",
DateTimeExecution = DateTime.Now.ToString("dd-MM-yy-HH.mm")
};
File.WriteAllText(@"donotdelete.json", JsonConvert.SerializeObject(file));
using (StreamWriter sw = File.CreateText(@"donotdelete.json"))
{
JsonSerializer serializer = new JsonSerializer();
serializer.Serialize(sw, file);
}
}
public bool InsertData_FileExcel(ParamsFileDTO _paramsFileDTO, ref string msgErr)
{
try
{
ParamsFile pf = new ParamsFile()
{
ID = Guid.NewGuid(),
PathFileExcel = _paramsFileDTO.PathFileExcel,
PasswordFileExcel = Crypteur.CrypterText(_paramsFileDTO.PasswordFileExcel),
DateUpdatedFile = _paramsFileDTO.DateUpdatedFile,
DateUpdatedPassword = _paramsFileDTO.DateUpdatedPassword,
AccountUpdatedPath = _paramsFileDTO.AccountUpdatedPath,
AccountUpdatetedPwd = _paramsFileDTO.AccountUpdatetedPwd
};
new DAL <ParamsFile>().InserRow(pf);
return(true);
}
catch (Exception ex)
{
msgErr = ex.Message;
return(false);
}
}
public Main()
{
InitializeComponent();
_parametros = CarregaParametrosJSON();
}
