/// <summary> /// Adds the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> AddAsync(FARMechanismDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { FAR_Mechanism add = context.FAR_Mechanism.Create(); add.Description = entity.Description; add.Name = entity.Name; add.IsDeleted = false; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<FAR_Mechanism>(add).State = System.Data.Entity.EntityState.Added; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Updates the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> UpdateAsync(MSTServiceDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var service = context.MST_Services.Single(x => x.Id == entity.Id && x.IsDeleted == false); service.Name = entity.Name; service.IsDeleted = entity.IsDeleted; service.Description = entity.Description; service.LastUpdatedBy = entity.LastUpdatedBy; service.LastUpdate = DateTime.Now; context.Entry<MST_Services>(service).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the range asynchronous. /// </summary> /// <param name="entities">The entities.</param> /// <returns></returns> public async Task<SaveResult> AddRangeAsync(IEnumerable<MSTServiceDto> entities) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { MST_Services add = null; foreach (var entity in entities) { add = context.MST_Services.Create(); add.Description = entity.Description; add.IsDeleted = false; add.Name = entity.Name; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<MST_Services>(add).State = System.Data.Entity.EntityState.Added; } result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Updates the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> UpdateAsync(FARInitialTargetLogDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var log = context.LOG_FARInitialTarget.Single(x => x.Id == entity.Id && x.IsDeleted == false); log.MasterId = entity.MasterId; log.ReasonId = entity.ReasonId; log.IsDeleted = entity.IsDeleted; log.TargetDate = entity.TargetDate; log.LastUpdatedBy = entity.LastUpdatedBy; log.LastUpdate = DateTime.Now; context.Entry<LOG_FARInitialTarget>(log).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the range asynchronous. /// </summary> /// <param name="entities">The entities.</param> /// <returns></returns> public async Task<SaveResult> AddRangeAsync(IEnumerable<FARInitialTargetLogDto> entities) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { LOG_FARInitialTarget add = null; foreach (var entity in entities) { add = context.LOG_FARInitialTarget.Create(); add.TargetDate = entity.TargetDate; add.ReasonId = entity.ReasonId; add.IsDeleted = false; add.MasterId = entity.MasterId; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<LOG_FARInitialTarget>(add).State = System.Data.Entity.EntityState.Added; } result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Updates the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> UpdateAsync(DelayReasonDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var assembly = context.MST_ReasonINIReport.Single(x => x.Id == entity.Id && x.IsDeleted == false); assembly.Description = entity.Description; assembly.LastUpdatedBy = entity.LastUpdatedBy; assembly.LastUpdate = DateTime.Now; context.Entry<MST_ReasonINIReport>(assembly).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the range. /// </summary> /// <param name="entities">The entities.</param> /// <returns></returns> public SaveResult AddRange(IEnumerable<DelayReasonDto> entities) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { foreach (var entity in entities) { MST_ReasonINIReport add = context.MST_ReasonINIReport.Create(); add.Description = entity.Description; add.IsDeleted = entity.IsDeleted; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<MST_ReasonINIReport>(add).State = System.Data.Entity.EntityState.Added; } result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Updates the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> UpdateAsync(FARAnalystReassignLogDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var assembly = context.LOG_FARAnalystReassign.Single(x => x.Id == entity.Id && x.IsDeleted == false); assembly.MasterId = entity.MasterId; assembly.IsDeleted = entity.IsDeleted; assembly.AnalystFrom = entity.AnalystFrom; assembly.AnalystTo = entity.AnalystTo; assembly.LastUpdatedBy = entity.LastUpdatedBy; assembly.UpdatedDate = DateTime.Now; context.Entry<LOG_FARAnalystReassign>(assembly).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> AddAsync(FARAnalystReassignLogDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { LOG_FARAnalystReassign add = context.LOG_FARAnalystReassign.Create(); add.MasterId = entity.MasterId; add.AnalystFrom = entity.AnalystFrom; add.AnalystTo = entity.AnalystTo; add.IsDeleted = entity.IsDeleted; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<LOG_FARAnalystReassign>(add).State = System.Data.Entity.EntityState.Added; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> AddAsync(MSTProcessProductDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { MST_ProcessProduct add = context.MST_ProcessProduct.Create(); //Check productId and ProcessTypeId exits record? var checkExits = context.MST_ProcessProduct.Where(x => x.ProcessTypeId == entity.ProcessTypeId && x.ProductId == entity.ProductId).FirstOrDefault(); if (checkExits != null) { checkExits.InChargePerson = entity.InChargePerson; checkExits.IsDeleted = false; checkExits.LastUpdatedBy = entity.LastUpdatedBy; checkExits.LastUpdate = DateTime.Now; context.Entry<MST_ProcessProduct>(checkExits).State = System.Data.Entity.EntityState.Modified; } else { add.Description = entity.Description; add.ProductId = entity.ProductId; add.ProcessTypeId = entity.ProcessTypeId; add.InChargePerson = entity.InChargePerson; add.IsDeleted = false; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<MST_ProcessProduct>(add).State = System.Data.Entity.EntityState.Added; } result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the range. /// </summary> /// <param name="entities">The entities.</param> /// <returns></returns> public SaveResult AddRange(IEnumerable<MSTProcessProductDto> entities) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { MST_ProcessProduct add = null; foreach (var entity in entities) { add = context.MST_ProcessProduct.Create(); add.Description = entity.Description; add.ProductId = entity.ProductId; add.ProcessTypeId = entity.ProcessTypeId; add.InChargePerson = entity.InChargePerson; add.IsDeleted = false; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<MST_ProcessProduct>(add).State = System.Data.Entity.EntityState.Added; } result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Updates the specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Update(MSTProcessProductDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var update = context.MST_ProcessProduct.Single(x => x.Id == entity.Id && x.IsDeleted == false); update.InChargePerson = entity.InChargePerson; update.IsDeleted = entity.IsDeleted; update.Description = entity.Description; update.LastUpdatedBy = entity.LastUpdatedBy; update.LastUpdate = DateTime.Now; context.Entry<MST_ProcessProduct>(update).State = System.Data.Entity.EntityState.Modified; result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Deletes the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> DeleteAsync(FARMechanismDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var fabSite = context.FAR_Mechanism.Single(x => x.Id == entity.Id && x.IsDeleted == false); fabSite.IsDeleted = true; fabSite.LastUpdate = DateTime.Now; fabSite.LastUpdatedBy = entity.LastUpdatedBy; context.Entry<FAR_Mechanism>(fabSite).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the range. /// </summary> /// <param name="entities">The entities.</param> /// <returns></returns> public SaveResult AddRange(IEnumerable<FARMechanismDto> entities) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { FAR_Mechanism add = null; foreach (var entity in entities) { add = context.FAR_Mechanism.Create(); add.Description = entity.Description; add.IsDeleted = false; add.Name = entity.Name; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<FAR_Mechanism>(add).State = System.Data.Entity.EntityState.Added; } result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the range asynchronous. /// </summary> /// <param name="entities">The entities.</param> /// <returns></returns> public async Task<SaveResult> AddRangeAsync(IEnumerable<FARUploadDto> entities) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { LOG_FARUpload add = null; foreach (var entity in entities) { add = context.LOG_FARUpload.Create(); add.FileName = entity.FileName; add.MasterId = entity.MasterId; add.ReasonId = entity.ReasonId; add.FAType = entity.FAType; add.UploadedBy = entity.UploadedBy; add.UploadedDate = DateTime.Now; context.Entry<LOG_FARUpload>(add).State = System.Data.Entity.EntityState.Added; } result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the range. /// </summary> /// <param name="entities">The entities.</param> /// <returns></returns> public SaveResult AddRange(IEnumerable<FARAnalystReassignLogDto> entities) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { LOG_FARAnalystReassign add = null; foreach (var entity in entities) { add = context.LOG_FARAnalystReassign.Create(); add.MasterId = entity.MasterId; add.AnalystFrom = entity.AnalystFrom; add.AnalystTo = entity.AnalystTo; add.IsDeleted = entity.IsDeleted; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<LOG_FARAnalystReassign>(add).State = System.Data.Entity.EntityState.Added; } result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Deletes the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> DeleteAsync(FARUploadDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var assembly = context.LOG_FARUpload.Single(x => x.Id == entity.Id); context.Entry<LOG_FARUpload>(assembly).State = System.Data.Entity.EntityState.Deleted; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Deletes the by. /// </summary> /// <param name="Id">The identifier.</param> /// <returns></returns> public SaveResult DeleteBy(int Id) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var reassign = context.LOG_FARAnalystReassign.Single(x => x.Id == Id && x.IsDeleted == false); reassign.IsDeleted = true; reassign.LastUpdate = DateTime.Now; context.Entry<LOG_FARAnalystReassign>(reassign).State = System.Data.Entity.EntityState.Modified; result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> AddAsync(DelayReasonDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { MST_ReasonINIReport add = context.MST_ReasonINIReport.Create(); add.Description = entity.Description; add.IsDeleted = entity.IsDeleted; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<MST_ReasonINIReport>(add).State = System.Data.Entity.EntityState.Added; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Updates the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> UpdateAsync(RecordLockDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var update = context.FAR_RecordLock.Single(x => x.Id == entity.Id && x.IsDeleted == false); update.ProcessHistoryId = entity.ProcessHistoryId; update.LockBy = entity.LockBy; update.LockDate = entity.LockDate; update.MasterId = entity.MasterId; update.ReleaseDate = entity.ReleaseDate; update.LastUpdatedBy = entity.LastUpdatedBy; update.LastUpdate = DateTime.Now; context.Entry<FAR_RecordLock>(update).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; }
/// <summary> /// Deletes the specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Delete(DelayReasonDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var assembly = context.MST_ReasonINIReport.Single(x => x.Id == entity.Id && x.IsDeleted == false); assembly.IsDeleted = true; context.Entry<MST_ReasonINIReport>(assembly).State = System.Data.Entity.EntityState.Modified; result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the range asynchronous. /// </summary> /// <param name="entities">The entities.</param> /// <returns></returns> public async Task<SaveResult> AddRangeAsync(IEnumerable<RecordLockDto> entities) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { foreach (var entity in entities) { FAR_RecordLock add = context.FAR_RecordLock.Create(); add.ProcessHistoryId = entity.ProcessHistoryId; add.LockBy = entity.LockBy; add.LockDate = entity.LockDate; add.MasterId = entity.MasterId; add.ReleaseDate = entity.ReleaseDate; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<FAR_RecordLock>(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; }
/// <summary> /// Adds the specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Add(FARInitialTargetLogDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { LOG_FARInitialTarget add = context.LOG_FARInitialTarget.Create(); add.TargetDate = entity.TargetDate; add.ReasonId = entity.ReasonId; add.IsDeleted = false; add.MasterId = entity.MasterId; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<LOG_FARInitialTarget>(add).State = System.Data.Entity.EntityState.Added; result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Deletes the by asynchronous. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public async Task<SaveResult> DeleteByAsync(int id) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var record = context.FAR_RecordLock.Single(x => x.Id == id && x.IsDeleted == false); record.IsDeleted = true; record.LastUpdate = DateTime.Now; context.Entry<FAR_RecordLock>(record).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; }
/// <summary> /// Deletes the by. /// </summary> /// <param name="Id">The identifier.</param> /// <returns></returns> public SaveResult DeleteBy(int Id) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var assembly = context.LOG_FARInitialTarget.Single(x => x.Id == Id && x.IsDeleted == false); assembly.IsDeleted = true; context.Entry<LOG_FARInitialTarget>(assembly).State = System.Data.Entity.EntityState.Modified; result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Updates the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> UpdateAsync(FARUploadDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var upload = context.LOG_FARUpload.Single(x => x.Id == entity.Id); upload.FileName = entity.FileName; upload.MasterId = entity.MasterId; upload.ReasonId = entity.ReasonId; upload.FAType = entity.FAType; upload.UploadedBy = entity.UploadedBy; upload.UploadedDate = DateTime.Now; context.Entry<LOG_FARUpload>(upload).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Add(MSTServiceDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { MST_Services add = context.MST_Services.Create(); add.Description = entity.Description; add.IsDeleted = false; add.Name = entity.Name; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<MST_Services>(add).State = System.Data.Entity.EntityState.Added; result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Add(FARUploadDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { LOG_FARUpload add = context.LOG_FARUpload.Create(); add.FileName = entity.FileName; add.MasterId = entity.MasterId; add.ReasonId = entity.ReasonId; add.FAType = entity.FAType; add.UploadedBy = entity.UploadedBy; add.UploadedDate = DateTime.Now; context.Entry<LOG_FARUpload>(add).State = System.Data.Entity.EntityState.Added; result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Deletes the by asynchronous. /// </summary> /// <param name="Id">The identifier.</param> /// <returns></returns> public async Task<SaveResult> DeleteByAsync(int Id) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var assembly = context.MST_Services.Single(x => x.Id == Id && x.IsDeleted == false); assembly.IsDeleted = true; context.Entry<MST_Services>(assembly).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Deletes the specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Delete(MSTPriorityDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var priority = context.MST_Priority.Single(x => x.Id == entity.Id && x.IsDeleted == false); priority.IsDeleted = true; priority.LastUpdate = DateTime.Now; priority.LastUpdatedBy = entity.LastUpdatedBy; context.Entry<MST_Priority>(priority).State = System.Data.Entity.EntityState.Modified; result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }