public void SaveToDatabase_MultipleAccounts_AllSaved()
{
var account1 = new Account
{
Name = "Account1",
CurrentBalance = 1234
};
var account2 = new Account
{
Name = "Account2",
CurrentBalance = 999
};
var account3 = new Account();
var account4 = new Account();
var dataAccess = new AccountDataAccess(connectionCreator);
dataAccess.SaveItem(account1);
dataAccess.SaveItem(account2);
dataAccess.SaveItem(account3);
dataAccess.SaveItem(account4);
var resultList = dataAccess.LoadList();
Assert.AreNotSame(account1, account2);
Assert.IsTrue(resultList.Any(x => x.Id == account1.Id && x.Name == account1.Name));
Assert.IsTrue(resultList.Any(x => x.Id == account2.Id && x.Name == account2.Name));
}
public void SaveToDatabase_MultipleAccounts_AllSaved()
{
var account1 = new Account {
Name = "Account1",
CurrentBalance = 1234
};
var account2 = new Account {
Name = "Account2",
CurrentBalance = 999
};
var account3 = new Account();
var account4 = new Account();
var dataAccess = new AccountDataAccess(connectionCreator);
dataAccess.SaveItem(account1);
dataAccess.SaveItem(account2);
dataAccess.SaveItem(account3);
dataAccess.SaveItem(account4);
var resultList = dataAccess.LoadList();
Assert.AreNotSame(account1, account2);
Assert.IsTrue(resultList.Any(x => x.Id == account1.Id && x.Name == account1.Name));
Assert.IsTrue(resultList.Any(x => x.Id == account2.Id && x.Name == account2.Name));
}
public void SaveToDatabase_CreateAndUpdateAccount_CorrectlyUpdated()
{
var firstName = "old name";
var secondName = "new name";
var account = new Account
{
Name = firstName,
CurrentBalance = 1234
};
var dataAccess = new AccountDataAccess(connectionCreator);
dataAccess.SaveItem(account);
Assert.AreEqual(firstName, dataAccess.LoadList().FirstOrDefault(x => x.Id == account.Id).Name);
account.Name = secondName;
dataAccess.SaveItem(account);
var accounts = dataAccess.LoadList();
Assert.IsFalse(accounts.Any(x => x.Name == firstName));
Assert.AreEqual(secondName, accounts.First(x => x.Id == account.Id).Name);
}
public void SaveToDatabase_ExistingAccount_CorrectId()
{
var balance = 456468;
var account = new Account
{
CurrentBalance = balance
};
var dataAccess = new AccountDataAccess(connectionCreator);
dataAccess.SaveItem(account);
Assert.IsNull(account.Name);
var id = account.Id;
var name = "Sparkonto";
account.Name = name;
Assert.AreEqual(id, account.Id);
Assert.AreEqual(name, account.Name);
Assert.AreEqual(balance, account.CurrentBalance);
}
public void AccountDataAccess_CrudAccount()
{
var accountDataAccess =
new AccountDataAccess(new SqliteConnectionCreator(new WindowsSqliteConnectionFactory()));
const string firstName = "fooo Name";
const string secondName = "new Foooo";
var account = new Account
{
CurrentBalance = 20,
Iban = "CHF20 0000 00000 000000",
Name = firstName,
Note = "this is a note"
};
accountDataAccess.SaveItem(account);
accountDataAccess.LoadList();
var list = accountDataAccess.LoadList();
Assert.Equal(1, list.Count);
Assert.Equal(firstName, list.First().Name);
account.Name = secondName;
accountDataAccess.SaveItem(account);
list = accountDataAccess.LoadList();
Assert.Equal(1, list.Count);
Assert.Equal(secondName, list.First().Name);
accountDataAccess.DeleteItem(account);
list = accountDataAccess.LoadList();
Assert.False(list.Any());
}
public void DeleteFromDatabase_AccountToDelete_CorrectlyDelete()
{
var account = new Account {
Name = "accountToDelete",
CurrentBalance = 1234
};
var dataAccess = new AccountDataAccess(connectionCreator);
dataAccess.SaveItem(account);
Assert.IsTrue(dataAccess.LoadList(x => x.Id == account.Id).Any());
dataAccess.DeleteItem(account);
Assert.IsFalse(dataAccess.LoadList(x => x.Id == account.Id).Any());
}
public void SaveToDatabase_ExistingAccount_CorrectId()
{
var balance = 456468;
var account = new Account
{
CurrentBalance = balance
};
var dataAccess = new AccountDataAccess(connectionCreator);
dataAccess.SaveItem(account);
Assert.IsNull(account.Name);
var id = account.Id;
var name = "Sparkonto";
account.Name = name;
Assert.AreEqual(id, account.Id);
Assert.AreEqual(name, account.Name);
Assert.AreEqual(balance, account.CurrentBalance);
}
public void SaveToDatabase_CreateAndUpdateAccount_CorrectlyUpdated()
{
var firstName = "old name";
var secondName = "new name";
var account = new Account
{
Name = firstName,
CurrentBalance = 1234
};
var dataAccess = new AccountDataAccess(connectionCreator);
dataAccess.SaveItem(account);
Assert.AreEqual(firstName, dataAccess.LoadList().FirstOrDefault(x => x.Id == account.Id).Name);
account.Name = secondName;
dataAccess.SaveItem(account);
var accounts = dataAccess.LoadList();
Assert.IsFalse(accounts.Any(x => x.Name == firstName));
Assert.AreEqual(secondName, accounts.First(x => x.Id == account.Id).Name);
}
public void DeleteFromDatabase_AccountToDelete_CorrectlyDelete()
{
var account = new Account
{
Name = "accountToDelete",
CurrentBalance = 1234
};
var dataAccess = new AccountDataAccess(connectionCreator);
dataAccess.SaveItem(account);
Assert.IsTrue(dataAccess.LoadList(x => x.Id == account.Id).Any());
dataAccess.DeleteItem(account);
Assert.IsFalse(dataAccess.LoadList(x => x.Id == account.Id).Any());
}
