using MALDFGASSURANCE.Models;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.IO;
using System.Linq;
using System.Net;
using System.Web.Mvc;

namespace MALDFGASSURANCE.Areas.FACTURATION.Controllers
{
    [Authorize(Roles = "Coordonnateur,MedecinConseil")]
    public class FACTUREPHARMACIESController : Controller
    {
        private MALDFGEntities db = new MALDFGEntities();

        // GET: FACTURATION/FACTUREPHARMACIES
        public ActionResult Index()
        {
            var fACTUREPHARMACIE = db.FACTUREPHARMACIE.Include(f => f.ASSURE).Include(f => f.PHARMACIE);
            return View(fACTUREPHARMACIE.ToList());
        }
        // GET: FACTURATION/FACTUREPHARMACIES/AlayseFacture 
        public ActionResult AlayseFacture()
        {
            var fACTUREPHARMACIE = db.FACTUREPHARMACIE.Include(f => f.ASSURE).Include(f => f.PHARMACIE);
            return View(fACTUREPHARMACIE.Where(p => p.ETAT == 1).ToList());
        }
        // GET: FACTURATION/FACTUREPHARMACIES/AlayseFactureEdit
        public ActionResult AlayseFactureEdit(string id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            FACTUREPHARMACIE fACTUREPHARMACIE = db.FACTUREPHARMACIE.Find(id);
            if (fACTUREPHARMACIE == null)
            {
                return HttpNotFound();
            }
            ViewBag.MATRICULE = new SelectList(db.ASSURE, "MATRICULE", "MATRICULE");
            ViewData["LISTEASSURE"] = db.ASSURE.ToList();
            ViewBag.REFPHARMACIE = new SelectList(db.PHARMACIE, "REFPHARMACIE", "RAISONSOCIALE");
            ViewBag.ID_TYPEFACTURE = new SelectList(db.TYPE_FACTURE, "ID_TYPEFACTURE", "LIBELLE_TYPEFACTURE");
            ViewData["LISTEMEDICAMENT"] = db.MEDICAMENT.Where(m => m.REFFACTUREPHAR == fACTUREPHARMACIE.REFFACTUREPHAR).ToList();
            ViewBag.STATUT = new SelectList(db.STATUT_FACTURE, "IDSTATUTFACTURE", "LIBELLESTATUT");
            return View(fACTUREPHARMACIE);
        }
        [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult AlayseFactureEdit([Bind(Include = "REFFACTUREPHAR,MATRICULE,DATE_EMISSION_FACTURE,NUMBON,REFPHARMACIE,NUMERO,MONTANT,MONTANTVALIDER,ETAT,IDUTILISATEUR,DATECREATION,DATEMODIFICATION,DATESUPPRESSION,DATEVALIDATION,PHOTO,ID_TYPEFACTURE,OBSERVATION,STATUT,DATEREMBOURSEMENT,PARTLDFG,PARTASSURE,PRESCRIPTEUR")] FACTUREPHARMACIE fACTUREPHARMACIE)
        {
            if (ModelState.IsValid)
            {
                db.Entry(fACTUREPHARMACIE).State = EntityState.Modified;
                db.SaveChanges();
                return RedirectToAction("Index");
            }
            ViewData["LISTEMEDICAMENT"] = db.MEDICAMENT.Where(m => m.REFFACTUREPHAR == fACTUREPHARMACIE.REFFACTUREPHAR).ToList();
            ViewBag.MATRICULE = new SelectList(db.ASSURE, "MATRICULE", "MATRICULE");
            ViewData["LISTEASSURE"] = db.ASSURE.ToList();
            ViewBag.REFPHARMACIE = new SelectList(db.PHARMACIE, "REFPHARMACIE", "RAISONSOCIALE");
            ViewBag.ID_TYPEFACTURE = new SelectList(db.TYPE_FACTURE, "ID_TYPEFACTURE", "LIBELLE_TYPEFACTURE");
            ViewBag.STATUT = new SelectList(db.STATUT_FACTURE, "IDSTATUTFACTURE", "LIBELLESTATUT");
            return View(fACTUREPHARMACIE);
        }
        public ActionResult AvisMedecin()
        {
            ViewBag.MATRICULE = new SelectList(db.ASSURE, "MATRICULE", "MATRICULE");
            ViewData["LISTEASSURE"] = db.ASSURE.ToList();
            ViewBag.REFPHARMACIE = new SelectList(db.PHARMACIE, "REFPHARMACIE", "RAISONSOCIALE");
            ViewBag.ID_TYPEFACTURE = new SelectList(db.TYPE_FACTURE, "ID_TYPEFACTURE", "LIBELLE_TYPEFACTURE");
            return View("Create");
        }
        [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult AvisMedecin([Bind(Include = "REFMEDICAMENT,REFFACTUREPHAR,DATE_EMISSION_FACTURE,NUMBON,LIBELLE,POSOLOGIE,QUANTITE,PRIXUNITAITRE,PRIXVALIDE,IDUTILISATEUR,DATECREATION,DATEMODIFIER,DATESUPPRIMER,DATEVALIDATION,OBSERVATION")] MEDICAMENT mEDICAMENT)
        {

            if (db.MEDICAMENT.Where(m => m.REFMEDICAMENT == mEDICAMENT.REFMEDICAMENT).Count() > 0)
            {
                if (ModelState.IsValid)
                {

                    MEDICAMENT eDICAMENT = new MEDICAMENT();
                    eDICAMENT = db.MEDICAMENT.Find(mEDICAMENT.REFMEDICAMENT);
                    eDICAMENT.OBSERVATION = mEDICAMENT.OBSERVATION;
                    eDICAMENT.QUANTITEVALIDER = mEDICAMENT.QUANTITEVALIDER;
                    eDICAMENT.PRIXVALIDE = eDICAMENT.PRIXUNITAITRE;
                    db.Entry(eDICAMENT).State = EntityState.Modified;
                    db.SaveChanges();
                    return RedirectToAction("AlayseFactureEdit/" + eDICAMENT.REFFACTUREPHAR);
                }
            }
            ViewBag.Message = " La reference est introuvable";
            ViewBag.REFFACTUREPHAR = new SelectList(db.FACTUREPHARMACIE, "REFFACTUREPHAR", "MATRICULE", mEDICAMENT.REFFACTUREPHAR);
            return RedirectToAction("AlayseFactureEdit/" + mEDICAMENT.REFFACTUREPHAR);
        }
        // GET: FACTURATION/FACTUREPHARMACIES/Details/5 
        public ActionResult Details(string id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            FACTUREPHARMACIE fACTUREPHARMACIE = db.FACTUREPHARMACIE.Find(id);
            if (fACTUREPHARMACIE == null)
            {
                return HttpNotFound();
            }
            ViewData["LISTEMEDICAMENT"] = db.MEDICAMENT.Where(m => m.REFFACTUREPHAR == fACTUREPHARMACIE.REFFACTUREPHAR).ToList();
            return View(fACTUREPHARMACIE);
        }

        // GET: FACTURATION/FACTUREPHARMACIES/Create
        public ActionResult Create()
        {
            ViewBag.MATRICULE = new SelectList(db.ASSURE, "MATRICULE", "MATRICULE");
            ViewData["LISTEASSURE"] = db.ASSURE.ToList();
            ViewBag.REFPHARMACIE = new SelectList(db.PHARMACIE, "REFPHARMACIE", "RAISONSOCIALE");
            ViewBag.ID_TYPEFACTURE = new SelectList(db.TYPE_FACTURE, "ID_TYPEFACTURE", "LIBELLE_TYPEFACTURE");
            return View();
        }

        // POST: FACTURATION/FACTUREPHARMACIES/Create
        // Afin de déjouer les attaques par survalidation, activez les propriétés spécifiques auxquelles vous voulez établir une liaison. Pour 
        // plus de détails, consultez https://go.microsoft.com/fwlink/?LinkId=317598.
        [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult Create([Bind(Include = "REFFACTUREPHAR,MATRICULE,LIBELLE_ETABLISSEMENT,NUMBON,DATE_EMISSION_FACTURE,REFPHARMACIE,NUMERO,MONTANT,MONTANTVALIDER,ETAT,IDUTILISATEUR,CODEAFFECTION,DATECREATION,DATEMODIFICATION,DATESUPPRESSION,DATEVALIDATION,PHOTO,ID_TYPEFACTURE,OBSERVATION,STATUT,DATEREMBOURSEMENT,PARTLDFG,PARTASSURE,PRESCRIPTEUR")] FACTUREPHARMACIE fACTUREPHARMACIE)
        {
            if (ModelState.IsValid)
            {
                try
                {

                    if (Request.Files.Count > 0)
                    {
                        var file = Request.Files[0];
                        //extension de fichier
                        if (file != null && file.ContentLength > 0)
                        {
                            string[] validFileTypes = { ".pdf", ".png", ".jpg", ".jpeg", ".PDF", ".PNG", ".JPG", ".JPEG" };
                            string ext = Path.GetExtension(file.FileName);
                            if (string.IsNullOrEmpty(ext) || !validFileTypes.Contains(ext))
                            {
                                ViewBag.Message = "le fichier veuillez enregistrer PDF, PNG ou JPG  ";
                                ViewData["LISTEASSURE"] = db.ASSURE.ToList();
                                ViewBag.MATRICULE = new SelectList(db.ASSURE, "MATRICULE", "MATRICULE");
                                ViewBag.REFPHARMACIE = new SelectList(db.PHARMACIE, "REFPHARMACIE", "RAISONSOCIALE");
                                ViewBag.ID_TYPEFACTURE = new SelectList(db.TYPE_FACTURE, "ID_TYPEFACTURE", "LIBELLE_TYPEFACTURE");
                                return View();
                            }


                            ASSURE aSSURE = db.ASSURE.Find(fACTUREPHARMACIE.MATRICULE);
                            int TAUX = Convert.ToInt32(aSSURE.ADHERENT.CATEGORIE_PROFESSIONELLE.TAUXCOUVERTURE.TAUX);
                            if (fACTUREPHARMACIE.MONTANT == fACTUREPHARMACIE.PARTASSURE + fACTUREPHARMACIE.PARTLDFG)
                            {

                                if (TAUX > 0)
                                {
                                    Random aleatoire = new Random();
                                    int chiffrealeatoire = aleatoire.Next(100, 999);
                                    fACTUREPHARMACIE.REFFACTUREPHAR = fACTUREPHARMACIE.MATRICULE + "PHAR" + fACTUREPHARMACIE.NUMERO.Replace('/', '_').Replace(' ', '-').Replace("\\", "-").Replace('.', '-') + chiffrealeatoire + DateTime.Now.ToString("ddMMyyHHmmss");
                                    var fileName = Path.GetFileName(file.FileName);
                                    String nomdufichier = fACTUREPHARMACIE.REFFACTUREPHAR.Replace('/', '-').Replace(' ', '-').Replace("\\", "_").Replace('.', '-') + ext;
                                    var path = Path.Combine(Server.MapPath("~/Fichier/FichierPharmacie"), nomdufichier);
                                    file.SaveAs(path);
                                    ViewBag.Message += "Taux est superieur à Zéro";
                                    fACTUREPHARMACIE.DATECREATION = DateTime.Now;
                                    fACTUREPHARMACIE.PHOTO = nomdufichier;
                                    fACTUREPHARMACIE.ID_TYPEFACTURE = 1;
                                    fACTUREPHARMACIE.TAUX = Convert.ToString(TAUX);
                                    fACTUREPHARMACIE.STATUT = 1;
                                    fACTUREPHARMACIE.ETAT = 1;
                                    var refFacture = fACTUREPHARMACIE.REFPHARMACIE;

                                    var nometablissement = db.PHARMACIE.Find(refFacture).RAISONSOCIALE;
                                    if (nometablissement != null || nometablissement != "")
                                    {
                                        fACTUREPHARMACIE.LIBELLE_ETABLISSEMENT = nometablissement;
                                        db.FACTUREPHARMACIE.Add(fACTUREPHARMACIE);
                                        db.SaveChanges();
                                        return RedirectToAction("FactureMedicaments/" + fACTUREPHARMACIE.REFFACTUREPHAR, "MEDICAMENTS");
                                    }
                                    else
                                    {
                                        ViewBag.Message += "ETABLISSEMENT N'EST PAS ENREGISTRE";
                                    }
                                }
                                else
                                {
                                    ViewBag.Message += "LE TAUX DE COUVERTURE N'EST RENSEIGNER";
                                }
                            }
                            else
                            {
                                ViewBag.Message += " PART DE L'ASSURÉ +  PART DE LDFG ≠ MONTANT TOTAL DE LA FACTURE ";
                            }

                        }

                    }
                }
                catch (DirectoryNotFoundException ex)
                {
                    ViewBag.Message += " liste" + ex;
                    ViewBag.Message += "le fichier veuillez enregistrer PDF, PNG ou JPG  ";
                    ViewBag.MATRICULE = new SelectList(db.ASSURE, "MATRICULE", "MATRICULE");
                    ViewData["LISTEASSURE"] = db.ASSURE.ToList();
                    ViewBag.REFPHARMACIE = new SelectList(db.PHARMACIE, "REFPHARMACIE", "RAISONSOCIALE");
                    ViewBag.ID_TYPEFACTURE = new SelectList(db.TYPE_FACTURE, "ID_TYPEFACTURE", "LIBELLE_TYPEFACTURE");
                    return View();
                }


            }

            ViewBag.Message += " une erreur s'est produite lors de l'enregistrement";
            ViewBag.MATRICULE = new SelectList(db.ASSURE, "MATRICULE", "MATRICULE");
            ViewData["LISTEASSURE"] = db.ASSURE.ToList();
            ViewBag.REFPHARMACIE = new SelectList(db.PHARMACIE, "REFPHARMACIE", "RAISONSOCIALE");
            ViewBag.ID_TYPEFACTURE = new SelectList(db.TYPE_FACTURE, "ID_TYPEFACTURE", "LIBELLE_TYPEFACTURE");
            return View(fACTUREPHARMACIE);
        }

        public ActionResult CreateDirect()
        {
            ViewBag.MATRICULE = new SelectList(db.ASSURE, "MATRICULE", "MATRICULE");
            ViewData["LISTEASSURE"] = db.ASSURE.ToList();
            ViewBag.REFPHARMACIE = new SelectList(db.PHARMACIE, "REFPHARMACIE", "RAISONSOCIALE");
            ViewBag.ID_TYPEFACTURE = new SelectList(db.TYPE_FACTURE, "ID_TYPEFACTURE", "LIBELLE_TYPEFACTURE");
            return View();
        }

        [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult CreateDirect([Bind(Include = "REFFACTUREPHAR,LIBELLE_ETABLISSEMENT,MATRICULE,NUMBON,DATE_EMISSION_FACTURE,REFPHARMACIE,NUMERO,MONTANT,MONTANTVALIDER,ETAT,IDUTILISATEUR,CODEAFFECTION,DATECREATION,DATEMODIFICATION,DATESUPPRESSION,DATEVALIDATION,PHOTO,ID_TYPEFACTURE,OBSERVATION,STATUT,DATEREMBOURSEMENT,PARTLDFG,PARTASSURE,PRESCRIPTEUR")] FACTUREPHARMACIE fACTUREPHARMACIE)
        {

            if (ModelState.IsValid)
            {
                try
                {

                    if (Request.Files.Count > 0)
                    {
                        var file = Request.Files[0];
                        //extension de fichier
                        if (file != null && file.ContentLength > 0)
                        {
                            string[] validFileTypes = { ".pdf", ".png", ".jpg", ".jpeg", ".PDF", ".PNG", ".JPG", ".JPEG" };
                            string ext = Path.GetExtension(file.FileName);
                            if (string.IsNullOrEmpty(ext) || !validFileTypes.Contains(ext))
                            {
                                ViewBag.Message = "le fichier veuillez enregistrer PDF, PNG ou JPG  ";
                                ViewData["LISTEASSURE"] = db.ASSURE.ToList();
                                ViewBag.MATRICULE = new SelectList(db.ASSURE, "MATRICULE", "MATRICULE");
                                ViewBag.REFPHARMACIE = new SelectList(db.PHARMACIE, "REFPHARMACIE", "RAISONSOCIALE");
                                ViewBag.ID_TYPEFACTURE = new SelectList(db.TYPE_FACTURE, "ID_TYPEFACTURE", "LIBELLE_TYPEFACTURE");
                                return View();
                            }


                            ASSURE aSSURE = db.ASSURE.Find(fACTUREPHARMACIE.MATRICULE);
                            int TAUX = Convert.ToInt32(aSSURE.ADHERENT.CATEGORIE_PROFESSIONELLE.TAUXCOUVERTURE.TAUX);
                            fACTUREPHARMACIE.PARTASSURE = Convert.ToInt32(fACTUREPHARMACIE.MONTANT * TAUX * 0.01);
                            fACTUREPHARMACIE.PARTLDFG = Convert.ToInt32(fACTUREPHARMACIE.MONTANT - fACTUREPHARMACIE.PARTASSURE);

                            if (fACTUREPHARMACIE.MONTANT == fACTUREPHARMACIE.PARTASSURE + fACTUREPHARMACIE.PARTLDFG)
                            {

                                if (TAUX > 0)
                                {
                                    Random aleatoire = new Random();
                                    int chiffrealeatoire = aleatoire.Next(100, 999);
                                    fACTUREPHARMACIE.REFFACTUREPHAR = fACTUREPHARMACIE.MATRICULE + "PHAR" + fACTUREPHARMACIE.NUMERO.Replace('/', '_').Replace(' ', '_').Replace("\\", "_") + "_" + chiffrealeatoire + DateTime.Now.ToString("ddMMyyHHmmss");
                                    var fileName = Path.GetFileName(file.FileName);
                                    String nomdufichier = fACTUREPHARMACIE.REFFACTUREPHAR.Replace('/', '_').Replace(' ', '_').Replace("\\", "_") + ext;
                                    var path = Path.Combine(Server.MapPath("~/Fichier/FichierPharmacie"), nomdufichier);
                                    file.SaveAs(path);
                                    ViewBag.Message += "Taux est superieur à Zéro";
                                    fACTUREPHARMACIE.DATECREATION = DateTime.Now;
                                    fACTUREPHARMACIE.PHOTO = nomdufichier;
                                    fACTUREPHARMACIE.ID_TYPEFACTURE = 2;
                                    fACTUREPHARMACIE.REFPHARMACIE = "1";
                                    fACTUREPHARMACIE.TAUX = Convert.ToString(TAUX);
                                    fACTUREPHARMACIE.STATUT = 1;
                                    fACTUREPHARMACIE.ETAT = 1;
                                    if (fACTUREPHARMACIE.LIBELLE_ETABLISSEMENT != null || fACTUREPHARMACIE.LIBELLE_ETABLISSEMENT != "")
                                        db.FACTUREPHARMACIE.Add(fACTUREPHARMACIE);
                                    db.SaveChanges();
                                    return RedirectToAction("FactureMedicaments/" + fACTUREPHARMACIE.REFFACTUREPHAR, "MEDICAMENTS");
                                }
                                else
                                {
                                    ViewBag.Message += "VEUILLEZ SAISIR LE NOM DE L'ETABLISSEMENT";
                                }
                            }
                            else
                            {
                                ViewBag.Message += "LE TAUX DE COUVERTURE N'EST RENSEIGNER";
                            }
                        }
                        else
                        {
                            ViewBag.Message += " PART DE L'ASSURÉ +  PART DE LDFG ≠ MONTANT TOTAL DE LA FACTURE ";
                        }

                    }

                }
                catch (DirectoryNotFoundException ex)
                {
                    ViewBag.Message += " liste" + ex;
                    ViewBag.Message += "le fichier veuillez enregistrer PDF, PNG ou JPG  ";
                    ViewBag.MATRICULE = new SelectList(db.ASSURE, "MATRICULE", "MATRICULE");
                    ViewData["LISTEASSURE"] = db.ASSURE.ToList();
                    ViewBag.REFPHARMACIE = new SelectList(db.PHARMACIE, "REFPHARMACIE", "RAISONSOCIALE");
                    ViewBag.ID_TYPEFACTURE = new SelectList(db.TYPE_FACTURE, "ID_TYPEFACTURE", "LIBELLE_TYPEFACTURE");
                    return View();
                }
            }

            ViewBag.Message += " une erreur s'est produite lors de l'enregistrement";
            ViewBag.MATRICULE = new SelectList(db.ASSURE, "MATRICULE", "MATRICULE");
            ViewData["LISTEASSURE"] = db.ASSURE.ToList();
            ViewBag.REFPHARMACIE = new SelectList(db.PHARMACIE, "REFPHARMACIE", "RAISONSOCIALE");
            ViewBag.ID_TYPEFACTURE = new SelectList(db.TYPE_FACTURE, "ID_TYPEFACTURE", "LIBELLE_TYPEFACTURE");
            return View(fACTUREPHARMACIE);

        }

        // GET: FACTURATION/FACTUREPHARMACIES/Edit/5
        public ActionResult Edit(string id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            FACTUREPHARMACIE fACTUREPHARMACIE = db.FACTUREPHARMACIE.Find(id);
            if (fACTUREPHARMACIE == null)
            {
                return HttpNotFound();
            }
            ViewBag.MATRICULE = new SelectList(db.ASSURE, "MATRICULE", "MATRICULE");
            ViewData["LISTEASSURE"] = db.ASSURE.ToList();
            ViewBag.REFPHARMACIE = new SelectList(db.PHARMACIE, "REFPHARMACIE", "RAISONSOCIALE");
            ViewBag.ID_TYPEFACTURE = new SelectList(db.TYPE_FACTURE, "ID_TYPEFACTURE", "LIBELLE_TYPEFACTURE");
            return View(fACTUREPHARMACIE);
        }

        // POST: FACTURATION/FACTUREPHARMACIES/Edit/5
        // Afin de déjouer les attaques par survalidation, activez les propriétés spécifiques auxquelles vous voulez établir une liaison. Pour 
        // plus de détails, consultez https://go.microsoft.com/fwlink/?LinkId=317598.
        [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult Edit([Bind(Include = "REFFACTUREPHAR,MATRICULE,NUMBON,DATE_EMISSION_FACTURE,REFPHARMACIE,NUMERO,MONTANT,MONTANTVALIDER,ETAT,IDUTILISATEUR,DATECREATION,DATEMODIFICATION,DATESUPPRESSION,DATEVALIDATION,PHOTO,ID_TYPEFACTURE,OBSERVATION,STATUT,DATEREMBOURSEMENT,PARTLDFG,PARTASSURE,PRESCRIPTEUR")] FACTUREPHARMACIE fACTUREPHARMACIE)
        {
            if (ModelState.IsValid)
            {
                db.Entry(fACTUREPHARMACIE).State = EntityState.Modified;
                db.SaveChanges();
                return RedirectToAction("Index");
            }
            ViewBag.MATRICULE = new SelectList(db.ASSURE, "MATRICULE", "MATRICULE");
            ViewData["LISTEASSURE"] = db.ASSURE.ToList();
            ViewBag.REFPHARMACIE = new SelectList(db.PHARMACIE, "REFPHARMACIE", "RAISONSOCIALE");
            ViewBag.ID_TYPEFACTURE = new SelectList(db.TYPE_FACTURE, "ID_TYPEFACTURE", "LIBELLE_TYPEFACTURE");
            return View(fACTUREPHARMACIE);
        }

        [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult EditValidation([Bind(Include = "REFMEDICAMENT,REFFACTUREPHAR,QUANTITE,OBSERVATION,STATUT")] MEDICAMENT mEDICAMENT)
        {
            if (db.MEDICAMENT.Where(m => m.REFMEDICAMENT == mEDICAMENT.REFMEDICAMENT).Count() > 0)
            {
                if (ModelState.IsValid)
                {

                    MEDICAMENT eDICAMENT = new MEDICAMENT();
                    eDICAMENT = db.MEDICAMENT.Find(mEDICAMENT.REFMEDICAMENT);
                    eDICAMENT.OBSERVATION = mEDICAMENT.OBSERVATION;
                    if (mEDICAMENT.STATUT == 3)
                    {
                        eDICAMENT.QUANTITEVALIDER = 0;
                        eDICAMENT.PRIXVALIDE = 0;
                    }
                    else
                    {
                        eDICAMENT.QUANTITEVALIDER = mEDICAMENT.QUANTITE;
                        eDICAMENT.PRIXVALIDE = eDICAMENT.PRIXUNITAITRE;
                    }
                    eDICAMENT.STATUT = mEDICAMENT.STATUT;
                    eDICAMENT.ETAT = 2;
                    db.Entry(eDICAMENT).State = EntityState.Modified;
                    db.SaveChanges();
                    return RedirectToAction("AlayseFactureEdit/" + eDICAMENT.REFFACTUREPHAR);
                }
            }
            ViewBag.Message = " La reference est introuvable";
            return RedirectToAction("AlayseFactureEdit/" + mEDICAMENT.REFFACTUREPHAR);
        }

        // GET: FACTURATION/FACTUREPHARMACIES/Delete/5  ValiderMedicament

        public ActionResult ValiderMedicament(decimal id)
        {
            MEDICAMENT meDICAMENT = new MEDICAMENT();
            meDICAMENT = db.MEDICAMENT.Find(id);
            if (ModelState.IsValid)
            {
                meDICAMENT.ETAT = 2;
                meDICAMENT.STATUT = 2;
                meDICAMENT.QUANTITEVALIDER = meDICAMENT.QUANTITE;
                meDICAMENT.PRIXVALIDE = meDICAMENT.PRIXUNITAITRE;

                db.Entry(meDICAMENT).State = EntityState.Modified;
                db.SaveChanges();
                return RedirectToAction("AlayseFactureEdit/" + meDICAMENT.REFFACTUREPHAR);
            }
            return RedirectToAction("AlayseFactureEdit/" + id);
        }

        public ActionResult TerminerFacturePharmacie(string id)
        {
            FACTUREPHARMACIE fACTUREPHARMACIE = new FACTUREPHARMACIE();
            MEDICAMENT mEDICAMENT = new MEDICAMENT();
            fACTUREPHARMACIE = db.FACTUREPHARMACIE.Find(id);

            foreach (var listMedicament in db.MEDICAMENT.Where(m => m.REFFACTUREPHAR == id).ToList() as IList<MEDICAMENT>)
            {
                if (listMedicament.STATUT != 2 && listMedicament.STATUT != 3)
                {
                    listMedicament.QUANTITEVALIDER = listMedicament.QUANTITE;
                    listMedicament.PRIXVALIDE = listMedicament.PRIXUNITAITRE;
                    listMedicament.STATUT = 2;
                }
                listMedicament.ETAT = 2;

                db.Entry(listMedicament).State = EntityState.Modified;
                db.SaveChanges();
            }
            fACTUREPHARMACIE = db.FACTUREPHARMACIE.Find(id);
            fACTUREPHARMACIE.MONTANTVALIDER = Convert.ToInt32(db.MEDICAMENT.Where(m => (m.REFFACTUREPHAR == id && m.STATUT == 2)).Sum(m => m.PRIXVALIDE * m.QUANTITEVALIDER));
            fACTUREPHARMACIE.ETAT = 2;
            fACTUREPHARMACIE.STATUT = 2;
            fACTUREPHARMACIE.IDUTILISATEUR = User.Identity.Name;
            fACTUREPHARMACIE.DATEMODIFICATION = DateTime.Now;
            db.Entry(fACTUREPHARMACIE).State = EntityState.Modified;
            db.SaveChanges();
            return RedirectToAction("AlayseFactureEdit/" + id);

        }
        public ActionResult Delete(string id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            FACTUREPHARMACIE fACTUREPHARMACIE = db.FACTUREPHARMACIE.Find(id);
            if (fACTUREPHARMACIE == null)
            {
                return HttpNotFound();
            }
            return View(fACTUREPHARMACIE);
        }

        // POST: FACTURATION/FACTUREPHARMACIES/Delete/5
        [HttpPost, ActionName("Delete")]
        [ValidateAntiForgeryToken]
        public ActionResult DeleteConfirmed(string id)
        {
            FACTUREPHARMACIE fACTUREPHARMACIE = db.FACTUREPHARMACIE.Find(id);
            db.FACTUREPHARMACIE.Remove(fACTUREPHARMACIE);
            db.SaveChanges();
            return RedirectToAction("Index");
        }

        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                db.Dispose();
            }
            base.Dispose(disposing);
        }
    }
}