protected void BtnGuardar_Click(object sender, EventArgs e)
 {
     Data.DataDataContext db = new Data.DataDataContext();
     db.CommandTimeout = 900000;
     db.BorrarAreas();
        // db.BorrarParametrizacion();
     Consultas.GuardarAreas();
     //Consultas.GuardarParametros();
 }
        protected void gvMeses_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            Data.DataDataContext db = new Data.DataDataContext();
            db.CommandTimeout = 900000;
            var item = db.ValidarFechas(Session["ProyectoAgrupacionesFechas"].ToString());

            foreach (ValidarFechasResult a in item)
            {

                    if (e.Row.RowType == DataControlRowType.DataRow)
                    {
                        string priority = (string)DataBinder.Eval(e.Row.DataItem, "Mes");
                        if (a.Mes == priority.ToString())
                        {
                            {
                                e.Row.CssClass = currentClass;
                              //  e.Row.Style.Add("background-color","Blue");
                               // e.Row.BackColor = System.Drawing.Color.Red;
                            }
                        }
                    }
                 }
        }
        protected void ImgLB_Command(object sender, CommandEventArgs e)
        {
            Data.DataDataContext db = new Data.DataDataContext();
            db.CommandTimeout = 900000;

            try
            {

                if (e.CommandName != "Page")
                {

                    //get the gridview row where the command is raised

                    GridViewRow selectedRow = ((Control)sender).Parent.NamingContainer as GridViewRow;

                    db.ActualizarCostosFecha(int.Parse(e.CommandArgument.ToString()), selectedRow.Cells[4].Text.ToString());
                    Response.Write("<script>window.alert('" + "Se ha Cambiado el Estado de Esta Fecha a Linea base" + "');</script>");
                    gvProyectos.DataSource = GetData("SELECT DISTINCT(PROYECTO),0 as ID FROM Fechas");
                    gvProyectos.DataBind();
                   /* selectedRow.DataBind();*/

                }
            }
            catch (Exception ex)
            {
                 db.InsertarError(ex.Message.ToString(),DateTime.Now);

            }
        }