Example #1
0
        protected void GridPrestamo_SelectedIndexChanged(object sender, EventArgs e)
        {
            GridViewRow row       = GridPrestamo.SelectedRow;
            string      ConvFecha = " Convert(VARCHAR(10),Fecha,103) as Fecha ";

            DataTable dt = Utilitario.Lista(" Cantidad, " + ConvFecha, " from Abono ", " where PrestamoId = " + row.Cells[1].Text);

            DataTable dt2 = new DataTable();

            dt2 = Utilitario.Lista(" ClienteId ", " from Prestamo ", " where PrestamoId = " + row.Cells[1].Text);


            if (dt2.Rows.Count > 0)
            {
                LblClienteId.Text = dt2.Rows[0]["ClienteId"].ToString();

                DataTable dt3 = new DataTable();

                dt3 = Utilitario.Lista(" Descripcion,Fecha ", " from Nota ", " where PrestamoId = " + row.Cells[1].Text);

                if (dt3.Rows.Count > 0)
                {
                    GridComentario.DataSource = dt3;
                    GridComentario.DataBind();

                    ViewState["Detalle"] = dt3;
                    ObtenerGridView();
                    btnGuardarNonta.Visible = true;
                }
                else
                {
                    btnGuardarNonta.Visible = false;
                }
            }



            if (Utilitario.ValidarTabla(dt))
            {
                GridVAbono.DataSource = dt;
                GridVAbono.DataBind();
                divAbono.Visible = true;
                lblId.Text       = row.Cells[0].Text;
            }
            else
            {
                lblId.Text       = row.Cells[0].Text;
                divAbono.Visible = false;
                Utilitario.ShowToastr(this, "NO TIENE ABONO", "Mensaje", "error");
            }

            btnImprimir.Visible = true;
        }
Example #2
0
 public void ObtenerGridView()
 {
     GridComentario.DataSource = (DataTable)ViewState["Detalle"];
     GridComentario.DataBind();
 }