public static List <AbstractTransaction> GetTransactionList(string accountNumber) { string sql = "SELECT [idTransaction],[idOriginAccount],[idDestinationAccount],[amount],[transactionType],[transactionDate],[beginDate],[endDate],[periodicity]" + " FROM [Transaction] WHERE idOriginAccount= @idAccount"; SqlCommand cmd = new SqlCommand(); cmd.Connection = GetConnexion; cmd.CommandText = sql; cmd.Parameters.Add(new SqlParameter("@idAccount", GetIdAccountFromAccountNumber(accountNumber))); List <AbstractTransaction> newTransactiontList = new List <AbstractTransaction>(); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { String transactionType = reader.GetString(reader.GetOrdinal("transactionType")); AbstractTransaction transaction = AbstractTransaction.Create(transactionType); transaction.IdTransaction = reader.GetInt32(reader.GetOrdinal("idTransaction")); transaction.AccountOrigin = reader.GetInt32(reader.GetOrdinal("idOriginAccount")); transaction.AccountDestination = reader.GetInt32(reader.GetOrdinal("idDestinationAccount")); transaction.Amount = reader.GetDecimal(reader.GetOrdinal("amount")); transaction.TransactionDate = reader.GetDateTime(reader.GetOrdinal("transactionDate")); transaction.StartDate = reader.GetDateTime(reader.GetOrdinal("beginDate")); transaction.EndDate = reader.GetDateTime(reader.GetOrdinal("endDate")); transaction.Periodicity = reader.GetInt32(reader.GetOrdinal("periodicity")); newTransactiontList.Add(transaction); } } return(newTransactiontList); } }
public void MakeNewTransaction(decimal amount, AbstractAccount accountOrigin, AbstractAccount accountDestination, DateTime?startDate = null, DateTime?endDate = null, int periodicity = 0) { AbstractTransaction currentTransaction = AbstractTransaction.Create(startDate, endDate); currentTransaction.AccountOrigin = accountOrigin.IdAccount; currentTransaction.AccountDestination = accountDestination.IdAccount; currentTransaction.Amount = amount; currentTransaction.Periodicity = periodicity; currentTransaction.TransactionDate = DateTime.Now; DBQuery.InsertTransaction(currentTransaction); List <TransferMoney> transfertList = currentTransaction.GetTransferts(); Console.WriteLine("We do the transfer"); DBQuery.SaveNewTransferInDb(transfertList); }