private void ActionConsulta() { if (StaticParametros.GetLockVariavel() == false) { if (StaticParametros.GetIntegraBanco() == true) { foreach (var p in StaticParametersDB.getAllListBanco()) { StaticParametersDB.Setcurrent(p.Id); ConsultaDB(); } } if (StaticParametros.GetDirOrigem() != null && StaticParametros.GetDirOrigem() != "") { ConsultaArquivos(1); } System.Windows.Forms.MessageBox.Show("Processo de consulta concluido!", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { System.Windows.Forms.MessageBox.Show("Por favor, aguarde alguns instantes e tente novamente", "", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void init2() { BtnDelete.Visibility = Visibility.Hidden; CboDriver.Items.Insert(0, "Oracle"); CboDriver.Items.Insert(1, "SQLServer"); CboDriver.SelectedIndex = -1; CboConexao.Items.Insert(0, "Nova conexão"); CboConexao.SelectedIndex = 0; try { var process = new Processos(); paramDB = null; paramDB = StaticParametersDB.getAllListBanco(); if (paramDB.Count > 0) { for (int i = 0; i < paramDB.Count; i++) { CboConexao.Items.Insert(i + 1, paramDB[i].Descr); } } else { throw new Exception(); } } catch (Exception e) { } }
public static bool TesteConexao(string host, string port, string servicename, string user, string password, string driver, string trusted_conn = "True") { var retorno = true; using (var conn = GetConnectionWithParam(host, port, servicename, user, password, driver, trusted_conn)) { try { conn.Open(); } catch (Exception e) { //MessageBox.Show(e.Message); MessageBox.Show(e.Message, "", MessageBoxButton.OK, MessageBoxImage.Warning); Processos p = new Processos(); p.InsereLogInterno(StaticParametersDB.GetDriver(), e, "99", "Teste Conexão", ""); retorno = false; } finally { conn.Close(); } } return(retorno); }
public IList <ProtocoloDB> BuscarPorIDEvento(string Id) { ICriterion criterio1 = Restrictions.Eq("idDB", StaticParametersDB.GetId()); ICriterion criterio2 = Restrictions.Eq("id", Id); ICriterion criterio3 = Restrictions.And(criterio1, criterio2); return(sessao.CreateCriteria <ProtocoloDB>().Add(criterio3).List <ProtocoloDB>()); //return sessao.Load<ProtocoloDB>(id); }
public IList <ProtocoloDB> BuscaParaAtualizarBanco() { ICriterion criterio1 = Restrictions.And(Restrictions.Eq("consultado", true), Restrictions.Eq("salvoDB", false)); ICriterion criterio2 = Restrictions.Eq("idDB", StaticParametersDB.GetId()); criterios.Add(Restrictions.And(criterio1, criterio2)); return(criterios.List <ProtocoloDB>()); }
private static dynamic GetAdapter(dynamic comm) { if (StaticParametersDB.GetDriver() == "oracle") { return(new OracleDataAdapter(comm)); } else { return(new SqlDataAdapter(comm)); } }
private static dynamic GetCommand() { if (StaticParametersDB.GetDriver() == "oracle") { return(new OracleCommand()); } else { return(new SqlCommand()); } }
public IList <ProtocoloDB> BuscaConsulta() { ICriterion criterio1 = Restrictions.And( Restrictions.Or(Restrictions.IsNull("nroRec"), Restrictions.Eq("nroRec", "")), Restrictions.Or(Restrictions.IsNull("erros"), Restrictions.Eq("erros", ""))); ICriterion criterio2 = Restrictions.IsNotNull("nroProt"); ICriterion criterio3 = Restrictions.And(criterio1, criterio2); ICriterion criterio4 = Restrictions.Eq("idDB", StaticParametersDB.GetId()); criterios.Add(Restrictions.And(criterio3, criterio4)); return(criterios.List <ProtocoloDB>()); }
private void ActionConsulta() { if (StaticParametros.GetIntegraBanco() == true) { foreach (var p in StaticParametersDB.getAllListBanco()) { StaticParametersDB.Setcurrent(p.Id); ConsultaDB(); } //ConsultaDB(); } if (StaticParametros.GetDirOrigem() != null && StaticParametros.GetDirOrigem() != "") { Consulta(1); } Log("Consulta finalizada: ", 1); }
private void ActionIntegra() { if (StaticParametros.GetIntegraBanco() == true) { foreach (var p in StaticParametersDB.getAllListBanco()) { StaticParametersDB.Setcurrent(p.Id); IntegraDB(); } //IntegraDB(); } if (StaticParametros.GetDirOrigem() != null && StaticParametros.GetDirOrigem() != "") { Integra(1); } Log("Integração finalizado: ", 1); }
private void BtnDelete_Click(object sender, RoutedEventArgs e) { MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Deseja prosseguir?", "Confirmação de exclusão", System.Windows.MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.Yes) { var sessao = AuxiliarNhibernate.AbrirSessao(); var paramdb = new ParametroDB_DAO(sessao); try { paramdb.Remover(paramDB[lastIndex - 1]); paramDB.RemoveAt(lastIndex - 1); if (paramDB.Count >= 1) { StaticParametersDB.clearListBanco(); foreach (var p in paramDB) { StaticParametersDB.SetListBanco(p); } StaticParametersDB.Setcurrent(paramDB[0].Id); refreshCBO(paramDB[0], 1); } else { StaticParametersDB.clearListBanco(); StaticParametersDB.clearAllStatic(); StaticParametros.SetIntegraBanco(false); BtnDelete.Visibility = Visibility.Hidden; CboConexao.Items.Clear(); CboConexao.Items.Insert(0, "Nova conexão"); CboConexao.SelectedIndex = 0; } cleanScreen(); } catch (Exception ex) { } //this.Close(); } }
private void Window_Closing(object sender, System.ComponentModel.CancelEventArgs e) { if (paramDB.Count >= 1) { StaticParametersDB.clearListBanco(); foreach (var p in paramDB) { StaticParametersDB.SetListBanco(p); } foreach (var p in paramDB) { if (p.Grupo == 0 || p.Token == null || p.Token == "") { __main.Show(); return; } } StaticParametersDB.Setcurrent(paramDB[0].Id); } __main.Show(); }
public static void CustomUpdateDB(IList <ProtocoloDB> prot, int tipo) { using (var conn = GetConnection()) { try { conn.Open(); using (var comm = GetCommand()) { var sql = CriaSQL(prot[0], tipo); query = sql; comm.Connection = conn; comm.CommandType = CommandType.Text; if (StaticParametersDB.GetDriver() == "sqlserver") { comm.CommandText = "SET DATEFORMAT dmy"; comm.ExecuteNonQuery(); } using (var command = SqlCommandWithParameters(prot[0], tipo)) { command.Connection = conn; command.ExecuteNonQuery(); } } } catch (Exception ex) { ExceptionCore e = new ExceptionCore(); e.ExBanco(2, ex.Message, StaticParametersDB.GetDriver(), ex, query); } finally { conn.Close(); } } }
private static dynamic GetConnection() { if (StaticParametersDB.GetDriver() == "oracle") { string oradb = $"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST={StaticParametersDB.GetHost()})(PORT={StaticParametersDB.GetPort()}))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME={StaticParametersDB.GetServiceName()})));User ID={StaticParametersDB.GetUser()};Password={StaticParametersDB.GetPassword()};"; return(new OracleConnection(oradb)); } else { if (StaticParametersDB.GetPort() != "0") { var strconnection = $"Data Source={StaticParametersDB.GetHost()},{StaticParametersDB.GetPort()};Network Library=DBMSSOCN;Initial Catalog = {StaticParametersDB.GetServiceName()}; User ID = {StaticParametersDB.GetUser()}; Password = {StaticParametersDB.GetPassword()};"; return(new SqlConnection(strconnection)); } else { var strconnection = $"Server={StaticParametersDB.GetHost()};Database={StaticParametersDB.GetServiceName()};Trusted_Connection={StaticParametersDB.GetTrustedConn()};User Id={StaticParametersDB.GetUser()};Password = {StaticParametersDB.GetPassword()}; "; return(new SqlConnection(strconnection)); } } }
public static void GetData(ISession sessao) { var ProtocoloDAO = new ProtocoloDB_DAO(sessao); using (var conn = GetConnection()) { //Não é possível abrir o banco de dados solicitado pelo logon. Falha de logon.Falha de logon do usuário 'AUTORIDADE NT\SISTEMA'. try { conn.Open(); using (var comm = GetCommand()) { comm.Connection = conn; comm.CommandText = "SELECT ID, XMLEVENTO, IDSEQ FROM ZMDATVIVES_EVENTOS_ESOCIAL WHERE NROPROTOCOLO IS NULL"; var adapter = GetAdapter(comm); var dataTable = new System.Data.DataTable(); adapter.Fill(dataTable); Processos proc = new Processos(); foreach (System.Data.DataRow row in dataTable.Rows) { try { var Base = proc.DefineBaseEnvioDB(Convert.ToString(row["XMLEVENTO"]), (Convert.ToString(row["ID"]) + "-" + Convert.ToString(row["IDSEQ"]) + "-" + StaticParametersDB.GetId())); var prot = new ProtocoloDB { id = string.Concat(Convert.ToString(row["ID"]), "-", Convert.ToString(row["IDSEQ"]), "-" + StaticParametersDB.GetId()), idEvento = Convert.ToString(row["ID"]), idSeq = Convert.ToString(row["IDSEQ"]), xmlEvento = Convert.ToString(row["XMLEVENTO"]), driver = StaticParametersDB.GetDriver(), baseEnv = Convert.ToString(Base), idDB = StaticParametersDB.GetId() }; ProtocoloDAO.Salvar(prot); } catch (Exception ex) { if (ex.HResult != -2147467261) { ExceptionCore e = new ExceptionCore(); e.ExBanco(30, "ID Evento: " + (Convert.ToString(row["ID"]) + "-" + Convert.ToString(row["IDSEQ"]) + "-" + StaticParametersDB.GetId()) + " | Erro: " + ex.Message, StaticParametersDB.GetDriver(), ex, ""); } else { UpdateDB( proc.GeraProtocoloAux("1" , Convert.ToString(row["ID"]) , Convert.ToString(row["IDSEQ"]) , "<erro>Tag tipo de ambiente não presente no XML</erro>" , "0" , "Tag tipo de ambiente não presente no XML") ); } } } } } catch (Exception ex) { ExceptionCore e = new ExceptionCore(); e.ExBanco(1, ex.Message, StaticParametersDB.GetDriver(), ex, ""); } finally { conn.Close(); } } }
public void Init() { Processos process = new Processos(); DirectoryInfo dir = new DirectoryInfo(@"C:\\vch"); FileInfo fil = new FileInfo(@"C:\\vch\\dados.db"); int ctrlFirstExec = 0; if (dir.Exists != true) { ctrlFirstExec = 1; string user = System.Windows.Forms.SystemInformation.UserName; System.IO.DirectoryInfo folderInfo = new System.IO.DirectoryInfo("C:\\"); DirectorySecurity ds = new DirectorySecurity(); ds.AddAccessRule(new FileSystemAccessRule(user, FileSystemRights.Modify, AccessControlType.Allow)); ds.SetAccessRuleProtection(false, false); folderInfo.Create(ds); folderInfo.CreateSubdirectory("vch"); OrganizaTelaEvent(1); } if (fil.Exists != true) { try { AuxiliarNhibernate.AbrirSessao(); //fil.Create(); } catch (Exception e) { //System.Windows.Forms.MessageBox.Show(e.Message, "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); } } if (process.ReadPermissionFolder() == false || process.ReadPermissionFile() == false) { OrganizaTelaEvent(1); return; } var sessao = AuxiliarNhibernate.AbrirSessao(); Thread t = new Thread(process.VerificaParaAtualizar); t.Name = "UpdaterWorker"; t.Start(); if (ctrlFirstExec == 0) { var parametroDAO = new ParametroDAO(sessao); var param = parametroDAO.BuscarPorID(1);//Armazenamento.GetParametros(); int ctrl = 0; int ctrlVazio = 0; try { StaticParametros.SetGeraLogs(param.GeraLog); if (param.CaminhoToke.Contains(".ives") && param.CaminhoToke != "" && File.Exists(param.CaminhoToke)) { StaticParametros.SetDirToke(param.CaminhoToke); txtFolderToken.Text = param.CaminhoToke; DefineToken(param.CaminhoToke); ctrl++; } if (param.CaminhoDir != "") { if (Directory.Exists(param.CaminhoDir)) { txtFolderIni.Text = param.CaminhoDir; StaticParametros.SetDirOrigem(param.CaminhoDir); ctrl++; } } } catch (Exception ex) { //OrganizaTelaEvent(1); ctrlVazio = 1; } var parametroDBDAO = new ParametroDB_DAO(sessao); var paramDB = parametroDBDAO.BuscarTodos();//parametroDBDAO.BuscarPorID(1); //var paramDB = Armazenamento.GetParametrosDB(); try { if (paramDB.Count == 1) { StaticParametersDB.SetListBanco(paramDB[0]); if (paramDB[0].Grupo == 0 || paramDB[0].Token == null || paramDB[0].Token == "") { throw new Exception(); } else { StaticParametersDB.Setcurrent(paramDB[0].Id); } } else if (paramDB.Count > 1) { foreach (var p in paramDB) { StaticParametersDB.SetListBanco(p); } foreach (var p in paramDB) { if (p.Grupo == 0 || p.Token == null || p.Token == "") { throw new Exception(); } } StaticParametersDB.Setcurrent(paramDB[0].Id); } else { throw new Exception(); } StaticParametros.SetIntegraBanco(true); TxtStatusBanco.Text = "Conectado"; ctrl++; } catch (Exception ex) { StaticParametros.SetIntegraBanco(false); TxtStatusBanco.Text = "Desconectado"; if (ctrlVazio == 0) { var paramn = new Parametro { Id = 1, CaminhoDir = StaticParametros.GetDirOrigem(), CaminhoToke = StaticParametros.GetDirToke(), IntegraBanco = StaticParametros.GetIntegraBanco(), GeraLog = StaticParametros.GetGeraLogs() }; parametroDAO.Salvar(param); //Armazenamento.UpdateParametros(new Parametro { Id = 1, CaminhoDir = param.CaminhoDir, CaminhoToke = param.CaminhoToke, IntegraBanco = false }); } } if (ctrl >= 2) { try { if (txtFolderToken.Text == "") { OrganizaTelaEvent(1); } else { OrganizaTelaEvent(2); } //Job(); if (StaticParametros.GetDirOrigem() != null && StaticParametros.GetDirOrigem() != "") { process.CriarPastas(); } } catch (Exception ex) { OrganizaTelaEvent(1); } } else { Thread Tproc = new Thread(process.LimpaLog); Tproc.Start(); OrganizaTelaEvent(1); } } sessao.Close(); if (process.WritePermissionFolder() == false || process.WritePermissionFile() == false) { OrganizaTelaEvent(1); } }
public static bool UpdateDB(ProtocoloDB prot) { bool retorno = true; using (var conn = GetConnection()) { try { conn.Open(); using (var comm = GetCommand()) { if (prot.nroRec == null || prot.nroRec == "") { var sql = CriaSQL(prot, 1); query = sql; comm.Connection = conn; comm.CommandType = CommandType.Text; if (StaticParametersDB.GetDriver() == "sqlserver") { comm.CommandText = "SET DATEFORMAT dmy"; comm.ExecuteNonQuery(); } try //Tenta atualizar com tamanho original da mensagem de erro { using (var command = SqlCommandWithParameters(prot, 1)) { command.Connection = conn; command.ExecuteNonQuery(); } } catch (Exception ex) { if (ex.HResult == -2146232060 || ex.HResult == -2147467259) //Banco retorna erros de valor de caracteres excedido. { using (var command = SqlCommandWithParameters(prot, 1, true)) //Valor true passado por parametro para forcar a atualização, alterando o valor da mensagem. { command.Connection = conn; command.ExecuteNonQuery(); } } else { throw ex; //Caso seja outro erro, grava log. } } } else { var sql = CriaSQL(prot, 2); query = sql; comm.Connection = conn; comm.CommandType = CommandType.Text; if (StaticParametersDB.GetDriver() == "sqlserver") { comm.CommandText = "SET DATEFORMAT dmy"; comm.ExecuteNonQuery(); } using (var command = SqlCommandWithParameters(prot, 2)) { command.Connection = conn; command.ExecuteNonQuery(); } } } } catch (Exception ex) { ExceptionCore e = new ExceptionCore(); e.ExBanco(2, ex.Message, StaticParametersDB.GetDriver(), ex, query); retorno = false; } finally { conn.Close(); } } return(retorno); }
private void BtnSalvar_Click(object sender, RoutedEventArgs e) { var proc = new Processos(); if (proc.ReadPermissionFolder() == false || proc.WritePermissionFolder() == false) { System.Windows.Forms.MessageBox.Show("Ops, você não tem permissão para leitura ou escrita na pasta c:/vch", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (proc.WritePermissionFile() == false || proc.ReadPermissionFile() == false) { System.Windows.Forms.MessageBox.Show("Ops, você não tem permissão para leitura ou escrita no arquivo dados.db | c:/vch/dados.db", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var sessao = AuxiliarNhibernate.AbrirSessao(); var parametroDAO = new ParametroDAO(sessao); var parametroDBDAO = new ParametroDB_DAO(sessao); if (proc.VerificaProcessoRun() == false) { Processos process = new Processos(); var ctrl = 0; if (StaticParametros.GetDirToke() != null) { if (File.Exists(StaticParametros.GetDirToke())) { ctrl++; if (StaticParametros.GetDirOrigem() != null) { if (Directory.Exists(StaticParametros.GetDirOrigem())) { ctrl++; } else { System.Windows.MessageBox.Show("Ops! Parece que a pasta de origem foi movida"); txtFolderIni.Text = ""; StaticParametros.SetDirOrigem(null); } } if (StaticParametersDB.GetDriver() != null) { ctrl++; StaticParametros.SetIntegraBanco(true); } if (ctrl >= 2) { var newParam = new Parametro { Id = 1, CaminhoDir = StaticParametros.GetDirOrigem(), CaminhoToke = StaticParametros.GetDirToke(), IntegraBanco = StaticParametros.GetIntegraBanco(), GeraLog = StaticParametros.GetGeraLogs() }; parametroDAO.Salvar(newParam); if (StaticParametersDB.GetDriver() != null) { TxtStatusBanco.Text = "Conectado"; } else { TxtStatusBanco.Text = "Desconectado"; } //Armazenamento.AddParametros(new Parametro { Id = 1, CaminhoDir = StaticParametros.GetDirOrigem(), CaminhoToke = StaticParametros.GetDirToke(), IntegraBanco = StaticParametros.GetIntegraBanco() }); OrganizaTelaEvent(2); if (StaticParametros.GetDirOrigem() != null && StaticParametros.GetDirOrigem() != "") { process.CriarPastas(); } } else { TxtStatusBanco.Text = "Desconectado"; System.Windows.MessageBox.Show("É necessário definir um diretorio ou configurar uma conexão com banco de dados para continuar"); } } else { System.Windows.MessageBox.Show("Ops! Parece que o arquivo de token foi movido"); txtFolderToken.Text = ""; StaticParametros.SetDirToke(null); } } else { System.Windows.MessageBox.Show("É necessário definir um token para continuar"); } } else { System.Windows.MessageBox.Show("O serviço está em execução"); } sessao.Close(); }
public void Parametro() { var sessao = AuxiliarNhibernate.AbrirSessao(); var ParametroDAO = new ParametroDAO(sessao); var ParametroDBDAO = new ParametroDB_DAO(sessao); Processos process = new Processos(); StaticParametros.SetTipoApp("Service"); int ctrl = 0; try { var ret = ParametroDAO.BuscarPorID(1);//Armazenamento.GetParametros(); //var retdb = ParametroDBDAO.BuscarPorID(1); var retdb = ParametroDBDAO.BuscarTodos(); try { StaticParametros.SetGeraLogs(ret.GeraLog); if (File.Exists(ret.CaminhoToke)) { ctrl++; StaticParametros.SetDirToke(ret.CaminhoToke); if (DefineToken(StaticParametros.GetDirToke()) == false) { this.Stop(); } if (VerificaProcessoRun() == false) { Thread t = new Thread(process.VerificaParaAtualizar); t.Name = "UpdaterWorker"; t.Start(); } else { Log("Feche o integrador para iniciar o serviço.", 2); this.Stop(); } } } catch (Exception) { Log("Não foi possivel localizar as informações, por favor, abra o integrador e defina os parametros novamente.", 2); this.Stop(); } try { if (Directory.Exists(ret.CaminhoDir)) { ctrl++; StaticParametros.SetDirOrigem(ret.CaminhoDir); process.CriarPastas(); } } catch (Exception) { } try { if (retdb.Count == 1) { StaticParametersDB.SetListBanco(retdb[0]); if (retdb[0].Grupo == 0 || retdb[0].Token == null || retdb[0].Token == "") { throw new Exception(); } StaticParametersDB.Setcurrent(retdb[0].Id); } else if (retdb.Count > 1) { foreach (var p in retdb) { StaticParametersDB.SetListBanco(p); } foreach (var p in retdb) { if (p.Grupo == 0 || p.Token == null || p.Token == "") { throw new Exception(); } } StaticParametersDB.Setcurrent(retdb[0].Id); } else { throw new Exception(); } StaticParametros.SetIntegraBanco(true); ctrl++; } catch (Exception) { StaticParametros.SetIntegraBanco(false); } if (ctrl < 2) { Log("Não foi possivel localizar as informações, por favor, abra o integrador e defina os parametros novamente.", 2); this.Stop(); } } catch { StreamWriter vWriter = new StreamWriter(@"c:\vch\log\logServico.log", true); vWriter.WriteLine("--------------------------------------------------"); vWriter.WriteLine("Erro " + DateTime.Now.ToString()); vWriter.Flush(); vWriter.Close(); sessao.Close(); this.Stop(); } sessao.Close(); }
private static string CriaSQL(ProtocoloDB prot, int tipo) { var quote = '\''; string format = "dd-MM-yyyy hh:mm:ss"; //string format1 = "yyyy-MM-dd hh:mm:ss"; if (tipo == 1) { //var data = Convert.ToDateTime(prot.dtconsulta); //RetornaArrayData(prot.dtconsulta); var data = ConvertDate(prot.dtconsulta); var sql = "UPDATE ZMDATVIVES_EVENTOS_ESOCIAL SET NROPROTOCOLO = :Nrprot, XMLPROTOCOLO = :Xmlprot, MENSAGEMERRO = :Erro, DATARETORNO = :Dtretorno, HORARETORNO = :Hrretorno, STATUS = :Status WHERE ID = :Idevento AND IDSEQ = :Idseq"; sql = sql.Replace(":Nrprot", string.Concat(quote + prot.nroProt + quote)); sql = sql.Replace(":Xmlprot", string.Concat(quote + (prot.xmlProt = prot.xmlProt.Replace("> <", "><")) + quote)); if (String.IsNullOrEmpty(prot.erros)) { sql = sql.Replace(":Erro", string.Concat(quote + "null" + quote)); } else { sql = sql.Replace(":Erro", string.Concat(quote + prot.erros.Replace("'", "") + quote)); } if (StaticParametersDB.GetDriver() == "oracle") { sql = sql.Replace(":Dtretorno", "trunc(SYSDATE)"); } else { //CONVERT(DATETIME, '2012-06-05', 102) sql = sql.Replace(":Dtretorno", string.Concat(quote + data.ToString(format) + quote)); } sql = sql.Replace(":Hrretorno", string.Concat(quote + prot.hrconsulta + quote)); sql = sql.Replace(":Status", string.Concat(quote + prot.status + quote)); sql = sql.Replace(":Idevento", string.Concat(quote + prot.idEvento + quote)); sql = sql.Replace(":Idseq", prot.idSeq); return(sql); } else if (tipo == 2) { //var data = Convert.ToDateTime(prot.dtconsulta);//RetornaArrayData(prot.dtconsulta); var data = ConvertDate(prot.dtconsulta); var sql = "UPDATE ZMDATVIVES_EVENTOS_ESOCIAL SET NROPROTOCOLO = :nrprot, XMLPROTOCOLO = :xmlprot, NRORECIBO = :nroRec, XMLRECIBO = :xmlRec, DATARETORNO = :Dtretorno, HORARETORNO = :Hrretorno, STATUS = :Status WHERE ID = :Idevento AND IDSEQ = :Idseq"; sql = sql.Replace(":nrprot", string.Concat(quote + prot.nroProt + quote)); sql = sql.Replace(":xmlprot", string.Concat(quote + prot.xmlProt + quote)); sql = sql.Replace(":nroRec", string.Concat(quote + prot.nroRec + quote)); sql = sql.Replace(":xmlRec", string.Concat(quote + prot.xmlRec + quote)); if (StaticParametersDB.GetDriver() == "oracle") { sql = sql.Replace(":Dtretorno", "trunc(SYSDATE)"); } else { //CONVERT(DATETIME, '2012-06-05', 102) sql = sql.Replace(":Dtretorno", string.Concat(quote + data.ToString(format) + quote)); } sql = sql.Replace(":Hrretorno", string.Concat(quote + prot.hrconsulta + quote)); sql = sql.Replace(":Status", string.Concat(quote + prot.status + quote)); sql = sql.Replace(":Idevento", string.Concat(quote + prot.idEvento + quote)); sql = sql.Replace(":Idseq", prot.idSeq); return(sql); } else if (tipo == 3)//novo { //var data = Convert.ToDateTime(prot.dtenvio);//RetornaArrayData(prot.dtenvio); var data = ConvertDate(prot.dtenvio); var sql = "UPDATE ZMDATVIVES_EVENTOS_ESOCIAL SET NROPROTOCOLO = :Nrprot, XMLPROTOCOLO = :Xmlprot, STATUS = :Status, DATAENVIO = :Dtenvio, HORAENVIO = :Hrenvio WHERE ID = :Idevento AND IDSEQ = :Idseq"; sql = sql.Replace(":Nrprot", string.Concat(quote + prot.nroProt + quote)); sql = sql.Replace(":Xmlprot", string.Concat(quote + prot.xmlProt + quote)); sql = sql.Replace(":Status", string.Concat(quote + prot.status + quote)); if (StaticParametersDB.GetDriver() == "oracle") { sql = sql.Replace(":Dtenvio", "trunc(SYSDATE)"); } else { //CONVERT(DATETIME, '2012-06-05', 102) sql = sql.Replace(":Dtenvio", string.Concat(quote + data.ToString(format) + quote)); } sql = sql.Replace(":Hrenvio", string.Concat(quote + prot.hrenvio + quote)); sql = sql.Replace(":Idevento", string.Concat(quote + prot.idEvento + quote)); sql = sql.Replace(":Idseq", prot.idSeq); return(sql); } else { //var data = Convert.ToDateTime(prot.dtconsulta);//RetornaArrayData(prot.dtconsulta); var data = ConvertDate(prot.dtconsulta); var sql = "UPDATE ZMDATVIVES_EVENTOS_ESOCIAL SET DATARETORNO = :Dtretorno, HORARETORNO = :Hrretorno, STATUS = :Status WHERE ID = :Idevento AND IDSEQ = :Idseq"; if (StaticParametersDB.GetDriver() == "oracle") { sql = sql.Replace(":Dtretorno", "trunc(SYSDATE)"); } else { //CONVERT(DATETIME, '2012-06-05', 102) sql = sql.Replace(":Dtretorno", string.Concat(quote + data.ToString(format) + quote)); } sql = sql.Replace(":Hrretorno", string.Concat(quote + prot.hrconsulta + quote)); sql = sql.Replace(":Status", string.Concat(quote + prot.status + quote)); sql = sql.Replace(":Idevento", string.Concat(quote + prot.idEvento + quote)); sql = sql.Replace(":Idseq", prot.idSeq); return(sql); } }
private void init() { init2(); BtnDelete.Visibility = Visibility.Hidden; CboDriver.Items.Insert(0, "Oracle"); CboDriver.Items.Insert(1, "SQLServer"); CboDriver.SelectedIndex = -1; var sessao = AuxiliarNhibernate.AbrirSessao(); var ParametroDB = new ParametroDB_DAO(sessao); try { var process = new Processos(); var param = ParametroDB.BuscarPorID(1);//Armazenamento.GetParametrosDB(); try { if (param.Driver == "oracle") { CboDriver.SelectedIndex = 0; } else { CboDriver.SelectedIndex = 1; } TxbHost.Text = param.Host; TxbPort.Text = param.Port; TxbServiceName.Text = param.ServiceName; TxbUser.Text = param.User; StaticParametersDB.SetDriver("oracle"); StaticParametersDB.SetHost(TxbHost.Text); StaticParametersDB.SetPort(TxbPort.Text); StaticParametersDB.SetServiceName(TxbServiceName.Text); StaticParametersDB.SetUser(TxbUser.Text); PwbSenha.Password = AESThenHMAC.SimpleDecryptWithPassword(param.Password, process.GetMacAdress()); StaticParametersDB.SetPassword(PwbSenha.Password); BtnDelete.Visibility = Visibility.Visible; } catch (Exception e) { if (StaticParametersDB.GetDriver() != null) { var driver = StaticParametersDB.GetDriver(); if (driver == "oracle") { CboDriver.SelectedIndex = 0; } else { CboDriver.SelectedIndex = 1; } TxbHost.Text = StaticParametersDB.GetHost(); TxbPort.Text = StaticParametersDB.GetPort(); TxbServiceName.Text = StaticParametersDB.GetServiceName(); TxbUser.Text = StaticParametersDB.GetUser(); PwbSenha.Password = StaticParametersDB.GetPassword(); BtnDelete.Visibility = Visibility.Visible; } } }catch (Exception e) { } sessao.Close(); }
public IList <ProtocoloDB> BuscaTodos() { criterios.Add(Restrictions.Eq("idDB", StaticParametersDB.GetId())); return(criterios.List <ProtocoloDB>()); }
public IList <ProtocoloDB> BuscaEnvio() { criterios.Add(Restrictions.And(Restrictions.Eq("idDB", StaticParametersDB.GetId()), Restrictions.Or(Restrictions.IsNull("nroProt"), Restrictions.Eq("nroProt", "")))); return(criterios.List <ProtocoloDB>()); }
private void BtnSalvar_Click(object sender, RoutedEventArgs e) { ParametroDB paramdbNew = new ParametroDB(); Processos proc = new Processos(); if (TxbHost.Text != "" && TxbPort.Text != "" && TxbServiceName.Text != "" && TxbUser.Text != "" && PwbSenha.Password != "" && CboDriver.SelectedIndex != -1 && CboConexao.SelectedIndex != -1 && TxbDescr.Text != "" && TxbGrupo.Text != "" && TxbToken.Text != "") { if (proc.VerificaConexaoBanco(TxbHost.Text, TxbPort.Text, TxbServiceName.Text, TxbUser.Text, PwbSenha.Password, (string)CboDriver.SelectedItem) == true) { if (lastIndex != 0) { if (CboDriver.SelectedIndex == 0) { paramDB[lastIndex - 1].Driver = "oracle"; } else { paramDB[lastIndex - 1].Driver = "sqlserver"; } paramDB[lastIndex - 1].Descr = TxbDescr.Text; paramDB[lastIndex - 1].Host = TxbHost.Text; paramDB[lastIndex - 1].Port = TxbPort.Text; paramDB[lastIndex - 1].ServiceName = TxbServiceName.Text; paramDB[lastIndex - 1].User = TxbUser.Text; paramDB[lastIndex - 1].Password = AESThenHMAC.SimpleEncryptWithPassword(PwbSenha.Password, proc.GetMacAdress()); paramDB[lastIndex - 1].Trusted_Conn = "True"; paramDB[lastIndex - 1].Token = TxbToken.Text; try { paramDB[lastIndex - 1].Grupo = Convert.ToInt64(TxbGrupo.Text); salvaDB(paramDB[lastIndex - 1]); } catch (Exception error) { System.Windows.MessageBox.Show("Campo Grupo deve ser numerico", "Atenção", MessageBoxButton.OK, MessageBoxImage.Warning); return; } } else { if (CboDriver.SelectedIndex == 0) { paramdbNew.Driver = "oracle"; } else { paramdbNew.Driver = "sqlserver"; } paramdbNew.Descr = TxbDescr.Text; paramdbNew.Host = TxbHost.Text; paramdbNew.Port = TxbPort.Text; paramdbNew.ServiceName = TxbServiceName.Text; paramdbNew.User = TxbUser.Text; paramdbNew.Password = AESThenHMAC.SimpleEncryptWithPassword(PwbSenha.Password, proc.GetMacAdress()); paramdbNew.Trusted_Conn = "True"; paramdbNew.Token = TxbToken.Text; try { paramdbNew.Grupo = Convert.ToInt64(TxbGrupo.Text); salvaDB(paramdbNew); } catch (Exception error) { System.Windows.MessageBox.Show("Campo Grupo deve ser numerico", "Atenção", MessageBoxButton.OK, MessageBoxImage.Warning); return; } } cleanScreen(); lastIndex = -1; } else if (proc.VerificaConexaoBanco(TxbHost.Text, TxbPort.Text, TxbServiceName.Text, TxbUser.Text, PwbSenha.Password, (string)CboDriver.SelectedItem, "False") == true) { if (lastIndex != 0) { if (CboDriver.SelectedIndex == 0) { paramDB[lastIndex - 1].Driver = "oracle"; } else { paramDB[lastIndex - 1].Driver = "sqlserver"; } paramDB[lastIndex - 1].Descr = TxbDescr.Text; paramDB[lastIndex - 1].Host = TxbHost.Text; paramDB[lastIndex - 1].Port = TxbPort.Text; paramDB[lastIndex - 1].ServiceName = TxbServiceName.Text; paramDB[lastIndex - 1].User = TxbUser.Text; paramDB[lastIndex - 1].Password = AESThenHMAC.SimpleEncryptWithPassword(PwbSenha.Password, proc.GetMacAdress()); paramDB[lastIndex - 1].Trusted_Conn = "False"; paramDB[lastIndex - 1].Token = TxbToken.Text; try { paramDB[lastIndex - 1].Grupo = Convert.ToInt64(TxbGrupo.Text); salvaDB(paramDB[lastIndex - 1]); } catch (Exception error) { System.Windows.MessageBox.Show("Campo Grupo deve ser numerico", "Atenção", MessageBoxButton.OK, MessageBoxImage.Warning); return; } } else { if (CboDriver.SelectedIndex == 0) { paramdbNew.Driver = "oracle"; } else { paramdbNew.Driver = "sqlserver"; } paramdbNew.Descr = TxbDescr.Text; paramdbNew.Host = TxbHost.Text; paramdbNew.Port = TxbPort.Text; paramdbNew.ServiceName = TxbServiceName.Text; paramdbNew.User = TxbUser.Text; paramdbNew.Password = AESThenHMAC.SimpleEncryptWithPassword(PwbSenha.Password, proc.GetMacAdress()); paramdbNew.Trusted_Conn = "False"; StaticParametersDB.SetListBanco(paramdbNew); paramdbNew.Token = TxbToken.Text; try { paramdbNew.Grupo = Convert.ToInt64(TxbGrupo.Text); salvaDB(paramdbNew); } catch (Exception error) { System.Windows.MessageBox.Show("Campo Grupo deve ser numerico", "Atenção", MessageBoxButton.OK, MessageBoxImage.Warning); return; } } cleanScreen(); lastIndex = -1; } } else { System.Windows.MessageBox.Show("Preencha todos os campos antes de continuar", "Atenção", MessageBoxButton.OK, MessageBoxImage.Warning); } }
private void refreshCBO(ParametroDB paramdbNew, int tipo) { BtnDelete.Visibility = Visibility.Hidden; BtnDelete.Visibility = Visibility.Hidden; if (tipo == 1) { try { CboConexao.Items.Clear(); CboConexao.Items.Insert(0, "Nova conexão"); CboConexao.SelectedIndex = 0; if (paramDB.Count > 1) { StaticParametersDB.clearListBanco(); foreach (var p in paramDB) { StaticParametersDB.SetListBanco(p); } for (int i = 0; i < paramDB.Count; i++) { CboConexao.Items.Insert(i + 1, paramDB[i].Descr); } } else { StaticParametersDB.clearListBanco(); StaticParametersDB.SetListBanco(paramDB[0]); CboConexao.Items.Insert(1, paramDB[0].Descr); } } catch (Exception e) { } } else { try { var process = new Processos(); paramDB.Add(paramdbNew); CboConexao.Items.Clear(); CboConexao.Items.Insert(0, "Nova conexão"); CboConexao.SelectedIndex = 0; if (paramDB.Count > 1) { StaticParametersDB.clearListBanco(); foreach (var p in paramDB) { StaticParametersDB.SetListBanco(p); } for (int i = 0; i < paramDB.Count; i++) { CboConexao.Items.Insert(i + 1, paramDB[i].Descr); } } else { StaticParametersDB.clearListBanco(); StaticParametersDB.SetListBanco(paramDB[0]); CboConexao.Items.Insert(1, paramDB[0].Descr); } } catch (Exception e) { } } }
private static dynamic SqlCommandWithParameters(ProtocoloDB prot, int tipo, bool forceUpdate = false) { string format = "dd-MM-yyyy hh:mm:ss"; if (StaticParametersDB.GetDriver() == "oracle") { if (tipo == 1) { OracleCommand oraCommand = new OracleCommand("UPDATE ZMDATVIVES_EVENTOS_ESOCIAL SET NROPROTOCOLO = :Nrprot, XMLPROTOCOLO = :Xmlprot, MENSAGEMERRO = :Erro, DATARETORNO = :Dtretorno, HORARETORNO = :Hrretorno, STATUS = :Status WHERE ID = :Idevento AND IDSEQ = :Idseq"); oraCommand.Parameters.Add(new OracleParameter(":Nrprot", prot.nroProt)); oraCommand.Parameters.Add(new OracleParameter(":Xmlprot", prot.xmlProt)); if (String.IsNullOrEmpty(prot.erros)) { oraCommand.Parameters.Add(new OracleParameter(":Erro", DBNull.Value)); } else { if (forceUpdate == true && prot.erros.Length > 4000) { prot.erros = "Consulte o portal ives para detalhes do erro"; } oraCommand.Parameters.Add(new OracleParameter(":Erro", prot.erros.Replace("'", ""))); } oraCommand.Parameters.Add(new OracleParameter(":Dtretorno", prot.dtconsulta)); oraCommand.Parameters.Add(new OracleParameter(":Hrretorno", prot.hrconsulta)); oraCommand.Parameters.Add(new OracleParameter(":Status", prot.status)); oraCommand.Parameters.Add(new OracleParameter(":Idevento", prot.idEvento)); oraCommand.Parameters.Add(new OracleParameter(":Idseq", prot.idSeq)); return(oraCommand); } else if (tipo == 2) { OracleCommand oraCommand = new OracleCommand("UPDATE ZMDATVIVES_EVENTOS_ESOCIAL SET NROPROTOCOLO = :nrprot, XMLPROTOCOLO = :xmlprot, NRORECIBO = :nroRec, XMLRECIBO = :xmlRec, DATARETORNO = :Dtretorno, HORARETORNO = :Hrretorno, STATUS = :Status WHERE ID = :Idevento AND IDSEQ = :Idseq"); oraCommand.Parameters.Add(new OracleParameter(":nrprot", prot.nroProt)); oraCommand.Parameters.Add(new OracleParameter(":xmlprot", prot.xmlProt)); oraCommand.Parameters.Add(new OracleParameter(":nroRec", prot.nroRec)); oraCommand.Parameters.Add(new OracleParameter(":xmlRec", prot.xmlRec)); oraCommand.Parameters.Add(new OracleParameter(":Dtretorno", prot.dtconsulta)); oraCommand.Parameters.Add(new OracleParameter(":Hrretorno", prot.hrconsulta)); oraCommand.Parameters.Add(new OracleParameter(":Status", prot.status)); oraCommand.Parameters.Add(new OracleParameter(":Idevento", prot.idEvento)); oraCommand.Parameters.Add(new OracleParameter(":Idseq", prot.idSeq)); return(oraCommand); } else if (tipo == 3) { OracleCommand oraCommand = new OracleCommand("UPDATE ZMDATVIVES_EVENTOS_ESOCIAL SET NROPROTOCOLO = :Nrprot, XMLPROTOCOLO = :Xmlprot, STATUS = :Status, DATAENVIO = :Dtenvio, HORAENVIO = :Hrenvio WHERE ID = :Idevento AND IDSEQ = :Idseq"); oraCommand.Parameters.Add(new OracleParameter(":Nrprot", prot.nroProt)); oraCommand.Parameters.Add(new OracleParameter(":Xmlprot", prot.xmlProt)); oraCommand.Parameters.Add(new OracleParameter(":Status", prot.status)); oraCommand.Parameters.Add(new OracleParameter(":Dtenvio", prot.dtenvio)); oraCommand.Parameters.Add(new OracleParameter(":Hrenvio", prot.hrenvio)); oraCommand.Parameters.Add(new OracleParameter(":Idevento", prot.idEvento)); oraCommand.Parameters.Add(new OracleParameter(":Idseq", prot.idSeq)); return(oraCommand); } else { OracleCommand oraCommand = new OracleCommand("UPDATE ZMDATVIVES_EVENTOS_ESOCIAL SET DATARETORNO = :Dtretorno, HORARETORNO = :Hrretorno, STATUS = :Status WHERE ID = :Idevento AND IDSEQ = :Idseq"); oraCommand.Parameters.Add(new OracleParameter(":Dtretorno", prot.dtconsulta)); oraCommand.Parameters.Add(new OracleParameter(":Hrretorno", prot.hrconsulta)); oraCommand.Parameters.Add(new OracleParameter(":Status", prot.status)); oraCommand.Parameters.Add(new OracleParameter(":Idevento", prot.idEvento)); oraCommand.Parameters.Add(new OracleParameter(":Idseq", prot.idSeq)); return(oraCommand); } } else { if (tipo == 1) { SqlCommand sqlCommand = new SqlCommand("UPDATE ZMDATVIVES_EVENTOS_ESOCIAL SET NROPROTOCOLO = @Nrprot, XMLPROTOCOLO = @Xmlprot, MENSAGEMERRO = @Erro, DATARETORNO = @Dtretorno, HORARETORNO = @Hrretorno, STATUS = @Status WHERE ID = @Idevento AND IDSEQ = @Idseq"); sqlCommand.Parameters.Add(new SqlParameter("@Nrprot", prot.nroProt)); sqlCommand.Parameters.Add(new SqlParameter("@Xmlprot", prot.xmlProt)); if (String.IsNullOrEmpty(prot.erros)) { sqlCommand.Parameters.Add(new SqlParameter("@Erro", DBNull.Value)); } else { if (forceUpdate == true && prot.erros.Length > 4000) { prot.erros = "Consulte o portal do iVes para obter detalhes do erro"; } sqlCommand.Parameters.Add(new SqlParameter("@Erro", prot.erros.Replace("'", ""))); } sqlCommand.Parameters.Add(new SqlParameter("@Dtretorno", Convert.ToDateTime(prot.dtconsulta).ToString(format))); sqlCommand.Parameters.Add(new SqlParameter("@Hrretorno", prot.hrconsulta)); sqlCommand.Parameters.Add(new SqlParameter("@Status", prot.status)); sqlCommand.Parameters.Add(new SqlParameter("@Idevento", prot.idEvento)); sqlCommand.Parameters.Add(new SqlParameter("@Idseq", prot.idSeq)); return(sqlCommand); } else if (tipo == 2) { SqlCommand sqlCommand = new SqlCommand("UPDATE ZMDATVIVES_EVENTOS_ESOCIAL SET NROPROTOCOLO = @nrprot, XMLPROTOCOLO = @xmlprot, NRORECIBO = @nroRec, XMLRECIBO = @xmlRec, DATARETORNO = @Dtretorno, HORARETORNO = @Hrretorno, STATUS = @Status WHERE ID = @Idevento AND IDSEQ = @Idseq"); sqlCommand.Parameters.Add(new SqlParameter("@nrprot", prot.nroProt)); sqlCommand.Parameters.Add(new SqlParameter("@xmlprot", prot.xmlProt)); sqlCommand.Parameters.Add(new SqlParameter("@nroRec", prot.nroRec)); sqlCommand.Parameters.Add(new SqlParameter("@xmlRec", prot.xmlRec)); sqlCommand.Parameters.Add(new SqlParameter("@Dtretorno", Convert.ToDateTime(prot.dtconsulta).ToString(format))); sqlCommand.Parameters.Add(new SqlParameter("@Hrretorno", prot.hrconsulta)); sqlCommand.Parameters.Add(new SqlParameter("@Status", prot.status)); sqlCommand.Parameters.Add(new SqlParameter("@Idevento", prot.idEvento)); sqlCommand.Parameters.Add(new SqlParameter("@Idseq", prot.idSeq)); return(sqlCommand); } else if (tipo == 3) { SqlCommand sqlCommand = new SqlCommand("UPDATE ZMDATVIVES_EVENTOS_ESOCIAL SET NROPROTOCOLO = @Nrprot, XMLPROTOCOLO = @Xmlprot, STATUS = @Status, DATAENVIO = @Dtenvio, HORAENVIO = @Hrenvio WHERE ID = @Idevento AND IDSEQ = @Idseq"); sqlCommand.Parameters.Add(new SqlParameter("@Nrprot", prot.nroProt)); sqlCommand.Parameters.Add(new SqlParameter("@Xmlprot", prot.xmlProt)); sqlCommand.Parameters.Add(new SqlParameter("@Status", prot.status)); sqlCommand.Parameters.Add(new SqlParameter("@Dtenvio", Convert.ToDateTime(prot.dtenvio).ToString(format))); sqlCommand.Parameters.Add(new SqlParameter("@Hrenvio", prot.hrenvio)); sqlCommand.Parameters.Add(new SqlParameter("@Idevento", prot.idEvento)); sqlCommand.Parameters.Add(new SqlParameter("@Idseq", prot.idSeq)); return(sqlCommand); } else { SqlCommand sqlCommand = new SqlCommand("UPDATE ZMDATVIVES_EVENTOS_ESOCIAL SET DATARETORNO = @Dtretorno, HORARETORNO = @Hrretorno, STATUS = @Status WHERE ID = @Idevento AND IDSEQ = @Idseq"); sqlCommand.Parameters.Add(new SqlParameter("@Dtretorno", Convert.ToDateTime(prot.dtconsulta).ToString(format))); sqlCommand.Parameters.Add(new SqlParameter("@Hrretorno", prot.hrconsulta)); sqlCommand.Parameters.Add(new SqlParameter("@Status", prot.status)); sqlCommand.Parameters.Add(new SqlParameter("@Idevento", prot.idEvento)); sqlCommand.Parameters.Add(new SqlParameter("@Idseq", prot.idSeq)); return(sqlCommand); } } }