public Task Get(int id)
{
using (var command = _connection.CreateCommand())
{
command.CommandText = @"SELECT * FROM Task WHERE Id = @taskId";
command.AddParameter("taskId", id);
command.ExecuteNonQuery();
return(ToList(command).First());
}
}
public void Create(CheckListItem item)
{
using (var command = _connection.CreateCommand())
{
command.CommandText = @"INSERT INTO CheckListItem (Name, Description, [Order], TaskId, Done) VALUES(@name, @description, @order, @taskId, @done)";
command.AddParameter("name", item.Name);
command.AddParameter("description", item.Description);
command.AddParameter("order", item.Order);
command.AddParameter("taskId", item.TaskId);
command.AddParameter("done", Convert.ToString(item.Done));
command.ExecuteNonQuery();
}
}
