public ParametrizationCorrectiveAction Update(ParametrizationCorrectiveAction updateparam) { using (var scope = _serviceProvider.CreateScope()) { var _ctx = scope.ServiceProvider.GetService(typeof(SQLHoshinCoreContext)) as SQLHoshinCoreContext; var paramCorrectiveAction = _ctx.ParametrizationCorrectiveActions.Where(x => x.ParametrizationCorrectiveActionID == updateparam.Id).FirstOrDefault(); paramCorrectiveAction.Name = updateparam.Name; paramCorrectiveAction.Code = updateparam.Code; paramCorrectiveAction.Value = updateparam.Value; _ctx.Update(paramCorrectiveAction); _ctx.SaveChanges(); return(updateparam); } }
public ParametrizationCorrectiveAction Add(ParametrizationCorrectiveAction newparam) { using (var scope = _serviceProvider.CreateScope()) { var _ctx = scope.ServiceProvider.GetService(typeof(SQLHoshinCoreContext)) as SQLHoshinCoreContext; var param = _ctx.ParametrizationCorrectiveActions.Where(x => x.Name == newparam.Name).FirstOrDefault(); if (param == null) { var paramCorrectiveAction = new ParametrizationCorrectiveActions(); paramCorrectiveAction.Name = newparam.Name; paramCorrectiveAction.Code = newparam.Code; paramCorrectiveAction.Value = newparam.Value; _ctx.ParametrizationCorrectiveActions.Add(paramCorrectiveAction); _ctx.SaveChanges(); newparam.Id = paramCorrectiveAction.ParametrizationCorrectiveActionID; return(newparam); } return(null); } }