public void DownloadQuestao(Dominio.Questao questao)
{
Dominio.Configuracao configuracao = new Dominio.Configuracao();
string caminhoEntrada = System.IO.Path.Combine(configuracao.CaminhoSalvarSubmissoes, questao.ArquivoEntrada);
string caminhoSaida = System.IO.Path.Combine(configuracao.CaminhoSalvarSubmissoes, questao.ArquivoSaida);
NpgsqlConnection conexao = new NpgsqlConnection("Server=187.45.196.224;Database=bubblesort9;User ID=bubblesort9;Password=BSboca;");
NpgsqlTransaction transacao = null;
try
{
conexao.Open();
transacao = conexao.BeginTransaction();
LargeObjectManager lbm = new LargeObjectManager(conexao);
LargeObject lo = lbm.Open(questao.IdArquivoEntrada, LargeObjectManager.READ);
FileStream fsout = File.OpenWrite(caminhoEntrada);
byte[] buf = new byte[lo.Size()];
buf = lo.Read(lo.Size());
fsout.Write(buf, 0, (int)lo.Size());
fsout.Flush();
fsout.Close();
lo.Close();
lo = lbm.Open(questao.IdArquivoSaida, LargeObjectManager.READ);
fsout = File.OpenWrite(caminhoSaida);
byte[] buffer = new byte[lo.Size()];
buffer = lo.Read(lo.Size());
fsout.Write(buffer, 0, (int)lo.Size());
fsout.Flush();
fsout.Close();
lo.Close();
transacao.Commit();
}
catch
{
if (transacao != null)
transacao.Rollback();
throw;
}
finally
{
conexao.Close();
}
}
private async void CarregarDadosAsync()
{
Dominio.Configuracao configuracao = await CarregarConfiguracao();
if (configuracao != null)
{
txbServidor.Text = configuracao.Servidor;
txbDatabase.Text = configuracao.Banco;
txbUsuario.Text = configuracao.Usuario;
txbSenha.Text = configuracao.Senha;
ckbGravarLog.Checked = configuracao.RegistrarLog;
}
}
public void DownloadArquivos(Dominio.Submissao submissao)
{
Dominio.Configuracao configuracao = new Dominio.Configuracao();
string caminho=string.Empty;
switch (submissao.Linguagem)
{
case Dominio.Linguagem.C:
caminho = System.IO.Path.Combine(configuracao.CaminhoSalvarSubmissoes, submissao.Id + ".c");
break;
case Dominio.Linguagem.Cmaismais:
caminho = System.IO.Path.Combine(configuracao.CaminhoSalvarSubmissoes, submissao.Id + ".cpp");
break;
}
NpgsqlConnection conexao = new NpgsqlConnection("Server=187.45.196.224;Database=bubblesort9;User ID=bubblesort9;Password=BSboca;");
NpgsqlTransaction transacao = null;
try
{
conexao.Open();
transacao = conexao.BeginTransaction();
LargeObjectManager lbm = new LargeObjectManager(conexao);
LargeObject lo = lbm.Open(submissao.IdData, LargeObjectManager.READWRITE);
FileStream fsout = File.OpenWrite(caminho);
byte[] buf = new byte[lo.Size()];
buf = lo.Read(lo.Size());
fsout.Write(buf, 0, (int)lo.Size());
fsout.Flush();
fsout.Close();
lo.Close();
transacao.Commit();
}
catch
{
if (transacao != null)
transacao.Rollback();
throw;
}
finally
{
conexao.Close();
}
}
private Task <string> SalvarConfiguracao()
{
return(Task.Run(() =>
{
Core.Configurador configurador = new Core.Configurador();
Dominio.Configuracao configuracao = new Dominio.Configuracao()
{
Servidor = txbServidor.Text.ToUpper().Trim(),
Banco = txbDatabase.Text.ToUpper().Trim(),
Usuario = txbUsuario.Text.Trim(),
Senha = txbSenha.Text,
RegistrarLog = ckbGravarLog.Checked
};
return configurador.AlterarConfiguracao(configuracao);
}));
}
private async void CarregarCamposAsync(string schema, string tabela)
{
DataTable colunas;
Configurador configurador = new Configurador();
Dominio.Configuracao configuracao = configurador.RetornarConfiguracao();
Conexao conexao = new Conexao(configuracao);
string query = string.Format(@" SELECT C.COLUMN_NAME AS COLUNA
FROM INFORMATION_SCHEMA.TABLES T WITH(NOLOCK)
INNER JOIN INFORMATION_SCHEMA.COLUMNS C WITH(NOLOCK) ON T.TABLE_CATALOG = C.TABLE_CATALOG AND
T.TABLE_NAME = C.TABLE_NAME
WHERE T.TABLE_SCHEMA = '{1}' AND C.TABLE_NAME = '{0}'", tabela, schema);
colunas = await conexao.RetornarDadosAsync(query);
dgvColunas.DataSource = colunas;
}
