private void Btn_Add_Click(object sender, RoutedEventArgs e)
{
vetWin = new VeteranRecord(parentWin);
vetWin.SetSingleRecord();
vetWin.BuildAndShowDialog();
parentWin.DataContext = null;
parentWin.MainWindowContent = vetWin;
parentWin.DataContext = parentWin;
}
private void LoadSingleSearchResult(string searchTerm)
{
int veteranNumber = 0;
try
{
using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString))
{
conn.OpenAsync();
using (MySqlCommand command = conn.CreateCommand())
{
command.CommandText = @"SELECT ID FROM Veterans WHERE LName=@searchTerm";
command.Parameters.Add("@searchTerm", MySqlDbType.VarChar).Value = searchTerm;
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
veteranNumber = reader.GetInt32(0);
}
}
}
}
}
catch (InvalidOperationException)
{
MessageBox.Show(Tools.DBErrorMessage, Tools.DBErrorTitle);
}
catch (MySqlException e)
{
Tools.HandleSQLExceptions(e);
}
vetWin = new VeteranRecord(parentWin);
vetWin.SetSingleRecord();
vetWin.BuildAndShowDialog(veteranNumber);
parentWin.DataContext = null;
parentWin.MainWindowContent = vetWin;
parentWin.DataContext = parentWin;
}