public static void InsertSub(SFieldsItems v, SQLITE_DAL dalsession)
{
string q = " INSERT INTO " + SFIELDSITEMS.SFIELDSITEMS_TBL + " ( ";
//q += " " + SFIELDSITEMS.SFIELDS_ID + " \r\n ";
q += "" + SFIELDSITEMS.STABLES_ID + " \r\n ";
q += "," + SFIELDSITEMS.FIELDSNAME + " \r\n ";
q += "," + SFIELDSITEMS.DISPLAY_NAME + " \r\n ";
q += "," + SFIELDSITEMS.DATATYPE + " \r\n ";
//q += "," + SFIELDSITEMS.LENGTHS + " \r\n ";
//q += "," + SFIELDSITEMS.PKEYS + " \r\n ";
//q += "," + SFIELDSITEMS.IFNULL + " \r\n ";
//q += "," + SFIELDSITEMS.REFEREDTBL + " \r\n ";
q += "," + SFIELDSITEMS.INPUTTYPE + " \r\n ";
q += "," + SFIELDSITEMS.WIDTH + " \r\n ";
q += " ) VALUES ( ";
//q += " @" + SFIELDSITEMS.SFIELDS_ID + "@ \r\n ";
q += " @" + SFIELDSITEMS.STABLES_ID + "@ \r\n ";
q += ", @" + SFIELDSITEMS.FIELDSNAME + "@ \r\n ";
q += ", @" + SFIELDSITEMS.DISPLAY_NAME + "@ \r\n ";
q += ", @" + SFIELDSITEMS.DATATYPE + "@ \r\n ";
//q += ", @" + SFIELDSITEMS.LENGTHS + "@ \r\n ";
//q += ", @" + SFIELDSITEMS.PKEYS + "@ \r\n ";
//q += ", @" + SFIELDSITEMS.IFNULL + "@ \r\n ";
//q += ", @" + SFIELDSITEMS.REFEREDTBL + "@ \r\n ";
q += ", @" + SFIELDSITEMS.INPUTTYPE + "@ \r\n ";
q += ", @" + SFIELDSITEMS.WIDTH + "@ \r\n ";
q += " ) \r\n ";
q = AttachParams(q, v);
dalsession.Execute(q);
}
public static void Insert(MasterTablePath v, SQLITE_DAL dalsession)
{
string q = " INSERT INTO " + MASTERPATH.MASTERPATH_TBL + " ( ";
q += " " + MASTERPATH.MASTERTABLES_ID + " \r\n ";
q += "," + MASTERPATH.ROOT_FOLDER + " \r\n ";
q += "," + MASTERPATH.CONTFOLDER + " \r\n ";
q += "," + MASTERPATH.CLASSFOLDER + " \r\n ";
q += "," + MASTERPATH.FORMFOLDER + " \r\n ";
q += "," + MASTERPATH.LISTFOLDER + " \r\n ";
q += "," + MASTERPATH.SETUPFOLDER + " \r\n ";
q += "," + MASTERPATH.TESTFOLDER + " \r\n ";
q += "," + MASTERPATH.ACTIVE_ID + " \r\n ";
q += " ) VALUES ( ";
q += " @" + MASTERPATH.MASTERTABLES_ID + "@ \r\n ";
q += ", @" + MASTERPATH.ROOT_FOLDER + "@ \r\n ";
q += ", @" + MASTERPATH.CONTFOLDER + "@ \r\n ";
q += ", @" + MASTERPATH.CLASSFOLDER + "@ \r\n ";
q += ", @" + MASTERPATH.FORMFOLDER + "@ \r\n ";
q += ", @" + MASTERPATH.LISTFOLDER + "@ \r\n ";
q += ", @" + MASTERPATH.SETUPFOLDER + "@ \r\n ";
q += ", @" + MASTERPATH.TESTFOLDER + "@ \r\n ";
q += ", @" + MASTERPATH.ACTIVE_ID + "@ \r\n ";
q += " ) \r\n ";
q = AttachParams(q, v);
dalsession.Execute(q);
}
public static void InsertSub(MasterTablesItems v, SQLITE_DAL dalsession)
{
string q = " INSERT INTO " + MASTERTABLESITEMS.MASTERTABLESITEMS_TBL + " ( ";
q += " " + MASTERTABLESITEMS.FIELDSNAME + " \r\n ";
q += "," + MASTERTABLESITEMS.MASTERTABLES_ID + " \r\n ";
q += "," + MASTERTABLESITEMS.DISPLAYNAME + " \r\n ";
q += "," + MASTERTABLESITEMS.DATATYPE + " \r\n ";
q += "," + MASTERTABLESITEMS.INPUTTYPE + " \r\n ";
q += "," + MASTERTABLESITEMS.WIDTH + " \r\n ";
q += "," + MASTERTABLESITEMS.HEIGHT + " \r\n ";
q += "," + MASTERTABLESITEMS.CPOSITION + " \r\n ";
q += "," + MASTERTABLESITEMS.RPOSITION + " \r\n ";
q += "," + MASTERTABLESITEMS.VALIDATE + " \r\n ";
q += "," + MASTERTABLESITEMS.ISDEFAULT + " \r\n ";
q += "," + MASTERTABLESITEMS.PLACEMENT + " \r\n ";
q += "," + MASTERTABLESITEMS.ALIGNTO + " \r\n ";
q += " ) VALUES ( ";
q += " @" + MASTERTABLESITEMS.FIELDSNAME + "@ \r\n ";
q += ", @" + MASTERTABLESITEMS.MASTERTABLES_ID + "@ \r\n ";
q += ", @" + MASTERTABLESITEMS.DISPLAYNAME + "@ \r\n ";
q += ", @" + MASTERTABLESITEMS.DATATYPE + "@ \r\n ";
q += ", @" + MASTERTABLESITEMS.INPUTTYPE + "@ \r\n ";
q += ", @" + MASTERTABLESITEMS.WIDTH + "@ \r\n ";
q += ", @" + MASTERTABLESITEMS.HEIGHT + "@ \r\n ";
q += ", @" + MASTERTABLESITEMS.CPOSITION + "@ \r\n ";
q += ", @" + MASTERTABLESITEMS.RPOSITION + "@ \r\n ";
q += ", @" + MASTERTABLESITEMS.VALIDATE + "@ \r\n ";
q += ", @" + MASTERTABLESITEMS.ISDEFAULT + "@ \r\n ";
q += ", @" + MASTERTABLESITEMS.PLACEMENT + "@ \r\n ";
q += ", @" + MASTERTABLESITEMS.ALIGNTO + "@ \r\n ";
q += " ) \r\n ";
q = AttachParams(q, v);
dalsession.Execute(q);
}
public static void Update(Namespaces v, SQLITE_DAL dalsession)
{
string q = "UPDATE " + NAMESPACES.NAMESPACES_TBL + " SET";
q += " " + NAMESPACES.NAMESPACES_NAME + " = @" + NAMESPACES.NAMESPACES_NAME + "@ \r\n ";
q += "," + NAMESPACES.NOTES + " = @" + NAMESPACES.NOTES + "@ \r\n ";
q += "," + NAMESPACES.ACTIVE_ID + " = @" + NAMESPACES.ACTIVE_ID + "@ \r\n ";
q += " WHERE " + NAMESPACES.NAMESPACES_ID + " = @" + NAMESPACES.NAMESPACES_ID + "@ ";
q = AttachParams(q, v);
dalsession.Execute(q);
}
public static void Update(Databases _Databases, SQLITE_DAL dalsession)
{
string q = "UPDATE " + DATABASES.DATABASES_TBL + " SET";
q += " " + DATABASES.DATABASES_NAME + " = @" + DATABASES.DATABASES_NAME + "@ \r\n ";
q += "," + DATABASES.NOTES + " = @" + DATABASES.NOTES + "@ \r\n ";
q += "," + DATABASES.ACTIVE_ID + " = @" + DATABASES.ACTIVE_ID + "@ \r\n ";
q += "," + DATABASES.USER_ID + " = @" + DATABASES.USER_ID + "@ \r\n ";
q += " WHERE " + DATABASES.DATABASES_ID + " = @" + DATABASES.DATABASES_ID + "@ ";
q = AttachParams(q, _Databases);
dalsession.Execute(q);
}
public static void Update(MasterTables v, SQLITE_DAL dalsession)
{
string q = "UPDATE " + MASTERTABLES.MASTERTABLES_TBL + " SET";
q += " " + MASTERTABLES.DATABASES_ID + " = @" + MASTERTABLES.DATABASES_ID + "@ \r\n ";
q += "," + MASTERTABLES.MASTERTABLES_NAME + " = @" + MASTERTABLES.MASTERTABLES_NAME + "@ \r\n ";
q += "," + MASTERTABLES.ALIAS + " = @" + MASTERTABLES.ALIAS + "@ \r\n ";
q += "," + MASTERTABLES.NAMESPACES_ID + " = @" + MASTERTABLES.NAMESPACES_ID + "@ \r\n ";
q += "," + MASTERTABLES.ACTIVE_ID + " = @" + MASTERTABLES.ACTIVE_ID + "@ \r\n ";
q += " WHERE " + MASTERTABLES.MASTERTABLES_ID + " = @" + MASTERTABLES.MASTERTABLES_ID + "@ ";
q = AttachParams(q, v);
dalsession.Execute(q);
}
public static void Update(Version v, SQLITE_DAL dalsession)
{
string q = "UPDATE " + VERSION.VERSION_TBL + " SET";
q += " " + VERSION.VERSION_NAME + " = @" + VERSION.VERSION_NAME + "@ \r\n ";
q += "," + VERSION.CREATED_ON + " = @" + VERSION.CREATED_ON + "@ \r\n ";
q += "," + VERSION.CHANGES + " = @" + VERSION.CHANGES + "@ \r\n ";
//q += "," + VERSION.NOTES + " = @" + VERSION.NOTES + "@ \r\n ";
//q += "," + VERSION.ACTIVE_ID + " = @" + VERSION.ACTIVE_ID + "@ \r\n ";
//q += "," + VERSION.USER_ID + " = @" + VERSION.USER_ID + "@ \r\n ";
q += " WHERE " + VERSION.VERSION_ID + " = @" + VERSION.VERSION_ID + "@ ";
q = AttachParams(q, v);
dalsession.Execute(q);
}
public static void Insert(Namespaces v, SQLITE_DAL dalsession)
{
string q = " INSERT INTO " + NAMESPACES.NAMESPACES_TBL + " ( ";
q += " " + NAMESPACES.NAMESPACES_NAME + " \r\n ";
q += "," + NAMESPACES.NOTES + " \r\n ";
q += "," + NAMESPACES.ACTIVE_ID + " \r\n ";
q += " ) VALUES ( ";
q += " @" + NAMESPACES.NAMESPACES_NAME + "@ \r\n ";
q += ", @" + NAMESPACES.NOTES + "@ \r\n ";
q += ", @" + NAMESPACES.ACTIVE_ID + "@ \r\n ";
q += " ) \r\n ";
q = AttachParams(q, v);
dalsession.Execute(q);
}
public static void Update(Servers _Servers, SQLITE_DAL dalsession)
{
string q = "UPDATE " + SERVERS.SERVERS_TBL + " SET";
q += " " + SERVERS.SERVERS_NAME + " = @" + SERVERS.SERVERS_NAME + "@ \r\n ";
q += "," + SERVERS.SERVERS_VERSION + " = @" + SERVERS.SERVERS_VERSION + "@ \r\n ";
q += "," + SERVERS.SERVERS_PATH + " = @" + SERVERS.SERVERS_PATH + "@ \r\n ";
q += "," + SERVERS.SERVERS_BACKUP_PATH + " = @" + SERVERS.SERVERS_BACKUP_PATH + "@ \r\n ";
q += "," + SERVERS.NOTES + " = @" + SERVERS.NOTES + "@ \r\n ";
q += "," + SERVERS.ACTIVE_ID + " = @" + SERVERS.ACTIVE_ID + "@ \r\n ";
q += "," + SERVERS.USER_ID + " = @" + SERVERS.USER_ID + "@ \r\n ";
q += " WHERE " + SERVERS.SERVERS_ID + " = @" + SERVERS.SERVERS_ID + "@ ";
q = AttachParams(q, _Servers);
dalsession.Execute(q);
}
public static void Update(MasterTablePath v, SQLITE_DAL dalsession)
{
string q = "UPDATE " + MASTERPATH.MASTERPATH_TBL + " SET";
q += " " + MASTERPATH.MASTERTABLES_ID + " = @" + MASTERPATH.MASTERTABLES_ID + "@ \r\n ";
q += "," + MASTERPATH.ROOT_FOLDER + " = @" + MASTERPATH.ROOT_FOLDER + "@ \r\n ";
q += "," + MASTERPATH.CONTFOLDER + " = @" + MASTERPATH.CONTFOLDER + "@ \r\n ";
q += "," + MASTERPATH.CLASSFOLDER + " = @" + MASTERPATH.CLASSFOLDER + "@ \r\n ";
q += "," + MASTERPATH.FORMFOLDER + " = @" + MASTERPATH.FORMFOLDER + "@ \r\n ";
q += "," + MASTERPATH.LISTFOLDER + " = @" + MASTERPATH.LISTFOLDER + "@ \r\n ";
q += "," + MASTERPATH.SETUPFOLDER + " = @" + MASTERPATH.SETUPFOLDER + "@ \r\n ";
q += "," + MASTERPATH.TESTFOLDER + " = @" + MASTERPATH.TESTFOLDER + "@ \r\n ";
q += "," + MASTERPATH.ACTIVE_ID + " = @" + MASTERPATH.ACTIVE_ID + "@ \r\n ";
q += " WHERE " + MASTERPATH.MASTERPATH_ID + " = @" + MASTERPATH.MASTERPATH_ID + "@ ";
q = AttachParams(q, v);
dalsession.Execute(q);
}
public static void Insert(Databases _Databases, SQLITE_DAL dalsession)
{
string q = " INSERT INTO " + DATABASES.DATABASES_TBL + " ( ";
q += " " + DATABASES.DATABASES_NAME + " \r\n ";
q += "," + DATABASES.NOTES + " \r\n ";
q += "," + DATABASES.ACTIVE_ID + " \r\n ";
q += "," + DATABASES.USER_ID + " \r\n ";
q += " ) VALUES ( ";
q += " @" + DATABASES.DATABASES_NAME + "@ \r\n ";
q += ", @" + DATABASES.NOTES + "@ \r\n ";
q += ", @" + DATABASES.ACTIVE_ID + "@ \r\n ";
q += ", @" + DATABASES.USER_ID + "@ \r\n ";
q += " ) \r\n ";
q = AttachParams(q, _Databases);
dalsession.Execute(q);
}
public static void Insert(MasterTables v, SQLITE_DAL dalsession)
{
string q = " INSERT INTO " + MASTERTABLES.MASTERTABLES_TBL + " ( ";
q += " " + MASTERTABLES.DATABASES_ID + " \r\n";
q += "," + MASTERTABLES.MASTERTABLES_NAME + " \r\n";
q += "," + MASTERTABLES.ALIAS + " \r\n";
q += "," + MASTERTABLES.NAMESPACES_ID + " \r\n";
q += "," + MASTERTABLES.ACTIVE_ID + " \r\n";
q += " ) VALUES ( ";
q += " @" + MASTERTABLES.DATABASES_ID + "@ \r\n";
q += ", @" + MASTERTABLES.MASTERTABLES_NAME + "@ \r\n";
q += ", @" + MASTERTABLES.ALIAS + "@ \r\n";
q += ", @" + MASTERTABLES.NAMESPACES_ID + "@ \r\n";
q += ", @" + MASTERTABLES.ACTIVE_ID + "@ \r\n";
q += " ) \r\n ";
q = AttachParams(q, v);
dalsession.Execute(q);
}
public static void Insert(Version v, SQLITE_DAL dalsession)
{
string q = " INSERT INTO " + VERSION.VERSION_TBL + " ( ";
q += " " + VERSION.VERSION_NAME + " \r\n ";
q += "," + VERSION.CREATED_ON + " \r\n ";
q += "," + VERSION.CHANGES + " \r\n ";
//q += "," + VERSION.NOTES + " \r\n ";
//q += "," + VERSION.ACTIVE_ID + " \r\n ";
//q += "," + VERSION.USER_ID + " \r\n ";
q += " ) VALUES ( ";
q += " @" + VERSION.VERSION_NAME + "@ \r\n ";
q += ", @" + VERSION.CREATED_ON + "@ \r\n ";
q += ", @" + VERSION.CHANGES + "@ \r\n ";
//q += ", @" + VERSION.NOTES + "@ \r\n ";
//q += ", @" + VERSION.ACTIVE_ID + "@ \r\n ";
//q += ", @" + VERSION.USER_ID + "@ \r\n ";
q += " ) \r\n ";
q = AttachParams(q, v);
dalsession.Execute(q);
}
public static void InsertSub(SFields v, SQLITE_DAL dalsession)
{
string q = " INSERT INTO " + SFIELDS.SFIELDS_TBL + " ( ";
//q += " " + SFIELDS.SFIELDS_ID + " \r\n ";
q += "" + SFIELDS.STABLES_ID + " \r\n ";
q += "," + SFIELDS.FIELDSNAME + " \r\n ";
q += "," + SFIELDS.DISPLAY_NAME + " \r\n ";
q += "," + SFIELDS.DATATYPE + " \r\n ";
q += "," + SFIELDS.INPUTTYPE + " \r\n ";
q += "," + SFIELDS.WIDTH + " \r\n ";
q += "," + SFIELDS.HEIGHT + " \r\n ";
q += "," + SFIELDS.CPOSITION + " \r\n ";
q += "," + SFIELDS.RPOSITION + " \r\n ";
q += "," + SFIELDS.ALIGNTO + " \r\n ";
q += "," + SFIELDS.VALIDATE + " \r\n ";
q += "," + SFIELDS.ISDEFAULT + " \r\n ";
q += "," + SFIELDS.PLACEMENT + " \r\n ";
q += "," + SFIELDS.READONLY + " \r\n ";
q += " ) VALUES ( ";
//q += " @" + SFIELDS.SFIELDS_ID + "@ \r\n ";
q += " @" + SFIELDS.STABLES_ID + "@ \r\n ";
q += ", @" + SFIELDS.FIELDSNAME + "@ \r\n ";
q += ", @" + SFIELDS.DISPLAY_NAME + "@ \r\n ";
q += ", @" + SFIELDS.DATATYPE + "@ \r\n ";
q += ", @" + SFIELDS.INPUTTYPE + "@ \r\n ";
q += ", @" + SFIELDS.WIDTH + "@ \r\n ";
q += ", @" + SFIELDS.HEIGHT + "@ \r\n ";
q += ", @" + SFIELDS.CPOSITION + "@ \r\n ";
q += ", @" + SFIELDS.RPOSITION + "@ \r\n ";
q += ", @" + SFIELDS.ALIGNTO + "@ \r\n ";
q += ", @" + SFIELDS.VALIDATE + "@ \r\n ";
q += ", @" + SFIELDS.ISDEFAULT + "@ \r\n ";
q += ", @" + SFIELDS.PLACEMENT + "@ \r\n ";
q += ", @" + SFIELDS.READONLY + "@ \r\n ";
q += " ) \r\n ";
q = AttachParams(q, v);
dalsession.Execute(q);
}
public static void Insert(Servers _Servers, SQLITE_DAL dalsession)
{
string q = " INSERT INTO " + SERVERS.SERVERS_TBL + " ( ";
q += " " + SERVERS.SERVERS_NAME + " \r\n ";
q += "," + SERVERS.SERVERS_VERSION + " \r\n ";
q += "," + SERVERS.SERVERS_PATH + " \r\n ";
q += "," + SERVERS.SERVERS_BACKUP_PATH + " \r\n ";
q += "," + SERVERS.NOTES + " \r\n ";
q += "," + SERVERS.ACTIVE_ID + " \r\n ";
q += "," + SERVERS.USER_ID + " \r\n ";
q += " ) VALUES ( ";
q += " @" + SERVERS.SERVERS_NAME + "@ \r\n ";
q += ", @" + SERVERS.SERVERS_VERSION + "@ \r\n ";
q += ", @" + SERVERS.SERVERS_PATH + "@ \r\n ";
q += ", @" + SERVERS.SERVERS_BACKUP_PATH + "@ \r\n ";
q += ", @" + SERVERS.NOTES + "@ \r\n ";
q += ", @" + SERVERS.ACTIVE_ID + "@ \r\n ";
q += ", @" + SERVERS.USER_ID + "@ \r\n ";
q += " ) \r\n ";
q = AttachParams(q, _Servers);
dalsession.Execute(q);
}
public static void Delete(string _Databases_id, SQLITE_DAL dalsession)
{
dalsession.Execute("DELETE FROM " + DATABASES.DATABASES_TBL + " WHERE " + DATABASES.DATABASES_ID + " = " + _Databases_id + ";");
}
public static void Delete(string _Servers_id, SQLITE_DAL dalsession)
{
dalsession.Execute("DELETE FROM " + SERVERS.SERVERS_TBL + " WHERE " + SERVERS.SERVERS_ID + " = " + _Servers_id + ";");
}
public static void Delete(string fkid, SQLITE_DAL dalsession)
{
dalsession.Execute("DELETE FROM " + SFIELDSITEMS.SFIELDSITEMS_TBL + " WHERE " + SFIELDSITEMS.STABLES_ID + " = " + fkid + ";");
}
public static void Delete(string pkid, SQLITE_DAL dalsession)
{
dalsession.Execute("DELETE FROM " + MASTERTABLES.MASTERTABLES_TBL + " WHERE " + MASTERTABLES.MASTERTABLES_ID + " = " + pkid + ";");
}
public static void Delete(string pkid, SQLITE_DAL dalsession)
{
dalsession.Execute("DELETE FROM " + VERSION.VERSION_TBL + " WHERE " + VERSION.VERSION_ID + " = " + pkid + ";");
}