public UserRepository(UserManager <Users> userManager, SQLHoshinCoreContext ctx, IMapper mapper, RoleManager <Roles> roleManager) { _userManager = userManager; _roleManager = roleManager; _ctx = ctx; _mapper = mapper; }
private AuditStates ValidateDescriptionAuditState(SQLHoshinCoreContext _ctx, IMapper _mapper, AuditState auditState) { AuditStates auditStateValidation = _ctx.AuditStates.Where(x => (x.Name == auditState.Name || x.Code == auditState.Code || x.Color == auditState.Color) && x.AuditStateID != auditState.AuditStateID).FirstOrDefault(); if (auditStateValidation == null) { return(_mapper.Map <AuditState, AuditStates>(auditState)); } return(null); }
private void SetAuditInitiated(int auditId, SQLHoshinCoreContext ctx) { var audit = ctx.Audits.FirstOrDefault((x) => x.AuditID == auditId); var stateInitiated = ctx.AuditStates.FirstOrDefault(x => x.Code == "INI").AuditStateID; if (audit.AuditStateID != stateInitiated) { audit.AuditStateID = stateInitiated; ctx.Update(audit); } }
private IQueryable <Findings> MakeGetAllQuery(SQLHoshinCoreContext _ctx) { return(_ctx.Findings .Include(x => x.EmitterUser) .ThenInclude(x => x.JobSectorPlant.SectorPlant.Sector) .Include(x => x.EmitterUser) .ThenInclude(x => x.JobSectorPlant.SectorPlant.Plant) .Include(x => x.ResponsibleUser) .Include(x => x.FindingType) .Include(x => x.FindingState) .Include(x => x.FindingComments) .Include(x => x.SectorPlantTreatment) .ThenInclude(y => y.Sector) .Include(x => x.SectorPlantTreatment) .ThenInclude(y => y.Plant) .Where(f => f.WorkflowId != null)); }
private string ValidateStandard(SQLHoshinCoreContext _ctx, IMapper _mapper, Standard standard) { string validation = string.Empty; Standards standardValidation = _ctx.Standards.Where(x => (x.Name == standard.Name || x.Code == standard.Code) && x.StandardID != standard.StandardID).FirstOrDefault(); validation = standardValidation != null ? "NameExist" : string.Empty; if (!string.IsNullOrEmpty(validation)) { return(validation); } validation = standard.Aspects.Count() == standard.Aspects.Where(x => !x.Active).Count() ? "OneActive" : string.Empty; if (!string.IsNullOrEmpty(validation)) { return(validation); } return(validation); }
public CompanyRepository(SQLHoshinCoreContext ctx, IMapper mapper) { _ctx = ctx; _mapper = mapper; }
public UserCorrectiveActionsRepository(SQLHoshinCoreContext ctx) { _ctx = ctx; }
public RoleRepository(RoleManager <Roles> roleManager, IMapper mapper, SQLHoshinCoreContext ctx) { _roleManager = roleManager; _mapper = mapper; _ctx = ctx; }
public CorrectiveActionFishboneRepository(SQLHoshinCoreContext ctx, IMapper mapper) { _ctx = ctx; _mapper = mapper; }
public GetUpdatedJobsOfSectorTest() { var optionsBuilder = new DbContextOptionsBuilder <SQLHoshinCoreContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()) .Options; _ctx = new SQLHoshinCoreContext(optionsBuilder); jobs = new List <Domain.Job.Job>(); sectorsPlants = new SectorsPlants(); jobsDbSet = new List <Jobs> { new Jobs { JobID = 1 }, new Jobs { JobID = 2 }, new Jobs { JobID = 3 }, new Jobs { JobID = 4 }, new Jobs { JobID = 5 }, new Jobs { JobID = 6 }, new Jobs { JobID = 7 }, new Jobs { JobID = 8 }, new Jobs { JobID = 9 }, new Jobs { JobID = 10 } }; _ctx.Jobs.AddRange(jobsDbSet); _ctx.SaveChanges(); sectorsPlants.JobsSectorsPlants = new List <JobsSectorsPlants>(); sectorsPlants.JobsSectorsPlants.Add(new JobsSectorsPlants { PlantID = 1, SectorID = 1, JobID = 1, }); sectorsPlants.JobsSectorsPlants.Add(new JobsSectorsPlants { PlantID = 1, SectorID = 1, JobID = 2, }); sectorsPlants.JobsSectorsPlants.Add(new JobsSectorsPlants { PlantID = 1, SectorID = 1, JobID = 3, }); sectorsPlants.JobsSectorsPlants.Add(new JobsSectorsPlants { PlantID = 1, SectorID = 1, JobID = 4, }); }
public AuditTypeRepository(SQLHoshinCoreContext ctx, IMapper mapper) { _ctx = ctx; _mapper = mapper; }
public ParametrizationCriteriaRepository(SQLHoshinCoreContext ctx) { _ctx = ctx; }
public AlertUserRepository(SQLHoshinCoreContext ctx, IMapper mapper) { _ctx = ctx; _mapper = mapper; }