public ActionResult AssignQuestionnaire(int id, AssignWorkViewModel model)
        {
            if (ModelState.IsValid)
            {
                var questionnaire = db.Questionnaires.Find(id);
                if (questionnaire != null)
                {
                    questionnaire.CRUMEmployeeID = model.CMEEmployeeID;
                }

                db.Entry(questionnaire).State = EntityState.Modified;
                db.SaveChanges();

                AssignWork assignwork = new AssignWork
                {
                    QuestionnaireID = questionnaire.QuestionnaireID,
                    CMEEmployeeID   = questionnaire.CRUMEmployeeID,
                    CSEmployeeID    = questionnaire.CRUSEmployeeID,
                    AssignmentDate  = DateTime.Now
                };

                db.AssignWorks.Add(assignwork);
                db.SaveChanges();

                return(RedirectToAction("CRUSupervisorIndex"));
            }

            var Supervisor = db.CRUSupervisors.Where(s => s.Id == model.CSEmployeeID).First();
            var list       = db.CRUMembers.ToList().Where(m => m.Region == Supervisor.Region);

            ViewBag.EmployeeId = new SelectList(list, "Id", "FullName");

            ViewBag.QuestionnaireTypeId = new SelectList(db.QuestionnaireTypes, "QuestionnaireTypeId", "QuestionnaireTypeName");
            return(View());
        }
        // GET: Questionnaire/AssignQuestionnaire/5
        public ActionResult AssignQuestionnaire(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            Questionnaire questionnaire = db.Questionnaires.Find(id);

            if (questionnaire == null)
            {
                return(HttpNotFound());
            }

            AssignWorkViewModel model = new AssignWorkViewModel
            {
                QuestionnaireID = questionnaire.QuestionnaireID,
                CMEEmployeeID   = questionnaire.CRUMEmployeeID,
                CSEmployeeID    = questionnaire.CRUSEmployeeID
            };

            //var Supervisor = db.CRUSupervisors.Where(s => s.Id == model.CRUSEmployeeID).First();
            //var list = db.CRUMembers.ToList().Where(m => m.Region == Supervisor.Region);
            //ViewBag.EmployeeId = new SelectList(list, "Id", "FullName");

            var list = db.CRUMembers.ToList().Where(m => m.Region == questionnaire.CRUSupervisor.Region);

            ViewBag.EmployeeId = new SelectList(list, "Id", "FullName");

            ViewBag.QuestionnaireTypeId = new SelectList(db.QuestionnaireTypes, "QuestionnaireTypeId", "QuestionnaireTypeName");
            return(View(model));
        }