Esempio n. 1
0
        /// <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);
                }
            }
        }
Esempio n. 4
0
        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();
                }
            }
        }
Esempio n. 6
0
        /// <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;
        }