public static NONCONFORMANCE UpdateNonconf(SQM.Website.PSsqmEntities ctx, NONCONFORMANCE nonconf, string updateBy)
{
try
{
nonconf = (NONCONFORMANCE)SQMModelMgr.SetObjectTimestamp((object)nonconf, updateBy, nonconf.EntityState);
if (nonconf.EntityState == EntityState.Detached || nonconf.EntityState == EntityState.Added)
{
ctx.AddToNONCONFORMANCE(nonconf);
}
if (nonconf.STATUS == "D")
{
ctx.DeleteObject(nonconf);
}
ctx.SaveChanges();
}
catch (Exception e)
{
//SQMLogger.LogException(e);
}
return(nonconf);
}
public static SQM_MEASURE UpdateSQMMeasure(SQM.Website.PSsqmEntities ctx, SQM_MEASURE measure, string updateBy)
{
try
{
measure = (SQM_MEASURE)SQMModelMgr.SetObjectTimestamp((object)measure, updateBy, measure.EntityState);
if (measure.EntityState == EntityState.Detached || measure.EntityState == EntityState.Added)
{
ctx.AddToSQM_MEASURE(measure);
}
if (measure.STATUS == "D")
{
ctx.DeleteObject(measure);
}
ctx.SaveChanges();
}
catch (Exception e)
{
//SQMLogger.LogException(e);
}
return(measure);
}
public static SETTINGS UpdateSettings(SQM.Website.PSsqmEntities ctx, SETTINGS settings, string updateBy)
{
settings = (SETTINGS)SQMModelMgr.SetObjectTimestamp((object)settings, updateBy, settings.EntityState);
if (settings.EntityState == EntityState.Detached)
{
ctx.AddToSETTINGS(settings);
}
ctx.SaveChanges();
return(settings);
}
public static PERSPECTIVE_VIEW UpdateView(SQM.Website.PSsqmEntities ctx, PERSPECTIVE_VIEW view, string updateBy)
{
try
{
if (view.STATUS == "D")
{
ctx.DeleteObject(view);
}
else
{
view = (PERSPECTIVE_VIEW)SQMModelMgr.SetObjectTimestamp((object)view, updateBy, view.EntityState);
if (view.EntityState == EntityState.Detached || view.EntityState == EntityState.Added)
{
view.STATUS = "A";
ctx.AddToPERSPECTIVE_VIEW(view);
}
foreach (PERSPECTIVE_VIEW_ITEM vi in view.PERSPECTIVE_VIEW_ITEM.ToList())
{
if (vi.STATUS == "D" || vi.ITEM_SEQ < 1)
{
ctx.DeleteObject(vi);
}
else
{
if (vi.EntityState == EntityState.Detached || vi.EntityState == EntityState.Added)
{
vi.STATUS = "A";
vi.CALCS_SCOPE = view.PERSPECTIVE;
ctx.AddToPERSPECTIVE_VIEW_ITEM(vi);
}
}
}
}
ctx.SaveChanges();
}
catch (Exception e)
{
//SQMLogger.LogException(e);
}
return(view);
}
