public void DeleteFromDatabase_RecurringPaymentToDelete_CorrectlyDelete()
{
var payment = new RecurringPayment {
Note = "paymentToDelete"
};
var dataAccess = new RecurringPaymentDataAccess(connectionCreator);
dataAccess.SaveItem(payment);
Assert.IsTrue(dataAccess.LoadList(x => x.Id == payment.Id).Any());
dataAccess.DeleteItem(payment);
Assert.IsFalse(dataAccess.LoadList(x => x.Id == payment.Id).Any());
}
public void SaveToDatabase_ExistingRecurringPayment_CorrectId()
{
var payment = new RecurringPayment();
var dataAccess = new RecurringPaymentDataAccess(connectionCreator);
dataAccess.SaveItem(payment);
Assert.AreEqual(0, payment.Amount);
var id = payment.Id;
var amount = 789;
payment.Amount = amount;
Assert.AreEqual(id, payment.Id);
Assert.AreEqual(amount, payment.Amount);
}
public void SaveToDatabase_ExistingRecurringPayment_CorrectId()
{
var payment = new RecurringPayment();
var dataAccess = new RecurringPaymentDataAccess(connectionCreator);
dataAccess.SaveItem(payment);
Assert.AreEqual(0, payment.Amount);
var id = payment.Id;
var amount = 789;
payment.Amount = amount;
Assert.AreEqual(id, payment.Id);
Assert.AreEqual(amount, payment.Amount);
}
public void SaveToDatabase_MultipleRecurringPayment_AllSaved()
{
var payment1 = new RecurringPayment {
Note = "MultiPayment1"
};
var payment2 = new RecurringPayment {
Note = "MultiPayment2"
};
var dataAccess = new RecurringPaymentDataAccess(connectionCreator);
dataAccess.SaveItem(payment1);
dataAccess.SaveItem(payment2);
var resultList = dataAccess.LoadList();
Assert.IsTrue(resultList.Any(x => x.Id == payment1.Id && x.Note == payment1.Note));
Assert.IsTrue(resultList.Any(x => x.Id == payment2.Id && x.Note == payment2.Note));
}
public void SaveToDatabase_MultipleRecurringPayment_AllSaved()
{
var payment1 = new RecurringPayment
{
Note = "MultiRecPayment1"
};
var payment2 = new RecurringPayment
{
Note = "MultiRecPayment2"
};
var dataAccess = new RecurringPaymentDataAccess(connectionCreator);
dataAccess.SaveItem(payment1);
dataAccess.SaveItem(payment2);
var resultList = dataAccess.LoadList();
Assert.IsTrue(resultList.Any(x => x.Id == payment1.Id && x.Note == payment1.Note));
Assert.IsTrue(resultList.Any(x => x.Id == payment2.Id && x.Note == payment2.Note));
}
public void SaveToDatabase_CreateAndUpdateRecurringPayment_CorrectlyUpdated()
{
var firstAmount = 5555555;
var secondAmount = 222222222;
var payment = new RecurringPayment {
Amount = firstAmount
};
var dataAccess = new RecurringPaymentDataAccess(connectionCreator);
dataAccess.SaveItem(payment);
Assert.AreEqual(firstAmount, dataAccess.LoadList().FirstOrDefault(x => x.Id == payment.Id).Amount);
payment.Amount = secondAmount;
dataAccess.SaveItem(payment);
var categories = dataAccess.LoadList();
Assert.IsFalse(categories.Any(x => x.Amount == firstAmount));
Assert.AreEqual(secondAmount, categories.First(x => x.Id == payment.Id).Amount);
}
public void SaveToDatabase_CreateAndUpdateRecurringPayment_CorrectlyUpdated()
{
var firstAmount = 5555555;
var secondAmount = 222222222;
var payment = new RecurringPayment
{
Amount = firstAmount
};
var dataAccess = new RecurringPaymentDataAccess(connectionCreator);
dataAccess.SaveItem(payment);
Assert.AreEqual(firstAmount, dataAccess.LoadList().FirstOrDefault(x => x.Id == payment.Id).Amount);
payment.Amount = secondAmount;
dataAccess.SaveItem(payment);
var categories = dataAccess.LoadList();
Assert.IsFalse(categories.Any(x => x.Amount == firstAmount));
Assert.AreEqual(secondAmount, categories.First(x => x.Id == payment.Id).Amount);
}
public void DeleteFromDatabase_RecurringPaymentToDelete_CorrectlyDelete()
{
var payment = new RecurringPayment
{
Note = "paymentToDelete"
};
var dataAccess = new RecurringPaymentDataAccess(connectionCreator);
dataAccess.SaveItem(payment);
Assert.IsTrue(dataAccess.LoadList(x => x.Id == payment.Id).Any());
dataAccess.DeleteItem(payment);
Assert.IsFalse(dataAccess.LoadList(x => x.Id == payment.Id).Any());
}
