public void Data_Create_Budget()
{
var repository = new BudgetRepository(_dataConnectionString, 1);
var budget = new MABMoney.Domain.Budget {
Account_AccountID = 2,
Start = new DateTime(2015, 3, 1),
End = new DateTime(2015, 3, 31)
};
var result = repository.Add(budget);
Assert.IsTrue(result.BudgetID == 5);
Assert.IsTrue(result.Account_AccountID == 2);
Assert.IsTrue(result.Start == new DateTime(2015, 3, 1));
Assert.IsTrue(result.End == new DateTime(2015, 3, 31));
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_Read_Other_User_Budget()
{
var repository = new BudgetRepository(_dataConnectionString, 1);
var data = repository.Get(4);
Assert.IsTrue(data == null);
}
public void Data_Read_Budget_Latest()
{
var repository = new BudgetRepository(_dataConnectionString, 1);
var data = repository.GetLatest(1, new DateTime(2015, 2, 24, 23, 59, 59));
Assert.IsTrue(data.BudgetID == 2);
Assert.IsTrue(data.Account_AccountID == 1);
Assert.IsTrue(data.Start == new DateTime(2015, 2, 1));
Assert.IsTrue(data.End == new DateTime(2015, 2, 28));
}
public void Data_Read_Budget_Count()
{
var repository = new BudgetRepository(_dataConnectionString, 1);
var data = repository.GetBudgetCount(1);
Assert.IsTrue(data == 2);
}
public void Data_Read_Budgets()
{
var repository = new BudgetRepository(_dataConnectionString, 1);
var data = repository.All().ToList();
// There are 4 test budgets, but one is deleted and one is for another user
Assert.IsTrue(data.Count == 2);
Assert.IsTrue(data[0].BudgetID == 2);
Assert.IsTrue(data[0].Account_AccountID == 1);
Assert.IsTrue(data[0].Start == new DateTime(2015, 2, 1));
Assert.IsTrue(data[0].End == new DateTime(2015, 2, 28));
Assert.IsTrue(data[1].BudgetID == 1);
Assert.IsTrue(data[1].Account_AccountID == 1);
Assert.IsTrue(data[1].Start == new DateTime(2015, 1, 1));
Assert.IsTrue(data[1].End == new DateTime(2015, 1, 31));
}
public void Data_Delete_Budget()
{
var repository = new BudgetRepository(_dataConnectionString, 1);
var result = repository.Delete(1);
var budget = repository.Get(1);
Assert.IsTrue(budget == null);
Assert.IsTrue(result.Deleted == true);
Assert.IsTrue(result.DeletedBy == 1);
Assert.IsTrue(result.DeletedDate.Value.Date == DateTime.Now.Date);
}
public void Data_Update_Budget()
{
var repository = new BudgetRepository(_dataConnectionString, 1);
var budget = repository.Get(1);
budget.Account_AccountID = 2;
budget.Start = new DateTime(2015, 4, 1);
budget.End = new DateTime(2015, 4, 30);
var result = repository.Update(budget);
Assert.IsTrue(result.BudgetID == 1);
Assert.IsTrue(result.Account_AccountID == 2);
Assert.IsTrue(result.Start == new DateTime(2015, 4, 1));
Assert.IsTrue(result.End == new DateTime(2015, 4, 30));
Assert.IsTrue(result.LastModifiedBy == 1);
Assert.IsTrue(result.LastModifiedDate.Date == DateTime.Now.Date);
}