public void CategoryDataAccess_CrudCategory() { var categoryDataAccess = new CategoryDataAccess(new SqliteConnectionCreator(new WindowsSqliteConnectionFactory())); const string firstName = "category"; const string secondName = "new category"; var category = new Category { Name = firstName }; categoryDataAccess.SaveItem(category); categoryDataAccess.LoadList(); var list = categoryDataAccess.LoadList(); Assert.Equal(1, list.Count); Assert.Equal(firstName, list.First().Name); category.Name = secondName; categoryDataAccess.SaveItem(category); list = categoryDataAccess.LoadList(); Assert.Equal(1, list.Count); Assert.Equal(secondName, list.First().Name); categoryDataAccess.DeleteItem(category); list = categoryDataAccess.LoadList(); Assert.False(list.Any()); }
public void DeleteFromDatabase_CategoryToDelete_CorrectlyDelete() { var category = new Category { Name = "categoryToDelete" }; var dataAccess = new CategoryDataAccess(_connectionCreator); dataAccess.SaveItem(category); Assert.IsTrue(dataAccess.LoadList(x => x.Id == category.Id).Any()); dataAccess.DeleteItem(category); Assert.IsFalse(dataAccess.LoadList(x => x.Id == category.Id).Any()); }