Пример #1
0
        /// <summary>This method builds the SQL statement to insert the instance in database</summary>
        /// <param name="instance">This parameter represents the instance to be inserted in the database</param>
        public override void UpdateAdded(ONInstance instance)
        {
            NaveNodrizaInstance lInstance = instance as NaveNodrizaInstance;

            ONSqlInsert lOnSql = new ONSqlInsert();

            lOnSql.AddInto(CtesBD.TBL_NAVENODRIZA);
            // Field 'id_NaveNodriza'
            lOnSql.AddValue(CtesBD.FLD_NAVENODRIZA_ID_NAVENODRIZA, lInstance.Oid.Id_NaveNodrizaAttr);
            lOnSql.AddValue(CtesBD.FLD_NAVENODRIZA_ESTADOOBJ, lInstance.StateObj);
            lOnSql.AddValue(CtesBD.FLD_NAVENODRIZA_FUM, new ONDateTime(DateTime.Now));
            // Field 'Nombre_NaveNodriza'
            lOnSql.AddValue(CtesBD.FLD_NAVENODRIZA_NOMBRE_NAVENODRIZA, lInstance.Nombre_NaveNodrizaAttr);
            Execute(lOnSql);
        }
Пример #2
0
        /// <summary>This method builds the SQL statement to insert the instance in database</summary>
        /// <param name="instance">This parameter represents the instance to be inserted in the database</param>
        public override void UpdateAdded(ONInstance instance)
        {
            AdministradorInstance lInstance = instance as AdministradorInstance;

            ONSqlInsert lOnSql = new ONSqlInsert();

            lOnSql.AddInto(CtesBD.TBL_ADMINISTRADOR);
            // Field 'id_Administrador'
            lOnSql.AddValue(CtesBD.FLD_ADMINISTRADOR_ID_ADMINISTRADOR, lInstance.Oid.Id_AdministradorAttr);
            // Field 'PassWord'
            lOnSql.AddValue(CtesBD.FLD_ADMINISTRADOR_PASSWORD, lInstance.PassWordAttr);
            lOnSql.AddValue(CtesBD.FLD_ADMINISTRADOR_ESTADOOBJ, lInstance.StateObj);
            lOnSql.AddValue(CtesBD.FLD_ADMINISTRADOR_FUM, new ONDateTime(DateTime.Now));
            Execute(lOnSql);
        }
Пример #3
0
        /// <summary>This method builds the SQL statement to insert the instance in database</summary>
        /// <param name="instance">This parameter represents the instance to be inserted in the database</param>
        public override void UpdateAdded(ONInstance instance)
        {
            PasajeroInstance lInstance = instance as PasajeroInstance;

            ONSqlInsert lOnSql = new ONSqlInsert();

            lOnSql.AddInto(CtesBD.TBL_PASAJERO);
            // Field 'id_Pasajero'
            lOnSql.AddValue(CtesBD.FLD_PASAJERO_ID_PASAJERO, lInstance.Oid.Id_PasajeroAttr);
            lOnSql.AddValue(CtesBD.FLD_PASAJERO_ESTADOOBJ, lInstance.StateObj);
            lOnSql.AddValue(CtesBD.FLD_PASAJERO_FUM, new ONDateTime(DateTime.Now));
            // Field 'Nombre'
            lOnSql.AddValue(CtesBD.FLD_PASAJERO_NOMBRE, lInstance.NombreAttr);
            Execute(lOnSql);
        }
Пример #4
0
        /// <summary>This method builds the SQL statement to insert the instance in database</summary>
        /// <param name="instance">This parameter represents the instance to be inserted in the database</param>
        public override void UpdateAdded(ONInstance instance)
        {
            RevisionInstance lInstance = instance as RevisionInstance;

            ONSqlInsert lOnSql = new ONSqlInsert();

            lOnSql.AddInto(CtesBD.TBL_REVISION);
            // Field 'id_RevisarAeronave'
            lOnSql.AddValue(CtesBD.FLD_REVISION_ID_REVISARAERONAVE, lInstance.Oid.Id_RevisarAeronaveAttr);
            lOnSql.AddValue(CtesBD.FLD_REVISION_ESTADOOBJ, lInstance.StateObj);
            lOnSql.AddValue(CtesBD.FLD_REVISION_FUM, new ONDateTime(DateTime.Now));
            // Field 'NombreRevisor'
            lOnSql.AddValue(CtesBD.FLD_REVISION_NOMBREREVISOR, lInstance.NombreRevisorAttr);
            // Field 'FechaRevision'
            lOnSql.AddValue(CtesBD.FLD_REVISION_FECHAREVISION, lInstance.FechaRevisionAttr);
            // Field 'Id_Aeronave'
            lOnSql.AddValue(CtesBD.FLD_REVISION_ID_AERONAVE, lInstance.Id_AeronaveAttr);
            Execute(lOnSql);
        }
Пример #5
0
        /// <summary>This method builds the SQL statement to insert the instance in database</summary>
        /// <param name="instance">This parameter represents the instance to be inserted in the database</param>
        public override void UpdateAdded(ONInstance instance)
        {
            AeronaveInstance lInstance = instance as AeronaveInstance;

            ONSqlInsert lOnSql = new ONSqlInsert();

            lOnSql.AddInto(CtesBD.TBL_AERONAVE);
            // Field 'id_Aeronave'
            lOnSql.AddValue(CtesBD.FLD_AERONAVE_ID_AERONAVE, lInstance.Oid.Id_AeronaveAttr);
            lOnSql.AddValue(CtesBD.FLD_AERONAVE_ESTADOOBJ, lInstance.StateObj);
            lOnSql.AddValue(CtesBD.FLD_AERONAVE_FUM, new ONDateTime(DateTime.Now));
            // Field 'Nombre'
            lOnSql.AddValue(CtesBD.FLD_AERONAVE_NOMBRE, lInstance.NombreAttr);
            // Field 'MaximoPasajeros'
            lOnSql.AddValue(CtesBD.FLD_AERONAVE_MAXIMOPASAJEROS, lInstance.MaximoPasajerosAttr);
            // Field 'Origen'
            lOnSql.AddValue(CtesBD.FLD_AERONAVE_ORIGEN, lInstance.OrigenAttr);
            // Field 'Destino'
            lOnSql.AddValue(CtesBD.FLD_AERONAVE_DESTINO, lInstance.DestinoAttr);
            Execute(lOnSql);
        }