public void LoadValuesSqlite()
{
string strNotes = "";
SQLite.ADO.DataMgr dataMgr = new SQLite.ADO.DataMgr();
string strScenarioDBDir = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() + "\\" + ScenarioType + "\\db";
string strScenarioFile = "scenario_" + ScenarioType + "_rule_definitions.db";
StringBuilder strScenarioFullPath = new StringBuilder(strScenarioDBDir);
strScenarioFullPath.Append("\\");
strScenarioFullPath.Append(strScenarioFile);
string strScenarioConn = dataMgr.GetConnectionString(strScenarioFullPath.ToString());
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection(strScenarioConn))
{
con.Open();
if (ScenarioType.Trim().ToUpper() == "OPTIMIZER")
{
dataMgr.m_strSQL = "SELECT notes FROM scenario WHERE TRIM(scenario_id)='" + this.ReferenceOptimizerScenarioForm.uc_scenario1.strScenarioId.Trim() + "'";
}
else
{
dataMgr.m_strSQL = "SELECT notes FROM scenario WHERE TRIM(scenario_id)='" + this.ReferenceProcessorScenarioForm.uc_scenario1.strScenarioId.Trim() + "'";
}
strNotes = dataMgr.getSingleStringValueFromSQLQuery(con, dataMgr.m_strSQL, "scenario");
}
this.txtNotes.Text = strNotes;
}
private string[] loadScenarioArraySqlite()
{
//
//OPEN CONNECTION TO DB FILE CONTAINING PROCESSOR SCENARIO TABLE
//
//scenario mdb connection
string strProcessorScenarioDB =
frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() +
"\\processor\\" + Tables.ProcessorScenarioRuleDefinitions.DefaultSqliteDbFile;
//
//get a list of all the scenarios
//
SQLite.ADO.DataMgr dataMgr = new SQLite.ADO.DataMgr();
string strConn = dataMgr.GetConnectionString(strProcessorScenarioDB);
IList <string> lstScenarioArray = null;
using (System.Data.SQLite.SQLiteConnection oConn = new System.Data.SQLite.SQLiteConnection(strConn))
{
oConn.Open();
lstScenarioArray = dataMgr.getStringList(oConn,
"SELECT scenario_id " +
"FROM scenario " +
"WHERE scenario_id IS NOT NULL AND " +
"LENGTH(TRIM(scenario_id)) > 0");
}
return(lstScenarioArray.ToArray());
}
private void RefreshFormSqlite()
{
SQLite.ADO.DataMgr dataMgr = new SQLite.ADO.DataMgr();
string strScenarioDir = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() + "\\" + ScenarioType + "\\" +
Tables.ProcessorScenarioRuleDefinitions.DefaultSqliteDbFile;
string strConn = dataMgr.GetConnectionString(strScenarioDir);
try
{
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection(strConn))
{
con.Open();
string strSQL = "select * from scenario where scenario_id = '" + this.lstScenario.SelectedItem.ToString() + "';";
dataMgr.SqlQueryReader(con, strSQL);
if (dataMgr.m_DataReader.HasRows)
{
while (dataMgr.m_DataReader.Read())
{
txtScenarioId.Text = dataMgr.m_DataReader["scenario_id"].ToString();
txtDescription.Text = dataMgr.m_DataReader["description"].ToString();
txtScenarioPath.Text = dataMgr.m_DataReader["path"].ToString();
break;
}
}
dataMgr.m_DataReader.Close();
}
}
catch (Exception caught)
{
intError = -1;
strError = caught.Message;
MessageBox.Show(strError, "FIA Biosum");
}
}
public void SaveScenarioNotes()
{
ado_data_access p_ado = null;
SQLite.ADO.DataMgr oDataMgr = null;
string strNotes = this.txtNotes.Text;
string strProjDir = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim();
string strScenarioDir = strProjDir + "\\" + ScenarioType + "\\db";
if ((ReferenceProcessorScenarioForm != null && !ReferenceProcessorScenarioForm.m_bUsingSqlite) ||
ScenarioType.Trim().ToUpper() == "OPTIMIZER")
{
p_ado = new ado_data_access();
strNotes = p_ado.FixString(strNotes, "'", "''");
string strSQL = "";
if (ScenarioType.Trim().ToUpper() == "OPTIMIZER")
{
strSQL = "UPDATE scenario SET notes = '" +
strNotes +
"' WHERE trim(lcase(scenario_id)) = '" + ((frmOptimizerScenario)this.ParentForm).uc_scenario1.txtScenarioId.Text.Trim().ToLower() + "';";
}
else
{
strSQL = "UPDATE scenario SET notes = '" +
strNotes +
"' WHERE trim(lcase(scenario_id)) = '" + this.ReferenceProcessorScenarioForm.uc_scenario1.txtScenarioId.Text.Trim().ToLower() + "';";
}
System.Data.OleDb.OleDbConnection oConn = new System.Data.OleDb.OleDbConnection();
string strFile = "scenario_" + ScenarioType + "_rule_definitions.mdb";
StringBuilder strFullPath = new StringBuilder(strScenarioDir);
strFullPath.Append("\\");
strFullPath.Append(strFile);
string strConn = p_ado.getMDBConnString(strFullPath.ToString(), "admin", "");
p_ado.SqlNonQuery(strConn, strSQL);
p_ado = null;
}
else
{
oDataMgr = new SQLite.ADO.DataMgr();
strNotes = oDataMgr.FixString(strNotes, "'", "''");
//@ToDo: Only support Processor at this time
string strSQL = "UPDATE scenario SET notes = '" +
strNotes +
"' WHERE trim(lower(scenario_id)) = '" + this.ReferenceProcessorScenarioForm.uc_scenario1.txtScenarioId.Text.Trim().ToLower() + "';";
string strFile = "scenario_" + ScenarioType + "_rule_definitions.db";
StringBuilder strFullPath = new StringBuilder(strScenarioDir);
strFullPath.Append("\\");
strFullPath.Append(strFile);
string strConn = oDataMgr.GetConnectionString(strFullPath.ToString());
using (System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(strConn))
{
conn.Open();
oDataMgr.SqlNonQuery(conn, strSQL);
}
oDataMgr = null;
}
}
public void populate_scenario_listbox_sqlite()
{
string strScenarioId = "";
string strDescription = "";
string strScenarioPath = "";
SQLite.ADO.DataMgr dataMgr = new SQLite.ADO.DataMgr();
string strScenarioDir = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() + "\\" + ScenarioType + "\\" +
Tables.ProcessorScenarioRuleDefinitions.DefaultSqliteDbFile;
string strConn = dataMgr.GetConnectionString(strScenarioDir);
try
{
lstScenario.Items.Clear();
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection(strConn))
{
con.Open();
dataMgr.SqlQueryReader(con, "select * from scenario");
if (dataMgr.m_DataReader.HasRows)
{
while (dataMgr.m_DataReader.Read())
{
strScenarioId = dataMgr.m_DataReader["scenario_id"].ToString();
strDescription = dataMgr.m_DataReader["description"].ToString();
strScenarioPath = dataMgr.m_DataReader["path"].ToString();
this.lstScenario.Items.Add(strScenarioId);
}
}
}
this.lstScenario.SelectedIndex = this.lstScenario.Items.Count - 1;
this.txtScenarioPath.Text = strScenarioPath;
this.txtDescription.Text = strDescription;
}
catch (Exception caught)
{
intError = -1;
strError = caught.Message;
MessageBox.Show(strError, "FIA Biosum");
}
}
public void savevalues()
{
int x;
string strSpcGrp = "";
string strDbhGrp = "";
string strMerchValue = "";
string strChipValue = "";
string strWoodBin = "";
string strSql = "";
SQLite.ADO.DataMgr oDataMgr = null;
if (!ReferenceProcessorScenarioForm.m_bUsingSqlite)
{
//
//DELETE THE CURRENT SCENARIO RECORDS
//
m_oAdo.m_strSQL = "DELETE FROM scenario_tree_species_diam_dollar_values " +
"WHERE TRIM(scenario_id)='" + this.ScenarioId.Trim() + "'";
m_oAdo.SqlNonQuery(m_oAdo.m_OleDbConnection, m_oAdo.m_strSQL);
//
//DELETE THE WORK TABLE
//
if (m_oAdo.TableExist(m_oAdo.m_OleDbConnection, "spcgrp_dbhgrp"))
{
m_oAdo.SqlNonQuery(m_oAdo.m_OleDbConnection, "DROP TABLE spcgrp_dbhgrp");
}
//
//CREATE AND POPULATE WORK TABLE
//
m_oAdo.m_strSQL = "CREATE TABLE spcgrp_dbhgrp (" +
"species_group INTEGER," +
"species_label CHAR(50)," +
"diam_group INTEGER," +
"diam_class CHAR(15))";
m_oAdo.SqlNonQuery(m_oAdo.m_OleDbConnection, m_oAdo.m_strSQL);
foreach (ProcessorScenarioItem.SpcGroupItem objSpcGroup in ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oSpcGroupItem_Collection)
{
foreach (ProcessorScenarioItem.TreeDiamGroupsItem objDiamGroup in ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oTreeDiamGroupsItem_Collection)
{
// INITIALIZE RECORDS IN WORK TABLE
m_oAdo.m_strSQL = "INSERT INTO spcgrp_dbhgrp (species_group,species_label, diam_group, diam_class) " +
"VALUES (" + objSpcGroup.SpeciesGroup + ",'" + objSpcGroup.SpeciesGroupLabel + "'," +
objDiamGroup.DiamGroup + ",'" + objDiamGroup.DiamClass + "')";
m_oAdo.SqlNonQuery(m_oAdo.m_OleDbConnection, m_oAdo.m_strSQL);
//
//INSERT SCENARIO RECORDS
//
m_oAdo.m_strSQL = "INSERT INTO scenario_tree_species_diam_dollar_values (scenario_id,species_group,diam_group) " +
"VALUES ('" + ScenarioId.Trim() + "'," + objSpcGroup.SpeciesGroup + "," +
objDiamGroup.DiamGroup + ")";
m_oAdo.SqlNonQuery(m_oAdo.m_OleDbConnection, m_oAdo.m_strSQL);
}
}
}
else
{
oDataMgr = new SQLite.ADO.DataMgr();
string strScenarioDB =
frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() +
"\\processor\\" + Tables.ProcessorScenarioRuleDefinitions.DefaultSqliteDbFile;
oDataMgr.OpenConnection(oDataMgr.GetConnectionString(strScenarioDB));
if (oDataMgr.m_intError != 0)
{
m_intError = oDataMgr.m_intError;
m_strError = oDataMgr.m_strError;
oDataMgr = null;
return;
}
m_intError = 0;
m_strError = "";
//
//DELETE THE CURRENT SCENARIO RECORDS
//
oDataMgr.m_strSQL = "DELETE FROM scenario_tree_species_diam_dollar_values " +
"WHERE TRIM(scenario_id)='" + this.ScenarioId.Trim() + "'";
oDataMgr.SqlNonQuery(oDataMgr.m_Connection, oDataMgr.m_strSQL);
//
//DELETE THE WORK TABLE
//
if (oDataMgr.TableExist(oDataMgr.m_Connection, "spcgrp_dbhgrp"))
{
oDataMgr.SqlNonQuery(oDataMgr.m_Connection, "DROP TABLE spcgrp_dbhgrp");
}
//
//CREATE AND POPULATE WORK TABLE
//
oDataMgr.m_strSQL = "CREATE TABLE spcgrp_dbhgrp (" +
"species_group INTEGER," +
"species_label TEXT," +
"diam_group INTEGER," +
"diam_class TEXT)";
oDataMgr.SqlNonQuery(oDataMgr.m_Connection, oDataMgr.m_strSQL);
foreach (ProcessorScenarioItem.SpcGroupItem objSpcGroup in ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oSpcGroupItem_Collection)
{
foreach (ProcessorScenarioItem.TreeDiamGroupsItem objDiamGroup in ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oTreeDiamGroupsItem_Collection)
{
// INITIALIZE RECORDS IN WORK TABLE
oDataMgr.m_strSQL = "INSERT INTO spcgrp_dbhgrp (species_group,species_label, diam_group, diam_class) " +
"VALUES (" + objSpcGroup.SpeciesGroup + ",'" + objSpcGroup.SpeciesGroupLabel + "'," +
objDiamGroup.DiamGroup + ",'" + objDiamGroup.DiamClass + "')";
oDataMgr.SqlNonQuery(oDataMgr.m_Connection, oDataMgr.m_strSQL);
//
//INSERT SCENARIO RECORDS
//
oDataMgr.m_strSQL = "INSERT INTO scenario_tree_species_diam_dollar_values (scenario_id,species_group,diam_group) " +
"VALUES ('" + ScenarioId.Trim() + "'," + objSpcGroup.SpeciesGroup + "," +
objDiamGroup.DiamGroup + ")";
oDataMgr.SqlNonQuery(oDataMgr.m_Connection, oDataMgr.m_strSQL);
}
}
}
//
//UPDATE SCENARIO RECORDS WITH MERCH AND CHIP VALUES
//
for (x = 0; x <= this.uc_processor_scenario_spc_dbh_group_value_collection1.Count - 1; x++)
{
strSpcGrp = uc_processor_scenario_spc_dbh_group_value_collection1.Item(x).SpeciesGroup.Trim();
strDbhGrp = uc_processor_scenario_spc_dbh_group_value_collection1.Item(x).DbhGroup.Trim();
strWoodBin = uc_processor_scenario_spc_dbh_group_value_collection1.Item(x).GetWoodBin();
strMerchValue = uc_processor_scenario_spc_dbh_group_value_collection1.Item(x).CubicFootDollarValue.Trim();
strMerchValue = strMerchValue.Replace("$", "");
strChipValue = this.txtChipValue.Text.Trim();
strChipValue = strChipValue.Replace("$", "");
if (!ReferenceProcessorScenarioForm.m_bUsingSqlite)
{
strSql = "UPDATE scenario_tree_species_diam_dollar_values a " +
"INNER JOIN spcgrp_dbhgrp b " +
"ON a.species_group=b.species_group AND " +
"a.diam_group=b.diam_group " +
"SET a.merch_value=" + strMerchValue + "," +
"a.chip_value=" + strChipValue + ", " +
"a.wood_bin='" + strWoodBin.Trim() + "' " +
"WHERE TRIM(a.scenario_id)='" + ScenarioId.Trim() + "' AND " +
"TRIM(b.species_label)='" + strSpcGrp + "' AND " +
"TRIM(b.diam_class)='" + strDbhGrp + "'";
m_oAdo.SqlNonQuery(m_oAdo.m_OleDbConnection, strSql);
}
else
{
strSql = "UPDATE scenario_tree_species_diam_dollar_values " +
"SET merch_value = " + strMerchValue + "," +
"chip_value = " + strChipValue + "," +
"wood_bin = '" + strWoodBin.Trim() + "' WHERE EXISTS (" +
"SELECT * FROM spcgrp_dbhgrp " +
"WHERE scenario_tree_species_diam_dollar_values.species_group = spcgrp_dbhgrp.species_group " +
"AND scenario_tree_species_diam_dollar_values.diam_group = spcgrp_dbhgrp.diam_group " +
"AND TRIM(scenario_tree_species_diam_dollar_values.scenario_id) = '" + ScenarioId.Trim() + "' " +
"AND TRIM(spcgrp_dbhgrp.species_label) = '" + strSpcGrp + "' " +
"AND TRIM(spcgrp_dbhgrp.diam_class) = '" + strDbhGrp + "')";
oDataMgr.SqlNonQuery(oDataMgr.m_Connection, strSql);
}
uc_processor_scenario_spc_dbh_group_value_collection1.Item(x).SaveValues();
}
this.m_strChipValueSave = this.txtChipValue.Text;
if (ReferenceProcessorScenarioForm.m_bUsingSqlite)
{
//
//DELETE THE WORK TABLE AND CLOSE CONNECTION
//
if (oDataMgr.TableExist(oDataMgr.m_Connection, "spcgrp_dbhgrp"))
{
oDataMgr.SqlNonQuery(oDataMgr.m_Connection, "DROP TABLE spcgrp_dbhgrp");
}
m_intError = oDataMgr.m_intError;
oDataMgr.CloseConnection(oDataMgr.m_Connection);
oDataMgr = null;
}
}
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 savevalues()
{
val_data();
if (this.m_intError == 0)
{
//string strSQL;
int x;
string strMin;
string strMax;
string strDef;
string strId;
if (!ReferenceProcessorScenarioForm.m_bUsingSqlite)
{
//
//OPEN CONNECTION TO DB FILE CONTAINING PROCESSOR SCENARIO TABLES
//
//scenario mdb connection
string strScenarioMDB =
frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() +
"\\processor\\db\\scenario_processor_rule_definitions.mdb";
ado_data_access oAdo = new ado_data_access();
oAdo.OpenConnection(oAdo.getMDBConnString(strScenarioMDB, "", ""));
if (oAdo.m_intError != 0)
{
m_intError = m_ado.m_intError;
m_strError = m_ado.m_strError;
oAdo = null;
return;
}
if (this.m_intError == 0)
{
//delete the current records
oAdo.m_strSQL = "DELETE FROM " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeDiamGroupsTableName +
" WHERE TRIM(UCASE(scenario_id)) = '" + ScenarioId.Trim().ToUpper() + "'";
oAdo.SqlNonQuery(oAdo.m_OleDbConnection, oAdo.m_strSQL);
if (oAdo.m_intError == 0)
{
for (x = 0; x <= this.lstTreeDiam.Items.Count - 1; x++)
{
strId = this.lstTreeDiam.Items[x].Text;
strMin = this.lstTreeDiam.Items[x].SubItems[1].Text;
strMax = this.lstTreeDiam.Items[x].SubItems[2].Text;
strDef = this.lstTreeDiam.Items[x].SubItems[3].Text;
oAdo.m_strSQL = "INSERT INTO " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeDiamGroupsTableName + " " +
"(diam_group,diam_class,min_diam,max_diam,scenario_id) VALUES " +
"(" + strId + ",'" + strDef.Trim() + "'," +
strMin + "," + strMax + ",'" + ScenarioId + "');";
oAdo.SqlNonQuery(oAdo.m_OleDbConnection, oAdo.m_strSQL);
if (oAdo.m_intError != 0)
{
break;
}
}
}
}
oAdo.CloseConnection(oAdo.m_OleDbConnection);
this.m_intError = oAdo.m_intError;
oAdo = null;
}
else
{
string strScenarioDB =
frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() +
"\\processor\\" + Tables.ProcessorScenarioRuleDefinitions.DefaultSqliteDbFile;
SQLite.ADO.DataMgr oDataMgr = new SQLite.ADO.DataMgr();
using (System.Data.SQLite.SQLiteConnection conn =
new System.Data.SQLite.SQLiteConnection(oDataMgr.GetConnectionString(strScenarioDB)))
{
conn.Open();
if (oDataMgr.m_intError != 0)
{
m_intError = oDataMgr.m_intError;
m_strError = oDataMgr.m_strError;
oDataMgr = null;
return;
}
if (this.m_intError == 0)
{
//delete the current records
oDataMgr.m_strSQL = "DELETE FROM " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeDiamGroupsTableName +
" WHERE TRIM(UPPER(scenario_id)) = '" + ScenarioId.Trim().ToUpper() + "'";
oDataMgr.SqlNonQuery(conn, oDataMgr.m_strSQL);
if (oDataMgr.m_intError == 0)
{
for (x = 0; x <= this.lstTreeDiam.Items.Count - 1; x++)
{
strId = this.lstTreeDiam.Items[x].Text;
strMin = this.lstTreeDiam.Items[x].SubItems[1].Text;
strMax = this.lstTreeDiam.Items[x].SubItems[2].Text;
strDef = this.lstTreeDiam.Items[x].SubItems[3].Text;
oDataMgr.m_strSQL = "INSERT INTO " + Tables.ProcessorScenarioRuleDefinitions.DefaultTreeDiamGroupsTableName + " " +
"(diam_group,diam_class,min_diam,max_diam,scenario_id) VALUES " +
"(" + strId + ",'" + strDef.Trim() + "'," +
strMin + "," + strMax + ",'" + ScenarioId + "');";
oDataMgr.SqlNonQuery(conn, oDataMgr.m_strSQL);
if (oDataMgr.m_intError != 0)
{
break;
}
}
this.m_intError = oDataMgr.m_intError;
oDataMgr = null;
}
}
}
}
if (this.m_intError == 0)
{
this.btnSave.Enabled = false;
}
}
}
public void savevalues()
{
string strFields = "scenario_id,yard_dist_threshold,assumed_harvest_area_ac," +
"move_in_time_multiplier," +
"move_in_hours_addend";
string strValues = "";
//
//OPEN CONNECTION TO DB FILE CONTAINING PROCESSOR SCENARIO TABLES
//
//scenario mdb connection
ado_data_access oAdo = null;
SQLite.ADO.DataMgr oDataMgr = null;
if (!ReferenceProcessorScenarioForm.m_bUsingSqlite)
{
oAdo = new ado_data_access();
string strScenarioMDB =
frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() +
"\\processor\\db\\scenario_processor_rule_definitions.mdb";
oAdo.OpenConnection(oAdo.getMDBConnString(strScenarioMDB, "", ""));
if (oAdo.m_intError != 0)
{
m_intError = oAdo.m_intError;
m_strError = oAdo.m_strError;
oAdo = null;
return;
}
m_intError = 0;
m_strError = "";
oAdo.m_strSQL = "DELETE FROM " + Tables.ProcessorScenarioRuleDefinitions.DefaultMoveInCostsTableName + " " +
"WHERE TRIM(UCASE(scenario_id)) = '" + ScenarioId.Trim().ToUpper() + "'";
oAdo.SqlNonQuery(oAdo.m_OleDbConnection, oAdo.m_strSQL);
}
else
{
oDataMgr = new SQLite.ADO.DataMgr();
string strScenarioDB =
frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() +
"\\processor\\" + Tables.ProcessorScenarioRuleDefinitions.DefaultSqliteDbFile;
oDataMgr.OpenConnection(oDataMgr.GetConnectionString(strScenarioDB));
if (oDataMgr.m_intError != 0)
{
m_intError = oDataMgr.m_intError;
m_strError = oDataMgr.m_strError;
oDataMgr = null;
return;
}
m_intError = 0;
m_strError = "";
oDataMgr.m_strSQL = "DELETE FROM " + Tables.ProcessorScenarioRuleDefinitions.DefaultMoveInCostsTableName + " " +
"WHERE TRIM(UPPER(scenario_id)) = '" + ScenarioId.Trim().ToUpper() + "'";
oDataMgr.SqlNonQuery(oDataMgr.m_Connection, oDataMgr.m_strSQL);
}
//
//SCENARIOID
//
strValues = "'" + ScenarioId + "',";
//
//YARDING DISTANCE THRESHOLD
//
if (this.txtYardDistThreshold.Text.Trim().Length > 0)
{
strValues = strValues + this.txtYardDistThreshold.Text.Trim() + ",";
}
else
{
strValues = strValues + "null,";
}
//
//ASSUMED HARVEST AREA
//
if (this.txtAssumedHarvestArea.Text.Trim().Length > 0)
{
strValues = strValues + this.txtAssumedHarvestArea.Text.Trim() + ",";
}
else
{
strValues = strValues + "null,";
}
//
//MOVE IN TIME MULTIPLIER
//
if (this.txtMoveInTimeMultiplier.Text.Trim().Length > 0)
{
strValues = strValues + this.txtMoveInTimeMultiplier.Text.Trim() + ",";
}
else
{
strValues = strValues + "null,";
}
//
//MOVE IN TIME ADDEND
//
if (this.txtMoveInAddend.Text.Trim().Length > 0)
{
strValues = strValues + this.txtMoveInAddend.Text.Trim();
}
else
{
strValues = strValues + "null";
}
//
if (!ReferenceProcessorScenarioForm.m_bUsingSqlite)
{
oAdo.m_strSQL = Queries.GetInsertSQL(strFields, strValues, Tables.ProcessorScenarioRuleDefinitions.DefaultMoveInCostsTableName);
oAdo.SqlNonQuery(oAdo.m_OleDbConnection, oAdo.m_strSQL);
m_intError = oAdo.m_intError;
oAdo.CloseConnection(oAdo.m_OleDbConnection);
oAdo = null;
}
else
{
oDataMgr.m_strSQL = Queries.GetInsertSQL(strFields, strValues, Tables.ProcessorScenarioRuleDefinitions.DefaultMoveInCostsTableName);
oDataMgr.SqlNonQuery(oDataMgr.m_Connection, oDataMgr.m_strSQL);
m_intError = oDataMgr.m_intError;
oDataMgr.CloseConnection(oDataMgr.m_Connection);
oDataMgr = null;
}
}
public void savevalues()
{
m_intError = 0;
m_strError = "";
string strValues = "";
string strFields = "scenario_id," +
"EscalatorOperatingCosts_Cycle2," +
"EscalatorOperatingCosts_Cycle3," +
"EscalatorOperatingCosts_Cycle4," +
"EscalatorMerchWoodRevenue_Cycle2," +
"EscalatorMerchWoodRevenue_Cycle3," +
"EscalatorMerchWoodRevenue_Cycle4," +
"EscalatorEnergyWoodRevenue_Cycle2," +
"EscalatorEnergyWoodRevenue_Cycle3," +
"EscalatorEnergyWoodRevenue_Cycle4";
try
{
SQLite.ADO.DataMgr oDataMgr = null;
//
//DELETE THE CURRENT SCENARIO RECORDS
//
if (!ReferenceProcessorScenarioForm.m_bUsingSqlite)
{
m_oAdo.m_strSQL = "DELETE FROM scenario_cost_revenue_escalators " +
"WHERE TRIM(scenario_id)='" + this.ScenarioId.Trim() + "'";
m_oAdo.SqlNonQuery(m_oAdo.m_OleDbConnection, m_oAdo.m_strSQL);
}
else
{
oDataMgr = new SQLite.ADO.DataMgr();
string strScenarioDB =
frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() +
"\\processor\\" + Tables.ProcessorScenarioRuleDefinitions.DefaultSqliteDbFile;
oDataMgr.OpenConnection(oDataMgr.GetConnectionString(strScenarioDB));
if (oDataMgr.m_intError != 0)
{
m_intError = oDataMgr.m_intError;
m_strError = oDataMgr.m_strError;
oDataMgr = null;
return;
}
oDataMgr.m_strSQL = "DELETE FROM scenario_cost_revenue_escalators " +
"WHERE TRIM(scenario_id)='" + this.ScenarioId.Trim() + "'";
oDataMgr.SqlNonQuery(oDataMgr.m_Connection, oDataMgr.m_strSQL);
}
//
//scenario id
//
strValues = "'" + ScenarioId.Trim() + "',";
//
//Operating Cost Cycle1
//
strValues = strValues + this.uc_processor_scenario_escalators_value1.Cycle1.Trim() + ",";
//
//Operating Cost Cycle2
//
strValues = strValues + this.uc_processor_scenario_escalators_value1.Cycle2.Trim() + ",";
//
//Operating Cost Cycle3
//
strValues = strValues + this.uc_processor_scenario_escalators_value1.Cycle3.Trim() + ",";
//
//Merch Wood Revenue Cycle1
//
strValues = strValues + this.uc_processor_scenario_escalators_value2.Cycle1.Trim() + ",";
//
//Merch Wood Revenue Cycle2
//
strValues = strValues + this.uc_processor_scenario_escalators_value2.Cycle2.Trim() + ",";
//
//Merch Wood Revenue Cycle3
//
strValues = strValues + this.uc_processor_scenario_escalators_value2.Cycle3.Trim() + ",";
//
//Energy Wood Revenue Cycle1
//
strValues = strValues + this.uc_processor_scenario_escalators_value3.Cycle1.Trim() + ",";
//
//Energy Wood Revenue Cycle2
//
strValues = strValues + this.uc_processor_scenario_escalators_value3.Cycle2.Trim() + ",";
//
//Energy Wood Revenue Cycle3
//
strValues = strValues + this.uc_processor_scenario_escalators_value3.Cycle3.Trim();
if (!ReferenceProcessorScenarioForm.m_bUsingSqlite)
{
m_oAdo.m_strSQL = Queries.GetInsertSQL(strFields, strValues, "scenario_cost_revenue_escalators");
m_oAdo.SqlNonQuery(m_oAdo.m_OleDbConnection, m_oAdo.m_strSQL);
}
else
{
oDataMgr.m_strSQL = Queries.GetInsertSQL(strFields, strValues, "scenario_cost_revenue_escalators");
oDataMgr.SqlNonQuery(oDataMgr.m_Connection, oDataMgr.m_strSQL);
m_intError = oDataMgr.m_intError;
oDataMgr.CloseConnection(oDataMgr.m_Connection);
oDataMgr = null;
}
this.uc_processor_scenario_escalators_value1.SaveValues();
this.uc_processor_scenario_escalators_value2.SaveValues();
this.uc_processor_scenario_escalators_value3.SaveValues();
}
catch (Exception e)
{
m_intError = -1;
m_strError = e.Message;
}
}
private void loadgridSqlite()
{
//
//OPEN CONNECTION TO DB FILE CONTAINING Processor Scenario TABLE
//
//scenario mdb connection
string strProcessorScenarioDB =
frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() +
"\\processor\\" + Tables.ProcessorScenarioRuleDefinitions.DefaultSqliteDbFile;
SQLite.ADO.DataMgr oDataMgr = new SQLite.ADO.DataMgr();
using (System.Data.SQLite.SQLiteConnection conn =
new System.Data.SQLite.SQLiteConnection(oDataMgr.GetConnectionString(strProcessorScenarioDB)))
{
conn.Open();
//
//get a list of all the scenarios
//
oDataMgr.SqlQueryReader(conn,
"SELECT scenario_id,description " +
"FROM scenario " +
"WHERE scenario_id IS NOT NULL AND " +
"LENGTH(TRIM(scenario_id)) > 0");
int x = 0;
ListViewItem entryListItem = null;
if (oDataMgr.m_DataReader.HasRows)
{
while (oDataMgr.m_DataReader.Read())
{
if (oDataMgr.m_DataReader["scenario_id"] != DBNull.Value &&
oDataMgr.m_DataReader["scenario_id"].ToString().Trim().Length > 0 &&
ReferenceCurrentScenarioItem.ScenarioId.Trim().ToUpper() !=
oDataMgr.m_DataReader["scenario_id"].ToString().Trim().ToUpper())
{
entryListItem = lvProcessorScenario.Items.Add(" ");
entryListItem.UseItemStyleForSubItems = false;
this.m_oLvAlternateColors.AddRow();
this.m_oLvAlternateColors.AddColumns(x, lvProcessorScenario.Columns.Count);
entryListItem.SubItems.Add(oDataMgr.m_DataReader["scenario_id"].ToString().Trim());
if (oDataMgr.m_DataReader["description"] != DBNull.Value &&
oDataMgr.m_DataReader["description"].ToString().Trim().Length > 0)
{
entryListItem.SubItems.Add(oDataMgr.m_DataReader["description"].ToString().Trim());
}
else
{
entryListItem.SubItems.Add(" ");
}
x = x + 1;
}
}
oDataMgr.m_DataReader.Close();
this.m_oLvAlternateColors.ListView();
}
else
{
MessageBox.Show("!!No Scenarios To Copy!!", "FIA Bisoum");
btnCopy.Enabled = false;
}
}
}