public List <ClaseVehiculo> listaClaseVehiculos()
{
List <ClaseVehiculo> listaClase = new List <ClaseVehiculo>();
SqlCommand comando = new SqlCommand();
comando.Connection = this.conexion;
comando.CommandText = "Select * from CLASEVEHICULO";
try
{
SqlDataReader registro = comando.ExecuteReader();
while (registro.Read())
{
ClaseVehiculo CV = new ClaseVehiculo();
CV.id = registro.GetDecimal(0);
CV.descripcion = registro.GetString(1);
listaClase.Add(CV);
}
registro.Close();
}
catch (Exception ex)
{
this.error = ex.Message;
}
return(listaClase);
}
public Vehiculo BuscarVehiculo(int?id)
{
this.error = "";
Vehiculo unVehiculo = null;
SqlCommand comando = new SqlCommand();
comando.Connection = this.conexion;
comando.CommandText = "SELECT * FROM VEHICULO WHERE ID=" + id;
try
{
SqlDataReader registro = comando.ExecuteReader();
if (registro.Read())
{
unVehiculo = new Vehiculo();
unVehiculo.id = Convert.ToInt32(registro.GetDecimal(0));
unVehiculo.placa = registro.GetString(1);
Linea linea = new Linea();
linea.id = registro.GetDecimal(2);
unVehiculo.idLinea = linea;
unVehiculo.modelo = registro.GetString(3);
unVehiculo.numeroMotor = registro.GetString(4);
unVehiculo.color = registro.GetString(5);
ClaseVehiculo clase = new ClaseVehiculo();
clase.id = registro.GetDecimal(6);
unVehiculo.idClaseVehiculo = clase;
TipoServicio tipo = new TipoServicio();
tipo.id = registro.GetDecimal(7);
}
registro.Close();
}
catch (Exception ex)
{
this.error = ex.Message;
}
return(unVehiculo);
}
public Vehiculo(decimal id, string placa, Linea idLinea, string modelo, string numeroMotor, string color, ClaseVehiculo idClaseVehiculo, TipoServicio idTipoServicio)
{
this.id = id;
this.placa = placa;
this.idLinea = idLinea;
this.modelo = modelo;
this.numeroMotor = numeroMotor;
this.color = color;
this.idClaseVehiculo = idClaseVehiculo;
this.idTipoServicio = idTipoServicio;
}