public static void CreateLogFromApiException(HttpActionExecutedContext context)
        {
            using (var connection = ConnectionConfiguration.GetOpenConnection(LoggaConfiguration._connectionString))
            {
                var error = new LoggaEntry
                {
                    // ErrorLogId = Guid.NewGuid(),
                    Source         = context.Exception.Source,
                    Target         = context.Request.RequestUri.ToString(),
                    Type           = context.Exception.GetType().Name,
                    Message        = context.Exception.Message,
                    StackTrace     = context.Exception.StackTrace,
                    DateError      = DateTime.Now,
                    Host           = ((HttpContextWrapper)context.Request.Properties["MS_HttpContext"]).Request.UserHostName.ToString(),
                    InnerException = context.Exception.InnerException != null?context.Exception.InnerException.ToString() : "null"
                };

                if (context.ActionContext.ControllerContext.RequestContext.Principal.Identity.IsAuthenticated)
                {
                    error.User = context.ActionContext.ControllerContext.RequestContext.Principal.Identity.Name;
                }
                ;

                string processQuery = "INSERT INTO LoggaEntry VALUES (@DateError, @Source, @Target, @Type, @Message, @StackTrace, @User, @Host, @InnerException)";
                connection.Execute(processQuery, error);
            }
        }
        public static void CreateLogFromException(ExceptionContext exception)
        {
            using (var connection = ConnectionConfiguration.GetOpenConnection(LoggaConfiguration._connectionString))
            {
                var error = new LoggaEntry
                {
                    // ErrorLogId = Guid.NewGuid(),
                    Source         = exception.Exception.Source,
                    Target         = exception.HttpContext.Request.Url.ToString(),
                    Type           = exception.Exception.GetType().Name,
                    Message        = exception.Exception.Message,
                    StackTrace     = exception.Exception.StackTrace,
                    DateError      = DateTime.Now,
                    Host           = exception.HttpContext.Server.MachineName,
                    InnerException = exception.Exception.InnerException != null?exception.Exception.InnerException.ToString() : "null"
                };

                if (exception.HttpContext.User.Identity.IsAuthenticated)
                {
                    error.User = exception.HttpContext.User.Identity.Name;
                }
                ;

                string processQuery = "INSERT INTO LoggaEntry VALUES (@DateError, @Source, @Target, @Type, @Message, @StackTrace, @User, @Host, @InnerException)";
                connection.Execute(processQuery, error);
            }
        }
 public static void SaveLog(LoggaEntry entry)
 {
     using (var connection = ConnectionConfiguration.GetOpenConnection(LoggaConfiguration._connectionString))
     {
         string processQuery = "INSERT INTO LoggaEntry VALUES (@DateError, @Source, @Target, @Type, @Message, @StackTrace, @User, @Host, @InnerException)";
         connection.Execute(processQuery, entry);
     }
 }