public void ChangeInstroomSlide1(
int voltijds,
int deeltijds,
int totaal,
int generatieStudent,
int nietGeneratieStudent,
int aandelInTotaal,
int aandeelInVoltijds,
int index)
{
ISlide slide = this.PowerPoint.Slides[5];
ITable table = slide.Tables[0];
if (index == 1)
{
this.ChangeTableHeading(table);
}
table.Columns[table.Columns.Count - index].Cells[1].TextBody.Text = EHBFunctions.FormatStringNonPercent(voltijds);
table.Columns[table.Columns.Count - index].Cells[2].TextBody.Text = EHBFunctions.FormatStringNonPercent(deeltijds);
table.Columns[table.Columns.Count - index].Cells[3].TextBody.Text = EHBFunctions.FormatStringNonPercent(totaal);
table.Columns[table.Columns.Count - index].Cells[4].TextBody.Text = EHBFunctions.FormatStringNonPercent(generatieStudent);
table.Columns[table.Columns.Count - index].Cells[5].TextBody.Text = EHBFunctions.FormatStringNonPercent(nietGeneratieStudent);
table.Columns[table.Columns.Count - index].Cells[6].TextBody.Text = EHBFunctions.FormatStringPercent(aandelInTotaal);
table.Columns[table.Columns.Count - index].Cells[7].TextBody.Text = EHBFunctions.FormatStringPercent(aandeelInVoltijds);
}
public void ChangeStudierendementSlide1(
int opgenomePunten,
int verworvenPunten,
int index)
{
ISlide slide = this.PowerPoint.Slides[24];
ITable table = slide.Tables[0];
//IPresentationChart chart = slide.Charts[0];
if (index == 1)
{
this.ChangeTableHeading3(table);
}
table.Columns[table.Columns.Count - index].Cells[1].TextBody.Text = EHBFunctions.FormatStringNonPercent(opgenomePunten);
table.Columns[table.Columns.Count - index].Cells[2].TextBody.Text = EHBFunctions.FormatStringNonPercent(verworvenPunten);
table.Columns[table.Columns.Count - index].Cells[3].TextBody.Text = EHBFunctions.FormatStringPercent((int)Math.Round(((double)verworvenPunten / opgenomePunten) * 100.00));
}
public void ChangeInstroomSlide4(
int aso,
int tso,
int bso,
int kso,
int buiteland,
int aantal,
int index)
{
ISlide slide = this.PowerPoint.Slides[8];
ITable table = slide.Tables[0];
if (index == 1)
{
this.ChangeTableHeading(table);
}
table.Columns[table.Columns.Count - index].Cells[1].TextBody.Text = EHBFunctions.FormatStringNonPercent(aso);
table.Columns[table.Columns.Count - index].Cells[2].TextBody.Text = EHBFunctions.FormatStringNonPercent(tso);
table.Columns[table.Columns.Count - index].Cells[3].TextBody.Text = EHBFunctions.FormatStringNonPercent(bso);
table.Columns[table.Columns.Count - index].Cells[4].TextBody.Text = EHBFunctions.FormatStringNonPercent(kso);
table.Columns[table.Columns.Count - index].Cells[5].TextBody.Text = EHBFunctions.FormatStringNonPercent(buiteland);
table.Columns[table.Columns.Count - index].Cells[7].TextBody.Text = EHBFunctions.FormatStringNonPercent(aantal);
}
public void ChangeStudieduurSlide3(
int aso,
int tso,
int bso,
int kso,
int buiteland,
int index)
{
ISlide slide = this.PowerPoint.Slides[21];
ITable table = slide.Tables[0];
if (table.Columns.Count - index - 1 != 0)
{
if (index == 1)
{
this.ChangeTableHeading(table);
}
table.Columns[table.Columns.Count - index - 1].Cells[1].TextBody.Text = EHBFunctions.FormatStringNonPercent(aso);
table.Columns[table.Columns.Count - index - 1].Cells[2].TextBody.Text = EHBFunctions.FormatStringNonPercent(tso);
table.Columns[table.Columns.Count - index - 1].Cells[3].TextBody.Text = EHBFunctions.FormatStringNonPercent(bso);
table.Columns[table.Columns.Count - index - 1].Cells[4].TextBody.Text = EHBFunctions.FormatStringNonPercent(kso);
table.Columns[table.Columns.Count - index - 1].Cells[5].TextBody.Text = EHBFunctions.FormatStringNonPercent(buiteland);
}
}
public void ChangeStudieduurSlide2(
int asoMinderDanDrie,
int asoDrie,
int asoVier,
int asoMeerDanVier,
int tsoMinderDanDrie,
int tsoDrie,
int tsoVier,
int tsoMeerDanVier,
int bsoMinderDanDrie,
int bsoDrie,
int bsoVier,
int bsoMeerDanVier,
int ksoMinderDanDrie,
int ksoDrie,
int ksoVier,
int ksoMeerDanVier,
int blndMinderDanDrie,
int blndDrie,
int blndVier,
int blndMeerDanVier)
{
ISlide slide = this.PowerPoint.Slides[20];
ITable table = slide.Tables[0];
table.Rows[1].Cells[1].TextBody.Text = EHBFunctions.FormatStringNonPercent(asoMinderDanDrie);
table.Rows[1].Cells[2].TextBody.Text = EHBFunctions.FormatStringNonPercent(asoDrie);
table.Rows[1].Cells[3].TextBody.Text = EHBFunctions.FormatStringNonPercent(asoVier);
table.Rows[1].Cells[4].TextBody.Text = EHBFunctions.FormatStringNonPercent(asoMeerDanVier);
table.Rows[2].Cells[1].TextBody.Text = EHBFunctions.FormatStringNonPercent(tsoMinderDanDrie);
table.Rows[2].Cells[2].TextBody.Text = EHBFunctions.FormatStringNonPercent(tsoDrie);
table.Rows[2].Cells[3].TextBody.Text = EHBFunctions.FormatStringNonPercent(tsoVier);
table.Rows[2].Cells[4].TextBody.Text = EHBFunctions.FormatStringNonPercent(tsoMeerDanVier);
table.Rows[3].Cells[1].TextBody.Text = EHBFunctions.FormatStringNonPercent(bsoMinderDanDrie);
table.Rows[3].Cells[2].TextBody.Text = EHBFunctions.FormatStringNonPercent(bsoDrie);
table.Rows[3].Cells[3].TextBody.Text = EHBFunctions.FormatStringNonPercent(bsoVier);
table.Rows[3].Cells[4].TextBody.Text = EHBFunctions.FormatStringNonPercent(bsoMeerDanVier);
table.Rows[4].Cells[1].TextBody.Text = EHBFunctions.FormatStringNonPercent(ksoMinderDanDrie);
table.Rows[4].Cells[2].TextBody.Text = EHBFunctions.FormatStringNonPercent(ksoDrie);
table.Rows[4].Cells[3].TextBody.Text = EHBFunctions.FormatStringNonPercent(ksoVier);
table.Rows[4].Cells[4].TextBody.Text = EHBFunctions.FormatStringNonPercent(ksoMeerDanVier);
table.Rows[5].Cells[1].TextBody.Text = EHBFunctions.FormatStringNonPercent(blndMinderDanDrie);
table.Rows[5].Cells[2].TextBody.Text = EHBFunctions.FormatStringNonPercent(blndDrie);
table.Rows[5].Cells[3].TextBody.Text = EHBFunctions.FormatStringNonPercent(blndVier);
table.Rows[5].Cells[4].TextBody.Text = EHBFunctions.FormatStringNonPercent(blndMeerDanVier);
table.Rows[7].Cells[1].TextBody.Text = EHBFunctions.FormatStringNonPercent(asoMinderDanDrie + tsoMinderDanDrie + bsoMinderDanDrie + ksoMinderDanDrie + blndMinderDanDrie);
table.Rows[7].Cells[2].TextBody.Text = EHBFunctions.FormatStringNonPercent(asoDrie + tsoDrie + bsoDrie + ksoDrie + blndDrie);
table.Rows[7].Cells[3].TextBody.Text = EHBFunctions.FormatStringNonPercent(asoVier + tsoVier + bsoVier + ksoVier + blndVier);
table.Rows[7].Cells[4].TextBody.Text = EHBFunctions.FormatStringNonPercent(asoMeerDanVier + tsoMeerDanVier + bsoMeerDanVier + ksoMeerDanVier + blndMeerDanVier);
IShape text;
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 = $"4.2. Studieduur per type SO, uitstroom {EHBFunctions.FormatYearString(previousYear, currentYear)} \r in aantal studenten";
}
public void ChangeUitstroomSlide1(
int aso,
int tso,
int bso,
int kso,
int buiteland,
int aantal,
int asoP,
int tsoP,
int bsoP,
int ksoP,
int buitelandP,
int index)
{
ISlide slide = this.PowerPoint.Slides[16];
ITable table = slide.Tables[0];
if (table.Columns.Count - index - 1 != 0)
{
if (index == 1)
{
this.ChangeTableHeading(table);
}
table.Columns[table.Columns.Count - index - 1].Cells[1].TextBody.Text = EHBFunctions.FormatStringNonPercent(aso);
table.Columns[table.Columns.Count - index - 1].Cells[2].TextBody.Text = EHBFunctions.FormatStringNonPercent(tso);
table.Columns[table.Columns.Count - index - 1].Cells[3].TextBody.Text = EHBFunctions.FormatStringNonPercent(bso);
table.Columns[table.Columns.Count - index - 1].Cells[4].TextBody.Text = EHBFunctions.FormatStringNonPercent(kso);
table.Columns[table.Columns.Count - index - 1].Cells[5].TextBody.Text = EHBFunctions.FormatStringNonPercent(buiteland);
table.Columns[table.Columns.Count - index - 1].Cells[7].TextBody.Text = EHBFunctions.FormatStringNonPercent(aantal);
//TABEL 2 --> Onderaan
table = slide.Tables[1];
if (index == 1)
{
this.ChangeTableHeading(table);
}
table.Columns[table.Columns.Count - index - 1].Cells[1].TextBody.Text = EHBFunctions.FormatStringPercent(asoP);
table.Columns[table.Columns.Count - index - 1].Cells[2].TextBody.Text = EHBFunctions.FormatStringPercent(tsoP);
table.Columns[table.Columns.Count - index - 1].Cells[3].TextBody.Text = EHBFunctions.FormatStringPercent(bsoP);
table.Columns[table.Columns.Count - index - 1].Cells[4].TextBody.Text = EHBFunctions.FormatStringPercent(ksoP);
table.Columns[table.Columns.Count - index - 1].Cells[5].TextBody.Text = EHBFunctions.FormatStringPercent(buitelandP);
}
}
