private void button_Click(object sender, RoutedEventArgs e) //return { if (goback == "client") { ClientExtra window = new ClientExtra(); window.Show(); this.Hide(); } else if (goback == "account") { AccountExtra window = new AccountExtra(); window.Show(); this.Hide(); } else { if (editing.Approved) { Loans window = new Loans(); window.Show(); this.Hide(); } else { LoansApprove window = new LoansApprove(); window.Show(); this.Hide(); } } }
private void button10_Click(object sender, RoutedEventArgs e) { decimal balance = -1; try { if (decimal.TryParse(t3.Text, out balance)) { if (!refresh()) { return; } SqlCommand cmd = new SqlCommand("SELECT * FROM ACCOUNT_TYPE WHERE descr='" + comboBox.SelectedItem.ToString() + "'"); cmd.Connection = cn; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; DataSet dataSet = new DataSet(); adapter.Fill(dataSet); int atype = (int)dataSet.Tables[0].Rows[0]["atype"]; string b = balance.ToString().Replace(",", "."); try { cmd = new SqlCommand("UPDATE ACCOUNTS SET balance=" + b + ", atype=" + atype + " WHERE id=" + editing.ID.ToString()); cmd.Connection = cn; cmd.ExecuteNonQuery(); editing.Balance = (double)balance; AccountExtra window = new AccountExtra(); window.Show(); this.Hide(); } catch (SqlException) { MessageBox.Show("In an attempt to save your changes, there was an error updating the database: the balance might be too high."); } } else { MessageBox.Show("In an attempt to save your changes, an invalid balance was detected."); } } catch (OverflowException) { MessageBox.Show("In an attempt to save your changes, an error ocurred: the balance might be too high."); } }