public async Task <VerifyRecordResult> BeforeUpdateCheckAsync(PolicyDetailAdapterModel paraObject) { CleanTrackingHelper.Clean <PolicyDetail>(context); if (paraObject.MyUserId == 0) { return(VerifyRecordResultFactory.Build(false, "需要指定一個使用者")); } var searchItem = await context.PolicyDetail .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (searchItem == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.要更新的紀錄_發生同時存取衝突_已經不存在資料庫上)); } searchItem = await context.PolicyDetail .AsNoTracking() .FirstOrDefaultAsync(x => x.PolicyHeaderId == paraObject.PolicyHeaderId && x.MyUserId == paraObject.MyUserId && x.Id != paraObject.Id); if (searchItem != null) { return(VerifyRecordResultFactory.Build(false, "同一個簽核政策內,使用者不能重複指定")); } return(VerifyRecordResultFactory.Build(true)); }
public async Task <VerifyRecordResult> UpdateAsync(PolicyDetailAdapterModel paraObject) { try { PolicyDetail itemData = Mapper.Map <PolicyDetail>(paraObject); CleanTrackingHelper.Clean <PolicyDetail>(context); PolicyDetail item = await context.PolicyDetail .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (item == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.無法修改紀錄)); } else { CleanTrackingHelper.Clean <PolicyDetail>(context); context.Entry(itemData).State = EntityState.Modified; await context.SaveChangesAsync(); CleanTrackingHelper.Clean <PolicyDetail>(context); return(VerifyRecordResultFactory.Build(true)); } } catch (Exception ex) { Logger.LogError(ex, "修改記錄發生例外異常"); return(VerifyRecordResultFactory.Build(false, "修改記錄發生例外異常", ex)); } }
public async Task OnCommandClicked(CommandClickEventArgs <PolicyDetailAdapterModel> args) { PolicyDetailAdapterModel item = args.RowData as PolicyDetailAdapterModel; 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 } }
public async Task <VerifyRecordResult> BeforeDeleteCheckAsync(PolicyDetailAdapterModel paraObject) { CleanTrackingHelper.Clean <PolicyDetail>(context); var searchItem = await context.PolicyDetail .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (searchItem == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.無法刪除紀錄_要刪除的紀錄已經不存在資料庫上)); } return(VerifyRecordResultFactory.Build(true)); }
public async Task <PolicyDetailAdapterModel> GetAsync(int id) { PolicyDetail item = await context.PolicyDetail .AsNoTracking() .Include(x => x.PolicyHeader) .Include(x => x.MyUser) .FirstOrDefaultAsync(x => x.Id == id); PolicyDetailAdapterModel result = Mapper.Map <PolicyDetailAdapterModel>(item); await OhterDependencyData(result); return(result); }
public async Task <VerifyRecordResult> BeforeAddCheckAsync(PolicyDetailAdapterModel paraObject) { CleanTrackingHelper.Clean <PolicyDetail>(context); if (paraObject.MyUserId == 0) { return(VerifyRecordResultFactory.Build(false, "需要指定一個使用者")); } var item = await context.PolicyDetail .AsNoTracking() .FirstOrDefaultAsync(x => x.PolicyHeaderId == paraObject.PolicyHeaderId && x.MyUserId == paraObject.MyUserId); if (item != null) { return(VerifyRecordResultFactory.Build(false, "同一個簽核政策內,使用者不能重複指定")); } return(VerifyRecordResultFactory.Build(true)); }
public void ToolbarClickHandler(Syncfusion.Blazor.Navigations.ClickEventArgs args) { if (args.Item.Id == ButtonIdHelper.ButtonIdAdd) { CurrentRecord = new PolicyDetailAdapterModel(); #region 針對新增的紀錄所要做的初始值設定商業邏輯 #endregion EditRecordDialogTitle = "新增紀錄"; isNewRecordMode = true; IsShowEditRecord = true; CurrentRecord.PolicyHeaderId = Header.Id; CurrentRecord.Enable = true; } else if (args.Item.Id == ButtonIdHelper.ButtonIdRefresh) { dataGrid.RefreshGrid(); } }
public async Task <VerifyRecordResult> AddAsync(PolicyDetailAdapterModel paraObject) { try { PolicyDetail itemParameter = Mapper.Map <PolicyDetail>(paraObject); CleanTrackingHelper.Clean <PolicyDetail>(context); await context.PolicyDetail .AddAsync(itemParameter); await context.SaveChangesAsync(); CleanTrackingHelper.Clean <PolicyDetail>(context); return(VerifyRecordResultFactory.Build(true)); } catch (Exception ex) { Logger.LogError(ex, "新增記錄發生例外異常"); return(VerifyRecordResultFactory.Build(false, "新增記錄發生例外異常", ex)); } }
public async Task EnableIt(PolicyDetailAdapterModel paraObject) { PolicyDetail itemData = Mapper.Map <PolicyDetail>(paraObject); CleanTrackingHelper.Clean <PolicyDetail>(context); PolicyDetail item = await context.PolicyDetail .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (item == null) { } else { item.Enable = true; context.Entry(item).State = EntityState.Modified; await context.SaveChangesAsync(); CleanTrackingHelper.Clean <MenuData>(context); } }
Task OhterDependencyData(PolicyDetailAdapterModel data) { data.PolicyHeaderName = data.PolicyHeader.Name; data.MyUserName = data.MyUser.Name; return(Task.FromResult(0)); }
public async Task EnableIt(PolicyDetailAdapterModel item) { await CurrentService.EnableIt(item); dataGrid.RefreshGrid(); }