public int AuditLogSave(AuditLog audit_log)
{
if (audit_log == null)
{
throw new ArgumentNullException(nameof(audit_log));
}
return(ExecuteFaultHandledOperation(() =>
{
AuditLogData prod_data = _audit_log_es.Map(audit_log);
return _audit_log_repo.Insert(prod_data);
}));
}
} // Map function closer
public List <SqlParameter> MapParamsForUpsert(AuditLogData entity)
{
var sql_params = new List <SqlParameter>();
sql_params.Add(new SqlParameter("@audit_log_key", entity.AuditLogKey));
sql_params.Add(new SqlParameter("@audit_action", entity.AuditAction));
sql_params.Add(new SqlParameter("@audit_bus_obj", entity.AuditBusObj));
sql_params.Add(new SqlParameter("@audit_datetime", entity.AuditDatetime));
sql_params.Add(new SqlParameter("@audit_user_id", entity.AuditUserId));
sql_params.Add(new SqlParameter("@audit_app_name", entity.AuditAppName));
sql_params.Add(new SqlParameter("@audit_host_name", entity.AuditHostName));
sql_params.Add(new SqlParameter("@audit_comment", entity.AuditComment));
sql_params.Add(new SqlParameter("@audit_data_old", entity.AuditDataOld));
sql_params.Add(new SqlParameter("@audit_data_new", entity.AuditDataNew));
sql_params.Add(GetOutParam());
return(sql_params);
}
private string UpdateEmailBodyPlaceHolder(string htmlBody, Notification notification)
{
AuditLogData auditNotification = (AuditLogData)notification;
StringBuilder auditLogEntries = new StringBuilder();
for (int i = 0; i < Math.Min(this.logsCount, auditNotification.AuditLogs.Count()); i++)
{
auditLogEntries.Append("<tr>");
auditLogEntries.Append(string.Format("<td>{0}</td>", auditNotification.AuditLogs.ElementAt(i).AuditId));
auditLogEntries.Append(string.Format("<td>{0}</td>", auditNotification.AuditLogs.ElementAt(i).Message));
auditLogEntries.Append(string.Format("<td>{0}</td>", auditNotification.AuditLogs.ElementAt(i).TransactionId));
auditLogEntries.Append("</tr>");
}
htmlBody = htmlBody.Replace("{ScanTime}", auditNotification.ValidTo.ToString());
htmlBody = htmlBody.Replace("{LogEntries}", auditLogEntries.ToString());
return(htmlBody);
}
public AuditLog Map(AuditLogData audit_log_data)
{
return(new AuditLog()
{
AuditLogKey = audit_log_data.AuditLogKey,
AuditAction = audit_log_data.AuditAction,
AuditBusinessObject = audit_log_data.AuditBusObj,
AuditDateTime = audit_log_data.AuditDatetime,
AuditUserID = audit_log_data.AuditUserId,
AuditApplicationName = audit_log_data.AuditAppName,
AuditHostName = audit_log_data.AuditHostName,
AuditComment = audit_log_data.AuditComment,
AuditOldDataXML = audit_log_data.AuditDataOld,
AuditNewDataXML = audit_log_data.AuditDataNew,
AddedUserID = audit_log_data.AuditAddUserId,
AddedDateTime = audit_log_data.AuditAddDatetime,
UpdateUserID = audit_log_data.AuditUpdateUserId,
UpdateDateTime = audit_log_data.AuditUpdateDatetime,
});
}
public void AuditObject(string service_name, string comment, object obj_to_audit)
{
if (obj_to_audit == null)
{
return;
}
XmlSerializer serializer = GetSerializer(obj_to_audit);
string xml;
try
{
using (StringWriter text_writer = new StringWriter())
{
serializer.Serialize(text_writer, obj_to_audit);
xml = text_writer.ToString();
}
AuditLogData audit_entry = new AuditLogData()
{
AuditLogKey = 0,
AuditAction = "S",
AuditDatetime = DateTime.Now,
AuditAppName = $"App=({service_name})",
AuditUserId = $"{Environment.UserDomainName}\\{Environment.UserName}",
AuditBusObj = obj_to_audit.ToString().Replace("QIQO.Business.Entities.", ""),
AuditHostName = Environment.MachineName,
AuditComment = $"Object {obj_to_audit.ToString()} read from database via {comment}",
AuditDataOld = "",
AuditDataNew = xml
};
int audit_log_key = _audit_log_repo.Insert(audit_entry);
}
catch (Exception ex)
{
DumpException(ex);
}
}
public List <SqlParameter> MapParamsForDelete(AuditLogData entity)
{
return(MapParamsForDelete(entity.AuditLogKey));
}
