protected void repeater()
{
Vehiculos vehiculo = new Vehiculos();
VehiculosDataList.DataSource = vehiculo.Listado("TOP 6 EstadoVehiculo, MRC.Descripcion AS 'Marca', MDL.Descripcion AS 'Modelo', Año", "1=1", "");
VehiculosDataList.DataBind();
}
protected void Datalist()
{
Vehiculos vehiculo = new Vehiculos();
VehiculosDataList.DataSource = vehiculo.Listado("EstadoVehiculo, MRC.Descripcion AS 'Marca', MDL.Descripcion AS 'Modelo', CLR.Descripcion AS 'Color', MTR.Descripcion AS 'Motor', Año, TVS.Descripcion AS 'TipoVehiculo', Kilometraje, Precio", "1=1", "");
VehiculosDataList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
VehiculosDataList.DataSource = MostrarVehiculos();
VehiculosDataList.DataBind();
}
}
protected void FiltroButton_Click(object sender, EventArgs e)
{
Vehiculos vehiculo = new Vehiculos();
string filtro = "1=1";
if (FiltroTextBox.Text.Length > 0)
{
filtro = FiltroDropDownList.SelectedValue + " like '%" + FiltroTextBox.Text + "%'";
}
VehiculosDataList.DataSource = vehiculo.Listado("V.VehiculoId, Ma.Descripcion as 'Marca', M.Descripcion as 'Modelo', Mo.Descripcion, E.Descripcion as 'Estado', C.Descripcion, T.Descripcion, Año, Kilometraje, Precio, F.Foto", filtro, "");
VehiculosDataList.DataBind();
}
protected string Filtro()
{
Vehiculos vehiculo = new Vehiculos();
string filtro = "1=1";
if (FiltroTextBox.Text.Length > 0)
{
filtro = BuscarPorDropDownList.SelectedValue + " like '%" + FiltroTextBox.Text + "%'";
}
VehiculosDataList.DataSource = vehiculo.Listado("EstadoVehiculo, MRC.Descripcion AS 'Marca', MDL.Descripcion AS 'Modelo', CLR.Descripcion AS 'Color', MTR.Descripcion AS 'Motor', Año, TVS.Descripcion AS 'TipoVehiculo', Kilometraje, Precio", filtro, "");
VehiculosDataList.DataBind();
return(filtro);
}
