public static void DeleteRow(SQLiteConnection connection, long ID)
{
FixtureBeingUsedAreaModel model = SelectRow(connection, ID);
gBlock.DeleteRow(ID, connection);
DeleteOthers(model, connection);
}
public static void DeleteRow(SQLiteConnection connection, string handle, long fileID)
{
FixtureBeingUsedAreaModel model = SelectRow(connection, handle, fileID);
gBlock.DeleteRow(handle, fileID, connection);
DeleteOthers(model, connection);
}
private static void DeleteOthers(FixtureBeingUsedAreaModel model, SQLiteConnection connection)
{
if (model != null)
{
DBPoint3D.DeleteRow(connection, model.file.ID);
DBMatrix3d.DeleteRow(connection, model.matrixTransform.ID);
if (model.position != null)
{
DBPoint3D.DeleteRow(connection, model.position.ID);
}
if (model.origin != null)
{
DBPoint3D.DeleteRow(connection, model.origin.ID);
}
if (model.pointTop != null)
{
DBPoint3D.DeleteRow(connection, model.pointTop.ID);
}
if (model.pointBottom != null)
{
DBPoint3D.DeleteRow(connection, model.pointBottom.ID);
}
if (model.matrixTransform != null)
{
DBMatrix3d.DeleteRow(connection, model.matrixTransform.ID);
}
}
}
private static List <List <object> > GetItems(FixtureBeingUsedAreaModel model)
{
List <List <object> > items = new List <List <object> > {
new List <object> {
DBFixtureBeingUsedAreaName.HANDLE, DBFixtureBeingUsedAreaName_AT.handle, model.handle
},
new List <object> {
DBFixtureBeingUsedAreaName.POSITION_ID, DBFixtureBeingUsedAreaName_AT.position, model.position.ID
},
new List <object> {
DBFixtureBeingUsedAreaName.X, DBFixtureBeingUsedAreaName_AT.x, model.X
},
new List <object> {
DBFixtureBeingUsedAreaName.Y, DBFixtureBeingUsedAreaName_AT.y, model.Y
},
new List <object> {
DBFixtureBeingUsedAreaName.ORIGIN_ID, DBFixtureBeingUsedAreaName_AT.origin, model.origin.ID
},
new List <object> {
DBFixtureBeingUsedAreaName.POINT_TOP_ID, DBFixtureBeingUsedAreaName_AT.top, model.pointTop.ID
},
new List <object> {
DBFixtureBeingUsedAreaName.POINT_BOTTOM_ID, DBFixtureBeingUsedAreaName_AT.bottom, model.pointBottom.ID
},
new List <object> {
DBFixtureBeingUsedAreaName.MATRIX_ID, DBFixtureBeingUsedAreaName_AT.matrix, model.matrixTransform.ID
},
new List <object> {
DBFixtureBeingUsedAreaName.FILE_ID, DBFixtureBeingUsedAreaName_AT.file, model.file.ID
},
};
return(items);
}
public static void DeleteRow(SQLiteConnection connection, Dictionary <string, string> conDict, Dictionary <string, object> paraDict)
{
FixtureBeingUsedAreaModel model = SelectRow(connection, conDict, paraDict);
gBlock.DeleteRow(conDict, paraDict, connection);
DeleteOthers(model, connection);
}
public static void DeleteRow(SQLiteConnection connection, string handle, string relPath)
{
FixtureBeingUsedAreaModel model = SelectRow(connection, handle, relPath);
gBlock.DeleteRow(handle, relPath, connection);
DeleteOthers(model, connection);
}
public static void InsertRow(FixtureBeingUsedAreaModel model, SQLiteCommand command)
{
List <List <object> > items = GetItems(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(DBFixtureBeingUsedAreaName.name, variables, paraDict, command);
}
public static long InsertRow(SQLiteConnection connection, ref FixtureBeingUsedAreaModel model)
{
using (SQLiteCommand command = connection.CreateCommand())
{
DBFixtureBeingUsedAreaCommands.InsertRow(model, command);
long check = command.ExecuteNonQuery();
if (check == 1)
{
model.ID = connection.LastInsertRowId;
return(model.ID);
}
else if (check == 0)
{
throw new Exception("DBFixtureBeingUsed -> insertRow -> No Row is inserted.");
}
throw new Exception("DBFixtureBeingUsed -> insertRow -> Row insertion not successful.");
}
}
public static long UpdateRow(SQLiteConnection connection, FixtureBeingUsedAreaModel model)
{
using (SQLiteCommand command = connection.CreateCommand())
{
DBFixtureBeingUsedAreaCommands.UpdateRow(command, model);
long check = command.ExecuteNonQuery();
if (check == 1)
{
model.ID = connection.LastInsertRowId;
return(model.ID);
}
else if (check == 0)
{
//throw new Exception("FixtureBeingUsedAreaModel -> UpdateRow -> No Row is Updated.");
}
throw new Exception("FixtureBeingUsedAreaModel -> UpdateRow -> Insert Not Successful.");
}
}
private void GetTopAndBottomPoint(BlockReference block)
{
model = new FixtureBeingUsedAreaModel();
model.handle = Goodies.ConvertHandleToString(block.Handle);
model.position = new Point3dModel(block.Position.ToArray());
model.matrixTransform = new Matrix3dModel(block.BlockTransform.ToArray());
DynamicBlockReferencePropertyCollection dynBlockPropCol = block.DynamicBlockReferencePropertyCollection;
foreach (DynamicBlockReferenceProperty dynProp in dynBlockPropCol)
{
if (dynProp.PropertyName.Equals(DBFixtureBeingUsedAreaName.X))
{
model.X = (double)dynProp.Value;
}
else if (dynProp.PropertyName.Equals(DBFixtureBeingUsedAreaName.Y))
{
model.Y = (double)dynProp.Value;
}
else if (dynProp.PropertyName.Equals("Origin"))
{
model.origin = new Point3dModel(((Point3d)dynProp.Value).ToArray());
}
}
Point3d pointTop = new Point3d(model.origin.X, model.origin.Y, 0);
//Use the regular X,Y coordinate, DO NOT use Game or Web coordinate
Point3d pointBottom = new Point3d(model.origin.X + model.X, model.origin.Y - model.Y, 0);
pointTop = pointTop.TransformBy(block.BlockTransform);
pointBottom = pointBottom.TransformBy(block.BlockTransform);
model.pointBottom = new Point3dModel(pointBottom.ToArray());
model.pointTop = new Point3dModel(pointTop.ToArray());
}
public static void UpdateRow(SQLiteCommand command, FixtureBeingUsedAreaModel model)
{
DBPoint3D.UpdateRow(model.pointTop, command.Connection);
DBPoint3D.UpdateRow(model.pointBottom, command.Connection);
DBPoint3D.UpdateRow(model.origin, command.Connection);
DBPoint3D.UpdateRow(model.position, command.Connection);
DBMatrix3d.Update(command.Connection, model.matrixTransform);
List <List <object> > items = GetItems(model);
Dictionary <string, string> variables = new Dictionary <string, string>();
Dictionary <string, string> conDict = new Dictionary <string, string> {
{ DBFixtureBeingUsedAreaName.ID, DBFixtureBeingUsedAreaName_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]);
}
DBCommand.UpdateRow(DBFixtureBeingUsedAreaName.name, variables, conDict, paraDict, command);
}
private static FixtureBeingUsedAreaModel GetModelFromReader(SQLiteDataReader reader, SQLiteConnection connection)
{
FixtureBeingUsedAreaModel model = new FixtureBeingUsedAreaModel();
model.ID = (long)reader[DBFixtureBeingUsedAreaName.ID];
model.handle = (string)reader[DBFixtureBeingUsedAreaName.HANDLE];
model.position = DBPoint3D.SelectRow(connection, (long)reader[DBFixtureBeingUsedAreaName.POSITION_ID]);
model.pointTop = DBPoint3D.SelectRow(connection, (long)reader[DBFixtureBeingUsedAreaName.POINT_TOP_ID]);
model.pointBottom = DBPoint3D.SelectRow(connection, (long)reader[DBFixtureBeingUsedAreaName.POINT_BOTTOM_ID]);
model.origin = DBPoint3D.SelectRow(connection, (long)reader[DBFixtureBeingUsedAreaName.ORIGIN_ID]);
model.matrixTransform = DBMatrix3d.SelectRow(connection, (long)reader[DBFixtureBeingUsedAreaName.MATRIX_ID]);
model.X = (double)reader[DBFixtureBeingUsedAreaName.X];
model.Y = (double)reader[DBFixtureBeingUsedAreaName.Y];
model.file = DBDwgFile.SelectRow(connection, (long)reader[DBFixtureBeingUsedAreaName.FILE_ID]);
if (model.ID == ConstantName.invalidNum)
{
model = null;
}
return(model);
}
public FixtureBeingUsedArea(FixtureBeingUsedAreaModel model)
{
this.model = model;
}
