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)); }