public int DeleteTask(UserTask t)
{
string queryString = "Delete FROM Tasks WHERE Id = @Id";
return(conn.Execute(queryString, t));
}
public int EditTaskById(UserTask t)
{
string queryString = "UPDATE Tasks SET OwnerId = @OwnerId, Description = @Description, DueDate = @DueDate, Completed = @Completed WHERE Id = @Id";
return(conn.Execute(queryString, t));
}
public int MarkAsComplete(UserTask t)
{
string queryString = "UPDATE Tasks SET Completed = 1 WHERE Id = @Id";
return(conn.Execute(queryString, t));
}
public int EditTaskById(UserTask t)
{
string editString = "UPDATE IdentityTasks SET TaskDescription = @TaskDescription, DueDate = @DueDate WHERE Id = @Id";
return(conn.Execute(editString, t));
}