public void Create(SecurityLogEntry logEntry) { _sqlObjectFactory.GetConnection().Using(c => c.Command("INSERT INTO pf_SecurityLog (SecurityLogType, UserID, TargetUserID, IP, Message, ActivityDate) VALUES (@SecurityLogType, @UserID, @TargetUserID, @IP, @Message, @ActivityDate)") .AddParameter("@SecurityLogType", logEntry.SecurityLogType) .AddParameter("@UserID", logEntry.UserID.GetObjectOrDbNull()) .AddParameter("@TargetUserID", logEntry.TargetUserID.GetObjectOrDbNull()) .AddParameter("@IP", logEntry.IP) .AddParameter("@Message", logEntry.Message) .AddParameter("@ActivityDate", logEntry.ActivityDate) .ExecuteNonQuery()); }
public void Create() { var service = GetService(); SecurityLogEntry entry = null; _securityLogRepo.Setup(s => s.Create(It.IsAny <SecurityLogEntry>())).Callback <SecurityLogEntry>(e => entry = e); service.CreateLogEntry(new User(1, DateTime.MinValue), new User(2, DateTime.MinValue), "123", "msg", SecurityLogType.Undefined); Assert.Equal(1, entry.UserID); Assert.Equal(2, entry.TargetUserID); Assert.Equal("123", entry.IP); Assert.Equal("msg", entry.Message); Assert.Equal(SecurityLogType.Undefined, entry.SecurityLogType); }
public async Task Create() { var service = GetService(); SecurityLogEntry entry = null; _securityLogRepo.Setup(s => s.Create(It.IsAny <SecurityLogEntry>())).Callback <SecurityLogEntry>(e => entry = e); await service.CreateLogEntry(new User { UserID = 1 }, new User { UserID = 2 }, "123", "msg", SecurityLogType.Undefined); Assert.Equal(1, entry.UserID); Assert.Equal(2, entry.TargetUserID); Assert.Equal("123", entry.IP); Assert.Equal("msg", entry.Message); Assert.Equal(SecurityLogType.Undefined, entry.SecurityLogType); }
public async Task CreateLogEntry(int?userID, int?targetUserID, string ip, string message, SecurityLogType securityLogType, DateTime timeStamp) { if (ip == null) { throw new ArgumentNullException("ip"); } if (message == null) { throw new ArgumentNullException("message"); } var entry = new SecurityLogEntry { UserID = userID, TargetUserID = targetUserID, ActivityDate = timeStamp, IP = ip, Message = message, SecurityLogType = securityLogType }; await _securityLogRepository.Create(entry); }
public void Create(SecurityLogEntry logEntry) { _sqlObjectFactory.GetConnection().Using(connection => connection.Execute("INSERT INTO pf_SecurityLog (SecurityLogType, UserID, TargetUserID, IP, Message, ActivityDate) VALUES (@SecurityLogType, @UserID, @TargetUserID, @IP, @Message, @ActivityDate)", new { logEntry.SecurityLogType, logEntry.UserID, logEntry.TargetUserID, logEntry.IP, logEntry.Message, logEntry.ActivityDate })); }