public async Task <ActivityEntity> AddActivityAsync(ActivityEntity activity)
{
string activityFeedRowKey = ActivityKeyFactory.CreateRowKey(activity.Timestamp, activity.UserId);
var entity = new ActivityTableEntity(ActivityKeyFactory.CreatePartitionKey(activity.Timestamp), activityFeedRowKey, activity);
await this.storageAccessService.InsertAsync(Constants.TableNames.Activity, entity);
string activityPerUserRowKey = ActivityKeyFactory.CreatePerUserRowKey(activity.Timestamp);
var perUserEntity = new ActivityTableEntity(activity.UserId, activityPerUserRowKey, activity);
await this.storageAccessService.InsertAsync(Constants.TableNames.ActivityPerUser, perUserEntity);
await AddToPersonalizedFeedAsync(activity.UserId, activity);
return(activity);
}
public async Task <IEnumerable <ActivityEntity> > GetMasterActivitiesAsync(ActivityFilterArgs args)
{
string whereClause = null;
string tableName = Constants.TableNames.Activity;
string currentPartition = ActivityKeyFactory.CreatePartitionKey(DateTime.UtcNow);
string previousPartition = ActivityKeyFactory.CreatePartitionKey(DateTime.UtcNow.AddDays(-(DateTime.UtcNow.Day + 1)));
whereClause =
TableQuery.CombineFilters(
TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, currentPartition),
TableOperators.Or,
TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, previousPartition));
if ((args.FilterOptions & ActivityFilterOptions.WithLocation) == ActivityFilterOptions.WithLocation)
{
whereClause = TableQuery.CombineFilters(whereClause, TableOperators.And,
TableQuery.GenerateFilterConditionForBool(nameof(ActivityTableEntity.HasLocation), QueryComparisons.Equal, true));
}
if ((args.FilterOptions & ActivityFilterOptions.WithVenue) == ActivityFilterOptions.WithVenue)
{
whereClause = TableQuery.CombineFilters(whereClause, TableOperators.And,
TableQuery.GenerateFilterCondition(nameof(ActivityTableEntity.VenueId), QueryComparisons.NotEqual, null));
}
if (args.ActivityType != ActivityType.None)
{
whereClause = TableQuery.CombineFilters(whereClause, TableOperators.And,
TableQuery.GenerateFilterCondition(nameof(ActivityTableEntity.ActivityType), QueryComparisons.Equal, args.ActivityType.ToString()));
}
var result = await storageAccessService.QueryTableAsync <JsonTableEntity <ActivityEntity> >(tableName, whereClause, args.PageSize);
var resultActivities = result.ResultPage.Select(a => a.Entity).ToList();
return(resultActivities);
}
