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; }