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_Read_Category_Budgets()
{
var repository = new Category_BudgetRepository(_dataConnectionString, 1);
var data = repository.All(1).OrderBy(x => x.Category_CategoryID).ToList();
Assert.IsTrue(data.Count == 2);
Assert.IsTrue(data[0].Budget_BudgetID == 1);
Assert.IsTrue(data[0].Category_CategoryID == 2);
Assert.IsTrue(data[0].CategoryName == "Rent");
Assert.IsTrue(data[0].CategoryType == CategoryType.Expense);
Assert.IsTrue(data[0].Amount == 500.00M);
Assert.IsTrue(data[1].Budget_BudgetID == 1);
Assert.IsTrue(data[1].Category_CategoryID == 3);
Assert.IsTrue(data[1].Amount == 250.00M);
Assert.IsTrue(data[1].CategoryName == "Food");
Assert.IsTrue(data[1].CategoryType == CategoryType.Expense);
}
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_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_Create_Category_Budget()
{
var repository = new Category_BudgetRepository(_dataConnectionString, 1);
var category_budget = new MABMoney.Domain.Category_Budget {
Budget_BudgetID = 1,
Category_CategoryID = 4,
Amount = 250.00M
};
var result = repository.Add(category_budget);
Assert.IsTrue(result.Budget_BudgetID == 1);
Assert.IsTrue(result.Category_CategoryID == 4);
Assert.IsTrue(result.CategoryName == "Bills");
Assert.IsTrue(result.CategoryType == CategoryType.Expense);
Assert.IsTrue(result.Amount == 250.00M);
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_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);
}
