internal void Insert(Task task)
{
string tags;
if (task.Tags.Count == 0)
{
tags = "";
}
else
{
tags = task.Tags[0].ID;
for (var i = 1; i < task.Tags.Count; i++)
{
tags += "," + task.Tags[i].ID;
}
}
string cmd = String.Format(@"INSERT INTO tasks(Title, ID, Repeater, ActivatedTime, ExpiryTime, Time, Tags, WebAddress) VALUES
('{0}', '{1}', '{2}', Date('{3}'), Date('{4}'), '{5}', '{6}', '{7}');",
task.Title, task.ID, RepeaterStorageConverter.ToString(task.Repeater), task.ActivatedTime.ToString("yyyy-MM-dd HH:mm"),
task.ExpiryTime.ToString("yyyy-MM-dd HH:mm"), TimeInfosStorageConverter.ToString(task.Time), tags, task.WebAddress);
ExecuteQuery(cmd).ContinueWith(t => { if (t.IsFaulted)
{
throw t.Exception;
}
});
}
