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); }