public void SetStatus(int task_id, DbTaskStatus status)
{
Context.Connection.Execute("UPDATE fso_tasks set task_status = @task_status WHERE task_id = @task_id", new {
task_id = task_id,
task_status = status.ToString()
});
}
public void CompleteTask(int task_id, DbTaskStatus status)
{
Context.Connection.Execute("UPDATE fso_tasks set task_status = @task_status, time_completed = current_timestamp WHERE task_id = @task_id", new
{
task_id = task_id,
task_status = status.ToString()
});
}