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: "問與答資料錯誤!!"));
}
