private void OnSimulationCompleted(object sender, EventArgs e)
{
DataStore dataStore = new DataStore(this);
dataStore.WriteTable(this.messagesTable);
dataStore.Disconnect();
}
/// <summary>
/// Create an initial conditions table in the DataStore.
/// </summary>
/// <param name="simulation">The simulation to create an table for</param>
private static void CreateInitialConditionsTable(Simulation simulation)
{
// Create our initial conditions table.
DataTable initialConditionsTable = new DataTable("InitialConditions");
initialConditionsTable.Columns.Add("ModelPath", typeof(string));
initialConditionsTable.Columns.Add("Name", typeof(string));
initialConditionsTable.Columns.Add("Description", typeof(string));
initialConditionsTable.Columns.Add("DataType", typeof(string));
initialConditionsTable.Columns.Add("Units", typeof(string));
initialConditionsTable.Columns.Add("DisplayFormat", typeof(string));
initialConditionsTable.Columns.Add("Total", typeof(int));
initialConditionsTable.Columns.Add("Value", typeof(string));
initialConditionsTable.Rows.Add(
new object[] { Apsim.FullPath(simulation), "Simulation name", "Simulation name", "String", string.Empty, string.Empty, false, simulation.Name });
// Get all model properties and store in 'initialConditionsTable'
foreach (Model model in Apsim.FindAll(simulation))
{
string relativeModelPath = Apsim.FullPath(model).Replace(Apsim.FullPath(simulation) + ".", string.Empty);
List <VariableProperty> properties = new List <VariableProperty>();
FindAllProperties(model, properties);
foreach (VariableProperty property in properties)
{
string value = property.ValueWithArrayHandling.ToString();
if (value != string.Empty)
{
if (value != null && property.DataType == typeof(DateTime))
{
value = ((DateTime)property.Value).ToString("yyyy-MM-dd hh:mm:ss");
}
bool showTotal = !double.IsNaN(property.Total);
initialConditionsTable.Rows.Add(new object[]
{
relativeModelPath,
property.Name,
property.Description,
property.DataType.Name,
property.Units,
property.Format,
showTotal,
value
});
}
}
}
// Write to data store.
DataStore dataStore = new DataStore(simulation);
dataStore.DeleteOldContentInTable(simulation.Name, "InitialConditions");
dataStore.WriteTable(simulation.Name, "InitialConditions", initialConditionsTable);
dataStore.Disconnect();
}
private void OnSimulationCompleted(object sender, EventArgs e)
{
DataStore dataStore = new DataStore(this);
dataStore.DeleteOldContentInTable(this.Simulation.Name, "Messages");
dataStore.WriteTable(this.Simulation.Name, "Messages", this.messagesTable);
dataStore.Disconnect();
}
private void OnSimulationCompleted(object sender, EventArgs e)
{
DataStore dataStore = new DataStore(this);
dataStore.DeleteOldContentInTable(this.Simulation.Name, "Messages");
dataStore.WriteTable(this.Simulation.Name, "Messages", this.messagesTable);
dataStore.Disconnect();
}
/// <summary>
/// Create an initial conditions table in the DataStore.
/// </summary>
/// <param name="simulation">The simulation to create an table for</param>
private static void CreateInitialConditionsTable(Simulation simulation)
{
// Create our initial conditions table.
DataTable initialConditionsTable = new DataTable("InitialConditions");
initialConditionsTable.Columns.Add("ModelPath", typeof(string));
initialConditionsTable.Columns.Add("Name", typeof(string));
initialConditionsTable.Columns.Add("Description", typeof(string));
initialConditionsTable.Columns.Add("DataType", typeof(string));
initialConditionsTable.Columns.Add("Units", typeof(string));
initialConditionsTable.Columns.Add("DisplayFormat", typeof(string));
initialConditionsTable.Columns.Add("Total", typeof(int));
initialConditionsTable.Columns.Add("Value", typeof(string));
initialConditionsTable.Rows.Add(
new object[] { Apsim.FullPath(simulation), "Simulation name", "Simulation name", "String", string.Empty, string.Empty, false, simulation.Name });
initialConditionsTable.Rows.Add(
new object[] { Apsim.FullPath(simulation), "APSIM version", "APSIM version", "String", string.Empty, string.Empty, false, simulation.ApsimVersion });
initialConditionsTable.Rows.Add(
new object[] { Apsim.FullPath(simulation), "Run on", "Run on", "String", string.Empty, string.Empty, false, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") });
// Get all model properties and store in 'initialConditionsTable'
foreach (Model model in Apsim.FindAll(simulation))
{
string relativeModelPath = Apsim.FullPath(model).Replace(Apsim.FullPath(simulation) + ".", string.Empty);
List<VariableProperty> properties = new List<VariableProperty>();
FindAllProperties(model, properties);
foreach (VariableProperty property in properties)
{
string value = property.ValueWithArrayHandling.ToString();
if (value != string.Empty)
{
if (value != null && property.DataType == typeof(DateTime))
{
value = ((DateTime)property.Value).ToString("yyyy-MM-dd HH:mm:ss");
}
bool showTotal = !double.IsNaN(property.Total);
initialConditionsTable.Rows.Add(new object[]
{
relativeModelPath,
property.Name,
property.Description,
property.DataType.Name,
property.Units,
property.Format,
showTotal,
value
});
}
}
}
// Write to data store.
DataStore dataStore = new DataStore(simulation);
dataStore.DeleteOldContentInTable(simulation.Name, "InitialConditions");
dataStore.WriteTable(simulation.Name, "InitialConditions", initialConditionsTable);
dataStore.Disconnect();
}
/// <summary>
/// Create an initial conditions table in the DataStore.
/// </summary>
private void CreateInitialConditionsTable()
{
ReportColumnWithValues modelPath = new ReportColumnWithValues("ModelPath");
ReportColumnWithValues name = new ReportColumnWithValues("Name");
ReportColumnWithValues description = new ReportColumnWithValues("Description");
ReportColumnWithValues dataType = new ReportColumnWithValues("DataType");
ReportColumnWithValues units = new ReportColumnWithValues("Units");
ReportColumnWithValues displayFormat = new ReportColumnWithValues("DisplayFormat");
ReportColumnWithValues showTotal = new ReportColumnWithValues("Total");
ReportColumnWithValues value = new ReportColumnWithValues("Value");
ReportTable table = new Report.ReportTable();
table.FileName = Path.ChangeExtension(Simulation.FileName, ".db");
table.SimulationName = Simulation.Name;
table.TableName = "InitialConditions";
table.Columns.Add(modelPath);
table.Columns.Add(name);
table.Columns.Add(description);
table.Columns.Add(dataType);
table.Columns.Add(units);
table.Columns.Add(displayFormat);
table.Columns.Add(showTotal);
table.Columns.Add(value);
modelPath.Add(Apsim.FullPath(Simulation));
name.Add("Simulation name");
description.Add("Simulation name");
dataType.Add("String");
units.Add(string.Empty);
displayFormat.Add(string.Empty);
showTotal.Add(0);
value.Add(Simulation.Name);
modelPath.Add(Apsim.FullPath(Simulation));
name.Add("APSIM version");
description.Add("APSIM version");
dataType.Add("String");
units.Add(string.Empty);
displayFormat.Add(string.Empty);
showTotal.Add(0);
value.Add(Simulation.ApsimVersion);
modelPath.Add(Apsim.FullPath(Simulation));
name.Add("Run on");
description.Add("Run on");
dataType.Add("String");
units.Add(string.Empty);
displayFormat.Add(string.Empty);
showTotal.Add(0);
value.Add(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
// Get all model properties and store in 'initialConditionsTable'
foreach (Model model in Apsim.FindAll(Simulation))
{
string relativeModelPath = Apsim.FullPath(model).Replace(Apsim.FullPath(Simulation) + ".", string.Empty);
List <VariableProperty> properties = new List <VariableProperty>();
FindAllProperties(model, properties);
foreach (VariableProperty property in properties)
{
string propertyValue = property.ValueWithArrayHandling.ToString();
if (propertyValue != string.Empty)
{
if (propertyValue != null && property.DataType == typeof(DateTime))
{
propertyValue = ((DateTime)property.Value).ToString("yyyy-MM-dd HH:mm:ss");
}
modelPath.Add(relativeModelPath);
name.Add(property.Name);
description.Add(property.Description);
dataType.Add(property.DataType.Name);
units.Add(property.Units);
displayFormat.Add(property.Format);
if (double.IsNaN(property.Total))
{
showTotal.Add(0);
}
else
{
showTotal.Add(1);
}
value.Add(propertyValue);
}
}
}
// Write to data store.
DataStore dataStore = new DataStore(Simulation);
dataStore.WriteTable(table);
dataStore.Disconnect();
}