public override void Modify(AddressRecord record)
        {
            DbCommand command = this.Provider.GetStoredProcedure("spInsertUpdateAddress");

            this.MapParameterIn(command, "@PA_USER_LOGIN_ID", "dev");
            this.MapParametersIn(command, record, true);
            this.Execute(command);
            this.MapParametersOut(command, record);
        }
        /// <summary>
        ///     Creates a new <see cref="AddressRecord" /> object instance that is a shallow-copy of the current object instance.
        /// </summary>
        /// <returns>
        ///     The shallow-copy of the current <see cref="AddressRecord" /> object instance.
        /// </returns>
        public AddressRecord Clone()
        {
            AddressRecord record = new AddressRecord();

            record.Id            = this.Id;
            record.Lock          = this.Lock;
            record.AddDate       = this.AddDate;
            record.AddBy         = this.AddBy;
            record.ModDate       = this.ModDate;
            record.ModBy         = this.ModBy;
            record.RcvDate       = this.RcvDate;
            record.RcvFrom       = this.RcvFrom;
            record.Building      = this.Building;
            record.Street        = this.Street;
            record.Town          = this.Town;
            record.Area          = this.Area;
            record.County        = this.County;
            record.Postcode      = this.Postcode;
            record.Country       = this.Country;
            record.CountryStyle  = this.CountryStyle;
            record.Mailstring    = this.Mailstring;
            record.Map           = this.Map;
            record.JoiningInstrc = this.JoiningInstrc;
            record.CountryValue  = this.CountryValue;
            record.CoCode        = this.CoCode;
            record.CoArea        = this.CoArea;
            record.CoRegion      = this.CoRegion;
            record.Userchar1     = this.Userchar1;
            record.Userchar2     = this.Userchar2;
            record.Userchar3     = this.Userchar3;
            record.DrtionText    = this.DrtionText;
            record.DrtionHtml    = this.DrtionHtml;
            record.LocationUrl   = this.LocationUrl;
            record.Phone         = this.Phone;
            record.Fax           = this.Fax;
            record.Email         = this.Email;
            record.CustomerAcc   = this.CustomerAcc;
            record.Line5         = this.Line5;
            record.PhoneStd      = this.PhoneStd;
            record.FaxStd        = this.FaxStd;
            record.Lat           = this.Lat;
            record.Long          = this.Long;
            record.GridEast      = this.GridEast;
            record.GridNorth     = this.GridNorth;
            record.BatId         = this.BatId;
            record.DxCode        = this.DxCode;
            record.DxExchange    = this.DxExchange;
            record.DxBarcode     = this.DxBarcode;
            record.MailsortCode  = this.MailsortCode;
            return(record);
        }
        /// <summary>
        ///     Indicates whether the current <see cref="AddressRecord" /> instance is equal to another <see cref="AddressRecord" /> instance.
        /// </summary>
        /// <param name="that">
        ///     The <see cref="AddressRecord" /> instance to be compared against this instance.
        /// </param>
        /// <returns>
        ///     True if both instances are considered equal; otherwise, false.
        /// </returns>
        public Boolean Equals(AddressRecord that)
        {
            Boolean result = true;

            result = result && (this.Id.TrimOrNullify() == that.Id.TrimOrNullify());
            result = result && (this.Lock.TrimOrNullify() == that.Lock.TrimOrNullify());
            result = result && (this.Building.TrimOrNullify() == that.Building.TrimOrNullify());
            result = result && (this.Street.TrimOrNullify() == that.Street.TrimOrNullify());
            result = result && (this.Town.TrimOrNullify() == that.Town.TrimOrNullify());
            result = result && (this.Area.TrimOrNullify() == that.Area.TrimOrNullify());
            result = result && (this.County.TrimOrNullify() == that.County.TrimOrNullify());
            result = result && (this.Postcode.TrimOrNullify() == that.Postcode.TrimOrNullify());
            result = result && (this.Country.TrimOrNullify() == that.Country.TrimOrNullify());
            result = result && (this.CountryStyle.TrimOrNullify() == that.CountryStyle.TrimOrNullify());
            result = result && (this.Mailstring.TrimOrNullify() == that.Mailstring.TrimOrNullify());
            result = result && (this.Map.TrimOrNullify() == that.Map.TrimOrNullify());
            result = result && (this.JoiningInstrc.TrimOrNullify() == that.JoiningInstrc.TrimOrNullify());
            result = result && (this.CountryValue == that.CountryValue);
            result = result && (this.CoCode.TrimOrNullify() == that.CoCode.TrimOrNullify());
            result = result && (this.CoArea.TrimOrNullify() == that.CoArea.TrimOrNullify());
            result = result && (this.CoRegion.TrimOrNullify() == that.CoRegion.TrimOrNullify());
            result = result && (this.Userchar1.TrimOrNullify() == that.Userchar1.TrimOrNullify());
            result = result && (this.Userchar2.TrimOrNullify() == that.Userchar2.TrimOrNullify());
            result = result && (this.Userchar3.TrimOrNullify() == that.Userchar3.TrimOrNullify());
            result = result && (this.DrtionText.TrimOrNullify() == that.DrtionText.TrimOrNullify());
            result = result && (this.DrtionHtml.TrimOrNullify() == that.DrtionHtml.TrimOrNullify());
            result = result && (this.LocationUrl.TrimOrNullify() == that.LocationUrl.TrimOrNullify());
            result = result && (this.Phone.TrimOrNullify() == that.Phone.TrimOrNullify());
            result = result && (this.Fax.TrimOrNullify() == that.Fax.TrimOrNullify());
            result = result && (this.Email.TrimOrNullify() == that.Email.TrimOrNullify());
            result = result && (this.CustomerAcc.TrimOrNullify() == that.CustomerAcc.TrimOrNullify());
            result = result && (this.Line5.TrimOrNullify() == that.Line5.TrimOrNullify());
            result = result && (this.PhoneStd.TrimOrNullify() == that.PhoneStd.TrimOrNullify());
            result = result && (this.FaxStd.TrimOrNullify() == that.FaxStd.TrimOrNullify());
            result = result && (this.Lat == that.Lat);
            result = result && (this.Long == that.Long);
            result = result && (this.GridEast.TrimOrNullify() == that.GridEast.TrimOrNullify());
            result = result && (this.GridNorth.TrimOrNullify() == that.GridNorth.TrimOrNullify());
            result = result && (this.BatId.TrimOrNullify() == that.BatId.TrimOrNullify());
            result = result && (this.DxCode.TrimOrNullify() == that.DxCode.TrimOrNullify());
            result = result && (this.DxExchange.TrimOrNullify() == that.DxExchange.TrimOrNullify());
            result = result && (this.DxBarcode.TrimOrNullify() == that.DxBarcode.TrimOrNullify());
            result = result && (this.MailsortCode.TrimOrNullify() == that.MailsortCode.TrimOrNullify());
            return(result);
        }