/// <summary> /// Finds the asynchronous. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public async Task<FARUploadDto> SingleAsync(int id) { FARUploadDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = await (from item in context.LOG_FARUpload where item.Id == id select new FARUploadDto() { Id = item.Id, MasterId = item.MasterId, FAType = item.FAType, FileName = item.FileName, ReasonId = item.ReasonId, UploadedDate = item.UploadedDate, UploadedBy = item.UploadedBy }).SingleAsync(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the asynchronous. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public async Task<MSTServiceDto> SingleAsync(int id) { MSTServiceDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = await (from item in context.MST_Services where item.IsDeleted == false && item.Id == id select new MSTServiceDto() { Id = item.Id, Name = item.Name, Description = item.Description, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).SingleAsync(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the specified identifier. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public FARAnalystReassignLogDto Single(int id) { FARAnalystReassignLogDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = (from item in context.LOG_FARAnalystReassign where item.IsDeleted == false && item.Id == id select new FARAnalystReassignLogDto() { Id = item.Id, MasterId = item.MasterId, AnalystFrom = item.AnalystFrom, AnalystTo = item.AnalystTo, UpdatedDate = item.UpdatedDate, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).Single(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the specified identifier. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public FARMechanismDto Single(int id) { FARMechanismDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = (from item in context.FAR_Mechanism where item.IsDeleted == false && item.Id == id select new FARMechanismDto() { Id = item.Id, Name = item.Name, Description = item.Description, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).Single(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the specified identifier. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public SitesDto Single(int id) { SitesDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = (from item in context.MST_Sites where item.IsDeleted == false && item.Id == id select new SitesDto() { Id = item.Id, Name = item.Name, Address1 = item.Address1, Address2 = item.Address2, Phone = item.Phone, Description = item.Description, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).Single(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); } return result; }
/// <summary> /// Finds the specified identifier. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public MSTProcessTypesDto Single(int id) { MSTProcessTypesDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = (from item in context.MST_ProcessTypes where item.IsDeleted == false && item.Id == id select new MSTProcessTypesDto() { Id = item.Id, Name = item.Name, Description = item.Description, Duration = item.Duration, SeqNumber = item.SeqNumber, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).Single(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the asynchronous. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public async Task<FARPriorityLogDto> SingleAsync(int id) { FARPriorityLogDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = await (from item in context.LOG_FARPriority where item.IsDeleted == false && item.Id == id select new FARPriorityLogDto() { Id = item.Id, MasterId = item.MasterId, PriorityIdNew = item.PriorityNew, PriorityIdOld = item.PriorityOld, PriorityNew = new MSTPriorityDto { Name = item.MST_Priority1.Name }, PriorityOld = new MSTPriorityDto { Name = item.MST_Priority.Name }, ReasonId = item.ReasonId, Reason = new DelayReasonDto { Description = item.MST_Reason.Description }, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).SingleAsync(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the asynchronous. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public async Task<MSTFarReportDto> SingleAsync(int id) { MSTFarReportDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = await (from item in context.MST_FARReport where item.IsDeleted == false && item.Id == id select new MSTFarReportDto() { Id = item.Id, ReportTypeId = item.ReportTypeId, OriginId = item.OriginId, Required = item.Required, ReportType = new ReportTypesDto { Id = item.MST_ReportTypes.Id, Name = item.MST_ReportTypes.Name, Description = item.MST_ReportTypes.Description }, Origin = new MSTOriginDto { Id = item.MST_Origin.Id, Name = item.MST_Origin.Name, Description = item.MST_Origin.Description }, Description = item.Description, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).SingleAsync(); } } catch (Exception ex) { result = null; _logService.Error(ex.Message, ex); } return result; }
/// <summary> /// Finds the asynchronous. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public async Task<MSTCustomerDto> SingleAsync(int id) { MSTCustomerDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = await (from item in context.MST_Customer where item.IsDeleted == false && item.Id == id select new MSTCustomerDto() { Id = item.Id, CustomerName = item.CustomerName, EndCustomer = item.EndCustomer, Location = item.Location, Strategic = item.Strategic, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).SingleAsync(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the specified identifier. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public DelayReasonDto Single(int id) { DelayReasonDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = (from item in context.MST_ReasonINIReport where item.IsDeleted == false && item.Id == id select new DelayReasonDto() { Id = item.Id, Description = item.Description, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).Single(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the specified identifier. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public LOGHistoryDto Single(int id) { LOGHistoryDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = (from item in context.LOG_FARHistory where item.IsDeleted == false && item.Id == id select new LOGHistoryDto() { Id = item.Id, MasterId = item.MasterId, StatusId = item.StatusId, ReasonId = item.ReasonId, LogDate = item.LogDate, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).Single(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the asynchronous. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public async Task<FARInitialTargetLogDto> SingleAsync(int id) { FARInitialTargetLogDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = await (from item in context.LOG_FARInitialTarget where item.IsDeleted == false && item.Id == id select new FARInitialTargetLogDto() { Id = item.Id, MasterId = item.MasterId, ReasonId = item.ReasonId, TargetDate = item.TargetDate, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).SingleAsync(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the asynchronous. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public async Task<RecordLockDto> SingleAsync(int id) { RecordLockDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = await (from item in context.FAR_RecordLock where item.IsDeleted == false && item.Id == id select new RecordLockDto() { Id = item.Id, ProcessHistoryId = item.ProcessHistoryId, LockBy = item.LockBy, LockDate = item.LockDate, MasterId = item.MasterId, ReleaseDate = item.ReleaseDate, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).SingleAsync(); } } catch (Exception ex) { result = null; _logService.Error(ex.Message, ex); } return result; }
public async Task<FARCancelLogDto> SingleAsync(int id) { FARCancelLogDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = await (from item in context.LOG_FARCancel where item.IsDeleted == false && item.Id == id select new FARCancelLogDto() { Id = item.Id, MasterId = item.MasterId, StatusId = item.StatusId, ReasonId = item.ReasonId, CancelledDate = item.CancelledDate, IsDeleted = item.IsDeleted, InsertedBy = item.InsertedBy, InsertedOn = item.InsertedOn, UpdatedBy = item.UpdatedBy, UpdatedOn = item.UpdatedOn, }).SingleAsync(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the specified identifier. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public FARDeviceDetailsDto Single(int id) { FARDeviceDetailsDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = (from item in context.FAR_DeviceDetails where item.IsDeleted == false && item.Id == id select new FARDeviceDetailsDto() { Id = item.Id, MasterId = item.MasterId, Master = new FARMasterDto() { Id = item.FAR_Master.Id, Number = item.FAR_Master.Number, Analyst = item.FAR_Master.Analyst, Requestor = item.FAR_Master.Requestor, RefNo = item.FAR_Master.RefNo, StatusId = item.FAR_Master.StatusId, Product = item.FAR_Master.Product, Customer = item.FAR_Master.Customer, FailureRate = item.FAR_Master.FailureRate, RequestDate = item.FAR_Master.RequestDate, FailureDesc = item.FAR_Master.FailureDesc, }, WaferNo = item.WaferNo, SerialNo = item.SerialNo, LotNo = item.LotNo, MfgPartNo = item.MfgPartNo, TechnologyId = item.TechnologyId, Technogoly = new MSTTechnogolyDto() { Id = item.MST_Technology.Id, Name = item.MST_Technology.Name, Description = item.MST_Technology.Description, }, PackageTypeId = item.PackageTypeId, PackageType = new MSTPackageTypesDto() { Id = item.MST_PackageTypes.Id, Name = item.MST_PackageTypes.Name, Description = item.MST_PackageTypes.Description, }, AssemblySiteId = item.AssembliesSiteId, AssemblySites = new MSTAssemblySiteDto() { Id = item.MST_AssemblySites.Id, Name = item.MST_AssemblySites.Code, Description = item.MST_AssemblySites.Description, }, FabSiteId = item.FabSiteId, FabSite = new FabSiteDto() { Id = item.FabSites.Id, Name = item.FabSites.Name, Description = item.FabSites.Description, }, ServiceId = item.ServiceId, FARServices = new MSTServiceDto() { Id = item.MST_Services.Id, Name = item.MST_Services.Name, Description = item.MST_Services.Description }, DateCode = item.DateCode, Quantity = item.Quantity, Stage = item.Stage, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).Single(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the specified identifier. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public FARMasterDto Single(int id) { FARMasterDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = (from item in context.FAR_Master where item.IsDeleted == false && item.Id == id select new FARMasterDto() { Id = item.Id, Number = item.Number, OriginId = item.OriginId, FAROrigin = new MSTOriginDto() { Id = item.MST_Origin.Id, Name = item.MST_Origin.Name, Description = item.MST_Origin.Description }, Requestor = item.Requestor, RefNo = item.RefNo, FailureTypeId = item.FailureTypeId, FARFailureType = new MSTFailureTypeDto() { Id = item.MST_FailureType.Id, Name = item.MST_FailureType.Name, Description = item.MST_FailureType.Description }, FailureOriginId = item.FailureOriginId, FARFailureOrigin = new MSTFailureOriginDto() { Id = item.MST_FailureOrigin.Id, Name = item.MST_FailureOrigin.Name, Description = item.MST_FailureOrigin.Description }, FailureRate = item.FailureRate, StatusId = item.StatusId, FARStatus = new MSTStatusDto() { Id = item.MST_Status.Id, Name = item.MST_Status.Name, Description = item.MST_Status.Description }, Analyst = item.Analyst, RequestDate = item.RequestDate, SamplesArriveDate = item.SamplesArriveDate, PriorityId = item.PriorityId, FARPriority = new MSTPriorityDto() { Id = item.MST_Priority.Id, Name = item.MST_Priority.Name, Description = item.MST_Priority.Description }, InitialReportTargetDate = item.InitialReportTargetDate, BUId = item.BUId, Bu = new MSTBuDto() { Id = item.MST_BU.Id, Name = item.MST_BU.Name, Description = item.MST_BU.Description }, Product = item.Product, FailureDesc = item.FailureDesc, FinalReportTargetDate = item.FinalReportTargetDate, Submitted = item.Submitted, Customer = item.Customer, LabSiteId = item.LabSiteId, LabSite = new MSTLabSiteDto { Id = item.MST_LabSite.Id, Name = item.MST_LabSite.Name, Description = item.MST_LabSite.Description }, RatingId = item.RatingId, Rating = new MSTRatingDto { Id = item.MST_Rating != null ? item.MST_Rating.Id : 0, Name = item.MST_Rating != null ? item.MST_Rating.Name : "", Description = item.MST_Rating != null ? item.MST_Rating.Description : "" }, Comments = item.Comments, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).Single(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); return null; } return result; }
/// <summary> /// Finds the specified identifier. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public LOGProcessHistoryDto Single(int id) { LOGProcessHistoryDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = (from item in context.LOG_ProcessHistory where item.Id == id select new LOGProcessHistoryDto() { Id = item.Id, ProcessHisId = item.ProcessHisId, FARProcessHistory = new FARProcessHistoryDto() { Id = item.FAR_ProcessHistory.Id, Analystor = item.FAR_ProcessHistory.Analystor, Comment = item.FAR_ProcessHistory.Comment, DateIn = item.FAR_ProcessHistory.DateIn, DateOut = item.FAR_ProcessHistory.DateOut, Description = item.FAR_ProcessHistory.Description, PlannedIn = item.FAR_ProcessHistory.PlannedIN, PlannedOut = item.FAR_ProcessHistory.PlannedOUT, SeqNum = item.FAR_ProcessHistory.SeqNum, }, InsertedBy = item.InsertedBy, InsertedDate = item.InsertedDate, PlanFrom = item.PlanFrom, PlanTo = item.PlanTo, PlanType = (PlanType)item.PlanType, }).Single(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the specified identifier. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public MSTProcessProductDto Single(int id) { MSTProcessProductDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = (from item in context.MST_ProcessProduct where item.IsDeleted == false && item.Id == id select new MSTProcessProductDto() { Id = item.Id, InChargePerson = item.InChargePerson, ProcessTypeId = item.ProcessTypeId, ProcessType = new MSTProcessTypesDto { Name = item.MST_ProcessTypes.Name, Description = item.MST_ProcessTypes.Description, }, ProductId = item.ProductId, Product = new MSTProductDto { Name = item.MST_Product.Name, Description = item.MST_Product.Description, }, Description = item.Description, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).Single(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } return result; }
/// <summary> /// Finds the specified identifier. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public MSTProductDto Single(int id) { MSTProductDto result = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { result = (from item in context.MST_Product where item.IsDeleted == false && item.Id == id select new MSTProductDto() { Id = item.Id, Name = item.Name, Description = item.Description, MainPerson = item.MainPerson, SecondaryPerson = item.SecondaryPerson, TertiaryPerson = item.TertiaryPerson, LabSiteId = item.LabSiteId, LabSite = new MSTLabSiteDto { Id = item.MST_LabSite.Id, Name = item.MST_LabSite.Name }, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).Single(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = null; } 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> /// 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> /// 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> /// 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> /// 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> /// Gets all asynchronous. /// </summary> /// <returns></returns> public async Task<IEnumerable<MSTServiceDto>> GetAllAsync() { IEnumerable<MSTServiceDto> results = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { results = await (from item in context.MST_Services where item.IsDeleted == false select new MSTServiceDto() { Id = item.Id, Name = item.Name, Description = item.Description, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).ToListAsync(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); return null; } return results; }
/// <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> /// 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> /// 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> /// 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> /// Gets all asynchronous. /// </summary> /// <returns></returns> public async Task<IEnumerable<FARInitialTargetLogDto>> GetAllAsync() { IEnumerable<FARInitialTargetLogDto> results = null; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { results = await (from item in context.LOG_FARInitialTarget where item.IsDeleted == false select new FARInitialTargetLogDto() { Id = item.Id, MasterId = item.MasterId, ReasonId = item.ReasonId, TargetDate = item.TargetDate, IsDeleted = item.IsDeleted, LastUpdatedBy = item.LastUpdatedBy, LastUpdate = item.LastUpdate, }).ToListAsync(); } } catch (Exception ex) { _logService.Error(ex.Message, ex); return null; } return results; }