public void SetTaskAsCompleted(int taskId)
{
using (var context = new SharedTasksDBDataContext(_connectionString))
{
context.ExecuteCommand("UPDATE Tasks SET IsCompleted = 1 WHERE Id = {0}", taskId);
}
}
public void SetUserForTask(int taskId, int userId)
{
using (var context = new SharedTasksDBDataContext(_connectionString))
{
context.ExecuteCommand("UPDATE Tasks SET UserId = {0} WHERE Id = {1}", userId, taskId);
}
}