public void TPH_BaseType()
{
using (var ctx = GetContext())
{
var mp = new MeteringPoint {
CreatedAt = DateTime.Now
};
ctx.Set <MeteringPoint>().Add(mp);
ctx.SaveChanges();
var contracts = new List <ContractBase>();
var c1 = new ContractFixed
{
AvpContractNr = "c_FIX",
PackageFixedId = 1,
PricesJson = "{}",
MeteringPointId = mp.Id,
ClientId = 5,
};
contracts.Add(c1);
var c2 = new ContractStock {
AvpContractNr = "c_STX", Margin = 0.001m, PackageStockId = 2, MeteringPointId = mp.Id
};
contracts.Add(c2);
var k1 = new ContractKomb1 {
AvpContractNr = "c_K1", PackageKomb1Id = 3, MeteringPointId = mp.Id
};
contracts.Add(k1);
var k2 = new ContractKomb2 {
AvpContractNr = "c_K2", PackageKomb2Id = 3, Part1Margin = 0.1m, MeteringPointId = mp.Id
};
contracts.Add(k2);
ctx.BulkInsert(contracts);
var c1db = ctx.FixedContracts.OrderByDescending(x => x.Id).First();
Assert.AreEqual(c1.AvpContractNr, c1db.AvpContractNr);
Assert.AreEqual(c1.PackageFixedId, c1db.PackageFixedId);
Assert.AreEqual(c1.PricesJson, c1db.PricesJson);
Assert.AreEqual(c1.MeteringPointId, c1db.MeteringPointId);
Assert.AreEqual(c1.ClientId, c1db.ClientId);
Assert.AreEqual(c1.ContractNr, c1db.ContractNr);
Assert.AreEqual(c1.ContractSignedAt, c1db.ContractSignedAt);
var k1db = ctx.K1Contracts.OrderByDescending(x => x.Id).First();
Assert.AreEqual(k1.AvpContractNr, k1db.AvpContractNr);
Assert.AreEqual(k1.PackageKomb1Id, k1db.PackageKomb1Id);
Assert.AreEqual(k1.AvpContractNr, k1db.AvpContractNr);
Assert.AreEqual(k1.MeteringPointId, k1db.MeteringPointId);
Assert.AreEqual(k1.ClientId, k1db.ClientId);
Assert.AreEqual(k1.ContractNr, k1db.ContractNr);
Assert.AreEqual(k1.ContractSignedAt, k1db.ContractSignedAt);
}
}
public void TPH_SubType_NotFirst()
{
using (var ctx = GetContext())
{
var mp = new MeteringPoint {
CreatedAt = DateTime.Now
};
ctx.Set <MeteringPoint>().Add(mp);
ctx.SaveChanges();
var contracts = new List <ContractKomb1>();
var k1 = new ContractKomb1 {
AvpContractNr = "c_K1", PackageKomb1Id = 3, MeteringPointId = mp.Id
};
contracts.Add(k1);
ctx.BulkInsert(contracts);
var k1db = ctx.K1Contracts.OrderByDescending(x => x.Id).First();
Assert.AreEqual(k1.AvpContractNr, k1db.AvpContractNr);
Assert.AreEqual(k1.PackageKomb1Id, k1db.PackageKomb1Id);
Assert.AreEqual(k1.AvpContractNr, k1db.AvpContractNr);
Assert.AreEqual(k1.MeteringPointId, k1db.MeteringPointId);
Assert.AreEqual(k1.ClientId, k1db.ClientId);
Assert.AreEqual(k1.ContractNr, k1db.ContractNr);
Assert.AreEqual(k1.ContractSignedAt, k1db.ContractSignedAt);
}
}
public void TPH_SubType_NotFirst()
{
using (var ctx = GetContext())
{
var contracts = new List <ContractKomb1>();
var k1 = new ContractKomb1 {
AvpContractNr = "c_K1", PackageKomb1Id = 3
};
contracts.Add(k1);
ctx.BulkInsert(contracts);
var k1db = ctx.K1Contracts.OrderByDescending(x => x.Id).First();
Assert.AreEqual(k1.AvpContractNr, k1db.AvpContractNr);
Assert.AreEqual(k1.PackageKomb1Id, k1db.PackageKomb1Id);
Assert.AreEqual(k1.AvpContractNr, k1db.AvpContractNr);
Assert.AreEqual(k1.MeteringPointId, k1db.MeteringPointId);
Assert.AreEqual(k1.ClientId, k1db.ClientId);
Assert.AreEqual(k1.ContractNr, k1db.ContractNr);
Assert.AreEqual(k1.ContractSignedAt, k1db.ContractSignedAt);
}
}
