using CrystalDecisions.Shared.Json;
using MALDFGASSURANCE.Models;
using System.Collections.Generic;
using System.Linq;
using System.Web.Mvc;

namespace MALDFGASSURANCE.Controllers
{
    public class HomeController : Controller
    {
        private MALDFGEntities db = new MALDFGEntities();

        public ActionResult Index()
        {

          
            //--------CADRES----------------------------------
            var cadres = db.ADHERENT.Where(m => (m.CODE_CATEGORIE_PROFESSIONELLE == "CS" | m.CODE_CATEGORIE_PROFESSIONELLE == "CM") & m.IDENTREPRISES == "LDF").Count();
            var conjointcadres = db.ASSURE.Where(m => m.REFERENCE_ADHERENT == m.ADHERENT.REFERENCE_ADHERENT & (m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "CS" | m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "CM") & m.ADHERENT.IDENTREPRISES == "LDF" & m.ID_TYPE_ASSURE == "A002").Count();
            var enfantcadres = db.ASSURE.Where(m => m.REFERENCE_ADHERENT == m.ADHERENT.REFERENCE_ADHERENT & (m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "CS" | m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "CM") & m.ADHERENT.IDENTREPRISES == "LDF" & m.ID_TYPE_ASSURE == "A003").Count();
            var Totalcadres = cadres + enfantcadres + conjointcadres;
            ViewBag.Totalcadres = Totalcadres;
            ViewBag.cadres = cadres;
            ViewBag.conjointcardes = conjointcadres;
            ViewBag.enfantcadres = enfantcadres;

            //----------------Agent maitrise ldf-------------------------
            var agentm = db.ADHERENT.Where(m => m.CODE_CATEGORIE_PROFESSIONELLE == "AG" & m.IDENTREPRISES == "LDF").Count();
            var conjointagentm = db.ASSURE.Where(m => m.REFERENCE_ADHERENT == m.ADHERENT.REFERENCE_ADHERENT & m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "AG" & m.ADHERENT.IDENTREPRISES == "LDF" & m.ID_TYPE_ASSURE == "A002").Count();
            var enfantagentm = db.ASSURE.Where(m => m.REFERENCE_ADHERENT == m.ADHERENT.REFERENCE_ADHERENT & m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "AG" & m.ADHERENT.IDENTREPRISES == "LDF" & m.ID_TYPE_ASSURE == "A003").Count();
            var Totalagentm = agentm + enfantagentm + conjointagentm;
            ViewBag.Totalagentm = Totalagentm;
            ViewBag.agentm = agentm;
            ViewBag.conjointagentm = conjointagentm;
            ViewBag.enfantagentm = enfantagentm;

            //-------------agent maitrise iti----------------

            var agentmiti = db.ADHERENT.Where(m => m.CODE_CATEGORIE_PROFESSIONELLE == "AG" & m.IDENTREPRISES == "ITI").Count();
            var conjointagentmiti = db.ASSURE.Where(m => m.REFERENCE_ADHERENT == m.ADHERENT.REFERENCE_ADHERENT & m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "AG" & m.ADHERENT.IDENTREPRISES == "ITI" & m.ID_TYPE_ASSURE == "A002").Count();
            var enfantagentmiti = db.ASSURE.Where(m => m.REFERENCE_ADHERENT == m.ADHERENT.REFERENCE_ADHERENT & m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "AG" & m.ADHERENT.IDENTREPRISES == "ITI" & m.ID_TYPE_ASSURE == "A003").Count();
            var Totalagentmiti = agentmiti + enfantagentmiti + conjointagentmiti;
            ViewBag.agentmiti = agentmiti;
            ViewBag.conjointagentmiti = conjointagentmiti;
            ViewBag.enfantagentmiti = enfantagentmiti;
            ViewBag.Totalagentmiti = Totalagentmiti;

            //-------------agent maitrise freelance----------------

            var agentmfre = db.ADHERENT.Where(m => m.CODE_CATEGORIE_PROFESSIONELLE == "AG" & m.IDENTREPRISES == "FLDF").Count();
            var conjointagentmfre = db.ASSURE.Where(m => m.REFERENCE_ADHERENT == m.ADHERENT.REFERENCE_ADHERENT & m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "AG" & m.ADHERENT.IDENTREPRISES == "FLDF" & m.ID_TYPE_ASSURE == "A002").Count();
            var enfantagentmfre = db.ASSURE.Where(m => m.REFERENCE_ADHERENT == m.ADHERENT.REFERENCE_ADHERENT & m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "AG" & m.ADHERENT.IDENTREPRISES == "FLDF" & m.ID_TYPE_ASSURE == "A003").Count();
            var Totalagentmfre = agentmfre + enfantagentmfre + conjointagentmfre;
            ViewBag.agentmfre = agentmfre;
            ViewBag.conjointagentmfre = conjointagentmfre;
            ViewBag.enfantagentmfre = enfantagentmfre;
            ViewBag.Totalagentmfre = Totalagentmfre;

            //--------------employe ldf---------------------------

            var employeldf = db.ADHERENT.Where(m => m.CODE_CATEGORIE_PROFESSIONELLE == "E" & m.IDENTREPRISES == "LDF").Count();
            var conjointemployeldf = db.ASSURE.Where(m => m.REFERENCE_ADHERENT == m.ADHERENT.REFERENCE_ADHERENT & m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "E" & m.ADHERENT.IDENTREPRISES == "LDF" & m.ID_TYPE_ASSURE == "A002").Count();
            var enfantemployeldf = db.ASSURE.Where(m => m.REFERENCE_ADHERENT == m.ADHERENT.REFERENCE_ADHERENT & m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "E" & m.ADHERENT.IDENTREPRISES == "LDF" & m.ID_TYPE_ASSURE == "A003").Count();
            var Totalemployeldf = employeldf + enfantemployeldf + conjointemployeldf;
            ViewBag.employeldf = employeldf;
            ViewBag.conjointemployeldf = conjointemployeldf;
            ViewBag.enfantemployeldf = enfantemployeldf;
            ViewBag.Totalemployeldf = Totalemployeldf;

            //-----------------employe iti --------------------------

            var employeiti = db.ADHERENT.Where(m => m.CODE_CATEGORIE_PROFESSIONELLE == "E" & m.IDENTREPRISES == "ITI").Count();
            var conjointemployeiti = db.ASSURE.Where(m => m.REFERENCE_ADHERENT == m.ADHERENT.REFERENCE_ADHERENT & m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "E" & m.ADHERENT.IDENTREPRISES == "ITI" & m.ID_TYPE_ASSURE == "A002").Count();
            var enfantemployeiti = db.ASSURE.Where(m => m.REFERENCE_ADHERENT == m.ADHERENT.REFERENCE_ADHERENT & m.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == "E" & m.ADHERENT.IDENTREPRISES == "ITI" & m.ID_TYPE_ASSURE == "A003").Count();
            var Totalemployeiti = employeiti + enfantemployeiti + conjointemployeiti;
            ViewBag.employeiti = employeiti;
            ViewBag.conjointemployeiti = conjointemployeiti;
            ViewBag.enfantemployeiti = enfantemployeiti;
            ViewBag.Totalemployeiti = Totalemployeiti;

            //------------------Grand Total---------------------------

            var titulaire = cadres + agentm + agentmfre + agentmiti + employeiti + employeldf;
            var conjoint = conjointcadres + conjointagentm + conjointagentmfre + conjointagentmiti + conjointemployeiti + conjointemployeldf;
            var enfant = enfantcadres + enfantagentm + enfantagentmiti + enfantagentmfre + enfantemployeldf + enfantagentmiti;
            var global = Totalcadres + Totalagentm + Totalagentmiti + Totalagentmfre + Totalemployeldf + Totalemployeiti;
            ViewBag.titulaire = titulaire;
            ViewBag.conjoint = conjoint;
            ViewBag.enfant = enfant;
            ViewBag.global = global;
            //----------------compte etablissement------------------
            var listeTypeAssure = db.TYPE_ASSURE.ToList();
            ViewData["listeTypeAssure"] = listeTypeAssure;


            return View(db.VueCategorie_typeAssure.ToList());
        }

        public ActionResult About()
        {
            ViewBag.Message = "Your application description page.";

            return View();
        }

        public ActionResult ficheSoins()
        {
            var aSSURE = db.ASSURE;
            return View(aSSURE.Where(a => a.CODE_STATUT == 1).ToList());
        }
        public ActionResult EditionficheSoins()
        {
            var aSSURE = db.ASSURE;
            return View(aSSURE.Where(a => a.CODE_STATUT == 1).ToList());
        }
        public ActionResult Contact()
        {
            ViewBag.Message = "Your contact page.";

            return View();
        }
    }
}