private static bool HasBlankCountOrMeasure(this CruiseDatastore dal)
{
return(dal.GetRowCount(TREE._NAME, "WHERE ifnull(CountOrMeasure, '') = ''") > 0);
}
private static bool HasBlankDefaultLiveDead(this CruiseDatastore dal)
{
return(dal.GetRowCount(SAMPLEGROUP._NAME, "WHERE ifnull(DefaultLiveDead, '') = ''") > 0);
}
private static bool HasBlankLiveDead(this CruiseDatastore dal)
{
return(dal.GetRowCount(TREE._NAME, "WHERE ifnull(LiveDead, '') = ''") > 0);
}
private static bool HasBlankSpeciesCodes(this CruiseDatastore dal)
{
return(dal.GetRowCount(TREE._NAME, "WHERE ifnull(Species, '') = ''") > 0);
}
private static bool HasStrataWithNoSampleGroups(this CruiseDatastore dal)
{
return(dal.GetRowCount("Stratum", "LEFT JOIN SampleGroup USING (Stratum_CN) WHERE SampleGroup.Stratum_CN IS NULL") > 0);
}
private static bool HasOrphanedStrata(this CruiseDatastore dal)
{
return(dal.GetRowCount("Stratum", "LEFT JOIN CuttingUnitStratum USING (Stratum_CN) WHERE CuttingUnitStratum.Stratum_CN IS NULL") > 0);
}
private static bool HasMismatchSpecies(CruiseDatastore dal)
{
return(dal.GetRowCount("Tree", "JOIN TreeDefaultValue AS tdv USING (TreeDefaultValue_CN) WHERE Tree.Species != tdv.Species;") > 0);
}
