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