/// <summary>
/// Fill NHS Condition Bridge Cnt and DA tab reports.
/// </summary>
/// <param name="worksheet"></param>
/// <param name="bridgeWorkSummaryWorkSheet"></param>
/// <param name="nhsPercentSectionYearsRow"></param>
/// <param name="count"></param>
public void Fill(ExcelWorksheet worksheet, ExcelWorksheet bridgeWorkSummaryWorkSheet, int nhsPercentSectionYearsRow, string title, int count)
{
stackedColumnChartCommon.SetWorksheetProperties(worksheet);
var chart = worksheet.Drawings.AddChart(title, eChartType.ColumnStacked);
stackedColumnChartCommon.SetChartProperties(chart, title, 1050, 700, 6, 6);
SetChartAxes(chart);
AddSeries(bridgeWorkSummaryWorkSheet, nhsPercentSectionYearsRow, count, chart);
chart.AdjustPositionAndSize();
chart.Locked = true;
}
/// <summary>
/// Fill Condition DA tab report
/// </summary>
/// <param name="worksheet"></param>
/// <param name="bridgeWorkSummaryWorkSheet"></param>
/// <param name="totalDeckAreaSectionYearsRow"></param>
/// <param name="count"></param>
public void Fill(ExcelWorksheet worksheet, ExcelWorksheet bridgeWorkSummaryWorkSheet, int totalDeckAreaSectionYearsRow, int count)
{
stackedColumnChartCommon.SetWorksheetProperties(worksheet);
var title = Properties.Resources.CombineNHSNonNHSConditionByDeckArea;
var chart = worksheet.Drawings.AddChart(title, eChartType.ColumnStacked);
stackedColumnChartCommon.SetChartProperties(chart, title, 950, 700, 6, 7);
SetChartAxes(chart);
AddSeries(bridgeWorkSummaryWorkSheet, totalDeckAreaSectionYearsRow, count, chart);
chart.AdjustPositionAndSize();
chart.Locked = true;
}
public void Fill(ExcelWorksheet worksheet, ExcelWorksheet bridgeWorkSummaryWorkSheet, int totalPoorBridgesCountSectionYearsRow, int count)
{
stackedColumnChartCommon.SetWorksheetProperties(worksheet);
var title = Properties.Resources.PoorBridgeCompareBridgeCount;
var chart = worksheet.Drawings.AddChart(title, eChartType.ColumnStacked);
stackedColumnChartCommon.SetChartProperties(chart, title, 1200, 820, 2, 6);
stackedColumnChartCommon.SetChartAxes(chart);
AddSeries(bridgeWorkSummaryWorkSheet, totalPoorBridgesCountSectionYearsRow, count, chart);
//chart.AdjustPositionAndSize();
chart.Locked = true;
}
