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