public void loadvalues_FromProperties()
{
if (ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oEscalators != null)
{
ProcessorScenarioItem.Escalators oEscalators = ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oEscalators;
//
//UPDATE CYCLE ESCALATOR TEXT BOXES
//
//operating costs cycle 2,3,4
//cycle2
if (oEscalators.OperatingCostsCycle2.Trim().Length > 0)
{
uc_processor_scenario_escalators_value1.Cycle1 =
oEscalators.OperatingCostsCycle2.Trim();
}
else
{
uc_processor_scenario_escalators_value1.Cycle1 = "1.00";
}
//cycle3
if (oEscalators.OperatingCostsCycle3.Trim().Length > 0)
{
uc_processor_scenario_escalators_value1.Cycle2 =
oEscalators.OperatingCostsCycle3.Trim();
}
else
{
uc_processor_scenario_escalators_value1.Cycle2 = "1.00";
}
if (oEscalators.OperatingCostsCycle4.Trim().Length > 0)
{
uc_processor_scenario_escalators_value1.Cycle3 =
oEscalators.OperatingCostsCycle4.Trim();
}
else
{
uc_processor_scenario_escalators_value1.Cycle3 = "1.00";
}
//merch wood revenue cycle 2,3,4
//cycle2
if (oEscalators.MerchWoodRevenueCycle2.Trim().Length > 0)
{
uc_processor_scenario_escalators_value2.Cycle1 =
oEscalators.MerchWoodRevenueCycle2.Trim();
}
else
{
uc_processor_scenario_escalators_value2.Cycle1 = "1.00";
}
//cycle3
if (oEscalators.MerchWoodRevenueCycle3.Trim().Length > 0)
{
uc_processor_scenario_escalators_value2.Cycle2 =
oEscalators.MerchWoodRevenueCycle3.Trim();
}
else
{
uc_processor_scenario_escalators_value2.Cycle2 = "1.00";
}
if (oEscalators.MerchWoodRevenueCycle4.Trim().Length > 0)
{
uc_processor_scenario_escalators_value2.Cycle3 =
oEscalators.MerchWoodRevenueCycle4.Trim();
}
else
{
uc_processor_scenario_escalators_value2.Cycle3 = "1.00";
}
//Energy wood revenue cycle 2,3,4
//cycle2
if (oEscalators.EnergyWoodRevenueCycle2.Trim().Length > 0)
{
uc_processor_scenario_escalators_value3.Cycle1 =
oEscalators.EnergyWoodRevenueCycle2.Trim();
}
else
{
uc_processor_scenario_escalators_value3.Cycle1 = "1.00";
}
//cycle3
if (oEscalators.EnergyWoodRevenueCycle3.Trim().Length > 0)
{
uc_processor_scenario_escalators_value3.Cycle2 =
oEscalators.EnergyWoodRevenueCycle3.Trim();
}
else
{
uc_processor_scenario_escalators_value3.Cycle2 = "1.00";
}
if (oEscalators.EnergyWoodRevenueCycle4.Trim().Length > 0)
{
uc_processor_scenario_escalators_value3.Cycle3 =
oEscalators.EnergyWoodRevenueCycle4.Trim();
}
else
{
uc_processor_scenario_escalators_value3.Cycle3 = "1.00";
}
}
this.uc_processor_scenario_escalators_value1.ReferenceProcessorScenarioForm = ReferenceProcessorScenarioForm;
this.uc_processor_scenario_escalators_value2.ReferenceProcessorScenarioForm = ReferenceProcessorScenarioForm;
this.uc_processor_scenario_escalators_value3.ReferenceProcessorScenarioForm = ReferenceProcessorScenarioForm;
lblCycleLength.Text = Convert.ToString(ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oEscalators.CycleLength);
}
public void loadvalues()
{
int x, y;
string strField;
if (m_oAdo != null && m_oAdo.m_OleDbConnection != null)
{
if (m_oAdo.m_OleDbConnection.State == System.Data.ConnectionState.Open)
{
m_oAdo.CloseConnection(m_oAdo.m_OleDbConnection);
}
}
//
//SCENARIO MDB
//
string strScenarioMDB =
frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() +
"\\processor\\db\\scenario_processor_rule_definitions.mdb";
//
//SCENARIO ID
//
ScenarioId = this.ReferenceProcessorScenarioForm.uc_scenario1.txtScenarioId.Text.Trim().ToLower();
//
//CREATE LINK IN TEMP MDB TO SCENARIO COST REVENUE ESCALATORS TABLE
//
dao_data_access oDao = new dao_data_access();
//link to tree species groups table
oDao.CreateTableLink(this.ReferenceProcessorScenarioForm.LoadedQueries.m_strTempDbFile,
"scenario_cost_revenue_escalators",
strScenarioMDB, "scenario_cost_revenue_escalators", true);
oDao.m_DaoWorkspace.Close();
oDao = null;
//
//OPEN CONNECTION TO TEMP DB FILE
//
m_oAdo = new ado_data_access();
m_oAdo.OpenConnection(m_oAdo.getMDBConnString(this.ReferenceProcessorScenarioForm.LoadedQueries.m_strTempDbFile, "", ""));
if (m_oAdo.m_intError == 0)
{
ReferenceProcessorScenarioForm.m_oProcessorScenarioTools.LoadEscalators(
m_oAdo, m_oAdo.m_OleDbConnection, ReferenceProcessorScenarioForm.LoadedQueries, ReferenceProcessorScenarioForm.m_oProcessorScenarioItem);
ProcessorScenarioItem.Escalators oEscalators = ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oEscalators;
//
//UPDATE CYCLE ESCALATOR TEXT BOXES
//
//operating costs cycle 2,3,4
//cycle2
if (oEscalators.OperatingCostsCycle2.Trim().Length > 0)
{
uc_processor_scenario_escalators_value1.Cycle1 =
oEscalators.OperatingCostsCycle2.Trim();
}
else
{
uc_processor_scenario_escalators_value1.Cycle1 = "1.00";
}
//cycle3
if (oEscalators.OperatingCostsCycle3.Trim().Length > 0)
{
uc_processor_scenario_escalators_value1.Cycle2 =
oEscalators.OperatingCostsCycle3.Trim();
}
else
{
uc_processor_scenario_escalators_value1.Cycle2 = "1.00";
}
if (oEscalators.OperatingCostsCycle4.Trim().Length > 0)
{
uc_processor_scenario_escalators_value1.Cycle3 =
oEscalators.OperatingCostsCycle4.Trim();
}
else
{
uc_processor_scenario_escalators_value1.Cycle3 = "1.00";
}
//merch wood revenue cycle 2,3,4
//cycle2
if (oEscalators.MerchWoodRevenueCycle2.Trim().Length > 0)
{
uc_processor_scenario_escalators_value2.Cycle1 =
oEscalators.MerchWoodRevenueCycle2.Trim();
}
else
{
uc_processor_scenario_escalators_value2.Cycle1 = "1.00";
}
//cycle3
if (oEscalators.MerchWoodRevenueCycle3.Trim().Length > 0)
{
uc_processor_scenario_escalators_value2.Cycle2 =
oEscalators.MerchWoodRevenueCycle3.Trim();
}
else
{
uc_processor_scenario_escalators_value2.Cycle2 = "1.00";
}
if (oEscalators.MerchWoodRevenueCycle4.Trim().Length > 0)
{
uc_processor_scenario_escalators_value2.Cycle3 =
oEscalators.MerchWoodRevenueCycle4.Trim();
}
else
{
uc_processor_scenario_escalators_value2.Cycle3 = "1.00";
}
//Energy wood revenue cycle 2,3,4
//cycle2
if (oEscalators.EnergyWoodRevenueCycle2.Trim().Length > 0)
{
uc_processor_scenario_escalators_value3.Cycle1 =
oEscalators.EnergyWoodRevenueCycle2.Trim();
}
else
{
uc_processor_scenario_escalators_value3.Cycle1 = "1.00";
}
//cycle3
if (oEscalators.EnergyWoodRevenueCycle3.Trim().Length > 0)
{
uc_processor_scenario_escalators_value3.Cycle2 =
oEscalators.EnergyWoodRevenueCycle3.Trim();
}
else
{
uc_processor_scenario_escalators_value3.Cycle2 = "1.00";
}
if (oEscalators.EnergyWoodRevenueCycle4.Trim().Length > 0)
{
uc_processor_scenario_escalators_value3.Cycle3 =
oEscalators.EnergyWoodRevenueCycle4.Trim();
}
else
{
uc_processor_scenario_escalators_value3.Cycle3 = "1.00";
}
}
this.uc_processor_scenario_escalators_value1.ReferenceProcessorScenarioForm = ReferenceProcessorScenarioForm;
this.uc_processor_scenario_escalators_value2.ReferenceProcessorScenarioForm = ReferenceProcessorScenarioForm;
this.uc_processor_scenario_escalators_value3.ReferenceProcessorScenarioForm = ReferenceProcessorScenarioForm;
lblCycleLength.Text = Convert.ToString(ReferenceProcessorScenarioForm.m_oProcessorScenarioItem.m_oEscalators.CycleLength);
}