public void WithNameAndPostCodeQueryParameterReturnsMatchingResident()
{
var person1 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(firstName: "ciasom");
var person2 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(firstName: "wrong name");
var person3 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(firstName: "ciasom");
DatabaseContext.Persons.Add(person1);
DatabaseContext.Persons.Add(person2);
DatabaseContext.Persons.Add(person3);
DatabaseContext.SaveChanges();
var address = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person1.Id, postCode: "E8 1DY");
var address2 = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person2.Id, postCode: "E8 1DY");
var address3 = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person2.Id, postCode: "E8 5RT");
DatabaseContext.Addresses.Add(address);
DatabaseContext.Addresses.Add(address2);
DatabaseContext.Addresses.Add(address3);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, firstname: "ciasom", postcode: "E8 1DY");
listOfPersons.Count.Should().Be(1);
listOfPersons.First().MosaicId.Should().Be(person1.Id.ToString());
listOfPersons.First().AddressList.Should().ContainEquivalentOf(address.ToResponse());
}
public void WithAddressQueryParameterReturnsMatchingResident(string addressQuery)
{
var person1 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
var person2 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.Add(person1);
DatabaseContext.Persons.Add(person2);
DatabaseContext.SaveChanges();
var address = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person1.Id, address: "1 My Street, Hackney, London");
var address2 = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person2.Id, address: "5 Another Street, Lambeth, London");
DatabaseContext.Addresses.Add(address);
DatabaseContext.Addresses.Add(address2);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, address: addressQuery);
listOfPersons.Count.Should().Be(1);
listOfPersons
.First(p => p.MosaicId.Equals(person1.Id.ToString()))
.AddressList
.Should().ContainEquivalentOf(address.ToDomain());
}
public void IfThereAreNoResidentPhoneNumbersWillReturnNullForPhoneNumbers()
{
var person = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.Add(person);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, id: person.Id);
listOfPersons.First().PhoneNumber.Should().BeNull();
}
public void ExecuteGetReturnsGetPersonResponseWhenPersonIsFound()
{
var request = GetValidGetPersonRequest();
var person = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
_mockDataBaseGateway.Setup(x => x.GetPersonDetailsById(request.Id)).Returns(person);
var response = _residentUseCase.GetResident(request);
response.Should().BeOfType <GetPersonResponse>();
}
public void WildcardSearchWithNameQueryParametersReturnsMatchingResident()
{
var person = DatabaseGatewayHelper.CreatePersonDatabaseEntity(firstName: "ciasom", lastName: "Tessellate");
DatabaseContext.Persons.Add(person);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, firstname: "ciasom", lastname: "ssellat");
listOfPersons.Count.Should().Be(1);
listOfPersons.First().MosaicId.Should().Be(person.Id.ToString());
}
public void WhenNoMatchingIDReturnsEmptyList()
{
var person = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.Add(person);
DatabaseContext.SaveChanges();
var response = _caseStatusGateway.GetCaseStatusesByPersonId(person.Id);
response.Should().BeEmpty();
}
public void WildcardSearchWithLastNameQueryParameterReturnsMatchingResident()
{
var person1 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(lastName: "tessellate");
var person2 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(lastName: "Tessellate");
DatabaseContext.Persons.Add(person1);
DatabaseContext.Persons.Add(person2);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, lastname: "sell");
listOfPersons.Count.Should().Be(2);
listOfPersons.Should().ContainEquivalentOf(DatabaseContext.Persons.First(x => x.Id == person1.Id).ToResidentInformationResponse());
listOfPersons.Should().ContainEquivalentOf(DatabaseContext.Persons.First(x => x.Id == person2.Id).ToResidentInformationResponse());
}
public void ReturnsTotalPersonCountForGivenFilterIgnoringPagingAndCursor()
{
var person1 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(firstName: "foo");
var person2 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(firstName: "foobar");
var person3 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(firstName: "foobarbar");
DatabaseContext.Persons.AddRange(new List <Person> {
person1, person2, person3
});
DatabaseContext.SaveChanges();
var(_, totalCount) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 1, firstname: "foo");
totalCount.Should().Be(3);
}
public void IfThereAreResidentsWithGivenMosaicIdThenReturnsThem()
{
var person1 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
var person2 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
var person3 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.AddRange(new List <Person> {
person1, person2, person3
});
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, id: person2.Id);
listOfPersons.Count.Should().Be(1);
listOfPersons.First().MosaicId.Should().Be(person2.Id.ToString());
}
public void GetAllResidentsWithPostCodeQueryParameterReturnsEmptyListWhenNoMatchingResidentsWithPostcodeInDisplayAddressAreFound()
{
var person = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.Add(person);
DatabaseContext.SaveChanges();
var address = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person.Id, postCode: "E83 AS", isDisplayAddress: "N");
DatabaseContext.Addresses.Add(address);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, postcode: "E83 AS");
listOfPersons.Should().BeEmpty();
}
public void IfThereAreMultipleAddressesReturnsTheUprnForTheCurrentAddress()
{
var person = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.Add(person);
DatabaseContext.SaveChanges();
var oldAddress = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person.Id, endDate: DateTime.Now);
var currentAddress = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person.Id);
DatabaseContext.Addresses.Add(oldAddress);
DatabaseContext.Addresses.Add(currentAddress);
DatabaseContext.SaveChanges();
var(response, _) = _classUnderTest.GetResidentsBySearchCriteria(0, 20);
response.First().Uprn.Should().Be(currentAddress.Uprn.ToString());
}
public void IfThereAreResidentsWillReturnThem()
{
var person1 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
var person2 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
var person3 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.AddRange(new List <Person>()
{
person1, person2, person3
});
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20);
listOfPersons.Should().ContainEquivalentOf(DatabaseContext.Persons.First(x => x.Id == person1.Id).ToResidentInformationResponse());
listOfPersons.Should().ContainEquivalentOf(DatabaseContext.Persons.First(x => x.Id == person2.Id).ToResidentInformationResponse());
listOfPersons.Should().ContainEquivalentOf(DatabaseContext.Persons.First(x => x.Id == person3.Id).ToResidentInformationResponse());
}
public void WithPostCodeQueryParameterIgnoresFormatting(string postcode)
{
var person = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.Add(person);
DatabaseContext.SaveChanges();
var address = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person.Id, postCode: postcode);
DatabaseContext.Addresses.Add(address);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, postcode: "E8 1DY");
listOfPersons.Count.Should().Be(1);
listOfPersons.First().MosaicId.Should().Be(person.Id.ToString());
listOfPersons.First().AddressList.Should().ContainEquivalentOf(address.ToResponse());
}
public void DoesNotReturnPersonRecordsMarkedForDeletion()
{
var person1 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
var person2 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(markedForDeletion: true);
var person3 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.AddRange(new List <Person> {
person1, person2, person3
});
DatabaseContext.SaveChanges();
var(response, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20);
response.Count.Should().Be(2);
response.Any(x => x.MosaicId == person1.Id.ToString()).Should().BeTrue();
response.Any(x => x.MosaicId == person2.Id.ToString()).Should().BeFalse();
response.Any(x => x.MosaicId == person3.Id.ToString()).Should().BeTrue();
}
public void WithBirthdayQueryParameterReturnsMatchingResidents()
{
var person1 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
var person2 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
var person3 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
person3.DateOfBirth = person1.DateOfBirth;
DatabaseContext.Persons.AddRange(new List <Person> {
person1, person2, person3
});
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, dateOfBirth: person1.DateOfBirth.Value.ToString("yyyy-MM-dd")); //Format passed by FE
listOfPersons.Count.Should().Be(2);
listOfPersons.Should().ContainEquivalentOf(DatabaseContext.Persons.First(x => x.Id == person1.Id).ToResidentInformationResponse());
listOfPersons.Should().ContainEquivalentOf(DatabaseContext.Persons.First(x => x.Id == person3.Id).ToResidentInformationResponse());
}
public void IfThereAreResidentAddressesWillReturnThem()
{
var person = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.Add(person);
DatabaseContext.SaveChanges();
var address = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person.Id);
DatabaseContext.Addresses.Add(address);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20);
listOfPersons
.Where(p => p.MosaicId.Equals(person.Id.ToString()))
.First()
.AddressList
.Should().ContainEquivalentOf(address.ToResponse());
}
public void ReturnsResidentsUprn()
{
var person = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.Add(person);
DatabaseContext.SaveChanges();
var address = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person.Id);
DatabaseContext.Addresses.Add(address);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(0, 20);
listOfPersons
.First(p => p.MosaicId.Equals(person.Id.ToString()))
.Uprn
.Should().Be(address.Uprn.ToString());
}
public void IfThereAreResidentPhoneNumbersWillReturnThem()
{
var person = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.Add(person);
DatabaseContext.SaveChanges();
var phoneNumber = DatabaseGatewayHelper.CreatePhoneNumberEntity(personId: person.Id);
DatabaseContext.PhoneNumbers.Add(phoneNumber);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(0, 20);
listOfPersons
.Where(p => p.MosaicId.Equals(phoneNumber.Person.Id.ToString()))
.First()
.PhoneNumber
.Should().ContainEquivalentOf(phoneNumber.ToResponse());
}
public void GetAllResidentsWithPostCodeQueryParameterReturnsOnlyResidentsWithPostcodeInDisplayAddress()
{
var person1 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
var person2 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.Add(person1);
DatabaseContext.Persons.Add(person2);
DatabaseContext.SaveChanges();
var address1 = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person1.Id, postCode: "E83 AS");
var address2 = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person2.Id, postCode: "E83 AS", isDisplayAddress: "N");
DatabaseContext.Addresses.Add(address1);
DatabaseContext.Addresses.Add(address2);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, postcode: "E83 AS");
listOfPersons.Count.Should().Be(1);
listOfPersons.First().MosaicId.Should().Be(person1.Id.ToString());
}
public void WithPostCodeQueryParameterReturnsPhoneNumberWithResidentInformation()
{
var person = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.Add(person);
DatabaseContext.SaveChanges();
var address = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person.Id, postCode: "E8 1DY");
var phoneNumber = DatabaseGatewayHelper.CreatePhoneNumberEntity(person.Id);
DatabaseContext.Addresses.Add(address);
DatabaseContext.PhoneNumbers.Add(phoneNumber);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, postcode: "E8 1DY");
var personUnderTest = listOfPersons
.First(p => p.MosaicId.Equals(person.Id.ToString()));
personUnderTest.PhoneNumber.Should().ContainEquivalentOf(phoneNumber.ToResponse());
}
public void GetAllResidentsWithPostCodeQueryParameterReturnsMatchingResident()
{
var person = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.Add(person);
DatabaseContext.SaveChanges();
var address1 = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person.Id, postCode: "E8 1DY");
var address2 = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person.Id, postCode: "E8 5TG");
DatabaseContext.Addresses.Add(address1);
DatabaseContext.Addresses.Add(address2);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, postcode: "E8 1DY");
listOfPersons.Count.Should().Be(1);
listOfPersons
.First(p => p.MosaicId.Equals(address1.Person.Id.ToString()))
.AddressList
.Should().ContainEquivalentOf(address1.ToDomain());
}
public void WithPostCodeQueryParameterWhenAPersonHasTwoAddressesReturnsOneRecordWithAListOfAddresses()
{
var person1 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
var person2 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
DatabaseContext.Persons.Add(person1);
DatabaseContext.Persons.Add(person2);
DatabaseContext.SaveChanges();
var address = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person1.Id, postCode: "E8 1DY");
var address2 = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: person1.Id, postCode: "E8 1DY");
DatabaseContext.Addresses.Add(address);
DatabaseContext.Addresses.Add(address2);
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, postcode: "E8 1DY");
listOfPersons.Count.Should().Be(1);
listOfPersons
.First(p => p.MosaicId.Equals(person1.Id.ToString()))
.AddressList.Count
.Should().Be(2);
}
public void OnlyReturnsTheMatchingResidentsForGivenLimitAndCursor()
{
var person1 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(personId: 1);
var person2 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(personId: 2);
var person3 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(personId: 3);
var person4 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(personId: 4);
var person5 = DatabaseGatewayHelper.CreatePersonDatabaseEntity(personId: 5);
DatabaseContext.Persons.AddRange(new List <Person>()
{
person1, person2, person3, person4, person5
});
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 2, limit: 3);
listOfPersons.Count.Should().Be(3);
listOfPersons
.Select(p => p.MosaicId)
.Should().BeEquivalentTo(new List <string> {
"3", "4", "5"
});
}
public void WithContextFlagQueryParameterReturnsMatchingResidents()
{
var person1 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
person1.AgeContext = "A";
var person2 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
person2.AgeContext = "C";
var person3 = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
person3.AgeContext = "A";
DatabaseContext.Persons.AddRange(new List <Person> {
person1, person2, person3
});
DatabaseContext.SaveChanges();
var(listOfPersons, _) = _classUnderTest.GetResidentsBySearchCriteria(cursor: 0, limit: 20, contextflag: "A");
listOfPersons.Count.Should().Be(2);
listOfPersons.Should().ContainEquivalentOf(DatabaseContext.Persons.First(x => x.Id == person1.Id).ToResidentInformationResponse());
listOfPersons.Should().ContainEquivalentOf(DatabaseContext.Persons.First(x => x.Id == person3.Id).ToResidentInformationResponse());
}
public void CanMapPersonDetailsToGetPersonResponse()
{
Person person = DatabaseGatewayHelper.CreatePersonDatabaseEntity();
person.Id = 123;
Address address = DatabaseGatewayHelper.CreateAddressDatabaseEntity(person.Id);
//set to display address
address.IsDisplayAddress = "Y";
PhoneNumber phoneNumber1 = DatabaseGatewayHelper.CreatePhoneNumberEntity(person.Id);
PhoneNumber phoneNumber2 = DatabaseGatewayHelper.CreatePhoneNumberEntity(person.Id);
PersonOtherName otherName1 = DatabaseGatewayHelper.CreatePersonOtherNameDatabaseEntity(person.Id);
PersonOtherName otherName2 = DatabaseGatewayHelper.CreatePersonOtherNameDatabaseEntity(person.Id);
person.Addresses = new List <Address>
{
address
};
person.PhoneNumbers = new List <PhoneNumber>
{
phoneNumber1,
phoneNumber2
};
person.OtherNames = new List <PersonOtherName>
{
otherName1,
otherName2
};
AddressDomain addressDomain = new AddressDomain()
{
Address = address.AddressLines,
Postcode = address.PostCode,
Uprn = address.Uprn
};
OtherName personOtherName1 = new OtherName()
{
FirstName = otherName1.FirstName,
LastName = otherName1.LastName
};
OtherName personOtherName2 = new OtherName()
{
FirstName = otherName2.FirstName,
LastName = otherName2.LastName
};
PhoneNumberDomain phoneNumberDomain1 = new PhoneNumberDomain()
{
Number = phoneNumber1.Number,
Type = phoneNumber1.Type
};
PhoneNumberDomain phoneNumberDomain2 = new PhoneNumberDomain()
{
Number = phoneNumber2.Number,
Type = phoneNumber2.Type
};
var expectedResponse = new GetPersonResponse()
{
EmailAddress = person.EmailAddress,
DateOfBirth = person.DateOfBirth.Value,
DateOfDeath = person.DateOfDeath.Value,
Address = addressDomain,
SexualOrientation = person.SexualOrientation,
ContextFlag = person.AgeContext,
CreatedBy = person.CreatedBy,
Ethnicity = person.Ethnicity,
FirstLanguage = person.FirstLanguage,
FirstName = person.FirstName,
Gender = person.Gender,
LastName = person.LastName,
NhsNumber = person.NhsNumber.Value,
Id = person.Id,
PreferredMethodOfContact = person.PreferredMethodOfContact,
Religion = person.Religion,
Restricted = person.Restricted,
Title = person.Title,
OtherNames = new List <OtherName>()
{
personOtherName1, personOtherName2
},
PhoneNumbers = new List <PhoneNumberDomain>()
{
phoneNumberDomain1, phoneNumberDomain2
}
};
var result = ResponseFactory.ToResponse(person);
result.Should().BeEquivalentTo(expectedResponse);
}
