Example #1
0
        public void EngadirAluguer(clsBD oBaseDatos)
        {
            string cadenaSQL = String.Format(@"insert into Aluguer(IdVehiculo,Apenom,DataAluguer,NDias) values 
                                             ({0},'{1}','{2}',{3})", this.IdVehiculo, this.ApeNom, this.DataAluguer, this.NDias);

            oBaseDatos.operacionsNonSelect(cadenaSQL);
        }
Example #2
0
        public void colocarMarcaAlugado(clsBD oBaseDatos)
        {
            string cadenaSQL = string.Format("Update vehiculos set Alugado='{0}' where IdVehiculo={1}", this.Alugado, this.IdVehiculo);

            oBaseDatos.operacionsNonSelect(cadenaSQL);
        }
Example #3
0
        public System.Data.DataSet leerVehiculos(clsBD oBaseDatos)
        {
            string cadenaSQL = "Select * from Vehiculos";

            return(oBaseDatos.operacionsSelect(cadenaSQL));
        }
Example #4
0
 public fDetalle(clsBD oBD, clsVehiculo oVehiculo)
 {
     InitializeComponent();
     this.oBaseDatos = oBD;
     this.oVehiculo  = oVehiculo;
 }
Example #5
0
        public void BorrarAluguer(clsBD oBaseDatos)
        {
            string cadenaSQL = String.Format("delete from aluguer where IdAluguer={0}", this.IdAluguer);

            oBaseDatos.operacionsNonSelect(cadenaSQL);
        }
Example #6
0
        public System.Data.DataSet LeerAluguer(clsBD oBaseDatos)
        {
            string cadenaSQL = string.Format("select * from aluguer where idVehiculo={0}", this.IdVehiculo);

            return(oBaseDatos.operacionsSelect(cadenaSQL));
        }