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));
}
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 AddOilVolumeItems()
{
var items = new[]
{
new OilVolume {
TankName = "tank 01", HInclination = 0.1m, VInclination = 0.2m, Height = 0.3m, Volume = 0.4m
},
new OilVolume {
TankName = "tank 02", HInclination = 5m, VInclination = 0.6m, Height = 0.7m, Volume = 0.8m
}
};
var tankDb = new TankDb();
tankDb.ClearOilVolumeItems();
tankDb.Add(items);
var actual = tankDb.GetAllOilVolumeItems();
Assert.AreEqual(2, actual.Count());
var item = actual.First(t => t.TankName.Equals("tank 01"));
Assert.AreEqual(0.4m, item.Volume);
Assert.AreEqual(0.3m, item.Height);
Assert.AreEqual(0.2m, item.VInclination);
Assert.AreEqual(0.1m, item.HInclination);
item = actual.First(t => t.TankName.Equals("tank 02"));
Assert.AreEqual(0.8m, item.Volume);
Assert.AreEqual(0.7m, item.Height);
Assert.AreEqual(0.6m, item.VInclination);
Assert.AreEqual(5m, item.HInclination);
// add more
items = new[]
{
new OilVolume {
TankName = "tank 03", HInclination = 0.09m, VInclination = 10m, Height = 1.1m, Volume = 1200m
}
};
tankDb.Add(items);
actual = tankDb.GetAllOilVolumeItems();
Assert.AreEqual(3, actual.Count());
item = actual.First(t => t.TankName.Equals("tank 03"));
Assert.AreEqual(1200m, item.Volume);
Assert.AreEqual(1.1m, item.Height);
Assert.AreEqual(10m, item.VInclination);
Assert.AreEqual(0.09m, item.HInclination);
actual = new TankDb().GetAllOilVolumeItems();
Assert.AreEqual(3, actual.Count());
item = actual.First(t => t.TankName.Equals("tank 03"));
Assert.AreEqual(1200m, item.Volume);
Assert.AreEqual(1.1m, item.Height);
Assert.AreEqual(10m, item.VInclination);
Assert.AreEqual(0.09m, item.HInclination);
}
public void ClearOilVolumeItems()
{
var tankDb = new TankDb();
tankDb.ClearOilVolumeItems();
var actual = tankDb.GetAllOilVolumeItems();
Assert.AreEqual(0, actual.Count());
actual = new TankDb().GetAllOilVolumeItems();
Assert.AreEqual(0, actual.Count());
}
public void ClearTanks()
{
var tankDb = new TankDb();
tankDb.ClearTanks();
var actual = tankDb.GetAllTanks();
Assert.AreEqual(0, actual.Count());
actual = new TankDb().GetAllTanks();
Assert.AreEqual(0, actual.Count());
}
public void AddTanks()
{
var tanks = new[]
{
new Tank {
Name = "tank 01", Height = 11.1m
},
new Tank {
Name = "tank 02", Height = 22.2m
}
};
var tankDb = new TankDb();
tankDb.ClearTanks();
tankDb.Add(tanks);
var actual = tankDb.GetAllTanks();
Assert.IsTrue(actual.Any(t => t.Name == "tank 01"));
Assert.IsTrue(actual.Any(t => t.Name == "tank 02"));
actual = new TankDb().GetAllTanks();
Assert.IsTrue(actual.Any(t => t.Name == "tank 01"));
Assert.IsTrue(actual.Any(t => t.Name == "tank 02"));
Assert.AreEqual(11.1m, actual.First(t => t.Name == "tank 01").Height);
Assert.AreEqual(22.2m, actual.First(t => t.Name == "tank 02").Height);
// add more
tanks = new[]
{
new Tank {
Name = "tank 03", Height = 33.3m
}
};
tankDb.Add(tanks);
actual = tankDb.GetAllTanks();
Assert.AreEqual(3, actual.Count());
Assert.IsTrue(actual.Any(t => t.Name == "tank 01"));
Assert.IsTrue(actual.Any(t => t.Name == "tank 02"));
Assert.IsTrue(actual.Any(t => t.Name == "tank 03"));
Assert.AreEqual(33.3m, actual.First(t => t.Name == "tank 03").Height);
actual = new TankDb().GetAllTanks();
Assert.AreEqual(3, actual.Count());
Assert.IsTrue(actual.Any(t => t.Name == "tank 01"));
Assert.IsTrue(actual.Any(t => t.Name == "tank 02"));
Assert.IsTrue(actual.Any(t => t.Name == "tank 03"));
Assert.AreEqual(33.3m, actual.First(t => t.Name == "tank 03").Height);
}
private void LoadTanks()
{
this.ignoreCellValueChangedEvent = true;
try
{
this.Rows.Clear();
TankDb.GetAllTanks().Each(t =>
{
var row = new DataGridViewRow();
var rowIndex = this.Rows.Add(row);
this.Rows[rowIndex].Cells[colTankName.Index].Value = t.Name;
});
}
finally
{
this.ignoreCellValueChangedEvent = false;
}
}
public void SavePipes()
{
var pipes = new List <Pipe>
{
new Pipe {
Name = "pipe 01", Volume = 0.1m
},
new Pipe {
Name = "pipe 02", Volume = 2m
},
};
new TankDb().SaveVessel(new Vessel {
Name = "vessel 01", CertNo = "cert 01"
});
new TankDb().SavePipes(pipes);
var actual = new TankDb().GetVessel();
Assert.AreEqual(2, actual.Pipes.Count());
Assert.AreEqual(0.1m, actual.Pipes.First(p => p.Name == "pipe 01").Volume);
Assert.AreEqual(2m, actual.Pipes.First(p => p.Name == "pipe 02").Volume);
}
