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 SQM_MEASURE LookupSQMMeasure(SQM.Website.PSsqmEntities ctx, decimal measureID, string measureCode)
{
SQM_MEASURE measure = null;
if (measureID == 0)
{
measure = (from m in ctx.SQM_MEASURE
where (m.MEASURE_CD.ToUpper() == measureCode.ToUpper())
select m).Single();
}
else
{
measure = (from m in ctx.SQM_MEASURE
where (m.MEASURE_ID == measureID)
select m).Single();
}
return(measure);
}
