private bool Create_SQL_IaaS_Server_Rehost_AsOnPrem_Model()

in src/Assessment/Processor/ProcessDatasets.cs [1000:1080]

• 68 lines of code
• 10 McCabe index (conditional complexity)

        private bool Create_SQL_IaaS_Server_Rehost_AsOnPrem_Model(List<SQL_IaaS_Server_Rehost_AsOnPrem> SQL_IaaS_Server_Rehost_AsOnPrem_List, HashSet<string> AzureSQL_IaaS_Server, HashSet<string> AzureVM_Opportunity_AsOnPrem)
        {
            if (AzureVMAsOnPremMachinesData == null)
            {
                UserInputObj.LoggerObj.LogWarning("Not creating SQL_IaaS_Server_Rehost_AsOnPrem excel model as Azure VM AsOnPrem dataset is null");
                return false;
            }
            if (AzureVMAsOnPremMachinesData == null)
            {
                UserInputObj.LoggerObj.LogWarning("Not creating SQL_IaaS_Server_Rehost_AsonPrem excel model as Azure VM AsOnPrem dataset is null");
                return false;
            }

            UserInputObj.LoggerObj.LogInformation("Creating excel model fro SQL_IaaS_Server_Rehost_AsOnPrem");

            if (SQL_IaaS_Server_Rehost_AsOnPrem_List == null)
                SQL_IaaS_Server_Rehost_AsOnPrem_List = new List<SQL_IaaS_Server_Rehost_AsOnPrem>();
            if (AzureVM_Opportunity_AsOnPrem == null)
                AzureVM_Opportunity_AsOnPrem = new HashSet<string>();
            
            foreach (string discoveredMachineId in AzureSQL_IaaS_Server)
            {
                if (!AzureVMAsOnPremMachinesData.ContainsKey(discoveredMachineId))
                {
                    UserInputObj.LoggerObj.LogWarning($"Discovered Machind ID {discoveredMachineId} does not exist in Azure VM AsOnPrem dataset, skipping");
                    continue;
                }

                var value = AzureVMAsOnPremMachinesData[discoveredMachineId];

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

                obj.MachineName = value.DisplayName;
                obj.Environment = value.Environment;
                obj.AzureVMReadiness = new EnumDescriptionHelper().GetEnumDescription(value.Suitability);
                obj.RecommendedVMSize = value.RecommendedVMSize;
                obj.MonthlyComputeCostEstimate = value.MonthlyComputeCostEstimate;
                obj.MonthlyStorageCostEstimate = value.StorageMonthlyCost;
                obj.MonthlySecurityCostEstimate = value.MonthlySecurityCost;
                obj.OperatingSystem = value.OperatingSystem;
                obj.SupportStatus = value.SupportStatus;
                obj.VMHost = UtilityFunctions.GetStringValue(value.DatacenterManagementServerName);
                obj.BootType = UtilityFunctions.GetStringValue(value.BootType);
                obj.Cores = value.NumberOfCores;
                obj.MemoryInMB = value.MegabytesOfMemory;
                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.GroupName = value.GroupName;
                obj.MachineId = value.DatacenterMachineArmId;

                SQL_IaaS_Server_Rehost_AsOnPrem_List.Add(obj);
            }

            UserInputObj.LoggerObj.LogInformation($"Updated SQL_IaaS_Server_Rehost_AsOnPrem excel model with data of {SQL_IaaS_Server_Rehost_AsOnPrem_List.Count} machines");
            return true;
        }