public static void addAnswer(int questionID, string text, bool isCorrect, bool inActive)
{
try {
B2BDataContext db = new B2BDataContext();
B2BAnswer newAnswer = new B2BAnswer();
newAnswer.questionID = questionID;
newAnswer.text = text;
newAnswer.isCorrect = isCorrect;
newAnswer.date_added = DateTime.Now;
newAnswer.date_modified = DateTime.Now;
newAnswer.inactive = inActive;
db.B2BAnswers.InsertOnSubmit(newAnswer);
db.SubmitChanges();
} catch (Exception e) {
throw new Exception("Could not add Answer: " + e.Message);
}
}
public ActionResult EditAnswer(int id, string text, string isCorrect, string inactive)
{
ViewBag.error = "";
Boolean inActive = false;
inActive = (inactive == "on") ? true : false;
bool isCorrectAnswer = false;
if (isCorrect == "on") { isCorrectAnswer = true; } else { isCorrectAnswer = false; }
if (id > 0) {
// retrieve the answer with the id
try {
B2BDataContext db = new B2BDataContext();
B2BAnswer answer = new B2BAnswer();
answer = db.B2BAnswers.Where(x => x.id == id).FirstOrDefault<B2BAnswer>();
answer.text = text;
answer.isCorrect = isCorrectAnswer;
answer.inactive = inActive;
db.SubmitChanges();
ViewBag.answer = answer;
ViewBag.msg = "The answer has been changed.";
} catch (Exception e) {
ViewBag.error = e.Message;
}
} else {
return RedirectToAction("Index");
}
return View();
}
// get individual objects
public static B2BAnswer getAnswer(int answerID)
{
try {
B2BDataContext db = new B2BDataContext();
B2BAnswer answer = new B2BAnswer();
answer = db.B2BAnswers.Where(x => x.id == answerID).Select(x => x).FirstOrDefault<B2BAnswer>();
return answer;
} catch (Exception e) {
throw new Exception("could not retrieve the answer: " + e.Message);
}
}
public static string DeleteAnswer(int id)
{
try {
B2BDataContext db = new B2BDataContext();
B2BAnswer answer = new B2BAnswer();
answer = db.B2BAnswers.Where(x => x.id == id).FirstOrDefault<B2BAnswer>();
db.B2BAnswers.DeleteOnSubmit(answer);
db.SubmitChanges();
return "";
} catch (Exception) {
return "Error while deleting";
}
}
