public static List <PlotDO> ReadyByUnitStratum(Datastore dal, String unit, String stratum)
{
if (dal == null)
{
return(null);
}
if (String.IsNullOrEmpty(unit))
{
return(dal.From <PlotDO>()
.Join("Stratum", "USING (Stratum_CN)")
.Where("Stratum.Code = @p1")
.Read(stratum).ToList());
//.Read<PlotDO>("JOIN Stratum WHERE Plot.Stratum_CN = Stratum.Stratum_CN AND Stratum.Code = ?;", (object)stratum);
}
else if (String.IsNullOrEmpty(stratum))
{
return(dal.From <PlotDO>()
.Join("CuttingUnit", "USING (CuttingUnit_CN)")
.Where("CuttingUnit.Code = @p1")
.Read(unit).ToList());
//.Read<PlotDO>("JOIN CuttingUnit WHERE Plot.CuttingUnit_CN = CuttingUnit.CuttingUnit_CN AND CuttingUnit.Code = ?;", (object)unit);
}
return(dal.From <PlotDO>()
.Join("CuttingUnit", "USING (CuttingUnit_CN)")
.Join("Stratum", "USING (Stratum_CN)")
.Where("CuttingUnit.Code = @p1 AND Stratum.Code = @p2")
.Read(unit, stratum).ToList());
//.Read<PlotDO>("JOIN CuttingUnit JOIN Stratum WHERE Plot.CuttingUnit_CN = CuttingUnit.CuttingUnit_CN AND CuttingUnit.Code = ? AND Plot.Stratum_CN = Stratum.Stratum_CN AND Stratum.Code = ?;", (object)unit, stratum);
}
public static int DeleteStratum(Datastore dal, StratumDO stratum)
{
// check tree table for data
if (dal.GetRowCount("Tree", "WHERE Stratum_CN = @p1", stratum.Stratum_CN) > 0)
{
return(-1);
}
// check plot table for data
if (dal.GetRowCount("Plot", "WHERE Stratum_CN = @p1", stratum.Stratum_CN) > 0)
{
return(-1);
}
// Check Count table for each sample group
if (dal.GetRowCount("CountTree", "JOIN SampleGroup ON CountTree.SampleGroup_CN = SampleGroup.SampleGroup_CN WHERE SampleGroup.Stratum_CN = @p1 AND CountTree.TreeCount > 0", stratum.Stratum_CN) > 0)
{
return(-1);
}
//Delete sample groups for stratum
List <SampleGroupDO> allSGInStratum = dal.From <SampleGroupDO>()
.Where("Stratum_CN = @p1")
.Read(stratum.Stratum_CN).ToList();
//.Read<SampleGroupDO>("WHERE Stratum_CN = ?", stratum.Stratum_CN);
foreach (SampleGroupDO Sg in allSGInStratum)
{
//Delete Count Records for stratum
List <CountTreeDO> allCountInSG = dal.From <CountTreeDO>()
.Where("SampleGroup_CN = @p1")
.Read(Sg.SampleGroup_CN).ToList();
//.Read<CountTreeDO>("WHERE SampleGroup_CN = ?", Sg.SampleGroup_CN);
foreach (CountTreeDO Cnt in allCountInSG)
{
Cnt.Delete();
}
Sg.Delete();
}
//Delete stratum stats for stratum
List <StratumStatsDO> allStratumStatsInStratum = dal.From <StratumStatsDO>()
.Where("Stratum_CN = @p1")
.Read(stratum.Stratum_CN)
.ToList();
//.Read<StratumStatsDO>(
//"WHERE Stratum_CN = ?", stratum.Stratum_CN);
foreach (StratumStatsDO StratumStats in allStratumStatsInStratum)
{
StratumStats.DeleteStratumStats(dal, StratumStats.StratumStats_CN);
}
stratum.Delete();
return(0);
}
public int DeleteSampleGroup(Datastore dal, long?SampleGroup_CN)
{
// check tree table for data
if (dal.GetRowCount("Tree", "WHERE SampleGroup_CN = @p1", SampleGroup_CN) > 0)
{
return(-1);
}
// Check Count table for each sample group
if (dal.GetRowCount("CountTree", "WHERE SampleGroup_CN = @p1 AND TreeCount > 0", SampleGroup_CN) > 0)
{
return(-1);
}
//Delete Count Records for stratum
var allCountInSg = dal.From <CountTreeDO>()
.Where("SampleGroup_CN = @p1")
.Read(SampleGroup_CN).ToList();
foreach (CountTreeDO Cnt in allCountInSg)
{
Cnt.Delete();
}
Delete();
return(0);
}
public static void CleanupErrorLog(Datastore db)
{
foreach (var el in db.From <ErrorLog>().Where("CN_Number != 0").Query())
{
if (db.GetRowCount(el.TableName, "WHERE rowID = @p1", el.CN_Number) == 0)
{
db.Delete(el);
}
}
}
public static List <StratumDO> ReadByUnitCode(Datastore dal, String code)
{
if (dal == null)
{
return(null);
}
return(dal.From <StratumDO>()
.Join("CuttingUnitStratum", "USING (Stratum_CN)")
.Join("CuttingUnit", "USING (CuttingUnit_CN)")
.Where("CuttingUnit.Code = @p1")
.Read(code).ToList());
}
public static List <CuttingUnitDO> ReadByStratumCode(Datastore dal, String code)
{
if (dal == null)
{
return(null);
}
return(dal.From <CuttingUnitDO>()
.Join("CuttingUnitStratum", "USING (CuttingUnit_CN)")
.Join("Stratum", "Using (Stratum_CN)")
.Where("Stratum.Code = @p1")
.Read(code).ToList());
//.Read<CuttingUnitDO>("JOIN CuttingUnitStratum JOIN Stratum WHERE CuttingUnit.CuttingUnit_CN = CuttingUnitStratum.CuttingUnit_CN AND CuttingUnitStratum.Stratum_CN = Stratum.Stratum_CN AND Stratum.Code = ?;", (object)code);
}
public int DeleteStratumStats(Datastore dal, long?StratumStats_CN)
{
//Delete sample group stats for stratum
var allSGStatsInStratumStats = dal.From <SampleGroupStatsDO>()
.Where("StratumStats_CN = @p1")
.Read(StratumStats_CN).ToList();
foreach (SampleGroupStatsDO SgStats in allSGStatsInStratumStats)
{
SgStats.Delete();
}
Delete();
return(0);
}
