public static void CreatePiscesTree(string fileName, PiscesFolder root,
TimeSeriesDatabase db)
{
mi = new Model();
s_db = db;
sdi = db.NextSDI();
studyFolderID = sdi;
int parentID = root.ID;
seriesCatalog = new TimeSeriesDatabaseDataSet.SeriesCatalogDataTable();
if (File.Exists(fileName))
{
XYFileReader.Read(mi, fileName);
m_xyFilename = Path.GetFileNameWithoutExtension(fileName);
}
else
{
throw new FileNotFoundException("Modsim xy file is not found " + fileName);
}
string mdbJetName = Path.Combine(Path.GetDirectoryName(fileName), m_xyFilename + "OUTPUT.mdb");
string mdbAceName = Path.Combine(Path.GetDirectoryName(fileName), m_xyFilename + "OUTPUT.accdb");
if (File.Exists(mdbAceName))
{
m_databaseName = mdbAceName;
}
else
{
m_databaseName = mdbJetName;
}
if (File.Exists(m_databaseName))
{
m_db = new AccessDB(m_databaseName);
dir = Path.GetDirectoryName(Path.GetFullPath(m_databaseName));
//AddNewRow(sdi,parentID,true, "", mi.name, "");
AddNewRow(sdi, parentID, true, "", Path.GetFileNameWithoutExtension(fileName), "");
ReservoirsTree();
DemandsTree();
RiverLinksTree();
TotalsTree();
}
else
{
throw new FileNotFoundException(" MODSIM output not found " + m_databaseName);
}
//DataTableOutput.Write(seriesCatalog, @"C:\temp\a.csv",false);
db.Server.SaveTable(seriesCatalog);
db.RefreshFolder(root);
}
private void ReadFromModsim(DateTime t1, DateTime t2)
{
Units = m_defaultUnits;
if (IsInputDataType())
{
Logger.WriteLine("Reading: Modsim " + modsimName + " " + timeSeriesName + " in " + m_xyFilename);
}
else
{
Logger.WriteLine("Reading: Modsim " + modsimName + " " + timeSeriesName + " in " + m_databaseName);
}
if (!File.Exists(m_databaseName))
{
Logger.WriteLine("File not found: '" + m_databaseName + "'");
throw new FileNotFoundException();
}
// reads from modsim input (.xy) or output (.mdb) depending on timeSeriesName
if (IsInputDataType())
{
if (m_mi == null)
{
m_mi = new Model();
m_mi.fname = m_xyFilename;
}
XYFileReader.Read(m_mi, m_mi.fname);
ModsimInput(modsimName, t1, t2);//, timeSeriesName);
}
else
{
if (File.Exists(m_databaseName))
{
ReadModsimOutput(modsimName, timeSeriesName, t1, t2);
}
}
}
