public ActionResult Create(QUESTION question)
        {
            if (question.question_text == "")
            { ModelState.AddModelError("question_text", "This is a required field."); }
            if (question.answer_type_id == 0)
            { ModelState.AddModelError("answer_type_id", "This is a required field."); }

            question.user_stamp = 1;
            question.datestamp = DateTime.Now;
            int answerType = question.answer_type_id;

            if (ModelState.IsValid)
            {
                db.QUESTIONs.AddObject(question);
                db.SaveChanges();

                //NEEDS to bE FIXED
                //this needs to check the answer type name and not in index in the database
                //there is no guarentee the numbers are the same

                if ((answerType == 2) || (answerType == 3))
                {
                    var choices = new Survey.Models.MultipleChoiceItem();
                    choices.QID = question.question_id;
                    choices.Questiontext = question.question_text;

                    return RedirectToAction("MultipleChoiceCreate", choices);
                }
            }

            return RedirectToAction("Index");
        }
        public ActionResult MultipleChoiceCreate(MultipleChoiceItem choices)
        {
            if (!String.IsNullOrEmpty(choices.ChoiceText1))
            {
                var question_multiple_choice = new QUESTION_MULTIPLE_CHOICE();

                question_multiple_choice.question_id = choices.QID;
                question_multiple_choice.choice_text = choices.ChoiceText1;

                if (ModelState.IsValid)
                {
                    db.QUESTION_MULTIPLE_CHOICE.AddObject(question_multiple_choice);
                    db.SaveChanges();
                }

            }

            if (!String.IsNullOrEmpty(choices.ChoiceText2))
            {
                var question_multiple_choice = new QUESTION_MULTIPLE_CHOICE();

                question_multiple_choice.question_id = choices.QID;
                question_multiple_choice.choice_text = choices.ChoiceText2;

                if (ModelState.IsValid)
                {
                    db.QUESTION_MULTIPLE_CHOICE.AddObject(question_multiple_choice);
                    db.SaveChanges();
                }

            }

            if (!String.IsNullOrEmpty(choices.ChoiceText3))
            {
                var question_multiple_choice = new QUESTION_MULTIPLE_CHOICE();

                question_multiple_choice.question_id = choices.QID;
                question_multiple_choice.choice_text = choices.ChoiceText3;

                if (ModelState.IsValid)
                {
                    db.QUESTION_MULTIPLE_CHOICE.AddObject(question_multiple_choice);
                    db.SaveChanges();
                }

            }

            if (!String.IsNullOrEmpty(choices.ChoiceText4))
            {
                var question_multiple_choice = new QUESTION_MULTIPLE_CHOICE();

                question_multiple_choice.question_id = choices.QID;
                question_multiple_choice.choice_text = choices.ChoiceText4;

                if (ModelState.IsValid)
                {
                    db.QUESTION_MULTIPLE_CHOICE.AddObject(question_multiple_choice);
                    db.SaveChanges();
                }

            }

            if (!String.IsNullOrEmpty(choices.ChoiceText5))
            {
                var question_multiple_choice = new QUESTION_MULTIPLE_CHOICE();

                question_multiple_choice.question_id = choices.QID;
                question_multiple_choice.choice_text = choices.ChoiceText5;

                if (ModelState.IsValid)
                {
                    db.QUESTION_MULTIPLE_CHOICE.AddObject(question_multiple_choice);
                    db.SaveChanges();
                }
            }

            ModelState.Clear();
            return View(choices);
        }