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;
        }