public void LoadRecurringList_ListWithRecurringTransaction()
{
var dbHelper = new SqliteConnectionCreator(new WindowsSqliteConnectionFactory());
var transactionDataAccess =
new TransactionDataAccess(dbHelper);
var recTransactionDataAccess =
new RecurringTransactionDataAccess(dbHelper);
var repository = new TransactionRepository(transactionDataAccess, recTransactionDataAccess);
transactionDataAccess.SaveItem(new FinancialTransaction {Amount = 999, IsRecurring = false});
transactionDataAccess.SaveItem(new FinancialTransaction
{
Amount = 123,
IsRecurring = true,
RecurringTransaction = new RecurringTransaction {IsEndless = true}
});
repository.Load();
var result = repository.LoadRecurringList().ToList();
result.Count.ShouldBe(1);
result.First().Id.ShouldBe(2);
result.First().RecurringTransaction.Id.ShouldBe(1);
}
public void RecurringTransactionDataAccess_CrudRecurringTransaction()
{
var recurringTransactionDataAccess =
new RecurringTransactionDataAccess(new SqliteConnectionCreator(new WindowsSqliteConnectionFactory()));
const double firstAmount = 100.70;
const double secondAmount = 80.45;
var transaction = new RecurringTransaction
{
ChargedAccountId = 7,
Amount = firstAmount,
StartDate = DateTime.Today,
EndDate = DateTime.Now.AddDays(7),
Note = "this is a note!!!"
};
recurringTransactionDataAccess.SaveItem(transaction);
var list = recurringTransactionDataAccess.LoadList();
Assert.Equal(1, list.Count);
Assert.Equal(firstAmount, list.First().Amount);
transaction.Amount = secondAmount;
recurringTransactionDataAccess.SaveItem(transaction);
recurringTransactionDataAccess.LoadList();
list = recurringTransactionDataAccess.LoadList();
Assert.Equal(1, list.Count);
Assert.Equal(secondAmount, list.First().Amount);
recurringTransactionDataAccess.DeleteItem(transaction);
recurringTransactionDataAccess.LoadList();
list = recurringTransactionDataAccess.LoadList();
Assert.False(list.Any());
}
public void RecurringTransactionDataAccess_CrudRecurringTransaction()
{
var recurringTransactionDataAccess = new RecurringTransactionDataAccess();
const double firstAmount = 100.70;
const double secondAmount = 80.45;
var transaction = new RecurringTransaction {
ChargedAccountId = 7,
Amount = firstAmount,
StartDate = DateTime.Today,
EndDate = DateTime.Now.AddDays(7),
Note = "this is a note!!!"
};
recurringTransactionDataAccess.Save(transaction);
var list = recurringTransactionDataAccess.LoadList();
Assert.AreEqual(1, list.Count);
Assert.AreEqual(firstAmount, list.First().Amount);
transaction.Amount = secondAmount;
recurringTransactionDataAccess.Save(transaction);
recurringTransactionDataAccess.LoadList();
list = recurringTransactionDataAccess.LoadList();
Assert.AreEqual(1, list.Count);
Assert.AreEqual(secondAmount, list.First().Amount);
recurringTransactionDataAccess.Delete(transaction);
recurringTransactionDataAccess.LoadList();
list = recurringTransactionDataAccess.LoadList();
Assert.IsFalse(list.Any());
}
public void RecurringTransactionDataAccess_CrudRecurringTransaction()
{
var recurringTransactionDataAccess = new RecurringTransactionDataAccess(new DbHelper(new SQLitePlatformWinRT(), new TestDatabasePath()));
const double firstAmount = 100.70;
const double secondAmount = 80.45;
var transaction = new RecurringTransaction
{
ChargedAccountId = 7,
Amount = firstAmount,
StartDate = DateTime.Today,
EndDate = DateTime.Now.AddDays(7),
Note = "this is a note!!!"
};
recurringTransactionDataAccess.Save(transaction);
var list = recurringTransactionDataAccess.LoadList();
Assert.AreEqual(1, list.Count);
Assert.AreEqual(firstAmount, list.First().Amount);
transaction.Amount = secondAmount;
recurringTransactionDataAccess.Save(transaction);
recurringTransactionDataAccess.LoadList();
list = recurringTransactionDataAccess.LoadList();
Assert.AreEqual(1, list.Count);
Assert.AreEqual(secondAmount, list.First().Amount);
recurringTransactionDataAccess.Delete(transaction);
recurringTransactionDataAccess.LoadList();
list = recurringTransactionDataAccess.LoadList();
Assert.IsFalse(list.Any());
}
