private static async Task queryFromFirstAssess(InitialAssessmentData userData)
{
// Create a new instance of the Cosmos Client
await CreateDatabaseAsync();
await CreateContainerAsync();
await AddItemsToContainerAsync(userData);
//await QueryItemsAsync(userData);
}
private static async Task AddItemsToContainerAsync(InitialAssessmentData data)
{
ItemResponse <InitialAssessmentData> assessResponse = null;
// Create a family object for the Andersen family
InitialAssessmentData assess = new InitialAssessmentData
{
Id = Guid.NewGuid().ToString(),
PatientId = data.PatientId,
Pregnant = data.Pregnant,
EntryDate = data.EntryDate,
zipcode = data.zipcode,
Country = data.Country,
Age = data.Age,
Gender = data.Gender,
external_travel = data.external_travel,
covid_contact_ques = data.covid_contact_ques,
Flu_Vaccine = data.Flu_Vaccine,
Diabetic = data.Diabetic,
Cancer_history = data.Cancer_history,
Fever = data.Fever,
Cough = data.Cough,
Muscle_body_ache = data.Muscle_body_ache,
Sore_throat = data.Sore_throat,
Fatigue = data.Fatigue,
Chills = data.Chills,
Runny_nose = data.Runny_nose,
Nausea = data.Nausea,
Headache = data.Headache,
Abdominal_pain = data.Abdominal_pain,
Diarrhea = data.Diarrhea,
Anosmia = data.Anosmia,
Date_symptom_onset = data.Date_symptom_onset,
Tested_previously = data.Tested_previously,
Date_of_last_test = data.Date_of_last_test,
Results_of_test = data.Results_of_test
};
try
{
// Create an item in the container representing the Andersen family. Note we provide the value of the partition key for this item, which is "Andersen".
assessResponse = await container.CreateItemAsync <InitialAssessmentData>(assess, new PartitionKey(assess.zipcode));
// Note that after creating the item, we can access the body of the item with the Resource property of the ItemResponse. We can also access the RequestCharge property to see the amount of RUs consumed on this request.
Console.WriteLine("Created item in database with id: {0} Operation consumed {1} RUs.\n", assessResponse.Resource.Id, assessResponse.RequestCharge);
}
catch (CosmosException ex) when(ex.StatusCode == System.Net.HttpStatusCode.Conflict)
{
Console.WriteLine("Item in database with id: {0} already exists\n", assess.Id);
}
}
public static async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)] HttpRequest req,
ILogger log)
{
cosmosClient = new CosmosClient(EndpointUrl, PrimaryKey);
log.LogInformation("C# HTTP trigger function processed a request.");
string requestBody = await new StreamReader(req.Body).ReadToEndAsync();
InitialAssessmentData data = JsonConvert.DeserializeObject <InitialAssessmentData>(requestBody);
// Input user data to SQL DB
await upsert_initial_assessment.queryFromFirstAssess(data);
responseMessage = "Insert into First Assessment table successful";
return(new OkObjectResult(responseMessage));
}
