public RevenueObjectRepositoryTests()
{
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseInMemoryDatabase(Guid.NewGuid().ToString("N"));
_context = new RevenueObjectContext(optionsBuilder);
_context.RevenueObject.Add(new Models.V1.RevenueObject
{
Id = Id,
BeginEffectiveDate = _newestEffectiveDate,
EffectiveStatus = "A",
TransactionId = 0,
Pin = PinWithSitus,
UnformattedPin = "UnformattedPin",
Ain = "Ain",
GeoCd = "GeoCd",
ClassCd = SysTypeClassCdId,
AreaCd = "AreaCd",
CountyCd = "CountyCd",
CensusTract = "Track",
CensusBlock = "Block",
XCoordinate = "XCoordinate",
YCoordinate = "YCoordinate",
ZCoordinate = "ZCoordinate",
RightEstate = 0,
RightType = 0,
RightDescription = 0,
Type = RevObjTypeParcel,
SubType = 0
});
_context.RevenueObject.Add(new Models.V1.RevenueObject
{
Id = Id,
BeginEffectiveDate = _olderEffectiveDate,
EffectiveStatus = "A",
TransactionId = 0,
Pin = "pin",
UnformattedPin = "UnformattedPin",
Ain = "Ain",
GeoCd = "GeoCd",
ClassCd = SysTypeClassCdId,
AreaCd = "AreaCd",
CountyCd = "CountyCd",
CensusTract = "Track",
CensusBlock = "Block",
XCoordinate = "XCoordinate",
YCoordinate = "YCoordinate",
ZCoordinate = "ZCoordinate",
RightEstate = 0,
RightType = 0,
RightDescription = 0,
Type = RevObjTypeParcel,
SubType = 0
});
_context.RevenueObject.Add(new Models.V1.RevenueObject
{
Id = Id,
BeginEffectiveDate = _oldestEffectiveDate,
EffectiveStatus = "A",
TransactionId = 0,
Pin = "pin",
UnformattedPin = "UnformattedPin",
Ain = "Ain",
GeoCd = "GeoCd",
ClassCd = SysTypeClassCdId,
AreaCd = "AreaCd",
CountyCd = "CountyCd",
CensusTract = "Track",
CensusBlock = "Block",
XCoordinate = "XCoordinate",
YCoordinate = "YCoordinate",
ZCoordinate = "ZCoordinate",
RightEstate = 0,
RightType = 0,
RightDescription = 0,
Type = RevObjTypeParcel,
SubType = 0
});
_context.RevenueObject.Add(new Models.V1.RevenueObject()
{
Id = RelatedRevenueObjectId,
BeginEffectiveDate = _newestEffectiveDate,
EffectiveStatus = "A",
Pin = RelatedRevenueObjectPin,
ClassCd = SysTypeClassCdId
});
_context.SysTypeCat.Add(new SysTypeCat
{
Id = SysTypeCatId,
BeginEffectiveDate = _newestEffectiveDate,
ShortDescription = SysTypeCatShortDescription,
EffectiveStatus = "A"
});
_context.SysTypeCat.Add(new SysTypeCat
{
Id = SysTypeCatId,
BeginEffectiveDate = _olderEffectiveDate,
ShortDescription = "older SysTypeCat description",
EffectiveStatus = "A"
});
_context.SysTypeCat.Add(new SysTypeCat
{
Id = SysTypeCatId,
BeginEffectiveDate = _oldestEffectiveDate,
ShortDescription = "oldest SysTypeCat description",
EffectiveStatus = "A"
});
_context.SysType.Add(new SysType
{
Id = SysTypeId,
EffectiveStatus = "A",
BeginEffectiveDate = _newestEffectiveDate,
ShortDescription = SysTypeShortDescription,
SysTypeCatId = SysTypeCatId
});
_context.SysType.Add(new SysType
{
Id = SysTypeId,
EffectiveStatus = "A",
BeginEffectiveDate = _olderEffectiveDate,
ShortDescription = "older SysType description",
SysTypeCatId = SysTypeCatId
});
_context.SysType.Add(new SysType
{
Id = SysTypeId,
EffectiveStatus = "A",
BeginEffectiveDate = _oldestEffectiveDate,
ShortDescription = "oldest SysType description",
SysTypeCatId = SysTypeCatId
});
_context.SysType.Add(new SysType
{
Id = RevObjTypeParcel,
EffectiveStatus = "A",
BeginEffectiveDate = _oldestEffectiveDate,
ShortDescription = SysTypeShortDescrParcel,
SysTypeCatId = SysTypeCatId
});
_context.SysType.Add(new SysType()
{
Id = SysTypeClassCdId,
Description = SysTypeClassCdDescr,
EffectiveStatus = "A",
BeginEffectiveDate = _newestEffectiveDate
});
_context.TAG.Add(new TAG
{
Id = TagId,
BeginEffectiveYear = NewestEffectiveYear,
EffectiveStatus = "A",
Description = TagDescription
});
_context.TAG.Add(new TAG
{
Id = TagId,
BeginEffectiveYear = OlderEffectiveYear,
EffectiveStatus = "A",
Description = "older TAG description"
});
_context.TAG.Add(new TAG
{
Id = TagId,
BeginEffectiveYear = OldestEffectiveYear,
EffectiveStatus = "A",
Description = "oldest TAG description"
});
_context.TAGRole.Add(new TAGRole
{
Id = 133,
BeginEffectiveDate = _newestEffectiveDate,
EffectiveStatus = "A",
ObjectType = SysTypeId,
ObjectId = Id,
TAGId = TagId
});
_context.TAGRole.Add(new TAGRole
{
Id = 133,
BeginEffectiveDate = _olderEffectiveDate,
EffectiveStatus = "A",
ObjectType = SysTypeId,
ObjectId = Id,
TAGId = OlderTagId
});
_context.TAGRole.Add(new TAGRole
{
Id = 133,
BeginEffectiveDate = _oldestEffectiveDate,
EffectiveStatus = "A",
ObjectType = SysTypeId,
ObjectId = Id,
TAGId = OldestTagId
});
_context.TAGRole.Add(new TAGRole
{
Id = 133,
BeginEffectiveDate = new DateTime(2017, 1, 1),
EffectiveStatus = "A",
ObjectType = SysTypeId,
ObjectId = Id,
TAGId = TagId
});
_context.SitusAddress.Add(new SitusAddress()
{
Id = SitusAddressId,
BeginEffectiveDate = _newestEffectiveDate,
EffectiveStatus = "A",
FreeFormAddress = _situsAddress.FreeFormAddress,
City = _situsAddress.City,
StateCode = _situsAddress.StateCode,
PostalCode = _situsAddress.PostalCode
});
_context.SitusAddressRole.Add(new SitusAddressRole()
{
Id = Id,
BeginEffectiveDate = _newestEffectiveDate,
EffectiveStatus = "A",
ObjectId = Id,
ObjectType = SysTypeId,
SitusAddressId = SitusAddressId,
PrimeAddr = 1
});
_context.DescriptionHeader.Add(new DescriptionHeader()
{
Id = DescHeaderId,
BeginEffectiveDate = _newestEffectiveDate,
DisplayDescription = DescHeaderDescription,
EffectiveStatus = "A",
RevenueObjectId = Id
});
_context.DescriptionHeader.Add(new DescriptionHeader()
{
Id = DescHeaderId,
BeginEffectiveDate = _olderEffectiveDate,
DisplayDescription = "baloney",
EffectiveStatus = "I",
RevenueObjectId = Id
});
_context.RelatedRevenueObject.Add(new RelatedRevenueObject()
{
Id = 23,
EffectiveStatus = "A",
BeginEffectiveDate = _newestEffectiveDate,
RevenueObject1Id = Id,
RevenueObject2Id = RelatedRevenueObjectId
});
_context.ClassCodeMap.Add(new ClassCodeMap()
{
Id = Id,
RollType = RelatedRevenueObjectRollType,
ClassCode = SysTypeClassCdId
});
_context.SaveChanges();
}
public RevenueObjectRepository(RevenueObjectContext revenueObjectContext)
{
_revenueObjectContext = revenueObjectContext;
}
public MarketAndRestrictedValueRepository(RevenueObjectContext revenueObjectContext)
{
_revenueObjectContext = revenueObjectContext;
}
