protected override async Task ExecuteAsync(CancellationToken stoppingToken)
{
using (var db = new ComeAndTicketContext("come_and_ticket_user", "comeandticket"))
{
while (!stoppingToken.IsCancellationRequested)
{
try
{
_logger.Info("Worker running at: {time}", DateTimeOffset.Now);
_logger.Info("Updating Drafthouse data from web");
await ComeAndTicketContext.UpdateDatabaseFromWebAsync(db);
_logger.Info("Writing to database");
await db.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.Error(ex, "Exception while updating drafthouse data from web");
}
await Task.Delay(TimeSpan.FromMinutes(20));
}
}
}
private async Task <User> InnerGetUserAsync(string userName)
{
User user = new User(userName);
var dbUser = await _dbContext.Users
.Include(u => u.DeviceNicknames)
.Include(u => u.MovieTitlesToWatch)
.Where(u => u.EMail == user.EMail)
.FirstOrDefaultAsync();
if (dbUser == null)
{
dbUser = user;
_dbContext.Users.Add(user);
await _dbContext.SaveChangesAsync();
}
return(dbUser);
}
private static async Task PushMoviesAsync(ComeAndTicketContext db)
{
var users = await db.Users
.Include(u => u.HomeMarket)
.Include(u => u.Notifications)
.Include(u => u.MovieTitlesToWatch)
.Include(u => u.DeviceNicknames)
.ToListAsync();
foreach (var user in users)
{
if (string.IsNullOrEmpty(user.PushbulletApiKey))
{
_logger.Warn($"User is not configured with a pushbullet API key: {user.EMail}");
continue;
}
_logger.Info($"Getting devices from Pushbullet for user {user.EMail}");
var pushbulletApi = new Pushbullet(user.PushbulletApiKey);
var retrieveDevicesByNickname = user.DeviceNicknames.Select(async nickname => await pushbulletApi.GetDeviceByNickname(nickname.Value));
var devices = await Task.WhenAll(retrieveDevicesByNickname);
if (!devices.Any())
{
continue;
}
_logger.Info($"Finding movies for user {user.EMail}");
var showTimes = await FindMoviesAsync(user, db);
IEnumerable <IGrouping <Movie, ShowTime> > moviesOnSale = (
from s in showTimes
where MovieTitleContains(s.Movie, user.MovieTitlesToWatch)
where !MovieAlreadySent(s, user)
where s.TicketsStatus != TicketsStatus.Past
select s
).GroupBy(
s => s.Movie,
MovieComparer.TitleCurrentCultureIgnoreCase);
if (!moviesOnSale.Any())
{
continue;
}
var showTimesSent = new List <ShowTime>();
var messageBuilder = new StringBuilder();
messageBuilder.AppendLine(Environment.MachineName);
foreach (var movieOnSale in moviesOnSale)
{
Movie m = movieOnSale.Key;
messageBuilder.AppendLine(m.Title);
foreach (ShowTime s in movieOnSale)
{
if (s.TicketsStatus == TicketsStatus.OnSale)
{
messageBuilder.AppendLine($" - {s.Date} (Left: {s.SeatsLeft} seats, Buy: {s.TicketsUrl} )");
}
else if (s.TicketsStatus == TicketsStatus.SoldOut)
{
messageBuilder.AppendLine($" - {s.Date} (Sold out)");
}
else
{
messageBuilder.AppendLine($" - {s.Date} (Unknown ticket status)");
}
showTimesSent.Add(s);
}
messageBuilder.AppendLine();
}
foreach (var device in devices)
{
await pushbulletApi.PushNoteAsync(
"New tickets available",
messageBuilder.ToString(),
device.Id);
}
MarkMovieSent(showTimesSent, user);
}
await db.SaveChangesAsync();
}