public SaleDO(SaleDO obj) : this()
{
SetValues(obj);
}
private void checkSalePurpose()
{
mySale = new SaleDO(cdDAL.ReadSingleRow<SaleDO>("Sale", null, null));
// mySale = cdDAL.ReadSingleRow<SaleDO>("Sale", null, null);
sUOM = mySale.DefaultUOM;
String remark = mySale.Remarks;
if (remark == "Historical Design")
reconExists = false;
}
private void InitializeDatabaseTables()
{
// cdStratum = new List<StratumDO>(cdDAL.Read<StratumDO>("Stratum", null, null));
cdStratumStats = new BindingList<StratumStatsDO>(cdDAL.Read<StratumStatsDO>("StratumStats", "JOIN Stratum ON StratumStats.Stratum_CN = Stratum.Stratum_CN AND StratumStats.Method = Stratum.Method AND StratumStats.Used = 1 ORDER BY Stratum.Code", null));
mySale = cdDAL.ReadSingleRow<SaleDO>("Sale", null, null);
myGlobals = cdDAL.Read<GlobalsDO>("Globals", "WHERE Block = ?", "CruiseDesign");
}
public void SetValues(SaleDO obj)
{
if(obj == null) { return; }
SaleNumber = obj.SaleNumber;
Name = obj.Name;
Purpose = obj.Purpose;
Region = obj.Region;
Forest = obj.Forest;
District = obj.District;
MeasurementYear = obj.MeasurementYear;
CalendarYear = obj.CalendarYear;
LogGradingEnabled = obj.LogGradingEnabled;
Remarks = obj.Remarks;
DefaultUOM = obj.DefaultUOM;
}
public void GoToHistPage()
{
// If from UnitPage - get new currentStratumStats
currentStratumStats = (cdDAL.ReadSingleRow<StratumStatsDO>("StratumStats", "WHERE Stratum_CN = ? AND SgSet = 1", currentStratum.Stratum_CN));
if (currentStratumStats != null)
{
// data already exists for stratum, delete stratum and continue?
MessageBox.Show("Stratum data already exists for this stratum","Information");
return;
}
currentStratumStats = new StratumStatsDO(cdDAL);
currentStratumStats.Stratum = currentStratum;
currentStratumStats.Code = currentStratum.Code;
currentStratumStats.Description = currentStratum.Description;
currentStratumStats.SgSet = 1;
currentStratumStats.SgSetDescription = "";
float totalAcres = 0;
foreach (CuttingUnitDO cu in currentStratum.CuttingUnits)
{
float acres = cu.Area;
totalAcres += acres;
}
currentStratumStats.TotalAcres = totalAcres;
// Owner.currentStratumStats.Save();
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
histFile = openFileDialog1.FileName;
//set title bar with file name
histPage.textBoxFile.Text = openFileDialog1.SafeFileName;
//open new cruise DAL
if (histFile.Length > 0)
{
try
{
hDAL = new DAL(histFile);
}
catch (System.IO.IOException ie)
{
Logger.Log.E(ie);
}
catch (System.Exception ie)
{
Logger.Log.E(ie);
}
}
else
{
return;
}
Sale = new SaleDO(hDAL.ReadSingleRow<SaleDO>("Sale", null, null));
string sUOM = Sale.DefaultUOM;
if (sUOM != UOM)
{
MessageBox.Show("Cruise does not have same UOM.\nCannot import data.", "Warning");
return;
}
//set binding list for stratum
histStratum = new BindingList<StratumDO>(hDAL.Read<StratumDO>("Stratum", null, null));
histPage.bindingSourceStratum.DataSource = histStratum;
pageHost2.Display(histPage);
}
}
//cancels the cruise wizard diolog and discards all resorurces
private void setSalePurpose()
{
SaleDO sale = new SaleDO (cdDAL.ReadSingleRow<SaleDO>("Sale", null, null));
if (sale.DefaultUOM == null)
UOM = "03";
else
UOM = sale.DefaultUOM.ToString();
}
private void copySaleTable(DAL cDAL)
{
//mySale = new List<SaleDO>();
//open sale table
SaleDO sale = new SaleDO(cDAL.ReadSingleRow<SaleDO>("Sale", null, null));
SaleDO fsSale = new SaleDO(fsDAL);
fsSale.Purpose = "Timber Sale";
fsSale.SaleNumber = sale.SaleNumber;
fsSale.Name = sale.Name;
fsSale.Region = sale.Region;
fsSale.Forest = sale.Forest;
fsSale.District = sale.District;
fsSale.DefaultUOM = sale.DefaultUOM;
fsSale.CalendarYear = sale.CalendarYear;
fsSale.LogGradingEnabled = sale.LogGradingEnabled;
fsSale.MeasurementYear = sale.MeasurementYear;
fsSale.Remarks = sale.Remarks;
fsSale.Save();
logData = sale.LogGradingEnabled;
myMeth = new List<CruiseMethodsDO>(fsDAL.Read<CruiseMethodsDO>("CruiseMethods",null,null));
if (myMeth.Count() < 4)
{
myMeth.Clear();
for (int i = 0; i < 12; i++)
{
CruiseMethodsDO fsMeth = new CruiseMethodsDO(fsDAL);
addCruiseMethod(fsMeth, i);
myMeth.Add(fsMeth);
}
fsDAL.Save(myMeth);
}
}
private void copySaleData(dataFiles df)
{
SaleDO sale = new SaleDO(df.cdDAL);
sale.SaleNumber = df.SaleNumber;
sale.Name = df.Name;
sale.Purpose = df.Purpose;
sale.Region = df.Regnum;
sale.Forest = df.Forest;
sale.District = df.District;
sale.DefaultUOM = df.DefaultUOM;
sale.Remarks = "Historical Design";
sale.LogGradingEnabled = df.LogEnabled;
sale.Save();
}
public void UpdateSale(SaleDO obj)
{
salePage.SaleDOBindingSource.DataSource = obj;
}
private bool ShowWizardDialog(DAL database, out SaleDO sale)
{
CruiseWizardView view = new CruiseWizardView();
CruiseWizardPresenter p = new CruiseWizardPresenter(view, this, this.ApplicationController, database);
DialogResult result = view.ShowDialog((IWin32Window)this.ApplicationController.MainWindow);
sale = p.Sale;
if (result == DialogResult.OK)
{
return true;
}
else
{
return false;
}
}
protected String AskSavePath(SaleDO sale)
{
bool createSaleFolder = false;
if (ApplicationController.UserSettings.CreateSaleFolder == null)
{
using (var dialog = new CreateSaleFolerDialog())
{
createSaleFolder = (dialog.ShowDialog() == DialogResult.Yes);
if (dialog.RememberSelection)
{
ApplicationController.UserSettings.CreateSaleFolder = createSaleFolder;
//ApplicationState.GetHandle().Save();
}
}
}
else
{
createSaleFolder = ApplicationController.UserSettings.CreateSaleFolder.Value;
}
using (var saveFileDialog = new System.Windows.Forms.SaveFileDialog())
{
saveFileDialog.AutoUpgradeEnabled = true;
saveFileDialog.CustomPlaces.Add(System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + @"\CruiseFiles");
saveFileDialog.InitialDirectory = ApplicationController.UserSettings.CruiseSaveLocation;
saveFileDialog.DefaultExt = "cruise";
saveFileDialog.Filter = "Cruise files(*.cruise)|*.cruise";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
string fileName = saveFileDialog.FileName;
string dir = System.IO.Path.GetDirectoryName(fileName);
ApplicationController.UserSettings.CruiseSaveLocation = dir;
if (createSaleFolder)
{
dir += sale.ToString("\\[SaleNumber] [Name]\\", null);
if (!System.IO.Directory.Exists(dir))
{
System.IO.Directory.CreateDirectory(dir);
}
return dir + System.IO.Path.GetFileName(saveFileDialog.FileName);
}
return saveFileDialog.FileName;
}
return null;
}
}
public void getPopulations()
{
//MessageBox.Show("getPopulations");
mySale = new SaleDO(cdDAL.ReadSingleRow<SaleDO>("Sale", null, null));
if (reconExists)
{
// check for TreeDefaultValues - processed cruise
//List<TreeCalculatedValuesDO> chkValues = new List<TreeCalculatedValuesDO>(rDAL.Read<TreeCalculatedValuesDO>("TreeCalculatedValues", null, null));
rTreeCalcJoin = new List<TreeCalculatedValuesDO>(rDAL.Read<TreeCalculatedValuesDO>("TreeCalculatedValues", "JOIN Tree T JOIN SampleGroup G WHERE TreeCalculatedValues.Tree_CN = T.Tree_CN AND T.SampleGroup_CN = G.SampleGroup_CN", null));
if (rTreeCalcJoin.Count() <= 0)
{
errFlag = 1;
getDefaultData();
// default values calc
return;
}
}
else
{
getDefaultData();
return;
}
//get recon tree calculated list
myPlots = new List<PlotDO>(rDAL.Read<PlotDO>("Plot", null, null));
// get stratum definitions
stratum = new List<StratumDO>(cdDAL.Read<StratumDO>("Stratum", null, null));
// loop through stratum
foreach (StratumDO curStr in stratum)
{
// check if Stratum needs to be re-calculated (if method = 100, then it needs to be recalculated)
strStats = (cdDAL.ReadSingleRow<StratumStatsDO>("StratumStats", "WHERE Stratum_CN = ? AND SgSet = 1 AND Method = ?", curStr.Stratum_CN, "100"));
if (curStr.Method == "100" && strStats.Used == 2)
{
curStr.CuttingUnits.Populate();
// get total strata acres
removePopulations(curStr.Stratum_CN);
totalAcres = 0;
foreach (CuttingUnitDO cu in curStr.CuttingUnits)
{
float acres = cu.Area;
totalAcres += acres;
}
selectStratumStats = new List<StratumStatsDO>(cdDAL.Read<StratumStatsDO>("StratumStats", "WHERE Stratum_CN = ?", curStr.Stratum_CN));
// loop by stratumstats for multiple SgSets
foreach (StratumStatsDO curStrStats in selectStratumStats)
{
useDefaultFix = false;
useDefaultTree = false;
useDefaultPnt = false;
curPlotFixSize = 0;
curPlotPntSize = 0;
// add methods to the StratumStats table (FIX,FCM,F3P,STR,3P,S3P,PNT,P3P,PCM,3PPNT)
//setupPopulations(curStrStats.Stratum_CN, curStrStats.Code, curStrStats.Description, curStrStats.SgSet, curStrStats.SgSetDescription, curStrStats.TotalAcres);
selectSgStats = new List<SampleGroupStatsDO>(cdDAL.Read<SampleGroupStatsDO>("SampleGroupStats", "Where StratumStats_CN = ?", curStrStats.StratumStats_CN));
// loop through sample groups
foreach (SampleGroupStatsDO curSgStats in selectSgStats)
{
//Get all statistics from FIX plots **************
sgPlotSize = 0;
//find data from Recon file
int iReturn = getSgReconData(curStrStats, curSgStats, "FIX");
if (iReturn > 0)
{
useDefaultFix = true;
useDefaultTree = true;
}
if (curPlotFixSize == 0) curPlotFixSize = sgPlotSize;
// check plot sizes are not different across sample groups
if (curPlotFixSize != sgPlotSize)
{
// plot sizes are different across sample groups, cannot calculate Fix statistics
useDefaultFix = true;
}
// calc Fixed
getFixSgStats(curStrStats, curSgStats, useDefaultFix);
//Get all statistics from PNT plots **************
curPlotFixSize = 0;
sgPlotSize = 0;
//find data from Recon file
iReturn = getSgReconData(curStrStats, curSgStats, "PNT");
if (iReturn > 0)
{
useDefaultPnt = true;
}
if (curPlotPntSize == 0) curPlotPntSize = sgPlotSize;
// check plot sizes are not different across sample groups
if (curPlotPntSize != sgPlotSize)
{
// plot sizes are different across sample groups, cannot calculate Fix statistics
useDefaultPnt = true;
}
getPntSgStats(curStrStats, curSgStats, useDefaultPnt);
}
}
//calculate StratumStats from the SampleGroupStats
getStratumStats(curStr.Stratum_CN);
}
else
{
// selectStratumStats = new List<StratumStatsDO>(cdDAL.Read<StratumStatsDO>("StratumStats", "WHERE Stratum_CN = ?", curStr.Stratum_CN));
// check for historical data
// foreach (StratumStatsDO curStrStats in selectStratumStats)
// {
// check for error equal to zero
// if (curStrStats.StrError == 0)
// {
// selectSgStats = new List<SampleGroupStatsDO>(cdDAL.Read<SampleGroupStatsDO>("SampleGroupStats", "Where StratumStats_CN = ?", curStrStats.StratumStats_CN));
// loop through sample groups
// foreach (SampleGroupStatsDO curSgStats in selectSgStats)
// {
// getDefaultStats(curStrStats, curSgStats);
// }
// getStratumStats(curStr.Stratum_CN);
// }
//}
}
}
}
public SaleVM(SaleDO sale)
: base(sale)
{
}
