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