public async Task<SaveResult> AddAsync(FARCancelLogDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { LOG_FARCancel add = context.LOG_FARCancel.Create(); add.StatusId = entity.StatusId; add.MasterId = entity.MasterId; add.ReasonId = entity.ReasonId; add.CancelledDate = entity.CancelledDate; add.IsDeleted = entity.IsDeleted; add.InsertedBy = entity.InsertedBy; add.InsertedOn = DateTime.Now; context.Entry<LOG_FARCancel>(add).State = System.Data.Entity.EntityState.Added; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
public async Task<SaveResult> DeleteAsync(FARCancelLogDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var assembly = context.LOG_FARCancel.Single(x => x.Id == entity.Id && x.IsDeleted == false); assembly.IsDeleted = true; context.Entry<LOG_FARCancel>(assembly).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
public SaveResult Update(FARCancelLogDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var assembly = context.LOG_FARCancel.Single(x => x.Id == entity.Id && x.IsDeleted == false); assembly.StatusId = entity.StatusId; assembly.MasterId = entity.MasterId; assembly.IsDeleted = entity.IsDeleted; assembly.ReasonId = entity.ReasonId; assembly.CancelledDate = entity.CancelledDate; assembly.UpdatedBy = entity.UpdatedBy; assembly.UpdatedOn = DateTime.Now; context.Entry<LOG_FARCancel>(assembly).State = System.Data.Entity.EntityState.Modified; result = context.SaveChanges() > 0 ? SaveResult.SUCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }