/// <summary> /// Initializes local variables /// </summary> private void InitializeMembers() { this.datasets = new DatasetCollection(this, datasetCache); this.datasets.ItemAdded += OnDatasetAdded; this.datasets.ItemLoading += OnDatasetLoading; this.datasets.AllObjectsLoading += OnAllDatasetsLoading; }
public static void DisplayWorkspaceContents() { string jsonWorkspaces = ExecuteGetRequest(ProgramConstants.restUrlWorkspaces); WorkspaceCollection workspaces = JsonConvert.DeserializeObject <WorkspaceCollection>(jsonWorkspaces); Console.WriteLine("Group Workspaces:"); Console.WriteLine("-----------------"); foreach (Workspace workspace in workspaces.value) { Console.WriteLine(" - " + workspace.name + "(" + workspace.id + ")"); } Console.WriteLine(); Console.WriteLine("Now examining content in your personal workspace..."); Console.WriteLine(); string jsonDatasets = ExecuteGetRequest(ProgramConstants.restUrlDatasets); DatasetCollection datasets = JsonConvert.DeserializeObject <DatasetCollection>(jsonDatasets); Console.WriteLine("Datasets:"); Console.WriteLine("---------"); foreach (var ds in datasets.value) { Console.WriteLine(" - " + ds.name + "(" + ds.id + ")"); } Console.WriteLine(); string jsonReports = ExecuteGetRequest(ProgramConstants.restUrlReports); ReportCollection reports = JsonConvert.DeserializeObject <ReportCollection>(jsonReports); Console.WriteLine("Reports:"); Console.WriteLine("---------"); foreach (var report in reports.value) { Console.WriteLine(" - " + report.name + ": " + report.embedUrl); } Console.WriteLine(); string jsonImports = ExecuteGetRequest(ProgramConstants.restUrlImports); ImportCollection imports = JsonConvert.DeserializeObject <ImportCollection>(jsonImports); Console.WriteLine("Imports:"); Console.WriteLine("---------"); foreach (var import in imports.value) { Console.WriteLine(" - " + import.name + ": " + import.source); } Console.WriteLine(); }
public static void DeleteImport(string importName) { // check to see if import already exists by inspecting dataset names string restUrlDatasets = ProgramConstants.PowerBiServiceRootUrl + "datasets/"; string jsonDatasets = ExecuteGetRequest(restUrlDatasets); DatasetCollection datasets = JsonConvert.DeserializeObject <DatasetCollection>(jsonDatasets); foreach (var dataset in datasets.value) { if (importName.Equals(dataset.name)) { // if dataset name matches, delete dataset which will effective delete the entire import Console.WriteLine("Deleting existing import named " + dataset.name); string restUrlDatasetToDelete = ProgramConstants.PowerBiServiceRootUrl + "datasets/" + dataset.id; ExecuteDeleteRequest(restUrlDatasetToDelete); } } }
public Well() { _refProject = string.Empty; _location = string.Empty; _operator = string.Empty; _country = string.Empty; _angularLatitudeDegrees = string.Empty; _angularLongitudeDegrees = string.Empty; _angularLatitudeMinutes = string.Empty; _angularLongitudeMinutes = string.Empty; _angularLatitudeSeconds = string.Empty; _angularLongitudeSeconds = string.Empty; _polarLatitude = string.Empty; _datum = string.Empty; _airgap = string.Empty; _waterDensity = string.Empty; _polarLongitude = string.Empty; _waterDepth = string.Empty; _normalPore = string.Empty; _regionalFract = string.Empty; _regionalOver = string.Empty; //reason for setting value to -1, default value of int is 0. //So default object comparison in Equals method always says 0 is not equal to -1 _mftAirGap = -1; _mftWaterDepth = -1; _mftPolarLongitude = -1; _mftPolarLatitude = -1; _esteOeste = -1; _norteSur = -1; EngineerNames = new ObservableCollection<string>(); EngineerNames.CollectionChanged += EngineerNames_CollectionChanged; DatasetCollection collection = new DatasetCollection(); Datasets = collection.CurrentList; DatasetCollection = collection; // OnEntitySelectionChanged += Well_OnEntitySelectionChanged; }
public static void PatchDatasourceCredentials(string importName, string sqlAzureUser, string sqlAzurePassword) { string restUrlDatasets = ProgramConstants.PowerBiServiceRootUrl + "datasets/"; string jsonDatasets = ExecuteGetRequest(restUrlDatasets); DatasetCollection datasets = JsonConvert.DeserializeObject <DatasetCollection>(jsonDatasets); foreach (var dataset in datasets.value) { // find dataset whose name matches import name if (importName.Equals(dataset.name)) { Console.WriteLine("Updating data source for dataset named " + dataset.name); // determine gateway id and datasoure id string restUrlDatasetToUpdate = ProgramConstants.restUrlDatasets + dataset.id + "/"; string restUrlDatasetDefaultGateway = restUrlDatasetToUpdate + "Default.GetBoundGatewayDataSources"; string jsonDefaultGateway = ExecuteGetRequest(restUrlDatasetDefaultGateway); Gateway defaultGateway = (JsonConvert.DeserializeObject <GatewayCollection>(jsonDefaultGateway)).value[0]; Console.WriteLine(" - Gateway ID: " + defaultGateway.gatewayId); Console.WriteLine(" - Datasource ID: " + defaultGateway.id); // create URL with pattern myorg/gateways/{gateway_id}/datasources/{datasource_id} string restUrlPatchCredentials = ProgramConstants.PowerBiServiceRootUrl + "gateways/" + defaultGateway.gatewayId + "/" + "datasources/" + defaultGateway.id + "/"; // create C# object with credential data DataSourceCredentials dataSourceCredentials = new DataSourceCredentials { credentialType = "Basic", basicCredentials = new BasicCredentials { username = sqlAzureUser, password = sqlAzurePassword } }; // serialize C# object into JSON string jsonDelta = JsonConvert.SerializeObject(dataSourceCredentials); // add JSON to HttpContent object and configure content type HttpContent patchRequestBody = new StringContent(jsonDelta); patchRequestBody.Headers.ContentType = new MediaTypeWithQualityHeaderValue("application/json"); // prepare PATCH request var method = new HttpMethod("PATCH"); var request = new HttpRequestMessage(method, restUrlPatchCredentials); request.Content = patchRequestBody; HttpClient client = new HttpClient(); client.DefaultRequestHeaders.Add("Accept", "application/json"); client.DefaultRequestHeaders.Add("Authorization", "Bearer " + AccessToken); client.SendAsync(request); Console.WriteLine("Credentials have been updated.."); Console.WriteLine(); } } }