public void AddNewTransaction(BankTransactionDTO bankTransactionDTO)
{
using (IDbConnection connection = new SQLiteConnection(_connectionString))
{
string insertQuery = $@"INSERT INTO BankTransaction (TransactionDateTime,BankAccountId,TransactionAmount,TransactionType,IsDeleted)
VALUES ('{bankTransactionDTO.TransactionDateTime.ToString("yyyy-MM-dd HH:mm:ss.fff")}','{bankTransactionDTO.BankAccountId}',{bankTransactionDTO.TransactionAmount},{(int)bankTransactionDTO.TransactionType},0)";
connection.Execute(insertQuery);
}
}
public void DepositIntoAccount(int bankAccountId, double amount)
{
BankTransactionDTO bankTransactionDTO = new BankTransactionDTO()
{
BankAccountId = bankAccountId,
TransactionAmount = amount,
TransactionDateTime = DateTime.Now,
TransactionType = PublicEnum.TransactionType.Deposit
};
_databaseFunctions.AddNewTransaction(bankTransactionDTO);
}
