public void ParseAssessedSQLMachines()

in src/Assessment/Parser/AzureSQLAssessedMachinesParser.cs [19:114]


        public void ParseAssessedSQLMachines(Dictionary<string, AzureSQLMachineDataset> AzureSQLMachinesData, UserInput userInputObj)
        {
            if (userInputObj == null)
                throw new Exception("Received null user input object.");

            if (AzureSQLAssessmentStatusMap == null)
            {
                userInputObj.LoggerObj.LogError("Azure SQL assessment status map is null, terminating parsing");
                return;
            }

            if (AzureSQLAssessmentStatusMap.Count <= 0)
            {
                userInputObj.LoggerObj.LogError("Azure SQL Assessment status map is empty, terminating parsing");
                return;
            }

            foreach (var kvp in AzureSQLAssessmentStatusMap)
            {
                if (!UtilityFunctions.IsAssessmentCompleted(kvp))
                {
                    userInputObj.LoggerObj.LogWarning($"Skipping parsing assessment {kvp.Key.AssessmentName} as it is in {new EnumDescriptionHelper().GetEnumDescription(kvp.Value)} state");
                    continue;
                }

                userInputObj.LoggerObj.LogInformation($"Parsing Azure SQL assessment {kvp.Key.AssessmentName} for SQL Machines data");

                string url = Routes.ProtocolScheme + Routes.AzureManagementApiHostname + Routes.ForwardSlash +
                             Routes.SubscriptionPath + Routes.ForwardSlash + userInputObj.Subscription.Key + Routes.ForwardSlash +
                             Routes.ResourceGroupPath + Routes.ForwardSlash + userInputObj.ResourceGroupName.Value + Routes.ForwardSlash +
                             Routes.ProvidersPath + Routes.ForwardSlash + Routes.MigrateProvidersPath + Routes.ForwardSlash +
                             Routes.AssessmentProjectsPath + Routes.ForwardSlash + userInputObj.AssessmentProjectName + Routes.ForwardSlash +
                             Routes.GroupsPath + Routes.ForwardSlash + kvp.Key.GroupName + Routes.ForwardSlash +
                             new EnumDescriptionHelper().GetEnumDescription(kvp.Key.AssessmentType) + Routes.ForwardSlash + kvp.Key.AssessmentName + Routes.ForwardSlash +
                             Routes.AssessedSQLMachinesPath +
                             Routes.QueryStringQuestionMark +
                             Routes.QueryParameterApiVersion + Routes.QueryStringEquals + Routes.AssessmentMachineListApiVersion;

                while (!string.IsNullOrEmpty(url))
                {
                    string assessedMachinesResponse = "";
                    try
                    {
                        assessedMachinesResponse = new HttpClientHelper().GetHttpRequestJsonStringResponse(url, userInputObj).Result;
                    }
                    catch (OperationCanceledException)
                    {
                        throw;
                    }
                    catch (AggregateException aeAssessedSQLMachines)
                    {
                        string errorMessage = "";
                        foreach (var e in aeAssessedSQLMachines.Flatten().InnerExceptions)
                        {
                            if (e is OperationCanceledException)
                                throw e;
                            else
                            {
                                errorMessage = errorMessage + e.Message + " ";
                            }
                        }
                        userInputObj.LoggerObj.LogError($"Failed to retrieve machine data from assessment: {errorMessage}");
                        url = "";
                        continue;
                    }
                    catch (Exception exAssessedSQLMachines)
                    {
                        userInputObj.LoggerObj.LogError($"Failed to retrieve machine data from assessment: {exAssessedSQLMachines.Message}");
                        url = "";
                        continue;
                    }

                    AzureSQLAssessedMachinesJSON obj = JsonConvert.DeserializeObject<AzureSQLAssessedMachinesJSON>(assessedMachinesResponse);
                    url = obj.NextLink;

                    foreach (var value in obj.Values)
                    {
                        string key = value.Properties.DatacenterMachineArmId?.ToLower();

                        UpdateAssessedSQLMachinesDataset(AzureSQLMachinesData, key, value, kvp.Key, userInputObj.Currency.Key);

                        double monthlyComputeCost = value.Properties.MonthlyComputeCost;
                        if (kvp.Key.AssessmentTag == AssessmentTag.PerformanceBased)
                            AzureSQLMachinesData[key].MonthlyComputeCost = monthlyComputeCost;
                        else if (kvp.Key.AssessmentTag == AssessmentTag.PerformanceBased_RI3year)
                            AzureSQLMachinesData[key].MonthlyComputeCostEstimate_RI3year = monthlyComputeCost;
                        else if (kvp.Key.AssessmentTag == AssessmentTag.PerformanceBased_AHUB)
                            AzureSQLMachinesData[key].MonthlyComputeCostEstimate_AHUB = monthlyComputeCost;
                        else if (kvp.Key.AssessmentTag == AssessmentTag.PerformanceBased_AHUB_RI3year)
                            AzureSQLMachinesData[key].MonthlyComputeCostEstimate_AHUB_RI3year = monthlyComputeCost;
                        else if (kvp.Key.AssessmentTag == AssessmentTag.PerformanceBased_ASP3year)
                            AzureSQLMachinesData[key].MonthlyComputeCostEstimate_ASP3year = monthlyComputeCost;
                    }
                }
            }
        }