public async Task <VerifyRecordResult> DeleteAsync(int id) { try { CleanTrackingHelper.Clean <PhaseCategory>(context); PhaseCategory item = await context.PhaseCategory .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == id); if (item == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.無法刪除紀錄)); } else { CleanTrackingHelper.Clean <PhaseCategory>(context); context.Entry(item).State = EntityState.Deleted; 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> 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 <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 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)); } }
async Task 建立片語分類與文字Async() { List <PhaseMessage> PhaseMessage = new List <PhaseMessage>(); int cc = 10; #region 簽核表單使用的輸入片語 var phaseCategory = new PhaseCategory() { Name = "簽核表單使用的輸入片語", Enable = true, OrderNumber = cc++, PhaseMessage = new List <PhaseMessage>() }; await context.PhaseCategory.AddAsync(phaseCategory); await context.SaveChangesAsync(); PhaseMessage = new List <PhaseMessage>() { new PhaseMessage() { Content = "做得很好,繼續努力", Enable = true, Code = cc.ToString("D5"), OrderNumber = cc++, PhaseCategoryId = phaseCategory.Id, }, new PhaseMessage() { Content = "用來形容情緒不會表露出來的人", Enable = true, Code = cc.ToString("D5"), OrderNumber = cc++, PhaseCategoryId = phaseCategory.Id, }, new PhaseMessage() { Content = "像魚一樣的喝,表示喝很多,尤其指喝很多酒", Enable = true, Code = cc.ToString("D5"), OrderNumber = cc++, PhaseCategoryId = phaseCategory.Id, }, new PhaseMessage() { Content = "意指非常重要、有權力或是具有影響力的人", Enable = true, Code = cc.ToString("D5"), OrderNumber = cc++, PhaseCategoryId = phaseCategory.Id, }, }; await context.BulkInsertAsync(PhaseMessage); #endregion #region 改善報告的輸入片語 phaseCategory = new PhaseCategory() { Name = "改善報告的輸入片語", Enable = true, OrderNumber = cc++, PhaseMessage = new List <PhaseMessage>() }; await context.PhaseCategory.AddAsync(phaseCategory); await context.SaveChangesAsync(); PhaseMessage = new List <PhaseMessage>() { new PhaseMessage() { Content = "加速意見溝通", Enable = true, Code = cc.ToString("D5"), OrderNumber = cc++, PhaseCategoryId = phaseCategory.Id, }, new PhaseMessage() { Content = "○○○○案,簽會意見綜合說明如下,請鑒核", Enable = true, Code = cc.ToString("D5"), OrderNumber = cc++, PhaseCategoryId = phaseCategory.Id, }, new PhaseMessage() { Content = "會簽意見一略以,○○○○○○○○○…", Enable = true, Code = cc.ToString("D5"), OrderNumber = cc++, PhaseCategoryId = phaseCategory.Id, }, new PhaseMessage() { Content = "會簽意見二略以,○○○○○○○○○…", Enable = true, Code = cc.ToString("D5"), OrderNumber = cc++, PhaseCategoryId = phaseCategory.Id, }, new PhaseMessage() { Content = "「是否允當」?", Enable = true, Code = cc.ToString("D5"), OrderNumber = cc++, PhaseCategoryId = phaseCategory.Id, }, new PhaseMessage() { Content = "……因故不克擔任…,予以改派…", Enable = true, Code = cc.ToString("D5"), OrderNumber = cc++, PhaseCategoryId = phaseCategory.Id, }, }; await context.BulkInsertAsync(PhaseMessage); #endregion #region 雜項輸入片語 phaseCategory = new PhaseCategory() { Name = "雜項輸入片語", Enable = true, OrderNumber = cc++, PhaseMessage = new List <PhaseMessage>() }; await context.PhaseCategory.AddAsync(phaseCategory); await context.SaveChangesAsync(); PhaseMessage = new List <PhaseMessage>() { new PhaseMessage() { Content = "可以嗎?", Enable = true, Code = cc.ToString("D5"), OrderNumber = cc++, PhaseCategoryId = phaseCategory.Id, }, new PhaseMessage() { Content = "有關本校進修部學生向 鈞部「部長信箱」反映課程標準一案,本校已查明原委,謹檢陳查核報告乙份(如附件),敬請 鑒核。", Enable = true, Code = cc.ToString("D5"), OrderNumber = cc++, PhaseCategoryId = phaseCategory.Id, }, }; await context.BulkInsertAsync(PhaseMessage); #endregion }