public RepositoryTests()
{
var optionsBuilder = new DbContextOptionsBuilder <AssessmentEventContext>();
optionsBuilder.UseInMemoryDatabase(Guid.NewGuid().ToString("N"));
_context = new AssessmentEventContext(optionsBuilder);
_context.AssessmentEvent.Add(new AssessmentEvent
{
Id = AssessmentEventId,
TranId = 0,
DynCalcStepTrackingId = 0,
RevObjId = RevenueObjectId,
TaxYear = 0,
AsmtEventType = AssessmentEventTypeId,
EventDate = DateTime.Now
});
_context.AssessmentEventTransaction.Add(new AssessmentEventTransaction
{
Id = AssessmentEventTransactionId,
AsmtEventId = AssessmentEventId,
AsmtEventState = AssessmentEventStateId,
AsmtRevnEventId = 0
});
_context.AssessmentEventTransaction.Add(new AssessmentEventTransaction
{
Id = AssessmentEventTransactionId + 1,
AsmtEventId = AssessmentEventId,
AsmtEventState = AssessmentEventStateId,
AsmtRevnEventId = 0
});
_context.AssessmentEventValue.Add(new AssessmentEventValue
{
AsmtEventTranId = AssessmentEventValueBvs.AsmtEventTranId,
Attribute1 = AssessmentEventValueBvs.Attribute1,
Attribute2 = AssessmentEventValueBvs.Attribute2,
DynCalcStepTrackingId = AssessmentEventValueBvs.DynCalcStepTrackingId,
Id = AssessmentEventValueBvs.Id,
TaxYear = AssessmentEventValueBvs.TaxYear,
ValueAmount = AssessmentEventValueBvs.ValueAmount,
ValueTypeId = AssessmentEventValueBvs.ValueTypeId
});
_context.AssessmentEventValue.Add(new AssessmentEventValue
{
AsmtEventTranId = AssessmentEventValueBaseYear4Asmt.AsmtEventTranId,
Attribute1 = AssessmentEventValueBaseYear4Asmt.Attribute1,
Attribute2 = AssessmentEventValueBaseYear4Asmt.Attribute2,
DynCalcStepTrackingId = AssessmentEventValueBaseYear4Asmt.DynCalcStepTrackingId,
Id = AssessmentEventValueBaseYear4Asmt.Id,
TaxYear = AssessmentEventValueBaseYear4Asmt.TaxYear,
ValueAmount = AssessmentEventValueBaseYear4Asmt.ValueAmount,
ValueTypeId = AssessmentEventValueBaseYear4Asmt.ValueTypeId
});
_context.ValueType.Add(new ValueType
{
Id = 1000051,
ShortDescr = "BVS"
});
_context.ValueType.Add(new ValueType
{
Id = 1000052,
ShortDescr = "BVS2"
});
_context.ValueType.Add(new ValueType
{
Id = 1000053,
ShortDescr = "BVSValue"
});
_context.ValueType.Add(new ValueType
{
Id = 1000057,
ShortDescr = "BVSTrend"
});
_context.ValueType.Add(new ValueType
{
Id = 1000083,
ShortDescr = "BVSCalamity"
});
_context.ValueType.Add(new ValueType
{
Id = 1000097,
ShortDescr = "BVSTransfer"
});
_context.ValueType.Add(new ValueType
{
Id = 1000316,
ShortDescr = "BaseYear4Asmt"
});
_context.SysTypeCat.Add(new SysTypeCat
{
Id = SysTypeCatIdObjectType,
ShortDescription = "Object Type",
BeginEffectiveDate = new DateTime(1776, 1, 1),
EffectiveStatus = "A"
});
_context.SystemType.Add(new SystemType
{
Id = 470404,
begEffDate = new DateTime(1776, 07, 04),
shortDescr = "None",
descr = SystemTypeLongDescription
});
_context.SystemType.Add(new SystemType
{
Id = 470422,
begEffDate = new DateTime(1776, 07, 04),
shortDescr = "Other",
descr = SystemTypeLongDescription
});
_context.SystemType.Add(new SystemType
{
Id = 470426,
begEffDate = new DateTime(1776, 07, 04),
shortDescr = "Year",
descr = SystemTypeLongDescription
});
_context.SystemType.Add(new SystemType
{
Id = 470434,
begEffDate = new DateTime(1776, 07, 04),
shortDescr = "LegalPartyRole",
descr = SystemTypeLongDescription
});
_context.SystemType.Add(new SystemType
{
Id = 470436,
begEffDate = new DateTime(1776, 07, 04),
shortDescr = "AsmtEvent",
descr = SystemTypeLongDescription
});
_context.SystemType.Add(new SystemType
{
Id = 470475,
begEffDate = new DateTime(1776, 07, 04),
shortDescr = "RPAObject",
descr = SystemTypeLongDescription
});
_context.SystemType.Add(new SystemType
{
Id = AssessmentEventTypeId,
begEffDate = new DateTime(1776, 07, 04),
shortDescr = AssessmentEventTypeDescription,
descr = SystemTypeLongDescription
});
_context.SystemType.Add(new SystemType
{
Id = AssessmentEventTypeIdOlder,
begEffDate = new DateTime(1776, 07, 03),
shortDescr = AssessmentEventTypeDescriptionOlder,
descr = SystemTypeLongDescription
});
_context.SystemType.Add(new SystemType
{
Id = AssessmentEventStateId,
begEffDate = new DateTime(1776, 07, 04),
shortDescr = AssessmentEventStateDescription,
descr = SystemTypeLongDescription
});
_context.SystemType.Add(new SystemType
{
Id = AssessmentEventStateIdOlder,
begEffDate = new DateTime(1776, 07, 03),
shortDescr = AssessmentEventStateDescriptionOlder,
descr = SystemTypeLongDescription
});
_context.SystemType.Add(new SystemType
{
Id = ChangeReasonId,
begEffDate = new DateTime(1776, 07, 04),
descr = ChangeReason
});
_context.SystemType.Add(new SystemType
{
Id = SysTypeIdAsmtRevn,
shortDescr = "AsmtRevn",
begEffDate = new DateTime(1776, 01, 01),
effStatus = "A",
sysTypeCatId = SysTypeCatIdObjectType
});
_context.SystemType.Add(new SystemType
{
Id = SysTypePublicUse,
shortDescr = "Public use",
begEffDate = new DateTime(1776, 1, 1),
effStatus = "A"
});
_context.SystemType.Add(new SystemType
{
Id = SysTypeIdPrimaryBaseYearAttribute2,
descr = Attribute2DescriptionMultiple,
begEffDate = new DateTime(1776, 1, 1),
effStatus = "A"
});
_context.AssessmentRevision.Add(new AssessmentRevision
{
Id = AssessmentRevisionId,
ReferenceNumber = AssessmentRevisionReferenceNumber,
ValChangeReason = ChangeReasonId,
RevisionDate = _assessmentRevisionDate
});
_context.AssessmentRevisionEvent.Add(new AssessmentRevisionEvent
{
Id = AssessmentRevisionEventId,
AsmtRevnId = AssessmentRevisionId
});
_context.Note.Add(new Note
{
Id = 23223,
NoteText = NoteText,
BeginEffectiveDate = new DateTime(1776, 01, 01),
EffectiveStatus = "A",
ObjectType = SysTypeIdAsmtRevn,
ObjectId = AssessmentRevisionId,
Privacy = SysTypePublicUse
});
_context.SaveChanges();
}
public AssessmentEventRepository(AssessmentEventContext assessmentEventContext,
QueryOnlyAssessmentEventContext queryOnlyAssessmentEventContext)
{
_assessmentEventContext = assessmentEventContext;
_queryOnlyAssessmentEventContext = queryOnlyAssessmentEventContext;
}
public StatutoryReferenceRepository(AssessmentEventContext assessmentEventContext)
{
_assessmentEventContext = assessmentEventContext;
}
