public async Task <int> Add(string title, TodoItemState state, int listId, int userProfileId)
{
using (var con = _databaseConnectionProvider.New())
{
var createdDate = DateTime.UtcNow;
var todoItemId = Convert.ToInt32(await con.ExecuteScalarAsync(@"
INSERT INTO
TodoItems
(Title, State, DateCreated, DateUpdated, ListId, UserProfileId)
VALUES
(@title, @state, @createdDate, @createdDate, @listId, @userProfileId)
SELECT SCOPE_IDENTITY()", new
{
title,
state,
createdDate,
listId,
userProfileId
}));
return(todoItemId);
}
}
public async Task <bool> CreateGraphTodoItem()
{
this._state = TodoItemState.Loading;
Debug.WriteLine("need to create todo");
this._state = TodoItemState.Created;
this._isDirty = false;
return(false);
}
public void Assigning_a_task_should_raise_TaskAssigned_event()
{
var state = new TodoItemState();
var todoItem = new TodoItem(state);
todoItem.AssignTask("Task 1");
todoItem.GetEvents().Should().ContainItemsAssignableTo <TaskAssigned>();
}
public void AssignTask_should_add_task_to_todo_item()
{
var state = new TodoItemState();
var todoItem = new TodoItem(state);
todoItem.AssignTask("Task 1");
state.Tasks.Should().Contain(x => x.Description == "Task 1");
}
public async Task<ObservableCollection<TodoItem>> RetrieveItemsAsync(TodoItemState state)
{
var items = new ObservableCollection<TodoItem>();
var temp = mDbContext.ToDos.Where(a => a.State == state);
foreach (var item in temp)
{
items.Add(item);
}
return items;
}
public void AssignTasked_should_have_id_generated()
{
var state = new TodoItemState();
var todoItem = new TodoItem(state);
todoItem.AssignTask("Task 1");
todoItem.AssignTask("Task 2");
state.Tasks.First().Id.Should().Be(1);
state.Tasks.Last().Id.Should().Be(2);
}
public void CompleteTask_should_mark_task_as_completed()
{
var task = new Task(1, "Task 1");
var state = new TodoItemState
{
Tasks = new List <Task> {
task
}
};
var todoItem = new TodoItem(state);
todoItem.CompleteTask(task.Id);
task.Completed.Should().BeTrue();
}
public void Completing_all_tasks_should_raise_todo_item_completed_event()
{
var state = new TodoItemState
{
Tasks = new List <Task>
{
new Task(1, "Task 1"),
new Task(2, "Task 2")
}
};
var todoItem = new TodoItem(state);
todoItem.CompleteTask(1);
todoItem.CompleteTask(2);
todoItem.GetEvents().Should().ContainItemsAssignableTo <TodoItemCompleted>();
}
public void Completing_all_tasks_should_make_todo_item_completed()
{
var state = new TodoItemState
{
Tasks = new List <Task>
{
new Task(1, "Task 1"),
new Task(2, "Task 2")
}
};
var todoItem = new TodoItem(state);
todoItem.CompleteTask(1);
todoItem.CompleteTask(2);
state.Completed.Should().BeTrue();
}
public async Task ChangeState(int todoItemId, TodoItemState state)
{
using (var con = _databaseConnectionProvider.New())
{
var updateDate = DateTime.UtcNow;
await con.ExecuteAsync(@"
UPDATE
TodoItems
SET
State = @state,
DateUpdated = @updateDate
WHERE
Id = @todoItemId", new
{
state,
updateDate,
todoItemId
});
}
}
public TodoItemCreated(TodoItemState item)
{
Item = item;
}
void Ex02(bool value, string parameter, TodoItemState expected)
{
Expect($"the converted value should be {expected}", () => Equals(Converter.ConvertBack(value, value.GetType(), parameter, null), expected));
}
private async void LoadTodos(TodoItemState state)
{
CurrentItems = await Database.RetrieveItemsAsync(state);
}
public TodoItemCreated(TodoItemState item)
{
Item = item;
}
void Ex01(TodoItemState value, bool expected)
{
Expect($"the converted value should be {expected}", () => Equals(Converter.Convert(value, value.GetType(), null, null), expected));
}
