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