public void Data_Read_Transactions_By_Account_Date_And_Category() { var repository = new TransactionRepository(_dataConnectionString, 1); var data = repository.GetForAccount(1, 4, new DateTime(2015, 01, 02), new DateTime(2015, 01, 06)).ToList(); Assert.IsTrue(data.Count == 4); Assert.IsTrue(data[0].TransactionID == 14); Assert.IsTrue(data[0].Category_CategoryID == 4); Assert.IsTrue(data[0].CategoryName == "Bills"); Assert.IsTrue(data[0].Description == "USER1CURRENT14"); Assert.IsTrue(data[0].Note == "Water"); Assert.IsTrue(data[1].TransactionID == 11); Assert.IsTrue(data[1].Category_CategoryID == 4); Assert.IsTrue(data[1].CategoryName == "Bills"); Assert.IsTrue(data[1].Description == "USER1CURRENT11"); Assert.IsTrue(data[1].Note == "Electricity"); Assert.IsTrue(data[2].TransactionID == 7); Assert.IsTrue(data[2].Category_CategoryID == 4); Assert.IsTrue(data[2].CategoryName == "Bills"); Assert.IsTrue(data[2].Description == "USER1CURRENT7"); Assert.IsTrue(data[2].Note == "Mobile"); Assert.IsTrue(data[3].TransactionID == 4); Assert.IsTrue(data[3].Category_CategoryID == 4); Assert.IsTrue(data[3].CategoryName == "Bills"); Assert.IsTrue(data[3].Description == "USER1CURRENT4"); Assert.IsTrue(data[3].Note == "Gas"); }
public void Data_Sum_Transactions_By_Account_Up_To_Date() { var repository = new TransactionRepository(_dataConnectionString, 1); var sum = repository.GetTotalForAccountUpTo(1, new DateTime(2015, 01, 03)); Assert.IsTrue(sum == 535.50M); }
public void Data_Read_Transactions_By_Account() { var repository = new TransactionRepository(_dataConnectionString, 1); var data = repository.GetForAccount(1).ToList(); // There are 15 test transactions for this user (and one deleted) in date descending order Assert.IsTrue(data.Count == 15); Assert.IsTrue(data[0].TransactionID == 31); Assert.IsTrue(data[0].Category_CategoryID == null); Assert.IsTrue(data[0].CategoryName == null); Assert.IsTrue(data[0].Description == "USER1CURRENT15"); Assert.IsTrue(data[0].Amount == -5.00M); Assert.IsTrue(data[14].TransactionID == 1); Assert.IsTrue(data[14].Category_CategoryID == 1); Assert.IsTrue(data[14].CategoryName == "Salary"); Assert.IsTrue(data[14].Description == "USER1CURRENT1"); Assert.IsTrue(data[14].Amount == 1000.00M); }
public void Data_Read_Transactions_By_Account_And_Date() { var repository = new TransactionRepository(_dataConnectionString, 1); var data = repository.GetForAccount(1, new DateTime(2015, 01, 02), new DateTime(2015, 01, 04)).ToList(); Assert.IsTrue(data.Count == 7); Assert.IsTrue(data[0].TransactionID == 10); Assert.IsTrue(data[0].Category_CategoryID == 3); Assert.IsTrue(data[0].CategoryName == "Food"); Assert.IsTrue(data[0].Description == "USER1CURRENT10"); Assert.IsTrue(data[0].Note == null); Assert.IsTrue(data[6].TransactionID == 4); Assert.IsTrue(data[6].Category_CategoryID == 4); Assert.IsTrue(data[6].CategoryName == "Bills"); Assert.IsTrue(data[6].Description == "USER1CURRENT4"); Assert.IsTrue(data[6].Note == "Gas"); }
public void Data_Read_Transaction() { var repository = new TransactionRepository(_dataConnectionString, 1); var data = repository.Get(1); Assert.IsTrue(data.TransactionID == 1); Assert.IsTrue(data.Category_CategoryID == 1); Assert.IsTrue(data.CategoryName == "Salary"); Assert.IsTrue(data.Description == "USER1CURRENT1"); }
public void Data_Read_Transactions() { var repository = new TransactionRepository(_dataConnectionString, 1); var data = repository.All().ToList(); // There are 19 test transactions for this user (and one deleted) in date descending order Assert.IsTrue(data.Count == 19); Assert.IsTrue(data[0].Account_AccountID == 1); Assert.IsTrue(data[0].AccountName == "Current"); Assert.IsTrue(data[0].TransactionID == 31); Assert.IsTrue(data[0].Category_CategoryID == null); Assert.IsTrue(data[0].CategoryName == null); Assert.IsTrue(data[0].Description == "USER1CURRENT15"); Assert.IsTrue(data[0].Amount == -5.00M); Assert.IsTrue(data[1].Account_AccountID == 1); Assert.IsTrue(data[1].AccountName == "Current"); Assert.IsTrue(data[1].TransactionID == 14); Assert.IsTrue(data[1].Category_CategoryID == 4); Assert.IsTrue(data[1].CategoryName == "Bills"); Assert.IsTrue(data[1].Description == "USER1CURRENT14"); Assert.IsTrue(data[1].Note == "Water"); Assert.IsTrue(data[1].Amount == -25.00M); Assert.IsTrue(data[6].Account_AccountID == 2); Assert.IsTrue(data[6].AccountName == "Savings"); Assert.IsTrue(data[6].TransactionID == 19); Assert.IsTrue(data[6].Category_CategoryID == null); Assert.IsTrue(data[6].CategoryName == null); Assert.IsTrue(data[6].Description == "USER1SAVINGS19"); Assert.IsTrue(data[6].Amount == 9.50M); Assert.IsTrue(data[18].Account_AccountID == 1); Assert.IsTrue(data[18].AccountName == "Current"); Assert.IsTrue(data[18].TransactionID == 1); Assert.IsTrue(data[18].Category_CategoryID == 1); Assert.IsTrue(data[18].CategoryName == "Salary"); Assert.IsTrue(data[18].Description == "USER1CURRENT1"); Assert.IsTrue(data[18].Amount == 1000.00M); }
public void Data_Read_Other_User_Transactions_By_Account() { var repository = new TransactionRepository(_dataConnectionString, 1); var data = repository.GetForAccount(5).ToList(); Assert.IsTrue(data.Count == 0); }
public void Data_Read_Other_User_Transaction() { var repository = new TransactionRepository(_dataConnectionString, 1); var data = repository.Get(21); Assert.IsTrue(data == null); }
public void Data_Delete_Transaction() { var repository = new TransactionRepository(_dataConnectionString, 1); var result = repository.Delete(1); var transaction = repository.Get(1); Assert.IsTrue(transaction == null); Assert.IsTrue(result.Deleted == true); Assert.IsTrue(result.DeletedBy == 1); Assert.IsTrue(result.DeletedDate.Value.Date == DateTime.Now.Date); }
public void Data_Create_Transaction() { var repository = new TransactionRepository(_dataConnectionString, 1); var transaction = new MABMoney.Domain.Transaction { Account_AccountID = 1, Category_CategoryID = 3, Description = "ADDED", Amount = -10.25M, Date = new DateTime(2015, 1, 10, 18, 35, 10, 0), Note = "BISCUITS", TransferGUID = "5485364b-cac5-4c14-9638-5e7c0235a7c1" }; var result = repository.Add(transaction); Assert.IsTrue(result.TransactionID == 32); Assert.IsTrue(result.Account_AccountID == 1); Assert.IsTrue(result.AccountName == "Current"); Assert.IsTrue(result.Category_CategoryID == 3); Assert.IsTrue(result.CategoryName == "Food"); Assert.IsTrue(result.Description == "ADDED"); Assert.IsTrue(result.Amount == -10.25M); Assert.IsTrue(result.Date == new DateTime(2015, 1, 10, 18, 35, 10, 0)); Assert.IsTrue(result.Note == "BISCUITS"); Assert.IsTrue(result.TransferGUID == "5485364b-cac5-4c14-9638-5e7c0235a7c1"); Assert.IsTrue(result.CreatedBy == 1); Assert.IsTrue(result.CreatedDate.Date == DateTime.Now.Date); Assert.IsTrue(result.LastModifiedBy == 1); Assert.IsTrue(result.LastModifiedDate.Date == DateTime.Now.Date); }
public void Data_Update_Transaction() { var repository = new TransactionRepository(_dataConnectionString, 1); var transaction = repository.Get(1); transaction.Account_AccountID = 3; transaction.Category_CategoryID = 6; transaction.Description = "UPDATED"; transaction.Amount = -30.00M; transaction.Date = new DateTime(2015, 1, 11, 11, 40, 30, 0); transaction.Note = "MOVEDTOCREDIT"; transaction.TransferGUID = "5485364b-cac5-4c14-9638-5e7c0235a7c1"; var result = repository.Update(transaction); Assert.IsTrue(result.TransactionID == 1); Assert.IsTrue(result.Account_AccountID == 3); Assert.IsTrue(result.AccountName == "Credit"); Assert.IsTrue(result.Category_CategoryID == 6); Assert.IsTrue(result.CategoryName == "Payments"); Assert.IsTrue(result.Description == "UPDATED"); Assert.IsTrue(result.Amount == -30.00M); Assert.IsTrue(result.Date == new DateTime(2015, 1, 11, 11, 40, 30, 0)); Assert.IsTrue(result.Note == "MOVEDTOCREDIT"); Assert.IsTrue(result.TransferGUID == "5485364b-cac5-4c14-9638-5e7c0235a7c1"); Assert.IsTrue(result.LastModifiedBy == 1); Assert.IsTrue(result.LastModifiedDate.Date == DateTime.Now.Date); }