Пример #1
0
        public static CmdbApplicationDetail getApplicationDetail(string EPRID)
        {
            try
            {
                uCmdbObject           ucmdbObj     = getApplicationAttributes(EPRID);
                CmdbApplicationDetail AppDetailObj = BuildCmdbApplicationDetail(ucmdbObj);

                return(AppDetailObj);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #2
0
        private void MainProcessing()
        {
            DCC_Migration_Data_CollectionEntities dbRead = new DCC_Migration_Data_CollectionEntities();
            CmdbApplicationDetail appDetail = new CmdbApplicationDetail();

            string EPRID          = "";
            string lastEPRID      = "";
            string currL2         = "";
            string currL3         = "";
            string newL2          = "";
            string newL3          = "";
            int    bizDomainId    = 0;
            int    planId         = 0;
            bool   successfulRead = false;

            //get dccp packages to validate
            var recordSet = dbRead.vwUpdateL2L3.Select(row => row).OrderBy(e => e.epr_id);

            foreach (var record in recordSet)
            {
                EPRID  = record.epr_id.ToString();
                currL2 = record.biz_desc;
                currL3 = record.domain_desc;
                planId = record.plan_id;

                if (EPRID != lastEPRID)
                {
                    successfulRead = false;

                    while (!successfulRead)
                    {
                        try
                        {
                            //get the current L2/L3 based on the EPR ID
                            appDetail      = UcmdbUtil.getApplicationDetail(EPRID);
                            newL2          = appDetail.getLevel2OrgId();
                            newL3          = appDetail.getLevel3OrgId();
                            successfulRead = true;
                            logFile.WriteLine("Successfully retrieved data for EPR ID " + EPRID);
                        }
                        catch (Exception ex)
                        {
                            //sometimes it returns this error - "The remote server returned an error: (400) Bad Request." - so wait and try again
                            logFile.WriteLine("ERROR getting data for EPR ID " + EPRID + " - " + ex.Message + " - Waiting 15 seconds and trying again.");
                            System.Threading.Thread.Sleep(15000);
                        }
                    }
                }

                //check to see if the L2 and L3 are current
                if ((newL2.ToLower() != currL2.ToLower() || newL3.ToLower() != currL3.ToLower()) && newL2.ToLower() != "not found")
                {
                    //get the L2/L3 ID based on the new org info
                    var orgInfo = (from t1 in dbRead.dcc_biz
                                   join t2 in dbRead.dcc_biz_domain on t1.biz_id equals t2.biz_id
                                   where t1.biz_desc == newL2 &&
                                   t2.domain_desc == newL3
                                   select t2.biz_domain_id);

                    //if we don't find an ID, create the new L2/L3 structure
                    if (orgInfo.Count() > 0)
                    {
                        foreach (var org in orgInfo)
                        {
                            bizDomainId = org;
                        }
                    }
                    else
                    {
                        logFile.WriteLine("Creating L2/L3 - " + newL2 + "/" + newL3);
                        bizDomainId = CreateL2L3(newL2, newL3);
                    }

                    //update the L2/L3
                    try
                    {
                        if (bizDomainId != 0)
                        {
                            logFile.WriteLine("Updating plan id: " + planId);
                            dcc_plan planRec = dbUpdate.dcc_plan.FirstOrDefault(d => d.plan_id == planId);
                            planRec.domain_id = bizDomainId;
                            dbUpdate.SaveChanges();
                        }
                    }
                    catch (Exception ex)
                    {
                        logFile.WriteLine("ERROR updating L2/L3: " + ex.Message);
                    }
                }

                lastEPRID = EPRID;
            }

            //update MBS BUs
            try
            {
                logFile.WriteLine("Updating MBS BUs");
                dbUpdate.UpdateMBSBusinessUnit();
            }
            catch (Exception ex)
            {
                logFile.WriteLine("ERROR updating MBS BUs: " + ex.Message);
            }

            //delete any unused L2/L3s
            try
            {
                logFile.WriteLine("Deleting unused L2/L3s");
                dbUpdate.DeleteUnusedL2L3();
            }
            catch (Exception ex)
            {
                logFile.WriteLine("ERROR deleting unused L2/L3s: " + ex.Message);
            }
        }
Пример #3
0
        public static CmdbApplicationDetail BuildCmdbApplicationDetail(uCmdbObject ucmdbObj)
        {
            CmdbApplicationDetail cmdbAppDetailObj = new CmdbApplicationDetail();

            List <string> itAssetOwners = new List <string>();

            //Select the correct CI for the app

            foreach (uCmdbCi appCi in ucmdbObj.configurationItems)
            {
                if (appCi.type == "hpprtflapp")
                {
                    uCmdbAttributes appAttributes = appCi.attributes;
                    cmdbAppDetailObj.setConfigurationItem(appAttributes.hp_leg_ci_lgcl_nm);
                    cmdbAppDetailObj.setEpridStatus(appAttributes.hp_ci_stat_nm);
                }
                else if (appCi.type == "organization")
                {
                    //Select the correct relationship for the Org
                    foreach (uCmdbRelationship appRelationship in ucmdbObj.relationships)
                    {
                        if ((appCi.ucmdbId == appRelationship.endpoint1.ucmdbId & appRelationship.endpoint1.type == "organization") &
                            appRelationship.type == "hpitassetowner")
                        {
                            uCmdbAttributes appAttributes = appCi.attributes;

                            switch ((int)appAttributes.hp_org_lvl_nbr)// for our purpose we only need L2 and L3
                            {
                            case 2:
                                //set lvl 2 org value
                                cmdbAppDetailObj.setLevel2OrgId(appAttributes.name);
                                break;

                            case 3:
                                cmdbAppDetailObj.setLevel3OrgID(appAttributes.name);
                                break;
                            }

                            var childID = appRelationship.endpoint1.ucmdbId;
                            for (int x = (int)appAttributes.hp_org_lvl_nbr; x >= 1; x--)
                            {
                                foreach (uCmdbRelationship appRelationship2 in ucmdbObj.relationships)
                                {
                                    if (childID == appRelationship2.endpoint2.ucmdbId)
                                    {
                                        childID = appRelationship2.endpoint1.ucmdbId;
                                        foreach (uCmdbCi appCi2 in ucmdbObj.configurationItems)
                                        {
                                            if (appCi2.ucmdbId == childID)
                                            {
                                                //set values
                                                uCmdbAttributes appAttributes2 = appCi2.attributes;

                                                switch ((int)appAttributes2.hp_org_lvl_nbr)// for our purpose we only need L2 and L3
                                                {
                                                case 2:
                                                    //set lvl 2 org value
                                                    cmdbAppDetailObj.setLevel2OrgId(appAttributes2.name);
                                                    break;

                                                case 3:
                                                    cmdbAppDetailObj.setLevel3OrgID(appAttributes2.name);
                                                    break;
                                                }
                                                break;      //exit appCi2 loop once found
                                            }
                                        }
                                        break;              //exit appRelationship2 loop once found
                                    }
                                }
                            }
                            break;                          //exit appRelationship loop once found
                        }
                    }
                }
            }

            return(cmdbAppDetailObj);
        }