protected void Desplegar_LISTA_REUNIONES()
{
DB_AP_Reunion ListReu = new DB_AP_Reunion();
GVListaReunion.DataSource = ListReu.DB_Reporte_REUNIONES(1, Convert.ToInt32(LblIdCamp.Text), "LISTAREUNION");
GVListaReunion.DataBind();
}
protected void Registrar_TEMAS()
{
DB_AP_Reunion insert = new DB_AP_Reunion();
AP_ReunionTareas rt = new AP_ReunionTareas();
DataTable dt = Session["datos1"] as DataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
rt.Id_Reunion = Convert.ToInt32(LblIdReunion.Text);
rt.Criterios = dt.Rows[i][1].ToString();
insert.DB_Registrar_TEMAS(rt);
}
}
protected void Registrar_REUNION()
{
DB_AP_Reunion insert = new DB_AP_Reunion();
AP_Reunion r = new AP_Reunion();
r.Id_Campanhia = Convert.ToInt32(LblIdCamp.Text);
r.Id_Regional = Convert.ToInt32(DDLRegional.SelectedValue);
r.Tipo_Reunion = DDLTipoReunion.SelectedValue;
r.Lugar = TxtLugar.Text;
r.Fecha = Convert.ToDateTime(LblFecha.Text);
r.Conclusion = TxtConclucion.Text;
insert.DB_Registrar_REUNION(r);
DB_AP_Registro_Org aux = new DB_AP_Registro_Org();
LblIdReunion.Text = aux.DB_MaxId("AP_REUNION", "Id_Reunion");
Registrar_ASISTENCIA();
Registrar_TEMAS();
}
protected void Registrar_ASISTENCIA()
{
DB_AP_Reunion insert = new DB_AP_Reunion();
AP_ReunionAsistencia ra = new AP_ReunionAsistencia();
DataTable dt = Session["datos"] as DataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
ra.Id_Reunion = Convert.ToInt32(LblIdReunion.Text);
ra.Nombre = dt.Rows[i][1].ToString();
ra.ci = dt.Rows[i][2].ToString();
ra.Comunidad = dt.Rows[i][3].ToString();
ra.Municipio = dt.Rows[i][4].ToString();
ra.Representante = dt.Rows[i][5].ToString();
ra.Cargo = dt.Rows[i][6].ToString();
insert.DB_Registrar_ASISTENCIA(ra);
}
}
protected void Desplegar_Reporte_REUNIONES()
{
DB_AP_Reunion listReuni = new DB_AP_Reunion();
DataTable dt = new DataTable();
dt = listReuni.DB_Reporte_REUNIONES(Convert.ToInt32(LblIdReunion.Text), 0, "REUNION");
LblTipoReunion.Text = dt.Rows[0][4].ToString();
LblCamp.Text = dt.Rows[0][1].ToString();
LblCamp1.Text = dt.Rows[0][1].ToString();
LblLugar.Text = dt.Rows[0][5].ToString();
LblRegional.Text = dt.Rows[0][8].ToString();
LblFecha.Text = dt.Rows[0][6].ToString();
LblConclu.Text = dt.Rows[0][7].ToString();
GVAsistencia.DataSource = listReuni.DB_Reporte_REUNIONES(Convert.ToInt32(LblIdReunion.Text), 0, "ASISTENCIA");
GVAsistencia.DataBind();
GVTarea.DataSource = listReuni.DB_Reporte_REUNIONES(Convert.ToInt32(LblIdReunion.Text), 0, "TEMAS");
GVTarea.DataBind();
}
