public void TestCreateGetRelatedPersonByDependentFamilyMemberQuery_CheckProperties()
{
var spousePersonType = new DependentType
{
DependentTypeId = DependentType.Spouse.Id
};
var gender = new Gender
{
GenderId = Gender.Female.Id,
GenderName = Gender.Female.Value
};
var person = new Person
{
PersonId = 10,
GenderId = gender.GenderId,
Gender = gender
};
var dependent = new PersonDependent
{
DependentTypeId = spousePersonType.DependentTypeId,
DependentId = 2,
PersonId = person.PersonId,
FirstName = "firstName",
LastName = "lastName",
NameSuffix = "III",
GenderId = gender.GenderId,
Person = person
};
var status = new ParticipantStatus
{
ParticipantStatusId = 1,
Status = "status"
};
var participant = new Participant
{
Status = status,
Person = person,
};
context.ParticipantStatuses.Add(status);
person.Participations.Add(participant);
person.Family.Add(dependent);
context.People.Add(person);
context.PersonDependents.Add(dependent);
context.DependentTypes.Add(spousePersonType);
var result = PersonQueries.CreateGetRelatedPersonByDependentFamilyMemberQuery(context, dependent.DependentId).FirstOrDefault();
Assert.IsNotNull(result);
Assert.AreEqual(person.PersonId, result.PersonId);
}
public void TestCreateGetRelatedPersonByDependentFamilyMemberQuery_DepdendentDoesNotHaveFamily()
{
var spousePersonType = new DependentType
{
DependentTypeId = DependentType.Spouse.Id
};
var dependent = new PersonDependent
{
DependentId = 10,
DependentTypeId = spousePersonType.DependentTypeId,
DependentType = spousePersonType
};
context.PersonDependents.Add(dependent);
context.DependentTypes.Add(spousePersonType);
var result = PersonQueries.CreateGetRelatedPersonByDependentFamilyMemberQuery(context, dependent.DependentId).FirstOrDefault();
Assert.IsNull(result);
}
public void TestCreateGetRelatedPersonByDependentFamilyMemberQuery_DependentDoesNotHaveParticipantFamilyMember()
{
var spousePersonType = new DependentType
{
DependentTypeId = DependentType.Spouse.Id
};
var gender = new Gender
{
GenderId = Gender.Female.Id,
GenderName = Gender.Female.Value
};
var dependent = new PersonDependent
{
DependentId = 1,
PersonId = 10,
DependentTypeId = spousePersonType.DependentTypeId,
FirstName = "firstName",
LastName = "lastName",
NameSuffix = "III",
GenderId = gender.GenderId
};
var person = new Person
{
PersonId = 1,
Alias = "alias",
FamilyName = "family",
FirstName = "firstName",
GivenName = "givenName",
LastName = "lastName",
MiddleName = "middleName",
NamePrefix = "Mr.",
NameSuffix = "III",
Patronym = "patronym",
Gender = new Gender
{
GenderId = Gender.Female.Id,
GenderName = Gender.Female.Value
}
};
person.Family.Add(dependent);
var status = new ParticipantStatus
{
ParticipantStatusId = 1,
Status = "status"
};
var participant = new Participant
{
Status = status,
Person = person,
};
context.ParticipantStatuses.Add(status);
person.Participations.Add(participant);
context.People.Add(person);
context.PersonDependents.Add(dependent);
context.Genders.Add(person.Gender);
context.DependentTypes.Add(spousePersonType);
var result = PersonQueries.CreateGetRelatedPersonByDependentFamilyMemberQuery(context, dependent.DependentId).FirstOrDefault();
Assert.IsNull(result);
}
public void TestCreateGetRelatedPersonByDependentFamilyMemberQuery_DepdendentDoesNotExist()
{
var result = PersonQueries.CreateGetRelatedPersonByDependentFamilyMemberQuery(context, 0).FirstOrDefault();
Assert.IsNull(result);
}