public static void PopulateCustomerDB(string databasename, UpdateDatabaseRequest requestParams)
{
using (SqlConnection connection = CreateSQLConnection(requestParams.server, databasename, requestParams.credentials))
{
connection.Open();
// populate table
var insertQuery = string.Format(queryInsertIntoTable, requestParams.workspaceId, requestParams.reportId, databasename);
SqlCommand cmd = new SqlCommand(insertQuery, connection);
cmd.ExecuteNonQueryAsync().Wait();
connection.Close();
}
}
public static async Task <HttpResponseMessage> Run([HttpTrigger(AuthorizationLevel.Function, "post", Route = "database/{databasename}")] HttpRequestMessage req, string databasename, TraceWriter log)
{
log.Info("UpdateDatabase processed a request.");
HttpResponseMessage rtnResponse = null;
try
{
// Get request body
UpdateDatabaseRequest requestparameters = await req.Content.ReadAsAsync <UpdateDatabaseRequest>();
SQLHelper.PopulateCustomerDB(databasename, requestparameters);
rtnResponse = req.CreateResponse(HttpStatusCode.OK);
}
catch (AggregateException ex)
{
rtnResponse = req.CreateResponse(HttpStatusCode.BadRequest, $"An unexpected http error occured. A database of the name you specified may already exist, the connection details are invalid, or perhaps the values contained invalid characters. Details: {ex.Message}");
}
return(rtnResponse);
}
