public void RegistrarLogAuditoria(LogAuditoria logAuditoria, string conexao)
{
if (!Log_Config.LogAuditoria)
{
return;
}
string query =
"INSERT INTO " + Tabelas_Guardian.LogAuditoria + " " +
"(NOME_ROTINA, DATA, HORA, ACAO, VALOR, CLIENTE) " +
"VALUES ( " +
"'" + logAuditoria.NomeRotina + "', " +
"'" + logAuditoria.Data + "'," +
"'" + logAuditoria.Hora + "', " +
"'" + logAuditoria.Acao + "', " +
"'" + Convert.ToDouble(logAuditoria.Valor) + "', " +
"'" + logAuditoria.Cliente + "' )";
try
{
using (SqlConnection connection = new SqlConnection(conexao))
{
using (SqlCommand command = new SqlCommand(query, connection))
{
connection.Open();
command.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
Guardian_LogTxt.LogAplicacao("Registrar Log Auditoria ", "Erro " + ex.ToString() + Environment.NewLine + " Status: " + Log_Config.LogAuditoria + " Query: " + query);
}
}
public static void Log_Auditoria(string nomeRotina, Acao acao, double valor)
{
LogAuditoria logAuditoria = new LogAuditoria
{
NomeRotina = nomeRotina,
Data = DateTime.Now.ToString("yyyyMMdd"),
Hora = DateTime.Now.ToString("HH:mm:ss.fff"),
Acao = acao.ToString(),
Valor = valor,
Cliente = Service_Config.NomeCliente
};
LogDAO logDAO = new LogDAO();
logDAO.RegistrarLogAuditoria(logAuditoria, ConexaoGestor.Conexao());
}