public void CargarTablas() { BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo Order By Categoria Desc, Nombre;"); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ActAuto aa where g.Id = aa.IdAutor and aa.IdAct = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ActFuen af where g.Id = af.IdFuen and af.IdAct = " + Id + " Order By Categoria Desc, Nombre;"); }
public void Cargar(int id) { DataRow Requisito = ClsBaseDatos.BDTable("Select * from ReqNFunc where Id = " + id + ";").Rows[0]; Id = int.Parse(Requisito[0].ToString()); Nombre = Requisito[1].ToString(); Version = (double)Requisito[2]; Fecha = (DateTime)Requisito[3]; Descripcion = Requisito[4].ToString(); Prioridad = int.Parse(Requisito[5].ToString()); Urgencia = int.Parse(Requisito[6].ToString()); Estabilidad = int.Parse(Requisito[7].ToString()); Estado = ((int)Requisito[8] == 1) ? true : false; Categoria = int.Parse(Requisito[9].ToString()); Comentario = Requisito[10].ToString(); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqNAuto r where g.Id = r.IdAutor and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqNFuen r where g.Id = r.IdFuen and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Objetivos = ClsBaseDatos.BDTable("Select o.Id as Id, o.Nombre as Nombre from Objetivos o, ReqNObj r where o.Id = r.IdObj and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Requisitos = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqNFunc rn, ReqNReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqInfo + " Order By Categoria Desc, Nombre;"); Requisitos.Rows.Clear(); DataTable TablaAux; TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqInfo rn, ReqNReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqInfo + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux); TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqNFunc rn, ReqNReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqNFun + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux); TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqFun rn, ReqNReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqFun + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux); BObjetivos = ClsBaseDatos.BDTable("Select Id,Nombre from Objetivos where Id not IN (select idObj from ReqNObj where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdAutor from ReqNAuto where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdFuen from ReqNFuen where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); }
public void Cargar(int id) { DataRow Requisito = ClsBaseDatos.BDTable("Select * from ReqFun where Id = " + id + ";").Rows[0]; Id = int.Parse(Requisito[0].ToString()); Nombre = Requisito[1].ToString(); Version = (double)Requisito[2]; Fecha = (DateTime)Requisito[3]; Descripcion = Requisito[4].ToString(); Paquete = ClsBaseDatos.BDString("Select Nombre from Paquetes where Id = " + Requisito[5].ToString() + ";"); Precondicion = Requisito[6].ToString(); Postcondicion = Requisito[7].ToString(); Complejidad = int.Parse(Requisito[8].ToString()); Prioridad = int.Parse(Requisito[9].ToString()); Urgencia = int.Parse(Requisito[10].ToString()); Estabilidad = int.Parse(Requisito[11].ToString()); Estado = ((int)Requisito[12] == 1) ? true : false; Categoria = int.Parse(Requisito[13].ToString()); Comentario = Requisito[14].ToString(); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqAuto r where g.Id = r.IdAutor and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqFuen r where g.Id = r.IdFuen and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Objetivos = ClsBaseDatos.BDTable("Select o.Id as Id, o.Nombre as Nombre from Objetivos o, ReqObj r where o.Id = r.IdObj and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Actores = ClsBaseDatos.BDTable("Select a.Id as Id, a.Nombre as Nombre from Actores a, ReqAct r where a.Id = r.IdAct and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Requisitos = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqFun rn, ReqReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqInfo + " Order By Categoria Desc, Nombre;"); DataTable TablaAux; DataRow Fila; SecNormal.Clear(); SecExcepc.Clear(); TablaAux = ClsBaseDatos.BDTable("Select Descrip from ReqSecNor where IdReq = " + Id + ";"); for (int i = 0; i <= (TablaAux.Rows.Count - 1); i++) { Fila = TablaAux.Rows[i]; SecNormal.Add(new ClsDatDG() { Descrip = Fila[0].ToString() }); } TablaAux = ClsBaseDatos.BDTable("Select Descrip from ReqSecExc where IdReq = " + Id + ";"); for (int i = 0; i <= (TablaAux.Rows.Count - 1); i++) { Fila = TablaAux.Rows[i]; SecExcepc.Add(new ClsDatDG() { Descrip = Fila[0].ToString() }); } Requisitos.Rows.Clear(); TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqInfo rn, ReqReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqInfo + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux); TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqNFunc rn, ReqReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqNFun + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux); TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqFun rn, ReqReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqFun + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux); BObjetivos = ClsBaseDatos.BDTable("Select Id,Nombre from Objetivos where Id not IN (select idObj from ReqObj where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdAutor from ReqAuto where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdFuen from ReqFuen where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); BActores = ClsBaseDatos.BDTable("Select Id,Nombre from Actores where Id not IN (select IdAct from ReqAct where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); }
public void CargarTablas() { BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo Order By Categoria Desc, Nombre;"); BObjetivos = ClsBaseDatos.BDTable("Select Id,Nombre from Objetivos Order By Categoria Desc, Nombre;"); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ObjAuto oa where g.Id = oa.IdAutor and oa.IdObj = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ObjFuen obf where g.Id = obf.IdFuen and obf.IdObj = " + Id + " Order By Categoria Desc, Nombre;"); Objetivos = ClsBaseDatos.BDTable("Select o.Id as Id, o.Nombre as Nombre from Objetivos o, ObjSubobj os where o.Id = os.IdSubobj and os.IdObj = " + Id + " Order By Categoria Desc, Nombre;"); }
public void Cargar(int id) { DataRow Paquete = ClsBaseDatos.BDTable("Select * from Paquetes where Id = " + id + ";").Rows[0]; Id = int.Parse(Paquete[0].ToString()); Nombre = Paquete[1].ToString(); Version = (double)Paquete[2]; Fecha = (DateTime)Paquete[3]; Categoria = int.Parse(Paquete[4].ToString()); Comentario = Paquete[5].ToString(); }
public void CargarTablas() { BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo Order By Categoria Desc, Nombre;"); BObjetivos = ClsBaseDatos.BDTable("Select Id,Nombre from Objetivos Order By Categoria Desc, Nombre;"); BRequisitos = ClsBaseDatos.BDTable("Select Id,Nombre from ReqFun Order By Categoria Desc, Nombre;"); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqNAuto r where g.Id = r.IdAutor and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqNFuen r where g.Id = r.IdFuen and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Objetivos = ClsBaseDatos.BDTable("Select o.Id as Id, o.Nombre as Nombre from Objetivos o, ReqNObj r where o.Id = r.IdObj and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Requisitos = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqNFunc rn, ReqNReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); }
public void Cargar(int id) { DataRow Trabajador = ClsBaseDatos.BDTable("Select * from Grupo where Id = " + id + ";").Rows[0]; Id = int.Parse(Trabajador[0].ToString()); Nombre = Trabajador[1].ToString(); Version = (double)Trabajador[2]; Fecha = (DateTime)Trabajador[3]; Organizacion = Trabajador[4].ToString(); Rol = Trabajador[5].ToString(); Desarrollador = ((int)Trabajador[6] == 1) ? true : false; Categoria = int.Parse(Trabajador[7].ToString()); Comentario = Trabajador[8].ToString(); }
public void CargarTablaReqRel(int TipoReq) { if (TipoReq == DefValues.ReqInfo) { BRequisitos = ClsBaseDatos.BDTable("Select Id,Nombre from ReqInfo where Id not IN (select IdReqr from ReqIReqR where idReq = " + Id + " and TipoReq = " + DefValues.ReqInfo + ") and Id <> " + Id + " Order By Categoria Desc, Nombre;"); } else if (TipoReq == DefValues.ReqNFun) { BRequisitos = ClsBaseDatos.BDTable("Select Id,Nombre from ReqNFunc where Id not IN (select IdReqr from ReqIReqR where idReq = " + Id + " and TipoReq = " + DefValues.ReqNFun + ") Order By Categoria Desc, Nombre;"); } else if (TipoReq == DefValues.ReqFun) { BRequisitos = ClsBaseDatos.BDTable("Select Id,Nombre from ReqFun where Id not IN (select IdReqr from ReqIReqR where idReq = " + Id + " and TipoReq = " + DefValues.ReqFun + ") Order By Categoria Desc, Nombre;"); } }
public void Cargar(int id) { DataRow Actor = ClsBaseDatos.BDTable("Select * from Actores where Id = " + id + ";").Rows[0]; Id = int.Parse(Actor[0].ToString()); Nombre = Actor[1].ToString(); Version = (double)Actor[2]; Fecha = (DateTime)Actor[3]; Descripcion = Actor[4].ToString(); Complejidad = int.Parse(Actor[5].ToString()); DescComplejidad = Actor[6].ToString(); Categoria = int.Parse(Actor[7].ToString()); Comentario = Actor[8].ToString(); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ActAuto aa where g.Id = aa.IdAutor and aa.IdAct = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ActFuen af where g.Id = af.IdFuen and af.IdAct = " + Id + " Order By Categoria Desc, Nombre;"); BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdAutor from ActAuto where idAct = " + Id + ") Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdFuen from ActFuen where idAct = " + Id + ") Order By Categoria Desc, Nombre;"); }
public void Cargar(int id) { DataRow Objetivo = ClsBaseDatos.BDTable("Select * from Objetivos where Id = " + id + ";").Rows[0]; Id = int.Parse(Objetivo[0].ToString()); Nombre = Objetivo[1].ToString(); Version = (double)Objetivo[2]; Fecha = (DateTime)Objetivo[3]; Descripcion = Objetivo[4].ToString(); Prioridad = int.Parse(Objetivo[5].ToString()); Urgencia = int.Parse(Objetivo[6].ToString()); Estabilidad = int.Parse(Objetivo[7].ToString()); Estado = ((int)Objetivo[8] == 1) ? true : false; Categoria = int.Parse(Objetivo[9].ToString()); Comentario = Objetivo[10].ToString(); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ObjAuto oa where g.Id = oa.IdAutor and oa.IdObj = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ObjFuen obf where g.Id = obf.IdFuen and obf.IdObj = " + Id + " Order By Categoria Desc, Nombre;"); Objetivos = ClsBaseDatos.BDTable("Select o.Id as Id, o.Nombre as Nombre from Objetivos o, ObjSubobj os where o.Id = os.IdSubObj and os.IdObj = " + Id + " Order By Categoria Desc, Nombre;"); BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdAutor from ObjAuto where idObj = " + Id + ") Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdFuen from ObjFuen where idObj = " + Id + ") Order By Categoria Desc, Nombre;"); BObjetivos = ClsBaseDatos.BDTable("Select Id,Nombre from Objetivos where Id not IN (select idSubobj from ObjSubobj where idObj = " + Id + ") and Id <> " + Id + " Order By Categoria Desc, Nombre;"); }
public void Buscar(string valor) { Buscador = ClsBaseDatos.BDTable("Select Nombre,Id from Grupo where Nombre LIKE '%" + valor + "%' Order By Categoria Desc, Nombre;"); }
public void Buscar(string valor) { Buscador = ClsBaseDatos.BDTable("Select Nombre,Id from Paquetes where Nombre LIKE '%" + valor + "%' and Nombre <> 'No Asignado' Order By Categoria Desc, Nombre;"); }