internal static void SaveCoreTableItemSync <T>(T item, string tableName) where T : TableEntity
{
var table = TableUtil.GetCoreTableReference(tableName);
var saveOperation = TableOperation.InsertOrReplace(item);
table.Execute(saveOperation);
}
internal async Task <Organization> GetOrganization(string organizationId)
{
var table = TableUtil.GetCoreTableReference(Tables.Organizations);
var retrieveOperation = TableOperation.Retrieve <Organization>(partitionKey, organizationId);
var tableResult = await table.ExecuteAsync(retrieveOperation);
return((Organization)tableResult.Result);
}
internal Subscription GetSubscription(string subscriptionID)
{
var table = TableUtil.GetCoreTableReference(typeof(Subscription).Name);
var retrieveOperation = TableOperation.Retrieve <Subscription>(partitionKey, subscriptionID);
var tableResult = table.Execute(retrieveOperation);
return((Subscription)tableResult.Result);
}
internal List <Subscription> GetSubscriptionListByOrgId(string orgID)
{
var table = TableUtil.GetCoreTableReference(typeof(Subscription).Name);
var query = new TableQuery <Subscription>().Where(TableQuery.GenerateFilterCondition("OrganizationId", QueryComparisons.Equal, orgID));
var result = table.ExecuteQuery(query);
if (result != null)
{
return(result.ToList());
}
return(null);
}
internal List <PerUserTokenCache> GetPerUserTokenCacheListById(string User)
{
var table = TableUtil.GetCoreTableReference(Tables.PerUserTokenCache);
var query = new TableQuery <PerUserTokenCache>().Where(TableQuery.GenerateFilterCondition("webUserUniqueId", QueryComparisons.Equal, User));
var result = table.ExecuteQuery(query);
if (result != null)
{
return(result.ToList());
}
return(null);
}
internal Organization GetOrganizationByDomain(string domain)
{
var table = TableUtil.GetCoreTableReference(Tables.Organizations);
var filter = TableQuery.GenerateFilterCondition("VerifiedDomain", QueryComparisons.Equal, domain);
var query = new TableQuery <Organization>().Where(filter);
var result = table.ExecuteQuery(query);
if (result != null)
{
return(result.SingleOrDefault());
}
return(null);
}
internal List <Subscription> GetEnrolledSubscriptionListByOrgId(string orgID)
{
var table = TableUtil.GetCoreTableReference(Tables.Subscription);
string orgFilter = TableQuery.GenerateFilterCondition("OrganizationId", QueryComparisons.Equal, orgID);
string isEnrolledFilter = TableQuery.GenerateFilterConditionForBool("IsEnrolled", QueryComparisons.Equal, true);
string combinedFilters = TableQuery.CombineFilters(orgFilter, TableOperators.And, isEnrolledFilter);
var query = new TableQuery <Subscription>().Where(combinedFilters);
var result = table.ExecuteQuery(query);
if (result != null)
{
return(result.ToList());
}
return(null);
}
internal static async Task DeleteCoreTableItem <T>(T item, string tableName) where T : TableEntity
{
var table = TableUtil.GetCoreTableReference(tableName);
var deleteOperation = TableOperation.Delete(item);
await table.ExecuteAsync(deleteOperation);
}
internal static async Task SaveCoreTableItem <T>(T item, string tableName) where T : TableEntity
{
var table = TableUtil.GetCoreTableReference(tableName);
var saveOperation = TableOperation.InsertOrReplace(item);
await table.ExecuteAsync(saveOperation);
}