using MALDFGASSURANCE.Models;
using System.Linq;
using System.Web.Mvc;

namespace MALDFGASSURANCE.Areas.STATISTIQUE.Controllers
{
    [Authorize(Roles = "Coordonnateur, CorpsMedical, MedecinConseil, PDG, Conseil, SuperAdministrateur, PresidentMutuelle")]
    public class StatistiqueController : Controller
    {
        private MALDFGEntities db = new MALDFGEntities();
        // GET: STATISTIQUE/Statistique
        public ActionResult Index()
        {
            ViewData["consoclimois"] = db.MONT_FACT_CLI.ToList();
            ViewData["consopharmois"] = db.MONT_FACT_PHAR.ToList();
            ViewData["consopharan"] = db.MONTANT_ANNUEL_PHAR.ToList();
            ViewData["consoclian"] = db.MONTANT_ANNUEL_CLI.ToList();
            ViewData["validclimois"] = db.MONT_VALID_FACTCLI_MOIS.ToList();
            ViewData["validpharmois"] = db.MONT_VALID_FACTPHAR_MOIS.ToList();
            ViewData["validclian"] = db.CLI_ANNUEL_VALID.ToList();
            ViewData["validpharan"] = db.PHAR_ANNUEL_VALID.ToList();

            return View();
        }

        public ActionResult STATCOTISATIONS()
        {
            ViewData["cotimois"] = db.COTISATION_MOIS.ToList();
            ViewData["cotian"] = db.COTISATION_ANNEE.ToList();
            ViewData["cotiqvmois"] = db.COTISATION_80_MOIS.ToList();
            ViewData["cotiqvan"] = db.COTISATION_80_ANNEE.ToList();
            ViewData["cotiqdmois"] = db.COTISATION_90_MOIS.ToList();
            ViewData["cotiqdan"] = db.COTISATION_90_ANNEE.ToList();
            ViewData["rembmois"] = db.REMBOURSEMENT_MOIS.ToList();
            ViewData["remban"] = db.REMBOURSEMENT_ANNEE.ToList();
            return View();
        }

    }
}