protected string GetValueDescription(AuditEvent auditEvent, int valueTypeId, AuditEventValueTypeRepository auditEventValueTypeRepository, List <AuditEventValueConverter> valueConverters) { string eventDescription = ""; AuditEventValue auditEventValue = auditEvent.GetValueByValueTypeId(valueTypeId); if (auditEventValue != null && auditEventValue.Value != null) { AuditEventValueType auditEventValueType = auditEventValueTypeRepository.GetByID(auditEventValue.TypeID); AuditEventValueConverter auditEventValueConverter = valueConverters.Find(current => current.Handles(auditEventValue.TypeID)); if (auditEventValueConverter != null) // Sanity check { eventDescription = auditEventValueConverter.ValueConverter.Convert(auditEventValue.Value, auditEventValueType.Type, typeof(String)).ToString(); } } return(eventDescription); }
/// <summary> /// Posts message to MS Teams channel /// </summary> /// <param name="auditEvent"></param> /// <param name="auditEventType"></param> /// <param name="postMessageSettings"></param> public void PostMessage(AuditEvent auditEvent, AuditEventType auditEventType, MSTeamsPostMessageSettings postMessageSettings) { AuditEventValueTypeRepository auditEventValueTypeRepository = new AuditEventValueTypeRepository(); //Get Message value AuditEventValue auditEventValueMessage = auditEvent.GetValueByValueTypeId(AuditEventValueTypes.Message); AuditEventValue auditEventValueRunId = auditEvent.GetValueByValueTypeId(AuditEventValueTypes.GamePlanRunID); AuditEventValue auditEventValueScenarioId = auditEvent.GetValueByValueTypeId(AuditEventValueTypes.GamePlanScenarioID); AuditEventValue auditEventValueAutoBookId = auditEvent.GetValueByValueTypeId(AuditEventValueTypes.GamePlanAutoBookID); AuditEventValue auditEventValuePipelineErrorMessage = auditEvent.GetValueByValueTypeId(AuditEventValueTypes.GamePlanPipelineEventErrorMessage); // Determine if sub event is set string subEvent = ""; foreach (int valueTypeId in new int[] { AuditEventValueTypes.GamePlanPipelineEventID, AuditEventValueTypes.GamePlanAutoBookEventID }) { subEvent = GetValueDescription(auditEvent, valueTypeId, auditEventValueTypeRepository, _valueConverters); if (!String.IsNullOrEmpty(subEvent)) { break; } } StringBuilder title = new StringBuilder(auditEventType.Description); if (!String.IsNullOrEmpty(subEvent)) { title.Append(string.Format(" - {0}", subEvent)); } // Set Run/Scenario details Run run = null; StringBuilder message = new StringBuilder(title.ToString()); if (auditEventValueRunId != null || auditEventValueScenarioId != null) { using (var scope = _repositoryFactory.BeginRepositoryScope()) { var runRepository = scope.CreateRepository <IRunRepository>(); run = (auditEventValueRunId != null ? runRepository.Find((Guid)auditEventValueRunId.Value) : runRepository.FindByScenarioId((Guid)auditEventValueScenarioId.Value)); message.Append(message.Length == 0 ? "" : "; "); message.Append(string.Format("Description: {0}; Run ID: {1}", run.Description, MSTeamsMessageFormatter.FormatHyperlink(run.Id.ToString(), WebLinkFactory.GetRunDetailsURL(_frontendUrl, run.Id)))); if (auditEventValueScenarioId != null) { message.Append(message.Length == 0 ? "" : "; "); message.Append(string.Format("Scenario ID: {0}", MSTeamsMessageFormatter.FormatHyperlink(auditEventValueScenarioId.Value.ToString(), WebLinkFactory.GetOptimiserReportURL(_frontendUrl, run.Id, (Guid)auditEventValueScenarioId.Value)))); } } } // Set AutoBook details if (auditEventValueAutoBookId != null) { message.Append(message.Length == 0 ? "" : "; "); message.Append(string.Format("AutoBook ID: {0}", MSTeamsMessageFormatter.FormatHyperlink(auditEventValueAutoBookId.Value.ToString(), WebLinkFactory.GetAutoBookURL(_frontendUrl, (Guid)auditEventValueAutoBookId.Value)))); } // Set pipeline error if (auditEventValuePipelineErrorMessage != null) { message.Append(message.Length == 0 ? "" : "; "); message.Append(string.Format("Error: {0}", auditEventValuePipelineErrorMessage.Value.ToString())); } // Set message if (auditEventValueMessage != null) { message.Append(message.Length == 0 ? "" : "; "); message.Append(string.Format("Message: {0}", auditEventValueMessage.Value.ToString())); } // Post message _msTeamsREST.PostSimpleMessage(postMessageSettings.Url, "", message.ToString()); }
public MailMessage CreateEmail(AuditEvent auditEvent) { // Determine if we need to generate email EmailAuditEventSettings emailAuditEventSettings = _emailAuditEventSettingsList.Find(s => s.EventTypeId == auditEvent.EventTypeID); if (!Handles(auditEvent)) { return(null); } AuditEventValueTypeRepository auditEventValueTypeRepository = new AuditEventValueTypeRepository(); AuditEventType auditEventType = new AuditEventTypeRepository().GetByID(auditEvent.EventTypeID); // Determine if sub event is set string subEvent = ""; foreach (int valueTypeId in new int[] { AuditEventValueTypes.GamePlanPipelineEventID, AuditEventValueTypes.GamePlanAutoBookEventID }) { subEvent = GetValueDescription(auditEvent, valueTypeId, auditEventValueTypeRepository, _valueConverters); if (!String.IsNullOrEmpty(subEvent)) { break; } } MailMessage mail = new MailMessage(); if (!String.IsNullOrEmpty(subEvent)) // Sub event indicated { mail.Subject = string.Format("[{0}] {1}: {2}: {3}", _environmentId, Globals.ProductName, auditEventType.Description, subEvent); } else { mail.Subject = string.Format("[{0}] {1}: {2}", _environmentId, Globals.ProductName, auditEventType.Description); } mail.Sender = new MailAddress(emailAuditEventSettings.NotificationSettings.SenderAddress, emailAuditEventSettings.NotificationSettings.SenderAddress); mail.From = new MailAddress(emailAuditEventSettings.NotificationSettings.SenderAddress, emailAuditEventSettings.NotificationSettings.SenderAddress); mail.Body = GetBody(auditEvent, subEvent, _valueConverters, auditEventValueTypeRepository); mail.IsBodyHtml = mail.Body.ToLower().Contains("<html>") && (mail.Body.ToLower().Contains("<head>") || mail.Body.ToLower().Contains("<head/>")); // Check if specific email address indicated in audit event List <AuditEventValue> recipientAuditEventValues = new List <AuditEventValue>(); AuditEventValue recipientAuditEventValue = auditEvent.GetValueByValueTypeId(AuditEventValueTypes.RecipientEmailAddress); if (recipientAuditEventValue != null) { recipientAuditEventValues.Add(recipientAuditEventValue); } if (recipientAuditEventValues.Count == 0) { for (int index = 0; index < emailAuditEventSettings.NotificationSettings.RecipientAddresses.Count; index++) { mail.To.Add(new MailAddress(emailAuditEventSettings.NotificationSettings.RecipientAddresses[index], emailAuditEventSettings.NotificationSettings.RecipientAddresses[index])); } } else { foreach (AuditEventValue auditEventValue in recipientAuditEventValues) { mail.To.Add(new MailAddress(auditEventValue.Value.ToString())); } } if (emailAuditEventSettings.NotificationSettings.CCAddresses != null) { emailAuditEventSettings.NotificationSettings.CCAddresses.ForEach(address => mail.CC.Add(new MailAddress(address, address))); } /* * foreach (AuditEventValue auditEventValue in auditEvent.Values.Where(item => item.TypeID == AuditEventValueTypes.EmailAttachment)) * { * mail.Attachments.Add(new Attachment(auditEventValue.Value.ToString())); * } */ return(mail); }
private DataTable GetValuesDataTable(AuditEvent auditEvent, AuditEventType auditEventType, string subEvent, AuditEventValueTypeRepository auditEventValueTypeRepository) { DataTable dataTable = new DataTable(); dataTable.Columns.Add("Item", typeof(String)); dataTable.Columns.Add("Value", typeof(String)); // Add standard header AddValuesRow(dataTable, "Time", auditEvent.TimeCreated.ToString()); AddValuesRow(dataTable, "Event ID", auditEvent.ID); AddValuesRow(dataTable, "Event", string.IsNullOrEmpty(subEvent) ? auditEventType.Description : string.Format("{0} - {1}", auditEventType.Description, subEvent)); // Add other values HashSet <int> valueTypesDone = new HashSet <int>() { AuditEventValueTypes.GamePlanRunID, AuditEventValueTypes.GamePlanPipelineEventID, AuditEventValueTypes.GamePlanAutoBookEventID }; foreach (AuditEventValue auditEventValue in auditEvent.Values) { if (!valueTypesDone.Contains(auditEventValue.TypeID)) // Ignore values done above { AuditEventValueType auditEventValueType = auditEventValueTypeRepository.GetByID(auditEventValue.TypeID); if (!auditEventValueType.Internal) { AuditEventValueConverter auditEventValueConverter = _valueConverters.Find(current => current.Handles(auditEventValue.TypeID)); if (auditEventValueConverter != null) { AddValuesRow(dataTable, auditEventValueType.Description, auditEventValueConverter.ValueConverter.Convert(auditEventValue.Value, auditEventValueType.Type, typeof(String)).ToString()); } else { AddValuesRow(dataTable, auditEventValueType.Description, auditEventValue.Value.ToString()); } } } } return(dataTable); }
/// <summary> /// Returns email body. Email has header details (event type, event type etc) and table for each audit event value. /// </summary> /// <param name="auditEvent"></param> /// <returns></returns> private string GetBody(AuditEvent auditEvent, string subEvent, List <AuditEventValueConverter> valueConverters, AuditEventValueTypeRepository auditEventValueTypeRepository) { AuditEventType auditEventType = new AuditEventTypeRepository().GetByID(auditEvent.EventTypeID); StringBuilder html = new StringBuilder(string.Format("<html><head>{0}</head><body>", GetStyle())); html.Append("<table>"); //html.Append("<tr><th>Item</th><th>Value</th></tr>"); DataTable valuesDataTable = GetValuesDataTable(auditEvent, auditEventType, subEvent, auditEventValueTypeRepository); for (int rowIndex = 0; rowIndex < valuesDataTable.Rows.Count; rowIndex++) { html.Append(string.Format("<tr><td><B>{0}</B></td><td>{1}</td></tr>", valuesDataTable.Rows[rowIndex]["Item"].ToString(), valuesDataTable.Rows[rowIndex]["Value"].ToString())); } html.Append("</table>"); html.Append("</body>"); html.Append("</html>"); return(html.ToString()); }
/// <summary> /// Posts message to MS Teams channel /// </summary> /// <param name="auditEvent"></param> /// <param name="auditEventType"></param> /// <param name="postMessageSettings"></param> public void PostMessage(AuditEvent auditEvent, AuditEventType auditEventType, MSTeamsPostMessageSettings postMessageSettings) { AuditEventValueTypeRepository auditEventValueTypeRepository = new AuditEventValueTypeRepository(); //Get Message value AuditEventValue auditEventValueMessage = auditEvent.GetValueByValueTypeId(AuditEventValueTypes.Message); AuditEventValue auditEventValueRunId = auditEvent.GetValueByValueTypeId(AuditEventValueTypes.GamePlanRunID); AuditEventValue auditEventValueScenarioId = auditEvent.GetValueByValueTypeId(AuditEventValueTypes.GamePlanScenarioID); AuditEventValue auditEventValueAutoBookId = auditEvent.GetValueByValueTypeId(AuditEventValueTypes.GamePlanAutoBookID); // Determine if sub event is set string subEvent = ""; foreach (int valueTypeId in new int[] { AuditEventValueTypes.GamePlanPipelineEventID, AuditEventValueTypes.GamePlanAutoBookEventID }) { subEvent = GetValueDescription(auditEvent, valueTypeId, auditEventValueTypeRepository, _valueConverters); if (!String.IsNullOrEmpty(subEvent)) { break; } } List <string> detailsTextList = new List <string>(); List <string> detailsUrlList = new List <string>(); StringBuilder title = new StringBuilder(auditEventType.Description); if (!String.IsNullOrEmpty(subEvent)) { title.Append(string.Format(" - {0}", subEvent)); } // Set Run/Scenario details Run run = null; StringBuilder message = new StringBuilder(""); if (auditEventValueRunId != null || auditEventValueScenarioId != null) { using (var scope = _repositoryFactory.BeginRepositoryScope()) { var runRepository = scope.CreateRepository <IRunRepository>(); run = (auditEventValueRunId != null ? runRepository.Find((Guid)auditEventValueRunId.Value) : runRepository.FindByScenarioId((Guid)auditEventValueScenarioId.Value)); if (auditEventValueScenarioId == null) { // Set URL detailsUrlList.Add(WebLinkFactory.GetRunDetailsURL(_frontendUrl, run.Id)); detailsTextList.Add("Run Details"); } else { detailsUrlList.Add(WebLinkFactory.GetRunDetailsURL(_frontendUrl, run.Id)); detailsTextList.Add("Run Details"); // Set URL detailsUrlList.Add(WebLinkFactory.GetOptimiserReportURL(_frontendUrl, run.Id, (Guid)auditEventValueScenarioId.Value)); detailsTextList.Add("Scenario Details"); } } } // Set AutoBook details if (auditEventValueAutoBookId != null) { detailsUrlList.Add(WebLinkFactory.GetAutoBookURL(_frontendUrl, (Guid)auditEventValueAutoBookId.Value)); detailsTextList.Add("AutoBook Details"); } DataTable dataTable = GetValuesDataTable(auditEvent, run, auditEventType, subEvent, auditEventValueTypeRepository, _valueConverters); foreach (DataRow dataRow in dataTable.Rows) { message.Append(message.Length == 0 ? "" : "; "); //message.Append(message.Length == 0 ? "" : "<BR/>"); message.Append(string.Format("{0}: {1}", dataRow[0].ToString(), dataRow[1].ToString())); } // Post message _msTeamsREST.PostMessageCard(postMessageSettings.Url, "Title", title.ToString(), message.ToString(), detailsTextList, detailsUrlList); }
public MailMessage CreateEmail(AuditEvent auditEvent) { // Determine if we need to generate email if (!Handles(auditEvent)) { return(null); } using (var scope = _repositoryFactory.BeginRepositoryScope()) { EmailAuditEventSettings emailAuditEventSettings = _emailAuditEventSettingsList.Find(s => s.EventTypeId == auditEvent.EventTypeID); AuditEventValueTypeRepository auditEventValueTypeRepository = new AuditEventValueTypeRepository(); // Determine if sub event is set string subEvent = ""; foreach (int valueTypeId in new int[] { AuditEventValueTypes.GamePlanPipelineEventID, AuditEventValueTypes.GamePlanAutoBookEventID }) { subEvent = GetValueDescription(auditEvent, valueTypeId, auditEventValueTypeRepository, _valueConverters); if (!String.IsNullOrEmpty(subEvent)) { break; } } // Get run details, check if specific scenario specified var runRepository = scope.CreateRepository <IRunRepository>(); AuditEventValue runIdAuditEventValue = auditEvent.GetValueByValueTypeId(AuditEventValueTypes.GamePlanRunID); AuditEventValue scenarioIdAuditEventValue = auditEvent.GetValueByValueTypeId(AuditEventValueTypes.GamePlanScenarioID); Run run = runRepository.Find((Guid)runIdAuditEventValue.Value); AuditEventType auditEventType = new AuditEventTypeRepository().GetByID(auditEvent.EventTypeID); MailMessage mail = new MailMessage(); if (!String.IsNullOrEmpty(subEvent)) // No pipeline event { mail.Subject = string.Format("[{0}] {1}: {2}: {3}", _environmentId, Globals.ProductName, auditEventType.Description, subEvent); } else { mail.Subject = string.Format("[{0}] {1}: {2}", _environmentId, Globals.ProductName, auditEventType.Description); } // Indicate if run failed in subject, bit of a hack as we have to check the message string if (auditEvent.EventTypeID == AuditEventTypes.GamePlanRunCompleted) { string message = GetValueDescription(auditEvent, AuditEventValueTypes.Message, auditEventValueTypeRepository, _valueConverters); if (!String.IsNullOrEmpty(message) && message.ToLower().Contains("errors")) { mail.Subject = mail.Subject + string.Format(" ({0})", message); } } // Load scenarios var scenarioRepository = scope.CreateRepository <IScenarioRepository>(); var scenarioIds = run.Scenarios.Select(e => e.Id).Distinct().ToArray(); List <Scenario> scenarios = scenarioRepository.FindByIds(scenarioIds).ToList(); mail.Sender = new MailAddress(emailAuditEventSettings.NotificationSettings.SenderAddress, emailAuditEventSettings.NotificationSettings.SenderAddress); mail.From = new MailAddress(emailAuditEventSettings.NotificationSettings.SenderAddress, emailAuditEventSettings.NotificationSettings.SenderAddress); mail.Body = scenarioIdAuditEventValue == null?GetBody(auditEvent, auditEventType, run, scenarios, subEvent, auditEventValueTypeRepository) : GetBody(auditEvent, auditEventType, run, (Guid)scenarioIdAuditEventValue.Value, scenarios.First(s => s.Id == (Guid)scenarioIdAuditEventValue.Value), subEvent, auditEventValueTypeRepository); mail.IsBodyHtml = mail.Body.ToLower().Contains("<html>") && (mail.Body.ToLower().Contains("<head>") || mail.Body.ToLower().Contains("<head/>")); // Check if specific email address indicated in audit event List <AuditEventValue> recipientAuditEventValues = new List <AuditEventValue>(); AuditEventValue recipientAuditEventValue = auditEvent.GetValueByValueTypeId(AuditEventValueTypes.RecipientEmailAddress); if (recipientAuditEventValue != null) { recipientAuditEventValues.Add(recipientAuditEventValue); } if (recipientAuditEventValues.Count == 0) { for (int index = 0; index < emailAuditEventSettings.NotificationSettings.RecipientAddresses.Count; index++) { mail.To.Add(new MailAddress(emailAuditEventSettings.NotificationSettings.RecipientAddresses[index], emailAuditEventSettings.NotificationSettings.RecipientAddresses[index])); } } else { foreach (AuditEventValue auditEventValue in recipientAuditEventValues) { mail.To.Add(new MailAddress(auditEventValue.Value.ToString())); } } if (emailAuditEventSettings.NotificationSettings.CCAddresses != null) { emailAuditEventSettings.NotificationSettings.CCAddresses.ForEach(address => mail.CC.Add(new MailAddress(address, address))); } /* * foreach (AuditEventValue auditEventValue in auditEvent.Values.Where(item => item.TypeID == AuditEventValueTypes.EmailAttachment)) * { * mail.Attachments.Add(new Attachment(auditEventValue.Value.ToString())); * } */ return(mail); } }
/// <summary> /// Returns email body. Email has header details (event type, event type etc) and table for each audit event value. /// </summary> /// <param name="auditEvent"></param> /// <returns></returns> private string GetBody(AuditEvent auditEvent, AuditEventType auditEventType, Run run, Guid scenarioId, Scenario scenario, string pipelineEvent, AuditEventValueTypeRepository auditEventValueTypeRepository) { StringBuilder text = new StringBuilder("<table>"); //text.Append("<tr><th>Item</th><th>Value</th></tr>"); DataTable valuesDataTable = GetValuesDataTable(auditEvent, run, auditEventType, pipelineEvent, auditEventValueTypeRepository); for (int rowIndex = 0; rowIndex < valuesDataTable.Rows.Count; rowIndex++) { text.Append(string.Format("<tr><td><B>{0}</B></td><td>{1}</td></tr>", valuesDataTable.Rows[rowIndex]["Item"].ToString(), valuesDataTable.Rows[rowIndex]["Value"].ToString())); } text.Append("</table><BR/>"); text.Append("<B>Scenario</B><BR/><table>"); text.Append("<tr><th>Scenario ID</th><th>Passes</th><th>Started</th><th>Completed</th><th>Status</th></tr>"); foreach (var runScenario in run.Scenarios.Where(s => s.Id == scenarioId)) { string scenarioUrl = string.Format(@"{0}/#/optimizer-report/{1}/{2}", _frontendUrl, run.Id, runScenario.Id); text.Append(string.Format("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td></tr>", CreateHTMLLink(runScenario.Id.ToString(), scenarioUrl), scenario.Passes.Count, (runScenario.StartedDateTime == null ? "n/a" : runScenario.StartedDateTime.Value.ToString()), (runScenario.CompletedDateTime == null ? "n/a" : runScenario.CompletedDateTime.Value.ToString()), runScenario.Status.ToString())); } text.Append("</table>"); return(string.Format("<html><head>{0}</head><body>{1}</body></html>", GetStyle(), text.ToString())); }
private DataTable GetValuesDataTable(AuditEvent auditEvent, Run run, AuditEventType auditEventType, string subEvent, AuditEventValueTypeRepository auditEventValueTypeRepository) { DataTable dataTable = new DataTable(); dataTable.Columns.Add("Item", typeof(String)); dataTable.Columns.Add("Value", typeof(String)); string runUrl = string.Format(@"{0}/#/manage-runs", _frontendUrl); // Add standard header AddValuesRow(dataTable, "Time", auditEvent.TimeCreated.ToString()); AddValuesRow(dataTable, "Event ID", auditEvent.ID); AddValuesRow(dataTable, "Event", string.IsNullOrEmpty(subEvent) ? auditEventType.Description : string.Format("{0} - {1}", auditEventType.Description, subEvent)); // Add values from Run ID AddValuesRow(dataTable, "Run ID", CreateHTMLLink(run.Id.ToString(), runUrl)); AddValuesRow(dataTable, "Description", run.Description); AddValuesRow(dataTable, "Date Range", string.Format("{0} - {1}", run.StartDate.ToString(), run.EndDate.ToString())); AddValuesRow(dataTable, "Created", run.CreatedDateTime.ToString()); AddValuesRow(dataTable, "Executed", run.ExecuteStartedDateTime == null ? "n/a" : run.ExecuteStartedDateTime.Value.ToString()); if (run.CompletedScenarios.Count == run.Scenarios.Count && run.LastScenarioCompletedDateTime != null) { AddValuesRow(dataTable, "Completed", run.LastScenarioCompletedDateTime.Value.ToString()); } // Add other values HashSet <int> valueTypesDone = new HashSet <int>() { AuditEventValueTypes.GamePlanRunID, AuditEventValueTypes.GamePlanPipelineEventID, AuditEventValueTypes.GamePlanAutoBookEventID }; foreach (AuditEventValue auditEventValue in auditEvent.Values) { if (!valueTypesDone.Contains(auditEventValue.TypeID)) // Ignore values done above { AuditEventValueType auditEventValueType = auditEventValueTypeRepository.GetByID(auditEventValue.TypeID); if (!auditEventValueType.Internal) { AuditEventValueConverter auditEventValueConverter = _valueConverters.Find(current => current.Handles(auditEventValue.TypeID)); if (auditEventValueConverter != null) { AddValuesRow(dataTable, auditEventValueType.Description, auditEventValueConverter.ValueConverter.Convert(auditEventValue.Value, auditEventValueType.Type, typeof(String)).ToString()); } else { AddValuesRow(dataTable, auditEventValueType.Description, auditEventValue.Value.ToString()); } } } } return(dataTable); }