private static async Task RunSprocDemoAsync(DocumentClient client)
{
var CosmosDBUtils = new CosmosDBUtils(client);
var conferenceDb = await CosmosDBUtils.GetOrCreateDatabaseAsync("Conferences");
var conferenceCollection = await CosmosDBUtils.GetOrCreateDocumentCollectionAsync(conferenceDb, "FallConferences");
var mySproc = new StoredProcedure
{
Id = "createDocs",
Body = "function(documentToCreate) {" +
"var context = getContext();" +
"var collection = context.getCollection();" +
"var accepted = collection.createDocument(collection.getSelfLink()," +
"documentToCreate," +
"function (err, documentCreated) {" +
"if (err) throw new Error('Error oh ' + documentToCreate.Name + '- ' + err.message);" +
"context.getResponse().setBody(documentCreated.id)" +
"});" +
"if (!accepted) return;" +
"}"
};
var response = await client.CreateStoredProcedureAsync(conferenceCollection.SelfLink, mySproc);
try
{
if (response.StatusCode == System.Net.HttpStatusCode.Created)
{
dynamic conf = Conference.CreateConference(4, new DateTime(2014, 12, 1));
await client.ExecuteStoredProcedureAsync <string>(response.Resource.SelfLink, conf);
var linqConferences = from c in client.CreateDocumentQuery <Conference>(conferenceCollection.DocumentsLink)
select c;
foreach (var conference in linqConferences)
{
Console.WriteLine("SPROC - Found Conference " + conference.Name + " on " + conference.StartDate);
}
}
else
{
Console.WriteLine("The sproc didn't get added!");
}
}
catch (Exception ex)
{
}
finally
{
client.DeleteStoredProcedureAsync(response.Resource.SelfLink).Wait();
RunDeleteDemoAsync(client).Wait();
}
Console.ReadKey();
}
private static async Task RunCleanEverythingAsnyc(DocumentClient client)
{
var CosmosDBUtils = new CosmosDBUtils(client);
var conferenceDb = await CosmosDBUtils.GetOrCreateDatabaseAsync("Conferences");
var conferenceCollection = await CosmosDBUtils.GetOrCreateDocumentCollectionAsync(conferenceDb, "FallConferences");
var linqConferences = from c in client.CreateDocumentQuery(conferenceCollection.DocumentsLink)
select c;
foreach (var conference in linqConferences)
{
await client.DeleteDocumentAsync(conference.SelfLink);
Console.WriteLine("Deleted Conference " + conference.Id);
}
var sprocs = client.CreateStoredProcedureQuery(conferenceCollection.StoredProceduresLink).Select(s => s).ToList();
foreach (var sproc in sprocs)
{
await client.DeleteStoredProcedureAsync(sproc.SelfLink);
Console.WriteLine("Deleted sproc " + sproc.Id);
}
Console.ReadKey();
}
private static async Task RunCreateDemoAsync(DocumentClient client)
{
var CosmosDBUtils = new CosmosDBUtils(client);
var conferenceDb = await CosmosDBUtils.GetOrCreateDatabaseAsync("Conferences");
var conferenceCollection = await CosmosDBUtils.GetOrCreateDocumentCollectionAsync(conferenceDb, "FallConferences");
await CosmosDBUtils.CreateDocumentAsync <Conference>(conferenceCollection, Conference.CreateConference(1, new DateTime(2014, 10, 18)));
await CosmosDBUtils.CreateDocumentAsync <Conference>(conferenceCollection, Conference.CreateConference(2, new DateTime(2014, 11, 18)));
await CosmosDBUtils.CreateDocumentAsync <Conference>(conferenceCollection, Conference.CreateConference(3, new DateTime(2014, 11, 22)));
}
private static async Task RunQueryDemoAsync(DocumentClient client)
{
var CosmosDBUtils = new CosmosDBUtils(client);
var conferenceDb = await CosmosDBUtils.GetOrCreateDatabaseAsync("Conferences");
var conferenceCollection = await CosmosDBUtils.GetOrCreateDocumentCollectionAsync(conferenceDb, "FallConferences");
QueryAll(client, conferenceCollection.DocumentsLink);
Console.ReadKey();
QueryForConferenceName(client, conferenceCollection.DocumentsLink, "Conference 1");
Console.ReadKey();
QueryForConferenceSessions(client, conferenceCollection.DocumentsLink, new DateTime(2014, 11, 1));
Console.ReadKey();
}
private static async Task RunDeleteDemoAsync(DocumentClient client)
{
var CosmosDBUtils = new CosmosDBUtils(client);
var conferenceDb = await CosmosDBUtils.GetOrCreateDatabaseAsync("Conferences");
var conferenceCollection = await CosmosDBUtils.GetOrCreateDocumentCollectionAsync(conferenceDb, "FallConferences");
var linqConferences = from c in client.CreateDocumentQuery(conferenceCollection.DocumentsLink)
select c;
foreach (var conference in linqConferences)
{
await client.DeleteDocumentAsync(conference.SelfLink);
Console.WriteLine("Deleted Conference " + conference.Id);
}
Console.ReadKey();
}
private static async Task RunUpdateDemoAsync(DocumentClient client)
{
var CosmosDBUtils = new CosmosDBUtils(client);
var conferenceDb = await CosmosDBUtils.GetOrCreateDatabaseAsync("Conferences");
var conferenceCollection = await CosmosDBUtils.GetOrCreateDocumentCollectionAsync(conferenceDb, "FallConferences");
var conference = client.CreateDocumentQuery <Conference>(conferenceCollection.DocumentsLink).Where(c => c.Name == "Conference 1").AsEnumerable().FirstOrDefault();
conference.Name = "Conference 1 Edited";
var conferenceDoc = client.CreateDocumentQuery(conferenceCollection.DocumentsLink).Where(d => d.Id == conference.id).AsEnumerable().FirstOrDefault();
await client.ReplaceDocumentAsync(conferenceDoc.SelfLink, conference);
var editedConference = client.CreateDocumentQuery <Conference>(conferenceCollection.DocumentsLink).Where(c => c.Name == "Conference 1 Edited").AsEnumerable().FirstOrDefault();
Console.WriteLine("Found conference " + editedConference.Name);
Console.ReadKey();
}