public void CreateTanqueroEsclusas( )
{
String cmdBuffer;
/* Indices for table TanqueroEsclusas */
try
{
cmdBuffer = " CREATE TABLE [TanqueroEsclusas] ([TanqueroEsclusasID] smallint NOT NULL , [TanqueroEsclusasDesc] varchar(40) NOT NULL , PRIMARY KEY([TanqueroEsclusasID])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
DropTableConstraints("[TanqueroEsclusas]");
cmdBuffer = " DROP TABLE [TanqueroEsclusas] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " CREATE TABLE [TanqueroEsclusas] ([TanqueroEsclusasID] smallint NOT NULL , [TanqueroEsclusasDesc] varchar(40) NOT NULL , PRIMARY KEY([TanqueroEsclusasID])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void CreateQuimiqueros( )
{
String cmdBuffer;
/* Indices for table Quimiqueros */
try
{
cmdBuffer = " CREATE TABLE [Quimiqueros] ([QuimiquerosID] smallint NOT NULL IDENTITY(1,1), [QuimiquerosBandaCPSUAB] decimal( 10) NOT NULL , [QuimiquerosTarifaCargados] smallmoney NOT NULL , [QuimiquerosTarifaLastre] smallmoney NOT NULL , PRIMARY KEY([QuimiquerosID])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
DropTableConstraints("[Quimiqueros]");
cmdBuffer = " DROP TABLE [Quimiqueros] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " CREATE TABLE [Quimiqueros] ([QuimiquerosID] smallint NOT NULL IDENTITY(1,1), [QuimiquerosBandaCPSUAB] decimal( 10) NOT NULL , [QuimiquerosTarifaCargados] smallmoney NOT NULL , [QuimiquerosTarifaLastre] smallmoney NOT NULL , PRIMARY KEY([QuimiquerosID])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void CreateTanqueroEsclusasRango( )
{
String cmdBuffer;
/* Indices for table TanqueroEsclusasRango */
try
{
cmdBuffer = " CREATE TABLE [TanqueroEsclusasRango] ([TanqueroEsclusasID] smallint NOT NULL , [TanqueroRango] smallint NOT NULL , [TanqueroTarifaCPSUAB] smallmoney NOT NULL , [TanqueroBandaTM] decimal( 12) NOT NULL , [TanqueroTarifaTM] smallmoney NOT NULL , [TanqueroTarifaLastre] smallmoney NOT NULL , [TanqueroBandaCPSUAB] decimal( 10) NOT NULL , PRIMARY KEY([TanqueroEsclusasID], [TanqueroRango])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
DropTableConstraints("[TanqueroEsclusasRango]");
cmdBuffer = " DROP TABLE [TanqueroEsclusasRango] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " CREATE TABLE [TanqueroEsclusasRango] ([TanqueroEsclusasID] smallint NOT NULL , [TanqueroRango] smallint NOT NULL , [TanqueroTarifaCPSUAB] smallmoney NOT NULL , [TanqueroBandaTM] decimal( 12) NOT NULL , [TanqueroTarifaTM] smallmoney NOT NULL , [TanqueroTarifaLastre] smallmoney NOT NULL , [TanqueroBandaCPSUAB] decimal( 10) NOT NULL , PRIMARY KEY([TanqueroEsclusasID], [TanqueroRango])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void CreateVEH_RORO( )
{
String cmdBuffer;
/* Indices for table VEH_RORO */
try
{
cmdBuffer = " CREATE TABLE [VEH_RORO] ([VEH_RORO_ID] smallint NOT NULL IDENTITY(1,1), [VEH_RORO_TON_INI] money NOT NULL , [VEH_RORO_TON_FIN] money NOT NULL , [VEH_RORO_UTIL_INI] money NOT NULL , [VEH_RORO_UTIL_FIN] money NOT NULL , [VEH_RORO_TARIFA] money NOT NULL , PRIMARY KEY([VEH_RORO_ID])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
DropTableConstraints("[VEH_RORO]");
cmdBuffer = " DROP TABLE [VEH_RORO] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " CREATE TABLE [VEH_RORO] ([VEH_RORO_ID] smallint NOT NULL IDENTITY(1,1), [VEH_RORO_TON_INI] money NOT NULL , [VEH_RORO_TON_FIN] money NOT NULL , [VEH_RORO_UTIL_INI] money NOT NULL , [VEH_RORO_UTIL_FIN] money NOT NULL , [VEH_RORO_TARIFA] money NOT NULL , PRIMARY KEY([VEH_RORO_ID])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void CreateTarifasGranelesSecos( )
{
String cmdBuffer;
/* Indices for table TarifasGranelesSecos */
try
{
cmdBuffer = " CREATE TABLE [TarifasGranelesSecos] ([TarifasGranelesSecosCodPeaje] decimal( 10) NOT NULL IDENTITY(1,1), [TarifasGranelesSecosDescBandas] varchar(40) NOT NULL , [TarifasGranelesSecosBandas] decimal( 10) NOT NULL , [TarifasGranelesSecosTipoEsclus] varchar(40) NULL , [TarifasGranelesSecosTipoGranos] varchar(30) NOT NULL , [TarifasGranelesSecosTarifaS_DW] smallmoney NOT NULL , [TarifasGranelesSecosTarifaS_Ca] smallmoney NOT NULL , PRIMARY KEY([TarifasGranelesSecosCodPeaje])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
DropTableConstraints("[TarifasGranelesSecos]");
cmdBuffer = " DROP TABLE [TarifasGranelesSecos] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " CREATE TABLE [TarifasGranelesSecos] ([TarifasGranelesSecosCodPeaje] decimal( 10) NOT NULL IDENTITY(1,1), [TarifasGranelesSecosDescBandas] varchar(40) NOT NULL , [TarifasGranelesSecosBandas] decimal( 10) NOT NULL , [TarifasGranelesSecosTipoEsclus] varchar(40) NULL , [TarifasGranelesSecosTipoGranos] varchar(30) NOT NULL , [TarifasGranelesSecosTarifaS_DW] smallmoney NOT NULL , [TarifasGranelesSecosTarifaS_Ca] smallmoney NOT NULL , PRIMARY KEY([TarifasGranelesSecosCodPeaje])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void CreateREF_CGRAL_DESP( )
{
String cmdBuffer;
/* Indices for table REF_CGRAL_DESP */
try
{
cmdBuffer = " CREATE TABLE [REF_CGRAL_DESP] ([REF_CGRAL_DESP_ID] smallint NOT NULL IDENTITY(1,1), [REF_CGRAL_DESP_CARGA] varchar(150) NOT NULL , [REF_CGRAL_DESP_TIPO] varchar(50) NULL , [REF_CGRAL_DESP_ID_TON_TARIF] smallint NOT NULL , [REF_CGRAL_DESP_TON_TARIF] decimal( 10) NULL , [REF_CGRAL_DESP_TARIFA] money NOT NULL , [REF_CGRAL_DESP_COMENTARIO] varchar(250) NULL , PRIMARY KEY([REF_CGRAL_DESP_ID])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
DropTableConstraints("[REF_CGRAL_DESP]");
cmdBuffer = " DROP TABLE [REF_CGRAL_DESP] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " CREATE TABLE [REF_CGRAL_DESP] ([REF_CGRAL_DESP_ID] smallint NOT NULL IDENTITY(1,1), [REF_CGRAL_DESP_CARGA] varchar(150) NOT NULL , [REF_CGRAL_DESP_TIPO] varchar(50) NULL , [REF_CGRAL_DESP_ID_TON_TARIF] smallint NOT NULL , [REF_CGRAL_DESP_TON_TARIF] decimal( 10) NULL , [REF_CGRAL_DESP_TARIFA] money NOT NULL , [REF_CGRAL_DESP_COMENTARIO] varchar(250) NULL , PRIMARY KEY([REF_CGRAL_DESP_ID])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void RIPropiedadBarrio( )
{
String cmdBuffer;
try
{
cmdBuffer = " ALTER TABLE [Propiedad] ADD CONSTRAINT [IPROPIEDAD1] FOREIGN KEY ([BarrioId]) REFERENCES [Barrio] ([BarrioId]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
try
{
cmdBuffer = " ALTER TABLE [Propiedad] DROP CONSTRAINT [IPROPIEDAD1] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex1)
{
}
cmdBuffer = " ALTER TABLE [Propiedad] ADD CONSTRAINT [IPROPIEDAD1] FOREIGN KEY ([BarrioId]) REFERENCES [Barrio] ([BarrioId]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void RIPortaContenedoresRangoPortaContenedores( )
{
String cmdBuffer;
try
{
cmdBuffer = " ALTER TABLE [PortaContenedoresRango] ADD CONSTRAINT [IPORTACONTENEDORESRANGO1] FOREIGN KEY ([PortaContenedoresEsclusa]) REFERENCES [PortaContenedores] ([PortaContenedoresEsclusa]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
try
{
cmdBuffer = " ALTER TABLE [PortaContenedoresRango] DROP CONSTRAINT [IPORTACONTENEDORESRANGO1] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex1)
{
}
cmdBuffer = " ALTER TABLE [PortaContenedoresRango] ADD CONSTRAINT [IPORTACONTENEDORESRANGO1] FOREIGN KEY ([PortaContenedoresEsclusa]) REFERENCES [PortaContenedores] ([PortaContenedoresEsclusa]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void RIFacturaCliente( )
{
String cmdBuffer;
try
{
cmdBuffer = " ALTER TABLE [Factura] ADD CONSTRAINT [IFACTURA1] FOREIGN KEY ([ClienteId]) REFERENCES [Cliente] ([ClienteId]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
try
{
cmdBuffer = " ALTER TABLE [Factura] DROP CONSTRAINT [IFACTURA1] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex1)
{
}
cmdBuffer = " ALTER TABLE [Factura] ADD CONSTRAINT [IFACTURA1] FOREIGN KEY ([ClienteId]) REFERENCES [Cliente] ([ClienteId]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void RIVisitasVisitaProPropiedad( )
{
String cmdBuffer;
try
{
cmdBuffer = " ALTER TABLE [VisitasVisitaPro] ADD CONSTRAINT [IVISITASVISITAPRO1] FOREIGN KEY ([PropiedadId]) REFERENCES [Propiedad] ([PropiedadId]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
try
{
cmdBuffer = " ALTER TABLE [VisitasVisitaPro] DROP CONSTRAINT [IVISITASVISITAPRO1] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex1)
{
}
cmdBuffer = " ALTER TABLE [VisitasVisitaPro] ADD CONSTRAINT [IVISITASVISITAPRO1] FOREIGN KEY ([PropiedadId]) REFERENCES [Propiedad] ([PropiedadId]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void RIBR_FamilyhistoryBR_Encounter( )
{
String cmdBuffer;
try
{
cmdBuffer = " ALTER TABLE [BR_Familyhistory] ADD CONSTRAINT [IBR_FAMILYHISTORY1] FOREIGN KEY ([BR_EncounterID]) REFERENCES [BR_Encounter] ([BR_EncounterID]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
try
{
cmdBuffer = " ALTER TABLE [BR_Familyhistory] DROP CONSTRAINT [IBR_FAMILYHISTORY1] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex1)
{
}
cmdBuffer = " ALTER TABLE [BR_Familyhistory] ADD CONSTRAINT [IBR_FAMILYHISTORY1] FOREIGN KEY ([BR_EncounterID]) REFERENCES [BR_Encounter] ([BR_EncounterID]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void ReorganizePedido( )
{
String cmdBuffer = "";
/* Indices for table Pedido */
cmdBuffer = " ALTER TABLE [Pedido] ADD [PedidoDescontoFrete] money NOT NULL CONSTRAINT PedidoDescontoFretePedido_DEFAULT DEFAULT convert(int, 0), [PedidoTotal] money NOT NULL CONSTRAINT PedidoTotalPedido_DEFAULT DEFAULT convert(int, 0) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " ALTER TABLE [Pedido] DROP CONSTRAINT PedidoDescontoFretePedido_DEFAULT "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " UPDATE [Pedido] SET [PedidoTotal]=T.[PedidoTotal] FROM (SELECT T1.[PedidoId], COALESCE( T2.[PedidoTotal], 0) AS PedidoTotal FROM ([Pedido] T1 LEFT JOIN (SELECT COALESCE( T4.[GXC1], 0) AS PedidoTotal, T3.[PedidoId] FROM ([Pedido] T3 LEFT JOIN (SELECT SUM(T6.[ProdutoValor] * CAST(T5.[PedidoItemQtd] AS decimal( 22, 10))) AS GXC1, T5.[PedidoId] FROM ([PedidoItem] T5 INNER JOIN [Produto] T6 ON T6.[ProdutoId] = T5.[ProdutoId]) GROUP BY T5.[PedidoId] ) T4 ON T4.[PedidoId] = T3.[PedidoId]) ) T2 ON T2.[PedidoId] = T1.[PedidoId])) T WHERE [Pedido].PedidoId= T.PedidoId "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " ALTER TABLE [Pedido] DROP CONSTRAINT PedidoTotalPedido_DEFAULT "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
public void RITanqueroEsclusasRangoTanqueroEsclusas( )
{
String cmdBuffer;
try
{
cmdBuffer = " ALTER TABLE [TanqueroEsclusasRango] ADD CONSTRAINT [ITANQUEROESCLUSASRANGO1] FOREIGN KEY ([TanqueroEsclusasID]) REFERENCES [TanqueroEsclusas] ([TanqueroEsclusasID]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
try
{
cmdBuffer = " ALTER TABLE [TanqueroEsclusasRango] DROP CONSTRAINT [ITANQUEROESCLUSASRANGO1] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex1)
{
}
cmdBuffer = " ALTER TABLE [TanqueroEsclusasRango] ADD CONSTRAINT [ITANQUEROESCLUSASRANGO1] FOREIGN KEY ([TanqueroEsclusasID]) REFERENCES [TanqueroEsclusas] ([TanqueroEsclusasID]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void CreatePortaContenedoresRango( )
{
String cmdBuffer;
/* Indices for table PortaContenedoresRango */
try
{
cmdBuffer = " CREATE TABLE [PortaContenedoresRango] ([PortaContenedoresEsclusa] smallint NOT NULL , [PortaRango] smallint NOT NULL , [PortaRangoIniTEU] decimal( 12) NOT NULL , [PortaRangoFinTEU] decimal( 12) NOT NULL , [PortaTarifaTTA4] smallmoney NOT NULL , [PortaTarifaTEU4] smallmoney NOT NULL , [PortaTarifaTTA3] smallmoney NOT NULL , [PortaTarifaTEU3] smallmoney NOT NULL , [PortaTarifaTTA2] smallmoney NOT NULL , [PortaTarifaTEU2] smallmoney NOT NULL , [PortaTarifaTTA1] smallmoney NOT NULL , [PortaTarifaTEU1] smallmoney NOT NULL , PRIMARY KEY([PortaContenedoresEsclusa], [PortaRango])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
DropTableConstraints("[PortaContenedoresRango]");
cmdBuffer = " DROP TABLE [PortaContenedoresRango] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " CREATE TABLE [PortaContenedoresRango] ([PortaContenedoresEsclusa] smallint NOT NULL , [PortaRango] smallint NOT NULL , [PortaRangoIniTEU] decimal( 12) NOT NULL , [PortaRangoFinTEU] decimal( 12) NOT NULL , [PortaTarifaTTA4] smallmoney NOT NULL , [PortaTarifaTEU4] smallmoney NOT NULL , [PortaTarifaTTA3] smallmoney NOT NULL , [PortaTarifaTEU3] smallmoney NOT NULL , [PortaTarifaTTA2] smallmoney NOT NULL , [PortaTarifaTEU2] smallmoney NOT NULL , [PortaTarifaTTA1] smallmoney NOT NULL , [PortaTarifaTEU1] smallmoney NOT NULL , PRIMARY KEY([PortaContenedoresEsclusa], [PortaRango])) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void ReorganizeBR_Encounter( )
{
String cmdBuffer = "";
/* Indices for table BR_Encounter */
cmdBuffer = " ALTER TABLE [BR_Encounter] ADD [EncounterIDEncrypt] nvarchar(500) NULL "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
public void ExecBeforeReorg()
{
ArrayList stmts = ParseStmtFile(ReorgScriptType.Before);
IGxDataStore dsDefault = context.GetDataStore("Default");
foreach (string stmt in stmts)
{
AddMsg(GXResourceManager.GetMessage("GXM_executing", new object[] { stmt }), null);
GxCommand RGZ = new GxCommand(dsDefault.Db, stmt, dsDefault, 0, true, false, null);
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
public void ReorganizeCliente( )
{
String cmdBuffer;
/* Indices for table Cliente */
cmdBuffer = " ALTER TABLE [Cliente] ALTER COLUMN [ClienteDireccion] char(20) NOT NULL "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " ALTER TABLE [Cliente] ALTER COLUMN [ClienteNombre] char(20) NOT NULL "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
public void ReorganizeCustomer( )
{
String cmdBuffer;
/* Indices for table Customer */
cmdBuffer = " DROP INDEX [ICUSTOMER1] ON [Customer] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " ALTER TABLE [Customer] ALTER COLUMN [CountryId] int NULL "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
try
{
cmdBuffer = " CREATE NONCLUSTERED INDEX [ICUSTOMER1] ON [Customer] ([CountryId] ) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
cmdBuffer = " DROP INDEX [ICUSTOMER1] ON [Customer] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " CREATE NONCLUSTERED INDEX [ICUSTOMER1] ON [Customer] ([CountryId] ) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}
void executePrivate( )
{
/* GeneXus formulas */
/* Output device settings */
/* Optimized copy (Insert w/Subselect). */
cmdBuffer = " SET IDENTITY_INSERT [GXA0002] ON "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
/* Using cursor CUSTOMERCO2 */
pr_default.execute(0);
pr_default.close(0);
cmdBuffer = " SET IDENTITY_INSERT [GXA0002] OFF "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
/* End optimized group. */
this.cleanup();
}
public void DropTableConstraints(String sTableName)
{
String cmdBuffer;
/* Using cursor P00067 */
pr_default.execute(5, new Object[] { sTableName });
while ((pr_default.getStatus(5) != 101))
{
constid = P00067_Aconstid[0];
nconstid = P00067_nconstid[0];
fkeyid = P00067_Afkeyid[0];
nfkeyid = P00067_nfkeyid[0];
rkeyid = P00067_Arkeyid[0];
nrkeyid = P00067_nrkeyid[0];
cmdBuffer = "ALTER TABLE " + "[" + fkeyid + "] DROP CONSTRAINT " + constid;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
pr_default.readNext(5);
}
pr_default.close(5);
}
public void ReorganizeCliente( )
{
String cmdBuffer = "";
/* Indices for table Cliente */
try
{
cmdBuffer = " CREATE TABLE [GXA0004] ([ClienteId] smallint NOT NULL IDENTITY(1,1), [ClienteNombre] char(20) NOT NULL ) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
try
{
DropTableConstraints("[GXA0004]");
cmdBuffer = " DROP TABLE [GXA0004] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex1)
{
try
{
DropTableConstraints("[GXA0004]");
cmdBuffer = " DROP VIEW [GXA0004] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex2)
{
try
{
DropTableConstraints("[GXA0004]");
cmdBuffer = " DROP FUNCTION [GXA0004] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex3)
{
}
}
}
cmdBuffer = " CREATE TABLE [GXA0004] ([ClienteId] smallint NOT NULL IDENTITY(1,1), [ClienteNombre] char(20) NOT NULL ) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
cmdBuffer = " SET IDENTITY_INSERT [GXA0004] ON "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " INSERT INTO [GXA0004] ([ClienteId], [ClienteNombre]) SELECT [ClienteId], [ClienteNombre] FROM [Cliente] T1 "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " SET IDENTITY_INSERT [GXA0004] OFF "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
try
{
DropTableConstraints("[Cliente]");
cmdBuffer = " DROP TABLE [Cliente] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex1)
{
try
{
DropTableConstraints("[Cliente]");
cmdBuffer = " DROP VIEW [Cliente] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex2)
{
try
{
DropTableConstraints("[Cliente]");
cmdBuffer = " DROP FUNCTION [Cliente] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex3)
{
}
}
}
RGZ = new GxCommand(dsDefault.Db, "sp_rename", dsDefault, 0, true, false, null);
RGZ.CommandType = CommandType.StoredProcedure;
RGZ.AddParameter("@objname", "[GXA0004]");
RGZ.AddParameter("@newname", "Cliente");
RGZ.ExecuteStmt();
cmdBuffer = " ALTER TABLE [Cliente] ADD PRIMARY KEY([ClienteId]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
public void ReorganizeBR_Familyhistory( )
{
String cmdBuffer = "";
/* Indices for table BR_Familyhistory */
cmdBuffer = " ALTER TABLE [BR_Familyhistory] ADD [BR_EncounterID] decimal( 18) NOT NULL CONSTRAINT BR_EncounterIDBR_Familyhistory_DEFAULT DEFAULT convert(int, 0) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " UPDATE [BR_Familyhistory] SET [BR_EncounterID]=T.[BR_EncounterID] FROM (SELECT T1.[BR_FamilyhistoryID], T2.[BR_EncounterID] FROM ([BR_Familyhistory] T1 INNER JOIN [BR_EncounterReason] T2 ON T2.[BR_Encounter_ID] = T1.[BR_Encounter_ID])) T WHERE [BR_Familyhistory].BR_FamilyhistoryID= T.BR_FamilyhistoryID "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " ALTER TABLE [BR_Familyhistory] DROP CONSTRAINT BR_EncounterIDBR_Familyhistory_DEFAULT "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " DROP INDEX [IBR_FAMILYHISTORY1] ON [BR_Familyhistory] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
try
{
cmdBuffer = " CREATE NONCLUSTERED INDEX [IBR_FAMILYHISTORY1] ON [BR_Familyhistory] ([BR_EncounterID] ) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
cmdBuffer = " DROP INDEX [IBR_FAMILYHISTORY1] ON [BR_Familyhistory] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " CREATE NONCLUSTERED INDEX [IBR_FAMILYHISTORY1] ON [BR_Familyhistory] ([BR_EncounterID] ) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
cmdBuffer = " ALTER TABLE [BR_Familyhistory] DROP CONSTRAINT [IBR_FAMILYHISTORY1] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " ALTER TABLE [BR_Familyhistory] DROP COLUMN [BR_Encounter_ID] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
void executePrivate( )
{
/* GeneXus formulas */
/* Output device settings */
cmdBuffer = " SET IDENTITY_INSERT [GXA0004] ON "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
/* Using cursor INVOICECON2 */
pr_default.execute(0);
while ((pr_default.getStatus(0) != 101))
{
A1CountryId = INVOICECON2_A1CountryId[0];
n1CountryId = INVOICECON2_n1CountryId[0];
A3CustomerId = INVOICECON2_A3CustomerId[0];
A15InvoiceDate = INVOICECON2_A15InvoiceDate[0];
A14InvoiceId = INVOICECON2_A14InvoiceId[0];
A1CountryId = INVOICECON2_A1CountryId[0];
n1CountryId = INVOICECON2_n1CountryId[0];
/*
* INSERT RECORD ON TABLE GXA0004
*
*/
AV2InvoiceId = A14InvoiceId;
AV3InvoiceDate = A15InvoiceDate;
AV4CustomerId = A3CustomerId;
if (INVOICECON2_n1CountryId[0])
{
AV5InvoiceCountryId = 0;
}
else
{
AV5InvoiceCountryId = A1CountryId;
}
/* Using cursor INVOICECON3 */
pr_default.execute(1, new Object[] { AV2InvoiceId, AV3InvoiceDate, AV4CustomerId, AV5InvoiceCountryId });
pr_default.close(1);
if ((pr_default.getStatus(1) == 1))
{
context.Gx_err = 1;
Gx_emsg = (String)(GXResourceManager.GetMessage("GXM_noupdate"));
}
else
{
context.Gx_err = 0;
Gx_emsg = "";
}
/* End Insert */
pr_default.readNext(0);
}
pr_default.close(0);
cmdBuffer = " SET IDENTITY_INSERT [GXA0004] OFF "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
this.cleanup();
}
private void CreateDataBase( )
{
DS = (GxDataStore)(context.GetDataStore("Default"));
ErrCode = DS.Connection.FullConnect();
DataBaseName = DS.Connection.Database;
if (ErrCode != 0)
{
DS.Connection.Database = "";
ErrCode = DS.Connection.FullConnect();
if (ErrCode == 0)
{
try
{
GeneXus.Reorg.GXReorganization.AddMsg(GXResourceManager.GetMessage("GXM_dbcrea") + " " + DataBaseName, null);
cmdBuffer = "CREATE DATABASE " + "[" + DataBaseName + "]";
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
Count = 1;
}
catch (Exception ex)
{
ErrCode = 1;
GeneXus.Reorg.GXReorganization.AddMsg(ex.Message, null);
throw ex;
}
ErrCode = DS.Connection.Disconnect();
DS.Connection.Database = DataBaseName;
ErrCode = DS.Connection.FullConnect();
while ((ErrCode != 0) && (Count > 0) && (Count < 30))
{
Res = GXUtil.Sleep(1);
ErrCode = DS.Connection.FullConnect();
Count = (short)(Count + 1);
}
setupDB = 0;
if ((setupDB == 1) || GeneXus.Configuration.Preferences.MustSetupDB( ))
{
defaultUsers = GXUtil.DefaultWebUser(context);
short gxidx;
gxidx = 1;
while (gxidx <= defaultUsers.Count)
{
defaultUser = ((String)defaultUsers.Item(gxidx));
try
{
GeneXus.Reorg.GXReorganization.AddMsg(GXResourceManager.GetMessage("GXM_dbadduser", new object[] { defaultUser, DataBaseName }), null);
cmdBuffer = "CREATE LOGIN " + "[" + defaultUser + "]" + " FROM WINDOWS";
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
}
try
{
cmdBuffer = "CREATE USER " + "[" + defaultUser + "]" + " FOR LOGIN " + "[" + defaultUser + "]";
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
}
try
{
cmdBuffer = "EXEC sp_addrolemember N'db_datareader', N'" + defaultUser + "'";
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
}
try
{
cmdBuffer = "EXEC sp_addrolemember N'db_datawriter', N'" + defaultUser + "'";
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
}
gxidx = (short)(gxidx + 1);
}
}
}
if (ErrCode != 0)
{
ErrMsg = DS.ErrDescription;
GeneXus.Reorg.GXReorganization.AddMsg(ErrMsg, null);
ErrCode = 1;
throw new Exception(ErrMsg);
}
}
}
public void ReorganizePropiedad( )
{
String cmdBuffer = "";
/* Indices for table Propiedad */
try
{
cmdBuffer = " CREATE TABLE [GXA0002] ([PropiedadId] smallint NOT NULL , [PropiedadDescripcion] char(50) NOT NULL , [PropiedadFoto] VARBINARY(MAX) NOT NULL , [PropiedadFoto_GXI] varchar(2048) NOT NULL , [PropiedadDireccion] char(50) NOT NULL , [BarrioId] smallint NOT NULL ) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
try
{
DropTableConstraints("[GXA0002]");
cmdBuffer = " DROP TABLE [GXA0002] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex1)
{
try
{
DropTableConstraints("[GXA0002]");
cmdBuffer = " DROP VIEW [GXA0002] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex2)
{
try
{
DropTableConstraints("[GXA0002]");
cmdBuffer = " DROP FUNCTION [GXA0002] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex3)
{
}
}
}
cmdBuffer = " CREATE TABLE [GXA0002] ([PropiedadId] smallint NOT NULL , [PropiedadDescripcion] char(50) NOT NULL , [PropiedadFoto] VARBINARY(MAX) NOT NULL , [PropiedadFoto_GXI] varchar(2048) NOT NULL , [PropiedadDireccion] char(50) NOT NULL , [BarrioId] smallint NOT NULL ) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
new propiedadconversion(context).execute( );
try
{
DropTableConstraints("[Propiedad]");
cmdBuffer = " DROP TABLE [Propiedad] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex1)
{
try
{
DropTableConstraints("[Propiedad]");
cmdBuffer = " DROP VIEW [Propiedad] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex2)
{
try
{
DropTableConstraints("[Propiedad]");
cmdBuffer = " DROP FUNCTION [Propiedad] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception sqlex3)
{
}
}
}
RGZ = new GxCommand(dsDefault.Db, "sp_rename", dsDefault, 0, true, false, null);
RGZ.CommandType = CommandType.StoredProcedure;
RGZ.AddParameter("@objname", "[GXA0002]");
RGZ.AddParameter("@newname", "Propiedad");
RGZ.ExecuteStmt();
cmdBuffer = " ALTER TABLE [Propiedad] ADD PRIMARY KEY([PropiedadId]) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
try
{
cmdBuffer = " CREATE NONCLUSTERED INDEX [IPROPIEDAD1] ON [Propiedad] ([BarrioId] ) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
catch (Exception ex)
{
cmdBuffer = " DROP INDEX [IPROPIEDAD1] ON [Propiedad] "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_MASKNOTFOUND | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
cmdBuffer = " CREATE NONCLUSTERED INDEX [IPROPIEDAD1] ON [Propiedad] ([BarrioId] ) "
;
RGZ = new GxCommand(dsDefault.Db, cmdBuffer, dsDefault, 0, true, false, null);
RGZ.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
RGZ.ExecuteStmt();
RGZ.Drop();
}
}