private void grados_Click(object sender, EventArgs e) { limpiar(); EmpleadoNombre emp = new EmpleadoNombre(con); emp.label1.Visible = false; emp.button1.Text = "Editar"; emp.button2.Visible = false; emp.cbEmpleadoID.Visible = false; emp.ShowDialog(); int id_eval = emp.id_eval; limpiar(); if (emp.exiting) { return; } EditarGrados gr = new EditarGrados(con, id_eval); tabStrip1.MdiForm = this; gr.MdiParent = this; gr.Show(); //gr.ShowDialog(); }
private void Evaluador_Load(object sender, EventArgs e) { if (id.Equals("")) { EmpleadoNombre en = new EmpleadoNombre(con); en.ShowDialog(); shouldExit = en.exiting; if (en.exiting) { if (con.State != ConnectionState.Closed) { con.Close(); } return; } id = en.id; id_eval = en.id_eval; } resultadosPorCategoriaTexto = new List <string>(); Fecha.Text = DateTime.Now.ToString(); try { if (con.State != ConnectionState.Open) { con.Open(); } DataTable dt = new DataTable();//casi para el final la usamos string n_gen = ""; //Loaders loadFirstDataSets(); //cargando otros datos loadDataTableTre(); loadCosmeticDetails(); dt = loadSecondPart(dt); //Another load loadCheckBeforeDataGrid(dt, n_gen); //=========CHECKBOX loadCheckDataGrid(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (con.State != ConnectionState.Closed) { con.Close(); } } }
private void Evaluador_Load(object sender, EventArgs e) { if (id.Equals("")) { EmpleadoNombre en = new EmpleadoNombre(con); en.ShowDialog(); shouldExit = en.exiting; if (en.exiting) { if (con.State != ConnectionState.Closed) con.Close(); return; } id = en.id; id_eval = en.id_eval; } resultadosPorCategoriaTexto = new List<string>(); Fecha.Text = DateTime.Now.ToString(); try { if (con.State != ConnectionState.Open) con.Open(); DataTable dt = new DataTable();//casi para el final la usamos string n_gen = ""; //Loaders loadFirstDataSets(); //cargando otros datos loadDataTableTre(); loadCosmeticDetails(); dt = loadSecondPart(dt); //Another load loadCheckBeforeDataGrid(dt, n_gen); //=========CHECKBOX loadCheckDataGrid(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (con.State != ConnectionState.Closed) con.Close(); } }
private void indiadores_Click(object sender, EventArgs e) { limpiar(); EmpleadoNombre emp = new EmpleadoNombre(con); emp.label1.Visible = false; emp.button1.Visible = false; emp.cbEmpleadoID.Visible = false; emp.ShowDialog(); int id_eval = emp.id_eval; limpiar(); if (emp.exiting) return; Editar_Indicadores ei = new Editar_Indicadores(con, id_eval); tabStrip1.MdiForm = this; ei.MdiParent = this; ei.Show(); }
private void indiadores_Click(object sender, EventArgs e) { limpiar(); EmpleadoNombre emp = new EmpleadoNombre(con); emp.label1.Visible = false; emp.button1.Visible = false; emp.cbEmpleadoID.Visible = false; emp.ShowDialog(); int id_eval = emp.id_eval; limpiar(); if (emp.exiting) { return; } Editar_Indicadores ei = new Editar_Indicadores(con, id_eval); tabStrip1.MdiForm = this; ei.MdiParent = this; ei.Show(); }
private void Evaluador_Load(object sender, EventArgs e) { EmpleadoNombre en = new EmpleadoNombre(con); List<string> bloquear = new List<string>(); en.ShowDialog(); shouldExit = en.exiting; if (en.exiting) { if (con.State != ConnectionState.Closed) con.Close(); return; } id = en.id; id_eval = en.id_eval; resultadosPorCategoriaTexto = new List<string>(); Fecha.Text = DateTime.Now.ToString(); try { if (con.State != ConnectionState.Open) con.Open(); DataTable dt1 = new DataTable(); SqlCommand cmd1 = new SqlCommand(); cmd1.Connection = con; cmd1.CommandType = System.Data.CommandType.Text; cmd1.CommandText = "SELECT CONCAT(NOMBRES,' ',APELLIDOS) FROM EMPLEADOS WHERE ID_EMPLEADO = " + this.id; SqlDataAdapter da1 = new SqlDataAdapter(cmd1); DataSet ds1 = new DataSet(); da1.Fill(ds1); dt1 = ds1.Tables[0]; DataTable dt3 = new DataTable(); SqlCommand cmd3 = new SqlCommand(); cmd3.Connection = con; cmd3.CommandType = System.Data.CommandType.Text; cmd3.CommandText = "select g.NOMBRE,I.NOMBRE as n from INDICADORES I INNER JOIN GRADOS g on I.ID_IND = g.ID_IND WHERE I.ID = " + id_eval; SqlDataAdapter da3 = new SqlDataAdapter(cmd3); DataSet ds3 = new DataSet(); da3.Fill(ds3); dt3 = ds3.Tables[0]; gradosesp = dt3; dataGridView1.Columns.Add("Indicadores", "Indicadores"); for (int i = 0; i < dt3.Rows.Count; i++) { if (cols.Count == 0) cols.Add(dt3.Rows[0][0].ToString()); else for (int j = 0; j < cols.Count; j++) { if (cols.ElementAt(j) == dt3.Rows[i][0].ToString()) break; if (cols.ElementAt(j) != dt3.Rows[i][0].ToString() && j == cols.Count - 1) cols.Add(dt3.Rows[i][0].ToString()); } } DataGridViewComboBoxColumn cmb = new DataGridViewComboBoxColumn(); cmb.HeaderText = "Grado"; cmb.Name = "Grado"; dataGridView1.Columns.Add(cmb); //Buscar el nombre en la base de datos, ya tenemos el ID label2.Text = id; Nombre.Text = dt1.Rows[0][0].ToString(); //cargar de la base de datos los indicadores y los grados!! //Temporal, solo como ejemplo dataGridView1.ColumnHeadersVisible = true; DataGridViewCellStyle columnHeaderStyle = new DataGridViewCellStyle(); columnHeaderStyle.BackColor = Color.Beige; columnHeaderStyle.Font = new System.Drawing.Font("Verdana", 10, FontStyle.Bold); dataGridView1.ColumnHeadersDefaultCellStyle = columnHeaderStyle; DataTable dt = new DataTable(); SqlCommand cmd2 = new SqlCommand(); cmd2.Connection = con; cmd2.CommandType = System.Data.CommandType.Text; cmd2.CommandText = "SELECT I.NOMBRE,I.PESO, IE.NOMBRE, IE.PESO,I.ID_IND,IE.ID_IND from INDICADORES I INNER JOIN INDICADORES IE ON I.ID_IND = IE.ID_GEN WHERE I.ID = " + id_eval; SqlDataAdapter da = new SqlDataAdapter(cmd2); DataSet ds = new DataSet(); da.Fill(ds); dt = ds.Tables[0]; string n_gen = ""; DataGridViewComboBoxCell cell = new DataGridViewComboBoxCell(); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i][0].ToString() != n_gen) { n_gen = dt.Rows[i][0].ToString(); bloquear.Add(n_gen); dataGridView1.Rows.Add(); dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells["Indicadores"].Value = n_gen; indicadores.Add(new Indicadores_Arr(n_gen, float.Parse(dt.Rows[i][1].ToString()), int.Parse(dt.Rows[i][4].ToString()), null)); } //ver aca if (dt.Rows[i][0].ToString() == n_gen) { dataGridView1.Rows.Add(); dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells["Indicadores"].Value = " ---" + dt.Rows[i][2].ToString(); cell = new DataGridViewComboBoxCell(); for (int l = 0; l < gradosesp.Rows.Count; l++) { if (dt.Rows[i][2].ToString() == gradosesp.Rows[l][1].ToString()) { cell.Items.Add(gradosesp.Rows[l][0].ToString()); } } dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells["Grado"] = cell; indicadores.ElementAt(indicadores.Count - 1).IndicadoresEspecificos.Add(new Indicadores_Arr(dt.Rows[i][2].ToString(), float.Parse(dt.Rows[i][3].ToString()), int.Parse(dt.Rows[i][4].ToString()), null)); } } //========= CHECKBOX DataTable dt4 = new DataTable(); SqlCommand cmd4 = new SqlCommand(); cmd4.Connection = con; cmd4.CommandType = System.Data.CommandType.Text; cmd4.CommandText = "SELECT NOMBRE FROM GRADOS WHERE ID_IND= (SELECT TOP 1 ID_IND FROM INDICADORES WHERE ID='" + id_eval + "' AND ID_GEN IS NULL)"; SqlDataAdapter da4 = new SqlDataAdapter(cmd4); DataSet ds4 = new DataSet(); da4.Fill(ds4); dt4 = ds4.Tables[0]; for (int i = 0; i < dt4.Rows.Count; i++) { DataGridViewCheckBoxColumn col = new DataGridViewCheckBoxColumn(); col.Name = dt4.Rows[i][0].ToString(); col.DataPropertyName = dt4.Rows[i][0].ToString(); col.HeaderText = dt4.Rows[i][0].ToString(); dataGridView1.Columns.Add(col); } for (int i = 0; i < bloquear.Count; i++) { for (int x = 0; x < dataGridView1.Rows.Count - 1; x++) { if (dataGridView1.Rows[x].Cells[0].Value.Equals(bloquear.ElementAt(i))) { for (int c = 2; c < dataGridView1.Columns.Count; c++) { dataGridView1.Rows[x].Cells[c] = new DataGridViewTextBoxCell(); dataGridView1.Rows[x].Cells[c].ReadOnly = true; } break; } } } for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { resultadosPorCategoriaTexto.Add(dataGridView1.Rows[i].Cells[0].Value.ToString()); if (dataGridView1.Rows[i].Cells[0].Value.ToString().Contains("---")) { DataGridViewComboBoxCell cb = (DataGridViewComboBoxCell)dataGridView1.Rows[i].Cells[1]; int k = 0; for (int h = 2; h < dataGridView1.Columns.Count; h++) { DataGridViewCheckBoxCell cellbox = (DataGridViewCheckBoxCell)dataGridView1.Rows[i].Cells[h]; if ( cb.Items[k].ToString() != dataGridView1.Columns[h].HeaderText) { dataGridView1.Rows[i].Cells[h] = new DataGridViewTextBoxCell(); dataGridView1.Rows[i].Cells[h].ReadOnly = true; //cellbox.ReadOnly = true; } else { cellbox.ReadOnly = false; if (k < cb.Items.Count - 1) k++; } } } } dataGridView1.Columns[1].Visible = false; for (int i = 0; i < dataGridView1.Columns.Count; i++) { dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[i] = new DataGridViewTextBoxCell(); dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[i].ReadOnly = true; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (con.State != ConnectionState.Closed) con.Close(); } }
private void grados_Click(object sender, EventArgs e) { limpiar(); EmpleadoNombre emp = new EmpleadoNombre(con); emp.label1.Visible = false; emp.cbEmpleadoID.Visible = false; emp.ShowDialog(); int id_eval = emp.id_eval; limpiar(); if (emp.exiting) return; EditarGrados gr = new EditarGrados(con, id_eval); tabStrip1.MdiForm = this; gr.MdiParent = this; gr.Show(); //gr.ShowDialog(); }