public async Task <HttpStatusCode> CreateUser(ClaimsPrincipal user, string deskId)
{
UserInfo userInfoObj = new UserInfo()
{
email = user.FindFirst("emails").Value,
firstName = user.FindFirst(ClaimTypes.GivenName).Value,
lastName = user.FindFirst(ClaimTypes.Surname).Value,
id = user.FindFirst(ClaimTypes.NameIdentifier).Value,
deskId = deskId
};
//returnMessage = JsonConvert.SerializeObject(userInfoObj);
Microsoft.Azure.Cosmos.CosmosClient client = new Microsoft.Azure.Cosmos.CosmosClient(_cosmosDBOptions.DatabaseEndpoint, _cosmosDBOptions.SecretKey);
Microsoft.Azure.Cosmos.Database database = await client.CreateDatabaseIfNotExistsAsync(_cosmosDBOptions.DatabaseName);
Microsoft.Azure.Cosmos.Container container = await database.CreateContainerIfNotExistsAsync(
"users",
"/email",
400);
// Upsert an item
Microsoft.Azure.Cosmos.ItemResponse <UserInfo> createResponse = await container.UpsertItemAsync(userInfoObj);
return(createResponse.StatusCode);
}
private static async Task <CosmosDbService <ClientData> > InitializeCosmosClientInstanceClientDataAsync(IConfigurationSection configurationSection)
{
string databaseName = configurationSection.GetSection("DatabaseName").Value;
string containerName = configurationSection.GetSection("ClientsContainerName").Value;
string account = configurationSection.GetSection("Account").Value;
string key = configurationSection.GetSection("Key").Value;
Microsoft.Azure.Cosmos.CosmosClient client = new Microsoft.Azure.Cosmos.CosmosClient(account, key);
CosmosDbService <ClientData> cosmosDbService = new CosmosDbService <ClientData>(client, databaseName, containerName);
Microsoft.Azure.Cosmos.DatabaseResponse database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
await database.Database.CreateContainerIfNotExistsAsync(containerName, "/id");
//Upsert client seeding data
if (await cosmosDbService.GetItemAsync(CreateBcnOfficeClient().Id) == null)
{
await cosmosDbService.AddItemAsync(CreateBcnOfficeClient());
}
else
{
// await cosmosDbService.UpdateItemAsync(CreateBcnOfficeClient().Id, CreateBcnOfficeClient());
}
return(cosmosDbService);
}
/// <summary>
/// Initialises Cosmos DB client connection and container.
/// </summary>
/// <param name="configurationSection"></param>
/// <returns></returns>
private static async Task <CosmosDBService> InitialiseCosmosClientInstanceAsync(IConfigurationSection configurationSection)
{
// Set connection parameters
string databaseName = configurationSection.GetSection("DatabaseName").Value;
string containerName = configurationSection.GetSection("ContainerName").Value;
string account = configurationSection.GetSection("Account").Value;
string key = configurationSection.GetSection("Key").Value;
// Build client and services
Microsoft.Azure.Cosmos.Fluent.CosmosClientBuilder clientBuilder =
new Microsoft.Azure.Cosmos.Fluent.CosmosClientBuilder(account, key);
Microsoft.Azure.Cosmos.CosmosClient client =
clientBuilder.WithConnectionModeDirect().Build();
CosmosDBService dBService = new CosmosDBService(client, databaseName, containerName);
// Initialise database, if required
Microsoft.Azure.Cosmos.DatabaseResponse database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
// Build the database container
await database.Database.CreateContainerIfNotExistsAsync(containerName, "/id");
return(dBService);
}
/// <summary>
/// Creates a Cosmos DB database and a container with the specified partition key.
/// </summary>
/// <returns></returns>
private async Task <CosmosDbService <T> > InitializeCosmosClientInstanceAsync <T>()
{
Microsoft.Azure.Cosmos.CosmosClient client = new Microsoft.Azure.Cosmos.CosmosClient(Configuration.GetValue <string>("ConnectionStrings:Default", null));
var databaseName = "Fagkveld";
var containerName = "ViktigeData";
var cosmosDbService = new CosmosDbService <T>(client, databaseName, containerName);
Microsoft.Azure.Cosmos.DatabaseResponse database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
await database.Database.CreateContainerIfNotExistsAsync(containerName, "/_partitionKey");
return(cosmosDbService);
}
// Creates a Cosmos DB database and a container with the specified partition key.
private static async Task <PatientService> InitializeCosmosClientInstanceAsync(IConfigurationSection configurationSection)
{
var databaseName = configurationSection.GetSection("DatabaseName").Value;
var containerName = configurationSection.GetSection("ContainerName").Value;
var account = configurationSection.GetSection("Account").Value;
var key = configurationSection.GetSection("Key").Value;
var client = new Microsoft.Azure.Cosmos.CosmosClient(account, key);
var patientService = new PatientService(client, databaseName, containerName);
var database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
await database.Database.CreateContainerIfNotExistsAsync(containerName, "/id");
return(patientService);
}
/// <summary>
/// Creates a Cosmos DB database and a container with the specified partition key.
/// </summary>
/// <returns></returns>
private static async Task <CosmosDBService> InitializeCosmosClientInstanceAsync(IConfigurationSection configurationSection)
{
string databaseName = configurationSection.GetSection("DatabaseName").Value;
string containerName = configurationSection.GetSection("ContainerName").Value;
string account = configurationSection.GetSection("Account").Value;
string key = configurationSection.GetSection("Key").Value;
Microsoft.Azure.Cosmos.CosmosClient client = new Microsoft.Azure.Cosmos.CosmosClient(account, key);
CosmosDBService cosmosDbService = new CosmosDBService(client, databaseName, containerName);
Microsoft.Azure.Cosmos.DatabaseResponse database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
await database.Database.CreateContainerIfNotExistsAsync(containerName, "/id");
return(cosmosDbService);
}
public static async Task <UserCosmosDbRepository> InitializeCosmosClientInstanceAsync(IConfigurationSection configurationSection)
{
string databaseName = configurationSection.GetSection("Radiometry").Value;
string containerName = configurationSection.GetSection("Users").Value;
string account = configurationSection.GetSection("Account").Value;
string key = configurationSection.GetSection("Key").Value;
Microsoft.Azure.Cosmos.CosmosClient client = new Microsoft.Azure.Cosmos.CosmosClient(account, key);
UserCosmosDbRepository cosmosDbService = new UserCosmosDbRepository(client, databaseName, containerName);
Microsoft.Azure.Cosmos.DatabaseResponse database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
await database.Database.CreateContainerIfNotExistsAsync(containerName, "/id");
return(cosmosDbService);
}
/// <summary>
/// Creates a Cosmos DB database and a container with the specified partition key.
/// </summary>
/// <returns></returns>
private static async Task <CosmosDbService> InitializeCosmosClientInstanceAsync(IConfigurationSection configurationSection)
{
string databaseName = Environment.GetEnvironmentVariable("DATABASE_NAME"); // configurationSection.GetSection("DatabaseName").Value;
string containerName = Environment.GetEnvironmentVariable("CONTAINER_NAME"); // configurationSection.GetSection("ContainerName").Value;
string account = Environment.GetEnvironmentVariable("ACCOUNT"); // configurationSection.GetSection("Account").Value;
string key = Environment.GetEnvironmentVariable("COSMOS_DB_KEY"); // configurationSection.GetSection("Key").Value;
Microsoft.Azure.Cosmos.CosmosClient client = new Microsoft.Azure.Cosmos.CosmosClient(account, key);
CosmosDbService cosmosDbService = new CosmosDbService(client, databaseName, containerName);
Microsoft.Azure.Cosmos.DatabaseResponse database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
await database.Database.CreateContainerIfNotExistsAsync(containerName, "/id");
return(cosmosDbService);
}
/// <summary>
/// Creates a Cosmos DB database and a container with the specified partition key.
/// </summary>
/// <returns></returns>
private static async Task <CosmosDbService> InitializeCosmosClientInstanceAsync(string url, string key)
{
string databaseName = Environment.GetEnvironmentVariable("CosmosDbName");
string containerName = Environment.GetEnvironmentVariable("CosmosDbContainerName");
Microsoft.Azure.Cosmos.CosmosClient client = new Microsoft.Azure.Cosmos.CosmosClient(url, key);
CosmosDbService cosmosDbService = new CosmosDbService(client, databaseName, containerName);
Microsoft.Azure.Cosmos.DatabaseResponse database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
await database.Database.CreateContainerIfNotExistsAsync(containerName, "/id");
await database.Database.CreateContainerIfNotExistsAsync("Identity", "/id");
return(cosmosDbService);
}
private static async Task <ProductsDBServices> InitializeCosmosProductDBAsync(IConfigurationSection configurationSection)
{
string databaseName = configurationSection.GetSection("DatabaseName").Value;
string containerName = configurationSection.GetSection("ContainerName").Value;
string account = configurationSection.GetSection("Account").Value;
string key = configurationSection.GetSection("Key").Value;
Microsoft.Azure.Cosmos.CosmosClient client = new Microsoft.Azure.Cosmos.CosmosClient(account, key);
ProductsDBServices productsDBServices = new ProductsDBServices(client, databaseName, containerName);
Microsoft.Azure.Cosmos.DatabaseResponse database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
await database.Database.CreateContainerIfNotExistsAsync(containerName, "/type");
return(productsDBServices);
}
// ReSharper disable once UnusedMember.Local
private static async Task <ItemsRepoCosmos> InitializeCosmosClientInstanceAsync(CosmosDbOptions cosmosDbOptions)
{
var client = new Microsoft.Azure.Cosmos.CosmosClient(
cosmosDbOptions.Account, cosmosDbOptions.Key);
var cosmosDbService = new ItemsRepoCosmos(
client, cosmosDbOptions.DatabaseName, cosmosDbOptions.ContainerName);
var database = await client.CreateDatabaseIfNotExistsAsync(
cosmosDbOptions.DatabaseName);
await database.Database.CreateContainerIfNotExistsAsync(
cosmosDbOptions.ContainerName, "/id");
return(cosmosDbService);
}
public static async Task <PersonService> InitializeCosmosClientInstanceAsync(IConfigurationSection configurationSection)
{
string dbName = configurationSection.GetSection("DatabaseName").Value;
string containerName = configurationSection.GetSection("ContainerName").Value;
string accountName = configurationSection.GetSection("Account").Value;
string key = configurationSection.GetSection("Key").Value;
Microsoft.Azure.Cosmos.CosmosClient cosmosClient = new Microsoft.Azure.Cosmos.CosmosClient(accountName, key);
PersonService personService = new PersonService(cosmosClient, dbName, containerName);
Microsoft.Azure.Cosmos.DatabaseResponse databaseResponse = await cosmosClient.CreateDatabaseIfNotExistsAsync(dbName);
await databaseResponse.Database.CreateContainerIfNotExistsAsync(containerName, "/cprnumber");
return(personService);
}
/// Creates a Cosmos DB database and a container with the specified partition key.
private static CosmosDBService InitializeCosmosClientInstanceAsync(IConfigurationSection configurationSection)
{
string databaseName = configurationSection.GetSection("DatabaseName").Value;
string containerName = configurationSection.GetSection("ContainerName").Value;
string account = configurationSection.GetSection("Account").Value;
string key = configurationSection.GetSection("Key").Value;
Microsoft.Azure.Cosmos.Fluent.CosmosClientBuilder clientBuilder = new Microsoft.Azure.Cosmos.Fluent.CosmosClientBuilder(account, key);
Microsoft.Azure.Cosmos.CosmosClient client = clientBuilder
.WithConnectionModeDirect()
.Build();
CosmosDBService cosmosDbService = new CosmosDBService(client, databaseName);
client.CreateDatabaseIfNotExistsAsync(databaseName);
return(cosmosDbService);
}
/// <summary>
/// Creates a Cosmos DB database and a container with the specified partition key.
/// </summary>
/// <returns></returns>
private static async Task <ICosmosDbService> InitializeCosmosClientInstanceAsync()
{
Microsoft.Azure.Cosmos.CosmosClient client = new Microsoft.Azure.Cosmos.CosmosClient(account, key);
CosmosDbService cosmosDbService = new CosmosDbService(client, databaseName, containerName);
AuditStatus a = new AuditStatus {
id = "0C805497-2BA1-4524-9D41-E5D556488F9D", BatchId = "C8F9F1C1-4BD1-447F-9F0E-D8E96DF8A1E7", Status = "start", TimeStamp = DateTime.Now
};
Microsoft.Azure.Cosmos.DatabaseResponse database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
await database.Database.CreateContainerIfNotExistsAsync(containerName, "/id");
await cosmosDbService.AddAuditStatusAsync(a);
return(cosmosDbService);
}
private static async Task <CosmosDbImpl> InitializeCosmosClientInstanceAsync(IConfigurationSection configurationSection)
{
string databaseName = configurationSection.GetSection("DatabaseName").Value;
string containerName = configurationSection.GetSection("ContainerName").Value;
string account = configurationSection.GetSection("Account").Value;
string key = configurationSection.GetSection("Key").Value;
Microsoft.Azure.Cosmos.Fluent.CosmosClientBuilder clientBuilder = new Microsoft.Azure.Cosmos.Fluent.CosmosClientBuilder(account, key);
Microsoft.Azure.Cosmos.CosmosClient client = clientBuilder
.WithConnectionModeDirect()
.Build();
CosmosDbImpl cosmosDbService = new CosmosDbImpl(client, databaseName, containerName);
Microsoft.Azure.Cosmos.DatabaseResponse database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
await database.Database.CreateContainerIfNotExistsAsync(containerName, "/legendname");
return(cosmosDbService);
}
/// <summary>
/// Creates a Cosmos DB database and a container with the specified partition key.
/// </summary>
/// <returns></returns>
private static async Task <CosmosDbService> InitializeCosmosClientInstanceAsync(IConfigurationSection configurationSection)
{
string databaseName = configurationSection.GetSection("DatabaseName").Value;
string containerName = configurationSection.GetSection("ContainerName").Value;
string account = configurationSection.GetSection("Account").Value;
string key = configurationSection.GetSection("Key").Value;
Microsoft.Azure.Cosmos.CosmosClient client = new Microsoft.Azure.Cosmos.CosmosClient(account, key);
CosmosDbService cosmosDbService = new CosmosDbService(client, databaseName, containerName);
Microsoft.Azure.Cosmos.DatabaseResponse database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
await database.Database.DefineContainer(name : containerName, partitionKeyPath : "/id")
.WithUniqueKey()
.Path("/emailAddress")
.Attach()
.CreateIfNotExistsAsync();
return(cosmosDbService);
}
private static async Task <CosmosDBService> InitializeCosmosClientInstanceAsync(IConfiguration Configuration)
{
// CosmosDB connection information
string account = Configuration["CosmosDB:Account"];
string key = Configuration["CosmosDB:Key"];
// CosmosDB database
string databaseName = Configuration["CosmosDB:DatabaseName"];
// CosmosDB containers
var containerNames = Configuration
.AsEnumerable()
.Where(o => o.Key.Contains("CosmosDB:ContainerName:"))
.Select(o => o.Value)
.ToList();
// initialize CosmosDB client
Microsoft.Azure.Cosmos.CosmosClient client = new Microsoft.Azure.Cosmos.CosmosClient(account, key);
// create database if missing
Microsoft.Azure.Cosmos.DatabaseResponse database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
// initialize service
CosmosDBService cosmosDbService = new CosmosDBService(client);
// for each container in list:
containerNames.ForEach(async containerName =>
{
// create container inside database, if missing
await database.Database.CreateContainerIfNotExistsAsync(containerName, "/id");
// add container to the list inside service
await cosmosDbService.AddContainerDefinition(databaseName, containerName);
});
// Do nothing. Satisfy debugger's requirement to have "await" in it
//await Task.Run(() => {});
return(cosmosDbService);
}
private async Task CreateDatabaseIfNotExistsAsync()
{
var throughputProperties = Microsoft.Azure.Cosmos.ThroughputProperties.CreateAutoscaleThroughput(MaxAutoScaleThroughput);
await cosmosClient.CreateDatabaseIfNotExistsAsync(databaseId, throughputProperties);
}