public Hoshin.Quality.Domain.AspectStates.AspectStates Update(Hoshin.Quality.Domain.AspectStates.AspectStates aspectStatus)
        {
            using (var scope = _serviceProvider.CreateScope())
            {
                var _ctx = scope.ServiceProvider.GetService(typeof(SQLHoshinCoreContext)) as SQLHoshinCoreContext;
                var aspectStatesResult = _ctx.AspectStates.Where(x => x.AspectStateID == aspectStatus.AspectStateID).FirstOrDefault();
                aspectStatesResult.Name   = aspectStatus.Name;
                aspectStatesResult.Colour = aspectStatus.Colour;
                aspectStatesResult.Active = aspectStatus.Active;
                _ctx.Update(aspectStatesResult);
                _ctx.SaveChanges();

                return(aspectStatus);
            }
        }
        public Hoshin.Quality.Domain.AspectStates.AspectStates Add(Hoshin.Quality.Domain.AspectStates.AspectStates aspectStatus)
        {
            using (var scope = _serviceProvider.CreateScope())
            {
                var _ctx = scope.ServiceProvider.GetService(typeof(SQLHoshinCoreContext)) as SQLHoshinCoreContext;

                var aspectState = new AspectStates();
                aspectState.Name   = aspectStatus.Name;
                aspectState.Colour = aspectStatus.Colour;
                aspectState.Active = aspectStatus.Active;

                _ctx.AspectStates.Add(aspectState);
                _ctx.SaveChanges();

                aspectStatus.AspectStateID = aspectState.AspectStateID;

                return(aspectStatus);
            }
        }