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); }