public async Task <VerifyRecordResult> UpdateAsync(PhaseCategoryAdapterModel paraObject) { try { PhaseCategory itemData = Mapper.Map <PhaseCategory>(paraObject); CleanTrackingHelper.Clean <PhaseCategory>(context); PhaseCategory item = await context.PhaseCategory .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (item == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.無法修改紀錄)); } else { CleanTrackingHelper.Clean <PhaseCategory>(context); context.Entry(itemData).State = EntityState.Modified; await context.SaveChangesAsync(); CleanTrackingHelper.Clean <PhaseCategory>(context); return(VerifyRecordResultFactory.Build(true)); } } catch (Exception ex) { Logger.LogError(ex, "修改記錄發生例外異常"); return(VerifyRecordResultFactory.Build(false, "修改記錄發生例外異常", ex)); } }
public async Task <VerifyRecordResult> BeforeAddCheckAsync(PhaseCategoryAdapterModel paraObject) { var searchItem = await context.PhaseCategory .AsNoTracking() .FirstOrDefaultAsync(x => x.Name == paraObject.Name); if (searchItem != null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.要新增的紀錄已經存在無法新增)); } return(VerifyRecordResultFactory.Build(true)); }
public async Task <PhaseCategoryAdapterModel> GetAsync(int id) { PhaseCategory item = await context.PhaseCategory .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == id); PhaseCategoryAdapterModel result = Mapper.Map <PhaseCategoryAdapterModel>(item); await OhterDependencyData(result); return(result); }
public async Task EnableIt(PhaseCategoryAdapterModel paraObject) { await Task.Delay(100); PhaseCategory curritem = await context.PhaseCategory .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); CleanTrackingHelper.Clean <PhaseCategory>(context); curritem.Enable = true; context.Entry(curritem).State = EntityState.Modified; await context.SaveChangesAsync(); CleanTrackingHelper.Clean <PhaseCategory>(context); return; }
public void ToolbarClickHandler(Syncfusion.Blazor.Navigations.ClickEventArgs args) { if (args.Item.Id == ButtonIdHelper.ButtonIdAdd) { CurrentRecord = new PhaseCategoryAdapterModel(); #region 針對新增的紀錄所要做的初始值設定商業邏輯 #endregion EditRecordDialogTitle = "新增紀錄"; isNewRecordMode = true; IsShowEditRecord = true; CurrentRecord.Enable = true; } else if (args.Item.Id == ButtonIdHelper.ButtonIdRefresh) { dataGrid.RefreshGrid(); } }
public async Task <VerifyRecordResult> AddAsync(PhaseCategoryAdapterModel paraObject) { try { PhaseCategory itemParameter = Mapper.Map <PhaseCategory>(paraObject); CleanTrackingHelper.Clean <PhaseCategory>(context); await context.PhaseCategory .AddAsync(itemParameter); await context.SaveChangesAsync(); CleanTrackingHelper.Clean <PhaseCategory>(context); return(VerifyRecordResultFactory.Build(true)); } catch (Exception ex) { Logger.LogError(ex, "新增記錄發生例外異常"); return(VerifyRecordResultFactory.Build(false, "新增記錄發生例外異常", ex)); } }
public async Task <VerifyRecordResult> BeforeDeleteCheckAsync(PhaseCategoryAdapterModel paraObject) { CleanTrackingHelper.Clean <OrderItem>(context); var searchItem = await context.PhaseCategory .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (searchItem == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.無法刪除紀錄_要刪除的紀錄已經不存在資料庫上)); } var searchOrderItemItem = await context.PhaseMessage .AsNoTracking() .FirstOrDefaultAsync(x => x.PhaseCategoryId == paraObject.Id); if (searchOrderItemItem != null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.該紀錄無法刪除因為有其他資料表在使用中)); } return(VerifyRecordResultFactory.Build(true)); }
public async Task <VerifyRecordResult> BeforeUpdateCheckAsync(PhaseCategoryAdapterModel paraObject) { var searchItem = await context.PhaseCategory .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (searchItem == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.要更新的紀錄_發生同時存取衝突_已經不存在資料庫上)); } searchItem = await context.PhaseCategory .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(PhaseCategoryAdapterModel data) { return(Task.FromResult(0)); }
public async Task EnableIt(PhaseCategoryAdapterModel item) { await CurrentService.EnableIt(item); dataGrid.RefreshGrid(); }
public async Task OnCommandClicked(CommandClickEventArgs <PhaseCategoryAdapterModel> args) { PhaseCategoryAdapterModel item = args.RowData as PhaseCategoryAdapterModel; 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), MessageBox.HiddenAsync); await Task.Yield(); thisView.NeedRefresh(); return; } #endregion #region 刪除這筆紀錄 await Task.Yield(); var checkTask = ConfirmMessageBox.ShowAsync("400px", "200px", "警告", "確認要刪除這筆紀錄嗎?", ConfirmMessageBox.HiddenAsync); thisView.NeedRefresh(); var checkAgain = await checkTask; if (checkAgain == true) { var verifyRecordResult = await CurrentService.DeleteAsync(CurrentNeedDeleteRecord.Id); await TranscationResultHelper.CheckDatabaseResult(MessageBox, verifyRecordResult); dataGrid.RefreshGrid(); } #endregion #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 } }