public void Data_Read_Other_User_Category_Budget() { var repository = new Category_BudgetRepository(_dataConnectionString, 1); var data = repository.Get(4, 9); Assert.IsTrue(data == null); }
public void Data_Delete_Category_Budget() { var repository = new Category_BudgetRepository(_dataConnectionString, 1); var result = repository.Delete(1, 3); var category = repository.Get(1, 3); Assert.IsTrue(category == null); Assert.IsTrue(result.Deleted == true); Assert.IsTrue(result.DeletedBy == 1); Assert.IsTrue(result.DeletedDate.Value.Date == DateTime.Now.Date); }
public void Data_Read_Category_Budget() { var repository = new Category_BudgetRepository(_dataConnectionString, 1); var data = repository.Get(1, 2); Assert.IsTrue(data.Budget_BudgetID == 1); Assert.IsTrue(data.Category_CategoryID == 2); Assert.IsTrue(data.CategoryName == "Rent"); Assert.IsTrue(data.CategoryType == CategoryType.Expense); Assert.IsTrue(data.Amount == 500.00M); }
public void Data_Update_Category_Budget() { var repository = new Category_BudgetRepository(_dataConnectionString, 1); var category = repository.Get(1, 2); category.Amount = 123.45M; var result = repository.Update(category); Assert.IsTrue(result.Budget_BudgetID == 1); Assert.IsTrue(result.Category_CategoryID == 2); Assert.IsTrue(result.CategoryName == "Rent"); Assert.IsTrue(result.CategoryType == CategoryType.Expense); Assert.IsTrue(result.Amount == 123.45M); Assert.IsTrue(result.LastModifiedBy == 1); Assert.IsTrue(result.LastModifiedDate.Date == DateTime.Now.Date); }