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);
}
public void colocarMarcaAlugado(clsBD oBaseDatos)
{
string cadenaSQL = string.Format("Update vehiculos set Alugado='{0}' where IdVehiculo={1}", this.Alugado, this.IdVehiculo);
oBaseDatos.operacionsNonSelect(cadenaSQL);
}
public System.Data.DataSet leerVehiculos(clsBD oBaseDatos)
{
string cadenaSQL = "Select * from Vehiculos";
return(oBaseDatos.operacionsSelect(cadenaSQL));
}
public fDetalle(clsBD oBD, clsVehiculo oVehiculo)
{
InitializeComponent();
this.oBaseDatos = oBD;
this.oVehiculo = oVehiculo;
}
public void BorrarAluguer(clsBD oBaseDatos)
{
string cadenaSQL = String.Format("delete from aluguer where IdAluguer={0}", this.IdAluguer);
oBaseDatos.operacionsNonSelect(cadenaSQL);
}
public System.Data.DataSet LeerAluguer(clsBD oBaseDatos)
{
string cadenaSQL = string.Format("select * from aluguer where idVehiculo={0}", this.IdVehiculo);
return(oBaseDatos.operacionsSelect(cadenaSQL));
}