public ActionResult EditCoachRevenueIndicator(MonthlyCoachRevenueIndicatorQueryViewModel viewModel)
{
ViewBag.ViewModel = viewModel;
if (viewModel.KeyID != null)
{
viewModel.PeriodID = viewModel.DecryptKeyValue();
}
var indicator = models.GetTable <MonthlyIndicator>().Where(c => c.PeriodID == viewModel.PeriodID).FirstOrDefault();
if (indicator == null)
{
return(View("~/Views/ConsoleHome/Shared/JsAlert.cshtml", model: "資料錯誤!!"));
}
var item = models.GetTable <MonthlyCoachRevenueIndicator>()
.Where(c => c.PeriodID == viewModel.PeriodID && c.CoachID == viewModel.CoachID).FirstOrDefault();
if (item != null)
{
viewModel.AchievementGoal = item.AchievementGoal;
viewModel.CompleteLessonsGoal = item.CompleteLessonsGoal;
viewModel.BRCount = item.BRCount;
viewModel.AverageLessonPrice = item.AverageLessonPrice;
}
else
{
viewModel.AverageLessonPrice = indicator.CalculateAverageLessonPrice(models, viewModel.CoachID);
}
return(View("~/Views/BusinessConsole/Module/SelectCoachAchievementGoal.cshtml", indicator));
}
public ActionResult ProcessCoachRevenueIndicator(MonthlyCoachRevenueIndicatorQueryViewModel viewModel)
{
ViewBag.ViewModel = viewModel;
if (viewModel.KeyID != null)
{
viewModel.PeriodID = viewModel.DecryptKeyValue();
}
var item = models.GetTable <MonthlyCoachRevenueIndicator>().Where(c => c.PeriodID == viewModel.PeriodID && c.CoachID == viewModel.CoachID).FirstOrDefault();
if (item == null)
{
return(View("~/Views/ConsoleHome/Shared/JsAlert.cshtml", model: "資料錯誤!!"));
}
return(View("~/Views/BusinessConsole/Module/ProcessCoachRevenueIndicator.cshtml", item));
}
public ActionResult DeleteCoachRevenueIndicator(MonthlyCoachRevenueIndicatorQueryViewModel viewModel)
{
ViewBag.ViewModel = viewModel;
if (viewModel.KeyID != null)
{
viewModel.PeriodID = viewModel.DecryptKeyValue();
}
var count = models.ExecuteCommand("delete [KPI].MonthlyCoachRevenueIndicator where PeriodID={0} and CoachID={1}", viewModel.PeriodID, viewModel.CoachID);
if (count > 0)
{
return(Json(new { result = true }, JsonRequestBehavior.AllowGet));
}
return(Json(new { result = false, message = "刪除失敗!!" }, JsonRequestBehavior.AllowGet));
}
public ActionResult ApplyCoachAchievement(MonthlyCoachRevenueIndicatorQueryViewModel viewModel)
{
ViewBag.ViewModel = viewModel;
if (viewModel.KeyID != null)
{
viewModel.PeriodID = viewModel.DecryptKeyValue();
}
if (!viewModel.Year.HasValue || !viewModel.Month.HasValue)
{
viewModel.Year = DateTime.Today.Year;
viewModel.Month = DateTime.Today.Month;
}
var item = viewModel.AssertMonthlyIndicator(models);
return(View("~/Views/BusinessConsole/Module/SelectCoachAchievementGoal.cshtml", item));
}
// GET: AchievementConsole
public ActionResult InquireMonthlyCoachRevenue(MonthlyCoachRevenueIndicatorQueryViewModel viewModel)
{
ViewBag.ViewModel = viewModel;
int?coachID = viewModel.CoachID;
if (viewModel.KeyID != null)
{
coachID = viewModel.DecryptKeyValue();
}
IQueryable <MonthlyIndicator> indicatorItems = viewModel.InquireMonthlyIndicator(models);
IQueryable <MonthlyCoachRevenueIndicator> items = models.GetTable <MonthlyCoachRevenueIndicator>()
.Where(c => c.CoachID == viewModel.CoachID)
.Join(indicatorItems, c => c.PeriodID, m => m.PeriodID, (c, m) => c);
return(View("~/Views/AchievementConsole/Module/InquireMonthlyCoachRevenue.cshtml", items));
}
public ActionResult MakeStrategyAnalysis(MonthlyCoachRevenueIndicatorQueryViewModel viewModel)
{
ViewBag.ViewModel = viewModel;
if (viewModel.KeyID != null)
{
viewModel.PeriodID = viewModel.DecryptKeyValue();
}
var item = models.GetTable <MonthlyBranchIndicator>().Where(c => c.PeriodID == viewModel.PeriodID && c.BranchID == viewModel.BranchID).FirstOrDefault();
if (item == null)
{
return(View("~/Views/ConsoleHome/Shared/JsAlert.cshtml", model: "資料錯誤!!"));
}
viewModel.RiskPrediction = item.RiskPrediction;
viewModel.Strategy = item.Strategy;
viewModel.Comment = item.Comment;
return(View("~/Views/BusinessConsole/Module/MakeStrategyAnalysis.cshtml", item));
}
public ActionResult CommitStrategyAnalysis(MonthlyCoachRevenueIndicatorQueryViewModel viewModel)
{
ViewBag.ViewModel = viewModel;
if (viewModel.KeyID != null)
{
viewModel.PeriodID = viewModel.DecryptKeyValue();
}
var item = models.GetTable <MonthlyBranchIndicator>().Where(c => c.PeriodID == viewModel.PeriodID && c.BranchID == viewModel.BranchID).FirstOrDefault();
if (item == null)
{
return(View("~/Views/ConsoleHome/Shared/JsAlert.cshtml", model: "資料錯誤!!"));
}
item.RiskPrediction = viewModel.RiskPrediction;
item.Strategy = viewModel.Strategy;
//item.Comment = viewModel.Comment;
models.SubmitChanges();
return(Json(new { result = true }, JsonRequestBehavior.AllowGet));
}