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