安排任务可以在数据库上执行更新数据

Question

我正在尝试使用Quartz Nuget软件包执行任务时间表。调度程序按预期工作，但我的班级问题。当我尝试使用HTTP标头发送SMS时，计划工作正常（我正在使用API​​ SMS Sender服务），但是当我尝试使用数据库执行任何操作时，什么都没有预期。波纹管，我正在分享我的代码。

paymentIncrease.cs

using AmitSMS.Models;
using Microsoft.EntityFrameworkCore;
using Quartz;

namespace AmitSMS.Data.Services;

public class PaymentIncrease : IJob
{
    private readonly ApplicationDbContext _context;

    public PaymentIncrease(ApplicationDbContext context)
    {
        _context = context;
    }

    public Task Execute(IJobExecutionContext context)
    {
        var task = Task.Run(() => Increase());
        return task;
    }

    public void Increase()
    {
        var students = _context.Set<Student>().AsNoTracking().Where(x => x.Status == 1 && (x.Batch1 == 1 || x.Batch2 == 1)).ToList();

        foreach (var student in students)
        {
            Due due = new()
            {
                StudentId = student.StudentId,
                Recurring = DateTime.Now.ToString("MMMM, yyyy"),
                Amount = 800 * (student.Physics + student.HigherMath),
                PreviousAmount = student.Due
            };

            student.Payment += due.Amount;
            student.Due += due.Amount;

            _context.Update(student);
            _context.Add(due);
        }

        _context.SaveChanges();
    }
}

schedulertask.cs

using Quartz;
using Quartz.Impl;

namespace AmitSMS.Data.Services;

public class SchedulerTask
{
    private static readonly string ScheduleSMSExpression = "0 * * ? * *";
    public static async Task StartAsync()
    {
        try
        {
            var scheduler = await StdSchedulerFactory.GetDefaultScheduler();
            if (!scheduler.IsStarted)
            {
                await scheduler.Start();
            }

            

            // Increase Payment
            var job1 = JobBuilder.Create<PaymentIncrease>().WithIdentity("ExecuteTaskServiceCallJob1", "group1").Build();

            var trigger1 = TriggerBuilder.Create().WithIdentity("ExecuteTaskServiceCallTrigger1", "group1").WithCronSchedule(ScheduleSMSExpression).Build();

       
            //Schedule Payment Job
            await scheduler.ScheduleJob(job1, trigger1);
        }
        catch (Exception ex) {
            
        }
    }
}

和on program.cs在配置区域上做到了这一点。

SchedulerTask.StartAsync().GetAwaiter().GetResult();

我正在使用dotnet6。请帮忙。抱歉，所有语法错误。 谢谢。