private IList <FixCNTTallyPopulation> PopulateTallyPopulations()
{
System.Diagnostics.Debug.Assert(Stratum != null);
var list = new List <FixCNTTallyPopulation>();
var sampleGroups = DAL.From <SampleGroupDO>()
.Where("Stratum_CN = @p1")
.Query(Stratum_CN);
foreach (var sg in sampleGroups)
{
var treeDefaults = DAL.From <TreeDefaultValueDO>()
.Join("SampleGroupTreeDefaultValue", "USING (TreeDefaultValue_CN)")
.Where("SampleGroup_CN = @p1")
.Query(sg.SampleGroup_CN);
foreach (var tdv in treeDefaults)
{
var pop = DAL.From <FixCNTTallyPopulation>()
.Where("SampleGroup_CN = @p1 AND TreeDefaultValue_CN = @p2")
.Query(sg.SampleGroup_CN, tdv.TreeDefaultValue_CN).FirstOrDefault();
if (pop == null)
{
pop = new FixCNTTallyPopulation()
{
DAL = this.DAL,
SampleGroup_CN = sg.SampleGroup_CN,
TreeDefaultValue_CN = tdv.TreeDefaultValue_CN,
};
}
pop.TallyClass = this;
list.Add(pop);
}
}
return(list);
}
private IList<FixCNTTallyPopulation> PopulateTallyPopulations()
{
System.Diagnostics.Debug.Assert(Stratum != null);
var list = new List<FixCNTTallyPopulation>();
var sampleGroups = DAL.From<SampleGroupDO>()
.Where("Stratum_CN = ?")
.Query(Stratum_CN);
foreach (var sg in sampleGroups)
{
var treeDefaults = DAL.From<TreeDefaultValueDO>()
.Join("SampleGroupTreeDefaultValue", "USING (TreeDefaultValue_CN)")
.Where("SampleGroup_CN = ?")
.Query(sg.SampleGroup_CN);
foreach (var tdv in treeDefaults)
{
var pop = DAL.From<FixCNTTallyPopulation>()
.Where("SampleGroup_CN = ? AND TreeDefaultValue_CN = ?")
.Query(sg.SampleGroup_CN, tdv.TreeDefaultValue_CN).FirstOrDefault();
if (pop == null)
{
pop = new FixCNTTallyPopulation()
{
DAL = this.DAL,
SampleGroup_CN = sg.SampleGroup_CN,
TreeDefaultValue_CN = tdv.TreeDefaultValue_CN,
};
}
pop.TallyClass = this;
list.Add(pop);
}
}
return list;
}
