//UPDATE POINT3D SET 'X' =1, 'Y' = 2, 'Z' = 3 WHERE ID = 3;
public static void Update(SQLiteCommand command, Point3dModel model)
{
List <List <object> > itemList = new List <List <object> >
{
new List <object> {
DBPoint3DName.X, DBPoint3D_AT.x, model.X
},
new List <object> {
DBPoint3DName.Y, DBPoint3D_AT.y, model.Y
},
new List <object> {
DBPoint3DName.Z, DBPoint3D_AT.z, model.Z
}
};
Dictionary <string, string> variable = new Dictionary <string, string>();
Dictionary <string, object> paraDict = new Dictionary <string, object>();
Dictionary <string, string> conDict = new Dictionary <string, string> {
{ DBPoint3DName.ID, DBPoint3D_AT.id }
};
foreach (List <object> item in itemList)
{
variable.Add((string)item[0], (string)item[1]);
paraDict.Add((string)item[1], item[2]);
}
;
paraDict.Add(DBPoint3D_AT.id, model.ID);
DBCommand.UpdateRow(DBPoint3DName.tableName, variable, conDict, paraDict, command);
}
protected virtual void CopyModel(BlockModelBase model)
{
ID = model.ID;
handle = model.handle;
position = model.position;
matrixTransform = model.matrixTransform;
file = model.file;
}
public Point3dModel GetColdWaterTip()
{
if (fuS.HasSingleStud() && fuS.HasColdStud())
{
Point3dModel point = new Point3dModel(0, 1 + D1, 0);
return(matrixTransform.Transform(A1, point));
}
return(null);
}
public Point3dModel GetDoubleDrainTip()
{
if (fuS.HasDoubleDrainButNotAtOrigin())
{
Point3dModel tipPoint = new Point3dModel(R1.X, R1.Y + Y2, R1.Z);
return(matrixTransform.Transform(A3, R1, tipPoint));
}
return(null);
}
public static long UpdateRow(Point3dModel model, SQLiteConnection connection)
{
using (SQLiteCommand command = connection.CreateCommand())
{
DBPoint3DCommands.Update(command, model);
int check = command.ExecuteNonQuery();
return(check);
}
}
private static FixtureDetailsModel GetFixture(SQLiteDataReader reader, SQLiteConnection connection)
{
FixtureDetailsModel model;
long POSITION_ID = (long)reader[DBFixtureDetailsNames.POSITION_ID];
long TRANSFORM_ID = (long)reader[DBFixtureDetailsNames.MATRIX_ID];
string HANDLE = (string)reader[DBFixtureDetailsNames.HANDLE];
double INDEX = (double)reader[DBFixtureDetailsNames.INDEXX];
string FIXTURE_NAME = (string)reader[DBFixtureDetailsNames.FIXTURE_NAME];
string TAG = (string)reader[DBFixtureDetailsNames.TAG];
string NUMBER = (string)reader[DBFixtureDetailsNames.NUMBER];
double CW_DIA = (double)reader[DBFixtureDetailsNames.CW_DIA];
double HW_DIA = (double)reader[DBFixtureDetailsNames.HW_DIA];
double WASTE_DIA = (double)reader[DBFixtureDetailsNames.WASTE_DIA];
double VENT_DIA = (double)reader[DBFixtureDetailsNames.VENT_DIA];
double STORM_DIA = (double)reader[DBFixtureDetailsNames.STORM_DIA];
double WSFU = (double)reader[DBFixtureDetailsNames.WSFU];
double CWSFU = (double)reader[DBFixtureDetailsNames.CWSFU];
double HWSFU = (double)reader[DBFixtureDetailsNames.HWSFU];
double DFU = (double)reader[DBFixtureDetailsNames.DFU];
string DESCRIPTION = (string)reader[DBFixtureDetailsNames.DESCRIPTION];
long ID = (long)reader[DBFixtureDetailsNames.ID];
long FILE_ID = (long)reader[DBFixtureDetailsNames.FILE_ID];
Matrix3dModel matrix = DBMatrix3d.SelectRow(connection, TRANSFORM_ID);
Point3dModel position = DBPoint3D.SelectRow(connection, POSITION_ID);
DwgFileModel file = DBDwgFile.SelectRow(connection, FILE_ID);
model = new FixtureDetailsModel();
model.position = position;
model.matrixTransform = matrix;
model.handle = HANDLE;
model.INDEX = INDEX;
model.FIXTURENAME = FIXTURE_NAME;
model.TAG = TAG;
model.NUMBER = NUMBER;
model.CW_DIA = CW_DIA;
model.HW_DIA = HW_DIA;
model.WASTE_DIA = WASTE_DIA;
model.VENT_DIA = VENT_DIA;
model.STORM_DIA = STORM_DIA;
model.WSFU = WSFU;
model.CWSFU = CWSFU;
model.HWSFU = HWSFU;
model.DFU = DFU;
model.DESCRIPTION = DESCRIPTION;
model.ID = ID;
model.file = file;
return(model);
}
/// <summary>
/// Return a list of points, the first one is hotWaterTipPoint, the second one is coldWaterTipPoint
/// </summary>
/// <returns></returns>
public List <Point3dModel> GetHotColdTip()
{
if (fuS.HasHotColdStud())
{
Point3dModel hotPoint = new Point3dModel(-5, 1 + D1, 0);
Point3dModel coldPoint = new Point3dModel(5, 1 + D1, 0);
return(new List <Point3dModel> {
matrixTransform.Transform(A1, hotPoint),
matrixTransform.Transform(A2, coldPoint)
});
}
return(null);
}
private static InsertPointModel GetModel(SQLiteDataReader reader, SQLiteConnection connection)
{
string alias = (string)reader[DBInsertPointName.ALIAS];
string name = (string)reader[DBInsertPointName.ANAME];
long ID = (long)reader[DBInsertPointName.ID];
Point3dModel pos = DBPoint3D.SelectRow(connection, (long)reader[DBInsertPointName.POSITION_ID]);
string handle1 = (string)reader[DBInsertPointName.HANDLE];
DwgFileModel file = DBDwgFile.SelectRow(connection, (long)reader[DBInsertPointName.FILE_ID]);
Matrix3dModel matrix = DBMatrix3d.SelectRow(connection, (long)reader[DBInsertPointName.MATRIX_ID]);
InsertPointModel model = new InsertPointModel(alias, name, ID, file, handle1, pos, matrix);
return(model);
}
public static void Insert(SQLiteCommand command, Point3dModel model)
{
//"INSERT INTO POINT3D ('X', 'Y', 'Z') VALUES (034.34, 233, 0);"
List <string> variables = new List <string> {
DBPoint3DName.X, DBPoint3DName.Y, DBPoint3DName.Z
};
Dictionary <string, object> paraDict = new Dictionary <string, object> {
{ DBPoint3D_AT.x, model.X },
{ DBPoint3D_AT.y, model.Y },
{ DBPoint3D_AT.z, model.Z }
};
DBCommand.InsertCommand(DBPoint3DName.tableName, variables, paraDict, command);
}
/// <summary>
/// Insert a point to Table, return id the row inserted.
/// After inserting, ID will be added to model
/// </summary>
/// <param name="point"></param>
/// <param name="connection"></param>
/// <returns></returns>
public static long InsertRow(ref Point3dModel model, SQLiteConnection connection)
{
using (SQLiteCommand command = connection.CreateCommand())
{
DBPoint3DCommands.Insert(command, model);
int check = command.ExecuteNonQuery();
if (check == 1)
{
model.ID = connection.LastInsertRowId;
return(model.ID);
}
else if (check == 0)
{
throw new Exception("DBPoint3dCommands -> Insert -> No Point Was Inserted");
}
throw new Exception("DBPoint3D -> Insert -> Insert Point not successful.");
}
}
