public void Data_Read_Categories_By_Account() { var repository = new CategoryRepository(_dataConnectionString, 1); var data = repository.All(1).OrderBy(x => x.CategoryID).ToList(); // There are 10 test categories, but only 4 for this account and user Assert.IsTrue(data.Count == 4); Assert.IsTrue(data[0].CategoryID == 1); Assert.IsTrue(data[0].Name == "Salary"); Assert.IsTrue(data[0].Account_AccountID == 1); Assert.IsTrue(data[0].AccountName == "Current"); Assert.IsTrue(data[1].CategoryID == 2); Assert.IsTrue(data[1].Name == "Rent"); Assert.IsTrue(data[1].Account_AccountID == 1); Assert.IsTrue(data[1].AccountName == "Current"); Assert.IsTrue(data[2].CategoryID == 3); Assert.IsTrue(data[2].Name == "Food"); Assert.IsTrue(data[2].Account_AccountID == 1); Assert.IsTrue(data[2].AccountName == "Current"); Assert.IsTrue(data[3].CategoryID == 4); Assert.IsTrue(data[3].Name == "Bills"); Assert.IsTrue(data[3].Account_AccountID == 1); Assert.IsTrue(data[3].AccountName == "Current"); }
public void Data_Read_Categories() { var repository = new CategoryRepository(_dataConnectionString, 1); var data = repository.All().OrderBy(x => x.CategoryID).ToList(); // There are 8 test categories for this user but 2 are deleted Assert.IsTrue(data.Count == 6); Assert.IsTrue(data[0].CategoryID == 1); Assert.IsTrue(data[0].Name == "Salary"); Assert.IsTrue(data[0].Account_AccountID == 1); Assert.IsTrue(data[0].AccountName == "Current"); Assert.IsTrue(data[1].CategoryID == 2); Assert.IsTrue(data[1].Name == "Rent"); Assert.IsTrue(data[1].Account_AccountID == 1); Assert.IsTrue(data[1].AccountName == "Current"); Assert.IsTrue(data[2].CategoryID == 3); Assert.IsTrue(data[2].Name == "Food"); Assert.IsTrue(data[2].Account_AccountID == 1); Assert.IsTrue(data[2].AccountName == "Current"); Assert.IsTrue(data[3].CategoryID == 4); Assert.IsTrue(data[3].Name == "Bills"); Assert.IsTrue(data[3].Account_AccountID == 1); Assert.IsTrue(data[3].AccountName == "Current"); Assert.IsTrue(data[4].CategoryID == 6); Assert.IsTrue(data[4].Name == "Payments"); Assert.IsTrue(data[4].Account_AccountID == 3); Assert.IsTrue(data[4].AccountName == "Credit"); Assert.IsTrue(data[5].CategoryID == 7); Assert.IsTrue(data[5].Name == "Bills"); Assert.IsTrue(data[5].Account_AccountID == 3); Assert.IsTrue(data[5].AccountName == "Credit"); }