protected void btnTransfer_Click(object sender, EventArgs e)
{
bool success = false;
int fromAccount, toAccount, amount;
string description = txtDescription.Text;
string transType = "Transfer";
DateTime stamp = DateTime.Now;
string transRef = "Online Transfer";
fromAccount = int.Parse(txtAccountNumber.Text);
toAccount = int.Parse(txtToAccountNumber.Text);
amount = int.Parse(txtAmount.Text);
Transaction newTransaction = new Transaction();
newTransaction.TransactionAccountNumber = fromAccount;
newTransaction.DestinationAccountNumber = toAccount;
newTransaction.TransactionType = transType;
newTransaction.TransactionReference = transRef;
newTransaction.TransactionAmount = amount;
newTransaction.TransactionDateTime = stamp;
newTransaction.TransactionDescription = description;
using (var _db = new CustomerContext())
{
try
{
_db.Transactions.Add(newTransaction);
success = true;
_db.SaveChanges();
}
catch (Exception ex)
{
FireBugWriter.Write(ex.Message);
}
}
using (var db = new CustomerContext())
{
int deductAmount = int.Parse(txtAmount.Text);
int accountNumber = int.Parse(txtAccountNumber.Text);
try
{
var query = (from a in db.Accounts
where a.AccountNumber == accountNumber
select a).First();
int newBalance = query.Balance - deductAmount;
query.Balance = newBalance;
db.SaveChanges();
}
catch (Exception ex)
{
FireBugWriter.Write(ex.Message);
}
}
using (var db = new CustomerContext())
{
int addAmount = int.Parse(txtAmount.Text);
int destinationAccount = int.Parse(txtToAccountNumber.Text);
try
{
var query = (from a in db.Accounts
where a.AccountNumber == destinationAccount
select a).First();
int newBalance = query.Balance + addAmount;
query.Balance = newBalance;
db.SaveChanges();
}
catch (Exception ex)
{
FireBugWriter.Write(ex.Message);
}
}
if (success)
{
txtAmount.Text = string.Empty;
txtDescription.Text = string.Empty;
txtReference.Text = string.Empty;
txtToAccountNumber.Text = string.Empty;
}
}
protected void btnTransfer_Click(object sender, EventArgs e)
{
bool success = false;
int fromAccount, toAccount, amount;
string description = txtDescription.Text;
string transType = "Transfer";
DateTime stamp = DateTime.Now;
string transRef = "Online Transfer";
fromAccount = int.Parse(txtFromAccount.Text);
toAccount = int.Parse(txtToAccount.Text);
amount = int.Parse(txtAmount.Text);
Transaction newTransaction = new Transaction();
newTransaction.TransactionAccountNumber = fromAccount;
newTransaction.DestinationAccountNumber = toAccount;
newTransaction.TransactionType = transType;
newTransaction.TransactionReference = transRef;
newTransaction.TransactionAmount = amount;
newTransaction.TransactionDateTime = stamp;
newTransaction.TransactionDescription = description;
using (var _db = new CustomerContext())
{
try
{
_db.Transactions.Add(newTransaction);
success = true;
_db.SaveChanges();
UpdateBalance();
if (success)
{
txtFromAccount.Text = string.Empty;
txtToAccount.Text = string.Empty;
txtAmount.Text = string.Empty;
}
}
catch (Exception ex)
{
FireBugWriter.Write(ex.Message);
}
}
}