public void PullNewSampleGroups(ComponentFileVM comp)
{
StartJob("Add New Sample Groups");
var compSGList = comp.Database.From<SampleGroupDO>().Query();
foreach (SampleGroupDO sg in compSGList)
{
SampleGroupDO match = Master.From<SampleGroupDO>()
.Where("Code = ? AND Stratum_CN = ?")
.Query(sg.Code, sg.Stratum_CN).FirstOrDefault();
if (match == null)
{
SampleGroupDO newSG = new SampleGroupDO(Master);
newSG.SuspendEvents();
newSG.SetValues(sg);
newSG.Stratum_CN = sg.Stratum_CN;
newSG.ResumeEvents();
newSG.Save();
match = newSG;
}
if (sg.SampleGroup_CN != match.SampleGroup_CN)
{
comp.Database.Execute("UPDATE SampleGroup SET SampleGroup_CN = ? WHERE SampleGroup_CN = ?;", match.SampleGroup_CN, sg.SampleGroup_CN);
}
}
EndJob();
}
