protected void Buscar_Click(object sender, EventArgs e) { panel1.Visible = true; botonExportar.Visible = true; ButtonExp.Visible = false; panel3.Visible = false; if ((lista_depto.SelectedValue.ToString() == "0")) { //MensajeError("Debes de Seleccionar el Departamento"); panel1.Visible = false; panel2.Visible = false; botonExportar.Visible = false; return; } //else //{ String idOrganizationEBS = lista_depto.SelectedValue.ToString(); TablaEmpleados empleadosEbs = new TablaEmpleados(); DataTable table = empleadosEbs.empleadoxdepto(idOrganizationEBS); if (table == null) { MensajeError("Null empleadoxdepto"); return; } gridBuscar.DataSource = table; gridBuscar.DataBind(); panel2.Visible = true; int contadorpos; //panel3.Visible = true; //panel2.Visible = true; //string idplantilla; //---BORRO la CONSULTA ANTERIOR usuario.Text = (string)(Session["Nombre"]); empcritico.Text = ""; empnec.Text = ""; empreconocer.Text = ""; empretener.Text = ""; using (SqlConnection cnxdel = new SqlConnection(connectionString)) { cnxdel.Open(); string query_del = " DELETE FROM EVA_C_GRAFICA " + " WHERE iduser= '******' "; SqlCommand cmdd = new SqlCommand(query_del, cnxdel); SqlDataReader drd = cmdd.ExecuteReader(); } using (SqlConnection cnxdel = new SqlConnection(connectionString)) { cnxdel.Open(); string query_del = " DELETE FROM EVA_D_GRAFICA " + " WHERE usuario= '" + usuario.Text + "' "; SqlCommand cmdd = new SqlCommand(query_del, cnxdel); SqlDataReader drd = cmdd.ExecuteReader(); } //saco la plantillas using (SqlConnection cnx = new SqlConnection(connectionString)) { cnx.Open(); string query = "SELECT id_plantilla FROM EVA_PLANTILLAS WHERE (vigencia_plant = '1')"; SqlCommand cmd = new SqlCommand(query, cnx); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { idplantilla.Text = dr["id_plantilla"].ToString(); } } else { idplantilla.Text = "No se encontro plantilla autorizada"; } } // cierre de la conn DataTable dt = new DataTable(); TablaEmpleados empleadosEbs2 = new TablaEmpleados(); DataTable table2 = empleadosEbs2.empleadoxdeptoID(idOrganizationEBS); if (table2 != null) { foreach (DataRow row in table2.Rows) // Loop over the rows. { foreach (var item in row.ItemArray) // Loop over the items. { using (SqlConnection cnx = new SqlConnection(connectionString)) { cnx.Open(); string query = " select count(c.id_eva) as total, c.id_eva " + " from EVA_C_EVALUACION as c, EVA_D_EVALUACION as d " + " where c.id_emp='" + item + "' and c.estatus='2' and c.id_eva=d.id_eva and d.id_plantilla='" + idplantilla.Text + "' " + " group by c.id_eva "; SqlCommand cmd = new SqlCommand(query, cnx); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { evaluacionid.Text = dr["id_eva"].ToString(); } } else { evaluacionid.Text = "0"; } } // cierre de la conn if (evaluacionid.Text != "0") { using (SqlConnection cnx = new SqlConnection(connectionString)) { // estatus=2 cuando la evaluacion ha sido liberada por jefe inmediato cnx.Open(); string query = " select {fn IFNULL(SUM(calificacion_val_jefe),0)} AS total_puntaje_valores " + " from EVA_C_EVALUACION as e, EVA_D_EVALUACION as d " + " where e.id_eva='" + evaluacionid.Text + "' and e.estatus='2' and d.id_plantilla='" + idplantilla.Text + "' and e.id_eva=d.id_eva "; SqlCommand cmd = new SqlCommand(query, cnx); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { total_valores.Text = dr["total_puntaje_valores"].ToString(); } } else { total_valores.Text = "0"; } } // cierre de la conn if (total_valores.Text != "0") { using (SqlConnection cnx = new SqlConnection(connectionString)) { cnx.Open(); string query = " select {fn IFNULL(SUM(ponderacion_ind_jefe),0)} AS total_puntaje_indicadores " + " from EVA_C_EVALUACION as e, EVA_D_INDICADORES as d " + " where e.id_eva='" + evaluacionid.Text + "' and e.estatus='2' and d.id_plantilla='" + idplantilla.Text + "' " + " and e.id_eva=d.id_eva "; SqlCommand cmd = new SqlCommand(query, cnx); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { total_valores_ind.Text = dr["total_puntaje_indicadores"].ToString(); } } else { total_valores_ind.Text = "No se encontro puntaje indicadores"; } } // cierre de la conn // para sacar la calificacion en Letra using (SqlConnection cnx = new SqlConnection(connectionString)) { cnx.Open(); string query2 = " SELECT ponderacion_kpi, calificacion_kpi, descripcion_kpi " + " FROM EVA_C_CALIFICACION_KPI " + " WHERE ponderacion_kpi <= '" + total_valores_ind.Text + "' order by 1 "; SqlCommand cmd2 = new SqlCommand(query2, cnx); SqlDataReader dr2 = cmd2.ExecuteReader(); if (dr2.HasRows) { while (dr2.Read()) { cal_indicador.Text = dr2["calificacion_kpi"].ToString(); } } else { //MensajeError("No se encontro Calificacion"); return; } } // cierre de la conn //--------------PARA GUARDAR LA POSICION EN LA GRAFICA Y QUE POSICION CORRESPONDE-------------------------------------- //string posicion; int contador_ab1, contador_cc1, contador_cd1, contador_ab2, contador_cc2, contador_cd2, contador_ab3, contador_cc3, contador_cd3; contador_ab1 = 0; contador_cc1 = 0; contador_cd1 = 0; contador_ab2 = 0; contador_cc2 = 0; contador_cd2 = 0; contador_ab3 = 0; contador_cc3 = 0; contador_cd3 = 0; if ((Convert.ToInt32(total_valores.Text) >= 1) && ((Convert.ToInt32(total_valores.Text.Trim())) <= 22)) { if (cal_indicador.Text.Trim() == "A" || cal_indicador.Text.Trim() == "B") { posicion.Text = "ab1"; contador_ab1 = contador_ab1 + 1; } if (cal_indicador.Text.Trim() == "C-" || cal_indicador.Text.Trim() == "C") { posicion.Text = "cc1"; contador_cc1 = contador_cc1 + 1; } if (cal_indicador.Text.Trim() == "C+" || cal_indicador.Text.Trim() == "D") { posicion.Text = "cd1"; contador_cd1 = contador_cd1 + 1; } //aqui guardo para tener los datos using (SqlConnection cnx2 = new SqlConnection(connectionString)) { cnx2.Open(); string query = " insert EVA_D_GRAFICA (id_eva, cal_valores, cal_indicadores, posicion, usuario, idempleado) " + " values ('" + evaluacionid.Text + "', '" + Convert.ToInt32(total_valores.Text) + "', '" + cal_indicador.Text + "', '" + posicion.Text + "', '" + usuario.Text + "' , '" + item + "' )"; SqlCommand cmd = new SqlCommand(query, cnx2); SqlDataReader dr = cmd.ExecuteReader(); } } else { if ((Convert.ToInt32(total_valores.Text) >= 23) && (Convert.ToInt32(total_valores.Text.Trim()) <= 50)) { if (cal_indicador.Text.Trim() == "A" || cal_indicador.Text.Trim() == "B") { posicion.Text = "ab2"; contador_ab2 = contador_ab2 + 1; } if (cal_indicador.Text.Trim() == "C-" || cal_indicador.Text.Trim() == "C") { posicion.Text = "cc2"; contador_cc2 = contador_cc2 + 1; } if (cal_indicador.Text.Trim() == "C+" || cal_indicador.Text.Trim() == "D") { posicion.Text = "cd2"; contador_cd2 = contador_cd2 + 1; } //aqui guardo para tener los datos using (SqlConnection cnx2 = new SqlConnection(connectionString)) { cnx2.Open(); string query = " insert EVA_D_GRAFICA (id_eva, cal_valores, cal_indicadores, posicion, usuario, idempleado) " + " values ('" + evaluacionid.Text + "', '" + Convert.ToInt32(total_valores.Text) + "', '" + cal_indicador.Text + "', '" + posicion.Text + "', '" + usuario.Text + "', '" + item + "' )"; SqlCommand cmd = new SqlCommand(query, cnx2); SqlDataReader dr = cmd.ExecuteReader(); } } else { if ((Convert.ToInt32(total_valores.Text) >= 51) && (Convert.ToInt32(total_valores.Text.Trim()) <= 54)) { if (cal_indicador.Text.Trim() == "A" || cal_indicador.Text.Trim() == "B") { posicion.Text = "ab3"; contador_ab3 = contador_ab3 + 1; } if (cal_indicador.Text.Trim() == "C-" || cal_indicador.Text.Trim() == "C") { posicion.Text = "cc3"; contador_cc3 = contador_cc3 + 1; } if (cal_indicador.Text.Trim() == "C+" || cal_indicador.Text.Trim() == "D") { posicion.Text = "cd3"; contador_cd3 = contador_cd3 + 1; } //aqui guardo para tener los datos using (SqlConnection cnx2 = new SqlConnection(connectionString)) { cnx2.Open(); string query = " insert EVA_D_GRAFICA (id_eva, cal_valores, cal_indicadores, posicion, usuario, idempleado) " + " values ('" + evaluacionid.Text + "', '" + Convert.ToInt32(total_valores.Text) + "', '" + cal_indicador.Text + "', '" + posicion.Text + "', '" + usuario.Text + "', '" + item + "') "; SqlCommand cmd = new SqlCommand(query, cnx2); SqlDataReader dr = cmd.ExecuteReader(); } } } } } //--------------------------------------------------------------------------------------------------------------------- } // termina el if de total_valores.Text else { // sino tiene total de valores en 0 //aqui guardo para tener los datos using (SqlConnection cnx2 = new SqlConnection(connectionString)) { cnx2.Open(); string query = " insert EVA_D_GRAFICA (id_eva, cal_valores, cal_indicadores, posicion, usuario) " + " values ('" + evaluacionid.Text + "', '0', '0', '-', '" + usuario.Text + "') "; SqlCommand cmd = new SqlCommand(query, cnx2); SqlDataReader dr = cmd.ExecuteReader(); } } } } } else { MensajeError("Null -empleadoxdeptoID"); return; } // AQUI GUARDO LOS RESULTADOS contadorpos = 0; while (contadorpos <= 8) { if (contadorpos == 0) { using (SqlConnection cnx3 = new SqlConnection(connectionString)) { cnx3.Open(); string query3 = " insert EVA_C_GRAFICA (idposicion, total_depto, iduser) " + " values ('ab1', 0, '" + usuario.Text + "') "; SqlCommand cmd3 = new SqlCommand(query3, cnx3); SqlDataReader dr3 = cmd3.ExecuteReader(); } } if (contadorpos == 1) { using (SqlConnection cnx3 = new SqlConnection(connectionString)) { cnx3.Open(); string query3 = " insert EVA_C_GRAFICA (idposicion, total_depto, iduser) " + " values ('ab2', 0, '" + usuario.Text + "') "; SqlCommand cmd3 = new SqlCommand(query3, cnx3); SqlDataReader dr3 = cmd3.ExecuteReader(); } } if (contadorpos == 2) { using (SqlConnection cnx3 = new SqlConnection(connectionString)) { cnx3.Open(); string query3 = " insert EVA_C_GRAFICA (idposicion, total_depto, iduser) " + " values ('ab3', 0, '" + usuario.Text + "') "; SqlCommand cmd3 = new SqlCommand(query3, cnx3); SqlDataReader dr3 = cmd3.ExecuteReader(); } } if (contadorpos == 3) { using (SqlConnection cnx3 = new SqlConnection(connectionString)) { cnx3.Open(); string query3 = " insert EVA_C_GRAFICA (idposicion, total_depto, iduser) " + " values ('cc1', 0, '" + usuario.Text + "') "; SqlCommand cmd3 = new SqlCommand(query3, cnx3); SqlDataReader dr3 = cmd3.ExecuteReader(); } } if (contadorpos == 4) { using (SqlConnection cnx3 = new SqlConnection(connectionString)) { cnx3.Open(); string query3 = " insert EVA_C_GRAFICA (idposicion, total_depto, iduser) " + " values ('cc2', 0, '" + usuario.Text + "') "; SqlCommand cmd3 = new SqlCommand(query3, cnx3); SqlDataReader dr3 = cmd3.ExecuteReader(); } } if (contadorpos == 5) { using (SqlConnection cnx3 = new SqlConnection(connectionString)) { cnx3.Open(); string query3 = " insert EVA_C_GRAFICA (idposicion, total_depto, iduser) " + " values ('cc3', 0, '" + usuario.Text + "') "; SqlCommand cmd3 = new SqlCommand(query3, cnx3); SqlDataReader dr3 = cmd3.ExecuteReader(); } } if (contadorpos == 6) { using (SqlConnection cnx3 = new SqlConnection(connectionString)) { cnx3.Open(); string query3 = " insert EVA_C_GRAFICA (idposicion, total_depto, iduser) " + " values ('cd1', 0, '" + usuario.Text + "') "; SqlCommand cmd3 = new SqlCommand(query3, cnx3); SqlDataReader dr3 = cmd3.ExecuteReader(); } } if (contadorpos == 7) { using (SqlConnection cnx3 = new SqlConnection(connectionString)) { cnx3.Open(); string query3 = " insert EVA_C_GRAFICA (idposicion, total_depto, iduser) " + " values ('cd2', 0, '" + usuario.Text + "') "; SqlCommand cmd3 = new SqlCommand(query3, cnx3); SqlDataReader dr3 = cmd3.ExecuteReader(); } } if (contadorpos == 8) { using (SqlConnection cnx3 = new SqlConnection(connectionString)) { cnx3.Open(); string query3 = " insert EVA_C_GRAFICA (idposicion, total_depto, iduser) " + " values ('cd3', 0, '" + usuario.Text + "') "; SqlCommand cmd3 = new SqlCommand(query3, cnx3); SqlDataReader dr3 = cmd3.ExecuteReader(); } } contadorpos = contadorpos + 1; } using (SqlConnection cnx = new SqlConnection(connectionString)) { cnx.Open(); string query2 = " SELECT COUNT(posicion) AS total, posicion " + " FROM EVA_D_GRAFICA " + " WHERE (usuario = '" + usuario.Text + "') " + " GROUP BY posicion ORDER BY 2"; SqlCommand cmd2 = new SqlCommand(query2, cnx); SqlDataReader dr2 = cmd2.ExecuteReader(); if (dr2.HasRows) { while (dr2.Read()) { Txtposicion.Text = dr2["posicion"].ToString(); //total_pos.Text = dr2["total"].ToString(); contadorpos = contadorpos + 1; if (Txtposicion.Text.Trim() == "ab1") { total_pos.Text = dr2["total"].ToString(); } else { if (Txtposicion.Text.Trim() == "ab2") { total_pos.Text = dr2["total"].ToString(); } else { if (Txtposicion.Text.Trim() == "ab3") { total_pos.Text = dr2["total"].ToString(); } else { if (Txtposicion.Text.Trim() == "cc1") { total_pos.Text = dr2["total"].ToString(); } else { if (Txtposicion.Text.Trim() == "cc2") { total_pos.Text = dr2["total"].ToString(); } else { if (Txtposicion.Text.Trim() == "cc3") { total_pos.Text = dr2["total"].ToString(); } else { if (Txtposicion.Text.Trim() == "cd1") { total_pos.Text = dr2["total"].ToString(); } else { if (Txtposicion.Text.Trim() == "cd2") { total_pos.Text = dr2["total"].ToString(); } else { if (Txtposicion.Text.Trim() == "cd3") { total_pos.Text = dr2["total"].ToString(); } else { total_pos.Text = "0"; } } } } } } } } } //-- aqui antes de que acabe el while using (SqlConnection cnx2 = new SqlConnection(connectionString)) { cnx2.Open(); string query = " UPDATE EVA_C_GRAFICA set idposicion='" + Txtposicion.Text + "', total_depto='" + Convert.ToInt16(total_pos.Text) + "' , iduser='******' " + " WHERE iduser= '******' and idposicion='" + Txtposicion.Text + "' "; SqlCommand cmd = new SqlCommand(query, cnx2); SqlDataReader dr = cmd.ExecuteReader(); } } // del while } else { //MensajeError("No se encontro Calificacion"); return; } } // cierre de la conn string totalvalores = "0"; using (SqlConnection cnxt = new SqlConnection(connectionString)) { cnxt.Open(); string query2 = " SELECT SUM(cal_valores) AS totalval " + " FROM EVA_D_GRAFICA " + " WHERE (usuario = '" + usuario.Text + "') "; SqlCommand cmd2 = new SqlCommand(query2, cnxt); SqlDataReader drt = cmd2.ExecuteReader(); if (drt.HasRows) { while (drt.Read()) { totalvalores = drt["totalval"].ToString(); } } } if (Convert.ToInt32(totalvalores) != 0) { renderChart(); //para las graficas } else { panel2.Visible = false; } panel3.Visible = false; panel4.Visible = false; LinkBCGral.Visible = false; //} }
protected void Page_Load(object sender, EventArgs e) { panel1.Visible = false; if (!Page.IsPostBack) { IDEmpleado.Text = (string)(Session["ClaveJDE"]); //DEVUELVE LOS VALORES DEL EBS this.capitalHumano = new NegocioCapitalHumano(); TablaEmpleados empleadosEbs = new TablaEmpleados(); List<Employee> listaEmpleados = capitalHumano.ListaEmpleados(IDEmpleado.Text, "%", "%", "%", "%", "%", "%", "%", "%", "%", "%", Convert.ToDateTime("01/Jan/1950"), Convert.ToDateTime("01/Jan/9999")); if (listaEmpleados == null) { MensajeError("No tiene asignado Empleados"); Button1.Visible = false; return; } else { txtPersonid.Text = listaEmpleados[0].Perclave.ToString(); lbbanda.Text = listaEmpleados[0].Grado.ToString(); lbdepto.Text = listaEmpleados[0].OrganizacionClave.ToString(); using (SqlConnection cnx = new SqlConnection(connectionString)) { cnx.Open(); string query = "SELECT id_cat, banda, d_categoria FROM EVA_CATEGORIA " + "WHERE d_categoria= '" + lbbanda.Text + "' "; SqlCommand cmd = new SqlCommand(query, cnx); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { id_categoria.Text = dr["id_cat"].ToString(); } } else { id_categoria.Text = "No se encontro categoria"; } } // A1 y A2 GERENTE/DIRECTOR VERA TODOS LOS DEPTOS ASIGNADOS muestra combo x depto // A3 Y B1 COORDINADOR SOLO VERA SU DEPTO muestra combo x subordinado de su depto // B2 Y B3 SUPERVISO JEFE VERA SOLO SUS SUBORDINADOS combo x if (id_categoria.Text == "A1" || id_categoria.Text == "A2") { //DataTable table = empleadosEbs.SupxDepto(txtPersonid.Text); //lista_empleados.DataSource = table; //lista_empleados.DataValueField = "organization_id"; //lista_empleados.DataTextField = "NombreDepto"; //lista_empleados.DataBind(); //lista_empleados.SelectedIndex = 0; //opcestatus.Visible = true; //BuscarEmp.Visible = false; DataTable table3 = empleadosEbs.subordinados(txtPersonid.Text); lista_empleados.DataSource = table3; lista_empleados.DataValueField = "employee_number"; lista_empleados.DataTextField = "full_name"; lista_empleados.DataBind(); lista_empleados.SelectedIndex = 0; Button1.Visible = false; } else { if (id_categoria.Text == "A3" || id_categoria.Text == "B1") { if (IDEmpleado.Text == "200334") { DataTable table3 = empleadosEbs.subordinados(txtPersonid.Text); lista_empleados.DataSource = table3; lista_empleados.DataValueField = "employee_number"; lista_empleados.DataTextField = "full_name"; lista_empleados.DataBind(); lista_empleados.SelectedIndex = 0; Button1.Visible = false; } else { DataTable table2 = empleadosEbs.empleadoxdepto(lbdepto.Text); lista_empleados.DataSource = table2; lista_empleados.DataValueField = "employee_number"; lista_empleados.DataTextField = "full_name"; lista_empleados.DataBind(); lista_empleados.SelectedIndex = 0; Button1.Visible = false; } } else { if (id_categoria.Text == "B2" || id_categoria.Text == "B3" || id_categoria.Text == "C1" || id_categoria.Text == "C3") { DataTable table3 = empleadosEbs.subordinados(txtPersonid.Text); lista_empleados.DataSource = table3; lista_empleados.DataValueField = "employee_number"; lista_empleados.DataTextField = "full_name"; lista_empleados.DataBind(); lista_empleados.SelectedIndex = 0; Button1.Visible = false; } } } } } }
public DataTable GetData() { //string idemp; //idemp = (string)(Session["EmpleadoID[]"]); //for (int i = 0; i < idemp.Length; i++) //{ String idOrganizationEBS = lista_depto.SelectedValue.ToString(); TablaEmpleados empleadosEbs = new TablaEmpleados(); DataTable table = empleadosEbs.empleadoxdepto(idOrganizationEBS); DataTable dt = new DataTable(); // DataTable table = GetTable(); // Get the data table. Recorro el array para sacar todos los empleados foreach (DataRow row in table.Rows) // Loop over the rows. { // Console.WriteLine("--- Row ---"); // Print separator. foreach (var item in row.ItemArray) // Loop over the items. { //Console.Write("Item: "); // Print label. // Console.WriteLine(item); // Invokes ToString abstract method. string connectionString = ConfigurationManager.ConnectionStrings["conexionAPPS"].ConnectionString; //guardo los valores del empleado using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand("SELECT { fn IFNULL(MAX(c.id_eva), 0) } AS id_eva, { fn IFNULL(SUM(d.calificacion_val_jefe),0) } AS total_puntaje " + "FROM EVA_C_EVALUACION as c, EVA_D_EVALUACION as d, EVA_PLANTILLAS as p " + "WHERE (c.id_emp IN ('" + item + "')) and c.estatus='2' and p.vigencia_plant='1' and p.id_plantilla=d.id_plantilla " + "and c.id_eva=d.id_eva ", connection)) { connection.Open(); using (SqlDataReader dr = command.ExecuteReader()) { if (dr.HasRows) { dt.Load(dr); } } } } } } //} return dt; }
protected void Button1_Click(object sender, System.EventArgs e) { MensajeError(string.Empty); MensajeExito(string.Empty); //int graba = 1; String idEmpleadoJDE = lista_empleados.SelectedValue.ToString(); opcestatus.Visible = true; //para banda estrategica osea directores if (id_categoria.Text == "A1" || id_categoria.Text == "A2") { opcestatus.Visible = true; //================================================================================================================================== panel1.Visible = true; botonExportar.Visible = true; botonExportar.Visible = false; if ((lista_empleados.SelectedValue.ToString() == "0")) { //MensajeError("Debes de Seleccionar el Departamento"); panel1.Visible = false; //panel2.Visible = false; botonExportar.Visible = false; return; } //else //{ String idOrganizationEBS = lista_empleados.SelectedValue.ToString(); TablaEmpleados empleadosEbs = new TablaEmpleados(); DataTable table = empleadosEbs.empleadoxdepto(idOrganizationEBS); if (table == null) { MensajeError("Null empleadoxdepto"); return; } gridBuscar.DataSource = table; gridBuscar.DataBind(); //panel2.Visible = true; int contadorpos; //panel3.Visible = true; //panel2.Visible = true; //string idplantilla; //---BORRO la CONSULTA ANTERIOR usuario.Text = (string)(Session["Nombre"]); empcritico.Text = ""; empnec.Text = ""; empreconocer.Text = ""; empretener.Text = ""; //saco la plantillas using (SqlConnection cnx = new SqlConnection(connectionString)) { cnx.Open(); string query = "SELECT id_plantilla FROM EVA_PLANTILLAS WHERE (vigencia_plant = '1')"; SqlCommand cmd = new SqlCommand(query, cnx); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { idplantilla.Text = dr["id_plantilla"].ToString(); } } else { idplantilla.Text = "No se encontro plantilla autorizada"; } } // cierre de la conn DataTable dt = new DataTable(); TablaEmpleados empleadosEbs2 = new TablaEmpleados(); DataTable table2 = empleadosEbs2.empleadoxdeptoID(idOrganizationEBS); if (table2 != null) { foreach (DataRow row in table2.Rows) // Loop over the rows. { foreach (var item in row.ItemArray) // Loop over the items. { using (SqlConnection cnx = new SqlConnection(connectionString)) { cnx.Open(); string query = " select count(c.id_eva) as total, c.id_eva " + " from EVA_C_EVALUACION as c, EVA_D_EVALUACION as d " + " where c.id_emp='" + item + "' and c.estatus='2' and c.id_eva=d.id_eva and d.id_plantilla='" + idplantilla.Text + "' " + " group by c.id_eva "; SqlCommand cmd = new SqlCommand(query, cnx); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { evaluacionid.Text = dr["id_eva"].ToString(); } } else { evaluacionid.Text = "0"; } } // cierre de la conn if (evaluacionid.Text != "0") { using (SqlConnection cnx = new SqlConnection(connectionString)) { // estatus=2 cuando la evaluacion ha sido liberada por jefe inmediato cnx.Open(); string query = " select {fn IFNULL(SUM(calificacion_val_jefe),0)} AS total_puntaje_valores " + " from EVA_C_EVALUACION as e, EVA_D_EVALUACION as d " + " where e.id_eva='" + evaluacionid.Text + "' and e.estatus='2' and d.id_plantilla='" + idplantilla.Text + "' and e.id_eva=d.id_eva "; SqlCommand cmd = new SqlCommand(query, cnx); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { total_valores.Text = dr["total_puntaje_valores"].ToString(); } } else { total_valores.Text = "0"; } } // cierre de la conn if (total_valores.Text != "0") { using (SqlConnection cnx = new SqlConnection(connectionString)) { cnx.Open(); string query = " select {fn IFNULL(SUM(ponderacion_ind_jefe),0)} AS total_puntaje_indicadores " + " from EVA_C_EVALUACION as e, EVA_D_INDICADORES as d " + " where e.id_eva='" + evaluacionid.Text + "' and e.estatus='2' and d.id_plantilla='" + idplantilla.Text + "' " + " and e.id_eva=d.id_eva "; SqlCommand cmd = new SqlCommand(query, cnx); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { total_valores_ind.Text = dr["total_puntaje_indicadores"].ToString(); } } else { total_valores_ind.Text = "No se encontro puntaje indicadores"; } } // cierre de la conn // para sacar la calificacion en Letra using (SqlConnection cnx = new SqlConnection(connectionString)) { cnx.Open(); string query2 = " SELECT ponderacion_kpi, calificacion_kpi, descripcion_kpi " + " FROM EVA_C_CALIFICACION_KPI " + " WHERE ponderacion_kpi <= '" + total_valores_ind.Text + "' order by 1 "; SqlCommand cmd2 = new SqlCommand(query2, cnx); SqlDataReader dr2 = cmd2.ExecuteReader(); if (dr2.HasRows) { while (dr2.Read()) { cal_indicador.Text = dr2["calificacion_kpi"].ToString(); } } else { //MensajeError("No se encontro Calificacion"); return; } } // cierre de la conn } } } } } else { MensajeError("Null -empleadoxdeptoID"); return; } //===============================================================================================================HASTA AQUI } else { opcestatus.Visible = false; } }