/// <summary>
/// SQLite convered from DSS
/// https://github.com/usbr/convertdss
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void addSqLiteModel_Click(object sender, EventArgs e)
{
var dlg = new Reclamation.TimeSeries.ScenarioPicker.ScenarioPicker();
dlg.Text = "Select SqLite files";
dlg.Dialog.DefaultExt = ".db";
dlg.Dialog.Filter = "SQLite *.db|*.db|All Files|*.*";
dlg.Dialog.Title = "Open SQLite File (from DSS)";
try
{
DB.SuspendTreeUpdates();
var result = dlg.ShowDialog();
if (result == DialogResult.OK)
{
if (dlg.ScenariosChecked && dlg.ScenarioFiles.Count > 0)
{
//create scenarios
ShowAsBusy("Reading data");
var tblScen = DB.GetScenarios();
foreach (var item in dlg.ScenarioFiles)
{
string scenarioPath = ConnectionStringUtility.MakeFileNameRelative("FileName=" + item, DB.DataSource);
tblScen.AddScenarioRow(Path.GetFileNameWithoutExtension(item), true, scenarioPath, 0);
}
//add first file in the list to the tree
if (dlg.AddToTreeChecked)
{
SQLiteSeries.CreatePiscesTree(dlg.ScenarioFiles[0], CurrentFolder, DB);
}
DB.Server.SaveTable(tblScen);
DatabaseChanged();
}
else
if (dlg.AddToTreeChecked)
{
//add to tree, but not to scenairo list
ShowAsBusy("Reading data");
for (int i = 0; i < dlg.ScenarioFiles.Count; i++)
{
string fn = dlg.ScenarioFiles[i].ToString();
SQLiteSeries.CreatePiscesTree(fn, CurrentFolder, DB);
}
DatabaseChanged();
}
}
}
finally
{
ShowAsReady("Done with Modsim import");
DB.ResumeTreeUpdates();
}
}
private void AddBpaHydsimClick(object sender, EventArgs e)
{
var dlg = new Reclamation.TimeSeries.ScenarioPicker.ScenarioPicker();
dlg.Text = "Select Hydsim Output Files";
dlg.Dialog.DefaultExt = ".mdb";
dlg.Dialog.Filter = "BPA Hydsim Access (*.mdb, *.accdb)|*.mdb;*.accdb|All Files|*.*";
dlg.Dialog.Title = "Open BPA Hydsim Access File";
try
{
DB.SuspendTreeUpdates();
var result = dlg.ShowDialog();
if (result == DialogResult.OK)
{
if (dlg.ScenariosChecked && dlg.ScenarioFiles.Count > 0)
{
//create scenarios
ShowAsBusy("Reading Hydsim data");
var tblScen = DB.GetScenarios();
foreach (var item in dlg.ScenarioFiles)
{
string scenarioPath = ConnectionStringUtility.MakeFileNameRelative("FileName=" + item, DB.DataSource);
tblScen.AddScenarioRow(Path.GetFileNameWithoutExtension(item), true, scenarioPath, 0);
}
//add first file in the list to the tree
if (dlg.AddToTreeChecked)
{
var bpa = new BpaHydsim.BpaHydsimTreeAccess(dlg.ScenarioFiles[0], DB.DataSource, DB.NextSDI(), this.CurrentFolder.ID);
var tbl = bpa.CreateTree();
DB.Server.SaveTable(tbl);
}
DB.Server.SaveTable(tblScen);
DatabaseChanged();
}
else
if (dlg.AddToTreeChecked)
{
//add to tree, but not to scenairo list
ShowAsBusy("Reading Hydsim data");
for (int i = 0; i < dlg.ScenarioFiles.Count; i++)
{
string fn = dlg.ScenarioFiles[i].ToString();
var bpa = new BpaHydsim.BpaHydsimTreeAccess(fn, DB.DataSource, DB.NextSDI(), this.CurrentFolder.ID);
var tbl = bpa.CreateTree();
DB.Server.SaveTable(tbl);
}
DatabaseChanged();
}
}
}
finally
{
ShowAsReady("Done with Hydsim import");
DB.ResumeTreeUpdates();
}
}
private void AddBpaHydsimClick(object sender, EventArgs e)
{
var dlg = new Reclamation.TimeSeries.ScenarioPicker.ScenarioPicker();
dlg.Text = "Select Hydsim Output Files";
dlg.Dialog.DefaultExt = ".mdb";
dlg.Dialog.Filter = "BPA Hydsim Access (*.mdb, *.accdb)|*.mdb;*.accdb|All Files|*.*";
dlg.Dialog.Title = "Open BPA Hydsim Access File";
try
{
DB.SuspendTreeUpdates();
var result = dlg.ShowDialog();
if (result == DialogResult.OK)
{
if (dlg.ScenariosChecked && dlg.ScenarioFiles.Count > 0)
{
//create scenarios
ShowAsBusy("Reading Hydsim data");
var tblScen = DB.GetScenarios();
foreach (var item in dlg.ScenarioFiles)
{
string scenarioPath = ConnectionStringUtility.MakeFileNameRelative("FileName=" + item, DB.DataSource);
tblScen.AddScenarioRow(Path.GetFileNameWithoutExtension(item), true, scenarioPath,0);
}
//add first file in the list to the tree
if (dlg.AddToTreeChecked)
{
var bpa = new BpaHydsim.BpaHydsimTreeAccess(dlg.ScenarioFiles[0], DB.DataSource, DB.NextSDI(), this.CurrentFolder.ID);
var tbl = bpa.CreateTree();
DB.Server.SaveTable(tbl);
}
DB.Server.SaveTable(tblScen);
DatabaseChanged();
}
else
if (dlg.AddToTreeChecked)
{
//add to tree, but not to scenairo list
ShowAsBusy("Reading Hydsim data");
for (int i = 0; i < dlg.ScenarioFiles.Count; i++)
{
string fn = dlg.ScenarioFiles[i].ToString();
var bpa = new BpaHydsim.BpaHydsimTreeAccess(fn, DB.DataSource, DB.NextSDI(), this.CurrentFolder.ID);
var tbl = bpa.CreateTree();
DB.Server.SaveTable(tbl);
}
DatabaseChanged();
}
}
}
finally
{
ShowAsReady("Done with Hydsim import");
DB.ResumeTreeUpdates();
}
}
/// <summary>
/// SQLite convered from DSS
/// https://github.com/usbr/convertdss
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void addSqLiteModel_Click(object sender, EventArgs e)
{
var dlg = new Reclamation.TimeSeries.ScenarioPicker.ScenarioPicker();
dlg.Text = "Select SqLite files";
dlg.Dialog.DefaultExt = ".db";
dlg.Dialog.Filter = "SQLite *.db|*.db|All Files|*.*";
dlg.Dialog.Title = "Open SQLite File (from DSS)";
try
{
DB.SuspendTreeUpdates();
var result = dlg.ShowDialog();
if (result == DialogResult.OK)
{
if (dlg.ScenariosChecked && dlg.ScenarioFiles.Count > 0)
{
//create scenarios
ShowAsBusy("Reading data");
var tblScen = DB.GetScenarios();
foreach (var item in dlg.ScenarioFiles)
{
string scenarioPath = ConnectionStringUtility.MakeFileNameRelative("FileName=" + item, DB.DataSource);
tblScen.AddScenarioRow(Path.GetFileNameWithoutExtension(item), true, scenarioPath,0);
}
//add first file in the list to the tree
if (dlg.AddToTreeChecked)
{
SQLiteSeries.CreatePiscesTree(dlg.ScenarioFiles[0], CurrentFolder, DB);
}
DB.Server.SaveTable(tblScen);
DatabaseChanged();
}
else
if (dlg.AddToTreeChecked)
{
//add to tree, but not to scenairo list
ShowAsBusy("Reading data");
for (int i = 0; i < dlg.ScenarioFiles.Count; i++)
{
string fn = dlg.ScenarioFiles[i].ToString();
SQLiteSeries.CreatePiscesTree(fn, CurrentFolder, DB);
}
DatabaseChanged();
}
}
}
finally
{
ShowAsReady("Done with Modsim import");
DB.ResumeTreeUpdates();
}
}
