private void ChangeTableHeadingSpecial(ITable table) { DateTime currentYearTemp = EHBFunctions.GetCurrentAcademicYear(); string currentYear = currentYearTemp.Year.ToString(); DateTime nextYearTemp = currentYearTemp.AddYears(1); string nextYear = nextYearTemp.Year.ToString(); for (int i = table.Rows[0].Cells.Count - 1; i > 0; i--) { table.Rows[0].Cells[i].TextBody.Text = EHBFunctions.FormatYearStringSpecial(currentYear, nextYear); currentYearTemp = currentYearTemp.AddYears(-1); currentYear = currentYearTemp.Year.ToString(); nextYearTemp = nextYearTemp.AddYears(-1); nextYear = nextYearTemp.Year.ToString(); } }
public void ChangeDoorstroomSlide2( int aso60, int asoTussen45En60, int aso45, int asoTotaal, int tso60, int tsoTussen45En60, int tso45, int tsoTotaal, int kso60, int ksoTussen45En60, int kso45, int ksoTotaal, int bso60, int bsoTussen45En60, int bso45, int bsoTotaal, int buiteland60, int buitelandTussen45En60, int buiteland45, int buitelandTotaal) { ISlide slide = this.PowerPoint.Slides[13]; ITable table = slide.Tables[0]; table.Columns[1].Cells[1].TextBody.Text = EHBFunctions.FormatStringPercent(aso60); table.Columns[1].Cells[2].TextBody.Text = EHBFunctions.FormatStringPercent(asoTussen45En60); table.Columns[1].Cells[3].TextBody.Text = EHBFunctions.FormatStringPercent(aso45); table.Columns[1].Cells[5].TextBody.Text = asoTotaal.ToString(); table.Columns[2].Cells[1].TextBody.Text = EHBFunctions.FormatStringPercent(tso60); table.Columns[2].Cells[2].TextBody.Text = EHBFunctions.FormatStringPercent(tsoTussen45En60); table.Columns[2].Cells[3].TextBody.Text = EHBFunctions.FormatStringPercent(tso45); table.Columns[2].Cells[5].TextBody.Text = tsoTotaal.ToString(); table.Columns[3].Cells[1].TextBody.Text = EHBFunctions.FormatStringPercent(kso60); table.Columns[3].Cells[2].TextBody.Text = EHBFunctions.FormatStringPercent(ksoTussen45En60); table.Columns[3].Cells[3].TextBody.Text = EHBFunctions.FormatStringPercent(kso45); table.Columns[3].Cells[5].TextBody.Text = ksoTotaal.ToString(); table.Columns[4].Cells[1].TextBody.Text = EHBFunctions.FormatStringPercent(bso60); table.Columns[4].Cells[2].TextBody.Text = EHBFunctions.FormatStringPercent(bsoTussen45En60); table.Columns[4].Cells[3].TextBody.Text = EHBFunctions.FormatStringPercent(bso45); table.Columns[4].Cells[5].TextBody.Text = bsoTotaal.ToString(); table.Columns[5].Cells[1].TextBody.Text = EHBFunctions.FormatStringPercent(buiteland60); table.Columns[5].Cells[2].TextBody.Text = EHBFunctions.FormatStringPercent(buitelandTussen45En60); table.Columns[5].Cells[3].TextBody.Text = EHBFunctions.FormatStringPercent(buiteland45); table.Columns[5].Cells[5].TextBody.Text = buitelandTotaal.ToString(); IShape text; text = slide.Shapes[6] as IShape; text.TextBody.Paragraphs[0].Text = EHBFunctions.FormatStringPercent(aso60 + asoTussen45En60); text = slide.Shapes[7] as IShape; text.TextBody.Paragraphs[0].Text = EHBFunctions.FormatStringPercent(tso60 + tsoTussen45En60); DateTime currentYearTemp = EHBFunctions.GetCurrentAcademicYear(); string currentYear = currentYearTemp.Year.ToString(); DateTime previousYearTemp = currentYearTemp.AddYears(-1); string previousYear = previousYearTemp.Year.ToString(); text = slide.Shapes[1] as IShape; text.TextBody.Text += " " + EHBFunctions.FormatYearStringSpecial(previousYear, currentYear); }