How to implement an update LOG with ASP.NET MVC?

Question

I would like ideas on how to implement a generic update LOG in DB (Entity Framework 6+) that allows me to discover information such as: System X user at date Y changed name and date of birth (from, to) in customer registration.

I think it is possible to implement something like this in a generic way, without having to create log entries for each action in each controller, using Actionfilter and/or Entityframework Interceptor.

Answer 1

Step 1. Create a Model to register the shares

namespace SeuProjeto.Models 
{
    public class ActionsLog 
    {
        [Key]
        public Guid ActionsLogId { get; set; }
        public String Controller { get; set; }
        public String Action { get; set; }
        public String Ip { get; set; }
        public DateTime DateAndTime { get; set; }
        // Coloque aqui os campos extras que deseja usar para o registro
    }
}

Step 2. Implement a Filter derived from ActionFilter

namespace SeuProjeto.Filters 
{
    public class CustomActionFilter : ActionFilterAttribute, IActionFilter
    {
        void IActionFilter.OnActionExecuting(ActionExecutingContext filterContext)
        {
            // Coloque aqui algumas regras de negócio que quiser antes de fazer o log.

            // Aqui é o registro propriamente dito
            var contexto = new MeuProjetoContext();

            var log = new ActionsLog()
            {
                ActionsLogId = Guid.NewGuid(),
                Controller = filterContext.ActionDescriptor.ControllerDescriptor.ControllerName,
                Action = filterContext.ActionDescriptor.ActionName + " (Logged By: Custom Action Filter)",
                Ip = filterContext.HttpContext.Request.UserHostAddress,
                DateAndTime = filterContext.HttpContext.Timestamp
                // Coloque aqui os campos extras para inclusão
            };

            contexto.ActionsLogs.Add(log);
            contexto.SaveChanges();

            this.OnActionExecuting(filterContext);
        }
    }
}

Step 3. Register your ActionFilter in the Controller desired

[CustomActionFilter]
public class MeuController : Controller
{
    ...
}

Or decorate the Actions individually

[CustomActionFilter]
public ActionResult Index()
{
  ...
}

[CustomActionFilter]
public ActionResult Search(string term)
{
  ...
}