public void Update(User entity, Address address)
        {
            using (var myConnection = new SqlConnection(ConnectionString))
            {
                using (var myCommand = myConnection.CreateCommand())
                {
                    myCommand.CommandText = "UPDATE users " +
                                            "SET first_name = @first_name, last_name = @last_name, username = @username, access_level = @access_level, email = @email, password = @password, is_new = @is_new, is_active = @is_active " +
                                            "WHERE id = @id";
                    myCommand.Parameters.Add("@first_name", SqlDbType.VarChar).Value = entity.FirstName;
                    myCommand.Parameters.Add("@last_name", SqlDbType.VarChar).Value = entity.LastName;
                    myCommand.Parameters.Add("@username", SqlDbType.VarChar).Value = entity.UserName;
                    myCommand.Parameters.Add("@access_level", SqlDbType.Int).Value = entity.AccessLevel;
                    myCommand.Parameters.Add("@email", SqlDbType.VarChar).Value = entity.Email;
                    myCommand.Parameters.Add("@password", SqlDbType.VarChar).Value = entity.Password;
                    myCommand.Parameters.Add("@is_new", SqlDbType.Bit).Value = entity.IsNew;
                    myCommand.Parameters.Add("@is_active", SqlDbType.Bit).Value = entity.IsActive;
                    myCommand.Parameters.Add("@id", SqlDbType.Int).Value = entity.Id;

                    try
                    {
                        myConnection.Open();
                        myCommand.ExecuteNonQuery();

                        myCommand.Parameters.Clear();
                        myCommand.CommandText = "UPDATE addresses " +
                                                "SET street1 = @street1, city = @city, state = @state, zip = @zip, country_id = @country_id " +
                                                "WHERE user_id = @id";
                        myCommand.Parameters.Add("@street1", SqlDbType.NVarChar).Value = address.Street1;
                        myCommand.Parameters.Add("@city", SqlDbType.NVarChar).Value = address.City;
                        myCommand.Parameters.Add("@state", SqlDbType.NVarChar).Value = address.State;
                        myCommand.Parameters.Add("@zip", SqlDbType.NVarChar).Value = address.Zip;
                        myCommand.Parameters.Add("@country_id", SqlDbType.Int).Value = address.CountryId;
                        myCommand.Parameters.Add("@id", SqlDbType.Int).Value = address.Id;

                        myCommand.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {

                        throw;
                    }

                }
            }
        }