public async Task Insert(Bucket bucket)
{
await Task.Factory.StartNew(() =>
{
using (var db = new SQLiteConnection(configuration.FilePath))
{
db.RunInTransaction(() =>
{
db.CreateTable<Bucket>(); // only creates if table does not exist
db.Insert(bucket);
});
}
});
}
public async Task Initialize()
{
var o = ApplicationData.Current.LocalSettings.Values["Initialized"];
if (o != null && (bool)o)
{
return;
}
var firstBucket = new Bucket { Description = "Backlog", Order = 1 };
await bucketRepository.Insert(firstBucket);
var doingBucket = new Bucket { Description = "Doing", Order = 2 };
await bucketRepository.Insert(doingBucket);
var doneBucket = new Bucket { Description = "Done", Order = 3 };
await bucketRepository.Insert(doneBucket);
await userTaskRepository.Insert(
new UserTask
{
Title = "A simple task",
Description = "Capturing the things you need to do is the best way to not forget about them. The sorts of things you need to capture are up to you...",
BucketId = firstBucket.Id
});
await userTaskRepository.Insert(
new UserTask
{
Title = "Some tasks might not even require a description",
BucketId = firstBucket.Id
});
await userTaskRepository.Insert(
new UserTask
{
Title = "A task with a goal",
Description = "Sometimes you need to get something done soon, otherwise bad things will happen.",
TargetDate = DateTime.Now.AddDays(2),
BucketId = firstBucket.Id
});
await userTaskRepository.Insert(
new UserTask
{
Title = "A big task",
Description = "Sometimes a task requires more time compared to the other tasks in the bucket. This is how you can add emphasis to them.",
BucketId = firstBucket.Id,
Size = "Large"
});
await userTaskRepository.Insert(
new UserTask
{
Title = "A task underway",
Description = "As you work through the tasks on your list, you can move them across from left to right",
BucketId = doingBucket.Id,
});
await userTaskRepository.Insert(
new UserTask
{
Title = "Beware doing too much at once",
Description = "If you find yourself with too many things in this bucket, you may need to move some tasks back to help with focus",
BucketId = doingBucket.Id,
});
await userTaskRepository.Insert(
new UserTask
{
Title = "Doesn't that feel awesome?",
Description = "Don't forget to move the completed tasks over when you've done them",
BucketId = doneBucket.Id,
});
await userTaskRepository.Insert(
new UserTask
{
Title = "Leave the boring bits to us",
Description = "After a while these completed tasks will be hidden automatically, so you don't need to manually cleanup after.",
BucketId = doneBucket.Id
});
await userTaskRepository.Insert(
new UserTask
{
Title = "But wait, there's more!",
Description = "The more you use this, the more data we get on your workflow. See those charts on the right? They're made just for you!",
BucketId = doneBucket.Id
});
ApplicationData.Current.LocalSettings.Values["Initialized"] = true;
}