public DataSet GetAuditLogRecordsPaged(int userId, int packageId, int itemId, string itemName, DateTime startDate, DateTime endDate, int severityId, string sourceName, string taskName, string sortColumn, int startRow, int maximumRows) { return(AuditLog.GetAuditLogRecordsPaged(userId, packageId, itemId, itemName, startDate, endDate, severityId, sourceName, taskName, sortColumn, startRow, maximumRows)); }
public override void DoWork() { BackgroundTask topTask = TaskManager.TopTask; // get input parameters string mailTo = (string)topTask.GetParamValue("MAIL_TO"); int auditLogSeverity = Utils.ParseInt((string)topTask.GetParamValue("AUDIT_LOG_SEVERITY"), -1); string auditLogSource = (string)topTask.GetParamValue("AUDIT_LOG_SOURCE"); string auditLogTask = (string)topTask.GetParamValue("AUDIT_LOG_TASK"); string auditLogDate = (string)topTask.GetParamValue("AUDIT_LOG_DATE"); int showExecutionLog = Utils.ParseInt((string)topTask.GetParamValue("SHOW_EXECUTION_LOG"), 0); // check input parameters if (String.IsNullOrEmpty(mailTo)) { TaskManager.WriteWarning("Specify 'Mail To' task parameter"); return; } string mailFrom = null; SystemSettings settings = SystemController.GetSystemSettingsInternal(SystemSettings.SMTP_SETTINGS, false); if (settings != null) { mailFrom = settings["SmtpUsername"]; } if (String.IsNullOrEmpty(mailFrom)) { TaskManager.WriteWarning("You need to configure SMTP settings first"); return; } DateTime logStart, logEnd; switch (auditLogDate) { case "today": logStart = DateTime.Now; logEnd = DateTime.Now; break; case "yesterday": logStart = DateTime.Now.AddDays(-1); logEnd = DateTime.Now.AddDays(-1); break; case "schedule": default: logEnd = DateTime.Now; ScheduleInfo schedule = SchedulerController.GetSchedule(topTask.ScheduleId); switch (schedule.ScheduleTypeId) { case "Daily": logStart = DateTime.Now.AddDays(-1); break; case "Weekly": logStart = DateTime.Now.AddDays(-7); break; case "Monthly": logStart = DateTime.Now.AddMonths(-1); break; case "Interval": logStart = DateTime.Now.AddSeconds(-schedule.Interval); break; case "OneTime": default: logStart = DateTime.Now; break; } break; } string mailSubject = "Audit Log Report (" + logStart.ToString("MMM dd, yyyy") + " - " + logEnd.ToString("MMM dd, yyyy") + ")"; StringBuilder sb = new StringBuilder(); sb.AppendLine("<html><head><style>"); sb.AppendLine("table, th, td { border: 1px solid black; border-collapse: collapse; }"); sb.AppendLine("th, td { padding: 5px; }"); sb.AppendLine("th { text-align: left; }"); sb.AppendLine("</style></head><body>"); sb.AppendLine("<h2>" + mailSubject + "</h2>"); sb.AppendFormat("<h3>Source: {0}, Task: {1}, Severity: {2}</h3>", String.IsNullOrEmpty(auditLogSource) ? "All" : auditLogSource, String.IsNullOrEmpty(auditLogTask) ? "All" : auditLogTask, GetAuditLogRecordSeverityName(auditLogSeverity)); DataTable logs = AuditLog.GetAuditLogRecordsPaged(topTask.EffectiveUserId, 0, 0, null, logStart, logEnd, auditLogSeverity, auditLogSource, auditLogTask, "", 0, Int32.MaxValue).Tables[1]; sb.AppendLine("<p>"); if (logs.Rows.Count == 0) { sb.AppendLine("Audit Log is empty."); } else { sb.AppendLine("<table>"); sb.Append("<tr><th>Started</th><th>Finished</th><th>Severity</th><th>Username</th><th>Source</th><th>Task</th><th>Item-Name</th>"); if (showExecutionLog == 1) { sb.AppendLine("<th>Execution-Log</th></tr>"); } else { sb.AppendLine("</tr>"); } foreach (DataRow log in logs.Rows) { sb.AppendLine("<tr>"); // Started sb.AppendFormat("<td>{0}</td>", log["StartDate"].ToString()); // Finished sb.AppendFormat("<td>{0}</td>", log["FinishDate"].ToString()); // Severity sb.AppendFormat("<td>{0}</td>", GetAuditLogRecordSeverityName((int)log["SeverityID"])); // Username sb.AppendFormat("<td>{0}</td>", log["Username"]); // Source sb.AppendFormat("<td>{0}</td>", log["SourceName"]); // Task sb.AppendFormat("<td>{0}</td>", log["TaskName"]); // Item-Name sb.AppendFormat("<td>{0}</td>", log["ItemName"]); // Execution-Log if (showExecutionLog == 1) { string executionLog = FormatPlainTextExecutionLog(log["ExecutionLog"].ToString()); sb.AppendFormat("<td>{0}</td>", executionLog); } sb.AppendLine("</tr>"); } sb.AppendLine("</table>"); } sb.AppendLine("</p></body></html>"); // send mail message int res = MailHelper.SendMessage(mailFrom, mailTo, mailSubject, sb.ToString(), true); if (res != 0) { TaskManager.WriteError("SMTP Error. Code: " + res.ToString()); } }