protected void RegistrarLog(Exception ex, OperacoesSAP operacao, int IdTransacaoSap = 0) { var SQL = new StringBuilder(); SQL.AppendLine("INSERT INTO dbo.tb_sap_erros(id_transacao_sap, metodo, mensagem)"); SQL.AppendFormat("VALUES({0}, '{1}', '{2}')", IdTransacaoSap, operacao.ToString(), ex.Message); try { var result = ExecutaSQL(SQL.ToString()); } catch (Exception e) { throw e; } }
protected void RegistrarSolicitacao(int transacao_sap, OperacoesSAP operacao, int id_grv = 0, int id_atendimento = 0, int id_lote = 0) { var SQL = new StringBuilder(); var teste = ConsultaSQL("select db_name()"); SQL.AppendLine("INSERT INTO dbo.tb_sap_solicitacao(id_transacao_sap, operacao, id_grv, id_atendimento, id_lote)"); SQL.AppendFormat("VALUES({0}, '{1}', {2}, {3}, {4})", transacao_sap, operacao.ToString(), id_grv, id_atendimento, id_lote); try { var result = ExecutaSQL(SQL.ToString()); } catch (Exception) { throw; } }