public async Task <Response> AddAuditEntry(EventType eventType, EventId eventId, string message) { try { if (!IsAuditLogEnabled()) { return(new FailedResponse("Audit Log is disabled.")); } var ui = GetUsernameAndIp(); // Truncate data so that SQL won't blow up if (message.Length > 256) { message = message.Substring(0, 256); } string machineName = Environment.MachineName; if (machineName.Length > 32) { machineName = machineName.Substring(0, 32); } var auditEntry = new AuditEntry(eventType, eventId, ui.Username, ui.Ipv4, machineName, message); var connStr = _configuration.GetConnectionString(Constants.DbConnectionName); //await using var conn = new SqlConnection(connStr); await using var conn = new MySqlConnection(connStr); //var sql = @"INSERT INTO AuditLog([EventId],[EventType],[EventTimeUtc],[WebUsername],[IpAddressV4],[MachineName],[Message]) // VALUES(@EventId, @EventType, @EventTimeUtc, @Username, @IpAddressV4, @MachineName, @Message)"; var sql = @"INSERT INTO AuditLog(EventId,EventType,EventTimeUtc,WebUsername,IpAddressV4,MachineName,Message) VALUES(@EventId, @EventType, @EventTimeUtc, @Username, @IpAddressV4, @MachineName, @Message)"; int rows = await conn.ExecuteAsync(sql, auditEntry); return(new Response(rows > 0)); } catch (Exception e) { _logger.LogError(e, e.Message); return(new FailedResponse((int)ResponseFailureCode.GeneralException, e.Message, e)); } }
public async Task AddAuditEntry(EventType eventType, AuditEventId auditEventId, string message) { try { if (!await IsAuditLogEnabled()) { return; } (string username, string ipv4) = GetUsernameAndIp(); // Truncate data so that SQL won't blow up if (message.Length > 256) { message = message.Substring(0, 256); } string machineName = Environment.MachineName; if (machineName.Length > 32) { machineName = machineName.Substring(0, 32); } var auditEntry = new AuditEntry(eventType, auditEventId, username, ipv4, machineName, message); var connStr = _configuration.GetConnectionString(Constants.DbConnectionName); await using var conn = new SqlConnection(connStr); var sql = @"INSERT INTO AuditLog([EventId],[EventType],[EventTimeUtc],[WebUsername],[IpAddressV4],[MachineName],[Message]) VALUES(@EventId, @EventType, @EventTimeUtc, @Username, @IpAddressV4, @MachineName, @Message)"; await conn.ExecuteAsync(sql, auditEntry); } catch (Exception e) { _logger.LogError(e, e.Message); } }