private void Process_Load(object sender, EventArgs e)
{
labelUserName.Text = dtUser.Rows[0]["FIRST_NAME"].ToString() + " " + dtUser.Rows[0]["LAST_NAME"].ToString();
myQuery = new MySQLQuery();
dtCurrent = myQuery.GetCurrent(dtUser.Rows[0]["IBAN"].ToString());
if (dtCurrent.Rows.Count < 1)
{
SetDeposit("0");
}
else
{
SetDeposit(Convert.ToDecimal(dtCurrent.Rows[0]["CURRENT"]).ToString("0.##"));
}
}
private void btTransfer_Click(object sender, EventArgs e)
{
try{
// Check transfer user
string stTransAcc = mtbTransAcc.Text.Trim();
if (String.IsNullOrEmpty(stTransAcc))
{
MessageBox.Show("No account to transfer.");
return;
}
DataTable dtReceiver = myQuery.CheckUser(stTransAcc);
if (dtReceiver.Rows.Count != 1)
{
MessageBox.Show("Account to transfer is not found.");
return;
}
// Check amount
string stTrAmount = mtbTranAmount.Text.Trim();
if (String.IsNullOrEmpty(stTrAmount))
{
MessageBox.Show("No money to transfer!");
return;
}
decimal dcTransfer = Convert.ToDecimal(stTrAmount);
if (dcTransfer <= 0)
{
MessageBox.Show("No money to transfer!");
return;
}
// Check over amount
decimal dcSender = Convert.ToDecimal(dtCurrent.Rows[0]["CURRENT"]);
if (dcSender < dcTransfer)
{
MessageBox.Show("Money is not enough!");
return;
}
// Transfer Money
string stIBSend = dtUser.Rows[0]["IBAN"].ToString();
string stIBRecv = dtReceiver.Rows[0]["IBAN"].ToString();
decimal dcCurSender = dcSender - dcTransfer;
DataTable dtRecv = myQuery.GetCurrent(stIBRecv);
decimal dcCurRecv = dtRecv.Rows.Count < 1 ? 0 : Convert.ToDecimal(dtRecv.Rows[0]["CURRENT"]);
dcCurRecv += dcTransfer;
bool bExecute = myQuery.Transfer(stIBSend, stIBRecv, dcCurSender, dcCurRecv, dcTransfer);
if (bExecute)
{
dtCurrent.Rows[0]["CURRENT"] = dcCurSender;
SetDeposit(dcCurSender.ToString("0.##"));
mtbTranAmount.Text = string.Empty;
MessageBox.Show("Transfer Complete");
}
else
{
MessageBox.Show("Transfer Unsuccessful");
}
}
catch (FormatException fex) {
MessageBox.Show("Wrong Format: " + fex.Message);
}catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}