Implement Scheduled Tasks with Hangfire, GraphQL Subscriptions for Notifications, and CRUD Operations with PostgreSQL

[abdullahkhanjmm]

---

Title: Implement Scheduled Tasks with Hangfire, GraphQL Subscriptions for Notifications, and CRUD Operations with PostgreSQL

Description:

This task involves implementing three main features:

1. Scheduled Tasks with Hangfire
2. GraphQL Subscriptions for Notifications
3. CRUD Operations using PostgreSQL

1. Scheduled Tasks with Hangfire

• Objective: Implement scheduled background tasks using Hangfire.
• Details:
  • Set up Hangfire in the application to run recurring jobs.
  • Implement at least one Cron job that runs daily and performs a simple task (e.g., sending out reminder emails or cleaning up old records).
  • Ensure the job can be monitored via Hangfire Dashboard.

2. GraphQL Subscriptions for Notifications

• Objective: Implement real-time notifications using GraphQL subscriptions.
• Details:
  • Set up a GraphQL subscription that notifies clients of specific events (e.g., when a new record is added or updated).
  • Integrate the subscription with a frontend to demonstrate real-time updates.
  • Use a suitable message broker (like Redis) to handle subscription events if needed.

3. CRUD Operations using PostgreSQL

• Objective: Implement basic CRUD operations with PostgreSQL.
• Details:
  • Set up a PostgreSQL database and create a table for storing records (e.g., Employees, Products).
  • Implement Create, Read, Update, and Delete operations via a REST API or GraphQL mutations.
  • Ensure the operations are working with PostgreSQL, and properly handle database errors.

Requirements:

• Programming Language: Use C# with .NET Core.
• Database: PostgreSQL.
• Testing: Ensure all operations are tested thoroughly.

Additional Notes:

• Make sure to handle exceptions and edge cases.
• Use appropriate logging to track the execution of tasks.

---

[asifaliwork]

https://github.com/asifaliwork/AttendanceSchedule

[JMMAwais]

https://github.com/JMMAwais/GraphqlSubscriptionImplement_HangfireJob