public static FedIDStatus getFederatedModel(string modelName, string projName, string projNumber, out FederatedModelInfo fedModel) { fedModel = new FederatedModelInfo(); FedIDStatus stat = FedIDStatus.FedIDExisting; string currStep = "Getting federated ID"; // Create separate connection with a short duration string SqlStmt = "Select FEDERATEDID federatedID, ModelName, ProjectNumber, ProjectName, WORLDBBOX, MAXOCTREELEVEL, LastUpdateDate, Owner, DBConnection from BIMRL_FEDERATEDMODEL where MODELNAME = '" + modelName + "' and PROJECTNAME = '" + projName + "' and PROJECTNUMBER = '" + projNumber + "'"; OracleCommand command = new OracleCommand(SqlStmt, DBConn); OracleDataReader reader = command.ExecuteReader(); try { if (!reader.Read()) { reader.Close(); // Create a new record command.CommandText = "Insert into BIMRL_FEDERATEDMODEL (MODELNAME, PROJECTNAME, PROJECTNUMBER) values ('" + modelName + "', '" + projName + "', '" + projNumber + "')"; DBOperation.beginTransaction(); command.ExecuteNonQuery(); DBOperation.commitTransaction(); stat = FedIDStatus.FedIDNew; } command.CommandText = SqlStmt; reader = command.ExecuteReader(); reader.Read(); fedModel.FederatedID = reader.GetInt32(0); fedModel.ModelName = reader.GetString(1); fedModel.ProjectNumber = reader.GetString(2); fedModel.ProjectName = reader.GetString(3); if (!reader.IsDBNull(4)) { SdoGeometry worldBB = reader.GetValue(4) as SdoGeometry; Point3D LLB = new Point3D(worldBB.OrdinatesArrayOfDoubles[0], worldBB.OrdinatesArrayOfDoubles[1], worldBB.OrdinatesArrayOfDoubles[2]); Point3D URT = new Point3D(worldBB.OrdinatesArrayOfDoubles[3], worldBB.OrdinatesArrayOfDoubles[4], worldBB.OrdinatesArrayOfDoubles[5]); fedModel.WorldBoundingBox = LLB.ToString() + " " + URT.ToString(); } if (!reader.IsDBNull(5)) { fedModel.OctreeMaxDepth = reader.GetInt16(5); } if (!reader.IsDBNull(6)) { fedModel.LastUpdateDate = reader.GetDateTime(6); } if (!reader.IsDBNull(7)) { fedModel.Owner = reader.GetString(7); } if (!reader.IsDBNull(8)) { fedModel.DBConnection = reader.GetString(8); } reader.Close(); } catch (OracleException e) { string excStr = "%%Error - " + e.Message + "\n\t" + currStep; refBIMRLCommon.StackPushError(excStr); command.Dispose(); throw; } command.Dispose(); return(stat); }
public BIMRLProcessModel(IModel model, bool update) { //IfcProject proj = model.IfcProject; IfcStore modelStore = model as IfcStore; string currStep = String.Empty; _bimrlCommon.resetAll(); // Connect to Oracle DB DBOperation.refBIMRLCommon = _bimrlCommon; // important to ensure DBoperation has reference to this object!! try { DBOperation.ExistingOrDefaultConnection(); } catch { if (DBOperation.UIMode) { BIMRLErrorDialog erroDlg = new BIMRLErrorDialog(_bimrlCommon); erroDlg.ShowDialog(); } else { Console.Write(_bimrlCommon.ErrorMessages); } return; } DBOperation.commitInterval = 5000; // Initial Spatial index for later use BIMRLSpatialIndex spIdx = new BIMRLSpatialIndex(_bimrlCommon); try { DBOperation.beginTransaction(); IIfcProject firstProject; if (modelStore.IsFederation) { IfcStore firstModel = modelStore.ReferencedModels.FirstOrDefault().Model as IfcStore; firstProject = firstModel.Instances.OfType <IIfcProject>().FirstOrDefault(); } else { firstProject = modelStore.Instances.OfType <IIfcProject>().FirstOrDefault(); } string projLName; // Check whether Model has been defined before if (string.IsNullOrEmpty(firstProject.LongName)) { projLName = firstProject.Name + " - Federated"; } else { projLName = firstProject.LongName; } string modelNameFromFile; if (!string.IsNullOrEmpty(modelStore.FileName)) { modelNameFromFile = Path.GetFileNameWithoutExtension(modelStore.FileName); } else { modelNameFromFile = firstProject.Name + " - " + firstProject.LongName; } currStep = "Getting Federated ID from BIMRL_FEDERATEDMODEL - Model name, Project name and longname: " + modelNameFromFile + "; " + firstProject.Name + "; " + firstProject.LongName; FederatedModelInfo fedModel; FedIDStatus stat = DBOperation.getFederatedModel(modelNameFromFile, projLName, firstProject.Name, out fedModel); if (stat == FedIDStatus.FedIDNew) { DBOperation.currFedModel = fedModel; // Create new set of tables using the fedID as suffix int retStat = DBOperation.createModelTables(DBOperation.currFedModel.FederatedID); } else { DBOperation.currFedModel = fedModel; if (!fedModel.Owner.Equals(DBOperation.DBUserID)) { _bimrlCommon.StackPushError("%Error: Only the Owner (" + fedModel.Owner + ") can delete or override existing model (!" + fedModel.ModelName + ")"); throw new Exception("%Error: Unable to overwrite exisitng model"); } // Drop and recreate tables currStep = "Dropping existing model tables (ID: " + DBOperation.currFedModel.FederatedID.ToString("X4") + ")"; int retStat = DBOperation.dropModelTables(DBOperation.currFedModel.FederatedID); currStep = "Creating model tables (ID: " + DBOperation.currFedModel.FederatedID.ToString("X4") + ")"; retStat = DBOperation.createModelTables(DBOperation.currFedModel.FederatedID); } DBOperation.currSelFedID = DBOperation.currFedModel.FederatedID; // set the static variable keeping the selected Fed Id if (modelStore.IsFederation) { // get all models foreach (IReferencedModel refModel in modelStore.ReferencedModels) { IfcStore m = refModel.Model as IfcStore; currStep = "Getting Model ID for Federated model ID:" + DBOperation.currFedModel.FederatedID.ToString("X4"); _bimrlCommon.ClearDicts(); _ModelID = DBOperation.getModelID(DBOperation.currFedModel.FederatedID); doModel(m); BIMRLUtils.ResetIfcUnitDicts(); } } else { currStep = "Getting Model ID for Federated model ID:" + DBOperation.currFedModel.FederatedID.ToString("X4"); _ModelID = DBOperation.getModelID(DBOperation.currFedModel.FederatedID); doModel(modelStore); BIMRLUtils.ResetIfcUnitDicts(); } } catch (Exception e) { string excStr = "%%Error - " + e.Message + "\n\t" + currStep; _bimrlCommon.StackPushError(excStr); DBOperation.endTransaction(false); // rollback } DBOperation.endTransaction(true); // Commit = true try { DBOperation.beginTransaction(); OracleCommand cmd = new OracleCommand("", DBOperation.DBConn); // Define the spatial index metadata double marginX = (_bimrlCommon.URT_X - _bimrlCommon.LLB_X) * 0.2; // 20% margin double marginY = (_bimrlCommon.URT_Y - _bimrlCommon.LLB_Y) * 0.2; // 20% margin double marginZ = (_bimrlCommon.URT_Z - _bimrlCommon.LLB_Z) * 0.2; // 20% margin double lowerX = _bimrlCommon.LLB_X - marginX; double upperX = _bimrlCommon.URT_X + marginX; double lowerY = _bimrlCommon.LLB_Y - marginY; double upperY = _bimrlCommon.URT_Y + marginY; double lowerZ = _bimrlCommon.LLB_Z - marginZ; double upperZ = _bimrlCommon.URT_Z + marginZ; string sqlStmt = "insert into USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES " + "('BIMRL_ELEMENT_" + DBOperation.currFedModel.FederatedID.ToString("X4") + "','GEOMETRYBODY'," + "SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', " + lowerX.ToString() + ", " + upperX.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Y', " + lowerY.ToString() + ", " + upperY.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Z', " + lowerZ.ToString() + ", " + upperZ.ToString() + ", 0.000001))," + "NULL)"; currStep = sqlStmt; cmd.CommandText = sqlStmt; cmd.ExecuteNonQuery(); sqlStmt = "insert into USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES " + "('BIMRL_ELEMENT_" + DBOperation.currFedModel.FederatedID.ToString("X4") + "','GEOMETRYBODY_BBOX'," + "SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', " + lowerX.ToString() + ", " + upperX.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Y', " + lowerY.ToString() + ", " + upperY.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Z', " + lowerZ.ToString() + ", " + upperZ.ToString() + ", 0.000001))," + "NULL)"; currStep = sqlStmt; cmd.CommandText = sqlStmt; cmd.ExecuteNonQuery(); sqlStmt = "insert into USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES " + "('BIMRL_ELEMENT_" + DBOperation.currFedModel.FederatedID.ToString("X4") + "','GEOMETRYBODY_BBOX_CENTROID'," + "SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', " + lowerX.ToString() + ", " + upperX.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Y', " + lowerY.ToString() + ", " + upperY.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Z', " + lowerZ.ToString() + ", " + upperZ.ToString() + ", 0.000001))," + "NULL)"; currStep = sqlStmt; cmd.CommandText = sqlStmt; cmd.ExecuteNonQuery(); sqlStmt = "insert into USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES " + "('BIMRL_ELEMENT_" + DBOperation.currFedModel.FederatedID.ToString("X4") + "','GEOMETRYFOOTPRINT'," + "SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', " + lowerX.ToString() + ", " + upperX.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Y', " + lowerY.ToString() + ", " + upperY.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Z', " + lowerZ.ToString() + ", " + upperZ.ToString() + ", 0.000001))," + "NULL)"; currStep = sqlStmt; cmd.CommandText = sqlStmt; cmd.ExecuteNonQuery(); sqlStmt = "insert into USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES " + "('BIMRL_ELEMENT_" + DBOperation.currFedModel.FederatedID.ToString("X4") + "','GEOMETRYAXIS'," + "SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', " + lowerX.ToString() + ", " + upperX.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Y', " + lowerY.ToString() + ", " + upperY.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Z', " + lowerZ.ToString() + ", " + upperZ.ToString() + ", 0.000001))," + "NULL)"; currStep = sqlStmt; cmd.CommandText = sqlStmt; cmd.ExecuteNonQuery(); sqlStmt = "insert into USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES " + "('BIMRL_ELEMENT_" + DBOperation.currFedModel.FederatedID.ToString("X4") + "','BODY_MAJOR_AXIS1'," + "SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -1.01, 1.01, 0.000001)," + "SDO_DIM_ELEMENT('Y', -1.01, 1.01, 0.000001)," + "SDO_DIM_ELEMENT('Z', -1.01, 1.01, 0.000001))," + "NULL)"; currStep = sqlStmt; cmd.CommandText = sqlStmt; cmd.ExecuteNonQuery(); sqlStmt = "insert into USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES " + "('BIMRL_ELEMENT_" + DBOperation.currFedModel.FederatedID.ToString("X4") + "','BODY_MAJOR_AXIS2'," + "SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -1.01, 1.01, 0.000001)," + "SDO_DIM_ELEMENT('Y', -1.01, 1.01, 0.000001)," + "SDO_DIM_ELEMENT('Z', -1.01, 1.01, 0.000001))," + "NULL)"; currStep = sqlStmt; cmd.CommandText = sqlStmt; cmd.ExecuteNonQuery(); sqlStmt = "insert into USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES " + "('BIMRL_ELEMENT_" + DBOperation.currFedModel.FederatedID.ToString("X4") + "','BODY_MAJOR_AXIS3'," + "SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -1.01, 1.01, 0.000001)," + "SDO_DIM_ELEMENT('Y', -1.01, 1.01, 0.000001)," + "SDO_DIM_ELEMENT('Z', -1.01, 1.01, 0.000001))," + "NULL)"; currStep = sqlStmt; cmd.CommandText = sqlStmt; cmd.ExecuteNonQuery(); sqlStmt = "insert into USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES " + "('BIMRL_ELEMENT_" + DBOperation.currFedModel.FederatedID.ToString("X4") + "','BODY_MAJOR_AXIS_CENTROID'," + "SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', " + lowerX.ToString() + ", " + upperX.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Y', " + lowerY.ToString() + ", " + upperY.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Z', " + lowerZ.ToString() + ", " + upperZ.ToString() + ", 0.000001))," + "NULL)"; currStep = sqlStmt; cmd.CommandText = sqlStmt; cmd.ExecuteNonQuery(); sqlStmt = "insert into USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES " + "('BIMRL_TOPO_FACE_" + DBOperation.currFedModel.FederatedID.ToString("X4") + "','POLYGON'," + "SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', " + lowerX.ToString() + ", " + upperX.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Y', " + lowerY.ToString() + ", " + upperY.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Z', " + lowerZ.ToString() + ", " + upperZ.ToString() + ", 0.000001))," + "NULL)"; currStep = sqlStmt; cmd.CommandText = sqlStmt; cmd.ExecuteNonQuery(); sqlStmt = "insert into USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES " + "('BIMRL_TOPO_FACE_" + DBOperation.currFedModel.FederatedID.ToString("X4") + "','NORMAL'," + "SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -1.01, 1.01, 0.000001)," + "SDO_DIM_ELEMENT('Y', -1.01, 1.01, 0.000001)," + "SDO_DIM_ELEMENT('Z', -1.01, 1.01, 0.000001))," + "NULL)"; currStep = sqlStmt; cmd.CommandText = sqlStmt; cmd.ExecuteNonQuery(); sqlStmt = "insert into USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) VALUES " + "('BIMRL_TOPO_FACE_" + DBOperation.currFedModel.FederatedID.ToString("X4") + "','CENTROID'," + "SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', " + lowerX.ToString() + ", " + upperX.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Y', " + lowerY.ToString() + ", " + upperY.ToString() + ", 0.000001)," + "SDO_DIM_ELEMENT('Z', " + lowerZ.ToString() + ", " + upperZ.ToString() + ", 0.000001))," + "NULL)"; currStep = sqlStmt; cmd.CommandText = sqlStmt; cmd.ExecuteNonQuery(); sqlStmt = "Update BIMRL_FEDERATEDMODEL SET LastUpdateDate=sysdate WHERE FederatedID=" + DBOperation.currFedModel.FederatedID.ToString(); currStep = sqlStmt; cmd.CommandText = sqlStmt; cmd.ExecuteNonQuery(); // get the world BBox coordinates and update the BIMRL_FEDERATEDMODEL Table SdoGeometry Bbox = new SdoGeometry(); Bbox.Dimensionality = 3; Bbox.LRS = 0; Bbox.GeometryType = (int)SdoGeometryTypes.GTYPE.POINT; int gType = Bbox.PropertiesToGTYPE(); int[] elemInfoArr = { 1, (int)SdoGeometryTypes.ETYPE_SIMPLE.POLYGON_EXTERIOR, 1 }; Bbox.ElemArrayOfInts = elemInfoArr; double[] coordArr = new double[6]; coordArr[0] = _bimrlCommon.LLB_X; coordArr[1] = _bimrlCommon.LLB_Y; coordArr[2] = _bimrlCommon.LLB_Z; coordArr[3] = _bimrlCommon.URT_X; coordArr[4] = _bimrlCommon.URT_Y; coordArr[5] = _bimrlCommon.URT_Z; Bbox.OrdinatesArrayOfDoubles = coordArr; // Create spatial index from the new model (list of triangles are accummulated during processing of geometries) sqlStmt = "update BIMRL_FEDERATEDMODEL SET WORLDBBOX=:1 , MAXOCTREELEVEL=:2 WHERE FEDERATEDID=" + DBOperation.currFedModel.FederatedID.ToString(); currStep = sqlStmt; OracleCommand command = new OracleCommand(" ", DBOperation.DBConn); command.CommandText = sqlStmt; OracleParameter[] sdoGeom2 = new OracleParameter[3]; sdoGeom2[0] = command.Parameters.Add("1", OracleDbType.Object); sdoGeom2[0].Direction = ParameterDirection.Input; sdoGeom2[0].UdtTypeName = "MDSYS.SDO_GEOMETRY"; sdoGeom2[0].Value = Bbox; sdoGeom2[0].Size = 1; sdoGeom2[1] = command.Parameters.Add("2", OracleDbType.Int16); sdoGeom2[1].Direction = ParameterDirection.Input; sdoGeom2[1].Value = DBOperation.OctreeSubdivLevel; sdoGeom2[1].Size = 1; int commandStatus = command.ExecuteNonQuery(); if (DBOperation.OnepushETL) { DBOperation.commitInterval = 10000; int octreeLevel = DBOperation.computeRecomOctreeLevel(DBOperation.currFedModel.FederatedID); // 1. Create Octree spatial indexes and the Brep Topology Faces spIdx.createSpatialIndexFromBIMRLElement(DBOperation.currFedModel.FederatedID, null, true, true); // 2. Update major Axes and OBB BIMRLUtils.updateMajorAxesAndOBB(DBOperation.currFedModel.FederatedID, null); // 3. Enhance Space Boundary EnhanceBRep eBrep = new EnhanceBRep(); eBrep.enhanceSpaceBoundary(null); // 4. Process Face orientations. We will procees the normal face first and then after that the spacial ones (OBB, PROJOBB) string whereCond2 = ""; BIMRLCommon.appendToString(" TYPE NOT IN ('OBB','PROJOBB')", " AND ", ref whereCond2); eBrep.ProcessOrientation(whereCond2); whereCond2 = ""; BIMRLCommon.appendToString(" TYPE='OBB'", " AND ", ref whereCond2); eBrep.ProcessOrientation(whereCond2); whereCond2 = ""; BIMRLCommon.appendToString(" TYPE='PROJOBB'", " AND ", ref whereCond2); eBrep.ProcessOrientation(whereCond2); // 5. Create Graph Data BIMRLGraph.GraphData graphData = new BIMRLGraph.GraphData(); graphData.createCirculationGraph(DBOperation.currFedModel.FederatedID); graphData.createSpaceAdjacencyGraph(DBOperation.currFedModel.FederatedID); sqlStmt = "UPDATE BIMRL_FEDERATEDMODEL SET LASTUPDATEDATE=sysdate"; BIMRLCommon.appendToString("MAXOCTREELEVEL=" + octreeLevel.ToString(), ", ", ref sqlStmt); BIMRLCommon.appendToString("WHERE FEDERATEDID=" + DBOperation.currFedModel.FederatedID.ToString(), " ", ref sqlStmt); DBOperation.executeSingleStmt(sqlStmt); } else { // Minimum (without One-push ETL, create the bounding boxes (AABB) spIdx.createSpatialIndexFromBIMRLElement(DBOperation.currFedModel.FederatedID, null, false, false); } var location = new Uri(Assembly.GetEntryAssembly().GetName().CodeBase); string exePath = new FileInfo(location.AbsolutePath).Directory.FullName; // (Re)-Create the spatial indexes DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_SpatialIndexes.sql"), DBOperation.currFedModel.FederatedID); DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_TopoFace.sql"), DBOperation.currFedModel.FederatedID); DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_MajorAxes.sql"), DBOperation.currFedModel.FederatedID); //sqlStmt = "Create Index IDX_BIMRLELEM_GEOM_" + currFedID.ToString("X4") + " on BIMRL_ELEMENT_" + currFedID.ToString("X4") // + " (GEOMETRYBODY) INDEXTYPE is MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3')"; //currStep = sqlStmt; //cmd.CommandText = sqlStmt; //cmd.ExecuteNonQuery(); //sqlStmt = "Create Index IDX_BIMRLELEM_GEOMBB_" + currFedID.ToString("X4") + " on BIMRL_ELEMENT_" + currFedID.ToString("X4") // + " (GeometryBody_BBOX) INDEXTYPE is MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3')"; //currStep = sqlStmt; //cmd.CommandText = sqlStmt; //cmd.ExecuteNonQuery(); //sqlStmt = "Create Index IDX_BIMRLELEM_GEOMBBC_" + currFedID.ToString("X4") + " on BIMRL_ELEMENT_" + currFedID.ToString("X4") // + " (GeometryBody_BBOX_CENTROID) INDEXTYPE is MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3')"; //currStep = sqlStmt; //cmd.CommandText = sqlStmt; //cmd.ExecuteNonQuery(); //sqlStmt = "Create Index IDX_BIMRLELEM_GEOMFP_" + currFedID.ToString("X4") + " on BIMRL_ELEMENT_" + currFedID.ToString("X4") // + " (GeometryFootprint) INDEXTYPE is MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3')"; //currStep = sqlStmt; //cmd.CommandText = sqlStmt; //cmd.ExecuteNonQuery(); //sqlStmt = "Create Index IDX_BIMRLELEM_GEOMAX_" + currFedID.ToString("X4") + " on BIMRL_ELEMENT_" + currFedID.ToString("X4") // + " (GeometryAxis) INDEXTYPE is MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3')"; //currStep = sqlStmt; //cmd.CommandText = sqlStmt; //cmd.ExecuteNonQuery(); //sqlStmt = "Create Index IDX_BIMRLELEM_GEOMMJ1_" + currFedID.ToString("X4") + " on BIMRL_ELEMENT_" + currFedID.ToString("X4") // + " (BODY_MAJOR_AXIS1) INDEXTYPE is MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3')"; //currStep = sqlStmt; //cmd.CommandText = sqlStmt; //cmd.ExecuteNonQuery(); //sqlStmt = "Create Index IDX_BIMRLELEM_GEOMMJ2_" + currFedID.ToString("X4") + " on BIMRL_ELEMENT_" + currFedID.ToString("X4") // + " (BODY_MAJOR_AXIS2) INDEXTYPE is MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3')"; //currStep = sqlStmt; //cmd.CommandText = sqlStmt; //cmd.ExecuteNonQuery(); //sqlStmt = "Create Index IDX_BIMRLELEM_GEOMMJ3_" + currFedID.ToString("X4") + " on BIMRL_ELEMENT_" + currFedID.ToString("X4") // + " (BODY_MAJOR_AXIS3) INDEXTYPE is MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3')"; //currStep = sqlStmt; //cmd.CommandText = sqlStmt; //cmd.ExecuteNonQuery(); //sqlStmt = "Create Index IDX_BIMRLELEM_GEOMMJC_" + currFedID.ToString("X4") + " on BIMRL_ELEMENT_" + currFedID.ToString("X4") // + " (BODY_MAJOR_AXIS_CENTROID) INDEXTYPE is MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3')"; //currStep = sqlStmt; //cmd.CommandText = sqlStmt; //cmd.ExecuteNonQuery(); //sqlStmt = "Create Index IDX_TOPOF_POLYGON_" + currFedID.ToString("X4") + " on BIMRL_TOPO_FACE_" + currFedID.ToString("X4") // + " (POLYGON) INDEXTYPE is MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3')"; //currStep = sqlStmt; //cmd.CommandText = sqlStmt; //cmd.ExecuteNonQuery(); //sqlStmt = "Create Index IDX_TOPOF_NORMAL_" + currFedID.ToString("X4") + " on BIMRL_TOPO_FACE_" + currFedID.ToString("X4") // + " (NORMAL) INDEXTYPE is MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3')"; //currStep = sqlStmt; //cmd.CommandText = sqlStmt; //cmd.ExecuteNonQuery(); //sqlStmt = "Create Index IDX_TOPOF_CENTROID_" + currFedID.ToString("X4") + " on BIMRL_TOPO_FACE_" + currFedID.ToString("X4") // + " (CENTROID) INDEXTYPE is MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3')"; //currStep = sqlStmt; //cmd.CommandText = sqlStmt; //cmd.ExecuteNonQuery(); DBOperation.commitTransaction(); } catch (Exception e) { string excStr = "%%Error - " + e.Message + "\n\t" + currStep; _bimrlCommon.StackPushError(excStr); if (DBOperation.UIMode) { BIMRLErrorDialog errorDlg = new BIMRLErrorDialog(_bimrlCommon); errorDlg.ShowDialog(); } else { Console.Write(_bimrlCommon.ErrorMessages); } } // There are entries in the error stack, show them at the end if (_bimrlCommon.BIMRLErrorStackCount > 0) { if (DBOperation.UIMode) { BIMRLErrorDialog errorDlg = new BIMRLErrorDialog(_bimrlCommon); errorDlg.ShowDialog(); } else { Console.Write(_bimrlCommon.ErrorMessages); } } }