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>
/// Selects some of the customer information
/// </summary>
/// <param name="iban"></param>
/// <returns>Customer' infomation</returns>
public static Model.TransactionCustomer getCustomer(string iban)
{
Model.TransactionCustomer customer = new Model.TransactionCustomer();
MySqlConnection con = new MySqlConnection(connectionString);
MySqlCommand com = new MySqlCommand("Select * from user_account ", con);
com.Connection.Open();
MySqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
if (iban == dr["Iban"].ToString())
{
customer.NameCustomer = dr["FullName"].ToString();
customer.EgnCustomer = dr["EGN"].ToString();
break;
}
}
dr.Close();
com.Connection.Close();
return(customer);
}
