public void AddAccountAndTransactionTest()
{
using (var dbContext = new PersonalManagerDbContext())
{
var account = new Account
{
AccountName = "Account 5465",
AccountType = "Test type 2",
Balance = -51.2,
CreationTime = DateTime.Now,
Currency = "Dollar"
};
var transaction = new Transaction()
{
Amount = -530.151,
IsIncome = false,
TransactionType = "Shopping dafdsafsadfadsdv"
};
account.Transactions.Add(transaction);
dbContext.Accounts.Add(account);
dbContext.SaveChanges();
var storedAccount = dbContext.Accounts.Find(account.AccountId);
var storedTransaction = dbContext.Transactions.Find(transaction.TransactionId);
var listOfTransactions = new List <Transaction>(storedAccount.Transactions);
dbContext.Transactions.Remove(storedTransaction);
dbContext.Accounts.Remove(storedAccount);
dbContext.SaveChanges();
Assert.IsTrue(EntitiesComparator.CompareTransactions(storedTransaction, listOfTransactions.First()),
"Transaction of Account has not been properly set");
}
}
public void AddAccountAndAccountBalanceTest()
{
using (var dbContext = new PersonalManagerDbContext())
{
var account = new Account
{
AccountName = "Account 5465",
AccountType = "Test type 2",
Balance = -51.2,
CreationTime = DateTime.Now,
Currency = "Dollar"
};
var accountBalance = new AccountBalance
{
Balance = -65421.74,
UpdateTime = DateTime.Now
};
account.AccountBalance.Add(accountBalance);
dbContext.Accounts.Add(account);
dbContext.SaveChanges();
var storedAccount = dbContext.Accounts.Find(account.AccountId);
var storedAccountBalance = dbContext.AccountBalances.Find(accountBalance.AccountBalanceId);
var listOfBalances = new List <AccountBalance>(storedAccount.AccountBalance);
dbContext.AccountBalances.Remove(storedAccountBalance);
dbContext.Accounts.Remove(storedAccount);
dbContext.SaveChanges();
Assert.IsTrue(EntitiesComparator.CompareAccountBalances(storedAccountBalance, listOfBalances.First()),
"AccountBalance of Account has not been properly set");
}
}
public void AddAccountBalanceSetNoAttributesTest()
{
using (var dbContext = new PersonalManagerDbContext())
{
var accountBalance = new AccountBalance();
dbContext.AccountBalances.Add(accountBalance);
AccountBalance storedAccountBalance = dbContext.AccountBalances.Find(accountBalance.AccountBalanceId);
dbContext.AccountBalances.Remove(storedAccountBalance);
dbContext.SaveChanges();
Assert.IsTrue(EntitiesComparator.CompareAccountBalances(accountBalance, storedAccountBalance),
$"{accountBalance} is not the same as {storedAccountBalance}");
}
}
public void AddTransactionSetNoAttributesTest()
{
using (var dbContext = new PersonalManagerDbContext())
{
var transaction = new Transaction();
dbContext.Transactions.Add(transaction);
Transaction storedTransaction = dbContext.Transactions.Find(transaction.TransactionId);
dbContext.Transactions.Remove(storedTransaction);
dbContext.SaveChanges();
Assert.IsTrue(EntitiesComparator.CompareTransactions(transaction, storedTransaction),
$"{transaction} is not the same as {storedTransaction}");
}
}
public void AddUserTest()
{
using (var dbContext = new PersonalManagerDbContext())
{
User user = new User()
{
Email = "*****@*****.**",
PasswordHash = "adfdagargfaxgfdbs754edfs54fsef",
};
dbContext.Users.Add(user);
User storedUser = dbContext.Users.Find(user.Id);
dbContext.Users.Remove(user);
dbContext.SaveChanges();
Assert.IsTrue(EntitiesComparator.CompareUsersIdMailPassword(storedUser, user));
}
}
public void AddTransactionSetAllAttributesExceptIdTest()
{
using (var dbContext = new PersonalManagerDbContext())
{
var transaction = new Transaction
{
Amount = 547.2,
IsIncome = true,
TransactionType = "Shopping"
};
dbContext.Transactions.Add(transaction);
dbContext.SaveChanges();
Transaction storedTransaction = dbContext.Transactions.Find(transaction.TransactionId);
dbContext.Transactions.Remove(storedTransaction);
dbContext.SaveChanges();
Assert.IsTrue(EntitiesComparator.CompareTransactions(transaction, storedTransaction),
$"{transaction} is not the same as {storedTransaction}");
}
}
public void AddAccountSetAllAttributesExceptIdTest()
{
using (var dbContext = new PersonalManagerDbContext())
{
var account = new Account
{
AccountName = "Test account",
AccountType = "Test type",
Balance = 25.4,
CreationTime = DateTime.Now,
Currency = "Euro"
};
dbContext.Accounts.Add(account);
dbContext.SaveChanges();
var storedAccount = dbContext.Accounts.Find(account.AccountId);
dbContext.Accounts.Remove(storedAccount);
dbContext.SaveChanges();
Assert.IsTrue(EntitiesComparator.CompareAccounts(account, storedAccount), $"{account} is not the same as {storedAccount}");
}
}
