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); }