public void SetValues(TallyDO obj)
{
if(obj == null) { return; }
Hotkey = obj.Hotkey;
Description = obj.Description;
IndicatorValue = obj.IndicatorValue;
IndicatorType = obj.IndicatorType;
}
public TallyDO(TallyDO obj) : this()
{
SetValues(obj);
}
public void PullNewTallyTable(ComponentFileVM comp)
{
StartJob("Add New CountTree Records");
List<TallyDO> compTallies = comp.Database.Read<TallyDO>("Tally", null);
foreach (TallyDO tally in compTallies)
{
CheckWorkerStatus();
TallyDO match = Master.ReadSingleRow<TallyDO>("Tally", "WHERE HotKey = ? AND Description = ?",
tally.Hotkey, tally.Description);
if (match == null)
{
match = new TallyDO(Master);
match.Hotkey = tally.Hotkey;
match.Description = tally.Description;
match.Save();
}
}
}
public DialogResult ShowDialog(SGType sg)
{
this.SampleGroup = sg;
this._sgInfo_LBL.Text = this.SampleGroup.Code + "-" + this.SampleGroup.TallyMethod.ToString();
if ((sg.TallyMethod & CruiseDAL.Enums.TallyMode.BySampleGroup) == CruiseDAL.Enums.TallyMode.BySampleGroup)
{
this._species_LBL.Visible = false;
this._speciesSelect_CB.Visible = false;
TallyDO t = this.Controller._cDal.From<TallyDO>()
.Join("CountTree", "USING (Tally_CN)")
.Where("SampleGroup_CN = ?")
.Read(sg.SampleGroup_CN).FirstOrDefault();
if (t == null)
{
t = new TallyDO(this.Controller._cDal);
t.Description = sg.Code;
}
this.Tally = t;
}
else if ((sg.TallyMethod & CruiseDAL.Enums.TallyMode.BySpecies) == CruiseDAL.Enums.TallyMode.BySpecies)
{
this._species_LBL.Visible = true;
this._speciesSelect_CB.Visible = true;
this._speciesSelect_CB.DisplayMember = "Species";
this._speciesSelect_CB.ValueMember = "Tag";
foreach (TreeDefaultValueDO tdv in sg.TreeDefaultValues)
{
TallyDO t = this.Controller._cDal.From<TallyDO>()
.Join("CountTree", "USING (Tally_CN)")
.Where("SampleGroup_CN = ? and TreeDefaultValue_CN = ?")
.Read(sg.SampleGroup_CN, tdv.TreeDefaultValue_CN).FirstOrDefault();
if (t == null)
{
t = new TallyDO(this.Controller._cDal);
t.Description = tdv.Species;
}
tdv.Tag = t;
}
this._speciesSelect_CB.DataSource = sg.TreeDefaultValues;
}
else
{
}
return this.ShowDialog();
}
private void _speciesSelect_CB_SelectedValueChanged(object sender, EventArgs e)
{
TallyDO tally = _speciesSelect_CB.SelectedValue as TallyDO;
if (tally == null) { return; }
this.Tally = tally;
}
protected override void OnClosing(CancelEventArgs e)
{
base.OnClosing(e);
if (this.DialogResult == DialogResult.Cancel)
{
return;
}
else if (this.DialogResult == DialogResult.OK)
{
this._BS_Tally.EndEdit();
try
{
Cursor.Current = Cursors.WaitCursor;
this.Controller._cDal.BeginTransaction();
if ((this.SampleGroup.TallyMethod & CruiseDAL.Enums.TallyMode.BySampleGroup) == CruiseDAL.Enums.TallyMode.BySampleGroup)
{
if (this.Tally.IsPersisted == false)
{
TallyDO t = this.Controller._cDal.From<TallyDO>()
.Where("Description = ? and Hotkey = ?")
.Read(this.Tally.Description
, this.Tally.Hotkey).FirstOrDefault();
if (t != null) { this.Tally = t; }
else
{
this.Tally.Save();
}
}
string createCountsCommand = String.Format(@"INSERT OR IGNORE INTO CountTree (CuttingUnit_CN, SampleGroup_CN, CreatedBy)
Select CuttingUnitStratum.CuttingUnit_CN, SampleGroup.SampleGroup_CN, '{0}' AS CreatedBy
From SampleGroup
INNER JOIN CuttingUnitStratum
ON SampleGroup.Stratum_CN = CuttingUnitStratum.Stratum_CN
WHERE SampleGroup.SampleGroup_CN = {1};", this.Controller._cDal.User, this.SampleGroup.SampleGroup_CN);
this.Controller._cDal.Execute(createCountsCommand);
string setTallyRefCommand = String.Format("UPDATE CountTree SET Tally_CN = {0} WHERE SampleGroup_CN = {1} AND ifnull(TreeDefaultValue_CN, 0) = 0",
this.Tally.Tally_CN, this.SampleGroup.SampleGroup_CN);
this.Controller._cDal.Execute(setTallyRefCommand);
}
else if ((this.SampleGroup.TallyMethod & CruiseDAL.Enums.TallyMode.BySpecies) == CruiseDAL.Enums.TallyMode.BySpecies)
{
string creatCountsBySpeciesCommand = String.Format(@"INSERT OR IGNORE INTO CountTree (CuttingUnit_CN, SampleGroup_CN, TreeDefaultValue_CN, CreatedBy)
Select CuttingUnitStratum.CuttingUnit_CN, SampleGroup.SampleGroup_CN, SampleGroupTreeDefaultValue.TreeDefaultValue_CN, '{0}' AS CreatedBy
From SampleGroup
INNER JOIN CuttingUnitStratum
ON SampleGroup.Stratum_CN = CuttingUnitStratum.Stratum_CN
INNER JOIN SampleGroupTreeDefaultValue
ON SampleGroupTreeDefaultValue.SampleGroup_CN = SampleGroup.SampleGroup_CN
WHERE SampleGroup.SampleGroup_CN = {1};", this.Controller._cDal.User, this.SampleGroup.SampleGroup_CN);
this.Controller._cDal.Execute(creatCountsBySpeciesCommand);
foreach (TreeDefaultValueDO tdv in this.SampleGroup.TreeDefaultValues)
{
TallyDO tally = tdv.Tag as TallyDO;
if (tally == null)
{
e.Cancel = true;
return;
}
if (tally.IsPersisted == false)
{
TallyDO t = this.Controller._cDal.From<TallyDO>()
.Where("Description = ? and Hotkey = ?")
.Read(tally.Description, tally.Hotkey).FirstOrDefault();
if (t != null) { tally = t; }
else
{
tally.Save();
}
}
string setTallyRefCommand = String.Format("UPDATE CountTree SET Tally_CN = {0} WHERE SampleGroup_CN = {1} AND TreeDefaultValue_CN = {2}",
tally.Tally_CN, this.SampleGroup.SampleGroup_CN, tdv.TreeDefaultValue_CN);
this.Controller._cDal.Execute(setTallyRefCommand);
}
}
this.Controller._cDal.CommitTransaction();
}
catch (Exception ex)
{
this.Controller._cDal.RollbackTransaction();
this.Controller.HandleNonCriticalException(ex, "Some thing went wrong while saving");
}
finally
{
Cursor.Current = Cursors.Default;
}
}
}