protected void Button1_Click(object sender, EventArgs e)
{
Colores color = new Colores();
Utilerias2.dataset = "Colores";
Utilerias2.reporte = @"Report\ReportColores.rdlc";
Utilerias2.data = color.Listado("*", Filtro(), "");
Response.Write("<script type='text/javascript'>detailedresults=window.open('/Reporte.aspx');</script>");
}
protected void ImprimirButton_Click(object sender, EventArgs e)
{
Colores color = new Colores();
Validaciones.dataset = "Colores";
Validaciones.reporte = @"Reportes\ColoresReport.rdlc";
Validaciones.data = color.Listado("*", Filtro(), "");
Response.Write("<script type='text/javascript'>detailedresults=window.open('/Reportes/VisorReportes.aspx');</script>");
}
public void ColoresDropDownList()
{
Colores color = new Colores();
ColorDropDownList.DataSource = color.Listado("*", "1=1", "");
ColorDropDownList.DataTextField = "Descripcion";
ColorDropDownList.DataValueField = "ColorId";
ColorDropDownList.DataBind();
ColorDropDownList.Items.Insert(0, "Elige Color");
}
protected string Filtro()
{
Colores color = new Colores();
string filtro = "1=1";
if (FiltroTextbox.Text.Length > 0)
{
filtro = FiltroDropDownList.SelectedValue + " like '%" + FiltroTextbox.Text + "%'";
}
ColoresListView.DataSource = color.Listado("ColorId, Descripcion", filtro, "");
ColoresListView.DataBind();
return(filtro);
}
public void ObtenerDropDownList()
{
Marcas marca = new Marcas();
MarcaDropDownList.DataSource = marca.Listado(" * ", " 1=1 ", " ");
MarcaDropDownList.DataTextField = "Descripcion";
MarcaDropDownList.DataValueField = "MarcaId";
MarcaDropDownList.DataBind();
MarcaDropDownList.Items.Insert(0, "Seleccionar--");
Modelos modelo = new Modelos();
ModeloDropDownList.DataSource = modelo.Listado(" * ", " 1=1 ", " ");
ModeloDropDownList.DataTextField = "Descripcion";
ModeloDropDownList.DataValueField = "ModeloId";
ModeloDropDownList.DataBind();
ModeloDropDownList.Items.Insert(0, "Seleccionar--");
Motores motor = new Motores();
MotorDropDownList.DataSource = motor.Listado(" * ", " 1=1 ", " ");
MotorDropDownList.DataTextField = "Descripcion";
MotorDropDownList.DataValueField = "MotorId";
MotorDropDownList.DataBind();
MotorDropDownList.Items.Insert(0, "Seleccionar--");
Colores color = new Colores();
ColorDropDownList.DataSource = color.Listado(" * ", " 1=1 ", " ");
ColorDropDownList.DataTextField = "Descripcion";
ColorDropDownList.DataValueField = "ColorId";
ColorDropDownList.DataBind();
ColorDropDownList.Items.Insert(0, "Seleccionar--");
TipoVehiculos tipo = new TipoVehiculos();
TipoDropDownList.DataSource = tipo.Listado(" * ", " 1=1 ", " ");
TipoDropDownList.DataTextField = "Descripcion";
TipoDropDownList.DataValueField = "TipoVehiculoId";
TipoDropDownList.DataBind();
TipoDropDownList.Items.Insert(0, "Seleccionar--");
}
public void ListadoTest()
{
Colores color = new Colores();
Assert.IsTrue(color.Listado(" * ", " 1=1 ", "").Rows.Count > 0);
}
public DataTable MostrarColores()
{
Colores color = new Colores();
return(color.Listado("*", "1=1", ""));
}
