private void LocationDataGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
LocationEdit locationEdit = new LocationEdit(int.Parse(((DataRowView)((System.Windows.Controls.Primitives.Selector)sender).SelectedItem).Row.ItemArray[0].ToString()));
locationEdit.ShowDialog();
FillTable(FilterTextBox.Text);
}
private void LocationDataGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
DataGrid locationGrid = (DataGrid)sender;
DataRowView locationSelected = locationGrid.SelectedItem as DataRowView;
MySqlDataReader reader = null;
string dnsString = "server=localhost;" +
"user=nmt_demo_user;" +
"database=nmt_demo;" +
"port=3306;" +
"password=Password1";
if (locationSelected != null)
{
String locationID = locationSelected[0].ToString();
// get the details from the database
using (MySqlConnection connection = new MySqlConnection(dnsString))
{
connection.Open();
string sql = "SELECT * FROM locations WHERE id = '" + locationID + "'";
MessageBox.Show(sql);
using (MySqlCommand cmdSel = new MySqlCommand(sql, connection))
{
// DataTable dt = new DataTable();
//MySqlDataAdapter da = new MySqlDataAdapter(cmdSel);
//da.Fill(dt);
reader = cmdSel.ExecuteReader();
while (reader.Read())
{
MessageBox.Show(reader.GetString("location_name"));
}
}
connection.Close();
//MessageTextBlock.Text = "Ready";
UpdateStatus(500, "Ready...");
}
LocationEdit locationWindow = new LocationEdit();
// fill the LocationTextBox with the location title
// fill the CodeTextBox with the location code
locationWindow.LocationTextBox.Text = "???";
locationWindow.CodeTextBox.Text = "???";
locationWindow.Owner = this;
locationWindow.WindowStartupLocation =
WindowStartupLocation.CenterOwner;
if (locationWindow.ShowDialog() == true)
{
FillTable();
UpdateStatus(2500, "Location updated");
}
}
}