private void Update(object sender, RoutedEventArgs e)
{
App.Contact contact = (App.Contact)dgContacts.SelectedItem;
UpdateWindow w = new UpdateWindow(contact);
w.Show();
}
private void Delete(object sender, RoutedEventArgs e)
{
App.Contact contact = (App.Contact)dgContacts.SelectedItem;
dgContacts.Items.Remove(contact);
var name = contact.Name;
Console.WriteLine(name);
MySqlCommand delete = new MySqlCommand("DELETE FROM projekt WHERE Name='" + name + "'", connection);
delete.ExecuteNonQuery();
MySqlCommand get = new MySqlCommand("SELECT * FROM projekt", connection);
getData(get);
}
public void getData(MySqlCommand command)
{
dgContacts.Items.Clear();
using (var record = command.ExecuteReader())
{
while (record.Read())
{
App.Contact contact = new App.Contact();
contact.ID = int.Parse(record["id"].ToString());
contact.Name = record["name"].ToString();
contact.Age = int.Parse(record["age"].ToString());
dgContacts.Items.Add(contact);
}
}
}
public UpdateWindow(App.Contact contact)
{
InitializeComponent();
currentContact = contact;
}
