public void saveTreeGroupings_FromPropertiesSqlite()
{
SQLite.ADO.DataMgr oDataMgr = new SQLite.ADO.DataMgr();
string strDbFile = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() +
"\\processor\\" + Tables.ProcessorScenarioRuleDefinitions.DefaultSqliteDbFile;
using (System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(oDataMgr.GetConnectionString(strDbFile)))
{
conn.Open();
if (oDataMgr.m_intError == 0)
{
string strScenarioId = this.ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.ScenarioId;
//delete the current records
oDataMgr.m_strSQL = "DELETE FROM " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeDiamGroupsTableName +
" WHERE TRIM(UPPER(scenario_id)) = '" + strScenarioId.ToUpper().Trim() + "'";
oDataMgr.SqlNonQuery(conn, oDataMgr.m_strSQL);
// saving tree diameter groups
if (oDataMgr.m_intError == 0)
{
string strMin;
string strMax;
string strDef;
string strId;
for (int x = 0; x <= ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oTreeDiamGroupsItem_Collection.Count - 1; x++)
{
ProcessorScenarioItem.TreeDiamGroupsItem oItem =
ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oTreeDiamGroupsItem_Collection.Item(x);
strId = oItem.DiamGroup;
strMin = oItem.MinDiam;
strMax = oItem.MaxDiam;
strDef = oItem.DiamClass;
oDataMgr.m_strSQL = "INSERT INTO " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeDiamGroupsTableName + " " +
"(diam_group,diam_class,min_diam,max_diam,scenario_id) VALUES " +
"(" + strId + ",'" + strDef.Trim() + "'," +
strMin + "," + strMax + ",'" + strScenarioId.Trim() + "');";
oDataMgr.SqlNonQuery(conn, oDataMgr.m_strSQL);
if (oDataMgr.m_intError != 0)
{
break;
}
}
}
// saving tree species groups
if (oDataMgr.m_intError == 0)
{
string strCommonName;
int intSpCd;
int intSpcGrp;
string strGrpLabel;
int x;
//delete all records from the tree species group table
oDataMgr.m_strSQL = "DELETE FROM " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeSpeciesGroupsTableName +
" WHERE TRIM(UPPER(scenario_id))='" + strScenarioId.Trim().ToUpper() + "'";
oDataMgr.SqlNonQuery(conn, oDataMgr.m_strSQL);
if (oDataMgr.m_intError != 0)
{
return;
}
//delete all records from the tree species group list table
oDataMgr.m_strSQL = "DELETE FROM " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeSpeciesGroupsListTableName +
" WHERE TRIM(UPPER(scenario_id))='" + strScenarioId.Trim().ToUpper() + "'";
oDataMgr.SqlNonQuery(conn, oDataMgr.m_strSQL);
if (oDataMgr.m_intError == 0)
{
for (x = 0; x <= this.ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oSpcGroupItem_Collection.Count - 1; x++)
{
FIA_Biosum_Manager.ProcessorScenarioItem.SpcGroupItem oItem =
ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oSpcGroupItem_Collection.Item(x);
intSpcGrp = oItem.SpeciesGroup;
strGrpLabel = oItem.SpeciesGroupLabel;
oDataMgr.m_strSQL = "INSERT INTO " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeSpeciesGroupsTableName + " " +
"(SPECIES_GROUP,SPECIES_LABEL,SCENARIO_ID) VALUES " +
"(" + Convert.ToString(intSpcGrp).Trim() + ",'" + strGrpLabel.Trim() + "','" + strScenarioId.Trim() + "');";
oDataMgr.SqlNonQuery(conn, oDataMgr.m_strSQL);
}
}
if (oDataMgr.m_intError == 0)
{
for (x = 0; x <= this.ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oSpcGroupListItem_Collection.Count - 1; x++)
{
ProcessorScenarioItem.SpcGroupListItem oItem =
ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oSpcGroupListItem_Collection.Item(x);
intSpcGrp = oItem.SpeciesGroup;
strCommonName = oItem.CommonName;
strCommonName = oDataMgr.FixString(strCommonName.Trim(), "'", "''");
intSpCd = oItem.SpeciesCode;
oDataMgr.m_strSQL = "INSERT INTO " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeSpeciesGroupsListTableName + " " +
"(SPECIES_GROUP,common_name,SCENARIO_ID,SPCD) VALUES " +
"(" + Convert.ToString(intSpcGrp).Trim() + ",'" + strCommonName + "','" + strScenarioId.Trim() + "', " +
intSpCd + " );";
oDataMgr.SqlNonQuery(conn, oDataMgr.m_strSQL);
}
}
}
ReferenceProcessorScenarioForm.m_bTreeGroupsCopied = false;
}
}
oDataMgr = null;
}
public void saveTreeGroupings_FromProperties()
{
if (!ReferenceProcessorScenarioForm.m_bUsingSqlite)
{
ado_data_access _objAdo = new ado_data_access();
string strDbFile = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() +
"\\processor\\" + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeDiamGroupsDbFile;
_objAdo.OpenConnection(_objAdo.getMDBConnString(strDbFile, "", ""));
if (_objAdo.m_intError == 0)
{
string strScenarioId = this.ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.ScenarioId;
//delete the current records
_objAdo.m_strSQL = "DELETE FROM " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeDiamGroupsTableName +
" WHERE TRIM(UCASE(scenario_id)) = '" + strScenarioId.Trim() + "'";
_objAdo.SqlNonQuery(_objAdo.m_OleDbConnection, _objAdo.m_strSQL);
// saving tree diameter groups
if (_objAdo.m_intError == 0)
{
string strMin;
string strMax;
string strDef;
string strId;
for (int x = 0; x <= ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oTreeDiamGroupsItem_Collection.Count - 1; x++)
{
FIA_Biosum_Manager.ProcessorScenarioItem.TreeDiamGroupsItem oItem =
ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oTreeDiamGroupsItem_Collection.Item(x);
strId = oItem.DiamGroup;
strMin = oItem.MinDiam;
strMax = oItem.MaxDiam;
strDef = oItem.DiamClass;
_objAdo.m_strSQL = "INSERT INTO " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeDiamGroupsTableName + " " +
"(diam_group,diam_class,min_diam,max_diam,scenario_id) VALUES " +
"(" + strId + ",'" + strDef.Trim() + "'," +
strMin + "," + strMax + ",'" + strScenarioId.Trim() + "');";
_objAdo.SqlNonQuery(_objAdo.m_OleDbConnection, _objAdo.m_strSQL);
if (_objAdo.m_intError != 0)
{
break;
}
}
}
// saving tree species groups
if (_objAdo.m_intError == 0)
{
string strCommonName;
int intSpCd;
int intSpcGrp;
string strGrpLabel;
int x;
//delete all records from the tree species group table
_objAdo.m_strSQL = "DELETE FROM " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeSpeciesGroupsTableName +
" WHERE TRIM(UCASE(scenario_id))='" + strScenarioId.Trim().ToUpper() + " '";
_objAdo.SqlNonQuery(_objAdo.m_OleDbConnection, _objAdo.m_strSQL);
if (_objAdo.m_intError != 0)
{
return;
}
//delete all records from the tree species group list table
_objAdo.m_strSQL = "DELETE FROM " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeSpeciesGroupsListTableName +
" WHERE TRIM(UCASE(scenario_id))='" + strScenarioId.Trim().ToUpper() + " '";
_objAdo.SqlNonQuery(_objAdo.m_OleDbConnection, _objAdo.m_strSQL);
if (_objAdo.m_intError == 0)
{
for (x = 0; x <= this.ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oSpcGroupItem_Collection.Count - 1; x++)
{
FIA_Biosum_Manager.ProcessorScenarioItem.SpcGroupItem oItem =
ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oSpcGroupItem_Collection.Item(x);
intSpcGrp = oItem.SpeciesGroup;
strGrpLabel = oItem.SpeciesGroupLabel;
_objAdo.m_strSQL = "INSERT INTO " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeSpeciesGroupsTableName + " " +
"(SPECIES_GROUP,SPECIES_LABEL,SCENARIO_ID) VALUES " +
"(" + Convert.ToString(intSpcGrp).Trim() + ",'" + strGrpLabel.Trim() + "','" + strScenarioId.Trim() + "');";
_objAdo.SqlNonQuery(_objAdo.m_OleDbConnection, _objAdo.m_strSQL);
}
}
if (_objAdo.m_intError == 0)
{
for (x = 0; x <= this.ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oSpcGroupListItem_Collection.Count - 1; x++)
{
FIA_Biosum_Manager.ProcessorScenarioItem.SpcGroupListItem oItem =
ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oSpcGroupListItem_Collection.Item(x);
intSpcGrp = oItem.SpeciesGroup;
strCommonName = oItem.CommonName;
strCommonName = _objAdo.FixString(strCommonName.Trim(), "'", "''");
intSpCd = oItem.SpeciesCode;
_objAdo.m_strSQL = "INSERT INTO " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeSpeciesGroupsListTableName + " " +
"(SPECIES_GROUP,common_name,SCENARIO_ID,SPCD) VALUES " +
"(" + Convert.ToString(intSpcGrp).Trim() + ",'" + strCommonName + "','" + strScenarioId.Trim() + "', " +
intSpCd + " );";
_objAdo.SqlNonQuery(_objAdo.m_OleDbConnection, _objAdo.m_strSQL);
}
}
}
ReferenceProcessorScenarioForm.m_bTreeGroupsCopied = false;
}
_objAdo.CloseConnection(_objAdo.m_OleDbConnection);
_objAdo = null;
}
else
{
saveTreeGroupings_FromPropertiesSqlite();
}
}
