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)); }