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);
}
}
private void buttonUpdateWithdraw_Click(object sender, EventArgs e)
{
try
{
if (dataGridViewWithdraw.Rows.Count == 0)
{
MessageBox.Show("Please add the data to the table.",
"Withdraw .", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
customer = DataBaseOperations.GetIdAccount(customerWithdraw.account.Iban);
DataBaseOperations.UpdateWithdraw(customerWithdraw.WithdrawAmount,
modeWithdraw, customer, customerWithdraw);
MessageBox.Show($"Withdraw with iban {customerWithdraw.account.Iban} was successful .",
"Withdraw .", MessageBoxButtons.OK,
MessageBoxIcon.Information);
textBoxIbanWithdraw.Clear();
textBoxNameCustomerWithdraw.Clear();
textBoxEGNCustomerWithdraw.Clear();
textBoxAccountBalanceWithdraw.Clear();
textBoxAmountWithdraw.Clear();
dataGridViewWithdraw.Rows.Clear();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void buttonUpdateDeposit_Click(object sender, EventArgs e)
{
try
{
if (dataGridViewDeposit.Rows.Count == 0)
{
MessageBox.Show("Please add the data to the table.",
"Deposit .", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
customer = DataBaseOperations.GetIdAccount(customerDeposit.account.Iban);
DataBaseOperations.UpdateDeposit(customerDeposit.DepositAmount,
customer, customerDeposit);
MessageBox.Show($"Deposit with iban {customerDeposit.account.Iban} was successful .",
"Deposit ", MessageBoxButtons.OK,
MessageBoxIcon.Information);
textBoxIbanDeposit.Clear();
textBoxNameCustomerDeposit.Clear();
textBoxEgnCustomerDeposit.Clear();
textBoxAccountBalanceDeposit.Clear();
textBoxDepositAmount.Clear();
dataGridViewDeposit.Rows.Clear();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
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 buttonMake_Click(object sender, EventArgs e)
{
try
{
dataGridCustomers.Rows.Clear();
List <Customer> customers = DataBaseOperations.GetAllCustomerInformation();
foreach (var c in customers)
{
dataGridCustomers.Rows.Add(
c.Id,
c.account.Iban,
c.FullName,
c.Egn,
c.gender,
c.Address,
c.PostalCode,
c.City,
c.Country,
c.MobilePhone,
c.HomePhone,
c.Email,
c.DataOfAccount);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Deposit_Load(object sender, EventArgs e)
{
AutoCompleteStringCollection collection = new AutoCompleteStringCollection();
collection.AddRange(DataBaseOperations.getAccountIban().ToArray());
textBoxIbanDeposit.AutoCompleteCustomSource = collection;
}
private void Transfer_Load(object sender, EventArgs e)
{
AutoCompleteStringCollection collection = new AutoCompleteStringCollection();
collection.AddRange(DataBaseOperations.getAccountIban().ToArray());
textBoxFromIBanTransfer.AutoCompleteCustomSource = collection;
textBoxDestinationIBAN.AutoCompleteCustomSource = collection;
}
private void WithdrawingMoney_Load(object sender, EventArgs e)
{
string[] mode = { "Cash", "Cheque" };
foreach (string items in mode)
{
comboBoxModeWithdraw.Items.Add(items);
}
AutoCompleteStringCollection collection = new AutoCompleteStringCollection();
collection.AddRange(DataBaseOperations.getAccountIban().ToArray());
textBoxIbanWithdraw.AutoCompleteCustomSource = collection;
}
public static void DeleteAccount(string iban)
{
string sqlIdAccount = $"select idUserAccount from user_account where iban = @iban;";
MySqlCommand command = DataBaseOperations.GetCommand(sqlIdAccount,
new MySqlParameter[] { new MySqlParameter("@iban", iban) });
command.Connection.Open();
int id = Convert.ToInt32(command.ExecuteScalar());
string sqlClosureAccount = "insert into account_closure " +
"(idUserAccount, Iban, FullName, Egn, Gender, Address, PostalCode, City, " +
"Country, MobilePhone, HomePhone, Email, DataOfAccount) " +
"select * from user_account as ua where ua.iban = @iban;";
command.CommandText = sqlClosureAccount;
command.ExecuteScalar();
string sqlDelete = $"delete from user_account where iban = @iban;";
command.CommandText = sqlDelete;
command.ExecuteScalar();
//Get fee
//insert
string sqlFeeChargesAccount = $"insert into fee_charges_account_closure" +
$"(idUserAccount, date_fee, amount) values (" +
$"@idUserAccount," +
$"@date_fee," +
$"@amount);";
MySqlParameter[] parameterFee =
{
new MySqlParameter("@idUserAccount", id),
new MySqlParameter("@date_fee", DateTime.Now),
new MySqlParameter("@amount", feeDeleteAccount.ToString().Replace(",", "."))
};
command.CommandText = sqlFeeChargesAccount;
command.Parameters.AddRange(parameterFee);
command.ExecuteScalar();
command.Connection.Close();
}
private void buttonGetDetailsUpdate_Click(object sender, EventArgs e)
{
try
{
if (textBoxIbanUpdate.Text == "")
{
MessageBox.Show("Please enter IBAN on customer !",
"Update account/Search .", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
customer.account = new AccountCustomer();
dataGridViewUpdate.Rows.Clear();
customer = DataBaseOperations.GetCustomerInformation(textBoxIbanUpdate.Text);
dataGridViewUpdate.Rows.Add(
customer.Id,
customer.account.Iban,
customer.FullName,
customer.Egn,
customer.gender,
customer.Address,
customer.PostalCode,
customer.City,
customer.Country,
customer.MobilePhone,
customer.HomePhone,
customer.Email,
customer.DataOfAccount);
labelInformationCustomer.Text = $"Information about " +
$"{customer.FullName}";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void buttonRandomIban_Click(object sender, EventArgs e)
{
Random randomIban = new Random();
int ran = randomIban.Next(100000000, 999999999);
textBoxIBAN.Text = ran.ToString();
if (DataBaseOperations.checkIban(ran.ToString()) == true)
{
MessageBox.Show("Already exists such a iban. ",
"NewAccount .", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
MessageBox.Show("The IBAN is valid.",
"NewAccount .", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
try
{
if (dataGridViewNewAccount.Rows.Count == 0)
{
MessageBox.Show("Please add the data to the table.",
"New Account .", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
DataBaseOperations.SaveCustomerAccount(customer, customer.account);
textBoxIBAN.Clear();
textBoxFirstNameCustomer.Clear();
textBoxMidddleNameCustomer.Clear();
textBoxLastNameCustomer.Clear();
textBoxEGNCustomer.Clear();
textBoxAddressCustomer.Clear();
textBoxPostCodeCustomer.Clear();
textBoxCityCustomer.Clear();
textBoxCountryCustomer.Clear();
textBoxMobilePhoneCustomer.Clear();
textBoxHomePhoneCustomer.Clear();
textBoxEmailCustomer.Clear();
dataGridViewNewAccount.Rows.Clear();
MessageBox.Show($"Account IBAN {customer.account.Iban} was successfully saved .",
"NewAccount .", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void buttonSignIn_Click(object sender, EventArgs e)
{
try
{
LoginEmployee.LoginEmployee login = new LoginEmployee.LoginEmployee();
login.Username = textBoxUserName.Text;
login.Password = textBoxPassword.Text;
if (DataBaseOperations.checkUser(login.Username, login.Password) == true)
{
МainМenuBank menu = new МainМenuBank();
menu.Show();
this.Hide();
}
else
{
if (++clickFourLogin == 4)
{
MessageBox.Show("There is no such account ! " +
"Please check your password or username again.",
"Unsuccessful entry .", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Please check username or password .",
"Unsuccessful entry .", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Retains the transfer service data in the database table
/// and the transfer fee in another table
/// </summary>
/// <param name="sender"></param>
/// <param name="receiver"></param>
/// <param name="amountTransfer"></param>
public static void TransferMoney(AccountCustomer sender, AccountCustomer receiver,
decimal amountTransfer)
{
try
{
if (sender.Iban == null)
{
throw new ArgumentException("Sender IBAN is null.");
}
if (DataBaseOperations.getBalance(sender.Iban).Balance >= amountTransfer + GetFeeTransfer(amountTransfer))
{
string sqlSender = $"select idUserAccount from user_account where iban = @ibanSender;";
MySqlCommand command = DataBaseOperations.GetCommand(sqlSender,
new MySqlParameter[] { new MySqlParameter("@ibanSender", sender.Iban) });
command.Connection.Open();
int pkSender = Convert.ToInt32(command.ExecuteScalar());
string sqlReseiver = $"select idUserAccount from user_account where iban = @ibanReceiver;";
command.CommandText = sqlReseiver;
command.Parameters.AddWithValue("@ibanReceiver", receiver.Iban);
int pkReceiver = Convert.ToInt32(command.ExecuteScalar());
//Transfer
string sqlTransfer = $"insert into transfer_customer" +
$"(IDSender_Customer, IDRecipient_Customer, DataOfTransfer, Amount_Transfer) values (" +
$"@IDSender_Customer," +
$"@IDRecipient_Customer," +
$"@DataOfTransfer," +
$"@Amount_Transfer)";
MySqlParameter[] parametersTransfer =
{
new MySqlParameter("@IDSender_Customer", pkSender),
new MySqlParameter("@IDRecipient_Customer", pkReceiver),
new MySqlParameter("@DataOfTransfer", DateTime.Now),
new MySqlParameter("@Amount_Transfer", amountTransfer.ToString().Replace(",", "."))
};
command.CommandText = sqlTransfer;
command.Parameters.AddRange(parametersTransfer);
command.ExecuteScalar();
//Get Fee
//INSERT
string sqlChargesTransfer = $"insert into fee_charges_transfer" +
$"(iduser_account, date_fee, amount) values (" +
$"@iduser_account," +
$"@date_fee," +
$"@amount)";
MySqlParameter[] parametersChargesTransfer =
{
new MySqlParameter("@iduser_account", pkSender),
new MySqlParameter("@date_fee", DateTime.Now),
new MySqlParameter("@amount", GetFeeTransfer(amountTransfer).ToString().Replace(",", "."))
};
command.CommandText = sqlChargesTransfer;
command.Parameters.AddRange(parametersChargesTransfer);
command.ExecuteScalar();
command.Connection.Close();
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
