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)); }