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, ConexaoGuardian.Conexao()); }