private bool Create_SQL_IaaS_Server_Rehost_Perf

private bool Create_SQL_IaaS_Server_Rehost_Perf_Model()

in src/Assessment/Processor/ProcessDatasets.cs [893:984]
77 lines of code
10 McCabe index (conditional complexity)

        private bool Create_SQL_IaaS_Server_Rehost_Perf_Model(List<SQL_IaaS_Server_Rehost_Perf> SQL_IaaS_Server_Rehost_Perf_List, HashSet<string> AzureSQL_IaaS_Server, HashSet<string> AzureVM_Opportunity_Perf)
        {
            if (AzureSQLMachinesData == null)
            {
                UserInputObj.LoggerObj.LogWarning("Not creating SQL_IaaS_Server_Rehost_Perf excel model as Azure SQL machines dataset is null");
                return false;
            }
            if (AzureSQLMachinesData.Count <= 0)
            {
                UserInputObj.LoggerObj.LogWarning("Not creating SQL_IaaS_Server_Rehost_Perf excel model as Azure SQL machines dataset is empty");
                return false;
            }

            UserInputObj.LoggerObj.LogInformation("Creating excel model for SQL_IaaS_Server_Rehost_Perf");

            if (SQL_IaaS_Server_Rehost_Perf_List == null)
                SQL_IaaS_Server_Rehost_Perf_List = new List<SQL_IaaS_Server_Rehost_Perf>();
            if (AzureVM_Opportunity_Perf == null)
                AzureVM_Opportunity_Perf = new HashSet<string>();

            foreach (var discoveredMachineId in AzureSQL_IaaS_Server)
            {
                if (!AzureSQLMachinesData.ContainsKey(discoveredMachineId))
                {
                    UserInputObj.LoggerObj.LogWarning($"Discovered Machine ID {discoveredMachineId} does not exist in Azure SQL machines dataset, skipping");
                    continue;
                }

                var value = AzureSQLMachinesData[discoveredMachineId];

                if (value.Suitability != Suitabilities.Suitable && value.Suitability != Suitabilities.ConditionallySuitable)
                {
                    if (!AzureVM_Opportunity_Perf.Contains(discoveredMachineId))
                        AzureVM_Opportunity_Perf.Add(discoveredMachineId);
                    continue;
                }
                
                SQL_IaaS_Server_Rehost_Perf obj = new SQL_IaaS_Server_Rehost_Perf();

                obj.MachineName = value.DisplayName;
                obj.Environment = value.Environment;
                obj.AzureVMReadiness = new EnumDescriptionHelper().GetEnumDescription(value.Suitability);
                obj.AzureVMReadiness_Warnings = value.SuitabilityExplanation;
                obj.RecommendedVMSize = value.RecommendedVMSize;
                obj.MonthlyComputeCostEstimate = value.MonthlyComputeCost;
                obj.MonthlyComputeCostEstimate_RI3year = value.MonthlyComputeCostEstimate_RI3year;
                obj.MonthlyComputeCostEstimate_AHUB = value.MonthlyComputeCostEstimate_AHUB;
                obj.MonthlyComputeCostEstimate_AHUB_RI3year = value.MonthlyComputeCostEstimate_AHUB_RI3year;
                obj.MonthlyComputeCostEstimate_ASP3year = value.MonthlyComputeCostEstimate_ASP3year;
                obj.MonthlyStorageCostEstimate = value.MonthlyStorageCost;
                obj.MonthlySecurityCostEstimate = value.MonthlySecurityCost;
                obj.OperatingSystem = value.OperatingSystemName;
                obj.SupportStatus = value.SupportStatus;
                obj.VMHost = UtilityFunctions.GetStringValue(value.DatacenterManagementServerName);
                obj.BootType = value.BootType;
                obj.Cores = value.NumberOfCores;
                obj.MemoryInMB = value.MegabytesOfMemory;
                obj.CpuUtilizationPercentage = value.PercentageCoresUtilization;
                obj.MemoryUtilizationPercentage = value.PercentageMemoryUtilization;
                obj.StorageInGB = UtilityFunctions.GetTotalStorage(value.Disks);
                obj.NetworkAdapters = value.NetworkAdapters;

                var macIpKvp = UtilityFunctions.ParseMacIpAddress(value.NetworkAdapterList);
                obj.MacAddresses = macIpKvp.Key;
                obj.IpAddresses = macIpKvp.Value;

                obj.DiskNames = UtilityFunctions.GetDiskNames(value.Disks);
                obj.AzureDiskReadiness = UtilityFunctions.GetDiskReadiness(value.Disks);
                obj.RecommendedDiskSKUs = UtilityFunctions.GetRecommendedDiskSKUs(value.Disks);

                obj.StandardHddDisks = UtilityFunctions.GetDiskTypeCount(value.Disks, RecommendedDiskTypes.Standard);
                obj.StandardSsdDisks = UtilityFunctions.GetDiskTypeCount(value.Disks, RecommendedDiskTypes.StandardSSD);
                obj.PremiumDisks = UtilityFunctions.GetDiskTypeCount(value.Disks, RecommendedDiskTypes.Premium);
                obj.UltraDisks = UtilityFunctions.GetDiskTypeCount(value.Disks, RecommendedDiskTypes.Ultra);

                obj.MonthlyStorageCostForStandardHddDisks = UtilityFunctions.GetDiskTypeStorageCost(value.Disks, RecommendedDiskTypes.Standard);
                obj.MonthlyStorageCostForStandardSsdDisks = UtilityFunctions.GetDiskTypeStorageCost(value.Disks, RecommendedDiskTypes.StandardSSD);
                obj.MonthlyStorageCostForPremiumDisks = UtilityFunctions.GetDiskTypeStorageCost(value.Disks, RecommendedDiskTypes.Premium);
                obj.MonthlyStorageCostForUltraDisks = UtilityFunctions.GetDiskTypeStorageCost(value.Disks, RecommendedDiskTypes.Ultra);

                obj.MonthlyAzureSiteRecoveryCostEstimate = value.AzureSiteRecoveryMonthlyCostEstimate;
                obj.MonthlyAzureBackupCostEstimate = value.AzureBackupMonthlyCostEstimate;

                obj.GroupName = value.GroupName;
                obj.MachineId = value.DatacenterMachineArmId;

                SQL_IaaS_Server_Rehost_Perf_List.Add(obj);
            }
            
            UserInputObj.LoggerObj.LogInformation($"Updated SQL_IaaS_Server_Rehost_Perf excel model with data of {SQL_IaaS_Server_Rehost_Perf_List.Count} machines");
            return true;
        }