protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { AreaTematicaBusiness areatematicaBusiness = new AreaTematicaBusiness(WebConfigurationManager.ConnectionStrings["PRA_DFGKP"].ConnectionString); LinkedList <AreaTematica> areas = new LinkedList <AreaTematica>(); areas = areatematicaBusiness.ObtenerAreasTematicas(); ddlAreas.DataSource = areas; ddlAreas.DataTextField = "NombreAreaTematica"; ddlAreas.DataValueField = "IdArea"; ddlAreas.DataBind(); ddlAreas.Items.Insert(0, new ListItem("Seleccionar")); ddlAreas.SelectedIndex = 0; lblHeadAreaSeleccionada.Visible = false; lblHeadDescripcion.Visible = false; lblHeadFuncionario.Visible = false; lblHeadAreaSeleccionada.Visible = false; lblArea.Visible = false; lblDescripcion.Visible = false; ddlFuncionarios.Visible = false; btnAsignar.Visible = false; } else { ddlAreas.Items.Remove("Seleccionar"); } }
protected void ddlAreas_SelectedIndexChanged(object sender, EventArgs e) { lblHeadAreaSeleccionada.Visible = true; lblHeadDescripcion.Visible = true; lblHeadFuncionario.Visible = true; lblHeadAreaSeleccionada.Visible = true; lblArea.Visible = true; lblDescripcion.Visible = true; ddlFuncionarios.Visible = true; btnAsignar.Visible = true; AreaTematicaBusiness areaTematicaBusiness = new AreaTematicaBusiness(WebConfigurationManager.ConnectionStrings["PRA_DFGKP"].ConnectionString); FuncionarioBusiness funcionarioBusiness = new FuncionarioBusiness(WebConfigurationManager.ConnectionStrings["PRA_DFGKP"].ConnectionString); Funcionario funcionario = new Funcionario(); funcionario = funcionarioBusiness.ObtenerFuncionarioPorAreaAsignada(Int32.Parse(ddlAreas.SelectedItem.Value)); lblArea.Text = areaTematicaBusiness.ObtenerAreaTematicaPorId(Int32.Parse(ddlAreas.SelectedItem.Value)).NombreAreaTematica + ""; lblDescripcion.Text = areaTematicaBusiness.ObtenerAreaTematicaPorId(Int32.Parse(ddlAreas.SelectedItem.Value)).DescripcionArea + ""; LinkedList <Funcionario> funcionarios = new LinkedList <Funcionario>(); funcionarios = funcionarioBusiness.ObtenerFuncionariosDisponibles(); ddlFuncionarios.DataSource = funcionarios; ddlFuncionarios.DataTextField = "NombreFuncionario"; ddlFuncionarios.DataValueField = "IdFuncionario"; ddlFuncionarios.DataBind(); ddlFuncionarios.Items.Insert(0, new ListItem(funcionario.NombreFuncionario + " (Asignado)", funcionario.IdFuncionario + "")); ddlFuncionarios.SelectedIndex = 0; }
protected void ddlAreaTematica_SelectedIndexChanged(object sender, EventArgs e) { AreaTematicaBusiness areaBus = new AreaTematicaBusiness(connectionString); areaTematica = areaBus.findAreaTematicaByCode(Int32.Parse(ddlAreaTematica.SelectedItem.Value)); CriterioBusiness criterioBus = new CriterioBusiness(connectionString); LinkedList <Criterio> criterios = criterioBus.findAllCriteriosByAreaTematica(Int32.Parse(ddlAreaTematica.SelectedItem.Value)); if (criterios != null) { Criterio a = new Criterio(); a.IdCriterio = 0; a.Descripcion = ""; criterios.AddFirst(a); lblCriterios.Visible = true; ddlCriterios.Visible = true; ddlCriterios.DataSource = criterios; ddlCriterios.DataTextField = "descripcion"; ddlCriterios.DataValueField = "idCriterio"; ddlCriterios.DataBind(); } else { lblMensajeError.Text = "El area tematica seleccionada no tiene criterios registrados"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { String userName = User.Identity.Name; FuncionarioBusiness funcionarioBus = new FuncionarioBusiness(connectionString); AreaTematicaBusiness areaTematicaBus = new AreaTematicaBusiness(connectionString); funcionario = funcionarioBus.getFuncionarioByUserName(userName); LinkedList <AreaTematica> areasTematicasEncargado = areaTematicaBus.getAllAreaTematicasByEncargado(funcionario.IdFuncionario); if (areasTematicasEncargado != null) { AreaTematica a = new AreaTematica(); a.IdAreaTematica = 0; a.Nombre = ""; areasTematicasEncargado.AddFirst(a); lblAreaTematica.Visible = true; ddlAreaTematica.Visible = true; ddlAreaTematica.DataSource = areasTematicasEncargado; ddlAreaTematica.DataTextField = "nombre"; ddlAreaTematica.DataValueField = "idAreaTematica"; ddlAreaTematica.DataBind(); } else { lblMensajeError.Text = "El funcionario en seccion no posee Areas Tematicas a su cargo"; } } }
protected void ddlTipoBusqueda_SelectedIndexChanged(object sender, EventArgs e) { if (ddlTipoBusqueda.SelectedItem.Value == 1 + "") { CriterioBusiness criterioBusiness = new CriterioBusiness(WebConfigurationManager.ConnectionStrings["PRA_DFGKP"].ConnectionString); LinkedList <Criterio> criterios = new LinkedList <Criterio>(); criterios = criterioBusiness.ObtenerCriterios(); ddlAreasCriterios.DataSource = criterios; ddlAreasCriterios.DataTextField = "NombreCriterio"; ddlAreasCriterios.DataValueField = "IdCriterio"; ddlAreasCriterios.DataBind(); lblSeleccionBusqueda.Text = "Criterios:"; SubcriterioBusiness subcriterioBusiness = new SubcriterioBusiness(WebConfigurationManager.ConnectionStrings["PRA_DFGKP"].ConnectionString); LinkedList <Subcriterio> subcriterios = new LinkedList <Subcriterio>(); subcriterios = subcriterioBusiness.obtenerSubcriteriosPorIdCriterio(Int32.Parse(ddlAreasCriterios.SelectedItem.Value)); gvCriterios.DataSource = subcriterios; gvCriterios.DataBind(); } else { AreaTematicaBusiness areaTematicaBusiness = new AreaTematicaBusiness(WebConfigurationManager.ConnectionStrings["PRA_DFGKP"].ConnectionString); LinkedList <AreaTematica> areas = new LinkedList <AreaTematica>(); areas = areaTematicaBusiness.ObtenerAreasTematicas(); ddlAreasCriterios.DataSource = areas; ddlAreasCriterios.DataTextField = "NombreAreaTematica"; ddlAreasCriterios.DataValueField = "IdArea"; ddlAreasCriterios.DataBind(); lblSeleccionBusqueda.Text = "Áreas:"; SubcriterioBusiness subcriterioBusiness = new SubcriterioBusiness(WebConfigurationManager.ConnectionStrings["PRA_DFGKP"].ConnectionString); LinkedList <Subcriterio> subcriterios = new LinkedList <Subcriterio>(); subcriterios = subcriterioBusiness.obtenerSubcriteriosPorIdArea(Int32.Parse(ddlAreasCriterios.SelectedItem.Value)); gvCriterios.DataSource = subcriterios; gvCriterios.DataBind(); } }
protected void dataList_action(object source, DataListCommandEventArgs e) { Label Label = (Label)e.Item.FindControl("codAreaTematica"); int codArea = Int32.Parse(Label.Text); DropDownList dropDownList = (DropDownList)e.Item.FindControl("ddlEncargado"); int codFuncionario = Int32.Parse(dropDownList.SelectedValue); AreaTematicaBusiness areaTematicaBusiness = new AreaTematicaBusiness(WebConfigurationManager.ConnectionStrings["GestionAmbiental"].ConnectionString); areaTematicaBusiness.AsignarEncargadoDeAreaTematica(codFuncionario, codArea); reload(); }
protected void gvEncargadoDe_SelectedIndexChanged(object sender, EventArgs e) { AreaTematicaBusiness areaTematicaBusiness = new AreaTematicaBusiness( WebConfigurationManager.ConnectionStrings["ProyectoII"].ConnectionString); ddlAreas.DataSource = areaTematicaBusiness.getAllAreaTematicasByGuide( Int32.Parse(gvEncargadoDe.SelectedRow.Cells[6].Text)); ddlAreas.DataTextField = "nombre"; ddlAreas.DataValueField = "idAreaTematica"; ddlAreas.DataBind(); ddlAreas.Visible = true; }
private void reload() { int codGuia = Int32.Parse(Request.QueryString["codGuia"]); AreaTematicaBusiness areaTematicaBusiness = new AreaTematicaBusiness(WebConfigurationManager.ConnectionStrings["GestionAmbiental"].ConnectionString); LinkedList <AreaTematica> tematicasEnGuia = new LinkedList <AreaTematica>(); tematicasEnGuia = areaTematicaBusiness.BuscarAreaTematicaPorGuia(codGuia); dlEncargados.DataSource = tematicasEnGuia; dlEncargados.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { AreaTematicaBusiness areaTematicaBusiness = new AreaTematicaBusiness(WebConfigurationManager.ConnectionStrings["PRA_DFGKP"].ConnectionString); LinkedList <AreaTematica> areas = areaTematicaBusiness.ObtenerAreasTematicas(); //como llenar el DropDownList foreach (AreaTematica areaTematica in areas) { DDL_areaTematica.Items.Add(new ListItem(areaTematica.NombreAreaTematica.ToString())); DDL_areaTematica.DataValueField = areaTematica.IdArea.ToString(); } //foreach } //ispostback } //Page_Load
protected void Page_Load(object sender, EventArgs e) { String cadenaConexion = WebConfigurationManager.ConnectionStrings["GestionAmbiental"].ConnectionString; AreaTematicaBusiness areaTematicaBusiness = new AreaTematicaBusiness(cadenaConexion); SubcriterioBusiness criterioBusiness = new SubcriterioBusiness(cadenaConexion); AreaTematica area = (AreaTematica)Session["areaTematica"]; lblMensaje.Visible = false; //llenamos el DropDown de Criterios LinkedList <Criterio> listaCriterios = areaTematicaBusiness.ObtenerCriteriosPorArea(area.CodArea); foreach (Criterio criterioActual in listaCriterios) { ddlCriterios.Items.Add(new ListItem(criterioActual.NombreCriterio, criterioActual.CodCriterio + "")); } }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { int codGuia = Int32.Parse(Request.QueryString["codGuia"]); AreaTematicaBusiness areaTematicaBusiness = new AreaTematicaBusiness(WebConfigurationManager.ConnectionStrings["GestionAmbiental"].ConnectionString); LinkedList <AreaTematica> tematicasEnGuia = new LinkedList <AreaTematica>(); tematicasEnGuia = areaTematicaBusiness.BuscarAreaTematicaPorGuia(codGuia); dlEncargados.DataSource = tematicasEnGuia; dlEncargados.DataBind(); } }
public GuiaReconocimientoData(String connectionString) { this.connectionString = connectionString; this.areaTematicaBusiness = new AreaTematicaBusiness(connectionString); }
protected void Button1_Click(object sender, EventArgs e) { AreaTematicaBusiness areaBusiness = new AreaTematicaBusiness(WebConfigurationManager.ConnectionStrings["PRA_DFGKP"].ConnectionString); areaBusiness.AgregarAreaTematica(TX_nombreArea.Text, TX_descripcionArea.Text, TX_siglaArea.Text); }