protected void Button1_Click(object sender, EventArgs e)
{
string ced = "";
string tk = "";
string placa = "";
ced = txtcedula.Text;
tk = txtticket.Text;
placa = txtplaca.Text;
conexionbd obje = new conexionbd();
DataSet dt = new DataSet();
dt = obje.CargarSolicitudes(ced, tk, placa, 1);
GridView1.DataSource = dt;
GridView1.DataBind();
if (ced == "" && placa == "" && tk == "")
{
lblresp.Text = "Consulta sin filtros";
}
else
{
lblresp.Text = "Consulta Filtrada";
}
}
public void ConsultarTodasSolicitudes()
{
solicitud oSolicitud = new solicitud();
conexionbd obje = new conexionbd();
DataSet dt = new DataSet();
dt = obje.CargarSolicitudes("", "", "", 2);
GridView1.DataSource = dt;
GridView1.DataBind();
int conteo = 0;
conteo = oSolicitud.ContarPendientes();
lbltareas.Text = "Tareas Pendientes: " + conteo;
if (chktodas.Checked)
{
dt = obje.CargarSolicitudes("", "", "", 3);
gvtodas.DataSource = dt;
gvtodas.DataBind();
GridView1.Dispose();
Pnlpendientes.Dispose();
Pnlpendientes.Visible = false;
PnlTodas.Visible = true;
lbltareas.Text = "Todas las tareas";
}
else
{
Pnlpendientes.Visible = true;
PnlTodas.Visible = false;
}
}
protected void gvtodas_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
conexionbd obje = new conexionbd();
DataSet dt = new DataSet();
gvtodas.PageIndex = e.NewPageIndex;
dt = obje.CargarSolicitudes("", "", "", 3);
gvtodas.DataSource = dt;
gvtodas.DataBind();
GridView1.Dispose();
Pnlpendientes.Dispose();
Pnlpendientes.Visible = false;
// GridView1.Visible = false;
PnlTodas.Visible = true;
// gvtodas.Visible = true;
}
protected void GridView1_PageIndexChanging1(object sender, GridViewPageEventArgs e)
{
string ced = "";
string tk = "";
string placa = "";
ced = txtcedula.Text;
tk = txtticket.Text;
placa = txtplaca.Text;
conexionbd obje = new conexionbd();
DataSet dt = new DataSet();
GridView1.PageIndex = e.NewPageIndex;
dt = obje.CargarSolicitudes(ced, tk, placa, 1);
GridView1.DataSource = dt;
GridView1.DataBind();
}