public static object GetTreeTDVList(this DAL database, TreeVM tree)
{
if (tree == null) { return EMPTY_SPECIES_LIST; }
if (tree.Stratum == null)
{
if (database.GetRowCount("CuttingUnitStratum", "WHERE CuttingUnit_CN = ?", tree.CuttingUnit_CN) == 1)
{
tree.Stratum = database.From<StratumVM>()
.Join("CuttingUnitStratum", "USING (Stratum_CN)").Where("CuttingUnit_CN = ?")
.Read(tree.CuttingUnit_CN).FirstOrDefault();
}
else
{
return EMPTY_SPECIES_LIST;
}
}
if (tree.SampleGroup == null)
{
if (database.GetRowCount("SampleGroup", "WHERE Stratum_CN = ?", tree.Stratum_CN) == 1)
{
tree.SampleGroup = database.From<SampleGroupDO>()
.Where("Stratum_CN = ?").Read(tree.Stratum_CN).FirstOrDefault();
}
if (tree.SampleGroup == null)
{
return EMPTY_SPECIES_LIST;
}
}
return database.From<TreeDefaultValueDO>()
.Join("SampleGroupTreeDefaultValue", "USING (TreeDefaultValue_CN)")
.Where("SampleGroup_CN = ?").Read(tree.SampleGroup_CN).ToArray();
}
public static void SetTreeTDV(TreeVM tree, TreeDefaultValueDO tdv)
{
tree.TreeDefaultValue = tdv;
if (tdv != null)
{
tree.Species = tdv.Species;
tree.LiveDead = tdv.LiveDead;
tree.Grade = tdv.TreeGrade;
tree.FormClass = tdv.FormClass;
tree.RecoverablePrimary = tdv.Recoverable;
//tree.HiddenPrimary = tdv.HiddenPrimary; //#367
}
else
{
//tree.Species = string.Empty;
//tree.LiveDead = string.Empty;
//tree.Grade = string.Empty;
//tree.FormClass = 0;
//tree.RecoverablePrimary = 0;
//tree.HiddenPrimary = 0;
}
}
protected void UpdateSpeciesColumn(TreeVM tree, DataGridViewComboBoxCell cell)
{
if (cell == null) { return; }
cell.DataSource = ApplicationController.Database.GetTreeTDVList(tree);
}
//private void TreeDataGridView_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e)
//{
// var tree = e.Row.DataBoundItem as TreeVM;
// if (tree == null) { e.Cancel = true; return; }
// e.Cancel = !this.TryDeleteTree(tree);
//}
protected void UpdateSampleGroupColumn(TreeVM tree, DataGridViewComboBoxCell cell)
{
if (cell == null) { return; }
cell.DataSource = ApplicationController.Database.GetSampleGroupsByStratum(tree.Stratum_CN);
}
protected bool TrySaveTree(TreeVM tree)
{
try
{
tree.Save();
return true;
}
catch (Exception e)
{
MessageBox.Show("Unable to save tree. Ensure Tree Number, Sample Group and Stratum are valid");
//this.HandleNonCriticalException(e, "Unable to save tree. Ensure Tree Number, Sample Group and Stratum are valid");
return false;
}
}
protected bool TryDeleteTree(TreeVM tree)
{
try
{
tree.Delete();
return true;
}
catch
{
return false;
}
}