public ActionResult CurrentLessonContentPieData(TrainingExecutionViewModel viewModel)
{
ViewBag.ViewModel = viewModel;
var item = models.GetTable <TrainingExecution>().Where(f => f.ExecutionID == viewModel.ExecutionID).FirstOrDefault();
if (item == null)
{
return(Json(new object[] { }, JsonRequestBehavior.AllowGet));
}
return(Json(item.TrainingExecutionStage
.Select(r => new
{
label = r.TrainingStage.Stage + " " + String.Format("{0:.#}", r.TotalMinutes) + "分鐘",
data = r.TotalMinutes
}).ToArray(), JsonRequestBehavior.AllowGet));
}
public ActionResult EditEmphasis(TrainingExecutionViewModel viewModel)
{
ViewBag.ViewModel = viewModel;
if (viewModel.KeyID != null)
{
viewModel.ExecutionID = viewModel.DecryptKeyValue();
}
var item = models.GetTable <TrainingExecution>().Where(t => t.ExecutionID == viewModel.ExecutionID).FirstOrDefault();
if (item == null)
{
return(View("~/Views/Shared/JsAlert.cshtml", model: "資料錯誤!!"));
}
return(View("~/Views/Training/Module/EditEmphasis.ascx", item));
}
public ActionResult SwitchLessonFavorite(TrainingExecutionViewModel viewModel)
{
ViewBag.ViewModel = viewModel;
if (models.GetTable <FavoriteLesson>().Any(f => f.ExecutionID == viewModel.ExecutionID && f.UID == viewModel.UID))
{
models.ExecuteCommand("delete FavoriteLesson where ExecutionID = {0} and UID = {1}", viewModel.ExecutionID, viewModel.UID);
}
else
{
models.ExecuteCommand(@"
insert FavoriteLesson (ExecutionID,UID)
SELECT TrainingPlan.ExecutionID, UserProfile.UID
FROM TrainingPlan CROSS JOIN
UserProfile
WHERE (TrainingPlan.ExecutionID = {0}) AND (UserProfile.UID = {1})", viewModel.ExecutionID, viewModel.UID);
}
return(Json(new { result = true, message = models.GetTable <FavoriteLesson>().Where(f => f.ExecutionID == viewModel.ExecutionID).Count() }));
}
public ActionResult CommitEmphasis(TrainingExecutionViewModel viewModel)
{
ViewResult result = (ViewResult)EditEmphasis(viewModel);
TrainingExecution model = result.Model as TrainingExecution;
if (model == null)
{
return(result);
}
viewModel.Emphasis = viewModel.Emphasis.GetEfficientString();
if (viewModel.Emphasis == null)
{
return(Json(new { result = false, message = "Unfinished？!" }));
}
else if (viewModel.Emphasis.Length > 20)
{
return(Json(new { result = false, message = "太長了！超過20個中英文字" }));
}
model.Emphasis = viewModel.Emphasis;
models.SubmitChanges();
return(Json(new { result = true }));
}
