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

namespace MALDFGASSURANCE.Areas.STATISTIQUE.Controllers
{
    [Authorize(Roles = "Coordonnateur, CorpsMedical, MedecinConseil, PDG, Conseil, SuperAdministrateur, PresidentMutuelle")]
    public class DatastataController : Controller
    {
        private MALDFGEntities db = new MALDFGEntities();
        // GET: STATISTIQUE/Datastata

        public ActionResult Index()
        {
            IList<SynthesedesdonneesModel> synthesedesdonneesList = new List<SynthesedesdonneesModel>();

            var cATEGORIE_PROFESSIONELLE = db.CATEGORIE_PROFESSIONELLE;

            foreach (var liste in cATEGORIE_PROFESSIONELLE.ToList() as IList<CATEGORIE_PROFESSIONELLE>)
            {
                SynthesedesdonneesModel synthesedesdonneesModel = new SynthesedesdonneesModel();
                synthesedesdonneesModel.CATEGORIE = liste.LIBELLE_CATEGORIE_PROFESSIONELLE;
                synthesedesdonneesModel.TAUX = liste.TAUXCOUVERTURE.TAUX;
                synthesedesdonneesModel.NOMBREASSURES = db.ASSURE.Where(a => a.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == liste.CODE_CATEGORIE_PROFESSIONELLE).Count();
                synthesedesdonneesModel.NOMBRESACTES = db.PRESTATIONS.Where(p => p.FACTURE.ASSURE.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == liste.CODE_CATEGORIE_PROFESSIONELLE).Count() + db.FACTUREPHARMACIE.Where(f => f.ASSURE.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == liste.CODE_CATEGORIE_PROFESSIONELLE).Count();
                synthesedesdonneesModel.PRIMESASSURANCEPRORATA = 0;
                if (int.TryParse(db.FACTURE.Where(f => f.ASSURE.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == liste.CODE_CATEGORIE_PROFESSIONELLE && f.STATUT == 2).Sum(f => f.MONTANTVALIDER).ToString(), out int montant))
                {
                    synthesedesdonneesModel.FACTURESVALIDEES = montant;

                }
                if (int.TryParse("" + db.FACTURE.Where(f => f.ASSURE.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == liste.CODE_CATEGORIE_PROFESSIONELLE && f.STATUT == 2).Sum(f => f.MONTANTVALIDER), out int montantconsomation))
                {
                    synthesedesdonneesModel.CONSOMMATIONRELLE = montantconsomation;
                }
                if (int.TryParse(db.FACTURE.Where(f => f.ASSURE.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == liste.CODE_CATEGORIE_PROFESSIONELLE && f.STATUT == 2).Sum(f => f.MONTANTVALIDER).ToString(), out int montantrelle))
                {
                    synthesedesdonneesModel.CONSOMMATIONRELLE = montantrelle;
                }

                synthesedesdonneesModel.PROVISIONTECHNIQUEPRORATA = 0;
                synthesedesdonneesModel.TAUXCONSOMMATION = 0;
                synthesedesdonneesModel.COTISATIONEMISES = 0;
                if (db.PAYERCOTISATION.Where(c => c.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == liste.CODE_CATEGORIE_PROFESSIONELLE).Count() > 0)
                {
                    if (int.TryParse("" + db.PAYERCOTISATION.Where(c => c.ADHERENT.CODE_CATEGORIE_PROFESSIONELLE == liste.CODE_CATEGORIE_PROFESSIONELLE).Sum(c => c.MONTANT_PAYE), out int montantCotisation))
                    {
                        synthesedesdonneesModel.COTISATIONPERCUES = montantCotisation;

                    }
                }
                synthesedesdonneesModel.TAUXCONSOMMATION = 0;
                synthesedesdonneesList.Add(synthesedesdonneesModel);
            }
            ViewData["Systemes"] = synthesedesdonneesList;

            return View(cATEGORIE_PROFESSIONELLE.ToList());

        }
        // GET: STATISTIQUE/Datastata/Synthesedonnees
        public ActionResult Synthesedonnees()
        {
            int trimestre1 = 0;
            int trimestre2 = 0;
            int trimestre3 = 0;
            int trimestre4 = 0;
            var Consommationannuel = db.View_Consommationannuel.Where(c => c.MOIS != null && c.ANNEE == DateTime.Today.Year).ToList();
            foreach (var liste in Consommationannuel as IList<View_Consommationannuel>)
            {
                if (liste.MOIS != null)
                {
                    if (liste.MOIS <= 3)
                    {
                        trimestre1 = trimestre1 + Convert.ToInt32(liste.MONTANTLDF);
                    }

                    else if (liste.MOIS <= 6)
                    {
                        trimestre2 = trimestre2 + Convert.ToInt32(liste.MONTANTLDF);
                    }
                    else if (liste.MOIS <= 9)
                    {
                        trimestre3 = trimestre3 + Convert.ToInt32(liste.MONTANTLDF);
                    }
                    else if (liste.MOIS <= 12)
                    {
                        trimestre4 = trimestre4 + Convert.ToInt32(liste.MONTANTLDF);
                    }
                }

            }


            ViewBag.trimestre1 = trimestre1;
            ViewBag.trimestre2 = trimestre2;
            ViewBag.trimestre3 = trimestre3;
            ViewBag.trimestre4 = trimestre4;
            return View(Consommationannuel);

        }

        public ActionResult ListSynthesedonnees()
        {

            var Consommationannuel = db.View_Consommationannuel.Where(c => c.MOIS != null).ToList();
            return View(Consommationannuel);
        }
        // GET: STATISTIQUE/Datastata/statistiquesgenerales
        public ActionResult statistiquesgenerales()
        {
            var STATFACTGENERAL = db.View_STATFACTGENERAL_ANNEE_TPASSURE_CATPROF.Where(st => st.ANNEE != null).ToList();
            return View(STATFACTGENERAL);
        }
        // GET:  STATISTIQUE/Datastata/Etatdepensesstatcatprof
        public ActionResult Etatdepensesstatcatprof()
        {
            var STATFACTGENERAL_ANNEE_TPASSURE_CATPROF = db.View_STATFACTGENERAL_ANNEE_TPASSURE_CATPROF.Where(s => s.ANNEE != null).ToList();
            return View(STATFACTGENERAL_ANNEE_TPASSURE_CATPROF);
        }
        // GET: STATISTIQUE/Datastata/Etatdepensesmensfam
        public ActionResult Etatdepensesmensfam()
        {
            var DEPENSES_MOIS_FAMILLE_GROUP = db.View_DEPENSES_MOIS_FAMILLE_GROUP.ToList();
            return View(DEPENSES_MOIS_FAMILLE_GROUP);
        }
        // GET: STATISTIQUE/Datastata/Create
        public ActionResult Etatdepensespharmacie()
        {
            var DEPENSESPHARMACIE_ANNEE = db.View_DEPENSESPHARMACIE_ANNEE.Where(d => d.ANNEE != null).ToList();
            return View(DEPENSESPHARMACIE_ANNEE);
        }
        // GET: STATISTIQUE/Datastata/Create
        public ActionResult Etatdepensesclinique()
        {
            var DEPENSESCLINIQUE_ANNEE = db.View_DEPENSESCLINIQUE_ANNEE.Where(dc => dc.ANNEE != null).ToList();
            return View(DEPENSESCLINIQUE_ANNEE);
        }
        // GET: STATISTIQUE/Datastata/Create
        public ActionResult Encaissementsprimes()
        {
            var ENCAISSEMENTSASSURE = db.View_ENCAISSEMENTSASSURE.ToList();
            return View(ENCAISSEMENTSASSURE);
        }
        // GET: STATISTIQUE/Datastata/Details/5
        public ActionResult Details(int id)
        {
            return View();
        }

        // GET: STATISTIQUE/Datastata/Create
        public ActionResult Create()
        {
            return View();
        }

        // POST: STATISTIQUE/Datastata/Create
        [HttpPost]
        public ActionResult Create(FormCollection collection)
        {
            try
            {
                // TODO: Add insert logic here

                return RedirectToAction("Index");
            }
            catch
            {
                return View();
            }
        }

        // GET: STATISTIQUE/Datastata/Edit/5
        public ActionResult Edit(int id)
        {
            return View();
        }

        // POST: STATISTIQUE/Datastata/Edit/5
        [HttpPost]
        public ActionResult Edit(int id, FormCollection collection)
        {
            try
            {
                // TODO: Add update logic here

                return RedirectToAction("Index");
            }
            catch
            {
                return View();
            }
        }

        // GET: STATISTIQUE/Datastata/Delete/5
        public ActionResult Delete(int id)
        {
            return View();
        }

        // POST: STATISTIQUE/Datastata/Delete/5
        [HttpPost]
        public ActionResult Delete(int id, FormCollection collection)
        {
            try
            {
                // TODO: Add delete logic here

                return RedirectToAction("Index");
            }
            catch
            {
                return View();
            }
        }
    }
}