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); } } }