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();
}
}
