private void RemoveAnimalFromZoo_Clicked(object sender, RoutedEventArgs e)
{
//string query = @"delete from ZooAnimal where AnimalID = @AnimalID";
if (listBoxZoo.SelectedItem != null && listBoxAnimal.SelectedItem != null)
{
try
{
DbConnectionManager.RemoveAnimalFromZoo(listBoxZoo, listBoxAnimal);
//SqlCommand removeAnimalCommand = new SqlCommand(query, sqlConnection);
//using (removeAnimalCommand)
//{
// removeAnimalCommand.Parameters.AddWithValue("@ZooID", listBoxZoo.SelectedValue);
// removeAnimalCommand.Parameters.AddWithValue("@AnimalID", listBoxAnimal.SelectedValue);
// removeAnimalCommand.Connection.Open();
// removeAnimalCommand.ExecuteScalar();
// removeAnimalCommand.Connection.Close();
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
ShowAnimalsList();
}
}
else
{
MessageBox.Show("Select a zoo and animal first");
}
}
