public void PopulateTabel()
{
List <CijferTabel> lstCijfers = new List <CijferTabel>();
string sScore = "";
DataTable dtCijfers = db.CijferlijstOphalen(user);
foreach (DataRow row in dtCijfers.Rows)
{
switch (row[0].ToString()) //Switch voor de verschillende vakken & de ID's
{
case "10":
sScore = "20 van de 20";
break;
case "9.6":
sScore = "19 van de 20";
break;
case "9.2":
sScore = "18 van de 20";
break;
case "8.8":
sScore = "17 van de 20";
break;
case "8.4":
sScore = "16 van de 20";
break;
case "8":
sScore = "15 van de 20";
break;
case "7.5":
sScore = "14 van de 20";
break;
case "7.1":
sScore = "13 van de 20";
break;
case "6.8":
sScore = "12 van de 20";
break;
case "6.3":
sScore = "11 van de 20";
break;
case "5.9":
sScore = "10 van de 20";
break;
case "5.5":
sScore = " 9 van de 20";
break;
case "5":
sScore = " 8 van de 20";
break;
case "4.5":
sScore = " 7 van de 20";
break;
case "4":
sScore = " 6 van de 20";
break;
case "3.5":
sScore = " 5 van de 20";
break;
case "3":
sScore = " 4 van de 20";
break;
case "2.5":
sScore = " 3 van de 20";
break;
case "2":
sScore = " 2 van de 20";
break;
case "1.5":
sScore = " 1 van de 20";
break;
case "1":
sScore = " 0 van de 20";
break;
default:
sScore = "Kan niet worden opgehaald";
break;
}
lstCijfers.Add(new CijferTabel()
{
Vak = row[2].ToString(), Lesonderwerp = row[1].ToString(), Cijfer = row[0].ToString(), Score = sScore
});
}
dgCijfers.ItemsSource = lstCijfers;
}
