private void buttonGetDetailsTransfer_Click(object sender, EventArgs e) { try { if (textBoxFromIBanTransfer.Text == "") { MessageBox.Show("Please enter IBAN on customer !", "Transfer .", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { modelCustomerTransfer = DataBaseOperations.getCustomer(textBoxFromIBanTransfer.Text); textBoxNameCusotmerTransfer.Text = modelCustomerTransfer.NameCustomer; textBoxEGNCustomerTransfer.Text = modelCustomerTransfer.EgnCustomer; modelAccountCustomerTransfer = DataBaseOperations.getBalance(textBoxFromIBanTransfer.Text); textBoxAccountBalanceTransfer.Text = modelAccountCustomerTransfer.Balance.ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void buttonGetDetailsWithdraw_Click(object sender, EventArgs e) { try { if (textBoxIbanWithdraw.Text == "") { MessageBox.Show("Please enter IBAN on customer !", "Withdraw .", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { modelCustomerWithdraw = DataBaseOperations.getCustomer(textBoxIbanWithdraw.Text); textBoxNameCustomerWithdraw.Text = modelCustomerWithdraw.NameCustomer; textBoxEGNCustomerWithdraw.Text = modelCustomerWithdraw.EgnCustomer; ModelAccountCustomer = DataBaseOperations.getBalance(textBoxIbanWithdraw.Text); textBoxAccountBalanceWithdraw.Text = ModelAccountCustomer.Balance.ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// Select balance' customer /// </summary> /// <param name="iban"></param> /// <returns>Customer' balance in real time</returns> public static Model.ModelAccountCustomer getBalance(string iban) { Model.ModelAccountCustomer accountCustomer = new Model.ModelAccountCustomer(); MySqlConnection con = new MySqlConnection(connectionString); MySqlCommand com = new MySqlCommand("get_balance", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@ibanCustomer", iban); com.Parameters.Add(new MySqlParameter("?balance", MySqlDbType.VarChar)); com.Parameters["?balance"].Direction = ParameterDirection.Output; com.Connection.Open(); com.ExecuteNonQuery(); accountCustomer.Balance = Convert.ToDecimal(com.Parameters["?balance"].Value.ToString().Replace(".", ",")); com.Connection.Close(); return(accountCustomer); }