async public Task Execute(IJobExecutionContext context)
{
DbContextOptionsBuilder <ApplicationDbContext> optionbuilder = new DbContextOptionsBuilder <ApplicationDbContext>();
optionbuilder.UseSqlServer("Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=SmsServiceAppDB;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
ApplicationDbContext db = new ApplicationDbContext(optionbuilder.Options);
var senderManager = new SenderManager(db);
var messageLogger = new XmlLogger("XmlLog.xml");
var smsSender = new ConsoleSmsSender();
var messages = await senderManager.GetMessagesToSend();
foreach (var message in messages)
{
await smsSender.Send(message.Sender, message.Reciever, message.Text, "");
messageLogger.Log(message.Sender, message.Reciever, message.Text, DateTime.UtcNow);
}
var Ids = from i in messages
select i.TimeId;
await senderManager.SetTimesAsSent(Ids);
}