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 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 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 string userId()
{
GxConnection gxconn = _ds.Connection as GxConnection;
if (gxconn != null && !String.IsNullOrEmpty(gxconn.InternalUserId))
{
return(gxconn.InternalUserId);
}
else
{
GXLogging.Debug(log, "UserId method");
string stmt = ((GxDataRecord)_ds.Db).GetServerUserIdStmt();
if (string.IsNullOrEmpty(stmt))
{
return(string.Empty);
}
else
{
GxCommand cmd = new GxCommand(_ds.Db, stmt, _ds, 0, false, true, _errorHandler);
cmd.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
IDataReader reader;
cmd.FetchData(out reader);
string s = string.Empty;
if (reader != null)
{
s = reader.GetString(0);
reader.Close();
}
return(s);
}
}
}
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 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 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 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 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 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 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 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 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 DateTime serverNowIn(bool hasMilliseconds)
{
string stmt = "";
if (hasMilliseconds)
{
stmt = ((GxDataRecord)_ds.Db).GetServerDateTimeStmtMs(_ds.Connection);
}
else
{
stmt = ((GxDataRecord)_ds.Db).GetServerDateTimeStmt(_ds.Connection);
}
if (string.IsNullOrEmpty(stmt))
{
if (hasMilliseconds)
{
return(DateTimeUtil.ResetMicroseconds(DateTime.Now));
}
else
{
return(DateTimeUtil.ResetMilliseconds(DateTime.Now));
}
}
else
{
GxCommand cmd = new GxCommand(_ds.Db, stmt, _ds, 0, false, true, _errorHandler);
cmd.ErrorMask = GxErrorMask.GX_NOMASK | GxErrorMask.GX_MASKLOOPLOCK;
IDataReader reader;
cmd.FetchData(out reader);
DateTime d = DateTimeUtil.NullDate();
if (reader != null)
{
d = reader.GetDateTime(0);
if (hasMilliseconds)
{
d = DateTimeUtil.ResetMicroseconds(d);
}
else
{
d = DateTimeUtil.ResetMilliseconds(d);
}
reader.Close();
}
return(d);
}
}
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();
}
}
public void createCursor(IGxDataStore ds, GxErrorHandler errorHandler)
{
if (_state >= 2)
{
return;
}
_stmt = (_staticParameters == null)? _stmt : String.Format(_stmt, _staticParameters);
_gxDbCommand = new GxCommand(ds.Db, _stmt, _updatable, ds, "", _name, TTL, hasNested, isForFirst, errorHandler, _batchSize);
_gxDbCommand.IsCursor = true;
if (_blockSize > 0)
{
_gxDbCommand.FetchSize = Convert.ToUInt16(_blockSize);
}
bindParms(_parmBinds);
_fldGetter = new GXFatFieldGetter(_gxDbCommand);
_fldSetter = new GXFatFieldSetter(_gxDbCommand);
_state = 2;
_gxDbCommand.ErrorMask = _errMask;
}
private void commitDataStore(IGxDataStore ds, String auditObjectName)
{
GXLogging.Debug(log, "DataStoreProvider commit auditObjectName:" + auditObjectName);
GxCommand cmd = new GxCommand(ds.Db, "commit", ds, 0, false, true, _errorHandler);
cmd.ErrorMask = GxErrorMask.GX_NOMASK;
try
{
ds.Commit();
}
catch (Exception dbEx)
{
//If commit fails it should not retry, it makes no sense because it will no longer be possible. just close the existing connection.
int status = 0;
GxADODataException e = new GxADODataException(dbEx);
bool retry = false;
int retryCount = 0;
bool pe = ds.Connection.DataRecord.ProcessError(e.DBMSErrorCode, e.ErrorInfo, cmd.ErrorMask, ds.Connection, ref status, ref retry, retryCount);
GXLogging.Error(log, "Commit Transaction Error", e);
retryCount++;
cmd.processErrorHandler(status, e.DBMSErrorCode, e.SqlState, e.ErrorInfo, cmd.ErrorMask, "FETCH", ref pe, ref retry);
if (!pe)
{
try
{
ds.Connection.Close();
if (retry)
{
ds.Connection.Open();
}
}
catch (Exception ex)
{
GXLogging.Error(log, "beginTransaction in commit transaction failed", ex);
throw (new GxADODataException(e.ToString(), e));
}
}
}
cmd.Dispose();
}
private void rollbackDataStore(IGxDataStore ds, String auditObjectName)
{
GxCommand cmd = new GxCommand(ds.Db, "rollback", ds, 0, false, true, _errorHandler);
cmd.ErrorMask = GxErrorMask.GX_NOMASK;
try
{
ds.Rollback();
}
catch (Exception dbEx)
{
int status = 0;
GxADODataException e = new GxADODataException(dbEx);
bool retry = false;
int retryCount = 0;
bool pe = ds.Connection.DataRecord.ProcessError(e.DBMSErrorCode, e.ErrorInfo, cmd.ErrorMask, ds.Connection, ref status, ref retry, retryCount);
GXLogging.Error(log, "Rollback Transaction Error", e);
retryCount++;
cmd.processErrorHandler(status, e.DBMSErrorCode, e.SqlState, e.ErrorInfo, cmd.ErrorMask, "FETCH", ref pe, ref retry);
if (!pe)
{
try
{
ds.Connection.Close();
if (retry)
{
ds.Connection.Open();
}
}
catch (Exception ex)
{
GXLogging.Error(log, "beginTransaction in Rollback transaction failed", ex);
throw (new GxADODataException(e.ToString(), e));
}
}
}
cmd.Dispose();
}
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 GXFatFieldSetter(GxCommand gxDbCommand)
{
_gxDbCommand = gxDbCommand;
}
public GXFatErrorFieldGetter(GxCommand gxDbCommand)
{
_gxDbCommand = gxDbCommand;
}
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 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();
}
}
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);
}
}
}
