@model IEnumerable @{ ViewBag.Title = "EtatTresorerieAnnuel"; string dateExercice = DateTime.Today.Year.ToString(); dateExercice = "2020"; }
@{ int montantPOST = 0; int montantSOUS = 0; } @{string[] monthNames = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.MonthNames; } @foreach (string mois in monthNames) // writing out { } @foreach (var item01 in Model) { int i = 0; @foreach (string mois in monthNames) // writing out { i++; if (i <= 12) { } } }
POSTES @dateExercice Montant
@mois
@item01.libelleSousPost @{ int montantMOIS = Convert.ToInt32(item01.DETAILCOMPTE.Where(d => d.PERIODE.EXERCICECOMPTABLE.libelleExercice == dateExercice && d.PERIODE.LibellePeriode == i.ToString()).Sum(d => d.montant)); } @Convert.ToInt32(montantMOIS).ToString("n0") @{ int TotalSousPost = Convert.ToInt32(item01.DETAILCOMPTE.Where(d => d.PERIODE.EXERCICECOMPTABLE.libelleExercice == dateExercice).Sum(d => d.montant)); } @Convert.ToInt32(TotalSousPost).ToString("n0")