public void Add(Transaction transaction)
{
var parameter = new
{
transaction.FromCheckingAccountId,
transaction.ToCheckingAccountId,
transaction.Amount,
transaction.Created
};
var sqlInsert = $@"
INSERT INTO [Transaction]
( FromCheckingAccountId ,
ToCheckingAccountId ,
Amount ,
Active ,
Created
)
VALUES ( @FromCheckingAccountId ,
@ToCheckingAccountId ,
@Amount,
1 ,
@Created
)";
db.ExecuteScalar(sqlInsert, parameter);
}
public void UpdateBalance(long accountNumber, decimal newBalance)
{
var parameter = new
{
accountNumber,
newBalance,
updated = DateTime.UtcNow
};
var sqlUpdate = $@"UPDATE CheckingAccount
SET Balance = @newBalance,
Updated = @updated
WHERE AccountNumber = @accountNumber
AND Active = 1";
db.ExecuteScalar(sqlUpdate, parameter);
}
