The WaterSim_DB type exposes the following members.

Constructors

  NameDescription
Public methodWaterSim_DB
Constructs a WaterSim_DB object. Creates a new DbConnection and opens the Database if a filename is provided. Otherwise DBConnection is not created.

Methods

  NameDescription
Public methodColorado_Historical_Extraction_Start_Year_RangeCheck
Colorado_Historical_Extraction_Start_Year_RangeCheck
(Inherited from WaterSim.)
Public methodCreateDirectory
Creates a Directory of directoryName if it does not exist. Relative references is from the directory the program is executing from
(Inherited from WaterSim.)
Public methodCreateNewDataTable
Creates a new table in the open database. Must be a unique name. Creates all possible fields.
Public methodDispose
Must be called before WaterSim object loses scope or is lost (reassigned).
(Inherited from WaterSim.)
Public methodFastGetAnnualData
Fast get annual data.
(Inherited from WaterSim.)
Public methodGetErrorMessage
Gets the error message.
Public methodLoadScenario_DB
Loads a scenario from a database.
Public methodLockSimulation
Locks the simulation so not parameters can be set until unlocked. ///
(Inherited from WaterSim.)
Public methodPCTEffluentRangeCheck
PCTEffluentRangeCheck
(Inherited from WaterSim.)
Public methodPCTReclaimedRangeCheck
PCTReclaimedRangeCheck - Check to see of all the PCT reclaimed model paramters do nt eceeed 100% total
(Inherited from WaterSim.)
Public methodPCTResComRangeCheck
PCTResComRangeCheck - Checks to see if Residential an Commerical water use PCT does not excede 100.
(Inherited from WaterSim.)
Public methodProvider_Demand_Option_Label
Provider demand option label.
(Inherited from WaterSim.)
Public methodSaltVerde_Historical_Extraction_Start_Year_RangeCheck
SaltVerde_Historical_Extraction_Start_Year_RangeCheck
(Inherited from WaterSim.)
Public methodSimulation_AllYears
Runs all the years of the Simulation based on Simulation_STart_Year and Simulation_End_year, If initialized with one of the DB Simulation_Initilaize() overloads, will append data to the datatable, otehrwise just runs the model all years.
(Overrides WaterSim..::..Simulation_AllYears()()()().)
Public methodSimulation_Initialize()()()()
Must be called to setup a Simulation . Simulation can be run in two ways, calling SimulationNextYear() for each year to be run, call SimulationAllYears() which runs all the years All simulations should be stopped with StopSimulation(), which will make sure all files are closed Will reset SimulationLock to false;
(Inherited from WaterSim.)
Public methodSimulation_Initialize(DataTable, String)
Initializes a DB Simulation. results will be appended to the specified DataTable
Public methodSimulation_Initialize(String, String)
Initializes a DB Simulation. Opens the datatable using DbConnection and datatablename, results will be written to temp DataTable and then updated in the Database.
Public methodSimulation_NextYear
Runs the next (or first) year of the Simulation. If initialized with one of the DB Simulation_Initilaize() overloads, will append data to the datatable, otehrwise just runs the model one year.
(Overrides WaterSim..::..Simulation_NextYear()()()().)
Public methodSimulation_Stop
Stops the Simulation. If initialized with one of the DB Simulation_Initilaize() overloads, will update the datatable in the database.
(Overrides WaterSim..::..Simulation_Stop()()()().)
Public methodsimulationYears (Inherited from WaterSim.)
Public methodUnLockSimulation (Inherited from WaterSim.)
Public methodValid_DataTable
Check if Valid WaterSIM_DB datatable

Fields

  NameDescription
Public fieldColorado_Annual_Deliveries
The colorado annual deliveries
(Inherited from WaterSim.)
Public fieldColoradoBureau
The Colorado River Bureau/Historical River Range
(Inherited from WaterSim.)
Public fieldColoradoPaleo
The Colorado River Paleo River Range
(Inherited from WaterSim.)
Public fieldColoradoUser
Colorado river range for user supplied data
(Inherited from WaterSim.)
Public fieldDemand_Deficit
The demand deficit
(Inherited from WaterSim.)
Public fieldEffluent_Created
The effluent created
(Inherited from WaterSim.)
Public fieldEffluent_Discharged
The effluent discharged
(Inherited from WaterSim.)
Public fieldEffluent_To_PowerPlant
The effluent to power plant
(Inherited from WaterSim.)
Public fieldEffluent_To_Vadose
The effluent to vadose
(Inherited from WaterSim.)
Public fieldGPCD_Used
The gpcd used
(Inherited from WaterSim.)
Public fieldGroundwater_Balance
The groundwater balance
(Inherited from WaterSim.)
Public fieldGroundwater_Bank_Balance
The groundwater bank balance
(Inherited from WaterSim.)
Public fieldGroundwater_Bank_Used
The groundwater bank used
(Inherited from WaterSim.)
Public fieldGroundwater_Pumped_Municipal
The groundwater pumped municipal
(Inherited from WaterSim.)
Public fieldPCT_Effluent_to_PowerPlant
The percent effluent to power plant
(Inherited from WaterSim.)
Public fieldPCT_Effluent_to_Vadose
The percent effluent to vadose
(Inherited from WaterSim.)
Public fieldPCT_Groundwater_Treated
The percent groundwater treated
(Inherited from WaterSim.)
Public fieldPCT_Growth_Rate_Adjustment
The percent growth rate adjustment
(Inherited from WaterSim.)
Public fieldPCT_Max_Demand_Reclaim
The percent maximum demand reclaim
(Inherited from WaterSim.)
Public fieldPCT_Outdoor_WaterUse
The percent outdoor water use
(Inherited from WaterSim.)
Public fieldPCT_Reclaimed_Outdoor_Use
The percent reclaimed outdoor use
(Inherited from WaterSim.)
Public fieldPCT_Reclaimed_to_DirectInject
The percent reclaimed to direct inject
(Inherited from WaterSim.)
Public fieldPCT_Reclaimed_to_RO
The percent reclaimed to Reverse Osmosis
(Inherited from WaterSim.)
Public fieldPCT_Reclaimed_to_Vadose
The percent reclaimed to vadose
(Inherited from WaterSim.)
Public fieldPCT_Reclaimed_to_Water_Supply
The percent reclaimed to water supply
(Inherited from WaterSim.)
Public fieldPCT_RO_to_Water_Supply
The percent reverse osmosis water to water supply
(Inherited from WaterSim.)
Public fieldPCT_SurfaceWater_to_WaterBank
The percent surface water to water bank
(Inherited from WaterSim.)
Public fieldPCT_Wastewater_Reclaimed
The percent wastewater reclaimed
(Inherited from WaterSim.)
Public fieldPCT_Wastewater_to_Effluent
The percent wastewater to effluent
(Inherited from WaterSim.)
Public fieldPCT_WaterSupply_to_ComInd
The percent water supply to com ind
(Inherited from WaterSim.)
Public fieldPCT_WaterSupply_to_Residential
The percent water supply to residential
(Inherited from WaterSim.)
Public fieldPopulation_Used
The population used
(Inherited from WaterSim.)
Public fieldStatic memberrdbfID
Primary key db fieldname
Public fieldStatic memberrdbfProviderCode
Provider code db fieldname
Public fieldStatic memberrdbfProviderLabel
Provider label db fieldname
Public fieldStatic memberrdbfScenarioName
Scenario name db fieldname
Public fieldStatic memberrdbfSimYear
Simulation year db fieldname
Public fieldReclaimed_Water_Created
The reclaimed water created
(Inherited from WaterSim.)
Public fieldReclaimed_Water_Discharged
The reclaimed water discharged
(Inherited from WaterSim.)
Public fieldReclaimed_Water_to_DirectInject
The reclaimed water to direct inject
(Inherited from WaterSim.)
Public fieldReclaimed_Water_To_Vadose
The reclaimed water to vadose
(Inherited from WaterSim.)
Public fieldReclaimed_Water_Used
The reclaimed water used
(Inherited from WaterSim.)
Public fieldRO_Reclaimed_Water_Created
The ro reclaimed water created
(Inherited from WaterSim.)
Public fieldRO_Reclaimed_Water_to_DirectInject
The ro reclaimed water to direct inject
(Inherited from WaterSim.)
Public fieldRO_Reclaimed_Water_Used
The ro reclaimed water used
(Inherited from WaterSim.)
Public fieldSaltVerde_Annual_Deliveries_SRP
The salt verde annual deliveries srp
(Inherited from WaterSim.)
Public fieldSaltVerde_Class_BC_Designations (Inherited from WaterSim.)
Public fieldSaltVerdeBureau
The Salt Verde Bureau/Historical River Range
(Inherited from WaterSim.)
Public fieldSaltVerdePaleo
The Salt Verde Rivers Paleo/Tree Ring River Range
(Inherited from WaterSim.)
Public fieldSaltVerdeUser
Salt Verde river range for user supplied data
(Inherited from WaterSim.)
Public fieldSurface_to_Vadose_Time_Lag
The surface to vadose time lag
(Inherited from WaterSim.)
Public fieldSurfaceWater__to_Vadose
Surface water to vadose
(Inherited from WaterSim.)
Public fieldTotal_Demand
The total demand
(Inherited from WaterSim.)
Public fieldUse_GPCD
The gpcd to use with User Supplied GPCD
(Inherited from WaterSim.)
Public fieldUse_SurfaceWater_to_WaterBank
The use surface water to water bank
(Inherited from WaterSim.)
Public fieldUse_WaterSupply_to_DirectInject
The amount of water to direct inject
(Inherited from WaterSim.)
Public fieldWaterBank_Source_Option
The water bank source option
(Inherited from WaterSim.)

Properties

  NameDescription
Public propertyAPiVersion
Version of the API interface
(Inherited from WaterSim.)
Public propertyColorado_Climate_Adjustment_Percent
Gets or sets the colorado climate adjustment percent.
(Inherited from WaterSim.)
Public propertyColorado_Historical_Data_Source
Gets or sets the colorado historical data source.
(Inherited from WaterSim.)
Public propertyColorado_Historical_Extraction_Start_Year
Gets or sets the colorado historical extraction start year.
(Inherited from WaterSim.)
Public propertyColorado_River_Flow
Gets the colorado river flow.
(Inherited from WaterSim.)
Public propertyColorado_User_Adjustment_Percent
Gets or sets the colorado user adjustment percent.
(Inherited from WaterSim.)
Public propertyColorado_User_Adjustment_StartYear
Gets or sets the colorado user adjustment start year.
(Inherited from WaterSim.)
Public propertyColorado_User_Adjustment_Stop_Year
Gets or sets the colorado user adjustment stop year.
(Inherited from WaterSim.)
Public propertyDatabaseFilename
Property Datbase Filename for DbConnection. If different than current database (or database not open) closes DbConnection and opens new using this filename.
Public propertyDataBaseOpen
Property Returns true if the Database is open
Public propertyDbConnection
Property This is the database connection, can be opened seperately and assigned with this property, must be in the Open state, otherwise and exception is thrown
Public propertyEffluent_To_Agriculture
Gets the effluent to agriculture.
(Inherited from WaterSim.)
Public propertyisError
Property Returns true if t
Public propertyMead_Storage
Gets the mead storage.
(Inherited from WaterSim.)
Public propertyModelBuild
Verson of the Fortran Model
(Inherited from WaterSim.)
Public propertyParamManager
Provides access to the Parameter Manager
(Inherited from WaterSim.)
Public propertyPostProcess
Called after each year run Write Only
(Inherited from WaterSim.)
Public propertyPowell_Storage
Gets the powell storage.
(Inherited from WaterSim.)
Public propertyPreProcess
Called before each year run, Write Only
(Inherited from WaterSim.)
Public propertyProcessManager
Provides access to the Process Manager
(Inherited from WaterSim.)
Public propertyProvider_Demand_Option
Gets or sets the provider demand option.
(Inherited from WaterSim.)
Public propertySaltVerde_Climate_Adjustment_Percent
Gets or sets the salt verde climate adjustment percent.
(Inherited from WaterSim.)
Public propertySaltVerde_Historical_Data_Source
Gets or sets the salt verde historical data source.
(Inherited from WaterSim.)
Public propertySaltVerde_Historical_Extraction_Start_Year
Gets or sets the salt verde historical extraction start year.
(Inherited from WaterSim.)
Public propertySaltVerde_River_Flow
Gets the salt verde river flow.
(Inherited from WaterSim.)
Public propertySaltVerde_Storage
Gets the salt verde storage.
(Inherited from WaterSim.)
Public propertySaltVerde_User_Adjustment_Percent
Gets or sets the salt verde user adjustment percent.
(Inherited from WaterSim.)
Public propertySaltVerde_User_Adjustment_Start_Year
Gets or sets the salt verde user adjustment start year.
(Inherited from WaterSim.)
Public propertySaltVerde_User_Adjustment_Stop_Year
Gets or sets the salt verde user adjustment stop year.
(Inherited from WaterSim.)
Public propertySimulation_End_Year
Gets or sets the simulation end year.
(Inherited from WaterSim.)
Public propertySimulation_Start_Year
Simulation_Start_Year
(Inherited from WaterSim.)
Public propertySimulationLock
Property Locks the simulation so no parameters can be set until unlocked.
(Inherited from WaterSim.)

See Also