public static void DeleteRow(SQLiteConnection connection, string handle, string relPath)
{
FixtureUnitModel model = SelectRow(connection, handle, relPath);
gBlock.DeleteRow(handle, relPath, connection);
DeleteOthers(model, connection);
}
public static void DeleteRow(SQLiteConnection connection, Dictionary <string, string> conDict, Dictionary <string, object> paraDict)
{
FixtureUnitModel model = SelectRow(connection, conDict, paraDict);
gBlock.DeleteRow(conDict, paraDict, connection);
DeleteOthers(model, connection);
}
public static void DeleteRow(SQLiteConnection connection, long ID)
{
FixtureUnitModel model = SelectRow(connection, ID);
gBlock.DeleteRow(ID, connection);
DeleteOthers(model, connection);
}
public static void DeleteRow(SQLiteConnection connection, string handle, long fileID)
{
FixtureUnitModel model = SelectRow(connection, handle, fileID);
gBlock.DeleteRow(handle, fileID, connection);
DeleteOthers(model, connection);
}
private static FixtureUnitModel getItem(SQLiteDataReader reader, SQLiteConnection connection)
{
FixtureUnitModel model = new FixtureUnitModel();
long POSITION_ID = (long)reader[DBFixtureUnitName.POSITION_ID];
long TRANSFORM_ID = (long)reader[DBFixtureUnitName.MATRIX_ID];
model.handle = (string)reader[DBFixtureUnitName.HANDLE];
model.INDEX = (double)reader[DBFixtureUnitName.INDEX];
model.TAG = (string)reader[DBFixtureUnitName.TAG];
model.NUMBER = (string)reader[DBFixtureUnitName.NUMBER];
model.CW_DIA = (double)reader[DBFixtureUnitName.CW_DIA];
model.HW_DIA = (double)reader[DBFixtureUnitName.HW_DIA];
model.WASTE_DIA = (double)reader[DBFixtureUnitName.WASTE_DIA];
model.VENT_DIA = (double)reader[DBFixtureUnitName.VENT_DIA];
model.STORM_DIA = (double)reader[DBFixtureUnitName.STORM_DIA];
model.WSFU = (double)reader[DBFixtureUnitName.WSFU];
model.CWSFU = (double)reader[DBFixtureUnitName.CWSFU];
model.HWSFU = (double)reader[DBFixtureUnitName.HWSFU];
model.DFU = (double)reader[DBFixtureUnitName.DFU];
model.ID = (long)reader[DBFixtureUnitName.ID];
long FILE_ID = (long)reader[DBFixtureUnitName.FILE_ID];
model.A2 = (double)reader[DBFixtureUnitName.A2];
model.Y2 = (double)reader[DBFixtureUnitName.Y2];
model.X2 = (double)reader[DBFixtureUnitName.X2];
model.X2_2 = (double)reader[DBFixtureUnitName.X2_2];
model.A3 = (double)reader[DBFixtureUnitName.A3];
model.A1 = (double)reader[DBFixtureUnitName.A1];
model.D1 = (double)reader[DBFixtureUnitName.D1];
long tagID = (long)reader[DBFixtureUnitName.tagPos];
long ventID = (long)reader[DBFixtureUnitName.ventPos];
long hotStubID = (long)reader[DBFixtureUnitName.hotStub];
long coldStubID = (long)reader[DBFixtureUnitName.coldStub];
long drainPosID = (long)reader[DBFixtureUnitName.drainPos];
long M_ID = (long)reader[DBFixtureUnitName.M_ID];
long R1_ID = (long)reader[DBFixtureUnitName.R1_ID];
long V_ID = (long)reader[DBFixtureUnitName.V_ID];
model.matrixTransform = DBMatrix3d.SelectRow(connection, TRANSFORM_ID);
model.position = DBPoint3D.SelectRow(connection, POSITION_ID);
model.file = DBDwgFile.SelectRow(connection, FILE_ID);
model.tagPos = DBPoint3D.SelectRow(connection, tagID);
model.ventPos = DBPoint3D.SelectRow(connection, ventID);
model.hotStub = DBPoint3D.SelectRow(connection, hotStubID);
model.coldStub = DBPoint3D.SelectRow(connection, coldStubID);
model.drainPos = DBPoint3D.SelectRow(connection, drainPosID);
model.M = DBPoint3D.SelectRow(connection, M_ID);
model.R1 = DBPoint3D.SelectRow(connection, R1_ID);
model.V = DBPoint3D.SelectRow(connection, V_ID);
return(model);
}
private static void DeleteOthers(FixtureUnitModel model, SQLiteConnection connection)
{
if (model != null)
{
DBPoint3D.DeleteRow(connection, model.file.ID);
DBMatrix3d.DeleteRow(connection, model.matrixTransform.ID);
if (model.matrixTransform != null)
{
DBMatrix3d.DeleteRow(connection, model.matrixTransform.ID);
}
;
if (model.position != null)
{
DBPoint3D.DeleteRow(connection, model.position.ID);
}
;
if (model.tagPos != null)
{
DBPoint3D.DeleteRow(connection, model.tagPos.ID);
}
;
if (model.ventPos != null)
{
DBPoint3D.DeleteRow(connection, model.ventPos.ID);
}
;
if (model.hotStub != null)
{
DBPoint3D.DeleteRow(connection, model.hotStub.ID);
}
;
if (model.coldStub != null)
{
DBPoint3D.DeleteRow(connection, model.coldStub.ID);
}
;
if (model.drainPos != null)
{
DBPoint3D.DeleteRow(connection, model.drainPos.ID);
}
;
if (model.R1 != null)
{
DBPoint3D.DeleteRow(connection, model.R1.ID);
}
if (model.V != null)
{
DBPoint3D.DeleteRow(connection, model.V.ID);
}
if (model.M != null)
{
DBPoint3D.DeleteRow(connection, model.M.ID);
}
}
}
public static long UpdateRow(SQLiteConnection connection, FixtureUnitModel model)
{
using (SQLiteCommand command = connection.CreateCommand())
{
DBFixtureUnitCommands.UpdateRow(model, command);
long check = command.ExecuteNonQuery();
return(check);
}
}
public static long InsertRow(SQLiteConnection connection, ref FixtureUnitModel model)
{
using (SQLiteCommand command = connection.CreateCommand())
{
DBFixtureUnitCommands.InsertRow(model, command);
long check = command.ExecuteNonQuery();
if (check == 1)
{
model.ID = connection.LastInsertRowId;
return(model.ID);
}
throw new Exception("DBFixture_Unit -> InserRow -> insertRowNotSuccessful.");
}
}
public static void InsertRow(FixtureUnitModel model, SQLiteCommand command)
{
List <List <object> > items = getListItems(model);
List <string> variables = new List <string>();
Dictionary <string, object> paraDict = new Dictionary <string, object>();
foreach (List <object> item in items)
{
variables.Add((string)item[0]);
paraDict.Add((string)item[1], item[2]);
}
DBCommand.InsertCommand(DBFixtureUnitName.name, variables, paraDict, command);
}
public static void UpdateRow(FixtureUnitModel model, SQLiteCommand command)
{
List <List <object> > items = getListItems(model);
Dictionary <string, string> variables = new Dictionary <string, string>();
Dictionary <string, string> conDict = new Dictionary <string, string> {
{ DBFixtureUnitName.ID, DBFixtureUnitName_AT.id }
};
Dictionary <string, object> paraDict = new Dictionary <string, object>();
foreach (List <object> item in items)
{
variables.Add((string)item[0], (string)item[1]);
paraDict.Add((string)item[1], item[2]);
}
paraDict.Add(DBFixtureUnitName_AT.id, model.ID);
DBCommand.UpdateRow(DBFixtureUnitName.name, variables, conDict, paraDict, command);
}
public FixtureUnit(BlockReference bRef, Transaction tr)
{
model = new FixtureUnitModel();
model.position = new Point3dModel(bRef.Position.ToArray());
model.matrixTransform = new Matrix3dModel(bRef.BlockTransform.ToArray());
model.blockName = Goodies.GetDynamicName(bRef);
model.fuS = FixtureUnitBlock.GetFixtureUnitStatus(model.blockName);
Point3d v, m, r1;
foreach (DynamicBlockReferenceProperty prop in bRef.DynamicBlockReferencePropertyCollection)
{
if (prop.PropertyName == FixtureUnitModelName.A1)
{
model.A1 = (double)prop.Value;
}
else if (prop.PropertyName == FixtureUnitModelName.A2)
{
model.A2 = (double)prop.Value;
}
else if (prop.PropertyName == FixtureUnitModelName.A3)
{
model.A3 = (double)prop.Value;
}
else if (prop.PropertyName == FixtureUnitModelName.D1)
{
model.D1 = (double)prop.Value;
}
else if (prop.PropertyName == FixtureUnitModelName.Y2)
{
model.Y2 = (double)prop.Value;
}
else if (prop.PropertyName == FixtureUnitModelName.X2)
{
model.X2 = (double)prop.Value;
}
else if (prop.PropertyName == FixtureUnitModelName.X2_2)
{
model.X2_2 = (double)prop.Value;
}
else if (prop.PropertyName == FixtureUnitModelName.V)
{
v = (Point3d)prop.Value;
model.V = new Point3dModel(v.X, v.Y, v.Z);
}
else if (prop.PropertyName == FixtureUnitModelName.M)
{
m = (Point3d)prop.Value;
model.M = new Point3dModel(m.X, m.Y, m.Z);
}
else if (prop.PropertyName == FixtureUnitModelName.R1)
{
r1 = (Point3d)prop.Value;
model.R1 = new Point3dModel(r1.X, r1.Y, r1.Z);
}
}
foreach (ObjectId id in bRef.AttributeCollection)
{
AttributeReference attRef = (AttributeReference)tr.GetObject(id, OpenMode.ForRead);
if (attRef.Tag == FixtureUnitModelName.CWSFU)
{
model.CWSFU = Convert.ToDouble(attRef.TextString);
}
else if (attRef.Tag == FixtureUnitModelName.WSFU)
{
model.WSFU = Convert.ToDouble(attRef.TextString);
}
else if (attRef.Tag == FixtureUnitModelName.HWSFU)
{
model.HWSFU = Convert.ToDouble(attRef.TextString);
}
else if (attRef.Tag == FixtureUnitModelName.VENT_DIA)
{
model.VENT_DIA = Convert.ToDouble(attRef.TextString);
}
else if (attRef.Tag == FixtureUnitModelName.WASTE_DIA)
{
model.WASTE_DIA = Convert.ToDouble(attRef.TextString);
}
else if (attRef.Tag == FixtureUnitModelName.STORM_DIA)
{
model.STORM_DIA = Convert.ToDouble(attRef.TextString);
}
else if (attRef.Tag == FixtureUnitModelName.DFU)
{
model.DFU = Convert.ToDouble(attRef.TextString);
}
else if (attRef.Tag == FixtureUnitModelName.HW_DIA)
{
model.HW_DIA = Convert.ToDouble(attRef.TextString);
}
else if (attRef.Tag == FixtureUnitModelName.CW_DIA)
{
model.CW_DIA = Convert.ToDouble(attRef.TextString);
}
else if (attRef.Tag == FixtureUnitModelName.INDEX)
{
model.INDEX = Convert.ToDouble(attRef.TextString);
}
else if (attRef.Tag == FixtureUnitModelName.TAG)
{
throw new Exception("Check This Out.");
}
}
}
private static List <List <object> > getListItems(FixtureUnitModel model)
{
List <List <object> > items = new List <List <object> > {
new List <object> {
DBFixtureUnitName.POSITION_ID, DBFixtureUnitName_AT.position, model.position.ID
},
new List <object> {
DBFixtureUnitName.MATRIX_ID, DBFixtureUnitName_AT.matrix, model.matrixTransform.ID
},
new List <object> {
DBFixtureUnitName.HANDLE, DBFixtureUnitName_AT.handle, model.handle
},
new List <object> {
DBFixtureUnitName.INDEX, DBFixtureUnitName_AT.indexx, model.INDEX
},
new List <object> {
DBFixtureUnitName.TAG, DBFixtureUnitName_AT.tag, model.TAG
},
new List <object> {
DBFixtureUnitName.NUMBER, DBFixtureUnitName_AT.num, model.NUMBER
},
new List <object> {
DBFixtureUnitName.CW_DIA, DBFixtureUnitName_AT.cwD, model.CW_DIA
},
new List <object> {
DBFixtureUnitName.HW_DIA, DBFixtureUnitName_AT.hwD, model.HW_DIA
},
new List <object> {
DBFixtureUnitName.WASTE_DIA, DBFixtureUnitName_AT.wD, model.WASTE_DIA
},
new List <object> {
DBFixtureUnitName.VENT_DIA, DBFixtureUnitName_AT.vD, model.VENT_DIA
},
new List <object> {
DBFixtureUnitName.STORM_DIA, DBFixtureUnitName_AT.sD, model.STORM_DIA
},
new List <object> {
DBFixtureUnitName.WSFU, DBFixtureUnitName_AT.wsfu, model.WSFU
},
new List <object> {
DBFixtureUnitName.CWSFU, DBFixtureUnitName_AT.cwsfu, model.CWSFU
},
new List <object> {
DBFixtureUnitName.HWSFU, DBFixtureUnitName_AT.hwsfu, model.HWSFU
},
new List <object> {
DBFixtureUnitName.DFU, DBFixtureUnitName_AT.dfu, model.DFU
},
new List <object> {
DBFixtureUnitName.FILE_ID, DBFixtureUnitName_AT.file, model.file.ID
},
new List <object> {
DBFixtureUnitName.tagPos, DBFixtureUnitName_AT.tagPos, model.tagPos.ID
},
new List <object> {
DBFixtureUnitName.ventPos, DBFixtureUnitName_AT.ventPos, model.ventPos.ID
},
new List <object> {
DBFixtureUnitName.hotStub, DBFixtureUnitName_AT.hotStub, model.hotStub.ID
},
new List <object> {
DBFixtureUnitName.coldStub, DBFixtureUnitName_AT.coldStub, model.coldStub.ID
},
new List <object> {
DBFixtureUnitName.drainPos, DBFixtureUnitName_AT.drainPos, model.drainPos.ID
},
new List <object> {
DBFixtureUnitName.R1_ID, DBFixtureUnitName_AT.R1, model.R1.ID
},
new List <object> {
DBFixtureUnitName.A2, DBFixtureUnitName_AT.A2, model.A2
},
new List <object> {
DBFixtureUnitName.Y2, DBFixtureUnitName_AT.Y2, model.Y2
},
new List <object> {
DBFixtureUnitName.X2, DBFixtureUnitName_AT.X2, model.X2
},
new List <object> {
DBFixtureUnitName.X2_2, DBFixtureUnitName_AT.X2_2, model.X2_2
},
new List <object> {
DBFixtureUnitName.A3, DBFixtureUnitName_AT.A3, model.A3
},
new List <object> {
DBFixtureUnitName.A1, DBFixtureUnitName_AT.A1, model.A1
},
new List <object> {
DBFixtureUnitName.D1, DBFixtureUnitName_AT.D1, model.D1
},
new List <object> {
DBFixtureUnitName.V_ID, DBFixtureUnitName_AT.V, model.V.ID
},
new List <object> {
DBFixtureUnitName.M_ID, DBFixtureUnitName_AT.M, model.M.ID
},
};
return(items);
}