/// <summary> /// Adds the specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Add(MSTProductDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { MST_Product add = context.MST_Product.Create(); add.Description = entity.Description; add.MainPerson = entity.MainPerson; add.SecondaryPerson = entity.SecondaryPerson; add.TertiaryPerson = entity.TertiaryPerson; add.LabSiteId = entity.LabSiteId; add.IsDeleted = false; add.Name = entity.Name; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<MST_Product>(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. /// </summary> /// <param name="entities">The entities.</param> /// <returns></returns> public SaveResult AddRange(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 = context.SaveChanges() > 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<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 = context.SaveChanges() > 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 assembly = context.LOG_FARUpload.Single(x => x.Id == Id); context.Entry<LOG_FARUpload>(assembly).State = System.Data.Entity.EntityState.Deleted; 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(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 = context.SaveChanges() > 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<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 = context.SaveChanges() > 0 ? SaveResult.SUCESS : 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(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 = 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(MSTProcessTypesDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { MST_ProcessTypes add = context.MST_ProcessTypes.Create(); add.Description = entity.Description; add.IsDeleted = false; add.Name = entity.Name; add.SeqNumber = entity.SeqNumber; add.Duration = entity.Duration; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<MST_ProcessTypes>(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. /// </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 failureType = context.MST_FailureType.Single(x => x.Id == Id && x.IsDeleted == false); failureType.IsDeleted = true; failureType.LastUpdate = DateTime.Now; context.Entry<MST_FailureType>(failureType).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 specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Delete(MSTFarReportDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var report = context.MST_FARReport.Single(x => x.Id == entity.Id && x.IsDeleted == false); report.IsDeleted = true; context.Entry<MST_FARReport>(report).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 specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Add(LOGProcessHistoryDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { LOG_ProcessHistory add = context.LOG_ProcessHistory.Create(); add.ProcessHisId = entity.ProcessHisId; add.InsertedBy = entity.InsertedBy; add.PlanTo = entity.PlanTo; add.PlanFrom = entity.PlanFrom; add.PlanType = (byte)entity.PlanType; add.Description = entity.Description; add.InsertedDate = DateTime.Now; context.Entry<LOG_ProcessHistory>(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(MSTFarReportDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var report = context.MST_FARReport.Single(x => x.Id == entity.Id && x.IsDeleted == false); report.OriginId = entity.OriginId; report.ReportTypeId = entity.ReportTypeId; report.Required = entity.Required; report.Description = entity.Description; report.LastUpdatedBy = entity.LastUpdatedBy; report.LastUpdate = DateTime.Now; context.Entry<MST_FARReport>(report).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. /// </summary> /// <param name="entities">The entities.</param> /// <returns></returns> public SaveResult AddRange(IEnumerable<FARMasterDto> entities) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { FAR_Master add = null; foreach (var entity in entities) { add = context.FAR_Master.Create(); add.Number = entity.Number; add.OriginId = entity.OriginId; add.Requestor = entity.Requestor; add.RefNo = entity.RefNo; add.FailureTypeId = entity.FailureTypeId; add.FailureOriginId = entity.FailureOriginId; add.FailureRate = entity.FailureRate; add.StatusId = entity.StatusId; add.Analyst = entity.Analyst; add.RequestDate = entity.RequestDate; add.SamplesArriveDate = entity.SamplesArriveDate; add.PriorityId = entity.PriorityId; add.InitialReportTargetDate = entity.InitialReportTargetDate; add.BUId = entity.BUId; add.Product = entity.Product; add.FailureDesc = entity.FailureDesc; add.FinalReportTargetDate = entity.FinalReportTargetDate; add.Submitted = entity.Submitted; add.Customer = entity.Customer; add.LabSiteId = entity.LabSiteId; add.RatingId = entity.RatingId; add.Comments = entity.Comments; add.IsDeleted = entity.IsDeleted; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<FAR_Master>(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(FARMasterDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var entry = context.FAR_Master.Single(x => x.Id == entity.Id && x.IsDeleted == false); entry.Number = entity.Number; entry.OriginId = entity.OriginId; entry.Requestor = entity.Requestor; entry.RefNo = entity.RefNo; entry.FailureTypeId = entity.FailureTypeId; entry.FailureOriginId = entity.FailureOriginId; entry.FailureRate = entity.FailureRate; entry.StatusId = entity.StatusId; entry.Analyst = entity.Analyst; entry.RequestDate = entity.RequestDate; entry.SamplesArriveDate = entity.SamplesArriveDate; entry.PriorityId = entity.PriorityId; entry.InitialReportTargetDate = entity.InitialReportTargetDate; entry.BUId = entity.BUId; entry.Product = entity.Product; entry.FailureDesc = entity.FailureDesc; entry.FinalReportTargetDate = entity.FinalReportTargetDate; entry.Submitted = entity.Submitted; entry.Customer = entity.Customer; entry.LabSiteId = entity.LabSiteId; entry.RatingId = entity.RatingId; entry.Comments = entity.Comments; entry.IsDeleted = entity.IsDeleted; entry.LastUpdatedBy = entity.LastUpdatedBy; entry.LastUpdate = DateTime.Now; context.Entry<FAR_Master>(entry).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 specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Add(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 = 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(FARPriorityLogDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var his = context.LOG_FARPriority.Single(x => x.Id == entity.Id && x.IsDeleted == false); his.MasterId = entity.MasterId; his.IsDeleted = entity.IsDeleted; his.PriorityOld = entity.PriorityIdOld; his.PriorityNew = entity.PriorityIdNew; his.ReasonId = entity.ReasonId; his.LastUpdatedBy = entity.LastUpdatedBy; his.LastUpdate = DateTime.Now; context.Entry<LOG_FARPriority>(his).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 specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Update(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 = context.SaveChanges() > 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(FARPriorityLogDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { LOG_FARPriority add = context.LOG_FARPriority.Create(); add.PriorityOld = entity.PriorityIdOld; add.PriorityNew = entity.PriorityIdNew; add.ReasonId = entity.ReasonId; add.IsDeleted = false; add.MasterId = entity.MasterId; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<LOG_FARPriority>(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. /// </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 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 = context.SaveChanges() > 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(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; }
/// <summary> /// Adds the range. /// </summary> /// <param name="entities">The entities.</param> /// <returns></returns> public SaveResult AddRange(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 = 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(FARMechanismDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { FAR_Mechanism 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> /// Updates the specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Update(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 = context.SaveChanges() > 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(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 = 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(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 = 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(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 = 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(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 = 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(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 = context.SaveChanges() > 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 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 = 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(MSTProductDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var product = context.MST_Product.Single(x => x.Id == entity.Id && x.IsDeleted == false); product.Name = entity.Name; product.MainPerson = entity.MainPerson; product.SecondaryPerson = entity.SecondaryPerson; product.TertiaryPerson = entity.TertiaryPerson; product.LabSiteId = entity.LabSiteId; product.IsDeleted = entity.IsDeleted; product.Description = entity.Description; product.LastUpdatedBy = entity.LastUpdatedBy; product.LastUpdate = DateTime.Now; context.Entry<MST_Product>(product).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; }