public static void Log_Rotina(string nomeRotina, Tipo tipo, string textoLivre)
{
LogRotina logRotina = new LogRotina
{
Origem = "APLICACAO",
Data = DateTime.Now.ToString("yyyyMMdd"),
Hora = DateTime.Now.ToString("HH:mm:ss"),
Tipo = tipo.ToString(),
Rotina = nomeRotina,
Log = textoLivre,
};
LogDAO logDAO = new LogDAO();
logDAO.RegistrarLogRotina(logRotina, ConexaoERP.Conexao());
}
public void RegistrarLogRotina(LogRotina logRotina, string conexao)
{
if (!Log_Config.LogRotina)
{
return;
}
byte[] log = Encoding.UTF8.GetBytes(guardian_Util.FormatarCaracter(logRotina.Log));
string query =
"INSERT INTO " + Tabelas_Guardian.ZA0 + " " +
"(ZA0_ORIGEM, ZA0_DATA, ZA0_HORA, ZA0_TIPO, ZA0_ROTINA, ZA0_LOG) " +
"VALUES (" +
"'" + logRotina.Origem + "', " +
"'" + logRotina.Data + "', " +
"'" + logRotina.Hora + "', " +
"'" + logRotina.Tipo + "', " +
"'" + logRotina.Rotina + "', " +
"@log " +
")";
try
{
using (SqlConnection connection = new SqlConnection(conexao))
{
using (SqlCommand command = new SqlCommand(query, connection))
{
connection.Open();
command.Parameters.AddWithValue("@log", log);
command.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
Guardian_LogTxt.LogAplicacao("Registrar Log Rotina ", "Erro " + ex.ToString() + Environment.NewLine + " Status: " + Log_Config.LogRotina + " Query: " + query);
}
}