//grid unitarios
        protected void GridUnitarios_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            int? existe = 0;
            Data.DataDataContext db = new DataDataContext();
            db.CommandTimeout = 900000;
            if (e.Row.RowType == DataControlRowType.Header)
            {
                //Find the checkbox control in header and add an attribute
                ((CheckBox)e.Row.FindControl("cbSelectAllUnitarios")).Attributes.Add("onclick", "javascript:SelectAllUnitarios('" +
                        ((CheckBox)e.Row.FindControl("cbSelectAllUnitarios")).ClientID + "')");

            }

            for (int i = 0; i < GridUnitarios.Rows.Count; i++)
            {
                CheckBox chek = ((CheckBox)GridUnitarios.Rows[i].FindControl("CheckUnitarios"));

                string a = Session["Capitulo"].ToString();
                string clasificacion = "";
                db.ExisteParametrizacion(GridUnitarios.Rows[i].Cells[3].Text+a+GridUnitarios.Rows[i].Cells[1].Text, ref existe,ref clasificacion);
                if (existe != 0)
                {

                    chek.Checked = false;

                }
                else {

                    chek.Checked = true;
                }

            }
        }
        //grid de insumos
        protected void GridInsumos_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            Data.DataDataContext db = new DataDataContext();
            db.CommandTimeout = 900000;
            if (e.Row.RowType == DataControlRowType.Header)
            {
                //Find the checkbox control in header and add an attribute
                ((CheckBox)e.Row.FindControl("cbSelectAllInsumos")).Attributes.Add("onclick", "javascript:SelectAllInsumos('" +
                        ((CheckBox)e.Row.FindControl("cbSelectAllInsumos")).ClientID + "')");

            }

            int? existe = 0;
             string clasificacion = "";
            for (int i = 0; i < GridInsumos.Rows.Count; i++)
            {
                CheckBox chek = ((CheckBox)GridInsumos.Rows[i].FindControl("CheckInsumos"));
                //DropDownList cmbparametro = ((DropDownList)GridView1.Rows[i].FindControl("CmbClasificacion"));

                //comprobar si la parametrizacion existe
                db.ExisteParametrizacion(Label1.Text+Session["Capitulo"].ToString()+Session["Unitario"].ToString()+GridInsumos.Rows[i].Cells[1].Text,ref existe,ref clasificacion);
                if (existe != 0)
                {
                    //ponemos el check en false
                    chek.Checked = false;

                }
                else {
                    //ponemos el check en true
                    chek.Checked = true;
                }

            }
        }
        //cargar grilla capitulos
        protected void GridCapitulos_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            Data.DataDataContext db = new DataDataContext();
            db.CommandTimeout = 900000;

            if (e.Row.RowType == DataControlRowType.Header)
            {
                //Find the checkbox control in header and add an attribute
                ((CheckBox)e.Row.FindControl("cbSelectAllCapitulos")).Attributes.Add("onclick", "javascript:SelectAll('" +
                        ((CheckBox)e.Row.FindControl("cbSelectAllCapitulos")).ClientID + "')");

            }
            int? existe = 0;
            string clasificacion = "";
            for (int i = 0; i < GridCapitulos.Rows.Count; i++)
            {
                /*Check capitulos*/
                CheckBox chek = ((CheckBox)GridCapitulos.Rows[i].FindControl("CheckCapitulos"));
                //validar si existe parametrizacion
                db.ExisteParametrizacion(GridCapitulos.Rows[i].Cells[3].Text+GridCapitulos.Rows[i].Cells[1].Text, ref existe,ref clasificacion);
                if (existe != 0)
                {
                    //ponemos el chek en false
                    chek.Checked = false;

                }
                else {
                    //ponemos el chek en true
                    chek.Checked = true;
                }

            }
        }
        protected void GridInsumos_RowCreated(object sender, GridViewRowEventArgs e)
        {
            Data.DataDataContext db = new DataDataContext();
            db.CommandTimeout = 900000;
            int? existe = 0;
            string clasificacion = "";
            for (int i = 0; i < GridInsumos.Rows.Count; i++)
            {
                CheckBox chek = ((CheckBox)GridInsumos.Rows[i].FindControl("CheckInsumos"));
                //DropDownList cmbparametro = ((DropDownList)GridView1.Rows[i].FindControl("CmbClasificacion"));

                db.ExisteParametrizacion(Label1.Text+Session["Capitulo"].ToString()+Session["Unitario"].ToString()+GridInsumos.Rows[i].Cells[1].Text, ref existe, ref clasificacion);
                if (existe != 0)
                {
                    //seleccionamos en falso
                    chek.Checked = false;

                }
                else {
                    //seleccionamos en true
                    chek.Checked = true;

                }

            }
        }
        protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
        {
            Data.DataDataContext db = new DataDataContext();
            db.CommandTimeout = 900000;
            int? existe = 0;
            string clasificacion = "";
            for (int i = 0; i < GridView1.Rows.Count; i++)
            {
                //checkbox seleccionado
                CheckBox chek = ((CheckBox)GridView1.Rows[i].FindControl("CheckSeleccionar"));

                //combo seleccionado
                DropDownList cmbparametro = ((DropDownList)GridView1.Rows[i].FindControl("CmbClasificacion"));

                //validar si existe la parametrizacion
                db.ExisteParametrizacion(GridView1.Rows[i].Cells[3].Text , ref existe,ref clasificacion);
                if (existe != 0)
                {

                    chek.Checked = false;

                }
                else {

                    chek.Checked = true;
                    try
                    {
                        cmbparametro.SelectedValue = clasificacion.ToString();
                    }
                    catch (Exception EX) {

                    }

                }

            }
        }