//****************************************************************************************************** // Program.cs - Gbtc // // Copyright © 2014, Grid Protection Alliance. All Rights Reserved. // // Licensed to the Grid Protection Alliance (GPA) under one or more contributor license agreements. See // the NOTICE file distributed with this work for additional information regarding copyright ownership. // The GPA licenses this file to you under the MIT License (MIT), the "License"; you may // not use this file except in compliance with the License. You may obtain a copy of the License at: // // http://www.opensource.org/licenses/MIT // // Unless agreed to in writing, the subject software distributed under the License is distributed on an // "AS-IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. Refer to the // License for the specific language governing permissions and limitations. // // Code Modification History: // ---------------------------------------------------------------------------------------------------- // 02/10/2014 - Stephen C. Wills // Generated original version of source code. // 04/29/2015 - J. Ritchie Carroll // Added report e-mailing options. // 08/02/2018 - J. Ritchie Carroll // Added error logging and optional database connection arguments. // //****************************************************************************************************** using System; using System.Globalization; using System.IO; using System.Linq; using System.Threading; using System.Windows.Forms; using System.Xml.Linq; using GSF; using GSF.Console; using GSF.Data; using GSF.Diagnostics; using GSF.IO; using GSF.Net.Smtp; using GSF.Security.Cryptography; namespace StatHistorianReportGenerator { static class Program { public static LogPublisher Log; private static string s_configurationString; private static string s_dataProviderString; /// /// The main entry point for the application. /// [STAThread] static void Main() { string localPath = FilePath.GetAbsolutePath(""); string logPath = string.Format("{0}{1}Logs{1}", localPath, Path.DirectorySeparatorChar); try { if (!Directory.Exists(logPath)) Directory.CreateDirectory(logPath); } catch { logPath = localPath; } Logger.FileWriter.SetPath(logPath); Logger.FileWriter.SetLoggingFileCount(100); Logger.SuppressFirstChanceExceptionLogMessages(); Log = Logger.CreatePublisher(typeof(Program), MessageClass.Application); Log.Publish(MessageLevel.Info, "ApplicationStart"); try { // Report.NET is only capable of using the standard AFM fonts that are expected to be supported by all PDF readers. // As a result, high-order Unicode characters that may be produced with long date-time formats when using non-US // cultures can cause application to fail - as a result, culture is set to invariant to reduce failure risk. Note // that risk will not be completely eliminated, e.g., system configured with a company name using a bad character. Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture; Thread.CurrentThread.CurrentUICulture = CultureInfo.InvariantCulture; } catch (Exception ex) { Log.Publish(MessageLevel.Error, "InitializeCulture", exception: ex); } if (Environment.GetCommandLineArgs().Length > 1) { Arguments args = new Arguments(Environment.CommandLine, true); // Check for optional parameters TryGetValue(args, "configFile", out ArchiveLocator.HostConfigFile); TryGetValue(args, "configurationString", out s_configurationString); TryGetValue(args, "dataProviderString", out s_dataProviderString); if (TryGetValue(args, "reportType", out string arg) && !string.IsNullOrWhiteSpace(arg)) { arg = arg.Trim(); if (arg.Equals("completeness", StringComparison.OrdinalIgnoreCase)) GenerateCompletenessReport(); else if (arg.Equals("correctness", StringComparison.OrdinalIgnoreCase)) GenerateCorrectnessReport(); } else { // Generate completeness report by default GenerateCompletenessReport(); } } else { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Main()); } } private static void GenerateCompletenessReport() { try { CompletenessReportGenerator completenessReportGenerator = new CompletenessReportGenerator(); Arguments args = new Arguments(Environment.CommandLine, true); string reportLocation = ""; string reportFileName = ""; DateTime reportDate = DateTime.UtcNow; if (TryGetValue(args, "archiveLocation", out string arg)) completenessReportGenerator.ArchiveLocation = arg; if (TryGetValue(args, "reportLocation", out arg)) reportLocation = arg; if (TryGetValue(args, "reportFileName", out arg)) reportFileName = arg; if (TryGetValue(args, "title", out arg)) completenessReportGenerator.TitleText = arg; if (TryGetValue(args, "company", out arg)) completenessReportGenerator.CompanyText = arg; if (TryGetValue(args, "reportDate", out arg) && DateTime.TryParse(arg, out reportDate)) { if (reportDate.Kind == DateTimeKind.Unspecified) reportDate = new DateTime(reportDate.Ticks, DateTimeKind.Utc); completenessReportGenerator.ReportDate = reportDate; } if (TryGetValue(args, "level4Threshold", out arg) && double.TryParse(arg, out double threshold)) completenessReportGenerator.Level4Threshold = threshold; if (TryGetValue(args, "level3Threshold", out arg) && double.TryParse(arg, out threshold)) completenessReportGenerator.Level3Threshold = threshold; if (TryGetValue(args, "level4Alias", out arg)) completenessReportGenerator.Level4Alias = arg; if (TryGetValue(args, "level3Alias", out arg)) completenessReportGenerator.Level3Alias = arg; if (TryGetValue(args, "generateCsvReport", out arg) && bool.TryParse(arg, out bool generateCsvReport)) completenessReportGenerator.GenerateCsvReport = generateCsvReport; if (string.IsNullOrEmpty(reportFileName)) reportFileName = $"{completenessReportGenerator.TitleText} {completenessReportGenerator.ReportDate:yyyy-MM-dd}.pdf"; reportLocation = FilePath.GetAbsolutePath(reportLocation); if (!Directory.Exists(reportLocation)) Directory.CreateDirectory(reportLocation); completenessReportGenerator.ReportFilePath = Path.Combine(reportLocation, reportFileName); // Generate PDF report completenessReportGenerator.GenerateReport().Save(completenessReportGenerator.ReportFilePath); // E-mail PDF report if parameters were provided EmailReport(args, $"{completenessReportGenerator.CompanyText} {completenessReportGenerator.TitleText} for {reportDate:MMMM dd, yyyy}", completenessReportGenerator.ReportFilePath); } catch (Exception ex) { Log.Publish(MessageLevel.Error, "GenerateCompletenessReport", exception: ex); } } private static void GenerateCorrectnessReport() { try { CorrectnessReportGenerator correctnessReportGenerator = new CorrectnessReportGenerator(); Arguments args = new Arguments(Environment.CommandLine, true); string reportLocation = ""; string reportFileName = ""; DateTime reportDate = DateTime.UtcNow; if (TryGetValue(args, "archiveLocation", out string arg)) correctnessReportGenerator.ArchiveLocation = arg; if (TryGetValue(args, "reportLocation", out arg)) reportLocation = arg; if (TryGetValue(args, "reportFileName", out arg)) reportFileName = arg; if (TryGetValue(args, "title", out arg)) correctnessReportGenerator.TitleText = arg; if (TryGetValue(args, "company", out arg)) correctnessReportGenerator.CompanyText = arg; if (TryGetValue(args, "reportDate", out arg) && DateTime.TryParse(arg, out reportDate)) { if (reportDate.Kind == DateTimeKind.Unspecified) reportDate = new DateTime(reportDate.Ticks, DateTimeKind.Utc); correctnessReportGenerator.ReportDate = reportDate; } if (string.IsNullOrEmpty(reportFileName)) reportFileName = $"{correctnessReportGenerator.TitleText} {correctnessReportGenerator.ReportDate:yyyy-MM-dd}.pdf"; reportLocation = FilePath.GetAbsolutePath(reportLocation); if (!Directory.Exists(reportLocation)) Directory.CreateDirectory(reportLocation); string reportFilePath = Path.Combine(reportLocation, reportFileName); // Generate PDF report correctnessReportGenerator.GenerateReport().Save(reportFilePath); // E-mail PDF report if parameters were provided EmailReport(args, $"{correctnessReportGenerator.CompanyText} {correctnessReportGenerator.TitleText} for {reportDate:MMMM dd, yyyy}", reportFilePath); } catch (Exception ex) { Log.Publish(MessageLevel.Error, "GenerateCorrectnessReport", exception: ex); } } private static void EmailReport(Arguments args, string subject, string reportFilePath) { const string CryptoKey = "0679d9ae-aca5-4702-a3f5-604415096987"; try { if (TryGetValue(args, "smtpServer", out string smtpServer) && TryGetValue(args, "fromAddress", out string fromAddress) && TryGetValue(args, "toAddresses", out string toAddresses) && smtpServer.Length > 0 && fromAddress.Length > 0 && toAddresses.Length > 0) { using (Mail message = new Mail(fromAddress, toAddresses, smtpServer)) { message.Subject = subject; message.Attachments = reportFilePath; message.IsBodyHtml = true; message.Body = "
\r\n" + "The attached report requires a portable document format (PDF) reader, such as the " + "Adobe Acrobat PDF Reader.\r\n" + "
\r\n" + "

\r\n" + "
\r\n" + $"E-mail generated at {DateTime.UtcNow:yyyy-MM-dd HH:mm:ss.fff} UTC.\r\n" + "
"; if (TryGetValue(args, "generateCsvReport", out string generateCsvReport) && generateCsvReport.ParseBoolean()) message.Attachments += ";" + Path.ChangeExtension(reportFilePath, ".csv"); if (TryGetValue(args, "username", out string username) && TryGetValue(args, "password", out string password) && username.Length > 0 && password.Length > 0) { message.EnableSSL = true; message.Username = username; message.Password = password.Decrypt(CryptoKey, CipherStrength.Aes256); } message.Send(); } } } catch (Exception ex) { Log.Publish(MessageLevel.Error, "EmailReport", exception: ex); } } private static bool TryGetValue(Arguments args, string arg, out string value) { value = args[arg]; if ((object)value != null) { value = value.Trim(); return true; } return false; } public static AdoDataConnection GetDatabaseConnection() { string connectionString = s_configurationString; string dataProviderString = s_dataProviderString; if (string.IsNullOrWhiteSpace(connectionString) || string.IsNullOrWhiteSpace(dataProviderString)) { XDocument serviceConfig = XDocument.Load(ArchiveLocator.GetConfigurationFileName()); connectionString = serviceConfig .Descendants("systemSettings") .SelectMany(systemSettings => systemSettings.Elements("add")) .Where(element => "ConnectionString".Equals((string)element.Attribute("name"), StringComparison.OrdinalIgnoreCase)) .Select(element => (string)element.Attribute("value")) .FirstOrDefault(); dataProviderString = serviceConfig .Descendants("systemSettings") .SelectMany(systemSettings => systemSettings.Elements("add")) .Where(element => "DataProviderString".Equals((string)element.Attribute("name"), StringComparison.OrdinalIgnoreCase)) .Select(element => (string)element.Attribute("value")) .FirstOrDefault(); } if (string.IsNullOrWhiteSpace(connectionString) || string.IsNullOrWhiteSpace(dataProviderString)) return null; return new AdoDataConnection(connectionString, dataProviderString); } } }