public ActionResult EditQuestion(int id, string text, string inactive)
{
ViewBag.error = "";
if (id > 0) {
Boolean inActive = false;
inActive = (inactive == "on") ? true : false;
// retrieve the question with the id
try {
B2BDataContext db = new B2BDataContext();
B2BQuestion question = new B2BQuestion();
question = db.B2BQuestions.Where(x => x.id == id).FirstOrDefault<B2BQuestion>();
question.text = text;
question.inactive = inActive;
db.SubmitChanges();
ViewBag.question = question;
ViewBag.msg = "The question has been changed.";
} catch (Exception e) {
ViewBag.error = e.Message;
}
} else {
return RedirectToAction("Index");
}
return View();
}
public static string DeleteQuestion(int id)
{
try {
B2BDataContext db = new B2BDataContext();
B2BQuestion question = new B2BQuestion();
question = db.B2BQuestions.Where(x => x.id == id).FirstOrDefault<B2BQuestion>();
db.B2BQuestions.DeleteOnSubmit(question);
db.SubmitChanges();
return "";
} catch (Exception) {
return "Error while deleting";
}
}
public static B2BQuestion getQuestion(int questionID)
{
try {
B2BDataContext db = new B2BDataContext();
B2BQuestion question = new B2BQuestion();
question = db.B2BQuestions.Where(x => x.id == questionID).Select(x => x).FirstOrDefault<B2BQuestion>();
return question;
} catch (Exception e) {
throw new Exception("Could not load the question: " + e.Message);
}
}
public static void addQuestion(int testID, string text, bool inActive)
{
try {
B2BDataContext db = new B2BDataContext();
B2BQuestion newQuestion = new B2BQuestion();
newQuestion.testID = testID;
newQuestion.text = text;
newQuestion.date_added = DateTime.Now;
newQuestion.date_modified = DateTime.Now;
newQuestion.sort = 1;
newQuestion.inactive = inActive;
db.B2BQuestions.InsertOnSubmit(newQuestion);
db.SubmitChanges();
} catch (Exception e) {
throw new Exception("Could not add Question: " + e.Message);
}
}