public ActionResult AddDiagnosisToPatient(string patientID)
        {
            if (patientID == null)
            {
                return(View("Error"));
            }

            var db = new ApplicationDbContext();

            var non = from map in db.DiagnosisMap
                      join diagnosis in db.Diagnoses on map.DiagnosisID equals diagnosis.DiagnosisID
                      where map.UserID == patientID
                      select diagnosis;

            var d = db.Diagnoses.ToList().Except(non).ToList();

            var name = db.Users.Where(u => u.Id == patientID).FirstOrDefault().Identifier.FullName;

            var model = new AddDiagnosisToPatientViewModel
            {
                Diagnoses   = d,
                PatientName = name,
                PatientID   = patientID,
            };


            return(View(model));
        }
        public ActionResult AddDiagnosisToPatient(AddDiagnosisToPatientViewModel model)
        {
            if (!ModelState.IsValid)
            {
                return(View(model));
            }

            var db = new ApplicationDbContext();

            var patientDiagnosis = new DiagnosisMap
            {
                UserID      = model.PatientID,
                DiagnosisID = model.DiagnosisID
            };

            db.DiagnosisMap.Add(patientDiagnosis);
            db.SaveChanges();

            return(RedirectToAction("Index"));
        }