private void FindAnimalButton_Click(object sender, RoutedEventArgs e)
{
FindAnimal findAnimal = new FindAnimal();
findAnimal.chooseAnimal.Visibility = Visibility.Hidden;
findAnimal.Show();
}
private void Animal_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
animalInfo.Clear();
FindAnimal findAnimal = new FindAnimal();
findAnimal.exportButton.Visibility = Visibility.Hidden;
findAnimal.ShowDialog();
this.passportId = findAnimal.ChooseAnimal();
using (var db = DBConfig.Connection)
{
db.Open();
MySqlDataReader reader = null;
string selectCmd = "SELECT p.animal_name, b.animal_type_name FROM passport p JOIN animal_type b USING(animal_type_id) WHERE p.passport_id =" + this.passportId;
MySqlCommand command = new MySqlCommand(selectCmd, db);
reader = command.ExecuteReader();
while (reader.Read())
{
string animalName = (string)reader["animal_name"];
string animalType = (string)reader["animal_type_name"];
animalInfo.Text = animalName + " " + animalType;
}
db.Close();
}
}
public static bool FindAnimalFrom(this List <Animal> animals, FindAnimal findAnimal)
{
foreach (var a in animals)
{
if (findAnimal(a))
{
return(true);
}
}
return(false);
}