private static async Task SendLatestUpdate(CloudTable snowReportTable, string smsNumber)
{
var latestUpdateQuery = new TableQuery <SnowmobileReportEntity>()
.Take(1);
var queryResults = await snowReportTable.ExecuteQuerySegmentedAsync(latestUpdateQuery, null);
var latestReport = queryResults.Results.First();
await SmsMessaging.SendReport(smsNumber, latestReport);
}
public static async Task <SnowmobileReportEntity> RunAsync([TimerTrigger("0 */1 * * * *")] TimerInfo myTimer, ILogger log,
[Table("SnowReport")] CloudTable snowReportTable, [Table("SmsNumber")] CloudTable smsNumberTable)
{
log.LogInformation($"C# Timer trigger function executed at: {DateTime.Now}");
// TODO: Refactor into Travel Wisconsin Client
var client = new RestClient("https://www.travelwisconsin.com/snowreport/reportdetails");
var request = new RestRequest(Method.POST)
.AddParameter("id", "1671")
.AddParameter("reportType", "snowmobile");
var response = await client.ExecuteTaskAsync <SnowmobileReportEntity>(request);
// TODO: Refactor into unified long term storage class
var lastReportQuery = new TableQuery <SnowmobileReportEntity>()
.Where(TableQuery.GenerateFilterCondition("ModifiedDate",
QueryComparisons.Equal,
response.Data.ModifiedDate));
var queryResult = await snowReportTable.ExecuteQuerySegmentedAsync(lastReportQuery, null);
if (queryResult.Results.Any())
{
log.LogInformation("No changes.");
return(null);
}
log.LogInformation("Sending update via SMS...");
var smsNumberQuery = new TableQuery <SmsNumberEntity>()
.Where(TableQuery.GenerateFilterCondition("Status", QueryComparisons.Equal, "Active"));
var smsNumberResults = await smsNumberTable.ExecuteQuerySegmentedAsync(smsNumberQuery, null);
var smsNumbers = smsNumberResults.Results;
foreach (var smsNumber in smsNumbers)
{
log.LogInformation($"Sending update to {smsNumber.PhoneNumber}");
await SmsMessaging.SendReport(smsNumber.PhoneNumber, response.Data);
}
log.LogInformation("Done.");
response.Data.RowKey = Utilities.GetNewRowKey();
response.Data.PartitionKey = "Version 1";
return(response.Data);
}
