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