public byte[] GetRunExcelReport(ExcelReportRunModel run) { using (var reportBuilder = new ExcelReportBuilder(new ExcelStyleApplier())) { reportBuilder.PredefineStyles(GamePlanReportStyles.RunReportPredefineStyles); foreach (var scenario in run.Scenarios) { reportBuilder.Sheet(scenario.Name, sb => { var columnsCount = scenario.MaxColumnsCount; SetColumnsWidthForRunReport(sb, columnsCount); WriteGrid(sb, scenario.ScenarioDetails); sb.Skip(); WriteGrid(sb, scenario.SalesAreaPassPriorities); sb.Skip(); WriteGrid(sb, scenario.General); sb.Skip(); WriteGrid(sb, scenario.Weighting); sb.Skip(); WriteGrid(sb, scenario.Tolerance); sb.Skip(); WriteGrid(sb, scenario.Rules); sb.Skip(); WriteGrid(sb, scenario.ProgrammeRepetitions); sb.Skip(); WriteGrid(sb, scenario.MinRatingPoints); sb.Skip(); WriteGrid(sb, scenario.BreakExclusions); sb.Skip(); WriteGrid(sb, scenario.SlottingLimits); }); } return(reportBuilder.Save()); } }
public byte[] GetSmoothFailuresExcelReport(ExcelReportSmoothFailuresModel reportModel) { using (var builder = new ExcelReportBuilder(new ExcelStyleApplier())) { return(builder .PredefineStyles(GamePlanReportStyles.SmoothFailuresReportPredefineStyles) .Sheet("Smooth Failures", sb => GetSmoothFailures(sb, reportModel.SmoothFailures)) .Sheet("Report Info", sb => GetReportInfo(sb, "Smooth Failures", reportModel.Run, reportModel.ReportDate)) .Save()); } }