private void ChangeButton_Click(object sender, RoutedEventArgs e)
{
try
{
int id = Convert.ToInt32(ID_tb.Text);
string name = Name_tb.Text;
string descrip = Descrip_tb.Text;
int newid = Convert.ToInt32(ID_tb_Copy.Text);
string newname = Name_tb_Copy.Text;
string newdescrip = Descrip_tb_Copy.Text;
string connectionString = @"Data Source =.\SQLEXPRESS; Initial Catalog = FitnessCenter; Integrated Security = True";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
string cmdTxt1 = $"UPDATE Classes SET Name = '{newname}' WHERE ID_class = '{id}'";
SqlCommand command1 = new SqlCommand(cmdTxt1, connection);
string cmdTxt2 = $"UPDATE Classes SET Description = '{newdescrip}' WHERE ID_class = '{id}'";
SqlCommand command2 = new SqlCommand(cmdTxt2, connection);
command1.ExecuteNonQuery(); command2.ExecuteNonQuery();
MessageBox.Show("Изменения сохранены успешно!", "Статус действия", MessageBoxButton.OK, MessageBoxImage.Information);
ID_tb.Clear(); Name_tb.Clear(); Descrip_tb.Clear();
ID_tb_Copy.Clear(); Name_tb_Copy.Clear(); Descrip_tb_Copy.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
try
{
int id = Convert.ToInt32(ID_tb.Text);
string connectionString = @"Data Source =.\SQLEXPRESS; Initial Catalog = FitnessCenter; Integrated Security = True";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
string cmdTxt = $"DELETE FROM Abonnement WHERE ID_abonnement = '{id}'";
SqlCommand command = new SqlCommand(cmdTxt, connection);
int number = command.ExecuteNonQuery();
MessageBox.Show("Изменения сохранены успешно!\nУдалено объектов: " + number, "Статус действия", MessageBoxButton.OK, MessageBoxImage.Information);
ID_tb.Clear(); Name_tb.Clear(); Price_tb.Clear(); Descrip_tb.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
try
{
int id = Convert.ToInt32(ID_tb.Text);
string name = Name_tb.Text;
string descrip = Descrip_tb.Text;
string connectionString = @"Data Source =.\SQLEXPRESS; Initial Catalog = FitnessCenter; Integrated Security = True";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
string cmdTxt = $"INSERT INTO Classes (ID_class, Name, Description) VALUES ('{id}', '{name}', '{descrip}')";
SqlCommand command = new SqlCommand(cmdTxt, connection);
int number = command.ExecuteNonQuery();
MessageBox.Show("Изменения сохранены успешно!\nВставлено объектов: " + number, "Статус действия", MessageBoxButton.OK, MessageBoxImage.Information);
ID_tb.Clear(); Name_tb.Clear(); Descrip_tb.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}