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