public async Task <VerifyRecordResult> UpdateAsync(OrderMasterAdapterModel paraObject) { try { OrderMaster itemData = Mapper.Map <OrderMaster>(paraObject); CleanTrackingHelper.Clean <OrderMaster>(context); OrderMaster item = await context.OrderMaster .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (item == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.無法修改紀錄)); } else { CleanTrackingHelper.Clean <OrderMaster>(context); context.Entry(itemData).State = EntityState.Modified; await context.SaveChangesAsync(); CleanTrackingHelper.Clean <OrderMaster>(context); return(VerifyRecordResultFactory.Build(true)); } } catch (Exception ex) { Logger.LogError(ex, "修改記錄發生例外異常"); return(VerifyRecordResultFactory.Build(false, "修改記錄發生例外異常", ex)); } }
public async Task <VerifyRecordResult> BeforeDeleteCheckAsync(OrderMasterAdapterModel paraObject) { try { CleanTrackingHelper.Clean <OrderItem>(context); CleanTrackingHelper.Clean <OrderMaster>(context); var searchItem = await context.OrderMaster .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (searchItem == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.無法刪除紀錄_要刪除的紀錄已經不存在資料庫上)); } var searchOrderItemItem = await context.OrderItem .AsNoTracking() .FirstOrDefaultAsync(x => x.OrderMasterId == paraObject.Id); if (searchOrderItemItem != null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.該紀錄無法刪除因為有其他資料表在使用中)); } return(VerifyRecordResultFactory.Build(true)); } catch (Exception ex) { return(VerifyRecordResultFactory.Build(false, "刪除記錄發生例外異常", ex)); } }
public async Task OnCommandClicked(CommandClickEventArgs <OrderMasterAdapterModel> args) { OrderMasterAdapterModel item = args.RowData as OrderMasterAdapterModel; if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdEdit) { #region 點選 修改紀錄 按鈕 CurrentRecord = item.Clone(); EditRecordDialogTitle = "修改紀錄"; IsShowEditRecord = true; isNewRecordMode = false; #endregion } else if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdDelete) { #region 點選 刪除紀錄 按鈕 CurrentNeedDeleteRecord = item; #region 檢查關聯資料是否存在 var checkedResult = await CurrentService .BeforeDeleteCheckAsync(CurrentNeedDeleteRecord); await Task.Delay(100); if (checkedResult.Success == false) { MessageBox.Show("400px", "200px", "警告", ErrorMessageMappingHelper.Instance.GetErrorMessage(checkedResult.MessageId)); await Task.Yield(); thisView.NeedRefresh(); return; } #endregion ConfirmMessageBox.Show("400px", "200px", "警告", "確認要刪除這筆紀錄嗎?"); #endregion } else if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdShowDetailOfMaster) { #region 點選 開啟多筆 CRUD 對話窗 按鈕 IsShowMoreDetailsRecord = true; ShowMoreDetailsRecordDialogTitle = MagicHelper.訂單明細管理功能名稱; MasterRecord masterRecord = new MasterRecord() { Id = item.Id }; Header = masterRecord; if (ShowMoreDetailsGrid != null) { await Task.Delay(100); // 使用延遲,讓 Header 的資料綁定可以成功 ShowMoreDetailsGrid.RefreshGrid(); } #endregion } }
public async Task <IActionResult> Put([FromRoute] int id, [FromBody] OrderDto data) { APIResult apiResult; #region 驗證 DTO 物件的資料一致性 if (!ModelState.IsValid) { apiResult = APIResultFactory.Build(false, StatusCodes.Status200OK, ErrorMessageEnum.傳送過來的資料有問題, payload: data); return(Ok(apiResult)); } #endregion var record = await OrderService.GetAsync(id); if (record != null && record.Id != 0) { OrderMasterAdapterModel recordTarget = mapper.Map <OrderMasterAdapterModel>(data); recordTarget.Id = id; var result = mapper.Map <OrderDto>(recordTarget); #region 修改記錄前的紀錄完整性檢查 VerifyRecordResult verify = await OrderService.BeforeUpdateCheckAsync(record); if (verify.Success == false) { apiResult = APIResultFactory.Build(false, StatusCodes.Status200OK, ErrorMessageMappingHelper.Instance.GetErrorMessage(verify.MessageId), payload: result); return(Ok(apiResult)); } #endregion var verifyRecordResult = await OrderService.UpdateAsync(recordTarget); if (verifyRecordResult.Success) { apiResult = APIResultFactory.Build(true, StatusCodes.Status202Accepted, ErrorMessageEnum.None, payload: null); } else { apiResult = APIResultFactory.Build(false, StatusCodes.Status200OK, verifyRecordResult.MessageId, payload: result); } } else { apiResult = APIResultFactory.Build(false, StatusCodes.Status200OK, ErrorMessageEnum.沒有任何符合資料存在, payload: data); } return(Ok(apiResult)); }
public async Task <VerifyRecordResult> BeforeAddCheckAsync(OrderMasterAdapterModel paraObject) { var searchItem = await context.OrderMaster .AsNoTracking() .FirstOrDefaultAsync(x => x.Name == paraObject.Name); if (searchItem != null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.要新增的紀錄已經存在無法新增)); } return(VerifyRecordResultFactory.Build(true)); }
public async Task <OrderMasterAdapterModel> GetAsync(int id) { OrderMaster item = await context.OrderMaster .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == id); OrderMasterAdapterModel result = Mapper.Map <OrderMasterAdapterModel>(item); await OhterDependencyData(result); return(result); }
public async Task <VerifyRecordResult> BeforeDeleteCheckAsync(OrderMasterAdapterModel paraObject) { CleanTrackingHelper.Clean <OrderItem>(context); OrderItem item = await context.OrderItem .AsNoTracking() .FirstOrDefaultAsync(x => x.OrderId == paraObject.Id); if (item != null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.該紀錄無法刪除因為有其他資料表在使用中)); } return(VerifyRecordResultFactory.Build(true)); }
public async Task <IActionResult> Post([FromBody] OrderDto data) { APIResult apiResult; #region 驗證 DTO 物件的資料一致性 if (!ModelState.IsValid) { apiResult = APIResultFactory.Build(false, StatusCodes.Status200OK, ErrorMessageEnum.傳送過來的資料有問題, payload: data); return(Ok(apiResult)); } #endregion OrderMasterAdapterModel record = mapper.Map <OrderMasterAdapterModel>(data); if (record != null) { var result = mapper.Map <OrderDto>(record); #region 新增記錄前的紀錄完整性檢查 VerifyRecordResult verify = await OrderService.BeforeAddCheckAsync(record); if (verify.Success == false) { apiResult = APIResultFactory.Build(false, StatusCodes.Status200OK, ErrorMessageMappingHelper.Instance.GetErrorMessage(verify.MessageId), payload: result); return(Ok(apiResult)); } #endregion var verifyRecordResult = await OrderService.AddAsync(record); if (verifyRecordResult.Success) { apiResult = APIResultFactory.Build(true, StatusCodes.Status201Created, ErrorMessageEnum.None, payload: null); } else { apiResult = APIResultFactory.Build(false, StatusCodes.Status200OK, verifyRecordResult.MessageId, payload: record); } } else { apiResult = APIResultFactory.Build(false, StatusCodes.Status200OK, ErrorMessageEnum.傳送過來的資料有問題, payload: data); } return(Ok(apiResult)); }
public async Task <VerifyRecordResult> AddAsync(OrderMasterAdapterModel paraObject) { CleanTrackingHelper.Clean <OrderMaster>(context); OrderMaster itemParameter = Mapper.Map <OrderMaster>(paraObject); CleanTrackingHelper.Clean <OrderMaster>(context); await context.OrderMaster .AddAsync(itemParameter); await context.SaveChangesAsync(); CleanTrackingHelper.Clean <OrderMaster>(context); return(VerifyRecordResultFactory.Build(true)); }
public void ToolbarClickHandler(Syncfusion.Blazor.Navigations.ClickEventArgs args) { if (args.Item.Id == ButtonIdHelper.ButtonIdAdd) { CurrentRecord = new OrderMasterAdapterModel(); #region 針對新增的紀錄所要做的初始值設定商業邏輯 #endregion EditRecordDialogTitle = "新增紀錄"; isNewRecordMode = true; IsShowEditRecord = true; } else if (args.Item.Id == ButtonIdHelper.ButtonIdRefresh) { dataGrid.RefreshGrid(); } }
public async Task <VerifyRecordResult> AddAsync(OrderMasterAdapterModel paraObject) { try { CleanTrackingHelper.Clean <OrderMaster>(context); OrderMaster itemParameter = Mapper.Map <OrderMaster>(paraObject); CleanTrackingHelper.Clean <OrderMaster>(context); await context.OrderMaster .AddAsync(itemParameter); await context.SaveChangesAsync(); CleanTrackingHelper.Clean <OrderMaster>(context); return(VerifyRecordResultFactory.Build(true)); } catch (Exception ex) { Logger.LogError(ex, "新增記錄發生例外異常"); return(VerifyRecordResultFactory.Build(false, "新增記錄發生例外異常", ex)); } }
public async Task <VerifyRecordResult> BeforeUpdateCheckAsync(OrderMasterAdapterModel paraObject) { CleanTrackingHelper.Clean <OrderMaster>(context); var searchItem = await context.OrderMaster .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (searchItem == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.要更新的紀錄_發生同時存取衝突_已經不存在資料庫上)); } searchItem = await context.OrderMaster .AsNoTracking() .FirstOrDefaultAsync(x => x.Name == paraObject.Name && x.Id != paraObject.Id); if (searchItem != null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.要修改的紀錄已經存在無法修改)); } return(VerifyRecordResultFactory.Build(true)); }
Task OhterDependencyData(OrderMasterAdapterModel data) { return(Task.FromResult(0)); }