🚧Setup project for issue syncing

[CalvinWilkinson]

Complete The Item Below

• I have updated the title without removing the 🚧 emoji.

Description

Set up the project for issue syncing by creating workflows to utilize the org-level CICD scripts for syncing pull requests with the issues.

Create the following:

1. Create a workflow named sync-bot-status-check.yml which will be used as a sync bot when issues change and also as a status check for pull requests if the pull request is not in sync with the issue.
2. Create a workflow named sync-issue-to-pr.yml which will be used to manually sync pull requests with an issue upon creation as well as manually via a custom command via pull request comments.

The version to point to will be the latest which as of the creation of this issue is v6.0.0. Pointing to the new version will be done via a repository variable named CICD_SCRIPTS_VERSION.

Also, remove the add-issue-to-project.yml and add-pr-to-project.yml workflows from the project. These will be useless now that the syncing process takes care of this.

Acceptance Criteria

• add-issue-to-project.yml workflow removed
• add-pr-to-project.yml workflow removed
• sync-bot-status-check.yml workflow created
• sync-issue-to-pr.yml workflow created

ToDo Items

• Change type labels added to this issue. Refer to the Change Type Labels section below.
• Priority label added to this issue. Refer to the Priority Type Labels section below.
• Issue linked to the correct project (if applicable).
• Issue linked to the correct milestone (if applicable).
• Draft pull request created and linked to this issue (only required with code changes).

Issue Dependencies

No response

Related Work

No response

Additional Information:

Change Type Labels

Change Type	Label
Bug Fixes	🐛bug
Breaking Changes	🧨breaking changes
New Feature	✨new feature
CICD Changes	♻️cicd
Code Doc Changes	🗒️documentation/code
Product Doc Changes	📝documentation/product

Priority Type Labels

Priority Type	Label
Low Priority	low priority
Medium Priority	medium priority
High Priority	high priority

Code of Conduct

• I agree to follow this project's Code of Conduct.