public static bool ValidateSetup(SampleGroupDO sg, StratumDO st, out string error)
{
bool isValid = true;
error = null;
sg.Validate();
string pre = "Stratum: " + st.Code + " IN SG: " + sg.Code + " -";
if (sg.HasErrors())
{
isValid = false;
error += pre + sg.Error;
}
if (String.IsNullOrEmpty(sg.Code))
{
isValid = false;
error += pre + " Code can't be empty";
}
if (sg.TreeDefaultValues.Count == 0)
{
isValid = false;
error += pre + " No Tree Defaults Selected";
}
isValid = sg.ValidatePProdOnTDVs(ref error) && isValid;
return(isValid);
}
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 static bool CanEnableKZ(StratumDO stratum)
{
if (stratum == null) { return false; }
if (stratum.Method == null) { return true; }
if (Array.IndexOf(Schema.CruiseMethods.THREE_P_METHODS, stratum.Method) >= 0)
{
return true;
}
return false;
}
public static bool CanEnableBigBAF(StratumDO stratum)
{
if (stratum == null) { return false; }
if (stratum.Method == null) { return true; }
if (stratum.Method == "PCM")
{
return true;
}
return false;
}
public static bool CanDefineTallys(StratumDO stratum)
{
if (stratum.Method == "FIX" || stratum.Method == "PNT" || stratum.Method == "100")
{
return(false);
}
else
{
return(true);
}
}
public static bool CanEnableIFreq(StratumDO stratum)
{
if (stratum == null) { return false; }
if (stratum.Method == null) { return true; }
string method = stratum.Method;
if (method == "3P" || method == "S3P" || method == "STR")
{
return true;
}
return false;
}
public static bool CanEnableBigBAF(StratumDO stratum)
{
if (stratum == null)
{
return(false);
}
if (stratum.Method == null)
{
return(true);
}
if (stratum.Method == "PCM")
{
return(true);
}
return(false);
}
public static bool CanEnableKZ(StratumDO stratum)
{
if (stratum == null)
{
return(false);
}
if (stratum.Method == null)
{
return(true);
}
if (Array.IndexOf(Schema.CruiseMethods.THREE_P_METHODS, stratum.Method) >= 0)
{
return(true);
}
return(false);
}
public void ReadCountsTest()
{
IWindowPresenter wp = new WindowPresenterStub() { Database = new CruiseDAL.DAL(readTestFile) };
PrivateObject param0 = new PrivateObject( new DataEditorView(wp));
DataEditorView_Accessor target = new DataEditorView_Accessor(param0);
CuttingUnitDO cu = new CuttingUnitDO() { rowID = 1 };
StratumDO st = new StratumDO() { rowID = 1 };
SampleGroupDO sg = new SampleGroupDO() { rowID = 1 };
List<CountTreeDO> expected = null; // TODO: Initialize to an appropriate value
List<CountTreeDO> actual;
actual = target.ReadCounts(cu, st, sg);
Assert.AreEqual(expected, actual);
Assert.Inconclusive("Verify the correctness of this test method.");
}
public static bool CanEnableFrequency(StratumDO stratum)
{
if (stratum == null) { return false; }
if (stratum.Method == null) { return true; }
if (stratum.Method.IndexOf("3P") != -1)
{
return false;
}
if (stratum.Method == CruiseMethods.PNT
|| stratum.Method == CruiseMethods.FIX
|| stratum.Method == CruiseMethods.H_PCT
|| stratum.Method == CruiseMethods.FIXCNT)
{
return false;
}
return true;
}
public static bool CanEnableIFreq(StratumDO stratum)
{
if (stratum == null)
{
return(false);
}
if (stratum.Method == null)
{
return(true);
}
string method = stratum.Method;
if (method == "3P" || method == "S3P" || method == "STR")
{
return(true);
}
return(false);
}
protected void OnStratumChanged(StType newStratum)
{
Cursor.Current = Cursors.WaitCursor;
if (newStratum != null)
{
List <SGType> list = this.Controller.DataStore.From <SGType>()
.Where("Stratum_CN = ?")
.Read(newStratum.Stratum_CN).ToList();
foreach (SGType sg in list)
{
sg.TallyMethod = sg.GetSampleGroupTallyMode();
}
list.Add(_newSGPlaceHolder);
this._BS_SampleGroups.DataSource = list;
}
else
{
this._BS_SampleGroups.DataSource = new SGType[0];
}
Cursor.Current = Cursors.Default;
}
public static void RecursiveDeleteStratum(StratumDO stratum)
{
Datastore db = stratum.DAL;
db.BeginTransaction();
try
{
string command =
String.Format(@"DELETE From CuttingUnitStratum WHERE Stratum_CN = {0};
DELETE FROM Log WHERE Tree_CN IN (SELECT Tree_CN FROM Tree WHERE Tree.Stratum_CN = {0});
DELETE FROM LogStock WHERE Tree_CN IN (SELECT Tree_CN FROM Tree WHERE Tree.Stratum_CN = {0});
DELETE FROM TreeCalculatedValues WHERE Tree_CN IN (SELECT Tree_CN FROM Tree WHERE Tree.Stratum_CN = {0});
DELETE FROM Tree WHERE Stratum_CN = {0};
DELETE FROM Plot WHERE Stratum_CN = {0};
DELETE FROM TreeEstimate WHERE CountTree_CN IN (SELECT CountTree_CN FROM CountTree JOIN SampleGroup USING (SampleGroup_CN) WHERE Stratum_CN = {0});
DELETE FROM CountTree WHERE SampleGroup_CN IN (SELECT SampleGroup_CN FROM SampleGroup WHERE SampleGroup.Stratum_CN = {0});
DELETE FROM SampleGroupTreeDefaultValue WHERE SampleGroup_CN IN (SELECT SampleGroup_CN FROM SampleGroup WHERE SampleGroup.Stratum_CN = {0});
DELETE FROM SamplerState WHERE SampleGroup_CN IN (SELECT SampleGroup_CN FROM SampleGroup WHERE SampleGroup.Stratum_CN = {0});
DELETE FROM SampleGroup WHERE Stratum_CN = {0};
DELETE FROM TreeFieldSetup WHERE Stratum_CN = {0};
DELETE FROM LogFieldSetup WHERE Stratum_CN = {0};
DELETE FROM FixCNTTallyPopulation WHERE FixCNTTallyClass_CN IN (SELECT FixCNTtallyClass_CN FROM FixCNTTallyClass WHERE Stratum_CN = {0});
DELETE FROM FixCNTTallyClass WHERE Stratum_CN = {0};
DELETE FROM SampleGroupStatsTreeDefaultValue WHERE SampleGroupStats_CN IN
(SELECT SampleGroupStats_CN FROM SampleGroupStats AS sgs
JOIN StratumStats AS ss USING (StratumStats_CN) WHERE Stratum_CN = {0});
DELETE FROM SampleGroupStats WHERE StratumStats_CN IN
(SELECT StratumStats_CN FROM StratumStats WHERE Stratum_CN = {0});
DELETE FROM StratumStats WHERE Stratum_CN = {0};",
stratum.Stratum_CN);
db.Execute(command);
stratum.Delete();
db.CommitTransaction();
}
catch (Exception e)
{
db.RollbackTransaction();
throw e;
}
}
public static bool CanEnableFrequency(StratumDO stratum)
{
if (stratum == null)
{
return(false);
}
if (stratum.Method == null)
{
return(true);
}
if (stratum.Method.IndexOf("3P") != -1)
{
return(false);
}
if (stratum.Method == CruiseMethods.PNT ||
stratum.Method == CruiseMethods.FIX ||
stratum.Method == CruiseMethods.H_PCT ||
stratum.Method == CruiseMethods.FIXCNT)
{
return(false);
}
return(true);
}
public int getPopulations(StratumDO currentStratum)
{
// for each stratum
stage = statClass.isTwoStage(currentStratum.Method);
strStats = new StratumStatsDO(cdDAL);
strStats.Stratum = currentStratum;
strStats.Code = currentStratum.Code;
strStats.Description = currentStratum.Description;
strStats.SgSet = 1;
strStats.SgSetDescription = "";
float totalAcres = 0;
currentStratum.CuttingUnits.Populate();
foreach (CuttingUnitDO cu in currentStratum.CuttingUnits)
{
float acres = cu.Area;
totalAcres += acres;
}
strStats.TotalAcres = totalAcres;
strStats.Method = currentStratum.Method;
strStats.BasalAreaFactor = currentStratum.BasalAreaFactor;
strStats.FixedPlotSize = currentStratum.FixedPlotSize;
strStats.Used = 1;
strStats.Save();
if (getSampleGroupStats(currentStratum, strStats, totalAcres) < 0)
return(-1);
getStratumStats(strStats);
// create stratum sets;
// create sample group sets
// calculate stats
return (0);
}
public SampleGroupDO CreateNewSampleGroup(StratumDO stratum)
{
SampleGroupDO newSG = new SampleGroupDO();
newSG.DAL = this._cDal;
newSG.Stratum = stratum;
newSG.UOM = this._cDal.ExecuteScalar("Select DefaultUOM FROM Sale;") as String;
//newSG.UOM = this._cDal.ReadSingleRow<SaleDO>("Sale", false, null).DefaultUOM;
if (this.ViewController.ShowEditSampleGroup(newSG, true) == DialogResult.OK)
{
return newSG;
}
else
{
return null;
}
}
private void copyStratumToFScruise(DAL cdDAL)
{
//loop through design stratum table
List<StratumDO> myStr = new List<StratumDO>(cdDAL.Read<StratumDO>("Stratum",null,null));
foreach(StratumDO curStr in myStr)
{
// create new stratumDO
StratumDO fsStr = new StratumDO(fsDAL);
// copy stratum information
fsStr.Code = curStr.Code;
fsStr.Description = curStr.Description;
fsStr.Method = curStr.Method;
fsStr.BasalAreaFactor = curStr.BasalAreaFactor;
fsStr.FixedPlotSize = curStr.FixedPlotSize;
fsStr.KZ3PPNT = curStr.KZ3PPNT;
fsStr.YieldComponent = curStr.YieldComponent;
fsStr.Year = curStr.Year;
fsStr.Month = curStr.Month;
fsStr.Save();
}
}
public StratumVM(StratumDO st)
: base(st)
{
}
/// <summary>
/// helper method for Finish, executes database command that creates field set up entries from field setup defaults
/// </summary>
/// <param name="stratum"></param>
/// <param name="database"></param>
private void SetFieldSetup(StratumDO stratum, DAL database)
{
string setTreeFieldCommand = String.Format(@"INSERT OR IGNORE INTO TreeFieldSetup (Stratum_CN, Field, FieldOrder, ColumnType, Heading, Width, Format, Behavior)
Select {0} as Stratum_CN, Field, FieldOrder, ColumnType, Heading, Width, Format, Behavior
FROM TreeFieldSetupDefault
WHERE Method = '{1}';", stratum.Stratum_CN, stratum.Method);
string setLogFieldCommand = String.Format(@"INSERT OR IGNORE INTO LogFieldSetup (Stratum_CN, Field, FieldOrder, ColumnType, Heading, Width, Format, Behavior)
Select {0} as Stratum_CN, Field, FieldOrder, ColumnType, Heading, Width, Format, Behavior
FROM LogFieldSetupDefault;",
stratum.Stratum_CN);
database.Execute(setTreeFieldCommand);
database.Execute(setLogFieldCommand);
}
public bool CanDefintTallys(StratumDO stratum)
{
return StratumDO.CanDefineTallys(stratum);
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
// popup methods view
string columnName = this.dataGridViewStratumStats.Columns[e.ColumnIndex].HeaderText;
if (columnName == "Method")
{
//set binding list using currentStratum_cn
currentStratumStats.Used = 0;
currentStratumStats.Save();
msStratumStats = new BindingList<StratumStatsDO>(cdDAL.Read<StratumStatsDO>("StratumStats", "Where Stratum_CN = ? ORDER BY Method", currentStratumStats.Stratum_CN));
currentStratum = cdDAL.ReadSingleRow<StratumDO>("Stratum", "Where Stratum_CN = ?", currentStratumStats.Stratum_CN);
MethodSelect mDlg = new MethodSelect(this);
//mDlg.Owner = this;
// strDlg.dalFile = dalPath;
mDlg.ShowDialog(this);
// recreate stratum list/SampleGroup list with new selection
currentStratumStats.Save();
//currentStratum = cdDAL.ReadSingleRow<StratumDO>("Stratum", "Where Stratum_CN = ?", currentStratumStats.Stratum_CN);
//currentStratum.Method = currentStratumStats.Method;
currentStratum.Save();
InitializeDatabaseTables();
bindingSourceStratumStats.DataSource = cdStratumStats;
getSaleError();
}
}
protected void OnStratumChanged(StType newStratum)
{
Cursor.Current = Cursors.WaitCursor;
if (newStratum != null)
{
List<SGType> list = this.Controller._cDal.From<SGType>()
.Where("Stratum_CN = ?")
.Read(newStratum.Stratum_CN).ToList();
foreach (SGType sg in list)
{
sg.TallyMethod = sg.GetSampleGroupTallyMode();
}
list.Add(_newSGPlaceHolder);
this._BS_SampleGroups.DataSource = list;
}
else
{
this._BS_SampleGroups.DataSource = Constants.EMPTY_SG_LIST;
}
Cursor.Current = Cursors.Default;
}
internal void SetSelectedStratum(StratumDO stratrum)
{
var index = StratumBindingSource.IndexOf(stratrum);
StratumBindingSource.Position = index;
}
protected List<TreeFieldSetupDO> GetSelectedTreeFields(StratumDO stratum)
{
return this.Database.Read<TreeFieldSetupDO>("TreeFieldSetup", "WHERE Stratum_CN = ? ORDER BY FieldOrder", stratum.Stratum_CN);
}
public StratumDO(StratumDO obj) : this()
{
SetValues(obj);
}
public void HandleStratumChanging(TreeVM tree, StratumDO st, out bool cancel)
{
if (tree == null || st == null) { cancel = true; return; }
if (tree.Stratum != null && tree.Stratum.Stratum_CN == st.Stratum_CN) { cancel = true; return; }
if (tree.Stratum != null)
{
if (!this.ViewController.AskYesNo("You are changing the stratum of a tree, are you sure you want to do this?", "!", MessageBoxIcon.Asterisk))
{
cancel = true;//do not change stratum
}
else
{
//log stratum changed
this.Database.LogMessage(String.Format("Tree Stratum Changed (Cu:{0} St:{1} -> {2} Sg:{3} Tdv_CN:{4} T#: {5} P#:{6}",
tree.CuttingUnit.Code,
tree.Stratum.Code,
st.Code,
(tree.SampleGroup != null) ? tree.SampleGroup.Code : "?",
(tree.TreeDefaultValue != null) ? tree.TreeDefaultValue.TreeDefaultValue_CN.ToString() : "?",
tree.TreeNumber,
(tree.Plot != null) ? tree.Plot.PlotNumber.ToString() : "-"), "I");
}
}
cancel = false;
}
//---------------------------------------------------------------------------------------------------------
private int getSampleGroupStats(StratumDO currentStratum, StratumStatsDO currentStratumStats, float totalAcres)
{
int n1, n2, measTrees, sumKpi, talliedTrees, freq, kz, insTrees;
double st1x, st1x2, st2x, st2x2, cv1, cv2, sampErr, sumNetVol;
float treesPerAcre;
double comberr2 = 0;
double totalVolume = 0;
// for each sample group
sampleGroups = new List<SampleGroupDO>(cdDAL.Read<SampleGroupDO>("SampleGroup", "Where Stratum_CN = ?", currentStratum.Stratum_CN));
foreach (SampleGroupDO sg in sampleGroups)
{
// create samplegroupstats
currentSgStats = new SampleGroupStatsDO(cdDAL);
//set foriegn key
currentSgStats.StratumStats = currentStratumStats;
currentSgStats.SgSet = 1;
currentSgStats.Code = sg.Code;
currentSgStats.CutLeave = sg.CutLeave;
currentSgStats.UOM = sg.UOM;
currentSgStats.PrimaryProduct = sg.PrimaryProduct;
currentSgStats.SecondaryProduct = sg.SecondaryProduct;
currentSgStats.DefaultLiveDead = sg.DefaultLiveDead;
currentSgStats.Description = sg.Description;
// get POP data
selectedPOP = cdDAL.ReadSingleRow<POPDO>("POP", "WHERE Stratum = ? AND SampleGroup = ?", currentStratum.Code, sg.Code);
// calculate statistics (based on method)
if (selectedPOP == null)
{
MessageBox.Show("Cruise Not Processed. Please Process Cruise Before Continuing.", "Warning");
return(-1);
}
n1 = Convert.ToInt32(selectedPOP.StageOneSamples);
n2 = Convert.ToInt32(selectedPOP.StageTwoSamples);
measTrees = Convert.ToInt32(selectedPOP.MeasuredTrees);
talliedTrees = Convert.ToInt32(selectedPOP.TalliedTrees);
sumKpi = Convert.ToInt32(selectedPOP.SumKPI);
st1x = selectedPOP.Stg1NetXPP;
st1x2 = selectedPOP.Stg1NetXsqrdPP;
st2x = selectedPOP.Stg2NetXPP;
st2x2 = selectedPOP.Stg2NetXsqrdPP;
// trees per plot
// find CVs
cv1 = statClass.getCV(st1x, st1x2, n1);
if (stage == 12 || stage == 22)
cv2 = statClass.getCV(st2x, st2x2, n2);
else
cv2 = 0;
// find errors stage 11=tree,single 12=tree,2 stage 21=plot,single 22=plot,2 stage
if (stage == 11 || stage == 21)
sampErr = statClass.getSampleError(cv1, n1, 0);
else if (stage == 12 || stage == 22)
sampErr = statClass.getTwoStageError(cv1, cv2, n1, n2);
else
sampErr = 0;
currentSgStats.CV1 = Convert.ToSingle(cv1);
currentSgStats.CV2 = Convert.ToSingle(cv2);
currentSgStats.SampleSize1 = n1;
currentSgStats.SampleSize2 = n2;
if (stage == 11 || stage == 10)
{
currentSgStats.ReconTrees = n1;
currentSgStats.ReconPlots = 0;
}
else if (stage == 12)
{
currentSgStats.ReconPlots = n1;
currentSgStats.ReconTrees = n2;
}
else if (stage == 21 || stage == 22)
{
currentSgStats.ReconTrees = measTrees;
currentSgStats.ReconPlots = n1;
}
// calculate frequency
currentSgStats.SgError = Convert.ToSingle(sampErr);
// get LCD data
selectedLCD = cdDAL.Read<LCDDO>("LCD", "WHERE Stratum = ? AND SampleGroup = ?", currentStratum.Code, sg.Code);
sumExpFac = 0;
sumNetVol = 0;
//foreach (SampleGroupDO sg in Owner.histSampleGroup)
foreach (LCDDO lcd in selectedLCD)
{
// sum volume
double expFac = lcd.SumExpanFactor;
sumExpFac += expFac;
// sum trees
double netVol = lcd.SumNCUFT;
sumNetVol += netVol;
}
comberr2 += (sampErr * sumNetVol) * (sampErr * sumNetVol);
totalVolume += sumNetVol;
// find volume/acre and trees/acre
if (stage < 20)
{
treesPerAcre = Convert.ToSingle(Math.Round((sumExpFac / totalAcres), 2));
currentSgStats.TreesPerAcre = treesPerAcre;
currentSgStats.VolumePerAcre = Convert.ToSingle(Math.Round((sumNetVol / totalAcres), 2));
}
else
{
treesPerAcre = Convert.ToSingle(Math.Round((sumExpFac), 2));
currentSgStats.TreesPerAcre = treesPerAcre;
currentSgStats.VolumePerAcre = Convert.ToSingle(Math.Round((sumNetVol), 2));
if (stage == 21)
currentSgStats.TreesPerPlot = Convert.ToSingle(Math.Round((Convert.ToSingle((float)measTrees / (float)n1)), 1));
else
currentSgStats.TreesPerPlot = Convert.ToSingle(Math.Round((Convert.ToSingle((float)talliedTrees / (float)n1)), 1));
}
currentSgStats.TPA_Def = (long)(treesPerAcre * totalAcres);
// find frequency/KZ/BigBAF values
if ((stage == 11 || stage == 12 || stage == 22) && measTrees > 0)
{
freq = Convert.ToInt32((talliedTrees / measTrees));
kz = Convert.ToInt32((sumKpi / measTrees));
if (currentStratum.Method == "S3P")
{
currentSgStats.SamplingFrequency = Convert.ToInt32((talliedTrees / n1));
currentSgStats.KZ = kz;
}
else
{
currentSgStats.SamplingFrequency = freq;
currentSgStats.KZ = kz;
}
}
// find insurance trees
if (stage == 11 || stage == 12)
insTrees = getInsuranceTrees(sg);
else
insTrees = 0;
currentSgStats.InsuranceFrequency = insTrees;
// save samplegroupstats row
currentSgStats.Save();
// loop through TDV information
sg.TreeDefaultValues.Populate();
foreach (TreeDefaultValueDO tdv in sg.TreeDefaultValues)
{
currentSgStats.TreeDefaultValueStats.Add(tdv);
}
currentSgStats.Save();
currentSgStats.TreeDefaultValueStats.Save();
}
return (0);
}
public static bool ValidateSetup(SampleGroupDO sg, StratumDO st, out string error)
{
bool isValid = true;
error = null;
sg.Validate();
string pre = "Stratum: " + st.Code + " IN SG: " + sg.Code + " -";
if (sg.HasErrors())
{
isValid = false;
error += pre + sg.Error;
}
if (String.IsNullOrEmpty(sg.Code))
{
isValid = false;
error += pre + " Code can't be empty";
}
if (sg.TreeDefaultValues.Count == 0)
{
isValid = false;
error += pre + " No Tree Defaults Selected";
}
isValid = sg.ValidatePProdOnTDVs(ref error) && isValid;
return isValid;
}
public SampleGroupDO GetNewSampleGroup(StratumDO stratum, SampleGroupDO newSampleGroup)
{
if (newSampleGroup == null)
{
newSampleGroup = new SampleGroupDO(this._database);
}
newSampleGroup.CutLeave = "C";
newSampleGroup.DefaultLiveDead = "L";
newSampleGroup.Code = "<Blank>";
newSampleGroup.Stratum = stratum;
if (stratum.Method == CruiseDAL.Schema.CruiseMethods.FIXCNT)
{
newSampleGroup.UOM = "03";
}
else
{
newSampleGroup.UOM = Sale.DefaultUOM;
}
return newSampleGroup;
}
private void _strataCB_SelectedIndexChanged(object sender, EventArgs e)
{
this.Stratum = this._strataCB.SelectedItem as StType;
}
public void ShowSampleGroups(StratumDO stratum)
{
string errorMsg;
if (AreStrataValid(out errorMsg) == false)
{
MessageBox.Show(errorMsg, "Warning", MessageBoxButtons.OK);
return;
}
try
{
this.SaveStrata(false);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return;
}
this.WaitCopyTemplateDone();
View.Display("SampleGroups");
//if (stratum != null)
//{
// View.sampleGroupPage.CurrentStratum = stratum;
//}
}
public bool HandleStratumChanging(StratumDO newStratum, IView view)
{
if (newStratum == null) { return false; }
if (Stratum != null
&& Stratum.Stratum_CN == newStratum.Stratum_CN)
{ return false; }
if (Stratum != null)
{
if (!view.AskYesNo("You are changing the stratum of a tree" +
", are you sure you want to do this?"
, "!", System.Windows.Forms.MessageBoxIcon.Asterisk))
{
return false;//do not change stratum
}
else
{
//log stratum changed
DAL.LogMessage(String.Format("Tree Stratum Changed (Cu:{0} St:{1} -> {2} Sg:{3} Tdv_CN:{4} T#: {5} P#:{6}"
, CuttingUnit.Code
, Stratum.Code
, newStratum.Code
, (SampleGroup != null) ? SampleGroup.Code : "?"
, (TreeDefaultValue != null) ? TreeDefaultValue.TreeDefaultValue_CN.ToString() : "?"
, TreeNumber
, (Plot != null) ? Plot.PlotNumber.ToString() : "-"), "I");
return true;
}
}
else
{
return true;
}
}
public List<LogFieldSetupDO> GetSelectedLogFields(StratumDO stratum)
{
return this.Database.Read<LogFieldSetupDO>("LogFieldSetup", "WHERE Stratum_CN = ? ORDER BY FieldOrder", stratum.Stratum_CN);
}
public void SetValues(StratumDO obj)
{
if(obj == null) { return; }
Code = obj.Code;
Description = obj.Description;
Method = obj.Method;
BasalAreaFactor = obj.BasalAreaFactor;
FixedPlotSize = obj.FixedPlotSize;
KZ3PPNT = obj.KZ3PPNT;
Hotkey = obj.Hotkey;
FBSCode = obj.FBSCode;
YieldComponent = obj.YieldComponent;
Month = obj.Month;
Year = obj.Year;
}
public void ReadTreesTest()
{
IWindowPresenter wp = new WindowPresenterStub() { Database = new CruiseDAL.DAL(readTestFile) };
PrivateObject param0 = new PrivateObject(new DataEditorView(wp));
DataEditorView_Accessor target = new DataEditorView_Accessor(param0);
CuttingUnitDO cu = new CuttingUnitDO() { rowID = 1 };
StratumDO st = new StratumDO() { rowID = 1 };
SampleGroupDO sg = new SampleGroupDO() { rowID = 1 };
TreeDefaultValueDO tdv = new TreeDefaultValueDO() { rowID = 1 };
List<TreeVM> actual;
actual = target.ReadTrees(cu, st, sg, tdv);
Assert.IsNotNull(actual);
Assert.IsTrue(actual.Count > 0);
}
protected List<TreeFieldSetupDO> GetSelectedTreeFieldsDefault(StratumDO stratum)
{
//select from TreeFieldSetupDefault where method = stratum.method
List<TreeFieldSetupDefaultDO> treeFieldDefaults = this.Database.Read<TreeFieldSetupDefaultDO>("TreeFieldSetupDefault", "WHERE Method = ? ORDER BY FieldOrder", stratum.Method);
List<TreeFieldSetupDO> treeFields = new List<TreeFieldSetupDO>();
foreach (TreeFieldSetupDefaultDO tfd in treeFieldDefaults)
{
TreeFieldSetupDO tfs = new TreeFieldSetupDO();
tfs.Stratum_CN = stratum.Stratum_CN;
tfs.Field = tfd.Field;
tfs.FieldOrder = tfd.FieldOrder;
tfs.ColumnType = tfd.ColumnType;
tfs.Heading = tfd.Heading;
tfs.Width = tfd.Width;
tfs.Format = tfd.Format;
tfs.Behavior = tfd.Behavior;
treeFields.Add(tfs);
}
return treeFields;
}
public void ReadLogsTest()
{
IWindowPresenter wp = new WindowPresenterStub() { Database = new CruiseDAL.DAL(readTestFile) };
PrivateObject param0 = new PrivateObject(new DataEditorView(wp));
DataEditorView_Accessor target = new DataEditorView_Accessor(param0);
CuttingUnitDO cu = new CuttingUnitDO() { rowID = 1 };
StratumDO st = new StratumDO() { rowID = 1 };
SampleGroupDO sg = new SampleGroupDO() { rowID = 1 };
TreeDefaultValueDO tdv = new TreeDefaultValueDO() { rowID = 1 };
List<LogVM> actual;
actual = target.ReadLogs(cu, st, sg, tdv);
Assert.Inconclusive("Verify the correctness of this test method.");
}
private bool checkNestedPlots(StratumDO myRSt)
{
int nestNum = 0;
string myMeth = "";
float myBAF = 0;
float myFIX = 0;
//loop through each unit
myRSt.CuttingUnits.Populate();
foreach (CuttingUnitDO rcu in myRSt.CuttingUnits)
{
rcu.Strata.Populate();
if (rcu.Strata.Count() > 1)
{
// check for different method/plot sizes
foreach (StratumDO mySt in rcu.Strata)
{
if (nestNum == 0)
{
myMeth = mySt.Method;
myBAF = mySt.BasalAreaFactor;
myFIX = mySt.FixedPlotSize;
nestNum++;
}
else
{
if (myMeth != mySt.Method)
return (true);
float diff = myBAF - mySt.BasalAreaFactor;
if (diff > 1 || diff < -1)
return (true);
diff = myFIX - mySt.FixedPlotSize;
if (diff > 1 || diff < -1)
return (true);
}
}
}
}
return (false);
}
public void DeleteStratum(StratumDO st)
{
if (st.IsPersisted)
{
StratumDO.RecursiveDeleteStratum(st);
}
}
private void _strataCB_SelectedIndexChanged(object sender, EventArgs e)
{
this.Stratum = this._strataCB.SelectedItem as StType;
}
public DesignEditorStratum(CruiseDAL.DataObjects.StratumDO st) : base(st)
{
}