private ResidentInformation MapDetailsToResidentInformation(Person person, Address address,
TenancyAgreement tenancyAgreement, ContactLink contactLink, int?contactKey)
{
var resident = person.ToDomain();
resident.UPRN = address?.UPRN;
resident.ResidentAddress = address?.ToDomain();
resident.TenancyReference = tenancyAgreement?.TagRef.Trim();
resident.ContactKey = contactKey.ToString();
resident.TenureType = (tenancyAgreement == null) ? null
: $"{tenancyAgreement.UhTenureTypeId.Trim()}: {tenancyAgreement.UhTenureType.Description.Trim()}";
if (contactLink == null)
{
return(resident);
}
var telephoneNumberForPerson = _UHContext
.TelephoneNumbers.Where(t => t.ContactID == contactLink.ContactID).ToList();
var emailAddressForPerson =
_UHContext.EmailAddresses.Where(c => c.ContactID == contactLink.ContactID).ToList();
AttachContactDetailsToPerson(resident, telephoneNumberForPerson, emailAddressForPerson);
return(resident);
}
public static void InsertTenancy(TenancyAgreement tenancyAgreement, SqlConnection db)
{
var commandText = @"INSERT INTO [dbo].[tenagree]
([tag_ref],[prop_ref],[house_ref],[cur_bal],[tenure],[rent],[service],[other_charge])
VALUES
(@tag_ref,@prop_ref,@house_ref,@cur_bal,@tenure, @rent, @service, @other_charge)";
var command = new SqlCommand(commandText, db);
command.Parameters.Add("@tag_ref", SqlDbType.Char);
command.Parameters["@tag_ref"].Value = tenancyAgreement.tag_ref;
command.Parameters.Add("@prop_ref", SqlDbType.Char);
command.Parameters["@prop_ref"].Value = tenancyAgreement.prop_ref;
command.Parameters.Add("@house_ref", SqlDbType.Char);
command.Parameters["@house_ref"].Value = tenancyAgreement.house_ref;
command.Parameters.Add("@cur_bal", SqlDbType.Char);
command.Parameters["@cur_bal"].Value = tenancyAgreement.cur_bal;
command.Parameters.Add("@tenure", SqlDbType.Char);
command.Parameters["@tenure"].Value = tenancyAgreement.tenure;
command.Parameters.Add("@rent", SqlDbType.Decimal);
command.Parameters["@rent"].Value = tenancyAgreement.rent;
command.Parameters.Add("@service", SqlDbType.Decimal);
command.Parameters["@service"].Value = tenancyAgreement.service;
command.Parameters.Add("@other_charge", SqlDbType.Decimal);
command.Parameters["@other_charge"].Value = tenancyAgreement.other_charge;
command.ExecuteNonQuery();
}
private static ResidentInformation MapToExpectedDomain(Person databaseEntity, Address address,
List <Phone> phoneNumber, List <Email> emailAddresses,
TenancyAgreement tenancy, string contactKey = "")
{
var domainEntity = databaseEntity.ToDomain();
domainEntity.ResidentAddress = address.ToDomain();
domainEntity.UPRN = address.UPRN;
domainEntity.PhoneNumber = phoneNumber;
domainEntity.Email = emailAddresses;
domainEntity.TenancyReference = tenancy.TagRef;
domainEntity.ContactKey = contactKey;
domainEntity.TenureType = (tenancy == null) ? null
: $"{tenancy.UhTenureTypeId.Trim()}: {tenancy.UhTenureType.Description.Trim()}";
return(domainEntity);
}
