Pastable version of Refactoring Help Needed

<pre class='prettyprint' language='cs'>public interface IName
{
    string getLastName();
    string getFirstName();
    string getMiddleName();
    string getSuffixName();
}

public class Name : IName
{
    private string _lastName;
    private string _firstName;
    private string _middleName;
    private string _suffixName;

// Validation Methods
    // private set methods

#region IName Members

public string getLastName()
    {
        return _lastName;
    }

public string getFirstName()
    {
        return _firstName;
    }

public string getMiddleName()
    {
        return _middleName;
    }

public string getSuffixName()
    {
        return _suffixName;
    }

#endregion
}

public interface IAddress
{
    string getAddressNumber();
    string getAddressDirection();
    string getAddressStreet();
    string getAddressStreetType();
    string getAddressAptNum();
    string getAddressCity();
    string getAddressState();
    string getAddressZipcode();
    string getAddressCounty();
}

public class Address : IAddress
{
    private string _addressNumber;
    private string _addressDirection;
    private string _addressStreet;
    private string _addressStreetType;
    private string _addressAptNum;
    private string _addressrCity;
    private string _addressState;
    private string _addressZipcode;
    private string _addressCounty;

// Validation Methods
    // private Set Methods
    // public get methods

#region IAddress Members

public string getAddressNumber()
    {
        return _addressNumber;
    }

public string getAddressDirection()
    {
        return _addressDirection;
    }

public string getAddressStreet()
    {
        return _addressStreet;
    }

public string getAddressStreetType()
    {
        return _addressStreetType;
    }

public string getAddressAptNum()
    {
        return _addressAptNum;
    }

public string getAddressCity()
    {
        return _addressrCity;
    }

public string getAddressState()
    {
        return _addressState;
    }

public string getAddressZipcode()
    {
        return _addressZipcode;
    }

public string getAddressCounty()
    {
        return _addressCounty;
    }

#endregion
}
public interface IPerson
{
    int getId();
    IName getCurrentName();
    IName getFormerName();

IAddress getCurrentAddress();
    IAddress getFormerAddress();
    IAddress getMailingAddress();

DateTime getBirthdate();
    string getGender();
    string getSSNumber();
    string getPersonType();
    DateTime getRegistrationDate();
    string getIPAddress();
    string getBrowserInfo();

string getHomePhone();
    string getWorkPhone();
    string getCellPhone();
    string getFaxNumber();
    string getEmailAddress();
    string getSecondaryEmailAddress();
    string getDriversLicense();

bool save();
    void load();

}

public class Person : IPerson
{
    private int _id;
    private IName _currentName;
    private IName _formerName;

private IAddress _currentAddress;
    private IAddress _formerAddress;
    private IAddress _mailingAddress;

private DateTime _birthdate;
    private string _gender;
    private string _ssNumber;
    private string _personType;
    private DateTime _registrationDate;
    private string _ipAddress;
    private string _browserInfo;
    private string _driversLicense;

private string _homePhone;
    private string _workPhone;
    private string _cellPhone;
    private string _faxNumber;
    private string _emailAddress;
    private string _secondaryEmailAddress;
    
    
    // private set methods

#region IPerson Members

public bool save()
    {
        DataLayer dl = new DataLayer();
        if (_id == 0)
            return dl.insertPerson(this);
        else
            return dl.updatePerson(this);
    }

public void load()
    {
    }

public int getId()
    {
        return _id;
    }

public IName getCurrentName()
    {
        return _currentName;
    }

public IName getFormerName()
    {
        return _formerName;
    }

public IAddress getCurrentAddress()
    {
        return _currentAddress;
    }

public IAddress getFormerAddress()
    {
        return _formerAddress;
    }

public IAddress getMailingAddress()
    {
        return _mailingAddress;
    }

public DateTime getBirthdate()
    {
        return _birthdate;
    }

public string getGender()
    {
        return _gender;
    }

public string getSSNumber()
    {
        return _ssNumber;
    }

public string getPersonType()
    {
        return _personType;
    }

public DateTime getRegistrationDate()
    {
        return _registrationDate;
    }

public string getIPAddress()
    {
        return _ipAddress;
    }

public string getBrowserInfo()
    {
        return _browserInfo;
    }

public string getHomePhone()
    {
        return _homePhone;
    }

public string getWorkPhone()
    {
        return _workPhone;
    }

public string getCellPhone()
    {
        return _cellPhone;
    }

public string getFaxNumber()
    {
        return _faxNumber;
    }

public string getEmailAddress()
    {
        return _emailAddress;
    }

public string getSecondaryEmailAddress()
    {
        return _secondaryEmailAddress;
    }

public string getDriversLicense()
    {
        return _driversLicense;
    }

#endregion
}

public class DataLayer
{

public bool insertPerson(IPerson person)
    {
        bool inserted = false;
        SqlConnection cnDB = DatabaseConnection.GetOpenDBConnection();
        try
        {
            SqlCommand cmDB = new SqlCommand(&quot;sp_InsertName&quot;, cnDB);
            cmDB.CommandType = CommandType.StoredProcedure;
            cmDB.Parameters.Add(&quot;@last_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@last_name&quot;].Value = person.getCurrentName().getLastName();
            cmDB.Parameters.Add(&quot;@first_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@first_name&quot;].Value = person.getCurrentName().getFirstName();
            cmDB.Parameters.Add(&quot;@middle_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@middle_name&quot;].Value = person.getCurrentName().getMiddleName();
            cmDB.Parameters.Add(&quot;@suffix_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@suffix_name&quot;].Value = person.getCurrentName().getSuffixName();
            int id = cmDB.ExecuteNonQuery();

cmDB = new SqlCommand(&quot;sp_InsertName&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@former_last_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@former_last_name&quot;].Value = person.getFormerName().getLastName();
            cmDB.Parameters.Add(&quot;@former_first_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@former_first_name&quot;].Value = person.getFormerName().getFirstName();
            cmDB.Parameters.Add(&quot;@former_middle_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@former_middle_name&quot;].Value = person.getFormerName().getMiddleName();
            cmDB.Parameters.Add(&quot;@former_suffix_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@former_suffix_name&quot;].Value = person.getFormerName().getSuffixName();
            cmDB.ExecuteNonQuery();

// Insert Current Address

cmDB = new SqlCommand(&quot;sp_InsertAddress&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@address_number&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_number&quot;].Value = person.getCurrentAddress().getAddressNumber();
            cmDB.Parameters.Add(&quot;@address_direction&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_direction&quot;].Value = person.getCurrentAddress().getAddressDirection();
            cmDB.Parameters.Add(&quot;@address_street&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_street&quot;].Value = person.getCurrentAddress().getAddressStreet();
            cmDB.Parameters.Add(&quot;@address_street_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_street_type&quot;].Value = person.getCurrentAddress().getAddressStreetType();
            cmDB.Parameters.Add(&quot;@address_apt_number&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_apt_number&quot;].Value = person.getCurrentAddress().getAddressAptNum();
            cmDB.Parameters.Add(&quot;@address_city&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_city&quot;].Value = person.getCurrentAddress().getAddressCity();
            cmDB.Parameters.Add(&quot;@address_state&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_state&quot;].Value = person.getCurrentAddress().getAddressCity();
            cmDB.Parameters.Add(&quot;@address_zipcode&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_zipcode&quot;].Value = person.getCurrentAddress().getAddressZipcode();
            cmDB.Parameters.Add(&quot;@address_county&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_county&quot;].Value = person.getCurrentAddress().getAddressCounty();
            cmDB.ExecuteNonQuery();

// Insert Former Address

cmDB = new SqlCommand(&quot;sp_InsertAddress&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@address_number&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_number&quot;].Value = person.getFormerAddress().getAddressNumber();
            cmDB.Parameters.Add(&quot;@address_direction&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_direction&quot;].Value = person.getFormerAddress().getAddressDirection();
            cmDB.Parameters.Add(&quot;@address_street&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_street&quot;].Value = person.getFormerAddress().getAddressStreet();
            cmDB.Parameters.Add(&quot;@address_street_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_street_type&quot;].Value = person.getFormerAddress().getAddressStreetType();
            cmDB.Parameters.Add(&quot;@address_apt_number&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_apt_number&quot;].Value = person.getFormerAddress().getAddressAptNum();
            cmDB.Parameters.Add(&quot;@address_city&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_city&quot;].Value = person.getFormerAddress().getAddressCity();
            cmDB.Parameters.Add(&quot;@address_state&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_state&quot;].Value = person.getFormerAddress().getAddressCity();
            cmDB.Parameters.Add(&quot;@address_zipcode&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_zipcode&quot;].Value = person.getFormerAddress().getAddressZipcode();
            cmDB.Parameters.Add(&quot;@address_county&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_county&quot;].Value = person.getFormerAddress().getAddressCounty();
            cmDB.ExecuteNonQuery();

// Insert Mailing Address

cmDB = new SqlCommand(&quot;sp_InsertAddress&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@address_number&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_number&quot;].Value = person.getMailingAddress().getAddressNumber();
            cmDB.Parameters.Add(&quot;@address_direction&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_direction&quot;].Value = person.getMailingAddress().getAddressDirection();
            cmDB.Parameters.Add(&quot;@address_street&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_street&quot;].Value = person.getMailingAddress().getAddressStreet();
            cmDB.Parameters.Add(&quot;@address_street_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_street_type&quot;].Value = person.getMailingAddress().getAddressStreetType();
            cmDB.Parameters.Add(&quot;@address_apt_number&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_apt_number&quot;].Value = person.getMailingAddress().getAddressAptNum();
            cmDB.Parameters.Add(&quot;@address_city&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_city&quot;].Value = person.getMailingAddress().getAddressCity();
            cmDB.Parameters.Add(&quot;@address_state&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_state&quot;].Value = person.getMailingAddress().getAddressCity();
            cmDB.Parameters.Add(&quot;@address_zipcode&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_zipcode&quot;].Value = person.getMailingAddress().getAddressZipcode();
            cmDB.Parameters.Add(&quot;@address_county&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_county&quot;].Value = person.getMailingAddress().getAddressCounty();
            cmDB.ExecuteNonQuery();

// insert Personal Info

cmDB = new SqlCommand(&quot;sp_InsertPersonalInfo&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@birthdate&quot;, System.Data.SqlDbType.DateTime);
            cmDB.Parameters[&quot;@birthdate&quot;].Value = person.getBirthdate();
            cmDB.Parameters.Add(&quot;@gender&quot;, System.Data.SqlDbType.VarChar,1);
            cmDB.Parameters[&quot;@gender&quot;].Value = person.getGender();
            cmDB.Parameters.Add(&quot;@ss_number&quot;, System.Data.SqlDbType.VarChar,20);
            cmDB.Parameters[&quot;@ss_number&quot;].Value = person.getSSNumber();
            cmDB.Parameters.Add(&quot;@person_type&quot;, System.Data.SqlDbType.VarChar,20);
            cmDB.Parameters[&quot;@person_type&quot;].Value = person.getPersonType();
            cmDB.Parameters.Add(&quot;@registration_date&quot;, System.Data.SqlDbType.DateTime);
            cmDB.Parameters[&quot;@registration_date&quot;].Value = person.getRegistrationDate();
            cmDB.Parameters.Add(&quot;@ip_address&quot;, System.Data.SqlDbType.VarChar,20);
            cmDB.Parameters[&quot;@ip_address&quot;].Value = person.getIPAddress();
            cmDB.Parameters.Add(&quot;@browser_info&quot;, System.Data.SqlDbType.VarChar,20);
            cmDB.Parameters[&quot;@browser_info&quot;].Value = person.getBrowserInfo();
            cmDB.Parameters.Add(&quot;@drivers_license&quot;, System.Data.SqlDbType.VarChar,20);
            cmDB.Parameters[&quot;@drivers_license&quot;].Value = person.getDriversLicense();
            cmDB.ExecuteNonQuery();

//insert email address contact type
            cmDB = new SqlCommand(&quot;sp_InsertContactType&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@contact_type&quot;, System.Data.SqlDbType.VarChar,50);
            cmDB.Parameters[&quot;@contact_type&quot;].Value = &quot;Email&quot;;
            cmDB.Parameters.Add(&quot;@contact&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@gender&quot;].Value = person.getEmailAddress();
            cmDB.ExecuteNonQuery();

//insert secondary email address contact type
            cmDB = new SqlCommand(&quot;sp_InsertContactType&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@contact_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact_type&quot;].Value = &quot;Secondary Email&quot;;
            cmDB.Parameters.Add(&quot;@contact&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@gender&quot;].Value = person.getSecondaryEmailAddress();
            cmDB.ExecuteNonQuery();

//insert home phone contact type
            cmDB = new SqlCommand(&quot;sp_InsertContactType&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@contact_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact_type&quot;].Value = &quot;Home Phone&quot;;
            cmDB.Parameters.Add(&quot;@contact&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact&quot;].Value = person.getHomePhone();
            cmDB.ExecuteNonQuery();

//insert work phone contact type
            cmDB = new SqlCommand(&quot;sp_InsertContactType&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@contact_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact_type&quot;].Value = &quot;Work Phone&quot;;
            cmDB.Parameters.Add(&quot;@contact&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact&quot;].Value = person.getWorkPhone();
            cmDB.ExecuteNonQuery();

//insert cell phone contact type
            cmDB = new SqlCommand(&quot;sp_InsertContactType&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@contact_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact_type&quot;].Value = &quot;Cell Phone&quot;;
            cmDB.Parameters.Add(&quot;@contact&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact&quot;].Value = person.getCellPhone();
            cmDB.ExecuteNonQuery();

//insert cell phone contact type
            cmDB = new SqlCommand(&quot;sp_InsertContactType&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@contact_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact_type&quot;].Value = &quot;Fax Number&quot;;
            cmDB.Parameters.Add(&quot;@contact&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact&quot;].Value = person.getFaxNumber();
            cmDB.ExecuteNonQuery();

inserted = true;
        }
        catch (SqlException sqlEx)
        {
            throw new Exception(GetSqlExceptionMessage(sqlEx.Number));
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            if (cnDB.State == ConnectionState.Open)
                cnDB.Close();
        }
        return inserted;
    }

public bool updatePerson(IPerson person)
    {
        bool inserted = false;
        SqlConnection cnDB = DatabaseConnection.GetOpenDBConnection();
        try
        {
            string id = person.getId();

SqlCommand cmDB = new SqlCommand(&quot;sp_UpdateName&quot;, cnDB);
            cmDB.CommandType = CommandType.StoredProcedure;
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@last_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@last_name&quot;].Value = person.getCurrentName().getLastName();
            cmDB.Parameters.Add(&quot;@first_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@first_name&quot;].Value = person.getCurrentName().getFirstName();
            cmDB.Parameters.Add(&quot;@middle_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@middle_name&quot;].Value = person.getCurrentName().getMiddleName();
            cmDB.Parameters.Add(&quot;@suffix_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@suffix_name&quot;].Value = person.getCurrentName().getSuffixName();
            cmDB.ExecuteNonQuery();

cmDB = new SqlCommand(&quot;sp_UpdateName&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@former_last_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@former_last_name&quot;].Value = person.getFormerName().getLastName();
            cmDB.Parameters.Add(&quot;@former_first_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@former_first_name&quot;].Value = person.getFormerName().getFirstName();
            cmDB.Parameters.Add(&quot;@former_middle_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@former_middle_name&quot;].Value = person.getFormerName().getMiddleName();
            cmDB.Parameters.Add(&quot;@former_suffix_name&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@former_suffix_name&quot;].Value = person.getFormerName().getSuffixName();
            cmDB.ExecuteNonQuery();

// Update Current Address

cmDB = new SqlCommand(&quot;sp_UpdateAddress&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@address_number&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_number&quot;].Value = person.getCurrentAddress().getAddressNumber();
            cmDB.Parameters.Add(&quot;@address_direction&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_direction&quot;].Value = person.getCurrentAddress().getAddressDirection();
            cmDB.Parameters.Add(&quot;@address_street&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_street&quot;].Value = person.getCurrentAddress().getAddressStreet();
            cmDB.Parameters.Add(&quot;@address_street_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_street_type&quot;].Value = person.getCurrentAddress().getAddressStreetType();
            cmDB.Parameters.Add(&quot;@address_apt_number&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_apt_number&quot;].Value = person.getCurrentAddress().getAddressAptNum();
            cmDB.Parameters.Add(&quot;@address_city&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_city&quot;].Value = person.getCurrentAddress().getAddressCity();
            cmDB.Parameters.Add(&quot;@address_state&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_state&quot;].Value = person.getCurrentAddress().getAddressCity();
            cmDB.Parameters.Add(&quot;@address_zipcode&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_zipcode&quot;].Value = person.getCurrentAddress().getAddressZipcode();
            cmDB.Parameters.Add(&quot;@address_county&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_county&quot;].Value = person.getCurrentAddress().getAddressCounty();
            cmDB.ExecuteNonQuery();

// Update Former Address

cmDB = new SqlCommand(&quot;sp_UpdateAddress&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@address_number&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_number&quot;].Value = person.getFormerAddress().getAddressNumber();
            cmDB.Parameters.Add(&quot;@address_direction&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_direction&quot;].Value = person.getFormerAddress().getAddressDirection();
            cmDB.Parameters.Add(&quot;@address_street&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_street&quot;].Value = person.getFormerAddress().getAddressStreet();
            cmDB.Parameters.Add(&quot;@address_street_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_street_type&quot;].Value = person.getFormerAddress().getAddressStreetType();
            cmDB.Parameters.Add(&quot;@address_apt_number&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_apt_number&quot;].Value = person.getFormerAddress().getAddressAptNum();
            cmDB.Parameters.Add(&quot;@address_city&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_city&quot;].Value = person.getFormerAddress().getAddressCity();
            cmDB.Parameters.Add(&quot;@address_state&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_state&quot;].Value = person.getFormerAddress().getAddressCity();
            cmDB.Parameters.Add(&quot;@address_zipcode&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_zipcode&quot;].Value = person.getFormerAddress().getAddressZipcode();
            cmDB.Parameters.Add(&quot;@address_county&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_county&quot;].Value = person.getFormerAddress().getAddressCounty();
            cmDB.ExecuteNonQuery();

// Update Mailing Address

cmDB = new SqlCommand(&quot;sp_UpdateAddress&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@address_number&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_number&quot;].Value = person.getMailingAddress().getAddressNumber();
            cmDB.Parameters.Add(&quot;@address_direction&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_direction&quot;].Value = person.getMailingAddress().getAddressDirection();
            cmDB.Parameters.Add(&quot;@address_street&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_street&quot;].Value = person.getMailingAddress().getAddressStreet();
            cmDB.Parameters.Add(&quot;@address_street_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_street_type&quot;].Value = person.getMailingAddress().getAddressStreetType();
            cmDB.Parameters.Add(&quot;@address_apt_number&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_apt_number&quot;].Value = person.getMailingAddress().getAddressAptNum();
            cmDB.Parameters.Add(&quot;@address_city&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_city&quot;].Value = person.getMailingAddress().getAddressCity();
            cmDB.Parameters.Add(&quot;@address_state&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_state&quot;].Value = person.getMailingAddress().getAddressCity();
            cmDB.Parameters.Add(&quot;@address_zipcode&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_zipcode&quot;].Value = person.getMailingAddress().getAddressZipcode();
            cmDB.Parameters.Add(&quot;@address_county&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@address_county&quot;].Value = person.getMailingAddress().getAddressCounty();
            cmDB.ExecuteNonQuery();

// Update Personal Info

cmDB = new SqlCommand(&quot;sp_UpdatePersonalInfo&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@birthdate&quot;, System.Data.SqlDbType.DateTime);
            cmDB.Parameters[&quot;@birthdate&quot;].Value = person.getBirthdate();
            cmDB.Parameters.Add(&quot;@gender&quot;, System.Data.SqlDbType.VarChar, 1);
            cmDB.Parameters[&quot;@gender&quot;].Value = person.getGender();
            cmDB.Parameters.Add(&quot;@ss_number&quot;, System.Data.SqlDbType.VarChar, 20);
            cmDB.Parameters[&quot;@ss_number&quot;].Value = person.getSSNumber();
            cmDB.Parameters.Add(&quot;@person_type&quot;, System.Data.SqlDbType.VarChar, 20);
            cmDB.Parameters[&quot;@person_type&quot;].Value = person.getPersonType();
            cmDB.Parameters.Add(&quot;@registration_date&quot;, System.Data.SqlDbType.DateTime);
            cmDB.Parameters[&quot;@registration_date&quot;].Value = person.getRegistrationDate();
            cmDB.Parameters.Add(&quot;@ip_address&quot;, System.Data.SqlDbType.VarChar, 20);
            cmDB.Parameters[&quot;@ip_address&quot;].Value = person.getIPAddress();
            cmDB.Parameters.Add(&quot;@browser_info&quot;, System.Data.SqlDbType.VarChar, 20);
            cmDB.Parameters[&quot;@browser_info&quot;].Value = person.getBrowserInfo();
            cmDB.Parameters.Add(&quot;@drivers_license&quot;, System.Data.SqlDbType.VarChar, 20);
            cmDB.Parameters[&quot;@drivers_license&quot;].Value = person.getDriversLicense();
            cmDB.ExecuteNonQuery();

//Update email address contact type
            cmDB = new SqlCommand(&quot;sp_UpdateContactType&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@contact_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact_type&quot;].Value = &quot;Email&quot;;
            cmDB.Parameters.Add(&quot;@contact&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@gender&quot;].Value = person.getEmailAddress();
            cmDB.ExecuteNonQuery();

//Update secondary email address contact type
            cmDB = new SqlCommand(&quot;sp_UpdateContactType&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@contact_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact_type&quot;].Value = &quot;Secondary Email&quot;;
            cmDB.Parameters.Add(&quot;@contact&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@gender&quot;].Value = person.getSecondaryEmailAddress();
            cmDB.ExecuteNonQuery();

//Update home phone contact type
            cmDB = new SqlCommand(&quot;sp_UpdateContactType&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@contact_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact_type&quot;].Value = &quot;Home Phone&quot;;
            cmDB.Parameters.Add(&quot;@contact&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact&quot;].Value = person.getHomePhone();
            cmDB.ExecuteNonQuery();

//Update work phone contact type
            cmDB = new SqlCommand(&quot;sp_UpdateContactType&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@contact_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact_type&quot;].Value = &quot;Work Phone&quot;;
            cmDB.Parameters.Add(&quot;@contact&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact&quot;].Value = person.getWorkPhone();
            cmDB.ExecuteNonQuery();

//Update cell phone contact type
            cmDB = new SqlCommand(&quot;sp_UpdateContactType&quot;, cnDB);
            cmDB.Parameters.Add(&quot;@person_id&quot;, System.Data.SqlDbType.Int);
            cmDB.Parameters[&quot;@person_id&quot;].Value = id;
            cmDB.Parameters.Add(&quot;@contact_type&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact_type&quot;].Value = &quot;Fax Number&quot;;
            cmDB.Parameters.Add(&quot;@contact&quot;, System.Data.SqlDbType.VarChar, 50);
            cmDB.Parameters[&quot;@contact&quot;].Value = person.getFaxNumber();
            cmDB.ExecuteNonQuery();
            inserted = true;
        }
        catch (SqlException sqlEx)
        {
            throw new Exception(GetSqlExceptionMessage(sqlEx.Number));
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            if (cnDB.State == ConnectionState.Open)
                cnDB.Close();
        }
        return inserted;

}
}</pre>
<a href="http://www.refactormycode.com/codes/798-refactoring-help-needed" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

Refactor :my => 'code'

Recent

Popular

Pastable version of Refactoring Help Needed