public void Atualizar(ProtocoloDB protocolo) { if (protocolo != null) { sessao.Update(protocolo); sessao.Flush(); } }
public void Remover(ProtocoloDB parametro) { if (parametro != null) { sessao.Delete(parametro); sessao.Flush(); } }
public void EnviaDB() { var sessao = AuxiliarNhibernate.AbrirSessao(); ProtocoloDB_DAO ProtocoloDAO = new ProtocoloDB_DAO(sessao); Banco.GetData(sessao); var lista = ProtocoloDAO.BuscaEnvio(); if (lista.Count > 0) { foreach (var item in lista) { var apiXMLDB = new EnviaXML(StaticParametersDB.GetGrupo(), StaticParametersDB.GetToken(), Convert.ToBoolean(item.baseEnv)); if (item.driver == StaticParametersDB.GetDriver()) { var xmlString = proc.MontaXMLDB(item.id, item.xmlEvento); var response = apiXMLDB.SendXML(xmlString, item.id); if (proc.VerificaResponseXML(response) == true) { proc.SalvaProtocoloXML(item.id, response, 2, sessao); var data = proc.RetornaData(); var protocolo = new ProtocoloDB { id = item.id, dtenvio = data[0], hrenvio = data[1], status = "0 - Enviado", idDB = StaticParametersDB.GetId() }; ProtocoloDAO.Salvar(protocolo); proc.GeraLogEnviaXML(item.id, "Foi enviado com sucesso!"); Banco.CustomUpdateDB(ProtocoloDAO.BuscarPorIDEvento(item.id), 3); } else { proc.GeraLogEnviaXML(item.id, "Não foi enviado"); } } } } proc.RemoveFileBuffer(); sessao.Close(); }
private void search() { var sessao = AuxiliarNhibernate.AbrirSessao(); ProtocoloDB_DAO ProtocoloDAO = new ProtocoloDB_DAO(sessao); var protocolos = ProtocoloDAO.BuscaPorData(datePicker.SelectedDate.ToString().Split(' ')[0]); if (protocolos.Count > 0) { var result = MessageBox.Show("Deseja colocar os eventos da data selecionada para serem reconsultados? Total de " + protocolos.Count, "Confirmação", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { foreach (var protocolo in protocolos) { var procotolodb = new ProtocoloDB(); procotolodb.id = protocolo.id; procotolodb.consultado = false; procotolodb.salvoDB = false; procotolodb.erros = null; procotolodb.dtconsulta = null; procotolodb.hrconsulta = null; procotolodb.nroRec = null; procotolodb.xmlRec = null; procotolodb.nroProtGov = null; try { ProtocoloDAO.SalvarReconsulta(procotolodb); } catch (Exception ex) { Processos proc = new Processos(); proc.InsereLogInterno("Reconsultar", ex, "999", "1", ""); } } System.Windows.MessageBox.Show("Sucesso"); } } else { System.Windows.MessageBox.Show("Nenhum evento encontrado!"); } }
public void Salvar(ProtocoloDB protocolo) { try { var prot = BuscarPorIDEvento(protocolo.id); if (prot[0].xmlEvento != null) { Atualizar(AjustaParaAtualizar(prot[0], protocolo)); } } catch (Exception ex) { if (protocolo != null) { sessao.Save(protocolo); sessao.Flush(); } } }
public ProtocoloDB AjustaParaAtualizarReconsulta(ProtocoloDB protocoloCurrent, ProtocoloDB protocoloNew) { protocoloCurrent.nroRec = protocoloNew.nroRec; protocoloCurrent.xmlRec = protocoloNew.xmlRec; protocoloCurrent.erros = protocoloNew.erros; protocoloCurrent.salvoDB = protocoloNew.salvoDB; protocoloCurrent.consultado = protocoloNew.consultado; protocoloCurrent.dtconsulta = protocoloNew.dtconsulta; protocoloCurrent.hrconsulta = protocoloNew.hrconsulta; protocoloCurrent.nroProtGov = protocoloNew.nroProtGov; if (protocoloNew.nroProt != null && protocoloNew.nroProt != "") { protocoloCurrent.nroProt = protocoloNew.nroProt; } if (protocoloNew.xmlProt != null && protocoloNew.xmlProt != "") { protocoloCurrent.xmlProt = protocoloNew.xmlProt; } if (protocoloNew.baseEnv != null && protocoloNew.baseEnv != "") { protocoloCurrent.baseEnv = protocoloNew.baseEnv; } if (protocoloNew.dtenvio != null && protocoloNew.dtenvio != "") { protocoloCurrent.dtenvio = protocoloNew.dtenvio; } if (protocoloNew.hrenvio != null && protocoloNew.hrenvio != "") { protocoloCurrent.hrenvio = protocoloNew.hrenvio; } if (protocoloNew.status != null && protocoloNew.status != "") { protocoloCurrent.status = protocoloNew.status; } return(protocoloCurrent); }
public void ConsultaDB() { var sessao = AuxiliarNhibernate.AbrirSessao(); ProtocoloDB_DAO ProtocoloDAO = new ProtocoloDB_DAO(sessao); var lista = ProtocoloDAO.BuscaConsulta(); if (lista.Count > 0) { foreach (var item in lista) { if (item.driver == StaticParametersDB.GetDriver()) { var apiConXMLDB = new ConsultaXML(StaticParametersDB.GetGrupo(), StaticParametersDB.GetToken()); var retorno = apiConXMLDB.ConsultaProtocolo(item.nroProt, item.baseEnv, item.id); try { if (proc.VerificaConsultaXML(retorno) == true) { proc.GeraLogConsultaXML(item.id, retorno, item.nroProt, 2); if (proc.VerificaSeTemRecibo(retorno, item.id) == true) { var xmlRec = proc.ExtraiXMLRecibo(item.id, retorno); var nrRec = proc.ExtraiInfoXML(xmlRec, "nrRecibo"); var nrProtgov = proc.ExtraiInfoXML(xmlRec, "protocoloEnvioLote"); var data = proc.RetornaData(); var prot = new ProtocoloDB { id = item.id, xmlRec = xmlRec, nroRec = nrRec, consultado = true, dtconsulta = data[0], hrconsulta = data[1], nroProtGov = nrProtgov, status = "2 - Aprovado", idDB = StaticParametersDB.GetId() }; ProtocoloDAO.Salvar(prot); } else { var erros = proc.ExtraiErrosXmlDB(retorno, item.id); if (!erros.Equals("")) { var data = proc.RetornaData(); var prot = new ProtocoloDB { id = item.id, erros = erros, consultado = true, dtconsulta = data[0], hrconsulta = data[1], status = "3 - Rejeitado", idDB = StaticParametersDB.GetId() }; ProtocoloDAO.Salvar(prot); } else { throw new Exception($"Erro na consulta do item {item.id}, Retorno: {retorno}"); } } } else { var data = proc.RetornaData(); var prot = new ProtocoloDB { id = item.id, dtconsulta = data[0], hrconsulta = data[1], status = "1 - Aguardando Governo/iVeS", idDB = StaticParametersDB.GetId() }; ProtocoloDAO.Salvar(prot); Banco.CustomUpdateDB(ProtocoloDAO.BuscarPorIDEvento(item.id), 4); } } catch (Exception e) { ex.Exception(e.Message, item.id, "Consulta", "Tente consultar novamente em alguns minutos", e); } } } } proc.RemoveFileBuffer(); 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 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); } } }
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); }
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(); } } }