public IEnumerable <AuditLog> GetLog(AuditType logType, DateTime?sinceDate = null)
{
var result = _auditService.GetLogs(Enum <AuditType> .Parse(logType.ToString()), sinceDate);
var mapped = _umbracoMapper.MapEnumerable <IAuditItem, AuditLog>(result);
return(mapped);
}
public IEnumerable <AuditLog> GetLog(AuditType logType, DateTime?sinceDate)
{
if (sinceDate == null)
{
sinceDate = DateTime.Now.Subtract(new TimeSpan(7, 0, 0, 0, 0));
}
return(Mapper.Map <IEnumerable <AuditLog> >(
Log.Instance.GetLogItems(Enum <LogTypes> .Parse(logType.ToString()), sinceDate.Value)));
}
public IEnumerable <IAuditItem> Get(AuditType type, IQuery <IAuditItem> query)
{
var sqlClause = GetBaseQuery(false)
.Where <LogDto>(x => x.Header == type.ToString());
var translator = new SqlTranslator <IAuditItem>(sqlClause, query);
var sql = translator.Translate();
var dtos = Database.Fetch <LogDto>(sql);
return(dtos.Select(x => new AuditItem(x.NodeId, Enum <AuditType> .Parse(x.Header), x.UserId ?? Constants.Security.UnknownUserId, x.EntityType, x.Comment, x.Parameters)).ToList());
}
private void Audit(AuditType type, int userId, string description = null)
{
AuditDataObject audit = new AuditDataObject
{
LoginUserId = userId,
AuditTypeKey = type.ToString(),
Description = description
};
ProcessFactory.GetAuditProcess().Insert(audit);
}
private void Audit(AuditType type, string description)
{
AuditDataObject audit = new AuditDataObject
{
AuditTypeKey = type.ToString(),
Description = description,
LoginUserId = UserId
};
ProcessFactory.GetAuditProcess().Insert(audit);
}
public Audit ToAudit()
{
var audit = new Audit();
audit.UserId = UserId;
audit.Type = AuditType.ToString();
audit.TableName = TableName;
audit.DateTime = DateTime.Now;
audit.PrimaryKey = JsonConvert.SerializeObject(KeyValues);
audit.OldValues = OldValues.Count == 0 ? null : JsonConvert.SerializeObject(OldValues);
audit.NewValues = NewValues.Count == 0 ? null : JsonConvert.SerializeObject(NewValues);
audit.AffectedColumns = ChangedColumns.Count == 0 ? null : JsonConvert.SerializeObject(ChangedColumns);
return(audit);
}
public override void OnActionExecuted(ActionExecutedContext filterContext)
{
if (IsValid() && filterContext.HttpContext.User is UserPrincipal)
{
UserPrincipal user = filterContext.HttpContext.User as UserPrincipal;
AuditDataObject audit = new AuditDataObject
{
LoginUserId = user.Id,
AuditTypeKey = auditType.ToString(),
Description = description
};
ProcessFactory.GetAuditProcess().Insert(audit);
}
}
/// <summary>
/// Create an audit of an event
/// </summary>
public static void Log(Entities ctx, AuditType type, string source, string message, int systemUserID)
{
var dataSource = new AUDITLOG()
{
AUDITTYPE = type.ToString(),
DESCRIPTION = message,
SOURCE = source,
URL = "",
CREATEDON = DateTime.Now,
DELETED = 0,
SYSTEMUSERID = systemUserID
};
ctx.AddToAUDITLOGs(dataSource);
}
public Audit ToAudit()
{
return(new Audit
{
UserId = UserId,
UserName = UserName,
Type = AuditType.ToString(),
TableName = TableName,
DateTime = DateTime.Now,
PrimaryKey = JsonConvert.SerializeObject(KeyValues),
OldValues = OldValues.Count == 0 ? null : JsonConvert.SerializeObject(OldValues),
NewValues = NewValues.Count == 0 ? null : JsonConvert.SerializeObject(NewValues),
AffectedColumns = ChangedColumns.Count == 0 ? null : JsonConvert.SerializeObject(ChangedColumns)
});
}
/// <summary>
/// Create an audit of an event
/// </summary>
public static void Log(Entities ctx, AuditType type, string source, string message, int systemUserID)
{
var dataSource = new AUDITLOG()
{
AUDITTYPE = type.ToString(),
DESCRIPTION = message,
SOURCE = source,
URL = HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath,
CREATEDON = DateTime.Now,
DELETED = 0,
SYSTEMUSERID = systemUserID
};
ctx.AddToAUDITLOGs(dataSource);
}
public override void OnActionExecuted(ActionExecutedContext filterContext)
{
if (IsValid() && IdeaId != 0 && filterContext.HttpContext.User is UserPrincipal)
{
UserPrincipal user = filterContext.HttpContext.User as UserPrincipal;
AuditDataObject audit = new AuditDataObject
{
IdeaId = IdeaId,
LoginUserId = user.Id,
AuditTypeKey = auditType.ToString(),
Description = auditType == AuditType.FILE_DOWNLOAD ? FileId.ToString() : null
};
ProcessFactory.GetAuditProcess().Insert(audit);
}
}
public tbl_test_audit_trail ToAudit()
{
var audit = new tbl_test_audit_trail();
audit.audit_datetime_utc = DateTime.UtcNow;
audit.audit_type = AuditType.ToString();
audit.audit_user = AuditUser;
audit.table_name = TableName;
audit.key_values = JsonConvert.SerializeObject(KeyValues);
audit.old_values = OldValues.Count == 0 ?
null : JsonConvert.SerializeObject(OldValues);
audit.new_values = NewValues.Count == 0 ?
null : JsonConvert.SerializeObject(NewValues);
audit.changed_columns = ChangedColumns.Count == 0 ?
null : JsonConvert.SerializeObject(ChangedColumns);
return(audit);
}
public Audit ToAudit()
{
var audit = new Audit
{
ID = Guid.NewGuid(),
AuditDateTimeUtc = DateTime.UtcNow,
AuditType = AuditType.ToString(),
AuditUser = AuditUser,
TableName = TableName,
KeyValues = JsonConvert.SerializeObject(KeyValues),
OldValues = OldValues.Count == 0 ?
null : JsonConvert.SerializeObject(OldValues),
NewValues = NewValues.Count == 0 ?
null : JsonConvert.SerializeObject(NewValues),
ChangedColumns = ChangedColumns.Count == 0 ?
null : JsonConvert.SerializeObject(ChangedColumns)
};
return(audit);
}
public override void OnActionExecuted(ActionExecutedContext filterContext)
{
if (IsValid()
&&
(
UserId != null ||
auditType == AuditType.USER_PROFILE_UPDATE ||
auditType == AuditType.PASSWORD_RESET ||
auditType == AuditType.USER_LOGOUT
) &&
filterContext.HttpContext.User is UserPrincipal)
{
UserPrincipal loggedInUser = filterContext.HttpContext.User as UserPrincipal;
AuditDataObject audit = new AuditDataObject
{
LoginUserId = loggedInUser.Id,
UpdateUserId = UserId,
AuditTypeKey = auditType.ToString(),
Description = Description
};
ProcessFactory.GetAuditProcess().Insert(audit);
}
}
public static void LogCustomAction(List <string> messages, object data, AuditType auditType)
{
using (IDataAccessAdapter adapter = GetAdapter())
Auditor.LogCustomAction <Auditor>(adapter, messages, data, (int)auditType, auditType.ToString());
}