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