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_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_Read_Budget()
        {
            var repository = new BudgetRepository(_dataConnectionString, 1);

            var data = repository.Get(2);

            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_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);
        }