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