public void Delete(ToDoAssignment toDo)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("DELETE FROM Task WHERE task_id = @task_id", conn))
{
cmd.Parameters.AddWithValue("@task_id", toDo.Id);
cmd.ExecuteNonQuery();
}
}
}
public void MoveToDone(ToDoAssignment toDo)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("UPDATE Task SET task_done = @task_done WHERE task_id = @task_id", conn))
{
cmd.Parameters.AddWithValue("@task_id", toDo.Id);
cmd.Parameters.AddWithValue("@task_done", !toDo.IsDone);
cmd.ExecuteNonQuery();
}
}
}
public void Create(ToDoAssignment newToDo)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("INSERT INTO Task (task_title, task_deadline) VALUES (@task_title, @task_deadline) ", conn))
{
cmd.Parameters.AddWithValue("@task_title", newToDo.Task);
cmd.Parameters.AddWithValue("@task_deadline", newToDo.Dato);
cmd.ExecuteNonQuery();
}
}
}
public void Update(ToDoAssignment toDo)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("UPDATE Task SET task_title = @task_title, " +
"task_deadline = @task_deadline WHERE task_id = @task_id", conn))
{
cmd.Parameters.AddWithValue("@task_id", toDo.Id);
cmd.Parameters.AddWithValue("@task_title", toDo.Task);
cmd.Parameters.AddWithValue("@task_deadline", toDo.Dato);
cmd.ExecuteNonQuery();
}
}
}
