public ActionResult Create(SURVEY_QUESTIONS survey_questions)
{
if (survey_questions.survey_id == 0)
{ ModelState.AddModelError("survey_id", "Survey is a required field."); }
if (survey_questions.question_id == 0)
{ ModelState.AddModelError("question_id", "Question is a required field."); }
if (survey_questions.section_id == 0)
{ ModelState.AddModelError("section_id", "Survey Section is a required field."); }
//check if the question already exits in the survey
if (survey_questions.question_id > 0 && survey_questions.survey_id > 0)
{
SURVEY_QUESTIONS survey_questions_check = db.SURVEY_QUESTIONS.SingleOrDefault(s => s.survey_id == survey_questions.survey_id && s.question_id == survey_questions.question_id);
string checkforNulls = Convert.ToString(survey_questions_check);
if (!String.IsNullOrEmpty(checkforNulls))
{
//var survey_quesinons_check
if (survey_questions_check.question_id == survey_questions.question_id) { ModelState.AddModelError("survey_id", "Dupicate questions are not allowed on the same survey."); }
}
}
if (ModelState.IsValid)
{
db.SURVEY_QUESTIONS.AddObject(survey_questions);
db.SaveChanges();
//return RedirectToAction("Details", "Survey", survey_questions.survey_id);
return RedirectToAction("Details", new RouteValueDictionary(new { controller = "Survey", action = "Details", Id = survey_questions.survey_id }));
}
ViewBag.question_id = new SelectList(db.QUESTIONs, "question_id", "question_text", survey_questions.question_id);
ViewBag.survey_id = new SelectList(db.SURVEYs, "survey_id", "title", survey_questions.survey_id);
ViewBag.section_id = new SelectList(db.SURVEY_SECTION, "survey_section_id", "title", survey_questions.section_id);
return View(survey_questions);
}
/// <summary>
/// Deprecated Method for adding a new object to the SURVEY_QUESTIONS EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToSURVEY_QUESTIONS(SURVEY_QUESTIONS sURVEY_QUESTIONS)
{
base.AddObject("SURVEY_QUESTIONS", sURVEY_QUESTIONS);
}
/// <summary>
/// Create a new SURVEY_QUESTIONS object.
/// </summary>
/// <param name="survey_questions_id">Initial value of the survey_questions_id property.</param>
/// <param name="survey_id">Initial value of the survey_id property.</param>
/// <param name="question_id">Initial value of the question_id property.</param>
/// <param name="section_id">Initial value of the section_id property.</param>
public static SURVEY_QUESTIONS CreateSURVEY_QUESTIONS(global::System.Int32 survey_questions_id, global::System.Int32 survey_id, global::System.Int32 question_id, global::System.Int32 section_id)
{
SURVEY_QUESTIONS sURVEY_QUESTIONS = new SURVEY_QUESTIONS();
sURVEY_QUESTIONS.survey_questions_id = survey_questions_id;
sURVEY_QUESTIONS.survey_id = survey_id;
sURVEY_QUESTIONS.question_id = question_id;
sURVEY_QUESTIONS.section_id = section_id;
return sURVEY_QUESTIONS;
}
public ActionResult Edit(SURVEY_QUESTIONS survey_questions)
{
if (ModelState.IsValid)
{
db.SURVEY_QUESTIONS.Attach(survey_questions);
db.ObjectStateManager.ChangeObjectState(survey_questions, EntityState.Modified);
db.SaveChanges();
return RedirectToAction("Details", "Survey", survey_questions.survey_id);
//return RedirectToAction(".../Survey/Details", survey_questions.section_id);
}
ViewBag.question_id = new SelectList(db.QUESTIONs, "question_id", "question_text", survey_questions.question_id);
ViewBag.survey_id = new SelectList(db.SURVEYs, "survey_id", "title", survey_questions.survey_id);
ViewBag.section_id = new SelectList(db.SURVEY_SECTION, "survey_section_id", "title", survey_questions.section_id);
return View(survey_questions);
}
