private void ButtonСhange_Click(object sender, RoutedEventArgs e)
{
int idchanged = Convert.ToInt32(id);
const string host = "mysql11.hostland.ru";
const string database = "host1323541_itstep6";
const string port = "3306";
const string username = "******";
const string pass = "******";
const string ConnString = "Server=" + host + ";Database=" + database + ";port=" + port + ";User Id=" + username + ";password="******"UPDATE TelephoneBook SET name = '{FirstnameInput.Text}' , surname = '{SurnameInput.Text}' , TelephoneNumber = '{TelephonNamberInput.Text}' WHERE ID = {idchanged};";
var query = new MySqlCommand {
Connection = db, CommandText = sql
};
var result = query.ExecuteNonQuery();
FirstnameInput.Clear();
SurnameInput.Clear();
TelephonNamberInput.Clear();
if (result == 1)
{
MessageBox.Show("Данные изменены", "Предупреждение", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Данные не изменены", "Предупреждение", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void ButtonUpdate_Click(object sender, RoutedEventArgs e)
{
ListBox.Items.Clear();
ButtonСhange.IsEnabled = false;
Access.IsEnabled = true;
FirstnameInput.Clear();
SurnameInput.Clear();
TelephonNamberInput.Clear();
ShowDB();
}
public void FillDummyDataInInputs(string data, string inputName)
{
switch (inputName)
{
case "Name":
{
NameInput.Clear();
NameInput.SendKeys(data);
}
break;
case "Surname":
{
SurnameInput.Clear();
SurnameInput.SendKeys(data);
}
break;
default:
break;
}
}
