private void AddHDBModel_Click(object sender, EventArgs e)
{
#if !PISCES_OPEN
var server = OracleServer.ConnectToOracle();
if (server == null)
{
return;
}
Hdb.Instance = new Hdb(server);
SelectHdbModel dlg = new SelectHdbModel();
if (dlg.ShowDialog() == DialogResult.OK && dlg.ModelID > 0)
{
// create tree for this model.
var folder = DB.AddFolder(CurrentFolder, dlg.ModelName + " " + dlg.ModelTable);
var tbl = HdbModelTreeBuilder.PiscesSeriesCatalog(dlg.ModelID, dlg.ModelTable, dlg.OldestModelRunDate, DB.NextSDI(), folder.ID);
if (tbl.Rows.Count == 0)
{
MessageBox.Show("No model runs found for model_id " + dlg.ModelID + " after " + dlg.OldestModelRunDate.ToString());
return;
}
DB.Server.SaveTable(tbl);
// create scenario list.
var scenarioTable = DB.GetScenarios();
var ref_model_run = Hdb.Instance.ref_model_run(dlg.ModelID, dlg.OldestModelRunDate);
foreach (DataRow item in ref_model_run.Rows)
{
string date = Convert.ToDateTime(item["run_date"]).ToShortDateString();
string model_run_name = item["model_run_name"].ToString();
string id = item["model_run_id"].ToString();
string path = HdbModelSeries.BuildScenairoPath(model_run_name, id, date);
string name = HdbModelSeries.BuildScenairoName(model_run_name, id, date);
scenarioTable.AddScenarioRow(name, true, path, 0);
}
DB.Server.SaveTable(scenarioTable);
DatabaseChanged();
}
#endif
}
private void AddHDBModel_Click(object sender, EventArgs e)
{
#if !PISCES_OPEN
var server = OracleServer.ConnectToOracle();
if (server == null)
return;
Hdb.Instance = new Hdb(server);
SelectHdbModel dlg = new SelectHdbModel();
if (dlg.ShowDialog() == DialogResult.OK && dlg.ModelID > 0)
{
// create tree for this model.
var folder = DB.AddFolder(CurrentFolder, dlg.ModelName + " " + dlg.ModelTable);
var tbl = HdbModelTreeBuilder.PiscesSeriesCatalog(dlg.ModelID, dlg.ModelTable, dlg.OldestModelRunDate, DB.NextSDI(), folder.ID);
if (tbl.Rows.Count == 0)
{
MessageBox.Show("No model runs found for model_id " + dlg.ModelID + " after " + dlg.OldestModelRunDate.ToString());
return;
}
DB.Server.SaveTable(tbl);
// create scenario list.
var scenarioTable = DB.GetScenarios();
var ref_model_run = Hdb.Instance.ref_model_run(dlg.ModelID, dlg.OldestModelRunDate);
foreach (DataRow item in ref_model_run.Rows)
{
string date = Convert.ToDateTime(item["run_date"]).ToShortDateString();
string model_run_name = item["model_run_name"].ToString();
string id = item["model_run_id"].ToString();
string path = HdbModelSeries.BuildScenairoPath(model_run_name, id, date);
string name = HdbModelSeries.BuildScenairoName(model_run_name, id, date);
scenarioTable.AddScenarioRow(name, true, path,0);
}
DB.Server.SaveTable(scenarioTable);
DatabaseChanged();
}
#endif
}
