public ActionResult DeleteQuestion(DailyQuestionViewModel viewModel) { ViewBag.ViewModel = viewModel; if (viewModel.KeyID != null) { viewModel.QuestionID = viewModel.DecryptKeyValue(); } var item = models.GetTable <PDQQuestion>().Where(q => q.QuestionID == viewModel.QuestionID && q.GroupID == 6).FirstOrDefault(); if (item != null) { if (models.GetTable <PDQTask>().Any(t => t.QuestionID == item.QuestionID)) { viewModel.Status = (int)Naming.GeneralStatus.Failed; return(CommitQuestionStatus(viewModel)); } else { models.ExecuteCommand("delete PDQQuestion where QuestionID={0}", item.QuestionID); return(Json(new { result = true })); } } return(View("~/Views/Shared/JsAlert.cshtml", model: "問與答資料錯誤!!")); }
public ActionResult LoadDailyQuestion(DailyQuestionViewModel viewModel) { ViewBag.ViewModel = viewModel; if (viewModel.KeyID != null) { viewModel.QuestionID = viewModel.DecryptKeyValue(); } var item = models.GetTable <PDQQuestion>().Where(q => q.QuestionID == viewModel.QuestionID && q.GroupID == 6).FirstOrDefault(); if (item != null) { return(View("~/Views/Activity/Module/DailyQuestionDataItem.ascx", item)); } return(View("~/Views/Shared/JsAlert.cshtml", model: "問與答資料錯誤!!")); }
public ActionResult CommitQuestionStatus(DailyQuestionViewModel viewModel) { ViewBag.ViewModel = viewModel; if (viewModel.KeyID != null) { viewModel.QuestionID = viewModel.DecryptKeyValue(); } //models.ExecuteCommand("update PDQQuestionExtension set Status={0} where QuestionID={1}", status, questionID); var item = models.GetTable <PDQQuestionExtension>().Where(t => t.QuestionID == viewModel.QuestionID).FirstOrDefault(); if (item != null) { item.Status = viewModel.Status; models.SubmitChanges(); return(Content(new { result = true, item.QuestionID }.JsonStringify(), "application/json")); } return(View("~/Views/Shared/JsAlert.cshtml", model: "問與答資料錯誤!!")); }