public void ShouldGetZeroExpensesFromNonExistingUser() { var expected = new AExpense.Model.Expense { Id = Guid.NewGuid(), Date = new DateTime(1900, 01, 01), Title = "Title", Description = "Description", Total = 1.0, ReimbursementMethod = ReimbursementMethod.DirectDeposit, CostCenter = "CostCenter", Approved = true, User = new User { UserName = "******" }, ApproverName = "approver name" }; var repository = new ExpenseRepository(dataContext); repository.SaveExpense(expected); var expenses = repository.GetExpensesByUser("no existing user name"); Assert.AreEqual(0, expenses.Count()); }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { var repository = new ExpenseRepository(); var expenses = repository.GetExpensesByUser(this.User.Identity.Name); this.MyExpensesGridView.DataSource = expenses; this.DataBind(); } }
public void GetExpenseByUserIsGoneAfterCacheExpires() { Guid expenseIdToSave = Guid.NewGuid(); Assert.IsNull(util.DatabaseHelper.GetExpenseById(TestDatabaseConnectionString, expenseIdToSave)); var stubUser = new User { UserName = "******" }; var stubManager = "the manager"; var expenseToSave = new Model.Expense { Id = expenseIdToSave, Date = new DateTime(1900, 01, 01), Title = "Title", Description = "Description", Total = 1.0, ReimbursementMethod = ReimbursementMethod.DirectDeposit, CostCenter = "CostCenter", Approved = true, User = stubUser, ApproverName = stubManager }; var repository = new ExpenseRepository(TestDatabaseConnectionString, new TimeSpan(0, 0, 2)); repository.SaveExpense(expenseToSave); var expense = repository.GetExpensesByUser(stubUser.UserName); DatabaseHelper.BypassRepositoryAndDeleteExpense(TestDatabaseConnectionString, expenseToSave.Id); Thread.Sleep(3000); expense = repository.GetExpensesByUser(stubUser.UserName); Assert.AreEqual(0, expense.Count()); }
public void GetAllExpensesByUser() { var expected = new AExpense.Model.Expense { Id = Guid.NewGuid(), Date = new DateTime(1900, 01, 01), Title = "Title", Description = "Description", Total = 1.0, ReimbursementMethod = ReimbursementMethod.DirectDeposit, CostCenter = "CostCenter", Approved = true, User = new User { UserName = "******" }, ApproverName = "approver name" }; var repository = new ExpenseRepository(dataContext); repository.SaveExpense(expected); var expenses = repository.GetExpensesByUser("user name"); Assert.IsNotNull(expenses); var actual = expenses.ToList().Where(e => e.Id == expected.Id).FirstOrDefault(); Assert.IsNotNull(actual); Assert.AreEqual(expected.Total, actual.Total); Assert.AreEqual(expected.Approved, actual.Approved); Assert.AreEqual(expected.CostCenter, actual.CostCenter); Assert.AreEqual(expected.Date, actual.Date); Assert.AreEqual(expected.Description, actual.Description); Assert.AreEqual(expected.Id, actual.Id); Assert.AreEqual(expected.ReimbursementMethod, actual.ReimbursementMethod); Assert.AreEqual(expected.Title, actual.Title); Assert.AreEqual(expected.User.UserName, actual.User.UserName); }
public void ShouldGetZeroExpensesFromNonExistingUser() { var expected = new AExpense.Model.Expense { Id = Guid.NewGuid(), Date = new DateTime(1900, 01, 01), Title = "Title", Description = "Description", Total = 1.0, ReimbursementMethod = ReimbursementMethod.DirectDeposit, CostCenter = "CostCenter", Approved = true, User = new User { UserName = "******" }, ApproverName = "approver name" }; var repository = new ExpenseRepository(dataContext); repository.SaveExpense(expected); var expenses = repository.GetExpensesByUser("no existing user name"); Assert.AreEqual(0, expenses.Count()); }
public void GetAllExpensesByUser() { var expected = new AExpense.Model.Expense { Id = Guid.NewGuid(), Date = new DateTime(1900, 01, 01), Title = "Title", Description = "Description", Total = 1.0, ReimbursementMethod = ReimbursementMethod.DirectDeposit, CostCenter = "CostCenter", Approved = true, User = new User { UserName = "******" }, ApproverName = "approver name" }; var repository = new ExpenseRepository(dataContext); repository.SaveExpense(expected); var expenses = repository.GetExpensesByUser("user name"); Assert.IsNotNull(expenses); var actual = expenses.ToList().Where(e => e.Id == expected.Id).FirstOrDefault(); Assert.IsNotNull(actual); Assert.AreEqual(expected.Total, actual.Total); Assert.AreEqual(expected.Approved, actual.Approved); Assert.AreEqual(expected.CostCenter, actual.CostCenter); Assert.AreEqual(expected.Date, actual.Date); Assert.AreEqual(expected.Description, actual.Description); Assert.AreEqual(expected.Id, actual.Id); Assert.AreEqual(expected.ReimbursementMethod, actual.ReimbursementMethod); Assert.AreEqual(expected.Title, actual.Title); Assert.AreEqual(expected.User.UserName, actual.User.UserName); }
public void GetExpenseByUserIsGoneAfterCacheExpires() { Guid expenseIdToSave = Guid.NewGuid(); Assert.IsNull(util.DatabaseHelper.GetExpenseById(TestDatabaseConnectionString, expenseIdToSave)); var stubUser = new User { UserName = "******" }; var stubManager = "the manager"; var expenseToSave = new Model.Expense { Id = expenseIdToSave, Date = new DateTime(1900, 01, 01), Title = "Title", Description = "Description", Total = 1.0, ReimbursementMethod = ReimbursementMethod.DirectDeposit, CostCenter = "CostCenter", Approved = true, User = stubUser, ApproverName = stubManager }; var repository = new ExpenseRepository(TestDatabaseConnectionString, new TimeSpan(0, 0, 2)); repository.SaveExpense(expenseToSave); var expense = repository.GetExpensesByUser(stubUser.UserName); DatabaseHelper.BypassRepositoryAndDeleteExpense(TestDatabaseConnectionString, expenseToSave.Id); Thread.Sleep(3000); expense = repository.GetExpensesByUser(stubUser.UserName); Assert.AreEqual(0, expense.Count()); }