public void PrependLogs(FilingSummary tmpFS) { for (int i = 0; i < tmpFS.Logs.Count; i++) { LogItem log = tmpFS.Logs[i]; this.Logs.Insert(i, log); } }
private List <ReportHeader> returnHeaders(DirectoryInfo path) { FilingSummary sum = FilingSummary.Load(path.FullName); List <ReportHeader> HeaderList = new List <ReportHeader>(); if (sum != null) { ReportHeader[] header = (ReportHeader[])sum.MyReports.ToArray(); HeaderList = new List <ReportHeader>(header); } return(HeaderList); }
public static FilingSummary Load(string directory) { string fn = directory + Path.DirectorySeparatorChar + FilingSummaryXmlName; if (!File.Exists(fn)) { return(null); } XmlTextReader xmlReader = new XmlTextReader(fn); XmlSerializer xmlReport = new XmlSerializer(typeof(FilingSummary)); FilingSummary fs = (FilingSummary)xmlReport.Deserialize(xmlReader); xmlReader.Close(); return(fs); }
/// <summary> /// The method name refers to RR, but it is for all Instance Documents /// </summary> /// <param name="reportDirectory">The folder containing all reports (R1.xml, etc). /// This is also the destination folder.</param> /// <param name="excelReportName">The destination file name, without path or extention</param> /// <param name="xsltPath">The path to InstanceReport_XmlWorkbook.xslt</param> /// <param name="cssPath">The path to report.css</param> /// <returns></returns> public static bool GenerateExcelWorkbook(FilingSummary fs, string reportDirectory, string excelReportName) { if (!Directory.Exists(reportDirectory)) { return(false); } try { SingleFileWorkbook sfwb = GenerateExcelWorkbook(fs, reportDirectory); string saveAt = Path.Combine(reportDirectory, excelReportName + ".xls"); sfwb.SaveAs(saveAt); return(true); } catch { } return(false); }
/// <summary> /// Creates a new instance of the trace wrapper with <paramref /// name="fs"/> as the base. /// </summary> /// <param name="fs">The <see cref="FilingSummary"/> to use for /// creating the trace wrapper.</param> public FilingSummaryTraceWrapper(FilingSummary fs) { this.fs = fs; this.Attributes["switchValue"] = "All"; }
public void PrependLogs(FilingSummary tmpFS) { }
/// <summary> /// /// </summary> /// <param name="reportDirectory">The folder containing all reports (R1.xml, etc)</param> /// <param name="xsltPath">The path to InstanceReport_XmlWorkbook.xslt</param> /// <param name="cssPath">The path to report.css</param> /// <returns></returns> public static SingleFileWorkbook GenerateExcelWorkbook(FilingSummary myFilingSummary, string reportDirectory) { string cssPath = RulesEngineUtils.GetResourcePath(RulesEngineUtils.ReportBuilderFolder.Resources, RulesEngineUtils.StylesheetFile); string xsltPath = RulesEngineUtils.GetResourcePath(RulesEngineUtils.ReportBuilderFolder.Resources, RulesEngineUtils.TransformWorkbookFile); XslCompiledTransform xslt = new XslCompiledTransform(); xslt.Load(xsltPath); SingleFileWorkbook sfwb = new SingleFileWorkbook(); Dictionary <string, int> sheetNames = new Dictionary <string, int>(); //Process the R files. Each R File will be transformed into a worksheet in the workbook int idx = 0; foreach (ReportHeader reportHeader in myFilingSummary.MyReports) { if (reportHeader.ReportType == ReportHeaderType.Book) { continue; } string reportPath = Path.Combine(reportDirectory, reportHeader.XmlFileName); if (!File.Exists(reportPath)) { Trace.TraceError( "Error: An error occurred while creating the Excel Workbook.\n" + "Sheet '" + reportHeader.ShortName + "' could not be loaded.\n" + "Reason:\n\tFile not found." ); continue; } try { idx++; string tmpPath = Path.GetTempFileName(); if (File.Exists(tmpPath + ".html")) { FileInfo fi = new FileInfo(tmpPath + ".html"); FileUtilities.DeleteFile(fi, true); } File.Move(tmpPath, tmpPath + ".html"); tmpPath += ".html"; xslt.Transform(reportPath, tmpPath); SingleFileAttachment sfa = sfwb.AddAttachment(tmpPath); sfa.UseName = "Sheet" + idx.ToString("00") + ".html"; sfa.Name = NameSheet(reportHeader.ShortName, sheetNames); sheetNames[sfa.Name] = 1; } catch (Exception ex) { Trace.TraceWarning( "Warning: An error occurred while creating the Excel Workbook.\n" + "Sheet '" + reportHeader.ShortName + "' may be missing.\n" + "Reason:\n\t" + ex.Message ); } } string[] charts = Directory.GetFiles(reportDirectory, "*.jpg"); foreach (string chart in charts) { try { SingleFileAttachment sfa = sfwb.AddAttachment(chart); } catch (Exception ex) { Trace.TraceWarning( "Warning: An error occurred while creating the Excel Workbook.\n" + "This attachment could not be embedded:\n\t" + Path.GetFileName(chart) + "\nReason:\n\t" + ex.Message ); } } return(sfwb); }