public static async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = "DeleteInReachFeedFromCosmos/{userWebId}/{trackId}")] HttpRequest req,
[CosmosDB(
databaseName: "FreeCosmosDB",
collectionName: "TrackMe",
ConnectionStringSetting = "CosmosDBForFree",
PartitionKey = "{userWebId}",
Id = "{trackId}"
)] KMLInfo kMLInfo,
[CosmosDB(
databaseName: "FreeCosmosDB",
collectionName: "TrackMe",
ConnectionStringSetting = "CosmosDBForFree",
SqlQuery = "SELECT * FROM c WHERE c.groupid = 'user'"
)] IEnumerable <InReachUser> inReachUsers,
[CosmosDB(
databaseName: "FreeCosmosDB",
collectionName: "TrackMe",
ConnectionStringSetting = "CosmosDBForFree"
)] DocumentClient documentClient,
ExecutionContext context)
{
var config = new ConfigurationBuilder()
.SetBasePath(context.FunctionAppDirectory)
.AddJsonFile("local.settings.json", optional: true, reloadOnChange: true)
.AddEnvironmentVariables()
.Build();
var StorageContainerConnectionString = config["StorageContainerConnectionString"];
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(StorageContainerConnectionString);
CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient();
HelperKMLParse helperKMLParse = new HelperKMLParse();
ClaimsPrincipal Identities = req.HttpContext.User;
var checkUser = new HelperCheckUser();
var LoggedInUser = checkUser.LoggedInUser(inReachUsers, Identities);
var IsAuthenticated = false;
if (LoggedInUser.status == Status.ExistingUser)
{
IsAuthenticated = true;
}
if (IsAuthenticated)
{
//selfLink is like this: "dbs/auo6AA==/colls/auo6AOdfluE=/docs/auo6AOdfluEnFwIAAAAAAA==/";
await documentClient.DeleteDocumentAsync(kMLInfo._self, new RequestOptions { PartitionKey = new PartitionKey(LoggedInUser.userWebId) });
//delete blobs
foreach (var blob in helperKMLParse.Blobs)
{
var blobName = $"{kMLInfo.groupid}/{kMLInfo.id}/{blob.BlobName}.kml";
await helperKMLParse.RemoveBlobAsync(blobName, blobClient);
}
}
return(new OkObjectResult(IsAuthenticated));
}
public static async Task Run([TimerTrigger("0 */5 * * * *")] TimerInfo myTimer,
[CosmosDB(
databaseName: "FreeCosmosDB",
collectionName: "TrackMe",
ConnectionStringSetting = "CosmosDBForFree"
)]
IAsyncCollector <KMLInfo> asyncCollectorKMLInfo,
[CosmosDB(
databaseName: "FreeCosmosDB",
collectionName: "TrackMe",
ConnectionStringSetting = "CosmosDBForFree"
)] DocumentClient documentClient,
[CosmosDB(
databaseName: "FreeCosmosDB",
collectionName: "TrackMe",
ConnectionStringSetting = "CosmosDBForFree",
SqlQuery = "SELECT * FROM c WHERE c.groupid = 'user'"
)] IEnumerable <InReachUser> inReachUsers,
ExecutionContext context)
{
var config = new ConfigurationBuilder()
.SetBasePath(context.FunctionAppDirectory)
.AddJsonFile("local.settings.json", optional: true, reloadOnChange: true)
.AddEnvironmentVariables()
.Build();
var SendEmailFunctionKey = config["SendEmailInReachFunctionKey"];
var SendEmailFunctionUrl = config["SendEmailFunctionUrl"];
var WebSiteUrl = config["WebSiteUrl"];
var TodayTrackId = config["TodayTrackId"];
var StorageContainerConnectionString = config["StorageContainerConnectionString"];
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(StorageContainerConnectionString);
CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient();
Uri collectionUri = UriFactory.CreateDocumentCollectionUri("FreeCosmosDB", "TrackMe");
List <Emails> emails = new List <Emails>();
DateTime dateTimeUTC = DateTime.UtcNow.ToUniversalTime();
//getting active tracks from CosmosDB
var query = new SqlQuerySpec("SELECT * FROM c WHERE (c.d1 < @dateTimeUTC and c.d2 > @dateTimeUTC) or c.id = @TodayTrack",
new SqlParameterCollection(new SqlParameter[] { new SqlParameter {
Name = "@dateTimeUTC", Value = dateTimeUTC
}, new SqlParameter {
Name = "@TodayTrack", Value = TodayTrackId
} }));
IEnumerable <KMLInfo> kMLInfos = documentClient.CreateDocumentQuery <KMLInfo>(collectionUri, query, new FeedOptions {
EnableCrossPartitionQuery = true
}).AsEnumerable();
//remove all duplicates by LastPointTimestamp and groupid field to make only one query to Garmin per user (if user has multiple Live tracks in same time)
IEnumerable <KMLInfo> kMLInfoDeDups = kMLInfos.GroupBy(x => new { x.LastPointTimestamp, x.groupid }).Select(x => x.First()).ToList();
//getting feed from garmin, one feed for each user if LastpointTimestamp is same
foreach (var kMLInfoDeDup in kMLInfoDeDups)
{
DateTime lastd1 = DateTime.SpecifyKind(DateTime.Parse(kMLInfoDeDup.d1, CultureInfo.InvariantCulture), DateTimeKind.Utc);
DateTime today = DateTime.UtcNow.ToUniversalTime().AddDays(-1);
//set d1 to LastPointTimestamp + 1 second (if LastTimestamp exist) to download the feed from that point forward from Garmin
if (!string.IsNullOrEmpty(kMLInfoDeDup.LastPointTimestamp))
{
kMLInfoDeDup.d1 = DateTime.Parse(kMLInfoDeDup.LastPointTimestamp, CultureInfo.InvariantCulture).AddSeconds(1).ToString("yyyy-MM-ddTHH:mm:ssZ");
}
else
{
kMLInfoDeDup.d1 = DateTime.Parse(kMLInfoDeDup.d1, CultureInfo.InvariantCulture).ToString("yyyy-MM-ddTHH:mm:ssZ");
}
//resetting Today's track, once at night according to user Timezone
if (lastd1 < today && kMLInfoDeDup.id == TodayTrackId)
{
var dated1 = DateTime.UtcNow.ToUniversalTime().AddHours(kMLInfoDeDup.UserTimezone).ToString("yyyy-MM-dd");
var dateTimed1 = DateTime.Parse(dated1).AddHours(-kMLInfoDeDup.UserTimezone).ToString("yyyy-MM-ddTHH:mm:ssZ");
var dateTimed2 = DateTime.Parse(dated1).AddDays(1).AddHours(-kMLInfoDeDup.UserTimezone).ToString("yyyy-MM-ddTHH:mm:ssZ");
kMLInfoDeDup.d1 = dateTimed1;
kMLInfoDeDup.d2 = dateTimed2;
kMLInfoDeDup.LastPointTimestamp = "";
kMLInfoDeDup.LastLatitude = 0;
kMLInfoDeDup.LastLongitude = 0;
kMLInfoDeDup.LastTotalDistance = 0;
kMLInfoDeDup.LastTotalTime = "";
kMLInfoDeDup.TrackStartTime = "";
await asyncCollectorKMLInfo.AddAsync(kMLInfoDeDup);
//delete Today's blobs
foreach (var blob in helperKMLParse.Blobs)
{
var blobName = $"{kMLInfoDeDup.groupid}/{kMLInfoDeDup.id}/{blob.BlobName}.kml";
await helperKMLParse.RemoveBlobAsync(blobName, blobClient);
}
}
//getting always only last point from garmin (except if new day with active tracking has started)
HelperGetKMLFromGarmin GetKMLFromGarmin = new HelperGetKMLFromGarmin();
var kmlFeedresult = await GetKMLFromGarmin.GetKMLAsync(kMLInfoDeDup);
kMLInfoDeDup.LastPoint = kmlFeedresult;
}
foreach (var kMLInfo in kMLInfos)
{
var kmlFeedresult = kMLInfoDeDups.First(x => x.groupid == kMLInfo.groupid).LastPoint;
//if there are new points, then load whole track from database and add the point
if (helperKMLParse.IsThereNewPoints(kmlFeedresult, kMLInfo))
{
var user = new InReachUser();
foreach (var usr in inReachUsers)
{
if (usr.userWebId == kMLInfo.groupid)
{
user = usr;
break;
}
}
//open KML feeds from Blobstorage
var blobs = helperKMLParse.Blobs;
foreach (var blob in blobs)
{
var blobName = $"{kMLInfo.groupid}/{kMLInfo.id}/{blob.BlobName}.kml";
blob.BlobValue = await helperKMLParse.GetFromBlobAsync(blobName, blobClient);
}
//process the full track
helperKMLParse.ParseKMLFile(kmlFeedresult, kMLInfo, blobs, emails, user, WebSiteUrl);
kMLInfo.d1 = DateTime.Parse(kMLInfo.d1, CultureInfo.InvariantCulture).ToString("yyyy-MM-ddTHH:mm:ssZ");
kMLInfo.d2 = DateTime.Parse(kMLInfo.d2, CultureInfo.InvariantCulture).ToString("yyyy-MM-ddTHH:mm:ssZ");
await asyncCollectorKMLInfo.AddAsync(kMLInfo);
//save blobs
foreach (var blob in blobs)
{
var blobName = $"{kMLInfo.groupid}/{kMLInfo.id}/{blob.BlobName}.kml";
await helperKMLParse.AddToBlobAsync(blobName, blob.BlobValue, blobClient);
}
}
}
//remove all duplicates by DateTime field and sending the list to SendEmailFunction
if (emails.Any())
{
List <Emails> emailList = emails.GroupBy(x => x.DateTime).Select(x => x.First()).ToList();
HttpClient client = new HttpClient();
Uri SendEmailFunctionUri = new Uri($"{SendEmailFunctionUrl}?code={SendEmailFunctionKey}");
var returnMessage = await client.PostAsJsonAsync(SendEmailFunctionUri, emailList);
}
}
static async Task ManageTodayTrack(InReachUser LoggedInUser, IAsyncCollector <KMLInfo> addDocuments, DocumentClient client, Uri collectionUri, string TodayTrackId, string SendEmailFunctionUrl, string SendEmailFunctionKey, string WebSiteUrl, CloudBlobClient blobClient)
{
var dated1 = DateTime.UtcNow.ToUniversalTime().ToString("yyyy-MM-dd");
var dated2 = DateTime.UtcNow.ToUniversalTime().ToString("yyyy-MM-dd");
var dateTimed1 = DateTime.Parse(dated1).AddHours(-LoggedInUser.UserTimezone).ToString("yyyy-MM-ddTHH:mm:ssZ");
var dateTimed2 = DateTime.Parse(dated2).AddDays(1).AddHours(-LoggedInUser.UserTimezone).ToString("yyyy-MM-ddTHH:mm:ssZ");
KMLInfo kMLInfo = new KMLInfo()
{
id = TodayTrackId,
Title = "Today's Live Track",
d1 = dateTimed1,
d2 = dateTimed2,
groupid = LoggedInUser.userWebId,
InReachWebAddress = LoggedInUser.InReachWebAddress,
InReachWebPassword = LoggedInUser.InReachWebPassword,
UserTimezone = LoggedInUser.UserTimezone,
IsLongTrack = false
};
//create Today's track
if (LoggedInUser.Active)
{
HelperGetKMLFromGarmin helperGetKMLFromGarmin = new HelperGetKMLFromGarmin();
var emails = new List <Emails>();
//get feed grom garmin
var kmlFeedresult = await helperGetKMLFromGarmin.GetKMLAsync(kMLInfo);
var blobs = helperKMLParse.Blobs;
//parse and transform the feed and save to database
helperKMLParse.ParseKMLFile(kmlFeedresult, kMLInfo, blobs, emails, LoggedInUser, WebSiteUrl);
await addDocuments.AddAsync(kMLInfo);
//save blobs
foreach (var blob in blobs)
{
var blobName = $"{kMLInfo.groupid}/{kMLInfo.id}/{blob.BlobName}.kml";
await helperKMLParse.AddToBlobAsync(blobName, blob.BlobValue, blobClient);
}
//sending out emails
if (emails.Any())
{
HttpClient httpClient = new HttpClient();
Uri SendEmailFunctionUri = new Uri($"{SendEmailFunctionUrl}?code={SendEmailFunctionKey}");
var returnMessage = await httpClient.PostAsJsonAsync(SendEmailFunctionUri, emails);
}
}
//delete Today's track
if (!LoggedInUser.Active)
{
//select and delete document
var queryOne = new SqlQuerySpec("SELECT c._self, c.groupid, c.id FROM c WHERE c.id = @id",
new SqlParameterCollection(new SqlParameter[] { new SqlParameter {
Name = "@id", Value = kMLInfo.id
} }));
KMLInfo kML = client.CreateDocumentQuery(collectionUri, queryOne, new FeedOptions {
PartitionKey = new PartitionKey(kMLInfo.groupid)
}).AsEnumerable().FirstOrDefault();
if (!(kML is null))
{
//delete metadata
await client.DeleteDocumentAsync(kML._self, new RequestOptions { PartitionKey = new PartitionKey(kML.groupid) });
//delete blobs
foreach (var blob in helperKMLParse.Blobs)
{
var blobName = $"{kML.groupid}/{kML.id}/{blob.BlobName}.kml";
await helperKMLParse.RemoveBlobAsync(blobName, blobClient);
}
}
}
}
