package Guest;

sub new  {
   my ($pkg, $last_name, $first_names, $address, $city,
       $state, $zip, $est_count) = @_;
   bless {
      _last_name => $last_name,
      _first_names => $first_names,
      _address => $address,
      _city => $city,
      _state => $state,
      _zip => $zip,
      _est_count => $est_count
   }, $pkg;
}

# Database methods: add/update/delete
# - All database objects requre a database handle parameter
#   and will use DBI to talk to database.
sub add {
   my ($obj,$dbh) = @_;
   # Insert row into database
   my $sth = $dbh->prepare( "INSERT INTO guest_list
                                (last_name, first_names, address,
                                 city, state, zip, est_count)
                              VALUES  (?,?,?,?,?,?,?)" );

   $sth->execute($obj->{_last_name},
                 $obj->{_first_names},
                 $obj->{_address},
                 $obj->{_city},
                 $obj->{_state},
                 $obj->{_zip},
                 $obj->{_est_count});
   return 1;
}
# Delete
sub delete {
   my ($obj,$dbh) = @_;

   # Prep delete statement
   my $sth = $dbh->prepare( "DELETE FROM guest_list
                             WHERE  last_name = ? and
                                    first_names = ?" );

   $sth->execute($obj->{_last_name},
                 $obj->{_first_names});
   # Don't forget to delete the object
   return 1;
}

# Update
sub update {
   my ($obj,$dbh) = @_;

   # Insert row into database
   my $sth = $dbh->prepare( "UPDATE guest_list
                              SET   address = ?,
                                    city = ?,
                                    state = ?,
                                    zip = ?,
                                    est_count = ?
                              WHERE  last_name = ? and
                                    first_names = ?" );

   $sth->execute($obj->{_address},
                 $obj->{_city},
                 $obj->{_state},
                 $obj->{_zip},
                 $obj->{_est_count},
                 $obj->{_last_name},
                 $obj->{_first_names});
   return 1;
}

#Accessor methods
sub last_name   {my $obj = shift; @_ ? $obj->{_last_name} = shift : 
   $obj->{_last_name}}
sub first_names {my $obj = shift; @_ ? $obj->{_first_names} = 
   shift : $obj->{_first_names}}
sub address     {my $obj = shift; @_ ? $obj->{_address} = shift : 
   $obj->{_address}}
sub city        {my $obj = shift; @_ ? $obj->{_city} = shift : 
   $obj->{_city}}
sub state       {my $obj = shift; @_ ? $obj->{_state} = shift : 
   $obj->{_state}}
sub zip         {my $obj = shift; @_ ? $obj->{_zip} = shift : 
   $obj->{_zip}}
sub est_count   {my $obj = shift; @_ ? $obj->{_est_count} = shift : 
   $obj->{_est_count}}

1;