public void ReadPairedData3()
{
using (DssReader r = new DssReader(TestUtility.BasePath + "indexedPairedData1.dss"))
{
var p = r.GetPairedData("/excel/import/plugin//e/pairedData3CR/");
}
}
private static void Run(Options opts)
{
VerifyExportArgs(opts);
using (DssReader r = new DssReader(opts.DssFile))
{
object record;
ExcelWriter ew = new ExcelWriter(opts.ExcelFile);
for (int i = 0; i < opts.Paths.ToList <string>().Count; i++)
{
string sheet;
while (true)
{
sheet = "dssvue_import_" + ExcelTools.RandomString(5);
if (!ew.SheetExists(sheet))
{
break;
}
}
DssPath p = new DssPath(opts.Paths.ElementAt(i));
var type = r.GetRecordType(p);
if (type is RecordType.RegularTimeSeries || type is RecordType.IrregularTimeSeries)
{
record = r.GetTimeSeries(p);
ew.Write(record as TimeSeries, sheet);
}
else if (type is RecordType.PairedData)
{
record = r.GetPairedData(p.FullPath);
ew.Write(record as PairedData, sheet);
}
}
}
}
public void ReadPairedDataWithXY()
{
var path = "/FISHKILL CREEK/BEACON NY/FREQ-FLOW///USGS/";
using (DssReader r = new DssReader(TestUtility.BasePath + "sample7_units_xyz.dss"))
{
var pd = r.GetPairedData(path);
Assert.AreEqual(123, pd.LocationInformation.XOrdinate);
Assert.AreEqual(456, pd.LocationInformation.YOrdinate);
}
}
public void GetPairedDataV6()
{
var path = "/A/B/STAGE-FLOW//E/F/";
using (DssReader r = new DssReader(TestUtility.BasePath + "spd6.dss"))
{
var pd = r.GetPairedData(path);
Assert.AreEqual("FEET", pd.UnitsIndependent);
Assert.AreEqual("UNT", pd.TypeDependent);
Assert.AreEqual("CFS", pd.UnitsDependent);
Assert.AreEqual("UNT", pd.TypeDependent);
Assert.IsNotNull(pd);
}
}
public void GetHeaderInformationPairedData()
{
string dssFile = @".\tempdssfile.dss";
string srcFile = TestUtility.BasePath + @"benchmarks6\BaldEDmbrk.dss";
File.Delete(dssFile);
CopyAsReadWrite(srcFile, dssFile);
string path = @"/BALD EAGLE LOC HAV//LOCATION-ELEV//19FEB1999 2055/DAMBRKSIMBRCH/";
using (DssReader dss = new DssReader(dssFile))
{
DssPathCollection paths = dss.GetCatalog();
var dsspath = paths.FindExactPath(path);
var pd = dss.GetPairedData(dsspath.FullPath);
Assert.IsTrue(pd.UnitsDependent == "FEET");
Assert.IsTrue(pd.TypeDependent == "UNT");
}
}
public void GetPairedDataV7()
{
var path = "/a/b/stage-flow//e/f/";
using (DssReader r = new DssReader(TestUtility.BasePath + "spd7.dss"))
{
var pd = r.GetPairedData(path);
Assert.AreEqual("FEET", pd.UnitsIndependent);
Assert.AreEqual("UNT", pd.TypeDependent);
Assert.AreEqual("CFS", pd.UnitsDependent);
Assert.AreEqual("UNT", pd.TypeDependent);
var d = pd.Values[0][1];
Assert.IsNotNull(pd);
}
}
public void ReadPairedData()
{
var path = "/MY BASIN/DEER CREEK/STAGE-FLOW///USGS/";
using (DssReader r = new DssReader(TestUtility.BasePath + "sample7.dss"))
{
var pd = r.GetPairedData(path);
//Assert.AreEqual()
Assert.AreEqual("FEET", pd.UnitsIndependent);
Assert.AreEqual("UNT", pd.TypeDependent);
Assert.AreEqual("CFS", pd.UnitsDependent);
Assert.AreEqual("UNT", pd.TypeDependent);
Assert.AreEqual(0, pd.LocationInformation.CoordinateID);
}
}
public void ReadPairedDataWithMultipleCurves2()
{
var path = "/a/b/stage-flow//e/f/";
using (DssReader r = new DssReader(TestUtility.BasePath + "pdTest1.dss"))
{
var pd = r.GetPairedData(path);
Assert.AreEqual(2, pd.Values.Count);
Assert.AreEqual(1, pd.Values[0][0]);
Assert.AreEqual(11, pd.Values[0][1]);
Assert.AreEqual(111, pd.Values[0][2]);
Assert.AreEqual(1111, pd.Values[0][3]);
Assert.AreEqual(11111, pd.Values[0][4]);
Assert.AreEqual(2, pd.Values[1][0]);
Assert.AreEqual(22, pd.Values[1][1]);
Assert.AreEqual(222, pd.Values[1][2]);
Assert.AreEqual(2222, pd.Values[1][3]);
Assert.AreEqual(22222, pd.Values[1][4]);
Assert.AreEqual("duck1", pd.Labels[0]);
Assert.AreEqual("duck2", pd.Labels[1]);
//Assert.AreEqual()
Assert.AreEqual("ft", pd.UnitsIndependent);
Assert.AreEqual("UNT", pd.TypeDependent);
Assert.AreEqual("cfs", pd.UnitsDependent);
Assert.AreEqual("UNT", pd.TypeDependent);
Assert.AreEqual(0, pd.LocationInformation.CoordinateID);
}
}
private static void Run(Options opts)
{
if (opts.Command == "import")
{
VerifyImportArgs(opts);
ExcelReader er = new ExcelReader(opts.ExcelFile);
using (DssWriter w = new DssWriter(opts.DssFile))
{
if (opts.Sheets.ToList <string>().Count == 0)
{
for (int i = 0; i < er.WorksheetCount; i++)
{
var t = er.CheckType(i);
if (t is RecordType.RegularTimeSeries || t is RecordType.IrregularTimeSeries)
{
w.Write(er.Read(i) as TimeSeries);
}
else if (t is RecordType.PairedData)
{
w.Write(er.Read(i) as PairedData);
}
}
}
else
{
foreach (var sheet in opts.Sheets)
{
var t = er.CheckType(sheet);
if (t is RecordType.RegularTimeSeries || t is RecordType.IrregularTimeSeries)
{
w.Write(er.Read(sheet) as TimeSeries);
}
else if (t is RecordType.PairedData)
{
w.Write(er.Read(sheet) as PairedData);
}
}
}
}
}
else if (opts.Command == "export")
{
VerifyExportArgs(opts);
using (DssReader r = new DssReader(opts.DssFile))
{
object record;
ExcelWriter ew = new ExcelWriter(opts.ExcelFile);
if (opts.Sheets.ToList().Count == 0)
{
for (int i = 0; i < opts.Paths.ToList <string>().Count; i++)
{
string sheet = "dssvue_import_" + ExcelTools.RandomString(5);
DssPath p = new DssPath(opts.Paths.ElementAt(i));
var type = r.GetRecordType(p);
if (type is RecordType.RegularTimeSeries || type is RecordType.IrregularTimeSeries)
{
record = r.GetTimeSeries(p);
ew.Write(record as TimeSeries, sheet);
}
else if (type is RecordType.PairedData)
{
record = r.GetPairedData(p.FullPath);
ew.Write(record as PairedData, sheet);
}
}
}
else
{
for (int i = 0; i < opts.Sheets.ToList().Count; i++)
{
DssPath p = new DssPath(opts.Paths.ElementAt(i));
var type = r.GetRecordType(p);
if (type is RecordType.RegularTimeSeries || type is RecordType.IrregularTimeSeries)
{
record = r.GetTimeSeries(p);
ew.Write(record as TimeSeries, opts.Sheets.ElementAt(i));
}
else if (type is RecordType.PairedData)
{
record = r.GetPairedData(p.FullPath);
ew.Write(record as PairedData, opts.Sheets.ElementAt(i));
}
}
}
}
}
}