public void SetNoAudited(AuditStandardAspect auditStandardAspect) { using (var scope = _serviceProvider.CreateScope()) { var _ctx = scope.ServiceProvider.GetService(typeof(SQLHoshinCoreContext)) as SQLHoshinCoreContext; var auditStandardAspectToUpdate = _ctx .AuditStandardAspects .Include(x => x.Findings) .Where(x => x.AuditID == auditStandardAspect.AuditID && x.StandardID == auditStandardAspect.StandardID && x.AspectID == auditStandardAspect.AspectID) .FirstOrDefault(); auditStandardAspectToUpdate.Findings.Clear(); auditStandardAspectToUpdate.NoAudited = true; auditStandardAspectToUpdate.WithoutFindings = false; auditStandardAspectToUpdate.Description = auditStandardAspect.Description; this.SetAuditInitiated(auditStandardAspect.AuditID, _ctx); _ctx.AuditStandardAspects.Update(auditStandardAspectToUpdate); _ctx.SaveChanges(); } }
public AuditStandardAspect Add(AuditStandardAspect auditStandardAspect) { using (var scope = _serviceProvider.CreateScope()) { var _mapper = scope.ServiceProvider.GetService(typeof(IMapper)) as IMapper; var _ctx = scope.ServiceProvider.GetService(typeof(SQLHoshinCoreContext)) as SQLHoshinCoreContext; var auditStandardAspectRepo = _mapper.Map <AuditStandardAspect, Entities.Quality.AuditStandardAspect>(auditStandardAspect); _ctx.AuditStandardAspects.Add(auditStandardAspectRepo); _ctx.SaveChanges(); return(_mapper.Map <Entities.Quality.AuditStandardAspect, AuditStandardAspect>(auditStandardAspectRepo)); } }
public void SetPendingState(AuditStandardAspect auditStandardAspect) { using (var scope = _serviceProvider.CreateScope()) { var _ctx = scope.ServiceProvider.GetService(typeof(SQLHoshinCoreContext)) as SQLHoshinCoreContext; var auditStandardAspectToUpdate = _ctx .AuditStandardAspects .Where(x => x.AuditID == auditStandardAspect.AuditID && x.StandardID == auditStandardAspect.StandardID && x.AspectID == auditStandardAspect.AspectID) .FirstOrDefault(); auditStandardAspectToUpdate.AspectStateID = _ctx.AspectStates.FirstOrDefault(x => x.Name == "Pendiente" && x.Active == true).AspectStateID; _ctx.AuditStandardAspects.Update(auditStandardAspectToUpdate); _ctx.SaveChanges(); } }