/// <summary>
/// (非同步)將前端修改後的資料以交易方式，變更資料庫資料。回傳為字串形式:"查無此筆資料"、"修改成功"、Exception.Message
/// </summary>
/// <param name="singleCarCarPlan"></param>
/// <returns></returns>
public Task <string> EditCarCarPlan(CarCarPlanViewModel.CarCarPlanSingleResult singleCarCarPlan)
{
return(Task.Run(() =>
{
var queryResult = _dbRepository.GetAll <Plan>().FirstOrDefault(P => P.PlanId == singleCarCarPlan.PlanId);
if (queryResult == default)
{
return "查無此筆資料";
}
queryResult.QuantityLimit = (int)singleCarCarPlan.SubmitLimit;
queryResult.SubmitLimit = 0;
using (var transaction = _carcarplanContext.Database.BeginTransaction())
{
try
{
_dbRepository.Update <Plan>(queryResult);
transaction.Commit();
return "修改成功";
}
catch (Exception ex)
{
transaction.Rollback();
return ex.Message;
}
}
}));
}
/// <summary>
/// 從前端修改資料庫會員資料，回傳型式為字串。共有三種型式"查無此筆資料"、"修改成功"及例外的資訊
/// </summary>
/// <param name="backendSingle"></param>
/// <returns></returns>
public async Task <ActionResult <BaseModel.BaseResult <CarCarPlanViewModel.CarCarPlanSingleResult> > > PutCarCarPlan(CarCarPlanViewModel.CarCarPlanSingleResult carCarPlanVM)
{
_logger.LogWarning(2001, DateTime.Now.ToLongTimeString() + " CarCarPlans控制器PutCarCarPlan方法被呼叫 ,傳入的資料為:" + $"Product controller Get called ,Parameter is {nameof(carCarPlanVM.PlanId)} " + carCarPlanVM.PlanId);
var result = new BaseModel.BaseResult <CarCarPlanViewModel.CarCarPlanSingleResult>();
if (!ModelState.IsValid)
{
result.Msg = "查無此筆資料";
result.IsSuccess = false;
return(result);
}
var editResult = await _carCarPlanService.EditCarCarPlan(carCarPlanVM);
result.Msg = editResult;
if (result.Msg == "查無此筆資料")
{
result.IsSuccess = false;
return(result);
}
else if (result.Msg == "修改成功")
{
result.IsSuccess = true;
return(result);
}
else
{
result.IsSuccess = false;
return(result);
}
}
