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