public static void DeleteRow(SQLiteConnection connection, long ID)
{
FixtureDetailsModel model = SelectRow(connection, ID);
gBlock.DeleteRow(ID, connection);
DeleteOthers(model, connection);
}
public static void DeleteRow(SQLiteConnection connection, Dictionary <string, string> conDict, Dictionary <string, object> paraDict)
{
FixtureDetailsModel model = SelectRow(connection, conDict, paraDict);
gBlock.DeleteRow(conDict, paraDict, connection);
DeleteOthers(model, connection);
}
public static void DeleteRow(SQLiteConnection connection, string handle, string relPath)
{
FixtureDetailsModel model = SelectRow(connection, handle, relPath);
gBlock.DeleteRow(handle, relPath, connection);
DeleteOthers(model, connection);
}
public static void DeleteRow(SQLiteConnection connection, string handle, long fileID)
{
FixtureDetailsModel model = SelectRow(connection, handle, fileID);
gBlock.DeleteRow(handle, fileID, connection);
DeleteOthers(model, connection);
}
private static void DeleteOthers(FixtureDetailsModel model, SQLiteConnection connection)
{
if (model != null)
{
DBPoint3D.DeleteRow(connection, model.file.ID);
DBMatrix3d.DeleteRow(connection, model.matrixTransform.ID);
}
}
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);
}
public static void InsertRow(FixtureDetailsModel 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(DBFixtureDetailsNames.name, variables, paraDict, command);
}
public static long InsertRow(SQLiteConnection connection, ref FixtureDetailsModel model)
{
using (SQLiteCommand command = connection.CreateCommand())
{
DBFixtureDetailsCommands.InsertRow(model, command);
long check = command.ExecuteNonQuery();
if (check == 1)
{
model.ID = connection.LastInsertRowId;
return(model.ID);
}
else if (check == 0)
{
throw new Exception("DBFixtureDetails -> InsertRow -> No Row is Inserted.");
}
throw new Exception("DBFixtureDetails -> InsertRow -> Insert Not Successful.");
}
}
public static long UpdateRow(SQLiteConnection connection, FixtureDetailsModel model)
{
long index;
using (SQLiteCommand command = connection.CreateCommand())
{
DBFixtureDetailsCommands.UpdateRow(model, command);
long check = command.ExecuteNonQuery();
if (check == 1)
{
index = connection.LastInsertRowId;
return(index);
}
else if (check == 0)
{
//throw new Exception("DBFixtureDetails -> UpdateRow -> No Row is Updated.");
return(0);
}
throw new Exception("DBFixtureDetails -> UpdateRow -> Update Not Successful.");
}
}
public static void UpdateRow(FixtureDetailsModel model, SQLiteCommand command)
{
DBPoint3D.UpdateRow(model.position, command.Connection);
DBMatrix3d.Update(command.Connection, model.matrixTransform);
List <List <object> > items = getListItems(model);
Dictionary <string, string> variables = new Dictionary <string, string>();
Dictionary <string, string> conDict = new Dictionary <string, string> {
{ DBFixtureDetailsNames.ID, DBFixtureDetailsNames_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(DBFixtureDetailsNames_AT.id, model.ID);
DBCommand.UpdateRow(DBFixtureDetailsNames.name, variables, conDict, paraDict, command);
}
private static List <List <object> > getListItems(FixtureDetailsModel model)
{
List <List <object> > items = new List <List <object> > {
new List <object> {
DBFixtureDetailsNames.POSITION_ID, DBFixtureDetailsNames_AT.position, model.position.ID
},
new List <object> {
DBFixtureDetailsNames.MATRIX_ID, DBFixtureDetailsNames_AT.matrix, model.matrixTransform.ID
},
new List <object> {
DBFixtureDetailsNames.HANDLE, DBFixtureDetailsNames_AT.handle, model.handle
},
new List <object> {
DBFixtureDetailsNames.INDEXX, DBFixtureDetailsNames_AT.indexx, model.INDEX
},
new List <object> {
DBFixtureDetailsNames.FIXTURE_NAME, DBFixtureDetailsNames_AT.fixture, model.FIXTURENAME
},
new List <object> {
DBFixtureDetailsNames.TAG, DBFixtureDetailsNames_AT.tag, model.TAG
},
new List <object> {
DBFixtureDetailsNames.NUMBER, DBFixtureDetailsNames_AT.num, model.NUMBER
},
new List <object> {
DBFixtureDetailsNames.CW_DIA, DBFixtureDetailsNames_AT.cwD, model.CW_DIA
},
new List <object> {
DBFixtureDetailsNames.HW_DIA, DBFixtureDetailsNames_AT.hwD, model.HW_DIA
},
new List <object> {
DBFixtureDetailsNames.WASTE_DIA, DBFixtureDetailsNames_AT.wD, model.WASTE_DIA
},
new List <object> {
DBFixtureDetailsNames.VENT_DIA, DBFixtureDetailsNames_AT.vD, model.VENT_DIA
},
new List <object> {
DBFixtureDetailsNames.STORM_DIA, DBFixtureDetailsNames_AT.sD, model.STORM_DIA
},
new List <object> {
DBFixtureDetailsNames.WSFU, DBFixtureDetailsNames_AT.wsfu, model.WSFU
},
new List <object> {
DBFixtureDetailsNames.CWSFU, DBFixtureDetailsNames_AT.cwsfu, model.CWSFU
},
new List <object> {
DBFixtureDetailsNames.HWSFU, DBFixtureDetailsNames_AT.hwsfu, model.HWSFU
},
new List <object> {
DBFixtureDetailsNames.DFU, DBFixtureDetailsNames_AT.dfu, model.DFU
},
new List <object> {
DBFixtureDetailsNames.DESCRIPTION, DBFixtureDetailsNames_AT.desc, model.DESCRIPTION
},
new List <object> {
DBFixtureDetailsNames.FILE_ID, DBFixtureDetailsNames_AT.file, model.file.ID
}
};
return(items);
}
public FixtureDetails(FixtureDetailsModel model)
{
this.model = model;
}
