public void TransformationDeviceLoadCreationAndSaveTest()
{
using (var db = new DatabaseSetup(Utili.GetCurrentMethodAndClass()))
{
var tdlts =
new ObservableCollection <TransformationDeviceLoadType>();
var loadTypes = db.LoadLoadTypes();
TransformationDeviceLoadType.LoadFromDatabase(tdlts, db.ConnectionString, loadTypes, false);
// delete everything and check
tdlts.Clear();
db.ClearTable(TransformationDeviceLoadType.TableName);
TransformationDeviceLoadType.LoadFromDatabase(tdlts, db.ConnectionString, loadTypes, false);
(tdlts.Count).Should().Be(0);
// add one and load again
var tdlt = new TransformationDeviceLoadType(null, loadTypes[0], 1, 1,
db.ConnectionString, loadTypes[0].Name, TransformationFactorType.FixedFactor, Guid.NewGuid().ToStrGuid());
tdlt.SaveToDB();
TransformationDeviceLoadType.LoadFromDatabase(tdlts, db.ConnectionString, loadTypes, false);
(tdlts.Count).Should().Be(1);
// delete the loaded one
tdlts[0].DeleteFromDB();
tdlts.Clear();
TransformationDeviceLoadType.LoadFromDatabase(tdlts, db.ConnectionString, loadTypes, false);
(tdlts.Count).Should().Be(0);
db.Cleanup();
}
}
public void TransformationDeviceLoadCreationAndSaveTest()
{
using (var db = new DatabaseSetup(Utili.GetCurrentMethodAndClass()))
{
var tdlts = new ObservableCollection <TransformationDevice>();
var loadTypes = db.LoadLoadTypes();
var variables = db.LoadVariables();
TransformationDevice.LoadFromDatabase(tdlts, db.ConnectionString, loadTypes, variables, false);
// delete everything and check
tdlts.Clear();
db.ClearTable(TransformationDevice.TableName);
db.ClearTable(TransformationDeviceLoadType.TableName);
db.ClearTable(TransformationDeviceCondition.TableName);
db.ClearTable(TransformationFactorDatapoint.TableName);
TransformationDevice.LoadFromDatabase(tdlts, db.ConnectionString, loadTypes, variables, false);
(tdlts.Count).Should().Be(0);
// add one and load again
var tdlt = new TransformationDevice("tdlt", "desc", loadTypes[0], -1000000, 1000000,
db.ConnectionString, -100000, 100000, Guid.NewGuid().ToStrGuid());
tdlt.SaveToDB();
tdlt.AddOutTransformationDeviceLoadType(loadTypes[1], 2, TransformationFactorType.FixedFactor);
tdlt.AddTransformationDeviceCondition(variables[0], 0, 100);
tdlt.AddDataPoint(2, 1);
TransformationDevice.LoadFromDatabase(tdlts, db.ConnectionString, loadTypes, variables, false);
(tdlts.Count).Should().Be(1);
(tdlts[0].LoadTypesOut.Count).Should().Be(1);
(tdlts[0].Conditions.Count).Should().Be(1);
(tdlts[0].FactorDatapoints.Count).Should().Be(1);
// delete the loaded one
tdlts[0].DeleteTransformationLoadtypeFromDB(tdlts[0].LoadTypesOut[0]);
tdlts[0].DeleteTransformationDeviceCondition(tdlts[0].Conditions[0]);
tdlts[0].DeleteFactorDataPoint(tdlts[0].FactorDatapoints[0]);
(tdlts[0].LoadTypesOut.Count).Should().Be(0);
(tdlts[0].Conditions.Count).Should().Be(0);
(tdlts[0].FactorDatapoints.Count).Should().Be(0);
tdlts[0].DeleteFromDB();
tdlts.Clear();
TransformationDevice.LoadFromDatabase(tdlts, db.ConnectionString, loadTypes, variables, false);
(tdlts.Count).Should().Be(0);
var tdlt2 =
new ObservableCollection <TransformationDeviceLoadType>();
TransformationDeviceLoadType.LoadFromDatabase(tdlt2, db.ConnectionString, loadTypes, false);
(tdlt2.Count).Should().Be(0);
db.Cleanup();
}
}