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 void ScenariosAreInitWhenModelIsCreated()
{
var model = new ExcelReportRunModel();
Assert.IsNotNull(model.Scenarios);
Assert.AreEqual(0, model.Scenarios.Count);
}
public ExcelReportRunModel Map(RunModel run, IEnumerable <Demographic> demographics, DateTime reportDate)
{
var model = new ExcelReportRunModel();
foreach (var scenario in run.Scenarios)
{
var excelReportScenario = Map(run, scenario, demographics, reportDate);
model.Scenarios.Add(excelReportScenario);
}
return(model);
}
