Exemple #1
0
        //Add data in neo4j
        public bool insertAssetGroup(AssetGroup ag, int parentId)
        {
            List <Property> lp = new List <Property>();

            lp.Add(new Property("Name", ag.name));
            lp.Add(new Property("itemNR", ag.itemNR));
            lp.Add(new Property("contractNR", ag.contractNR));

            int assetId = AddNode("Group", lp);

            if (parentId >= 0)
            {
                AddRelationshipNode("Decomposed_By", lp, parentId, assetId);
            }
            //Add Characteristics
            foreach (Characteristic c in ag.characteristics)
            {
                lp = new List <Property>();
                lp.Add(new Property("Name", c.name ?? ""));
                lp.Add(new Property("Description", c.description ?? ""));
                lp.Add(new Property("Format", c.format ?? ""));
                lp.Add(new Property("Unit", c.unit ?? ""));
                lp.Add(new Property("Prefix", c.prefix ?? ""));
                lp.Add(new Property("Value", c.value ?? ""));
                lp.Add(new Property("stakeholderIdCreate", c.stakeholderIdCreate.ToString() ?? ""));
                lp.Add(new Property("stakeholderIdCreate", c.timestampCreate.ToString() ?? ""));

                int characteristicId = AddNode("Characteristic", lp);
                lp = new List <Property>();
                AddRelationshipNode("Specified_By", lp, assetId, characteristicId);
            }
            //Add Group
            foreach (AssetGroup a in ag.assetGroups)
            {
                insertAssetGroup(a, assetId);
            }
            //Add Group
            foreach (AssetMachine a in ag.assetMachines)
            {
                insertAssetMachine(a, assetId);
            }
            return(true);
        }
Exemple #2
0
        public void readProjectFromExcel()
        {
            Microsoft.Office.Interop.Excel.Application xlApp       = new Microsoft.Office.Interop.Excel.Application();
            Microsoft.Office.Interop.Excel.Workbook    xlWorkbook  = xlApp.Workbooks.Open("C:/Users/32477/Downloads/213032 EQUIPMENT LIST_revF.xls");
            Microsoft.Office.Interop.Excel._Worksheet  xlWorksheet = xlWorkbook.Sheets[1];
            Microsoft.Office.Interop.Excel.Range       xlRange     = xlWorksheet.UsedRange;

            string activeComponent = ""; //G, S, C, M

            //Create project
            projectFile                 = new AssetGroup();
            projectFile.assetGroups     = new List <AssetGroup>();
            projectFile.assetMachines   = new List <AssetMachine>();
            projectFile.characteristics = new List <Characteristic>();

            AssetGroup         ag;
            AssetMachine       am;
            AssetScopeOfSupply asos;
            Characteristic     c;
            Statement          t;


            int rowCount   = xlRange.Rows.Count;
            int groupCount = 0;

            List <string[]> assets = new List <string[]>();

            int index = 0;

            for (int i = 1; i <= rowCount; i++)
            {
                if (xlRange.Cells[i, 1] != null && xlRange.Cells[i, 1].Value2 != null)
                {
                    //First column of row contains indication letter
                    //Store indication letter to activecomponent
                    activeComponent = xlRange.Cells[i, 1].Value2.ToString();
                    switch (activeComponent)
                    {
                    case "G":
                        if (groupCount == 0)
                        {
                            projectFile.itemNR     = (xlRange.Cells[i, 3].Value2 ?? "").ToString();
                            projectFile.contractNR = (xlRange.Cells[i, 4].Value2 ?? "").ToString();
                            projectFile.name       = (xlRange.Cells[i, 5].Value2 ?? "").ToString();
                        }
                        else
                        {
                            ag                 = new AssetGroup();
                            ag.name            = (xlRange.Cells[i, 5].Value2 ?? "").ToString() + " " + (xlRange.Cells[i, 6].Value2 ?? "").ToString();
                            ag.itemNR          = (xlRange.Cells[i, 3].Value2 ?? "").ToString();
                            ag.contractNR      = (xlRange.Cells[i, 4].Value2 ?? "").ToString();
                            ag.characteristics = new List <Characteristic>();
                            ag.assetGroups     = new List <AssetGroup>();
                            ag.assetMachines   = new List <AssetMachine>();
                            string nr = (xlRange.Cells[i, 3].Value2 ?? "").ToString();
                            index = 4 - nr.Count(x => x == '0');
                            if (index == 4)
                            {
                                index = 3;
                            }
                            switch (index)
                            {
                            case 1:
                                projectFile.assetGroups.Add(ag);
                                break;

                            case 2:
                                projectFile.assetGroups.Last().assetGroups.Add(ag);
                                break;
                            }
                        }
                        groupCount++;
                        break;

                    case "M":
                        string nr2 = (xlRange.Cells[i, 3].Value2 ?? "").ToString();
                        index = 4 - nr2.Count(x => x == '0');
                        if (index == 4)
                        {
                            index = 3;
                        }
                        am                    = new AssetMachine();
                        am.itemNR             = (xlRange.Cells[i, 3].Value2 ?? "").ToString();
                        am.contractNR         = (xlRange.Cells[i, 4].Value2 ?? "").ToString();
                        am.name               = (xlRange.Cells[i, 6].Value2 ?? "").ToString();
                        am.characteristics    = new List <Characteristic>();
                        am.assetScopeOfSupply = new List <AssetScopeOfSupply>();
                        projectFile.assetGroups.Last().assetGroups.Last().assetMachines.Add(am);
                        break;

                    case "S":
                        break;

                    case "C":
                        c        = new Characteristic();
                        c.name   = (xlRange.Cells[i, 6].Value2 ?? "").ToString();
                        c.prefix = (xlRange.Cells[i, 8].Value2 ?? "").ToString();
                        c.value  = (xlRange.Cells[i, 9].Value2 ?? "").ToString();
                        c.unit   = (xlRange.Cells[i, 10].Value2 ?? "").ToString();
                        switch (index)
                        {
                        case 0:
                            projectFile.characteristics.Add(c);
                            break;

                        case 1:
                            projectFile.assetGroups.Last().characteristics.Add(c);
                            break;

                        case 2:
                            projectFile.assetGroups.Last().assetGroups.Last().characteristics.Add(c);
                            break;

                        case 3:
                            projectFile.assetGroups.Last().assetGroups.Last().assetMachines.Last().characteristics.Add(c);
                            break;
                        }
                        //Add Characteristic to parent group, machine or scope
                        break;

                    case "T":
                        t           = new Statement();
                        t.statement = (xlRange.Cells[i, 6].Value2 ?? "").ToString();
                        //Add Statement to group, machine or scope
                        break;
                    }
                }
            }
        }
Exemple #3
0
        public AssetGroup loadProject()
        {
            AssetGroup ag = new AssetGroup();

            return(ag);
        }