//Return all Dwgs relatives path, EXCEPT Note_Path file
public static HashSet <DwgFileModel> GetDwgsPath(SQLiteConnection sqlConn)
{
HashSet <DwgFileModel> dwgsSet = new HashSet <DwgFileModel>();
List <DwgFileModel> files = DBDwgFile.GetDwgFilesExceptPNote(sqlConn);
foreach (DwgFileModel file in files)
{
dwgsSet.Add(file);
}
return(dwgsSet);
}
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);
}
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 InitTable(string databasePath)
{
SQLiteConnection sqliteConn = new SQLiteConnection(DBCommand.GetConnectionString(databasePath));
try
{
sqliteConn.Open();
SQLiteTransaction sqliteTrans = sqliteConn.BeginTransaction();
DBMatrix3d.CreateTable(sqliteConn);
DBPoint3D.CreateTable(sqliteConn);
DBInsertPoint.CreateTable(sqliteConn);
DBFixtureDetails.CreateTable(sqliteConn);
DBFixtureBeingUsedArea.CreateTable(sqliteConn);
DBDwgFile.CreateTable(sqliteConn);
DBTable.CreateTable(sqliteConn);
DBFixture_Unit.CreateTable(sqliteConn);
DBAreaBorder.CreateTable(sqliteConn);
if (projectElement.P_NOTE != null)
{
projectElement.P_NOTE.WriteToDatabase(sqliteConn);
}
if (projectElement.Dwgs != null)
{
foreach (DwgFileModel model in projectElement.Dwgs)
{
model.WriteToDatabase(sqliteConn);
}
}
sqliteTrans.Commit();
sqliteTrans.Dispose();
sqliteConn.Close();
GC.Collect();
GC.WaitForPendingFinalizers();
}
catch (Exception e)
{
DebugMessage(string.Format(@"Error opening Database: {0}, Error:{1}", databasePath, e.Message));
}
}
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);
}
//SQL connection must be OPEN.
//This function should be put between transaction.
public static DwgFileModel GetNotePath(SQLiteConnection sqlConn)
{
DwgFileModel model = DBDwgFile.GetPNote(sqlConn);
return(model);
}
