private void BackToWindow(object sender, RoutedEventArgs e) { ChangeCurrencySellCourse changeCurrencySellCourse = new ChangeCurrencySellCourse(); changeCurrencySellCourse.Show(); this.Close(); }
private void ChangeCurrencySellData_Click(object sender, RoutedEventArgs e) { ChangeCurrencySellCourse changeCurrencySellCourse = new ChangeCurrencySellCourse(); changeCurrencySellCourse.Show(); this.Close(); }
private void SaveChanges(object sender, RoutedEventArgs e) { SqlConnection connection = new SqlConnection(connectionString); connection.Open(); if (criterion.Text != string.Empty && searchCriterion.Text != string.Empty) { int currencyCode = Convert.ToInt32(searchCriterion.Text); if (criterion.Text == "Название валюты") { if (changingCriterion.Text != CheckCurrency.CheckCurrencyName(changingCriterion.Text)) { System.Windows.MessageBox.Show(CheckCurrency.CheckCurrencyName(changingCriterion.Text)); return; } string mySelectQuery = "SELECT * FROM CurrencySell WHERE CurrencySellName = '" + changingCriterion.Text + "'"; using (SqlDataAdapter dataAdapter = new SqlDataAdapter(mySelectQuery, connection)) { DataTable table = new DataTable(); dataAdapter.Fill(table); if (table.Rows.Count > 0) { System.Windows.MessageBox.Show("Вы не можете изменить данные, так как эта валюта уже есть в базе."); return; } else if (table.Rows.Count == 0) { using (SqlCommand lastCommnd = connection.CreateCommand()) { lastCommnd.CommandText = "UPDATE CurrencySell SET CurrencySellName = @name WHERE CurrencySellCode = @code"; lastCommnd.Parameters.AddWithValue("@name", changingCriterion.Text); lastCommnd.Parameters.AddWithValue("@code", currencyCode); lastCommnd.ExecuteNonQuery(); } } } } else if (criterion.Text == "Курс валюты") { if (changingCriterion.Text != CheckCurrency.CheckCurrencyCourse(changingCriterion.Text)) { System.Windows.MessageBox.Show(CheckCurrency.CheckCurrencyCourse(changingCriterion.Text)); return; } using (SqlCommand lastCommnd = connection.CreateCommand()) { lastCommnd.CommandText = "UPDATE CurrencySell SET CurrencySellCourse = @course WHERE CurrencySellCode = @code"; lastCommnd.Parameters.AddWithValue("@course", Convert.ToDouble(changingCriterion.Text)); lastCommnd.Parameters.AddWithValue("@code", currencyCode); lastCommnd.ExecuteNonQuery(); } } } else { System.Windows.MessageBox.Show("Вы не выбрали данные для изменения."); return; } MessageBoxResult mboxResult = System.Windows.MessageBox.Show("Данные обновлены. Желаете изменить что-нибудь еще?", "Предупреждение", MessageBoxButton.YesNo); if (mboxResult == MessageBoxResult.No) { ChangeCurrencySellCourse changeCurrencySellCourse = new ChangeCurrencySellCourse(); changeCurrencySellCourse.Show(); this.Close(); } connection.Close(); }