private void copyTablesToDesign(dataFiles df)
{
// copy Sale table
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.SALE._NAME, null, OnConflictOption.Ignore);
//copy CuttingUnit table
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.CUTTINGUNIT._NAME, null, OnConflictOption.Ignore);
//copy TreeDefaultValues table
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.TREEDEFAULTVALUE._NAME, null, OnConflictOption.Ignore);
//copy globals table
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.GLOBALS._NAME, null, OnConflictOption.Ignore);
//copy logfieldsetupdefault
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.LOGFIELDSETUPDEFAULT._NAME, null, OnConflictOption.Ignore);
//copy messagelog
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.MESSAGELOG._NAME, null, OnConflictOption.Ignore);
//copy reports
df.cdDAL.DirectCopy(rDAL, "Reports", null, OnConflictOption.Ignore);
//copy treefieldsetupdefault
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.TREEFIELDSETUPDEFAULT._NAME, null, OnConflictOption.Ignore);
//copy volumeequations
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.VOLUMEEQUATION._NAME, null, OnConflictOption.Ignore);
//copy treeauditvalue
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.TREEAUDITVALUE._NAME, null, OnConflictOption.Ignore);
//copy treedefaultvaluetreeauditvalue
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.TREEDEFAULTVALUETREEAUDITVALUE._NAME, null, OnConflictOption.Ignore);
//copy tally
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.TALLY._NAME, null, OnConflictOption.Ignore);
}
private void createNewDatabase(dataFiles df)
{
try
{
df.tmpDAL = new DAL(df.tpFile);
}
catch (System.IO.IOException ie)
{
Logger.Log.E(ie);
}
catch (System.Exception ie)
{
Logger.Log.E(ie);
}
copyTemplateData(df);
copySaleData(df);
}
private void copyTemplateData(dataFiles df)
{
//copy TreeDefaultValues table
df.cdDAL.DirectCopy(df.tmpDAL, CruiseDAL.Schema.TREEDEFAULTVALUE._NAME, null, OnConflictOption.Ignore);
//copy globals table
df.cdDAL.DirectCopy(df.tmpDAL, CruiseDAL.Schema.GLOBALS._NAME, null, OnConflictOption.Ignore);
//copy logfieldsetupdefault
df.cdDAL.DirectCopy(df.tmpDAL, CruiseDAL.Schema.LOGFIELDSETUPDEFAULT._NAME, null, OnConflictOption.Ignore);
//copy messagelog
df.cdDAL.DirectCopy(df.tmpDAL, CruiseDAL.Schema.MESSAGELOG._NAME, null, OnConflictOption.Ignore);
//copy reports
df.cdDAL.DirectCopy(df.tmpDAL, "Reports", null, OnConflictOption.Ignore);
//copy treefieldsetupdefault
df.cdDAL.DirectCopy(df.tmpDAL, CruiseDAL.Schema.TREEFIELDSETUPDEFAULT._NAME, null, OnConflictOption.Ignore);
//copy volumeequations
df.cdDAL.DirectCopy(df.tmpDAL, CruiseDAL.Schema.VOLUMEEQUATION._NAME, null, OnConflictOption.Ignore);
//copy treeauditvalue
df.cdDAL.DirectCopy(df.tmpDAL, CruiseDAL.Schema.TREEAUDITVALUE._NAME, null, OnConflictOption.Ignore);
//copy treedefaultvaluetreeauditvalue
df.cdDAL.DirectCopy(df.tmpDAL, CruiseDAL.Schema.TREEDEFAULTVALUETREEAUDITVALUE._NAME, null, OnConflictOption.Ignore);
//copy tally
df.cdDAL.DirectCopy(df.tmpDAL, CruiseDAL.Schema.TALLY._NAME, null, OnConflictOption.Ignore);
//copy cruise methods
df.cdDAL.DirectCopy(df.tmpDAL, CruiseDAL.Schema.CRUISEMETHODS._NAME, null, OnConflictOption.Ignore);
}
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();
}
private void createNewDatabase(dataFiles df)
{
try
{
rDAL = new DAL(df.rFile);
}
catch (System.IO.IOException ie)
{
Logger.Log.E(ie);
}
catch (System.Exception ie)
{
Logger.Log.E(ie);
}
copyTablesToDesign(df);
}
// private void RemoveReconTDVData()
// {
// List<TreeDefaultValueDO> treeDV = new List<TreeDefaultValueDO>(rDAL.Read<TreeDefaultValueDO>("TreeDefaultValue", null, null));
// foreach (TreeDefaultValueDO tdv in treeDV)
// {
// tdv.CreatedBy = "";
// tdv.CreatedDate = "";
// tdv.ModifiedBy = "";
// tdv.ModifiedDate = "";
// tdv.RowVersion = "";
// tdv.Save();
// }
// }
private void copyTablesToDesign(dataFiles df)
{
// copy Sale table
// df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.SALE._NAME, null, OnConflictOption.Ignore);
var sale = rDAL.Read<SaleDO>("Sale", null, null);
foreach (SaleDO sl in sale)
{
sl.DAL = df.cdDAL;
sl.Save();
}
// RemoveReconTDVData();
//copy CuttingUnit table
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.CUTTINGUNIT._NAME, null, OnConflictOption.Ignore);
//copy TreeDefaultValues table
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.TREEDEFAULTVALUE._NAME, null, OnConflictOption.Ignore);
//copy globals table
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.GLOBALS._NAME, null, OnConflictOption.Ignore);
//copy logfieldsetupdefault
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.LOGFIELDSETUPDEFAULT._NAME, null, OnConflictOption.Ignore);
//copy logfieldsetup
//df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.LOGFIELDSETUP._NAME, null, OnConflictOption.Ignore);
//copy messagelog
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.MESSAGELOG._NAME, null, OnConflictOption.Ignore);
//copy reports
df.cdDAL.DirectCopy(rDAL, "Reports", null, OnConflictOption.Ignore);
//copy treefieldsetupdefault
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.TREEFIELDSETUPDEFAULT._NAME, null, OnConflictOption.Ignore);
//copy treefieldsetup
//df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.TREEFIELDSETUP._NAME, null, OnConflictOption.Ignore);
//copy volumeequations
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.VOLUMEEQUATION._NAME, null, OnConflictOption.Ignore);
//copy treeauditvalue
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.TREEAUDITVALUE._NAME, null, OnConflictOption.Ignore);
//copy treedefaultvaluetreeauditvalue
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.TREEDEFAULTVALUETREEAUDITVALUE._NAME, null, OnConflictOption.Ignore);
//copy tally
df.cdDAL.DirectCopy(rDAL, CruiseDAL.Schema.TALLY._NAME, null, OnConflictOption.Ignore);
}
