public void SaveVessel()
{
// delete vessel info from Vessel table
new QueryContext(Config.DataConnectionString, "DELETE * FROM Vessel").ExecuteNonQuery();
// inserting scenario
var tankDb = new TankDb();
var vessel = new Vessel {
Name = "vessel 01", CertNo = "certno 01 "
};
tankDb.SaveVessel(vessel);
var actual = tankDb.GetVessel();
Assert.AreEqual(vessel.Name, actual.Name);
Assert.AreEqual(vessel.CertNo, actual.CertNo);
actual = new TankDb().GetVessel();
Assert.AreEqual(vessel.Name, actual.Name);
Assert.AreEqual(vessel.CertNo, actual.CertNo);
// updating scenario
vessel = new Vessel {
Name = "vessel 02", CertNo = "certno 02 "
};
tankDb.SaveVessel(vessel);
actual = tankDb.GetVessel();
Assert.AreEqual(vessel.Name, actual.Name);
Assert.AreEqual(vessel.CertNo, actual.CertNo);
actual = new TankDb().GetVessel();
Assert.AreEqual(vessel.Name, actual.Name);
Assert.AreEqual(vessel.CertNo, actual.CertNo);
}
public void Import()
{
var importer = new TankCapacityImporter {
AccessFile = ".\\Data\\Data.mdb"
};
importer.RawDataFiles.AddRange(new[] { ".\\Data\\tank 01 raw data.txt", ".\\Data\\tank 02 raw data.txt" });
importer.Import();
var tankDb = new TankDb();
var vessel = tankDb.GetVessel();
var tanks = tankDb.GetAllTanks();
var volItems = tankDb.GetAllOilVolumeItems();
Assert.AreEqual("imported vessel 01", vessel.Name);
Assert.AreEqual("imported cert 01", vessel.CertNo);
Assert.IsTrue(tanks.Any(t => t.Name == "imported tank 01"));
Assert.IsTrue(tanks.Any(t => t.Name == "imported tank 02"));
Assert.AreEqual(27 + 8, volItems.Count());
Assert.IsTrue(volItems.Any(v => v.TankName == "imported tank 01" && v.HInclination == -0.5m && v.VInclination == -0.6m && v.Height == 3m && v.Volume == 100m));
Assert.IsTrue(volItems.Any(v => v.TankName == "imported tank 01" && v.HInclination == -0.5m && v.VInclination == 0m && v.Height == 1m && v.Volume == 99m));
Assert.IsTrue(volItems.Any(v => v.TankName == "imported tank 01" && v.HInclination == 0m && v.VInclination == -0.3m && v.Height == 2m && v.Volume == 1099.2m));
Assert.IsTrue(volItems.Any(v => v.TankName == "imported tank 01" && v.HInclination == 0.5m && v.VInclination == 0m && v.Height == 2m && v.Volume == 2099.3m));
Assert.IsTrue(volItems.Any(v => v.TankName == "imported tank 02" && v.HInclination == -5m && v.VInclination == -6m && v.Height == 2m && v.Volume == 1m));
Assert.IsTrue(volItems.Any(v => v.TankName == "imported tank 02" && v.HInclination == 0m && v.VInclination == -3m && v.Height == 1m && v.Volume == 8m));
Assert.IsTrue(volItems.Any(v => v.TankName == "imported tank 02" && v.HInclination == 0m && v.VInclination == -3m && v.Height == 2m && v.Volume == 6m));
Assert.IsTrue(!volItems.Any(v => v.TankName == "imported tank 02" && v.HInclination == 0m && v.VInclination == -3m && v.Height == 2m && v.Volume == 8m));
}
