//Ya funciona public void cambiarRol(string correo, int rol) { try { cn = Conexion.conectar(); cmd = new SqlCommand("UPDATE Usuarios SET rol =@rol WHERE correo = @correo", cn.getSqlConnection()); cmd.Parameters.AddWithValue("@rol", rol); cmd.Parameters.AddWithValue("@correo", correo); cmd.ExecuteNonQuery(); MessageBox.Show("Se cambio el rol de: " + correo); } catch (SqlException sqe) { MessageBox.Show("no se logro cambiar el rol del usuario por: " + sqe.ToString()); } catch (Exception ex) { MessageBox.Show("no se logro cambiar el rol del usuario por: " + ex.ToString()); } finally { cn.finalizar(); } }
protected void Button1_Click(object sender, EventArgs e) { int idProy, idCate, idPrio, idEstado; Proyecto p = new Proyecto(); idProy = p.ObtenerId(DropDownList1.Text); idCate = Int32.Parse(DropDownList2.Text); idEstado = Int32.Parse(DropDownList3.Text); idPrio = Int32.Parse(DropDownList4.Text); if (RadioButton1.Checked && RadioButton2.Checked && RadioButton3.Checked) { cn = Conexion.conectar(); cmd = new SqlCommand("Select C.titulo, C.fechaLimite, C.fechaEntrega , C.avance, C.descripcionCaso From Caso as C Where C.proyectoId = @id AND C.estado = @estado AND C.situacion = @situacion AND C.categoria = @categoria", cn.getSqlConnection()); cmd.Parameters.AddWithValue("@id", idProy); cmd.Parameters.AddWithValue("@estado", idEstado); cmd.Parameters.AddWithValue("@situacion", idPrio); cmd.Parameters.AddWithValue("@categoria", idCate); sda = new SqlDataAdapter(cmd); sda.Fill(tblData); GridView1.DataSource = (tblData); GridView1.DataBind(); } else if (RadioButton1.Checked && RadioButton2.Checked)//Categoria y estado { cn = Conexion.conectar(); cmd = new SqlCommand("Select C.titulo, C.fechaLimite, C.fechaEntrega , C.avance, C.descripcionCaso " + " From Caso as C Where C.proyectoId = @id AND C.categoria = @categoria AND C.estado = @estado", cn.getSqlConnection()); cmd.Parameters.AddWithValue("@id", idProy); cmd.Parameters.AddWithValue("@categoria", idCate); cmd.Parameters.AddWithValue("@estado", idEstado); sda = new SqlDataAdapter(cmd); sda.Fill(tblData); GridView1.DataSource = (tblData); GridView1.DataBind(); } else if (RadioButton1.Checked && RadioButton3.Checked)//Categoria y situacion { cn = Conexion.conectar(); cmd = new SqlCommand("Select C.titulo, C.fechaLimite, C.fechaEntrega , C.avance, C.descripcionCaso " + " From Caso as C Where C.proyectoId = @id AND C.categoria = @categoria AND C.situacion = @situacion", cn.getSqlConnection()); cmd.Parameters.AddWithValue("@id", idProy); cmd.Parameters.AddWithValue("@categoria", idCate); cmd.Parameters.AddWithValue("@situacion", idPrio); sda = new SqlDataAdapter(cmd); sda.Fill(tblData); GridView1.DataSource = (tblData); GridView1.DataBind(); } else if (RadioButton2.Checked && RadioButton3.Checked)//Estado y situacion { cn = Conexion.conectar(); cmd = new SqlCommand("Select C.titulo, C.fechaLimite, C.fechaEntrega , C.avance, C.descripcionCaso " + " From Caso as C Where C.proyectoId = @id AND C.situacion = @situacion AND C.estado = @estado", cn.getSqlConnection()); cmd.Parameters.AddWithValue("@id", idProy); cmd.Parameters.AddWithValue("@situacion", idPrio); cmd.Parameters.AddWithValue("@estado", idEstado); sda = new SqlDataAdapter(cmd); sda.Fill(tblData); GridView1.DataSource = (tblData); GridView1.DataBind(); } else if (RadioButton1.Checked)//Solo categoria { cn = Conexion.conectar(); cmd = new SqlCommand("Select C.titulo, C.fechaLimite, C.fechaEntrega , C.avance, C.descripcionCaso " + " From Caso as C Where C.proyectoId = @id AND C.categoria = @categoria", cn.getSqlConnection()); cmd.Parameters.AddWithValue("@id", idProy); cmd.Parameters.AddWithValue("@categoria", idCate); sda = new SqlDataAdapter(cmd); sda.Fill(tblData); GridView1.DataSource = (tblData); GridView1.DataBind(); } else if (RadioButton2.Checked)//Solo estado { cn = Conexion.conectar(); cmd = new SqlCommand("Select C.titulo, C.fechaLimite, C.fechaEntrega , C.avance, C.descripcionCaso " + " From Caso as C Where C.proyectoId = @id AND C.estado = @estado", cn.getSqlConnection()); cmd.Parameters.AddWithValue("@id", idProy); cmd.Parameters.AddWithValue("@estado", idEstado); sda = new SqlDataAdapter(cmd); sda.Fill(tblData); GridView1.DataSource = (tblData); GridView1.DataBind(); } else if (RadioButton3.Checked)//Solo situacion { cn = Conexion.conectar(); cmd = new SqlCommand("Select C.titulo, C.fechaLimite, C.fechaEntrega , C.avance, C.descripcionCaso " + " From Caso as C Where C.proyectoId = @id AND C.situacion = @situacion", cn.getSqlConnection()); cmd.Parameters.AddWithValue("@id", idProy); cmd.Parameters.AddWithValue("@situacion", idPrio); sda = new SqlDataAdapter(cmd); sda.Fill(tblData); GridView1.DataSource = (tblData); GridView1.DataBind(); } else { cn = Conexion.conectar(); cmd = new SqlCommand("Select C.titulo, C.fechaLimite, C.fechaEntrega , C.avance, C.descripcionCaso " + " From Caso as C Where C.proyectoId = @id", cn.getSqlConnection()); cmd.Parameters.AddWithValue("@id", idProy); sda = new SqlDataAdapter(cmd); sda.Fill(tblData); GridView1.DataSource = (tblData); GridView1.DataBind(); } }
protected void Button1_Click(object sender, EventArgs e) { //Proyecto p = new Proyecto(); //int proId = p.ObtenerId(DropDownList1.Text); Caso c = new _IPC2_Proyecto2.Caso(); ArrayList carga = new ArrayList(); carga = c.datosCompletosdeCaso(DropDownList1.Text); cn = Conexion.conectar(); cmd = new SqlCommand("SELECT * FROM Caso Where titulo ='" + DropDownList1.Text + "'", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData); GridView1.DataSource = (tblData); GridView1.DataBind(); cn.finalizar(); int i = 0; foreach (string item in carga) { switch (i) { case 2: //Creador cn = Conexion.conectar(); cmd = new SqlCommand("SELECT * FROM Usuarios Where idUsuario ='" + item + "'", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData1); GridView2.DataSource = (tblData1); GridView2.DataBind(); break; case 3: //Datos Proyecto cn = Conexion.conectar(); cmd = new SqlCommand("SELECT * FROM Proyectos Where idProyecto ='" + item + "'", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData2); GridView3.DataSource = (tblData2); GridView3.DataBind(); break; case 6: //Datos del editor cn = Conexion.conectar(); cmd = new SqlCommand("SELECT * FROM Usuarios Where idUsuario ='" + item + "'", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData3); GridView4.DataSource = (tblData3); GridView4.DataBind(); break; case 7: //estado cn = Conexion.conectar(); cmd = new SqlCommand("SELECT * FROM Estado Where idEstado ='" + item + "'", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData4); GridView7.DataSource = (tblData4); GridView7.DataBind(); break; case 8: //situacion cn = Conexion.conectar(); cmd = new SqlCommand("SELECT * FROM Situacion Where idSituacion ='" + item + "'", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData5); GridView8.DataSource = (tblData5); GridView8.DataBind(); break; case 9: //Categoria cn = Conexion.conectar(); cmd = new SqlCommand("SELECT * FROM Categoria Where idCategoria ='" + item + "'", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData6); GridView5.DataSource = (tblData6); GridView5.DataBind(); break; case 10: //Prioridad cn = Conexion.conectar(); cmd = new SqlCommand("SELECT * FROM Prioridad Where idPrioridad ='" + item + "'", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData7); GridView6.DataSource = (tblData7); GridView6.DataBind(); break; } i++; } //Creador //Proyecto //Ultimo Editor //Estado //Situacion //Categoria //Prioridad }
protected void Button1_Click(object sender, EventArgs e) { //--------------------------------BUGS cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Bugs' " + " From Caso " + " Where categoria = 1", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData); GridView1.DataSource = (tblData); GridView1.DataBind(); //--------------------------------Mejoras cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Mejoras' " + " From Caso " + " Where categoria = 2", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData2); GridView2.DataSource = (tblData2); GridView2.DataBind(); //--------------------------------INVESTIGACIONES cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Investigaciones' " + " From Caso " + " Where categoria = 3", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData3); GridView3.DataSource = (tblData3); GridView3.DataBind(); //--------------------------------Actividades cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Actividades' " + " From Caso " + " Where categoria = 4", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData4); GridView4.DataSource = (tblData4); GridView4.DataBind(); //--------------------------------Activos cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos Activos' " + " From Caso " + " Where estado = 1", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData5); GridView5.DataSource = (tblData5); GridView5.DataBind(); //--------------------------------Reactivados cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos Reactivados' " + " From Caso " + " Where estado = 2", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData6); GridView6.DataSource = (tblData6); GridView6.DataBind(); //--------------------------------Cerrados cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos Cerrados' " + " From Caso " + " Where estado = 3", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData7); GridView7.DataSource = (tblData7); GridView7.DataBind(); //--------------------------------Reactivados cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos Resueltos' " + " From Caso " + " Where estado = 4", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData8); GridView8.DataSource = (tblData8); GridView8.DataBind(); //--------------------------------Criticos cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos Criticos' " + " From Caso " + " Where prioridad = 1", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData9); GridView9.DataSource = (tblData9); GridView9.DataBind(); //--------------------------------Deben Arreglarse cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos que Deben Arreglarse' " + " From Caso " + " Where prioridad = 2", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData10); GridView10.DataSource = (tblData10); GridView10.DataBind(); //--------------------------------Arreglarse si hay tiempo cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos que Deben Arreglarse si hay tiempo' " + " From Caso " + " Where prioridad = 3", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData11); GridView11.DataSource = (tblData11); GridView11.DataBind(); //--------------------------------Reactivados cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos que no deben arreglarse' " + " From Caso " + " Where prioridad = 4", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData12); GridView12.DataSource = (tblData12); GridView12.DataBind(); }