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);
}
