private TodoRepository CreateTodoItemRepository(ISpeedySqlLocalDbWrapper wrapper)
{
var repositoryDbContext = CreateDbContext(wrapper);
var todoItemRepository = CreateTodoItemRepository(repositoryDbContext);
return(todoItemRepository);
}
private List <TodoTo> CreateExpectedForFilter(ISpeedySqlLocalDbWrapper wrapper)
{
var expected = CreateExpectedFromEntities(wrapper);
expected = expected.Where(x => x.IsCompleted == false).ToList();
return(expected);
}
private void InsertTodoItems(List <TodoItemEntityFrameworkModel> items, ISpeedySqlLocalDbWrapper wrapper)
{
var insertContext = CreateDbContext(wrapper);
items.ForEach(item =>
{
insertContext.TodoItem.Add(item);
});
insertContext.SaveChanges();
}
private List <TodoTo> CreateExpectedFromEntities(ISpeedySqlLocalDbWrapper wrapper)
{
var result = new List <TodoTo>();
var fetchContext = CreateDbContext(wrapper);
var todoItems = fetchContext.TodoItem.Include(x => x.Comments).ToList();
todoItems.ForEach(item =>
{
var comments = ConvertToCommentToCollection(item);
result.Add(CreateTodoItemTo(item, comments));
});
return(result);
}
private TodoContext CreateDbContext(ISpeedySqlLocalDbWrapper wrapper)
{
return(new TodoContext(wrapper.Connection));
}
private void InsertComments(List <TodoItemEntityFrameworkModel> itemEntities, ISpeedySqlLocalDbWrapper wrapper)
{
var commentCount = new Random().Next(1, 5);
var insertContext = CreateDbContext(wrapper);
itemEntities.ForEach(item =>
{
var itemId = item.Id;
AddCommentsForTodoItem(commentCount, insertContext, itemId);
});
insertContext.SaveChanges();
}