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);
}
}
}
private void Button_RegenGeometry_Click(object sender, RoutedEventArgs e)
{
BIMRLSpatialIndex spIdx = new BIMRLSpatialIndex(BIMRLCommonRef);
DBOperation.commitInterval = 5000;
double currentTol = MathUtils.tol;
var location = new Uri(Assembly.GetEntryAssembly().GetName().CodeBase);
string exePath = new FileInfo(location.AbsolutePath).Directory.FullName;
// Temporarily change the tolerance if it is set in the UI
if (!string.IsNullOrEmpty(TextBox_Tolerance.Text))
{
double tolSetting;
if (double.TryParse(TextBox_Tolerance.Text, out tolSetting))
{
MathUtils.tol = tolSetting;
}
}
if (!string.IsNullOrEmpty(TextBox_OctreeLevel.Text))
{
int level = -1;
level = int.Parse(TextBox_OctreeLevel.Text);
if (level > 0)
{
DBOperation.OctreeSubdivLevel = level;
}
}
int FedID = -1;
FederatedModelInfo selFedModelsItem = DataGrid_FedModels.SelectedItem as FederatedModelInfo;
if (selFedModelsItem == null)
{
return; // do nothing, no selection made
}
else
{
FederatedModelInfo selFedModel = selFedModelsItem;
FedID = selFedModel.FederatedID;
}
try
{
if (FedID >= 0)
{
string whereCond = null;
string updOctreeLevel = "";
if (!string.IsNullOrEmpty(TextBox_Additional_Condition.Text))
{
whereCond = TextBox_Additional_Condition.Text;
// Spatial always needs to be reconstructed even when one object is updated to maintain integrity of non-overlapping octree concept
if (regenSpatialIndex)
{
// We need the existing data to regenerate the dictionary. Truncate operation will be deferred until just before insert into the table
// DBOperation.executeSingleStmt("TRUNCATE TABLE BIMRL_SPATIALINDEX_" + FedID.ToString("X4"));
// DBOperation.executeSingleStmt("DELETE FROM BIMRL_SPATIALINDEX_" + FedID.ToString("X4") + " WHERE " + whereCond);
}
if (regenBoundaryFaces)
{
DBOperation.executeSingleStmt("DELETE FROM " + DBOperation.formatTabName("BIMRL_TOPO_FACE", FedID) + " WHERE " + whereCond);
}
}
else
{
FederatedModelInfo fedModel = DBOperation.getFederatedModelByID(FedID);
if (DBOperation.DBUserID.Equals(fedModel.Owner))
{
if (regenSpatialIndex)
{
DBOperation.executeSingleStmt("TRUNCATE TABLE " + DBOperation.formatTabName("BIMRL_SPATIALINDEX", FedID));
}
if (regenBoundaryFaces)
{
DBOperation.executeSingleStmt("TRUNCATE TABLE " + DBOperation.formatTabName("BIMRL_TOPO_FACE", FedID));
}
}
else
{
if (regenSpatialIndex)
{
DBOperation.executeSingleStmt("DELETE FROM " + DBOperation.formatTabName("BIMRL_SPATIALINDEX", FedID));
}
if (regenBoundaryFaces)
{
DBOperation.executeSingleStmt("DELETE FROM " + DBOperation.formatTabName("BIMRL_TOPO_FACE", FedID));
}
}
}
// Update Spatial index (including major axes and OBB) and Boundary faces
if (regenSpatialIndex && regenBoundaryFaces && _majorAxes)
{
spIdx.createSpatialIndexFromBIMRLElement(FedID, whereCond, true);
BIMRLUtils.updateMajorAxesAndOBB(FedID, whereCond);
DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_SpatialIndexes.sql"), FedID);
DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_TopoFace.sql"), FedID);
DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_MajorAxes.sql"), FedID);
updOctreeLevel = "MAXOCTREELEVEL=" + DBOperation.OctreeSubdivLevel;
}
else if (regenSpatialIndex && regenBoundaryFaces && !_majorAxes)
{
spIdx.createSpatialIndexFromBIMRLElement(FedID, whereCond, true);
DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_SpatialIndexes.sql"), FedID);
DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_TopoFace.sql"), FedID);
updOctreeLevel = "MAXOCTREELEVEL=" + DBOperation.OctreeSubdivLevel;
}
// Update Spatial index (including major axes and OBB) only
else if (regenSpatialIndex && !regenBoundaryFaces && _majorAxes)
{
spIdx.createSpatialIndexFromBIMRLElement(FedID, whereCond, false);
BIMRLUtils.updateMajorAxesAndOBB(FedID, whereCond);
DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_SpatialIndexes.sql"), FedID);
DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_MajorAxes.sql"), FedID);
updOctreeLevel = "MAXOCTREELEVEL=" + DBOperation.OctreeSubdivLevel;
}
// Update Boundary faces and MajorAxes
else if (!regenSpatialIndex && regenBoundaryFaces && _majorAxes)
{
spIdx.createFacesFromBIMRLElement(FedID, whereCond);
DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_TopoFace.sql"), FedID);
BIMRLUtils.updateMajorAxesAndOBB(FedID, whereCond);
DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_MajorAxes.sql"), FedID);
}
// Update Spatial Index only
else if (regenSpatialIndex && !regenBoundaryFaces && !_majorAxes)
{
spIdx.createSpatialIndexFromBIMRLElement(FedID, whereCond, false);
DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_SpatialIndexes.sql"), FedID);
updOctreeLevel = "MAXOCTREELEVEL=" + DBOperation.OctreeSubdivLevel;
}
// update faces only
else if (!regenSpatialIndex && regenBoundaryFaces && !_majorAxes)
{
spIdx.createFacesFromBIMRLElement(FedID, whereCond);
DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_TopoFace.sql"), FedID);
}
// Update only the major axes and OBB only
else if (!regenSpatialIndex && !regenBoundaryFaces && _majorAxes)
{
BIMRLUtils.updateMajorAxesAndOBB(FedID, whereCond);
DBOperation.executeScript(Path.Combine(exePath, "script", "BIMRL_Idx_MajorAxes.sql"), FedID);
}
else
{
// Invalid option
}
string sqlStmt = "UPDATE BIMRL_FEDERATEDMODEL SET LASTUPDATEDATE=sysdate";
BIMRLCommon.appendToString(updOctreeLevel, ", ", ref sqlStmt);
BIMRLCommon.appendToString("WHERE FEDERATEDID=" + FedID, " ", ref sqlStmt);
DBOperation.executeSingleStmt(sqlStmt);
}
}
catch (SystemException excp)
{
string excStr = "%% Error - " + excp.Message + "\n\t";
BIMRLCommonRef.StackPushError(excStr);
if (BIMRLCommonRef.BIMRLErrorStackCount > 0)
{
showError(null);
}
}
MathUtils.tol = currentTol;
}
private void processSpatialStructureData()
{
string currStep = string.Empty;
DBOperation.beginTransaction();
string container = string.Empty;
int commandStatus = -1;
int currInsertCount = 0;
OracleCommand command = new OracleCommand(" ", DBOperation.DBConn);
try
{
IEnumerable <IIfcSpatialStructureElement> spatialStructure = _model.Instances.OfType <IIfcSpatialStructureElement>();
foreach (IIfcSpatialStructureElement sse in spatialStructure)
{
string SqlStmt;
// do something
string guid = sse.GlobalId.ToString();
int IfcLineNo = sse.EntityLabel;
string elementtype = sse.GetType().Name.ToUpper();
string typeID = String.Empty;
int typeLineNo = 0;
IEnumerable <IIfcRelDefinesByType> relTyp = sse.IsTypedBy;
if (relTyp != null || relTyp.Count() > 0)
{
IIfcRelDefinesByType typ = relTyp.FirstOrDefault();
if (typ != null)
{
typeID = typ.RelatingType.GlobalId.ToString();
typeLineNo = typ.RelatingType.EntityLabel;
}
}
//if (sse.GetDefiningType() != null)
// {
// typeID = sse.GetDefiningType().GlobalId;
// typeLineNo = sse.GetDefiningType().EntityLabel;
// }
string sseName = BIMRLUtils.checkSingleQuote(sse.Name);
string sseDescription = BIMRLUtils.checkSingleQuote(sse.Description);
string sseObjectType = BIMRLUtils.checkSingleQuote(sse.ObjectType);
string sseLongName = BIMRLUtils.checkSingleQuote(sse.LongName);
IIfcRelAggregates relContainer = sse.Decomposes.FirstOrDefault();
if (relContainer == null)
{
container = string.Empty;
}
else
{
container = relContainer.RelatingObject.GlobalId.ToString();
}
// Keep a mapping between IFC guid used as a key in BIMRL and the IFC line no of the entity
_refBIMRLCommon.guidLineNoMappingAdd(BIMRLProcessModel.currModelID, IfcLineNo, guid);
SqlStmt = "Insert into " + DBOperation.formatTabName("BIMRL_Element") + "(Elementid, LineNo, ElementType, ModelID, Name, LongName, Description, ObjectType, Container, TypeID) Values ('"
+ guid + "'," + IfcLineNo + ", '" + elementtype + "', " + BIMRLProcessModel.currModelID.ToString() + ", '" + sseName + "', '" + sseLongName + "','" + sseDescription + "', '" + sseObjectType
+ "', '" + container + "', '" + typeID + "')";
// status = DBOperation.insertRow(SqlStmt);
command.CommandText = SqlStmt;
currStep = SqlStmt;
commandStatus = command.ExecuteNonQuery();
// Add intormation of the product label (LineNo into a List for the use later to update the Geometry
_refBIMRLCommon.insEntityLabelListAdd(Math.Abs(IfcLineNo));
currInsertCount++;
if (currInsertCount % DBOperation.commitInterval == 0)
{
//Do commit at interval but keep the long transaction (reopen)
DBOperation.commitTransaction();
}
}
}
catch (OracleException e)
{
string excStr = "%%Error - " + e.Message + "\n\t" + currStep;
_refBIMRLCommon.StackPushError(excStr);
command.Dispose();
throw;
}
DBOperation.commitTransaction();
command.Dispose();
}
